还剩12页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
《网络协议编程设计C#》实训课程项目报告公司管理系统,自己做的,除了数据库不能发其他源代码都有(实训设计)
一、实训题目公司员工管理系统
二、实训意义通过此次实训,让我们进一步了解c#应用程序__的过程,同时也让我们对前面所学的知识付出实践,达到熟练掌握、综合性应用的目的
三、实训内容
1、项目分析1 员工信息管理2 员工考勤管理
2、项目设计首先,我们必须建立一个登录系统和八个子系统登录系统用户在登陆后可以进行权限操作管理员工信息管理系统对员工信息进行查询、修改、添加、删除员工考勤管理系统对员工考勤信息进行查询、修改、添加、删除使用SQLSERVER2005建立YGGL数据库,其中包括用户表员工信息表员工考勤表
四、项目的实现
1、使用SQL2005创建YGGL数据库
2、分别在SQL2005的YGGL数据库下创建admin表、employee_info表、attendan__表,其代表用户表、员工信息表、员工考勤表1用户信息表CREATETABLE[dbo].[admin][name][varchar]50COLLATEChinese_PRC_CI_ASNOTNULL[pwd][varchar]50COLLATEChinese_PRC_CI_ASNOTNULLON[PRI__RY]GO2员工信息表CREATETABLE[dbo].[employee_info][userid][int]NOTNULL[name][char]10COLLATEChinese_PRC_CI_ASNOTNULL[___][char]10COLLATEChinese_PRC_CI_ASNOTNULL[workyear][varchar]2COLLATEChinese_PRC_CI_ASNULL[phone][varchar]50COLLATEChinese_PRC_CI_ASNULL[addr][varchar]50COLLATEChinese_PRC_CI_ASNULLCONSTRAINT[PK_employeeinfo]PRI__RYKEYCLUSTERED[userid]ASCWITHIGNORE_DUP_KEY=OFFON[PRI__RY]ON[PRI__RY]GO2员工考勤表CREATETABLE[dbo].[attendan__][userid][int]NOTNULL[le__e][int]NULL[tr__el][int]NULL[absent][int]NULLCONSTRAINT[PK_attendan__]PRI__RYKEYCLUSTERED[userid]ASCWITHIGNORE_DUP_KEY=OFFON[PRI__RY]ON[PRI__RY]
3、使用C#进行窗口设计(源代码)1登录系统privatevoidbtnloginOK_Click_1o__ectsenderEventArgse{SqlConnectiondbConnection=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;SqlDataReaderdataReader;stringsqlString=SELECTnamepwdFROMadmin;;stringloginPassWord=;dbConnection.Open;SqlCom__nddbCom__nd=newSqlCom__ndsqlStringdbConnection;dataReader=dbCom__nd.ExecuteReader;try{ifdataReader.HasRows{dataReader.Read;LoginName=dataReader[name].ToString;loginPassWord=dataReader[pwd].ToString;}}catchEx__ptione1{MessageBox.Showe
1.Message登陆出错;}dataReader.Close;ifLoginName==textBox
1.TextloginPassWord==textBox
2.Text{this.Hide;__infrm1=newMain;frm
1.ShowDialog;}else{MessageBox.Show请输入正确的用户名或者__!登陆出错;LoginName=null;}}2员工信息查询系统
①查询privatevoidbtnDe__nd_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;ifrdbid.Checked==true{sda=newSqlDataAdapterselect*fromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsemployee_info;}ifrdbname.Checked==true{sda=newSqlDataAdapterselect*fromemployee_infowherename=conn;ds=newDataSet;sda.Filldsemployee_info;}else{}dataGridView
1.DataSour__=ds.Tables
[0];}3员工考勤管理系统
①查询privatevoidbtnDe__nd1_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromattendan__whereuserid=conn;ds=newDataSet;sda.Filldsattendan__;dataGridView
2.DataSour__=ds.Tables
[0];}
②修改privatevoidbtnDe__nd2_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterupdateattendan__setle__e=tr__el=absent=whereuserid=conn;ds=newDataSet;sda.Filldsattendan__;}4新窗体
①添加窗体usingSystem;usingusingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingusingnamespa__WindowsApplication1{publicpartialclassinsert:Form{publicinsert{InitializeComponent;}privatevoidinsert_Loado__ectsenderEventArgse{}SqlDataAdaptersda;SqlConnectionconn;DataSetds;privatevoidbtnDe__nd5_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterinsertintoemployee_infovaluesconn;ds=newDataSet;sda.Filldsattendan__;}privatevoidbtnresult2_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infoconn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}}}
②修改窗体usingSystem;usingusingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingusingnamespa__WindowsApplication1{publicpartialclassUpdate:Form{publicUpdate{InitializeComponent;}privatevoidUpdate_Loado__ectsenderEventArgse{}privatevoiddataGridView1___llContentClicko__ectsenderDataGridView__llEventArgse{}SqlDataAdaptersda;SqlConnectionconn;DataSetds;privatevoidbtnDe__nd3_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}privatevoidbtnDe__nd4_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterupdateemployee_infosetname=___=workyear=phone=addr=whereuserid=conn;ds=newDataSet;sda.Filldsattendan__;}privatevoidbtnresult1_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}}}
③删除窗体usingSystem;usingusingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingusingnamespa__WindowsApplication1{publicpartialclassdelete:Form{publicdelete{InitializeComponent;}privatevoiddelete_Loado__ectsenderEventArgse{}privatevoiddataGridView1___llContentClicko__ectsenderDataGridView__llEventArgse{}SqlDataAdaptersda;SqlConnectionconn;DataSetds;privatevoidbtnDe__nd6_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}privatevoidbtnDe__nd7_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterdeletefromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsattendan__;}privatevoidbtnDe__nd8_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infoconn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}}}5员工信息管理系统
①修改privatevoidbtnupdate_Clicko__ectsenderEventArgse{Updatefrm2=newUpdate;frm
2.ShowDialog;}privatevoidbtnDe__nd3_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterselect*fromemployee_infowhereuserid=+tconn;ds=newDataSet;sda.Filldsattendan__;dataGridView
1.DataSour__=ds.Tables
[0];}privatevoidbtnDe__nd4_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterupdateemployee_infosetname=___=workyear=phone=addr=whereuserid=conn;ds=newDataSet;sda.Filldsattendan__;}
②添加privatevoidbtninsert_Clicko__ectsenderEventArgse{insertfrm2=newinsert;frm
2.ShowDialog;}privatevoidbtnDe__nd5_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterinsertintoemployee_infovaluesconn;ds=newDataSet;sda.Filldsattendan__;}
③删除privatevoidbutton5_Clicko__ectsenderEventArgse{deletefrm2=newdelete;frm
2.ShowDialog;}privatevoidbtnDe__nd7_Clicko__ectsenderEventArgse{conn=newSqlConnectionserver=.;database=YGGL;uid=sa;pwd=;sda=newSqlDataAdapterdeletefromemployee_infowhereuserid=conn;ds=newDataSet;sda.Filldsattendan__;}
五、小组成员分工陈子宇数据库的建立与连接、员工信息管理中修改、添加、删除模块邬宝国登陆界面、界面美化、员工信息查询与考勤管理的修改模块
六、总结与心得经过两个星期的实训,让我学到了很多关于C#的知识虽然之前老师让我们做过一些练习与调试,但是面对一个整体的系统,我们小组遇到了种种困难首先就是数据库的连接,是我明白了代码的编写决不能出现一丝错误接着就是各个模块的代码与各个控件的使用,终于在同学与老师的帮助下,我对C#有了更加清晰的了解并不断的对员工管理系统进行修改、完善期间使我在理论上对C#有了全新的认识,实践能力上也得到了大幅度的提高,更重要的是让我发现了自己的种种不足,让我学到了课堂上学不到的东西。