计算机毕业论文源代码.doc

1、1 / 34计算机毕业论文源代码计算机毕业论文源代码：会计信息生产社会化仿真系统 1.折旧年限表(company_zjnx)建表源程序：CREATETABLE.(40)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL)2.企业基本情况表(company_total)建表源程序：CR EATETABLE.(NOTNUL L,(40)COLLATEChin ese_PRC_CI_ASNOTNULL,(18)COLLATEChi nese_P

2、RC_CI_ASNULL,NULL,(8)COLLATEChinese_PRC_CI_ASN ULL,(40)COLLATECh inese_PRC_CI_ASNUL L,(20)COLLATEChin ese_PRC_CI_ASNULL,COLLATEChinese_PRC _CI_ASNULL,(12)CO LLATEChinese_PRC_C I_ASNULL,(11)COLL ATEChinese_PRC_CI_ASNULL,2 / 34(12)COLLAT EChinese_PRC_CI_AS NULL,(8)COLLATECh inese_PRC_CI_ASNULL,(30)COL

3、LATEChin ese_PRC_CI_ASNULL,(18)COLLATEChines e_PRC_CI_ASNULL,(12)COLLATEChinese_PRC_CI_ASNULL,(15 )COLLATEChinese_PR C_CI_ASNULL,NULL,NULL,(8)COLLATEC hinese_PRC_CI_ASNU LL,(30)COLLATEChi nese_PRC_CI_ASNULL ,(10)COLLATEChine se_PRC_CI_ASNULL)3.企业初始投资表(company_cstz)见表源程序：CREATE TABLE.(40)COLLATEChine

4、se_PRC_CI_AS NOTNULL,(40)COLLA TEChinese_PRC_CI_A SNULL,NULL,(20)C OLLATEChinese_PRC_CI_ASNULL,(10)COL LATEChinese_PRC_CI _ASNULL,(10)COLLATEChinese_PRC_CI_A SNULL,(10)COLLATE Chinese_PRC_CI_ASN ULL,(60)COLLATEChinese_PRC_CI_ASNUL L3 / 34)4.交易总表(contrac t_total)建表源程序：CRE ATETABLE.(10)COL LATEChinese

5、_PRC_CI _ASNULL,(10)COLLA TEChinese_PRC_CI_ASNULL,(10)COLLATE Chinese_PRC_CI_ASN ULL,(40)COLLATEChinese_PRC_CI_ASNUL L,(15)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChines e_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL,(10 )COLLATEChinese_PR C_CI_ASNULL,(20)C OLLATEChinese_PRC_CI_ASNULL,(8)COLL ATEC

6、hinese_PRC_CI_ASNULL,NULL,NULL,NULL,(18,0)NULL ,NULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,(15)CO LLATEChinese_PRC_CI_ASNULL,(40)COLL ATEChinese_PRC_CI_ASNULL,4 / 34(18)COLLAT EChinese_PRC_CI_ASNULL,NULL,(40)CO LLATEChinese_PRC_C I_ASNULL,NULL,NULL,(30)COLLATEChi nese_PRC_CI_ASNULL)5.科目表(kmb)建表源程序：C

7、REATETABLE.(15 )COLLATEChinese_PR C_CI_ASNULL,(26)C OLLATEChinese_PRC_CI_ASNULL,(10)COL LATEChinese_PRC_CI _ASNULL,(2)COLLATEChinese_PRC_CI_AS NULL,NULL)6.记账凭证表(jzpz)建表源程序：CRE ATETABLE.(10)COL LATEChinese_PRC_CI _ASNULL,(10)COLLA TEChinese_PRC_CI_ASNULL,(10)COLLATE Chinese_PRC_CI_ASN ULL,NULL,(40)CO

8、L LATEChinese_PRC_CI _ASNULL,5 / 34(40)COLLA TEChinese_PRC_CI_A SNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(26)COLLATEChinese_PRC_CI_ASNULL,(26)COLLATEChin ese_PRC_CI_ASNULL,(30)COLLATEChinese _PRC_CI_ASNULL,NU LL,NULL)7.时间维表(time_dim)建表源程序：CR EATETABLE.(IDENTITY(1,1)NOTNULL,(1 0)COLLATEChinese_P RC_CI_

9、ASNULL,(10)COLLATEChinese_PRC _CI_ASNULL,(10)CO LLATEChinese_PRC_C I_ASNULL)8.货物维表( obj_dim)建表源程序：CREATETABLE.(IDENTIT Y(1,1)NOTNULL,(10 )COLLATEChinese_PR C_CI_ASNOTNULL,(2 0)COLLATEChinese_P RC_CI_ASNOTNULL,(8)COLLATEChinese_P RC_CI_ASNOTNULL,NOTNULL6 / 34)9.购货单位维表( g_dim)建表源程序：CREAT ETABLE.(IDENT

10、ITY(1,1)NOTNULL,(40)C OLLATEChinese_PRC_CI_ASNOTNULL,(15)COLLATEChinese_PRC _CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(18)COLL ATEChinese_PRC_CI_ASNULL)10.销货单位维表(x_dim)建表源程序：CREA TETABLE.(IDENTITY(1,1)NOTNULL,(40)COLLATEChinese_PRC_CI_ASNOTNULL,(15 )COLLATEChinese_PR C_CI_ASNULL,(40)C OLLATEChines

11、e_PRC_CI_ASNULL,(18)COL LATEChinese_PRC_CI _ASNULL)11.交易事实表(contract_total)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTN ULL,NOTNULL,NOTN ULL,7 / 34NOTNULL,NOTN ULL,NOTNULL,NOTN ULL,(18,0)NOTNULL,NOTNULL,NOTNULL)计算机毕业论文源代码：企业人事管理系统的设计与实现各模块实现的主要源代码登录模块的设计与实现的主要代码if()=“)(“请您输入用户或密码!“,“警告“,);=“;=“;();return;el

