34/34計算機(jī)畢業(yè)論文源代碼計算機(jī)畢業(yè)論文源代碼：會計信息生產(chǎn)社會化仿真系統(tǒng)1.折舊年限表(company_zjnx)建表源程序：CREATETABLE.((40)COLLATEChinese_PRC_CI_ASNULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL,(40)COLLATEChinese_PRC_CI_ASNULL,NULL)2.企業(yè)基本情況表(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.企業(yè)初始投資表(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)計算機(jī)畢業(yè)論文源代碼：企業(yè)人事管理系統(tǒng)的設(shè)計與實現(xiàn)各模塊實現(xiàn)的主要源代碼登錄模塊的設(shè)計與實現(xiàn)的主要代碼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;}檢查該員工是否應(yīng)該是系統(tǒng)用戶：return("SELECTLoginIDFROMLoginWHERELoginCode="+LoginrCode+"");檢查用戶編碼是否可以使用：return("SELECTLoginrCodeFROMLoginWHERELoginCode="+LoginrCode+"");通過LoginID查找相應(yīng)的密碼：return("SelectPasswordfromLoginWhereLoginID="+LoginID);員工管理模塊的設(shè)計與實現(xiàn)的主要代碼員工管理實現(xiàn)的主要代碼：publicclassBllAttendance{//////增加一條數(shù)據(jù)///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);}//////更新一條數(shù)據(jù)///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));}//////刪除一條數(shù)據(jù)///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(());}部門管理實現(xiàn)主要代碼：publicclassBLLDepartment{//////增加一條數(shù)據(jù)///publicstaticintAdd(Departmentmodel){StringBuilderstrSql=newStringBuilder();("intoDepartment(");("DepartNo,DepartName,DepartDesn,ParentID,Remark");(")");("values(");(""++",");(""++",");(""++",");(""++",");(""++"");(")");return(());}//////更新一條數(shù)據(jù)///publicstaticintUpdate(Departmentmodel){StringBuilderstrSql=newStringBuilder();("Departmentset");("DepartName="++",");("DepartDesn="++",");("ParentID="++",");("Remark="++"");("whereDepartNo="++"");return(());}//////刪除一條數(shù)據(jù)///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){("員工工資添加成功","員工工資維護(hù)",,);();}else{("員工工資添加失敗!!","員工工資維護(hù)",,);}}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){("員工工資添加成功","員工工資維護(hù)",,);();}else{("員工工資添加失敗!!","員工工資維護(hù)",,);}}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{("請選擇一個員工信息","刪除員工工資信息",,);}}}考勤信息設(shè)計與實現(xiàn)主要代碼：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();}數(shù)據(jù)訪問類：publicclassBllExperience{publicBllExperience(){}//////增加一條數(shù)據(jù)///publicstaticintAdd(Experiencemodel){StringBuilderstrSql=newStringBuilder();("intoExperience(");("Position,Department,StartDate,EndDate,EmployeeNO,Remark");(")");("values(");(""++",");(""++",");(""++",");(""++",");(""++",");(""++"");(")");return(());}//////更新一條數(shù)據(jù)///publicstaticintUpdate(Experiencemodel){StringBuilderstrSql=newStringBuilder();("Experienceset");("Position="++",");("Department="++",");("StartDate="++",");("EndDate="++",");("EmployeeNO="++",");("Remark="++"");("WHEREExperience