计算机毕业论文源代码

计算机毕业论文源代码
计算机毕业论文源代码.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”); }
}
[计算机毕业论文源代码]。