計算機畢業(yè)論文源代碼

1、公司絕密計算機畢業(yè)論文源代碼計算機畢業(yè)論文源代碼.doc計算機畢業(yè)論文源代碼計算機畢業(yè)論文源代碼:會計信息生產(chǎn)社會化仿真系統(tǒng)1.折舊年限表(pany_zjnx)建表源程序:createtabledbo.pany_zjnx(cnamechar(40)collatechinese_prc_ci_asnull,obj_namechar(40)collatechinese_prc_ci_asnull,zj_yearsintnull,zj_ideachar(40)collatechinese_prc_ci_asnull,canzhifloatnull)2.企業(yè)基本情況表(pany_total)建表源程序

2、:createtabledbo.pany_total(_idintnotnull,cnamechar(40)collatechinese_prc_ci_asnotnull,ccodechar(18)collatechinese_prc_ci_asnull,rmoneyfloatnull,farenchar(8)collatechinese_prc_ci_asnull,caddchar(40)collatechinese_prc_ci_asnull,kindschar(20)collatechinese_prc_ci_asnull,act_areatextcollatechinese_prc_c

3、i_asnull,telchar(12)collatechinese_prc_ci_asnull,cellchar(11)collatechinese_prc_ci_asnull,faxchar(12)collatechinese_prc_ci_asnull,ccontentchar(8)collatechinese_prc_ci_asnull,bankchar(30)collatechinese_prc_ci_asnull,bank_numchar(18)collatechinese_prc_ci_asnull,zz_numchar(12)collatechinese_prc_ci_asnu

4、ll,tax_numchar(15)collatechinese_prc_ci_asnull,realmoneyfloatnull,zz_yearsintnull,fz_datechar(8)collatechinese_prc_ci_asnull,fz_jiguanchar(30)collatechinese_prc_ci_asnull,hangyechar(10)collatechinese_prc_ci_asnull)3.企業(yè)初始投資表(pany_cstz)見表源程序:createtabledbo.pany_cstz(cnamechar(40)collatechinese_prc_ci_

5、asnotnull,cz_prochar(40)collatechinese_prc_ci_asnull,cz_moneyrealnull,cz_manchar(20)collatechinese_prc_ci_asnull,cz_codechar(10)collatechinese_prc_ci_asnull,cz_datechar(10)collatechinese_prc_ci_asnull,cz_percentchar(10)collatechinese_prc_ci_asnull,extrachar(60)collatechinese_prc_ci_asnull)4.交易總表(con

6、tract_total)建表源程序:createtabledbo.contract_total(ychar(10)collatechinese_prc_ci_asnull,mchar(10)collatechinese_prc_ci_asnull,dchar(10)collatechinese_prc_ci_asnull,gnamechar(40)collatechinese_prc_ci_asnull,gtax_numchar(15)collatechinese_prc_ci_asnull,g_addchar(40)collatechinese_prc_ci_asnull,gbank_num

7、char(18)collatechinese_prc_ci_asnull,obj_bhchar(10)collatechinese_prc_ci_asnull,obj_namechar(20)collatechinese_prc_ci_asnull,obj_dwchar(8)collatechinese_prc_ci_asnull,obj_slintnull,obj_djrealnull,jinefloatnull,tax_perdecimal(18,0)null,taxefloatnull,jshjfloatnull,xnamechar(40)collatechinese_prc_ci_as

8、null,xtax_numchar(15)collatechinese_prc_ci_asnull,x_addchar(40)collatechinese_prc_ci_asnull,xbank_numchar(18)collatechinese_prc_ci_asnull,zj_yearsintnull,zj_idearchar(40)collatechinese_prc_ci_asnull,canzhifloatnull,pz_numintnull,zychar(30)collatechinese_prc_ci_asnull)5.科目表(kmb)建表源程序:createtabledbo.k

