计算机毕业论文源代码计算机毕业论文源代码.doc计算机毕业论文源代码计算机毕业论文源代码:会计信息生产社会化仿真系统1.折旧年限表(pany_zjnx)建表源程序: CREATETABLE[dbo].[pany_zjnx]([cname][char](40)COLLATEChinese_PRC_CI_ASNULL, [obj_name][char](40)COLLATEChinese_PRC_CI_ASNULL, [zj_years][int]NULL,[zj_idea][char](40)COLLATEChinese_PRC_CI_ASNULL, [canzhi][float]NULL)2.企业基本情况表(pany_total)建表源程序: CREATETABLE[dbo].[pany_total]([_id][int]NOTNULL,[cname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL, [ccode][char](18)COLLATEChinese_PRC_CI_ASNULL, [rmoney][float]NULL,[faren][char](8)COLLATEChinese_PRC_CI_ASNULL, [cadd][char](40)COLLATEChinese_PRC_CI_ASNULL, [kinds][char](20)COLLATEChinese_PRC_CI_ASNULL, [act_area][text]COLLATEChinese_PRC_CI_ASNULL, [tel][char](12)COLLATEChinese_PRC_CI_ASNULL, [cell][char](11)COLLATEChinese_PRC_CI_ASNULL, [fax][char](12)COLLATEChinese_PRC_CI_ASNULL,[ccontent][char](8)COLLATEChinese_PRC_CI_ASNULL, [bank][char](30)COLLATEChinese_PRC_CI_ASNULL, [bank_num][char](18)COLLATEChinese_PRC_CI_ASNULL, [zz_num][char](12)COLLATEChinese_PRC_CI_ASNULL, [tax_num][char](15)COLLATEChinese_PRC_CI_ASNULL, [realmoney][float]NULL,[zz_years][int]NULL,[fz_date][char](8)COLLATEChinese_PRC_CI_ASNULL,[fz_jiguan][char](30)COLLATEChinese_PRC_CI_ASNULL, [hangye][char](10)COLLATEChinese_PRC_CI_ASNULL)3.企业初始投资表(pany_cstz)见表源程序: CREATETABLE[dbo].[pany_cstz]([cname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL, [cz_pro][char](40)COLLATEChinese_PRC_CI_ASNULL, [cz_money][real]NULL,[cz_man][char](20)COLLATEChinese_PRC_CI_ASNULL, [cz_code][char](10)COLLATEChinese_PRC_CI_ASNULL, [cz_date][char](10)COLLATEChinese_PRC_CI_ASNULL, [cz_percent][char](10)COLLATEChinese_PRC_CI_ASNULL, [extra][char](60)COLLATEChinese_PRC_CI_ASNULL)4.交易总表(contract_total)建表源程序: CREATETABLE[dbo].[contract_total]([y][char](10)COLLATEChinese_PRC_CI_ASNULL,[m][char](10)COLLATEChinese_PRC_CI_ASNULL,[d][char](10)COLLATEChinese_PRC_CI_ASNULL, [gname][char](40)COLLATEChinese_PRC_CI_ASNULL, [gtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL, [g_add][char](40)COLLATEChinese_PRC_CI_ASNULL, [gbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL, [obj_bh][char](10)COLLATEChinese_PRC_CI_ASNULL, [obj_name][char](20)COLLATEChinese_PRC_CI_ASNULL, [obj_dw][char](8)COLLATEChinese_PRC_CI_ASNULL, [obj_sl][int]NULL,[obj_dj][real]NULL,[jine][float]NULL,[tax_per][decimal](18,0)NULL,[taxe][float]NULL,[jshj][float]NULL,[xname][char](40)COLLATEChinese_PRC_CI_ASNULL, [xtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL, [x_add][char](40)COLLATEChinese_PRC_CI_ASNULL, [xbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL, [zj_years][int]NULL,[zj_idear][char](40)COLLATEChinese_PRC_CI_ASNULL, [canzhi][float]NULL,[pz_num][int]NULL,[zy][char](30)COLLATEChinese_PRC_CI_ASNULL)5.科目表(kmb)建表源程序:CREATETABLE[dbo].[kmb]([km_num][char](15)COLLATEChinese_PRC_CI_ASNULL, [km_name][char](26)COLLATEChinese_PRC_CI_ASNULL, [km_xzh][char](10)COLLATEChinese_PRC_CI_ASNULL, [jdfx][char](2)COLLATEChinese_PRC_CI_ASNULL, [km_jb][int]NULL)6.记账凭证表(jzpz)建表源程序:CREATETABLE[dbo].[jzpz]([y][char](10)COLLATEChinese_PRC_CI_ASNULL, [m][char](10)COLLATEChinese_PRC_CI_ASNULL,[d][char](10)COLLATEChinese_PRC_CI_ASNULL,[pz_num][int]NULL,[z_cname][char](40)COLLATEChinese_PRC_CI_ASNULL, [d_cname][char](40)COLLATEChinese_PRC_CI_ASNULL, [km_num][char](10)COLLATEChinese_PRC_CI_ASNULL, [km_name][char](26)COLLATEChinese_PRC_CI_ASNULL, [mxkm][char](26)COLLATEChinese_PRC_CI_ASNULL, [zy][char](30)COLLATEChinese_PRC_CI_ASNULL,[j_jine][float]NULL,[d_jine][float]NULL)7.时间维表(time_dim)建表源程序:CREATETABLE[dbo].[time_dim]([time_num][int]IDENTITY(1,1)NOTNULL,[y][char](10)COLLATEChinese_PRC_CI_ASNULL,[m][char](10)COLLATEChinese_PRC_CI_ASNULL,[d][char](10)COLLATEChinese_PRC_CI_ASNULL)8.货物维表(obj_dim)建表源程序:CREATETABLE[dbo].[obj_dim]([obj_num][int]IDENTITY(1,1)NOTNULL,[obj_bh][char](10)COLLATEChinese_PRC_CI_ASNOTNULL, [obj_name][char](20)COLLATEChinese_PRC_CI_ASNOTNULL, [obj_dw][char](8)COLLATEChinese_PRC_CI_ASNOTNULL, [obj_dj][real]NOTNULL)9.购货单位维表(g_dim)建表源程序:CREATETABLE[dbo].[g_dim]([g_num][int]IDENTITY(1,1)NOTNULL,[gname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL, [gtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL, [g_add][char](40)COLLATEChinese_PRC_CI_ASNULL, [gbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL)10.销货单位维表(x_dim)建表源程序:CREATETABLE[dbo].[x_dim]([x_num][int]IDENTITY(1,1)NOTNULL,[xname][char](40)COLLATEChinese_PRC_CI_ASNOTNULL,[xtax_num][char](15)COLLATEChinese_PRC_CI_ASNULL,[x_add][char](40)COLLATEChinese_PRC_CI_ASNULL,[xbank_num][char](18)COLLATEChinese_PRC_CI_ASNULL)11.交易事实表(contract_total)建表源程序:CREATETABLE[dbo].[contract_fact]([s_num][int]IDENTITY(1,1)NOTNULL,[g_num][int]NOTNULL,[x_num][int]NOTNULL,[time_num][int]NOTNULL,[obj_num][int]NOTNULL,[obj_sl][int]NOTNULL,[jine][float]NOTNULL,[tax_per][decimal](18,0)NOTNULL,[taxe][float]NOTNULL,[jshj][float]NOTNULL)计算机毕业论文源代码:企业人事管理系统的设计与实现各模块实现的主要源代码F1.1登录模块的设计与实现的主要代码if(tbxUserCode.Text.Trim()==““){BigMessageBox.Show(“请您输入用户或密码!!”,“警告”,MessageBoxButtons.OK,MessageBoxIcon.Stop);this.tbxUserCode.Text=““;this.tbxUserCode.Text=““;this.tbxUserCode.Focus();return;}else{EmployeeInfoemp=null;switch(User.LoginValidate(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(“用户密码错误!!”,“用户验证”,MessageBoxButtons.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,I sUsed,CreateName,CreateDatetime,RemarkFROMLogin“);strSql.Append(“whereLoginrCode=“+LoginrCode);Loginmodel=newLogin();DataTabledt=DbHelperSQL.Instance.GetDataTable(strSql.ToString());if(dt.Rows.Count>0){model.EmpNO=dt.Rows[0][“EmpNO”].ToString();model.LoginName=dt.Rows[0][“LoginName”].ToString();model.LoginrCode=dt.Rows[0][“LoginCode”].ToString();model.Password=dt.Rows[0][“Password”].To String();if(dt.Rows[0][“RoleID”].ToString()!=““){model.RoleID=int.Parse(dt.Rows[0][“RoleID”].ToString());}model.IsUsed=dt.Rows[0][“IsUsed”].ToString();model.CreateName=dt.Rows[0][“CreateName”].ToString();if(dt.Rows[0][“CreateDatetime”].ToString()!=““){model.CreateDatetime=DateTime.Parse(dt.Rows[0][“CreateDatetime”].ToString());}model.Remark=dt.Rows[0][“Remark”].ToString();returnmodel;}else{returnnull;}检查该员工是否应该是系统用户:returnDbHelperSQL.Instance.E xecuteScalar(“SELECTLoginIDFROMLogin WHERELoginCode=“+LoginrCode+““);检查用户编码是否可以使用:returnDbHelperSQL.Instance.ExecuteScalar(“SELECTLoginrCodeFROMLo ginWHERELoginCode=“+LoginrCode+““);通过LoginID查找相应的密码:returnDbHelperSQL.Instance.ExecuteScalar(“SelectPassword fromLogin WhereLoginID=“+LoginID);F1.3员工管理模块的设计与实现的主要代码F1.3.1员工管理实现的主要代码:publicclassBllAttendance{//////增加一条数据///publicstaticintAdd(Attendancemodel,DbTransactiontrans){StringBuildersb=newStringBuilder();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,@Le ave,@A bsent,@Overtime,@NotIn,@NotOut,@Outgo,”);sb.Append(“@WorkOut,@WorkTime,@NumCount,@In,@Out,@Artificial,@Wo rk,@Illness,@Thing,@Family)”);returnDbHelperSQL.Instance.ExcuteTransNonQuery(sb.ToString(),DbHe lperSQL.Instance.CreateParamters(sb.ToString(),model),trans);}//////更新一条数据///publicstaticintUpdate(Attendancemodel){StringBuildersb=newStringBuilder();sb.Append(“UPDATEAttendanceSETAdsum=@Adsum,Fact=@Fact,Late=@Late ,Leave=@Leave,Absent=@Absent,Overtime=@Overtime,”);sb.Append(“NotIn=@NotIn,NotOu t=@NotOut,Outgo=@Outgo,WorkOut=@Wor kOut,WorkTime=@WorkTime,NumCount=@NumCount,”);sb.Append(“[In]=@In,Artificial=@Artificial,Out=@Out,[Work]=@Work ,Illness=@Illness,Thing=@Thing,Family=@FamilyWHEREEmpNo=@EmpNo”);returnDbHelperSQL.Instance.ExcuteNonQuery(sb.ToString(),DbHelperS QL.Instance.CreateParamters(sb.ToString(),model));}//////删除一条数据///publicstaticintDelete(stringEmpNo){StringBuildersb=newStringBuilder();sb.Append(String.Format(“DELETEFROMAttendanceWHEREEmpNo={0}”,Em pNo));returnDbHelperSQL.Instance.ExcuteNonQuery(sb.ToString());}publicstaticDataTableGetAttenddanceDataTable(){StringBuildersb=newStringBuilder();sb.Append(“SELECTAttenDate,EmpNo,Adsum,Fact,Late,Leave,Absent,Ov ertime,NotIn,NotOut,”);sb.Append(“Outgo,WorkOu t,WorkTime,NumCount,[In],Out,Artificial,[ Work],Illness,Thing,FamilyFROMAttendance“);returnDbHelperSQL.Instance.GetDataTable(sb.ToString());}F1.3.2部门管理实现主要代码:publicclassBLLDepartment{//////增加一条数据///publicstaticintAdd(Departmentmodel){StringBuilderstrSql=newStringBuilder();strSql.Append(“intoDepartment(“);strSql.Append(“DepartNo,DepartName,DepartDesn,ParentID,Remark”);strSql.Append(“)”);strSql.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()); }//////更新一条数据///publicstaticintUpdate(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(“whereDepartNo=“+model.DepartNo+““); returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString()); }//////删除一条数据///publicstaticintDelete(stringDepartNo){StringBuilderstrSql=newStringBuilder();strSql.Append(“Department“);strSql.Append(“whereDepartNo=“+DepartNo+““);returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString());}//////得到一个对象实体///publicstaticDepartmentGeDepartment(stringDepartNo){StringBuilderstrSql=newStringBuilder();strSql.Append(“SELECTDepartNo,DepartName,DepartDesn,ParentID,Rem arkFROMDepartment”);strSql.Append(“WHEREDepartNo=“+DepartNo);Departmentmodel=newDepartment();DataTabledt=DbHelperSQL.Instance.GetDataTable(strSql.ToString());if(dt.Rows.Count>0){model.De partNo=dt.Rows[0][“DepartNo”].ToString();model.DepartName=dt.Rows[0][“DepartName”].ToString();model.DepartDesn=dt.Rows[0][“DepartDesn”].ToString();if(dt.Rows[0][“ParentID”].ToString()!=““){model.ParentID=int.Parse(dt.Rows[0][“ParentID”].ToString());}model.Remark=dt.Rows[0][“Remark”].ToString();returnmodel;}else{returnnull;}}publicstaticstringGetDepartmentIDIsNull(intempID){returnDbHelperSQL.Instance.ExecuteScalar(“SELECTDepartmentIDFROM EmployeeWHEREDepartmentID=“+empID+““);}}F1.3.3工资管理主要代码:publicpartialclassUcPay:UserControl{privatestringempNo=““;publicUcPay(){Initializeponent();}privatevoidbtnExit_Click(objectsender,EventArgse){(this.ParentasPanel).Controls.Clear();}privatevoidbtnAdd_Click(objectsender,EventArgse){if(BLLGongZ.Add(GetGongZ())>0){BigMessageBox.Show(“员工工资添加成功”,“员工工资维护”,MessageBoxButtons.OK,rmation);this.Bind();}else{BigMessageBox.Show(“员工工资添加失败!!”,“员工工资维护”,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(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(txtJBGZ.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.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,DataGridViewCellEventArgs e){if(dgEmp.DataSource!=null&&dgEmp.Rows.Count>0){if(e.RowIndex!=-1){empNo=this.dgEmp.Rows[e.RowIndex].Cells[0].Value.ToString();this.Bind();}}}privatevoidbtnUpdate_Click(objectsender,EventArgse){if(BLLGongZ.Update(GetGongZ())>0){BigMessageBox.Show(“员工工资添加成功”,“员工工资维护”,MessageBoxButtons.OK,rmation);this.Bind();}else{BigMessageBox.Show(“员工工资添加失败!!”,“员工工资维护”,MessageBoxButtons.OK,MessageBoxIcon.Stop);}}privatevoidBind(){this.dgvSalaryItem.DataSource=BLLGongZ.GetGongZ(empNo);}privatevoiddgvSalaryItem_CellClick(objectsender,DataGridViewCellE ventArgse){if(dgvSalaryItem.DataSource!=null&&dgvSalaryItem.Rows.Count>0) {if(e.RowIndex!=-1){empNo=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“empID”].Value. ToString();cboMonth.SelectedValue=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“MonthID”].Value;txtGBGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“GBGZ”]. Value.ToString();txtFZYJ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“FZYJ”]. Value.ToString();txtXSTC.Tex t=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“XSTC”]. Value.ToString();txtBJGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“BJGZ”]. Value.ToString();txtJXGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“JXGZ”]. Value.ToString();txtSJGZ.Text=this.dgvSal aryItem.Rows[e.RowIndex].Cells[“SJGZ”]. Value.ToString();txtJLGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“JLGZ”]. Value.ToString();txtYLBX.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“YLBX”]. Value.ToString();txtJBGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“JBGZ”].Value.ToString();txtZSGZ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“ZSGZ”]. Value.ToString();txtQQJJ.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“QQJJ”]. Value.ToString();txtGSKF.Text=this.dgvSalaryItem.Rows[e.RowIndex].C ells[“GSKF”]. Value.ToString();ttxtOTHER.Text=this.dgvSalaryItem.Rows[e.RowIndex].Cells[“OTHER ”].Value.ToString();}}}privatevoidbtnDelete_Click(objectsender,EventArgse){if(empNo!=““){if(BigMessageBox.Show(“您确定要删除员工基本信息吗?”,“删除员工工资信息”,MessageBoxButto ns.OKCancel,MessageBoxIcon.Question)==DialogResul t.OK){if(BLLGongZ.Delete(empNo)>0){BigMessageBox.Show(“删除员工工资信息成功”,“删除员工工资信息”,MessageBoxButtons.OK,rmation);this.Bind();}else{BigMessageBox.Show(“删除员工考评信息失败”,“删除员工工资信息”,MessageBoxButtons.OK,rmation);}}}else{BigMessageBox.Show(“请选择一个员工信息”,“删除员工工资信息”,MessageBoxButtons.OK,rmation);}}}F1.3.4考勤信息设计与实现主要代码:privatevoidbtnAdd_Click(objectsender,EventArgse){if(BllEvaluation.Add(GetEvaluation())>0){BigMessageBox.Show(“添加员工考评信息成功”,“添加员工考评信息”,MessageBoxButtons.OK,rmation);Bind();Init();}else{BigMessageBox.Show(“添加员工考评信息失败”,“添加员工考评信息”,MessageBoxButtons.OK,rmation);}}privateEvaluationGetEvaluation(){Evaluationmodel=newEvaluation();if(Utilities.ConvertNullToSpace(cboMonth.SelectedValue)!=““){model.EvaMonth=Utilities.ConvertInt(cboMonth.SelectedValue.ToStri ng());}if(Utilities.ConvertNullToSpace(cboGrade.SelectedValue)!=““){model.MarkDegreeID=Utilities.ConvertInt(cboGrade.SelectedValue.To String());}model.Invigilater=txtPerson.Text;model.EmployeeNO=labEmpID.Text.Trim();model.Mark=Utilities.ConvertInt(this.txtNumber.Text);model.Remark=this.txtRemark.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(“修改员工考评信息成功”,“修改员工考评信息”,MessageBoxButtons.OK,rmation);this.dgvAssess.DataSource=BoxDataTable.GetAssessTable(labEmpID.Te xt.Trim());Init();}else{BigMessageBox.Show(“修改员工考评信息失败”,“修改员工考评信息”,MessageBoxButtons.OK,rmation);}}else{BigMessageBox.Show(“请选择一个员工的考评信息”,“修改员工考评信息”,MessageBoxBut tons.OK,rmation);}}privatevoidbtnDelete_Click(objectsender,EventArgse){if(!Utilities.ConvertNullToSpace(this.dgvAssess.Rows[this.dgvAsse ss.CurrentRow.Index].Cells[“EvaluationID”]).Equals(““)) {if(BllEvaluation.Delete(Utilities.ConvertInt(this.dgvAssess.Rows[ this.dgvAssess.CurrentRow.Index].Cells[“EvaluationID”].Value.ToStri ng()))>0){BigMessageBox.Show(“删除员工考评信息成功”,“删除员工考评信息”,MessageBoxButtons.OK,rmation);this.dgvAssess.DataSource=BoxDataTable.GetAssessTable(labEmpID.Te xt.Trim());Init();}else{BigMessageBox.Show(“删除员工考评信息失败”,“删除员工考评信息”,MessageBoxButtons.OK,rmation);}}else{BigMessageBox.Show(“请选择一个员工的考评信息”,“删除员工考评信息”,MessageBoxButtons.OK,rmation);}}privatevoiddgvEmp_CellClick(objectsender,DataGridViewCellEventArg se){if(dgvEmp.DataSource!=null&&dgvEmp.Rows.Count>0){labEmpID.Text=this.dgvEmp.Rows[e.RowIndex].Cells[“EmployeeNO”]. Value.ToString();this.dgvAssess.SelectionMode=DataGridViewSelectionMode.FullRowSel ect;this.dgvAssess.DataSource=BoxDataTable.GetAssessTable(this.dgvEmp .Rows[e.RowIndex].Cells[“EmployeeNO”].Value.ToString());this.btnAdd.Enabled=true;}}privatevoiddgvAssess_CellClick(objectsender,DataGridViewCellEvent Argse){if(dgvAssess.DataSource!=null&&dgvAssess.Rows.Count>0){labID.Text=this.dgvAssess.Rows[e.RowIndex].Cells[“EvaluationID”].Value.ToString();this.btnUpdate.Enabled=true;this.btnDelete.Enabled=true;this.txtNumber.Text=Utilities.ConvertNullToSpace(this.dgvAssess.R ows[e.RowIndex].Cells[“Mark”].Value);this.txtProject.Text=Utilities.ConvertNullToSpace(this.dgvAssess. Rows[e.RowIndex].Cells[“Subject”].Value);this.txtRemark.Text=Utilities.ConvertNullToSpace(this.dgvAssess.R ows[e.RowIndex].Cells[“Remark”].Value);this.txtResult.Text=Utilities.ConvertNullToSpace(this.dgvAssess.R ows[e.RowIndex].Cells[“Result”].Value);this.cboGrade.Text=Utilities.ConvertNullToSpace(this.dgvAssess.Ro ws[e.RowIndex].Cells[“MarkDegreeID”].Value);this.cboMonth.Text=Utilities.ConvertNullToSpace(this.dgvAssess.Ro ws[e.RowIndex].Cells[“EvaMonth”].Value);this.txtPerson.Text=Utilities.ConvertNullToSpace(this.dgvAssess.R ows[e.RowIndex].Cells[“Invigilater”].Value);}}privatevoidbtnClean_Click(objectsender,EventArgse){Init();F1.4数据访问类:publicclassBllExperience{publicBllExperience(){}//////增加一条数据///publicstaticintAdd(Experiencemodel){StringBuilderstrSql=newStringBuilder();strSql.Append(“intoExperience(“);strSql.Append(“Posi tion,Department,StartDate,EndDate,EmployeeNO, Remark”);strSql.Append(“)”);strSql.Append(“values(“);strSql.Append(““+model.Position+“,”);strSql.Append(““+model.Department+“,”);strSql.Append(““+model.StartDate+“,”);strSql.Append(““+model.EndDate+“,”);strSql.Append(““+model.EmployeeNO+“,”);strSql.Append(““+model.Remark+““);strSql.Append(“)”);returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString());}///更新一条数据///publicstaticintUpdate(Experiencemodel){StringBuilderstrSql=newStringBuilder();strSql.Append(“Experienceset“);strSql.Append(“Position=“+model.Position+“,”);strSql.Append(“Department=“+model.Department+“,”);strSql.Append(“StartDate=“+model.StartDate+“,”);strSql.Append(“EndDate=“+model.EndDate+“,”);strSql.Append(“EmployeeNO=“+model.EmployeeNO+“,”);strSql.Append(“Remark=“+model.Remark+““);strSql.Append(“WHEREExperienceID=“+model.ExperienceID+““); returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString()); }//////删除一条数据///publicstaticintDelete(intExperienceID){StringBuilderstrSql=newStringBuilder();strSql.Append(“Experience“);strSql.Append(“whereExperienceID=“+ExperienceID); returnDbHelperSQL.Instance.ExcuteNonQuery(strSql.ToString());//////得到一个对象实体///publicExperienceGetModel(intExperienceID){StringBuilderstrSql=newStringBuilder();strSql.Append(“select“);strSql.Append(“[ExperienceID],[Position],[Department],[StartDate ],[EndDate],[EmployeeID],[Remark]“);strSql.Append(“fromExperience“);strSql.Append(“whereExperienceID=“+ExperienceID);Experiencemodel=newExperience();DataTabledt=DbHelperSQL.Instance.GetDataTable(strSql.ToString());model.ExperienceID=ExperienceID;if(dt.Rows.Count>0){model.Position=dt.Rows[0][“Position”].ToString();model.Departmen t=dt.Rows[0][“Department”].ToString();if(dt.Rows[0][“StartDate”].ToString()!=““){model.StartDate=DateTime.Parse(dt.Rows[0][“StartDate”].ToString ());}if(dt.Rows[0][“EndDate”].ToString()!=““)model.EndDate=DateTime.Parse(dt.Rows[0][“EndDate”].ToString());}if(dt.Rows[0][“EmployeeID”].ToString()!=““){model.EmployeeNO=dt.Rows[0][“EmployeeID”].ToString();}model.Remark=dt.Rows[0][“Remark”].ToString();returnmodel;}else{returnnull;}}}F1.5生日提醒主要代码:获得当天生日的员工名称StringBuildersb=newStringBuilder();sb.Append(“SELECTEmployNameFROMEMPLOYEE“);sb.Append(“WHERECAST(MONTH(BIRTHDAY)ASVARCHAR(2))+CAST(DAY(BIRTH DAY)ASVARCHAR(2))=CAST(MONTH(GETDATE())ASVARCHAR(2))+CAST(DAY(GETDATE ())ASVARCHAR(2))”);returnDbHelperSQL.Instance.GetDataTable(sb.ToString());F1.6启动第三方EXE文件操作类:publicclassTools{//////启动数据库备份///publicstaticvoidDataBak(){System.Diagnostics.Process.Start(“BACKUP.exe”); }//////计算器///publicstaticvoidputer(){System.Diagnostics.Process.Start(“calc.exe”);}//////启动画图工具///publicstaticvoidImg(){System.Diagnostics.Process.Start(“mspaint.exe”); }//////记事本///publicstaticvoidOpenNotepad(){System.Diagnostics.Process.Start(“Notepad.exe”); }}[计算机毕业论文源代码]。
