|
数据库应用
系统设计目标
随着经济的发展,企业正向着大型化、规模化的方向发展,企业职员数量急剧增加,有关职员的各种信息量也成倍增长。在这种情况下单靠人工来处理职员的信息,工作量将很大,若公司人员有几万甚至几十万,人工处理将变得不可想象。用计算机可使人们从繁重的劳动中解脱出来,仅使用一些简单的操作便可及时、准确地获得需要的信息。
该系统的具体任务就是设计一个企业职员信息管理系统,由计算机来代替人工执行一系列诸如增加新进职员信息、变更职员信息、删除离职职员信息、查询及打印等操作。这样就使办公人员可以轻松快捷地完成职员信息管理的任务,使企业的职员管理工作系统化、规范化、自动化,从而达到提高企业管理效率的目的。
设计的指导思想是一切为用户着想,界面要美观大方,操作尽量简单明了,而且作为一个实用的应用程序要有良好的容错性,在用户出现误操作时能尽量及时地给出警告,以便用户及时改正。
开发和运行环境
开发工具:visual foxpro 6.0
运行环境:windows 9x 、windows 2000、windows xp
系统功能
l 系统数据初始化;
l 职员信息数据的增加;
l 职员信息数据的修改;
l 职员信息数据的删除;
l 职员信息的一览和查询;
l 职员信息的报表打印。
系统功能模块结构图
系统采用模块化程序设计方法,既便于系统功能的各种组合和修改,又便于未参与开发的技术维护人员补充、维护。在系统功能分析的基础上,考虑visual foxpro 6.0程序编制的特点,得到如下所示的系统功能模块结构图。
加入 tu 1
<p class="msobodytextindent" style="text-indent:0cm;mso-char-indent-count:0;
mso-char-indent-size:0cm"><span lang="en-us"> <o:p>
</o:p>
</span></p>
<p class="msobodytextindent" style="text-indent:0cm;mso-char-indent-count:0;
mso-char-indent-size:0cm"><span lang="en-us"> <o:p>
</o:p>
</span></p>
<p class="msobodytextindent" align="center" style="text-align:center;text-indent:
0cm;mso-char-indent-count:0;mso-char-indent-size:0cm"><b><span style="font-size:12.0pt;font-family:宋体;mso-ascii-font-family:"times new roman";
mso-hansi-font-family:"times new roman"">职员信息管理系统</span><span lang="en-us" style="font-size:12.0pt"><o:p>
</o:p>
</span></b></p>
<p class="msobodytextindent" style="text-indent:0cm;mso-char-indent-count:0;
mso-char-indent-size:0cm"><!--[if gte vml 1]><v:group id="_x0000_s1026"
style='position:absolute;left:0;text-align:left;margin-left:60.15pt;
margin-top:21.9pt;width:308.85pt;height:391.5pt;z-index:1' coordorigin="3183,5430"
coordsize="6177,7830">
<v:rect id="_x0000_s1027" style='position:absolute;left:4680;top:5430;width:2700;
height:619'>
<v:textbox style='mso-next-textbox:#_x0000_s1027' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msonormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:宋体;mso-ascii-font-family:"times new roman";
mso-hansi-font-family:"times new roman";mso-bidi-font-weight:bold'>主界面</span><span
lang=en-us style='font-size:12.0pt;mso-bidi-font-weight:bold'><o:p></o:p></span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:line id="_x0000_s1028" style='position:absolute' from="6120,6034"
to="6120,6857"/>
<v:line id="_x0000_s1029" style='position:absolute' from="3420,6870" to="9180,6870"/>
<v:line id="_x0000_s1030" style='position:absolute' from="3380,6857" to="3380,7681"/>
<v:line id="_x0000_s1031" style='position:absolute' from="4284,6857" to="4284,7681"/>
<v:line id="_x0000_s1032" style='position:absolute' from="5184,6857" to="5184,7681"/>
<v:line id="_x0000_s1033" style='position:absolute' from="6318,6857" to="6318,7681"/>
<v:line id="_x0000_s1034" style='position:absolute' from="7746,6857" to="7747,7681"/>
<v:line id="_x0000_s1035" style='position:absolute' from="9129,6839" to="9130,7776"/>
<v:rect id="_x0000_s1036" style='position:absolute;left:3183;top:7681;width:593;
height:1853'>
<v:textbox style='mso-next-textbox:#_x0000_s1036' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext><span style='font-size:12.0pt;font-family:宋体;
mso-ascii-font-family:"times new roman";mso-hansi-font-family:"times new roman"'>增加记录</span><span
lang=en-us style='font-size:12.0pt'><o:p></o:p></span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1037" style='position:absolute;left:4086;top:7701;
width:594;height:1833'>
<v:textbox style='mso-next-textbox:#_x0000_s1037' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext2><span style='font-family:宋体;mso-ascii-font-family:
"times new roman";mso-hansi-font-family:"times new roman"'>修改记录</span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1038" style='position:absolute;left:4986;top:7681;
width:594;height:1853'>
<v:textbox style='mso-next-textbox:#_x0000_s1038' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext2><span style='font-family:宋体;mso-ascii-font-family:
"times new roman";mso-hansi-font-family:"times new roman"'>删除记录</span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1039" style='position:absolute;left:6120;top:7681;
width:594;height:1853'>
<v:textbox style='mso-next-textbox:#_x0000_s1039' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext><span style='font-size:12.0pt;font-family:宋体;
mso-ascii-font-family:"times new roman";mso-hansi-font-family:"times new roman"'>查询</span><span
lang=en-us style='font-size:12.0pt'><o:p></o:p></span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1040" style='position:absolute;left:7513;top:7681;
width:593;height:1853'>
<v:textbox style='mso-next-textbox:#_x0000_s1040' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext2><span style='font-family:宋体;mso-ascii-font-family:
"times new roman";mso-hansi-font-family:"times new roman"'>报表打印</span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1041" style='position:absolute;left:8766;top:7653;
width:594;height:1872'>
<v:textbox style='mso-next-textbox:#_x0000_s1041' inset="7.92pt,3.96pt,7.92pt,3.96pt">
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext2><span style='font-family:宋体;mso-ascii-font-family:
"times new roman";mso-hansi-font-family:"times new roman"'>退出</span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
</v:rect><v:rect id="_x0000_s1042" style='position:absolute;left:7920;top:10461;
width:540;height:1560'>
<v:textbox style='mso-next-textbox:#_x0000_s1042'>
<![if !mso]>
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td><![endif]>
<div>
<p class=msobodytext2><span style='font-family:宋体;mso-ascii-font-family:
"times new roman";mso-hansi-font-family:"times new roman"'>打印预览</span></p>
</div>
<![if !mso]></td>
</tr>
</table>
<![endif]></v:textbox>
是代码.....vfp的 |
|