计算机毕业论文源代码

34/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)建表源程序：CREATETABLE.(NOTNULL,(40)COLLATEChinese_PRC_CI_ASNOTNULL,(18)COLLATEChinese_PRC_CI_ASNULL,NULL,(8)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(20)COLLATEChinese_PRC_CI_ASNULL,COLLATEChinese_PRC_CI_ASNULL,(12)COLLATEChinese_PRC_CI_ASNULL,(11)COLLATEChinese_PRC_CI_ASNULL,(12)COLLATEChinese_PRC_CI_ASNULL,(8)COLLATEChinese_PRC_CI_ASNULL,(30)COLLATEChinese_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL,(12)COLLATEChinese_PRC_CI_ASNULL,(15)COLLATEChinese_PRC_CI_ASNULL,NULL,NULL,(8)COLLATEChinese_PRC_CI_ASNULL,(30)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL)3.企业初始投资表(company_cstz)见表源程序：CREATETABLE.((40)COLLATEChinese_PRC_CI_ASNOTNULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL,(20)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(60)COLLATEChinese_PRC_CI_ASNULL)4.交易总表(contract_total)建表源程序：CREATETABLE.((10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(15)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(20)COLLATEChinese_PRC_CI_ASNULL,(8)COLLATEChinese_PRC_CI_ASNULL,NULL,NULL,NULL,(18,0)NULL,NULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,(15)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL,NULL,(30)COLLATEChinese_PRC_CI_ASNULL)5.科目表(kmb)建表源程序：CREATETABLE.((15)COLLATEChinese_PRC_CI_ASNULL,(26)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(2)COLLATEChinese_PRC_CI_ASNULL,NULL)6.记账凭证表(jzpz)建表源程序：CREATETABLE.((10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(26)COLLATEChinese_PRC_CI_ASNULL,(26)COLLATEChinese_PRC_CI_ASNULL,(30)COLLATEChinese_PRC_CI_ASNULL,NULL,NULL)7.时间维表(time_dim)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL,(10)COLLATEChinese_PRC_CI_ASNULL)8.货物维表(obj_dim)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTNULL,(10)COLLATEChinese_PRC_CI_ASNOTNULL,(20)COLLATEChinese_PRC_CI_ASNOTNULL,(8)COLLATEChinese_PRC_CI_ASNOTNULL,NOTNULL)9.购货单位维表(g_dim)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTNULL,(40)COLLATEChinese_PRC_CI_ASNOTNULL,(15)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL)10.销货单位维表(x_dim)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTNULL,(40)COLLATEChinese_PRC_CI_ASNOTNULL,(15)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,(18)COLLATEChinese_PRC_CI_ASNULL)11.交易事实表(contract_total)建表源程序：CREATETABLE.(IDENTITY(1,1)NOTNULL,NOTNULL,NOTNULL,NOTNULL,NOTNULL,NOTNULL,NOTNULL,(18,0)NOTNULL,NOTNULL,NOTNULL)计算机毕业论文源代码：企业人事管理系统的设计与实现各模块实现的主要源代码登录模块的设计与实现的主要代码if(()==""){("请您输入用户或密码!!","警告",,);="";="";();return;}else{EmployeeInfoemp=null;switch(((),(),outemp)){case:{("没有该用户信息","用户验证",,);="";();break;}case:{("用户密码错误!!","用户验证",,);="";();break;}case:{FormMainobjMain=newFormMain();();();break;}default:break;}}登陆实体类：StringBuilderstrSql=newStringBuilder();("selectEmpID,LoginName,LoginCode,Password,RoleID,IsUsed,CreateName,CreateDatetime,RemarkFROMLogin");("whereLoginrCode="+LoginrCode);Loginmodel=newLogin();DataTabledt=(());if(>0){=.ToString();=.ToString();=.ToString();=.ToString();if(.ToString()!=""){=(.ToString());}=.ToString();=.ToString();if(.ToString()!=""){=(.ToString());}=.ToString();returnmodel;}else{returnnull;}检查该员工是否应该是系统用户：return("SELECTLoginIDFROMLoginWHERELoginCode="+LoginrCode+"");检查用户编码是否可以使用：return("SELECTLoginrCodeFROMLoginWHERELoginCode="+LoginrCode+"");通过LoginID查找相应的密码：return("SelectPasswordfromLoginWhereLoginID="+LoginID);员工管理模块的设计与实现的主要代码员工管理实现的主要代码：publicclassBllAttendance{//////增加一条数据///publicstaticintAdd(Attendancemodel,DbTransactiontrans){StringBuildersb=newStringBuilder();("INSERTINTOAttendance(AttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotOut,Outgo,");("WorkOut,WorkTime,NumCount,,Out,Artificial,,Illness,Thing,Family)");("VALUES(@AttenDate,@EmpNo,@Adsum,@Fact,@Late,@Leave,@Absent,@Overtime,@NotIn,@NotOut,@Outgo,");("@WorkOut,@WorkTime,@NumCount,@In,@Out,@Artificial,@Work,@Illness,@Thing,@Family)");return((),((),model),trans);}//////更新一条数据///publicstaticintUpdate(Attendancemodel){StringBuildersb=newStringBuilder();("UPDATEAttendanceSETAdsum=@Adsum,Fact=@Fact,Late=@Late,Leave=@Leave,Absent=@Absent,Overtime=@Overtime,");("NotIn=@NotIn,NotOut=@NotOut,Outgo=@Outgo,WorkOut=@WorkOut,WorkTime=@WorkTime,NumCount=@NumCount,");("=@In,Artificial=@Artificial,Out=@Out,=@Work,Illness=@Illness,Thing=@Thing,Family=@FamilyWHEREEmpNo=@EmpNo");return((),((),model));}//////删除一条数据///publicstaticintDelete(stringEmpNo){StringBuildersb=newStringBuilder();(("DELETEFROMAttendanceWHEREEmpNo={0}",EmpNo));return(());}publicstaticDataTableGetAttenddanceDataTable(){StringBuildersb=newStringBuilder();("SELECTAttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Overtime,NotIn,NotOut,");("Outgo,WorkOut,WorkTime,NumCount,,Out,Artificial,,Illness,Thing,FamilyFROMAttendance");return(());}部门管理实现主要代码：publicclassBLLDepartment{//////增加一条数据///publicstaticintAdd(Departmentmodel){StringBuilderstrSql=newStringBuilder();("intoDepartment(");("DepartNo,DepartName,DepartDesn,ParentID,Remark");(")");("values(");(""++",");(""++",");(""++",");(""++",");(""++"");(")");return(());}//////更新一条数据///publicstaticintUpdate(Departmentmodel){StringBuilderstrSql=newStringBuilder();("Departmentset");("DepartName="++",");("DepartDesn="++",");("ParentID="++",");("Remark="++"");("whereDepartNo="++"");return(());}//////删除一条数据///publicstaticintDelete(stringDepartNo){StringBuilderstrSql=newStringBuilder();("Department");("whereDepartNo="+DepartNo+"");return(());}//////得到一个对象实体///publicstaticDepartmentGeDepartment(stringDepartNo){StringBuilderstrSql=newStringBuilder();("SELECTDepartNo,DepartName,DepartDesn,ParentID,RemarkFROMDepartment");("WHEREDepartNo="+DepartNo);Departmentmodel=newDepartment();DataTabledt=(());if(>0){=.ToString();=.ToString();=.ToString();if(.ToString()!=""){=(.ToString());}=.ToString();returnmodel;}else{returnnull;}}publicstaticstringGetDepartmentIDIsNull(intempID){return("SELECTDepartmentIDFROMEmployeeWHEREDepartmentID="+empID+"");}}工资管理主要代码：publicpartialclassUcPay:UserControl{privatestringempNo="";publicUcPay(){InitializeComponent();}privatevoidbtnExit_Click(objectsender,EventArgse){(asPanel).();}privatevoidbtnAdd_Click(objectsender,EventArgse){if((GetGongZ())>0){("员工工资添加成功","员工工资维护",,);();}else{("员工工资添加失败!!","员工工资维护",,);}}privateGongZGetGongZ(){GongZmodel=newGongZ();=empNo;=();=(());=(());=(());=(());=(());=(());=(());=(());=(());=(());=(());=(());=(());="";returnmodel;}privatevoidUcPay_Load(objectsender,EventArgse){="CDesc";="CodeID";=();=0;=();();}privatevoiddgEmp_CellClick(objectsender,DataGridViewCellEventArgse){if(!=null&&>0){if(!=-1){empNo=.Cells.();();}}}privatevoidbtnUpdate_Click(objectsender,EventArgse){if((GetGongZ())>0){("员工工资添加成功","员工工资维护",,);();}else{("员工工资添加失败!!","员工工资维护",,);}}privatevoidBind(){=(empNo);}privatevoiddgvSalaryItem_CellClick(objectsender,DataGridViewCellEventArgse){if(!=null&&>0){if(!=-1){empNo=.Cells.();=.Cells.Value;=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();=.Cells.();}}}privatevoidbtnDelete_Click(objectsender,EventArgse){if(empNo!=""){if(("您确定要删除员工基本信息吗?","删除员工工资信息",,)==){if((empNo)>0){("删除员工工资信息成功","删除员工工资信息",,);();}else{("删除员工考评信息失败","删除员工工资信息",,);}}}else{("请选择一个员工信息","删除员工工资信息",,);}}}考勤信息设计与实现主要代码：privatevoidbtnAdd_Click(objectsender,EventArgse){if((GetEvaluation())>0){("添加员工考评信息成功","添加员工考评信息",,);Bind();Init();}else{("添加员工考评信息失败","添加员工考评信息",,);}}privateEvaluationGetEvaluation(){Evaluationmodel=newEvaluation();if(()!=""){=(());}if(()!=""){=(());}=;=();=();=;=;=;if(()!=""){=(());}returnmodel;}privatevoidbtnUpdate_Click(objectsender,EventArgse){if(()!=""){if((GetEvaluation())>0){("修改员工考评信息成功","修改员工考评信息",,);=(());Init();}else{("修改员工考评信息失败","修改员工考评信息",,);}}else{("请选择一个员工的考评信息","修改员工考评信息",,);}}privatevoidbtnDelete_Click(objectsender,EventArgse){if(!(.Cells).Equals("")){if(((.Cells.()))>0){("删除员工考评信息成功","删除员工考评信息",,);=(());Init();}else{("删除员工考评信息失败","删除员工考评信息",,);}}else{("请选择一个员工的考评信息","删除员工考评信息",,);}}privatevoiddgvEmp_CellClick(objectsender,DataGridViewCellEventArgse){if(!=null&&>0){=.Cells.();=;=(.Cells.());=true;}}privatevoiddgvAssess_CellClick(objectsender,DataGridViewCellEventArgse){if(!=null&&>0){=.Cells.();=true;=true;=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);=(.Cells.Value);}}privatevoidbtnClean_Click(objectsender,EventArgse){Init();}数据访问类：publicclassBllExperience{publicBllExperience(){}//////增加一条数据///publicstaticintAdd(Experiencemodel){StringBuilderstrSql=newStringBuilder();("intoExperience(");("Position,Department,StartDate,EndDate,EmployeeNO,Remark");(")");("values(");(""++",");(""++",");(""++",");(""++",");(""++",");(""++"");(")");return(());}//////更新一条数据///publicstaticintUpdate(Experiencemodel){StringBuilderstrSql=newStringBuilder();("Experienceset");("Position="++",");("Department="++",");("StartDate="++",");("EndDate="++",");("EmployeeNO="++",");("Remark="++"");("WHEREExperience