C#Windows程序設(shè)計(jì)課程設(shè)計(jì)-人事管理系統(tǒng)

1、河南理工大學(xué)計(jì)算機(jī)科學(xué)與技術(shù)學(xué)院課程設(shè)計(jì)2011 2012學(xué)年 第二學(xué)期課程名稱c#windows程序設(shè)計(jì)課設(shè) 設(shè)計(jì)題目人事管理系統(tǒng)學(xué)生姓名學(xué) 號專業(yè)班級指導(dǎo)教師1設(shè)計(jì)任務(wù)書1.1題目與要求本人計(jì)劃編寫一個(gè)簡單的人事管理系統(tǒng)，主要用來管理員工基本信息 貝體要求如下：1、設(shè)置登陸界而2、主界面;3、員工信息的查詢；4、員工信息的添加；5、員工信息的修改；6、員工信息的刪除；1.2本系統(tǒng)涉及的知識點(diǎn)winform 常用控件、屬性、方法、(button, textbox, datagridview 等控件) 窗體之間的數(shù)據(jù)交互、數(shù)據(jù)庫技術(shù)。2功能設(shè)計(jì)通過設(shè)計(jì)一個(gè)人事管理系統(tǒng)來對公司員進(jìn)行增刪查改的操

2、作在系統(tǒng)功能分析的基礎(chǔ)上，考慮microsoft visual studio 2013和數(shù)據(jù)庫sql server2012程序編制的特點(diǎn)，得到如圖2-1所示的系統(tǒng)功能模塊圖界主 /,./添加員工庫圖2-1功能模塊圖3數(shù)據(jù)庫設(shè)計(jì)驗(yàn)證管理員登錄信息正確進(jìn)入主界面操作成功 程序作出反應(yīng)數(shù)據(jù)交互川 戶 操 作數(shù)據(jù)庫概念設(shè)計(jì)圖首先建立一個(gè)名為yggl的數(shù)據(jù)庫create database yeel建立登陸信息表create table 登陸100 %1sqlqueryl.sql l.-pca chuan (54)* x1234567screate table denglu (name varchar(5

3、0), pwd varchar(50 )日insert into denglu values c admin",' admin select *from denglu勺結(jié)果匕消息nameadminpwdadmin然后建立信息的表（以i條信息作為基礎(chǔ)信息）greate table 信息sql server 設(shè)計(jì) -er lxa i i j応魚資源背理器 ¥ x趣-菩恕歹固戛b lb libingchuan-pc (sql server 11.0.2100 libing. a 0 邂庫(±)瑋站庫(±)li(±)n system0yggl數(shù)

4、據(jù)庫關(guān)票圏日表田匚a漿統(tǒng)表-iletablesb日 3 dbo.denglu日n列這name (varchar(50), not null)j pwd (varchar(50)f not null)e) 口避田約束 融發(fā)器田索引 統(tǒng)計(jì)信息日j dbo信息日口列圍編號(int, null)u 姓名(varchar(20), null)u (varchar(10), null)圍錯(cuò)貫(varchar(60)l null)j電話(varchar(30), null)約束ms器索引4系統(tǒng)實(shí)現(xiàn)4.1：首先設(shè)計(jì)一個(gè)登陸窗】代碼如下：using system;using system. collection

5、s. generic;using system componentmodel;using system. data;using system. drawing;using system. linq;using systcm. text;using system. threading. tasks; using system. windows. forms; using systemdata. sqlclient;namespace員工管理系統(tǒng)public partial class forml : form publ ic forml ()initial!zecomponent();priva

6、te void buttonl_click(object sender, eventargs e)string name = textboxl.text;string pwd 二 textbox2.text;sqlcorrnection mycon = new sqlcorrnection();mycon. connectionstring = ta sourcc=libingciiuan-pc; initial catalog=yggl; integrated security二true"/設(shè)置數(shù)據(jù)庫連接參數(shù)，依次是服務(wù)器 名、數(shù)據(jù)庫名、連接方式mycon. open () ;/打