12、seEmp loyeeInfoemp=null;8 / 34switch(),(),oute mp)case:(“没有该用户信息“,“用户验证“,);=“;();break;case:(“用户密码错误!“,“用户验证“,);=“;();break;case:FormMainobjMain =newFormMain();();();break;9 / 34def ault:break;登陆实体类：StringBuilde rstrSql=newStringB uilder();(“selectEmpID,LoginName,Lo ginCode,Password,RoleID,IsUsed,Cr

13、eateName,CreateDatetime,RemarkFROMLogin “);(“whereLoginrC ode=“+LoginrCode);Loginmodel=newLog in();DataTabledt=();if(0)=.ToString();=.ToStr ing();=.ToString();=.ToString();if(.ToString()!=“)=(.ToString();10 / 34=.ToString();=.ToString();if(.T oString()!=“)=(.ToString();=.ToString();retur nmodel;else

14、r eturnnull;检查该员工是否应该是系统用户：return(“SELECTLoginIDFROMLoginWHERELoginCode=“+LoginrCode+“);检查用户编码是否可以使用：re turn(“SELECTLoginrCodeFROMLoginWHERELoginCode=“+Loginr Code+“);通过 LoginI D 查找相应的密码：11 / 34return(“SelectPasswordfromLoginWhereLoginID=“+LoginID);员工管理模块的设计与实现的主要代码员工管理实现的主要代码：publicclassB llAttenda

15、nce/增加一条数据/publ icstaticintAdd(Att endancemodel,DbTransactiontrans)S tringBuildersb=new StringBuilder();(“INSERTINTOAttenda nce(AttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotOut,O utgo,“);(“WorkOut,WorkTime,NumCount ,Out,Artificial,Illness,Thing,Fami ly)“);(“VALUES(A ttenDate,EmpNo,

16、Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotO ut,Outgo,“);(“WorkOut,WorkTime,NumCount,In,Out,12 / 34Artificial,Work,Illness,Thing,F amily)“);return(),(),model),trans );/更新一条数据/publicstaticintUpdate(Attendanc emodel)StringBu ildersb=newStringB uilder();(“UPDATE AttendanceSETAdsum =Adsum,Fact=Fact

17、,Late=Late,Leave=Leave,Absent=Absent,Overtime=Overtime,“);(“NotIn=NotIn,NotOut=NotO ut,Outgo=Outgo,WorkOut=WorkOut,Wor kTime=WorkTime,NumCount=NumCount,“);(“=In,Artifici al=Artificial,Out=Out,=Work,Illness=Illness,Thing=Thing,Family=FamilyWHEREEmpNo=Emp No“);return(),(),model);/13 / 34/删除一条数据/publi

18、cstaticintDelete(stringEmpNo)Stri ngBuildersb=newStr ingBuilder();(“D ELETEFROMAttendanc eWHEREEmpNo=0“,E mpNo);return();publicstaticDataTableGetAttendda nceDataTable()S tringBuildersb=newStringBuilder();(“SELECTAttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Ov ertime,NotIn,NotOu t,“);(“Outgo,WorkOut,

19、WorkTime,NumCount,Out,Artificial,Illness,Thing,FamilyFROMAttendanc e“);return();部门管理实现主要代码：publicclassBLLDepartment/14 / 34/增加一条数据/publicstaticint Add(Departmentmode l)StringBuilderstrSql=newStringBu ilder();(“intoDep artment(“);(“Depa rtNo,DepartName,De partDesn,ParentID,Remark“);(“)“);(“values(“);

20、(“+“,“);(“+“,“);(“+“,“);(“+“,“);(“+“);(“)“);return();/更新一条数据/publ icstaticintUpdate(Departmentmodel)15 / 34StringBuilderstrS ql=newStringBuilder();(“Departments et“);(“DepartName =“+“,“);(“DepartDesn=“+“,“);(“Pa rentID=“+“,“);(“Remark=“+“);(“w hereDepartNo=“+“);return();/删除一条数据/p ublicstaticintDelet