9、mb(km_numchar(15)collatechinese_prc_ci_asnull,km_namechar(26)collatechinese_prc_ci_asnull,km_xzhchar(10)collatechinese_prc_ci_asnull,jdfxchar(2)collatechinese_prc_ci_asnull,km_jbintnull)6.記賬憑證表(jzpz)建表源程序:createtabledbo.jzpz(ychar(10)collatechinese_prc_ci_asnull,mchar(10)collatechinese_prc_ci_asnull

10、,dchar(10)collatechinese_prc_ci_asnull,pz_numintnull,z_cnamechar(40)collatechinese_prc_ci_asnull,d_cnamechar(40)collatechinese_prc_ci_asnull,km_numchar(10)collatechinese_prc_ci_asnull,km_namechar(26)collatechinese_prc_ci_asnull,mxkmchar(26)collatechinese_prc_ci_asnull,zychar(30)collatechinese_prc_ci

11、_asnull,j_jinefloatnull,d_jinefloatnull)7.時間維表(time_dim)建表源程序:createtabledbo.time_dim(time_numintidentity(1,1)notnull,ychar(10)collatechinese_prc_ci_asnull,mchar(10)collatechinese_prc_ci_asnull,dchar(10)collatechinese_prc_ci_asnull)8.貨物維表(obj_dim)建表源程序:createtabledbo.obj_dim(obj_numintidentity(1,1)n

12、otnull,obj_bhchar(10)collatechinese_prc_ci_asnotnull,obj_namechar(20)collatechinese_prc_ci_asnotnull,obj_dwchar(8)collatechinese_prc_ci_asnotnull,obj_djrealnotnull)9.購貨單位維表(g_dim)建表源程序:createtabledbo.g_dim(g_numintidentity(1,1)notnull,gnamechar(40)collatechinese_prc_ci_asnotnull,gtax_numchar(15)coll

13、atechinese_prc_ci_asnull,g_addchar(40)collatechinese_prc_ci_asnull,gbank_numchar(18)collatechinese_prc_ci_asnull)10.銷貨單位維表(x_dim)建表源程序:createtabledbo.x_dim(x_numintidentity(1,1)notnull,xnamechar(40)collatechinese_prc_ci_asnotnull,xtax_numchar(15)collatechinese_prc_ci_asnull,x_addchar(40)collatechine

14、se_prc_ci_asnull,xbank_numchar(18)collatechinese_prc_ci_asnull)11.交易事實表(contract_total)建表源程序:createtabledbo.contract_fact(s_numintidentity(1,1)notnull,g_numintnotnull,x_numintnotnull,time_numintnotnull,obj_numintnotnull,obj_slintnotnull,jinefloatnotnull,tax_perdecimal(18,0)notnull,taxefloatnotnull,j

15、shjfloatnotnull)計算機畢業(yè)論文源代碼:企業(yè)人事管理系統(tǒng)的設(shè)計與實現(xiàn)各模塊實現(xiàn)的主要源代碼f1.1登錄模塊的設(shè)計與實現(xiàn)的主要代碼if(tbxusercode.text.trim()=“)bigmessagebox.show(“請您輸入用戶或密碼!”,“警告”,messageboxbuttons.ok,messageboxicon.stop);this.tbxusercode.text=“;this.tbxusercode.text=“;this.tbxusercode.focus();return;elseemployeeinfoemp=null;switch(user.logi

16、nvalidate(tbxusercode.text.trim(),tbxuserpwd.text.trim(),outemp)caseuser.loginresult.nouser:bigmessagebox.show(“沒有該用戶信息”,“用戶驗證”,messageboxbuttons.ok,messageboxicon.stop);tbxusercode.text=“;tbxusercode.focus();break;caseuser.loginresult.passworderror:bigmessagebox.show(“用戶密碼錯誤!”,“用戶驗證”,messageboxbutt

17、ons.ok,messageboxicon.stop);tbxuserpwd.text=“;tbxuserpwd.focus();break;caseuser.loginresult.success:formmainobjmain=newformmain();this.hide();objmain.show();break;default:break;f1.2登陸實體類:stringbuilderstrsql=newstringbuilder();strsql.append(“selectempid,loginname,logincode,password,roleid,isused,crea

18、tename,createdatetime,remarkfromlogin“);strsql.append(“whereloginrcode=“+loginrcode);loginmodel=newlogin();datatabledt=dbhelpersql.instance.getdatatable(strsql.tostring();if(dt.rows.count0)model.empno=dt.rows0“empno”.tostring();model.loginname=dt.rows0“l(fā)oginname”.tostring();model.loginrcode=dt.rows0

19、“l(fā)ogincode”.tostring();model.password=dt.rows0“password”.tostring();if(dt.rows0“roleid”.tostring()!=“)model.roleid=int.parse(dt.rows0“roleid”.tostring();model.isused=dt.rows0“isused”.tostring();model.createname=dt.rows0“createname”.tostring();if(dt.rows0“createdatetime”.tostring()!=“)model.createdat

20、etime=datetime.parse(dt.rows0“createdatetime”.tostring();model.remark=dt.rows0“remark”.tostring();returnmodel;elsereturnnull;檢查該員工是否應(yīng)該是系統(tǒng)用戶:returndbhelpersql.instance.executescalar(“selectloginidfromloginwherelogincode=“+loginrcode+“);檢查用戶編碼是否可以使用:returndbhelpersql.instance.executescalar(“selectlogi

21、nrcodefromloginwherelogincode=“+loginrcode+“);通過loginid查找相應(yīng)的密碼:returndbhelpersql.instance.executescalar(“selectpasswordfromloginwhereloginid=“+loginid);f1.3員工管理模塊的設(shè)計與實現(xiàn)的主要代碼f1.3.1員工管理實現(xiàn)的主要代碼:publicclassbllattendance/增加一條數(shù)據(jù)/publicstaticintadd(attendancemodel,dbtransactiontrans)stringbuildersb=newstri

22、ngbuilder();sb.append(“insertintoattendance(attendate,empno,adsum,fact,late,leave,absent,overtime,notin,notout,outgo,”);sb.append(“workout,worktime,numcount,in,out,artificial,work,illness,thing,family)”);sb.append(“values(attendate,empno,adsum,fact,late,leave,absent,overtime,notin,notout,outgo,”);sb

23、.append(“workout,worktime,numcount,in,out,artificial,work,illness,thing,family)”);returndbhelpersql.instance.excutetransnonquery(sb.tostring(),dbhelpersql.instance.createparamters(sb.tostring(),model),trans);/更新一條數(shù)據(jù)/publicstaticintupdate(attendancemodel)stringbuildersb=newstringbuilder();sb.append(“

24、updateattendancesetadsum=adsum,fact=fact,late=late,leave=leave,absent=absent,overtime=overtime,”);sb.append(“notin=notin,notout=notout,outgo=outgo,workout=workout,worktime=worktime,numcount=numcount,”);sb.append(“in=in,artificial=artificial,out=out,work=work,illness=illness,thing=thing,family=family

25、whereempno=empno”);returndbhelpersql.instance.excutenonquery(sb.tostring(),dbhelpersql.instance.createparamters(sb.tostring(),model);/刪除一條數(shù)據(jù)/publicstaticintdelete(stringempno)stringbuildersb=newstringbuilder();sb.append(string.format(“deletefromattendancewhereempno=0”,empno);returndbhelpersql.instan

26、ce.excutenonquery(sb.tostring();publicstaticdatatablegetattenddancedatatable()stringbuildersb=newstringbuilder();sb.append(“selectattendate,empno,adsum,fact,late,leave,absent,overtime,notin,notout,”);sb.append(“outgo,workout,worktime,numcount,in,out,artificial,work,illness,thing,familyfromattendance

27、“);returndbhelpersql.instance.getdatatable(sb.tostring();f1.3.2部門管理實現(xiàn)主要代碼:publicclassblldepartment/增加一條數(shù)據(jù)/publicstaticintadd(departmentmodel)stringbuilderstrsql=newstringbuilder();strsql.append(“intodepartment(“);strsql.append(“departno,departname,departdesn,parentid,remark”);strsql.append(“)”);strs

28、ql.append(“values(“);strsql.append(“+model.departno+“,”);strsql.append(“+model.departname+“,”);strsql.append(“+model.departdesn+“,”);strsql.append(“+model.parentid+“,”);strsql.append(“+model.remark+“);strsql.append(“)”);returndbhelpersql.instance.excutenonquery(strsql.tostring();/更新一條數(shù)據(jù)/publicstatic

29、intupdate(departmentmodel)stringbuilderstrsql=newstringbuilder();strsql.append(“departmentset“);strsql.append(“departname=“+model.departname+“,”);strsql.append(“departdesn=“+model.departdesn+“,”);strsql.append(“parentid=“+model.parentid+“,”);strsql.append(“remark=“+model.remark+“);strsql.append(“whe

30、redepartno=“+model.departno+“);returndbhelpersql.instance.excutenonquery(strsql.tostring();/刪除一條數(shù)據(jù)/publicstaticintdelete(stringdepartno)stringbuilderstrsql=newstringbuilder();strsql.append(“department“);strsql.append(“wheredepartno=“+departno+“);returndbhelpersql.instance.excutenonquery(strsql.tostr

31、ing();/得到一個對象實體/publicstaticdepartmentgedepartment(stringdepartno)stringbuilderstrsql=newstringbuilder();strsql.append(“selectdepartno,departname,departdesn,parentid,remarkfromdepartment”);strsql.append(“wheredepartno=“+departno);departmentmodel=newdepartment();datatabledt=dbhelpersql.instance.getda

32、tatable(strsql.tostring();if(dt.rows.count0)model.departno=dt.rows0“departno”.tostring();model.departname=dt.rows0“departname”.tostring();model.departdesn=dt.rows0“departdesn”.tostring();if(dt.rows0“parentid”.tostring()!=“)model.parentid=int.parse(dt.rows0“parentid”.tostring();model.remark=dt.rows0“

33、remark”.tostring();returnmodel;elsereturnnull;publicstaticstringgetdepartmentidisnull(intempid)returndbhelpersql.instance.executescalar(“selectdepartmentidfromemployeewheredepartmentid=“+empid+“);f1.3.3工資管理主要代碼:publicpartialclassucpay:usercontrolprivatestringempno=“;publicucpay()initializeponent();p

34、rivatevoidbtnexit_click(objectsender,eventargse)(this.parentaspanel).controls.clear();privatevoidbtnadd_click(objectsender,eventargse)if(bllgongz.add(getgongz()0)bigmessagebox.show(“員工工資添加成功”,“員工工資維護”,messageboxbuttons.ok,messageboxicon.information);this.bind();elsebigmessagebox.show(“員工工資添加失敗!”,“員工

35、工資維護”,messageboxbuttons.ok,messageboxicon.stop);privategongzgetgongz()gongzmodel=newgongz();model.empno=empno;model.monthid=utilities.converobjectint(cbomonth.selectedvalue);model.gbgz=convert.todecimal(txtgbgz.text.trim();model.fzyj=convert.todecimal(txtfzyj.text.trim();model.xstc=convert.todecimal

36、(txtxstc.text.trim();model.bjgz=convert.todecimal(txtbjgz.text.trim();model.jxgz=convert.todecimal(txtjxgz.text.trim();model.sjgz=convert.todecimal(txtsjgz.text.trim();model.jlgz=convert.todecimal(txtjlgz.text.trim();model.ylbx=convert.todecimal(txtylbx.text.trim();model.jbgz=convert.todecimal(txtjb

37、gz.text.trim();model.zsgz=convert.todecimal(txtzsgz.text.trim();model.qqjj=convert.todecimal(txtqqjj.text.trim();model.gskf=convert.todecimal(txtgskf.text.trim();model.other=convert.todecimal(ttxtother.text.trim();model.notes=“;returnmodel;privatevoiducpay_load(objectsender,eventargse)this.cbomonth.

38、displaymember=“cdesc”;this.cbomonth.valuemember=“codeid”;this.cbomonth.datasource=bllgongz.getmonth();this.cbomonth.selectedindex=0;this.dgemp.datasource=bllgongz.getempinfo();this.bind();privatevoiddgemp_cellclick(objectsender,datagridviewcelleventargse)if(dgemp.datasource!=null&dgemp.rows.count0)i

39、f(e.rowindex!=-1)empno=this.dgemp.rowse.rowindex.cells0.value.tostring();this.bind();privatevoidbtnupdate_click(objectsender,eventargse)if(bllgongz.update(getgongz()0)bigmessagebox.show(“員工工資添加成功”,“員工工資維護”,messageboxbuttons.ok,messageboxicon.information);this.bind();elsebigmessagebox.show(“員工工資添加失敗!

40、”,“員工工資維護”,messageboxbuttons.ok,messageboxicon.stop);privatevoidbind()this.dgvsalaryitem.datasource=bllgongz.getgongz(empno);privatevoiddgvsalaryitem_cellclick(objectsender,datagridviewcelleventargse)if(dgvsalaryitem.datasource!=null&dgvsalaryitem.rows.count0)if(e.rowindex!=-1)empno=this.dgvsalaryit

41、em.rowse.rowindex.cells“empid”.value.tostring();cbomonth.selectedvalue=this.dgvsalaryitem.rowse.rowindex.cells“monthid”.value;txtgbgz.text=this.dgvsalaryitem.rowse.rowindex.cells“gbgz”.value.tostring();txtfzyj.text=this.dgvsalaryitem.rowse.rowindex.cells“fzyj”.value.tostring();txtxstc.text=this.dgvs

42、alaryitem.rowse.rowindex.cells“xstc”.value.tostring();txtbjgz.text=this.dgvsalaryitem.rowse.rowindex.cells“bjgz”.value.tostring();txtjxgz.text=this.dgvsalaryitem.rowse.rowindex.cells“jxgz”.value.tostring();txtsjgz.text=this.dgvsalaryitem.rowse.rowindex.cells“sjgz”.value.tostring();txtjlgz.text=this.

43、dgvsalaryitem.rowse.rowindex.cells“jlgz”.value.tostring();txtylbx.text=this.dgvsalaryitem.rowse.rowindex.cells“ylbx”.value.tostring();txtjbgz.text=this.dgvsalaryitem.rowse.rowindex.cells“jbgz”.value.tostring();txtzsgz.text=this.dgvsalaryitem.rowse.rowindex.cells“zsgz”.value.tostring();txtqqjj.text=t

44、his.dgvsalaryitem.rowse.rowindex.cells“qqjj”.value.tostring();txtgskf.text=this.dgvsalaryitem.rowse.rowindex.cells“gskf”.value.tostring();ttxtother.text=this.dgvsalaryitem.rowse.rowindex.cells“other”.value.tostring();privatevoidbtndelete_click(objectsender,eventargse)if(empno!=“)if(bigmessagebox.sho

45、w(“您確定要刪除員工基本信息嗎?”,“刪除員工工資信息”,messageboxbuttons.okcancel,messageboxicon.question)=dialogresult.ok)if(bllgongz.delete(empno)0)bigmessagebox.show(“刪除員工工資信息成功”,“刪除員工工資信息”,messageboxbuttons.ok,messageboxicon.information);this.bind();elsebigmessagebox.show(“刪除員工考評信息失敗”,“刪除員工工資信息”,messageboxbuttons.ok,mes

46、sageboxicon.information);elsebigmessagebox.show(“請選擇一個員工信息”,“刪除員工工資信息”,messageboxbuttons.ok,messageboxicon.information);f1.3.4考勤信息設(shè)計與實現(xiàn)主要代碼:privatevoidbtnadd_click(objectsender,eventargse)if(bllevaluation.add(getevaluation()0)bigmessagebox.show(“添加員工考評信息成功”,“添加員工考評信息”,messageboxbuttons.ok,messagebox

47、icon.information);bind();init();elsebigmessagebox.show(“添加員工考評信息失敗”,“添加員工考評信息”,messageboxbuttons.ok,messageboxicon.information);privateevaluationgetevaluation()evaluationmodel=newevaluation();if(utilities.convertnulltospace(cbomonth.selectedvalue)!=“)model.evamonth=utilities.convertint(cbomonth.sele

48、ctedvalue.tostring();if(utilities.convertnulltospace(cbograde.selectedvalue)!=“)model.markdegreeid=utilities.convertint(cbograde.selectedvalue.tostring();model.invigilater=txtperson.text;model.employeeno=labempid.text.trim();model.mark=utilities.convertint(this.txtnumber.text);model.remark=this.txtr

49、emark.text;model.result=this.txtresult.text;model.subject=this.txtproject.text;if(labid.text.trim()!=“)model.evaluationid=int.parse(labid.text.trim();returnmodel;privatevoidbtnupdate_click(objectsender,eventargse)if(labid.text.trim()!=“)if(bllevaluation.update(getevaluation()0)bigmessagebox.show(“修改

50、員工考評信息成功”,“修改員工考評信息”,messageboxbuttons.ok,messageboxicon.information);this.dgvassess.datasource=boxdatatable.getassesstable(labempid.text.trim();init();elsebigmessagebox.show(“修改員工考評信息失敗”,“修改員工考評信息”,messageboxbuttons.ok,messageboxicon.information);elsebigmessagebox.show(“請選擇一個員工的考評信息”,“修改員工考評信息”,mes

51、sageboxbuttons.ok,messageboxicon.information);privatevoidbtndelete_click(objectsender,eventargse)if(!utilities.convertnulltospace(this.dgvassess.rowsthis.dgvassess.currentrow.index.cells“evaluationid”).equals(“)if(bllevaluation.delete(utilities.convertint(this.dgvassess.rowsthis.dgvassess.currentrow

52、.index.cells“evaluationid”.value.tostring()0)bigmessagebox.show(“刪除員工考評信息成功”,“刪除員工考評信息”,messageboxbuttons.ok,messageboxicon.information);this.dgvassess.datasource=boxdatatable.getassesstable(labempid.text.trim();init();elsebigmessagebox.show(“刪除員工考評信息失敗”,“刪除員工考評信息”,messageboxbuttons.ok,messageboxico

53、n.information);elsebigmessagebox.show(“請選擇一個員工的考評信息”,“刪除員工考評信息”,messageboxbuttons.ok,messageboxicon.information);privatevoiddgvemp_cellclick(objectsender,datagridviewcelleventargse)if(dgvemp.datasource!=null&dgvemp.rows.count0)labempid.text=this.dgvemp.rowse.rowindex.cells“employeeno”.value.tostring();this.dgvassess.selectionmode=datagridviewselectionmode.fullrowselect;this.dgvassess.datasource=boxdatatable.ge