7、開數(shù)據(jù)庫對象sqlcommand selectdm 二 new sqlcommand();selectdm. connection = mycon;selectdm. commandtext = "select * from denglu where name=，" + name + and pwd二' + pwd + ，；sqldataadaptcr da 二 new sqldataadaptcr();da. seiectcommand = selectdm;datatable dt 二 new datatable();da. fill (dt);/int i二d

8、t. rows. count;/此位置的設(shè)置是直接跳過密碼登陸 int i 二 1;if (i = 1)this. hide (); z j frm 二 new z j (); frm. show ();elsemcssagcbox. show(z，帳號或者密碼錯(cuò)謀！ ，“提示“); textboxl. clear ();textbox2. clear (); textboxl. focus (); mycon. close ();private void button2_click(object sender, eventargs e) application. exit ();效果圖如下:

9、4.2：主頁面的設(shè)計(jì) 代碼如下using system;using system. col lections. generic;using system. componentmodel;using system. data;using system. drawing;using system. linq;using system. text;using system. threading. tasks;using system. windows. forms;name space員工管理系統(tǒng) public peirtial class zj : form public zj ()initial

10、izecomponent (); private voidzj_load(object sender,eventargs e)private void textbox3_textchanged(object sender, eventargs e)private void buttonl_click(object sender, eventargs e) -點(diǎn)擊進(jìn)入查詢頁面this. hide ();ex frm 二 new ex ();frm. show (); private void button2_click(object sender, eventargs e)/點(diǎn)擊進(jìn)入添加頁面 t

11、his. hide ();t j frm = new t j (); frm. show ();private void button5_click(object sender, /點(diǎn)擊退出程序app i cat ion. exi t ();private void button3_click(object sender, "/點(diǎn)擊進(jìn)入修改頁面this. hideo ;xg frm = new xg ();frm. show ();privatc void button4_click(objcct sender,eventargs e)event.args e)eventargs e

12、)/點(diǎn)擊進(jìn)入刪除頁面 this. hide();sc frm 二 new sc (); frm. show ();運(yùn)行效杲圖如下員工管理系統(tǒng)點(diǎn)擊各個(gè)按鍵可以跳轉(zhuǎn)進(jìn)行下一步操作。4.3：對增刪查改的設(shè)置： 查：using system;using system. collections. generic;using system. componentmodel;using system. data;using system. drawing;using system. linq;using system. text;using system. threading. tasks;using sys

13、tem. windows. forms;using system. data. sqlclient;namespace員工管理系統(tǒng)public partial class ex : formpublic cx()initializccomponcnt();private void buttonl click(object sender, eventargs e)/sqlconnection mycon 二 new sqlconnection();/mycon. connectionstring = ta source=libingchuan-pc; initial catalog二yggl;

14、integrated security二true"/設(shè)置數(shù)據(jù)庫連接參數(shù)，依次是服務(wù)器 名、數(shù)據(jù)庫名、連接方式/mycon. open ()； 打開數(shù)據(jù)庫對象/sqlcommand selectdm 二 new sqlcommand(); /selectdm. connection 二 mycon;/selectdm. commandtext 二"select * from 員工信息;private void cx_load(object sender, eventargs e) / todo:這行代碼將數(shù)據(jù)加載到表"yggldataset2.信息”屮。您可以 根據(jù)

15、需要移動或刪除它。this.信息tablcadapter. fill (this. yggldataset2.信息);pri vate voi d button2 cli ck (object sender, eventargs e) "this. hide ();z j frm = new z j ();frm. show ();效果圖較為簡潔有i條基礎(chǔ)數(shù)據(jù)如下：using system;using system collections generic; using system. componentmodel;using system. data;using system .dr

16、awing;using system.linq;using system. text;using system. threading. tasks;using system. windows. forms;using system .data .sqlclicnt;name space員工管理系統(tǒng)public partial class tj : formpublic t j ()initializecomponent();private void buttonl_click(object sender, eventargs e) this. hide();z j frm 二 new z j

17、();frm. show();private void button2_click(object sender, eventargs e) "string 員工編號=textboxl. text;string 員工姓名=textbox2. text;string 性別=text.box3. text;string 籍貫=textboxd. text;string 屯話二 textbox5. text;sqlconnection mycon = new sqlconnectiono;mycon. connectionstring 二 "data source二libingch

18、uan-pc; initial catalog=yggl; integrated security二true"/設(shè)置數(shù)據(jù)庫連接參數(shù)，依次是服務(wù)器 名、數(shù)據(jù)庫名、連接方式mycon. openo ;/打開數(shù)據(jù)庫對象sqlcommand selectdm 二 new sqlcommand();seiectdm. connection 二 mycon;if (textbox1.text = “)messagebox. show(/z員工號不能為空！ “，提示信息， messageboxbuttons.ok, messageboxicon. information);elseselectdm

19、. commandtext 二"insert into 員工信息 values （' + 員 工編號+小，w +員工姓名+，+性別+，+籍貫+，+電話+ ，）； sclcctdm. exccutenonqucry （）;messagebox. show（“添加成功"）;mycon. close ();界面圖如下：改： amespace員工管理系統(tǒng)public partial class xg : formpublic xg()initializecomponent();private void xg_load(object sender, eventargs e)

20、/ todo:這行代碼將數(shù)據(jù)加載到表"yggldataset5.信息”屮。您可以 根據(jù)需要移動或刪除它。this.信息tableadapter2. fill (this. yggldataset5.信息);private void comboboxl selectedlndexchanged (object sender, eventargse)private void buttonl_click(object sender, eventargs e)string a 二 textboxl.text; string b = textbox2 .text string c 二 tcxt

21、box3 .text; string d = textbox4 .text string i = text.box5 text string q 二 textbox6. text;sqlcormcction mycon 二 new sqlcormcctiono;mycon. connectionstring = "data source二libingchuan-pc; initial catalog=yggl; integrated security二true"/設(shè)置數(shù)據(jù)庫連接參數(shù)，依次是服務(wù)器 名、數(shù)據(jù)庫名、連接方式mycon. open (); 打開數(shù)據(jù)庫對象sqlco

22、mmand selectdm 二 new sqlcommand();selectdm. connection = mycon;if (textbox6.text = “)messagebox. show(，z 輸入有* 誤！ ”， 提示信息“， mcssagcboxbuttons. ok, mcssagcboxicon. information);elseselectdm. commandtext 二 " update 信 息 set 編 號 二 convert. tolnt32 (a) +，姓名二'+b+ ，性別二'+c +，籍貫二+d+ ，電話 二，+i+，whe

23、re 編號=,z+convert. tolnt32 (q) +"；selectdm. executenonquery ();messagebox. show("修改成功);mycon. close ();private void button2_click(object sender, eventargs e) this hide ();ex frm 二 new ex ();frm. show();private void fillbytoolstripbutton_click(object sender, eventargs e) trythis信息tableadapte