21、e(stringDepartNo)StringBuilderst rSql=newStringBuil der();(“Departmen t“);(“whereDepart No=“+DepartNo+“);return();/得到一个对象实体16 / 34/p ublicstaticDepartmentGeDepartment(stringDepartNo)St ringBuilderstrSql=newStringBuilder();(“SELECTDepartNo,DepartName,DepartDesn,ParentID,Rema rkFROMDepartment“);(“WHER

22、EDepartNo=“+DepartNo);Depar tmentmodel=newDepa rtment();DataTabl edt=();if(0)=.ToString();=.To String();=.ToStri ng();if(.ToString ()!=“)=(.ToStr ing();=.ToStri ng();returnmodel;17 / 34elsereturnnu ll;publicstat icstringGetDepartmentIDIsNull(intempID)return(“SELECTDepartmentIDFROMEmployeeWHEREDepart

23、mentID=“+empID+“);工资管理主要代码：p ublicpartialclassU cPay:UserControlprivatestringempNo =“;publicUcPay()InitializeCompo nent();privatev oidbtnExit_Click(o bjectsender,EventArgse)18 / 34(asPanel).();privatevoidb tnAdd_Click(objectsender,EventArgse)if(GetGongZ()0)(“员工工资添加成功“,“员工工资维护“,);();else(“员工工资添加失败!“,

24、“员工工资维护“,);privateGongZGetGongZ()GongZmod el=newGongZ();=empNo;=();=();19 / 34=();=();=();=();=();=();=();=();=();=();=();=();=“;ret urnmodel;privat evoidUcPay_Load(ob jectsender,EventArgse)=“CDesc“;=“CodeID“;=();=0;=();20 / 34();privatevoiddgEmp_CellClic k(objectsender,DataGridViewCellEvent Argse)i

25、f(!=null ();privatevo idbtnUpdate_Click(objectsender,EventArgse)if(GetGo ngZ()0)(“员工工资添加成功“,“员工工资维护“,);();21 / 34else(“员工工资添加失败!“,“员工工资维护“,);privatevo idBind()=(empNo);privatevoiddg vSalaryItem_CellClick(objectsender,D ataGridViewCellEventArgse)if(!=null=.Cells.Value;=.Cells.();=.Cells.();=.Cells.()

26、;=.C ells.();22 / 34=.Cells.();=.Cells.();=.C ells.();=.Cells.();=.Cells.();=.C ells.();=.Cells.();=.Cells.();=.C ells.();privatevoidbtnDelete_Click(objectsender,EventArgse)if(empNo!=“)if(“您确定要删除员工基本信息吗?“,“删除员工工资信息“,)=)i f(empNo)0)23 / 34(“删除员工工资信息成功“,“删除员工工资信息“,);();else(“删除员工考评信息失败“,“删除员工工资信息“,);e

27、lse(“请选择一个员工信息“,“删除员工工资信息“,);考勤信息设计与实现主要代码：privatevoidbtnAdd _Click(objectsender,EventArgse)if(GetEvaluation()0)(“添加员工考评信息成功“,“添加员工考评信息“,);24 / 34B ind();Init();e lse(“添加员工考评信息失败“,“添加员工考评信息“,);privateEvaluatio nGetEvaluation()Evaluationmodel=newEvaluation();if()!=“)=();if()!=“)=();=;=();=();25 / 34=

28、;=;=;if()!=“)=();return model;privatevoidbtnUpdate_Click(objectsender,EventArgse)if()!=“)if(GetEvaluat ion()0)(“修改员工考评信息成功“,“修改员工考评信息“,);=();Init();else26 / 34(“修改员工考评信息失败“,“修改员工考评信息“,);else(“请选择一个员工的考评信息“,“修改员工考评信息“,);priv atevoidbtnDelete_C lick(objectsender,EventArgse)if(!(.Cells).Equals(“)if(.Ce

29、lls.()0)(“删除员工考评信息成功“,“删除员工考评信息“,);=();Init();else27 / 34(“删除员工考评信息失败“,“删除员工考评信息“,);else(“请选择一个员工的考评信息“,“删除员工考评信息“,);privatevoiddgvEmp_CellClic k(objectsender,DataGridViewCellEvent Argse)if(!=null =;=(.Cells.();=true;private voiddgvAssess_Cell Click(objectsender ,DataGridViewCellE ventArgse)28 / 34i

30、f(!=null=true;=true ;=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.C ells.Value);=(.Cells.Value);pr ivatevoidbtnClean_Click(objectsender ,EventArgse)Ini t();数据访问类：publ icclassBllExperien ce29 / 34publicBllExpe rience()/增加一条数据/publicstaticintAdd(Experi encemodel)S

31、trin gBuilderstrSql=newStringBuilder();(“intoExperience(“);(“Position,Depar tment,StartDate,EndDate,EmployeeNO,R emark“);(“)“);(“values(“);(“+“,“);(“+“,“);(“+“,“);(“+“,“);(“+“,“);(“+“);(“)“);return();30 / 34/更新一条数据/publicstati cintUpdate(Experiencemodel)String BuilderstrSql=newS tringBuilder();(“Experienceset“);(“Position=“+“,“);(“Department=“+“,“);(“StartDate=“+“,“);(“EndDate=“+“,“);(“Employee NO=“+“,“);(“Rema rk=“+“);(“WHERE ExperienceID=“+“);return();/删除一条数据/p ublicstaticintDele te(intExperienceID )StringBuilderstrSql=newStringBui lder();