24、r3. fillby (this. yggldataset2.信息); catch (system.exception ex)system windows forms messagebox show(ex message);界面如下：刪： 代碼： namespace員工管理系統(tǒng)public partial class sc : formpublic sc ()tnitializecomponent();private void buttonl click(object sender, eventargs e) "string z 二 textboxl.text;sqlconnecti

25、on mycon = new sqlconnection();mycon. connectionstring = z，data source二l1bingchuan-pc; initial catalog=yggl; integrated security二true"/設(shè)置數(shù)據(jù)庫連接參數(shù)，依次是服務(wù)器 名、數(shù)據(jù)庫名、連接方式mycon. open (); 打開數(shù)據(jù)庫對象sqlcommand select dm = new sqlcommando ;selectdm. connection = mycon;if (textbox1.text = “)messagebox. show(“

26、員工編號不能為空！ “，提示信息“, mcssageboxbuttons ok, vlcssageboxicon information);elseselectdm. commandtext 二"delete from 信息 where 編號二"+ convert.tolnt32(z) + “；selectdm. executenonquery ();messagebox. show("刪除成功);private void button2_click(object sender, event.args e) "thi s. hide();ex frm 二 new ex ();frm. show ();private voi d button3_click(object sender, eventargs e) " this. hide ();z j frm = new z j ();frm. show ();private void sc_load(object sender, eventargs e)效果如下:輸入員工編號：2確認(rèn)刪除查詢結(jié)果回主菜單程序設(shè)計(jì)總體概括圖:竝 員工管理系統(tǒng)microsoft visua