/// <summary> /// 修改员工信息(全部10张表信息) /// </summary> /// <param name="empModel">员工类实体</param> /// <returns>返回执行影响行数,大于0就执行成功</returns> public int UpdateEmpInfo(EmpModel empModel,int intEmpID) { if (aedal == null) aedal = new A_AddEmpDAL(); return aedal.UpdateEmpInfo(empModel,intEmpID); }
/// <summary> /// 增加员工信息(全部10张表信息) /// </summary> /// <param name="empModel">员工类实体</param> /// <returns>返回执行影响行数,大于0就执行成功</returns> public int InsertEmpInfo(EmpModel empModel) { if (aedal == null) aedal = new A_AddEmpDAL(); return aedal.InsertEmpInfo(empModel); }
/// <summary> /// 修改员工信息(全部10张表信息) /// </summary> /// <param name="empModel">员工类实体</param> /// <returns>返回执行影响行数,大于0就执行成功</returns> public int UpdateEmpInfo(EmpModel empModel) { //if (aedal == null) // aedal = new AddEmpDAL(); //return aedal.UpdateEmpInfo(empModel); return 0; }
/// <summary> /// 增加员工信息(全部10张表信息) /// </summary> /// <param name="empModel">员工类实体</param> /// <returns>返回执行影响行数,大于0就执行成功</returns> public int InsertEmpInfo(EmpModel empModel) { //if (aedal == null) // aedal = new AddEmpDAL(); //return aedal.InsertEmpInfo(empModel); return 0; }
/// <summary> /// 增加保存员工信息(全部10张表的信息) /// </summary> /// <param name="empModel">员工类实体,包含全部表信息</param> /// <returns>返回执行影响的行数</returns> public int InsertEmpInfo(EmpModel empModel) { SqlParameter[] para = new SqlParameter[] { #region[Emp_Info 员工基本信息表] new SqlParameter("@EmpName",SqlDbType.NVarChar,20), new SqlParameter("@Sex",SqlDbType.Bit), new SqlParameter("@Remark",SqlDbType.NVarChar,200), new SqlParameter("@EmpNO",SqlDbType.NVarChar,10), new SqlParameter("@DeptID",SqlDbType.Int), new SqlParameter("@DutyID",SqlDbType.Int), new SqlParameter("@MaxSecTime",SqlDbType.Int), new SqlParameter("@MinSecTime",SqlDbType.Int), new SqlParameter("@Selectmode",SqlDbType.Int), new SqlParameter("@ClassGroup",SqlDbType.NVarChar,50), new SqlParameter("@WorkPlace",SqlDbType.NVarChar,50), new SqlParameter("@Photo",SqlDbType.Image), new SqlParameter("@Nation",SqlDbType.NVarChar,30), new SqlParameter("@Wedlock",SqlDbType.NVarChar,50), new SqlParameter("@Clan",SqlDbType.NVarChar,50), new SqlParameter("@NativePlace",SqlDbType.NVarChar,50), new SqlParameter("@CensusRegister",SqlDbType.NVarChar,50), new SqlParameter("@SchoolRecord",SqlDbType.NVarChar,50), new SqlParameter("@GraduateFrom",SqlDbType.NVarChar,35), new SqlParameter("@Specialty",SqlDbType.NVarChar,50), new SqlParameter("@OfficialDesignation",SqlDbType.NVarChar,50), new SqlParameter("@Idcard",SqlDbType.NVarChar,20), new SqlParameter("@BirthDay",SqlDbType.DateTime), new SqlParameter("@Height",SqlDbType.Int), new SqlParameter("@Weight",SqlDbType.Int), new SqlParameter("@StateOfHealth",SqlDbType.NVarChar,50), new SqlParameter("@HomeTel1",SqlDbType.NVarChar,20), new SqlParameter("@HomeTel2",SqlDbType.NVarChar,20), new SqlParameter("@HomeAddress",SqlDbType.NVarChar,250), new SqlParameter("@Postalcode",SqlDbType.NVarChar,6), new SqlParameter("@ProbationDate",SqlDbType.DateTime), new SqlParameter("@OfficiallyDate",SqlDbType.DateTime), new SqlParameter("@ContractExpDate",SqlDbType.DateTime), new SqlParameter("@ContractExpAppendDate",SqlDbType.DateTime), new SqlParameter("@IsGearShift",SqlDbType.Bit), new SqlParameter("@HireTypeID",SqlDbType.Int), new SqlParameter("@Archives",SqlDbType.NVarChar,100), new SqlParameter("@DimissionTime",SqlDbType.DateTime), new SqlParameter("@EmpDetailRemark",SqlDbType.NVarChar,200), new SqlParameter("@EmpSerchRemark",SqlDbType.NVarChar,200), new SqlParameter("@EmpHomeRemark",SqlDbType.NVarChar,200), new SqlParameter("@EmpInCompanyRemark",SqlDbType.NVarChar,200), new SqlParameter("@EmpNowCompanyRemark",SqlDbType.NVarChar,200), new SqlParameter("@WorkTypeID1",SqlDbType.Int), new SqlParameter("@IsMostly1",SqlDbType.Bit), new SqlParameter("@IsEnable1",SqlDbType.Bit), new SqlParameter("@blood ",SqlDbType.NVarChar,20), new SqlParameter("@ID",SqlDbType.Int), new SqlParameter("@DeptName",SqlDbType.NVarChar,50), new SqlParameter("@DutyName",SqlDbType.NVarChar,50), new SqlParameter("@WorkTypeName",SqlDbType.NVarChar,50) #endregion }; para[0].Value = empModel.EmpName; para[1].Value = empModel.Sex; para[2].Value = empModel.BaseRemark; para[3].Value = empModel.EmpNO; para[4].Value = empModel.DeptID; para[5].Value = empModel.DutyID; para[6].Value = empModel.MaxSecTime; para[7].Value = empModel.MinSecTime; para[8].Value = empModel.SelectMode; para[9].Value = empModel.ClassGroup; para[10].Value = empModel.WorkPlace; para[11].Value = empModel.Photo; para[12].Value = empModel.Nation; para[13].Value = empModel.Wedlock; para[14].Value = empModel.Clan; para[15].Value = empModel.NativePlace; para[16].Value = empModel.CensusRegister; para[17].Value = empModel.SchoolRecord; para[18].Value = empModel.GraduateFrom; para[19].Value = empModel.Specialty; para[20].Value = empModel.OfficialDesignation; para[21].Value = empModel.IdCard; para[22].Value = empModel.BirthDay; para[23].Value = empModel.Height; para[24].Value = empModel.Weight; para[25].Value = empModel.StateOfHealth; para[26].Value = empModel.HomeTel1; para[27].Value = empModel.HomeTel2; para[28].Value = empModel.HomeAddress; para[29].Value = empModel.PostalCode; para[30].Value = empModel.ProbationDate; para[31].Value = empModel.OfficiallyDate; para[32].Value = empModel.ContractExpDate; para[33].Value = empModel.ContractExpAppendDate; para[34].Value = empModel.IsGearShift; para[35].Value = empModel.HireTypeID; para[36].Value = empModel.Archives; para[37].Value = empModel.DimissionTime; para[38].Value = empModel.DetailRemark; para[39].Value = empModel.SearchRemark; para[40].Value = empModel.HomeRemark; para[41].Value = empModel.InCompanyRemark; para[42].Value = empModel.NowCompanyRemark; para[43].Value = empModel.WorkType1.WorkTypeID; para[44].Value = 1;// empModel.WorkType1.IsMostly; para[45].Value = 1;// empModel.WorkType1.IsEnable; para[46].Value = empModel.Company; para[47].Value = empModel.EmpNO.GetHashCode(); para[48].Value = empModel.DeptName; para[49].Value = empModel.DutyName; para[50].Value = empModel.WorkType1.WorkTypeName; return dba.ExecuteSql("A_zjw_Emp_Insert", para); }
/// <summary> /// 修改 员工信息 /// </summary> private void UpDateEmployee() { #region 实例化员工类并赋值 //EmpModel empModel = new EmpModel(); ////员工基本信息 //empModel.EmpNO = textBox_EmployeeNO.Text; //empModel.EmpName = textBox_EmplyeeName.Text; //empModel.Sex = Convert.ToBoolean(comboBox_EmployeeSex.SelectedValue); //empModel.BaseRemark = textBox_EmployeeDemo.Text; ////员工详细信息 //string strEmpBirDay; //if (cb_EmpBirthDay.Checked) //{ // strEmpBirDay = dtp_EmpBirthDay.Value.ToString(); //} //else //{ // strEmpBirDay = "1900-1-1 00:00:01"; //} //empModel.Nation = textBox_EmployeeNation.Text; //empModel.NativePlace = textBox_EmployeeNativePlace.Text; //empModel.Wedlock = comboBox_EmployeeWedlock.SelectedText; //empModel.Clan = comboBox_EmployeeClan.SelectedText; //empModel.CensusRegister = textBox_EmployeeCensusRegister.Text; //empModel.SchoolRecord = comboBox_EmployeeSchoolRecord.SelectedText; //empModel.GraduateFrom = textBox_EmployeeGraduateFrom.Text; //empModel.Specialty = textBox_EmployeeSpecialty.Text; //empModel.OfficialDesignation = textBox_EmployeeOfficialDesignation.Text; //empModel.BirthDay = Convert.ToDateTime(strEmpBirDay); //empModel.IdCard = textBox_EmployeeIdentityCard.Text; //empModel.Company = txt_Company.Text; ////员工联系方式信息 //empModel.EmpTel1 = textBox_EmployeeTel1.Text; //empModel.EmpTel2 = textBox_EmployeeTel2.Text; ////员工健康信息 //if (textBox_EmpHeight.Text.Equals("")) //{ // empModel.Height = 0; //} //else //{ // empModel.Height = Convert.ToInt32(textBox_EmpHeight.Text); //} //if (textBox_EmpWeight.Text.Equals("")) //{ // empModel.Weight = 0; //} //else //{ // empModel.Weight = Convert.ToInt32(textBox_EmpWeight.Text); //} ////empModel.Weight = Convert.ToInt32(textBox_EmpWeight.Text); //empModel.StateOfHealth = textBox_EmpStateOfHealth.Text; ////员工家庭信息 //empModel.HomeAddress = textBox_EmployeeHomeAddress.Text; //#region 为员工试用日期,员工转正日期,合同有效期,续签有效期,离职日期赋值 //string strEmpProDate, strEmpOffDate, strEmpConExpDate, strEmpConExpAppDate, strEmpDimTime; //if (cb_EmployeeProbationDate.Checked) //{ // strEmpProDate = dtp_EmployeeProbationDate.Value.ToString(); //} //else //{ // strEmpProDate = "1900-1-1 00:00:01"; //} //if (cb_EmployeeOfficiallyDate.Checked) //{ // strEmpOffDate = dtp_EmployeeOfficiallyDate.Value.ToString(); //} //else //{ // strEmpOffDate = "1900-1-1 00:00:01"; //} //if (cb_EmployeeContractExpDate.Checked) //{ // strEmpConExpDate = dtp_EmployeeContractExpDate.Value.ToString(); //} //else //{ // strEmpConExpDate = "1900-1-1 00:00:01"; //} //if (cb_EmployeeContractExpAppendDate.Checked) //{ // strEmpConExpAppDate = dtp_EmployeeContractExpAppendDate.Value.ToString(); //} //else //{ // strEmpConExpAppDate = "1900-1-1 00:00:01"; //} //if (cb_EmployeeDimissionTime.Checked) //{ // strEmpDimTime = dtp_EmployeeDimissionTime.Value.ToString(); //} //else //{ // strEmpDimTime = "1900-1-1 00:00:01"; //} //#endregion ////员工进公司信息 //empModel.ProbationDate = Convert.ToDateTime((strEmpProDate)); //empModel.OfficiallyDate = Convert.ToDateTime(strEmpOffDate); //empModel.ContractExpDate = Convert.ToDateTime(strEmpConExpDate); //empModel.ContractExpAppendDate = Convert.ToDateTime(strEmpConExpAppDate); //empModel.IsGearShift = checkbox_EmployeeGearShift.Checked; //empModel.HireTypeID = Convert.ToInt32(combobox_EmployeeHireType.SelectedValue); //empModel.Archives = textBox_EmployeeArchives.Text; //empModel.DimissionTime = Convert.ToDateTime(strEmpDimTime); ////员工在公司信息 //empModel.DeptID = Convert.ToInt32(comboBox_EmployeeDepartment.SelectedValue); //empModel.DutyID = Convert.ToInt32(combobox_EmployeeDuty.SelectedValue); //empModel.MaxSecTime = (Convert.ToInt32(textBox_EmpMaxHour.Text) * 3600) // + (Convert.ToInt32(textBox_EmpMaxMinute.Text) * 60) // + Convert.ToInt32(textBox_EmpMaxSecond.Text); //empModel.MinSecTime = (Convert.ToInt32(textBox_EmpMinHour.Text) * 3600) // + (Convert.ToInt32(textBox_EmpMinMinute.Text) * 60) // + Convert.ToInt32(textBox_EmpMinSecond.Text); //int intSelectMode; //if (rdb_Dept.Checked) //{ // intSelectMode = 1; //} //else if (rdb_Emp.Checked) //{ // intSelectMode = 2; //} //else //{ // intSelectMode = 3; //} //empModel.SelectMode = intSelectMode; //empModel.ClassGroup = textBox_EmpGroup.Text.Trim(); //empModel.WorkPlace = textBox_EmpWorkPlace.Text.Trim(); ////员工照片信息 //if (bPhoto != null) //{ // empModel.Photo = bPhoto; //} ////员工工种信息 ////工种1 //EmpWorkType empWorkType1 = new EmpWorkType(); //if (Convert.ToInt32(comboBox_EmpWorkTypeName.SelectedValue) != 0) //{ // empWorkType1.WorkTypeID = Convert.ToInt32(comboBox_EmpWorkTypeName.SelectedValue); // empWorkType1.IsMostly = true; // empWorkType1.IsEnable = true; // empModel.WorkType1 = empWorkType1; //} #endregion EmpModel empModel = new EmpModel(); empModel = SetEmpModel(); int result = aebll.UpdateEmpInfo(empModel,tempEmpID); if (result > 0) { //Czlt-2011-12-10 跟新配置时间 aebll.UpdateTime(); //存入日志 LogSave.Messages("[A_FrmEmpInfo]", LogIDType.UserLogID, "修改员工信息,姓名:" + textBox_EmplyeeName.Text + ",编号:" + textBox_EmployeeNO.Text.Trim() + "。"); this.SetTipsInfo(lb_EmpTipsInfo, true, "修改成功!"); strEmpNO = textBox_EmployeeNO.Text.Trim(); } else { this.SetTipsInfo(lb_EmpTipsInfo, false, "修改失败!"); } }
/// <summary> /// 向数据库中添加 员工信息 /// </summary> private void SaveEmployeeData() { EmpModel empModel = new EmpModel(); empModel = SetEmpModel(); int result = aebll.InsertEmpInfo(empModel); if (result > 0) { //Czlt-2011-12-10 跟新配置时间 aebll.UpdateTime(); //存入日志 LogSave.Messages("[A_FrmEmpInfo]", LogIDType.UserLogID, "增加员工信息,姓名:" + textBox_EmplyeeName.Text + ",编号:" + textBox_EmployeeNO.Text.Trim() + "。"); this.SetTipsInfo(lb_EmpTipsInfo, true, "保存成功!"); } else { this.SetTipsInfo(lb_EmpTipsInfo, false, "保存失败!"); } }
private EmpModel SetEmpModel() { #region 实例化员工类并赋值 EmpModel empModel = new EmpModel(); //员工基本信息 empModel.EmpNO = textBox_EmployeeNO.Text; empModel.EmpName = textBox_EmplyeeName.Text; empModel.Sex = Convert.ToBoolean(comboBox_EmployeeSex.SelectedValue); empModel.BaseRemark = textBox_EmployeeDemo.Text; //员工详细信息 string strEmpBirDay; if (cb_EmpBirthDay.Checked) { strEmpBirDay = dtp_EmpBirthDay.Value.ToString(); } else { strEmpBirDay = "1900-1-1 00:00:01"; } empModel.Nation = textBox_EmployeeNation.Text; empModel.NativePlace = textBox_EmployeeNativePlace.Text; empModel.Wedlock = comboBox_EmployeeWedlock.Text; empModel.Clan = comboBox_EmployeeClan.Text; empModel.CensusRegister = textBox_EmployeeCensusRegister.Text; empModel.SchoolRecord = comboBox_EmployeeSchoolRecord.Text; empModel.GraduateFrom = textBox_EmployeeGraduateFrom.Text; empModel.Specialty = textBox_EmployeeSpecialty.Text; empModel.OfficialDesignation = textBox_EmployeeOfficialDesignation.Text; empModel.BirthDay = Convert.ToDateTime(strEmpBirDay); empModel.IdCard = textBox_EmployeeIdentityCard.Text; empModel.Company = txt_Company.Text; //员工联系方式信息 empModel.HomeTel1 = textBox_EmployeeTel1.Text; empModel.HomeTel2 = textBox_EmployeeTel2.Text; //员工健康信息 if (textBox_EmpHeight.Text.Equals("")) { empModel.Height = 0; } else { empModel.Height = Convert.ToInt32(textBox_EmpHeight.Text); } if (textBox_EmpWeight.Text.Equals("")) { empModel.Weight = 0; } else { empModel.Weight = Convert.ToInt32(textBox_EmpWeight.Text); } //empModel.Weight = Convert.ToInt32(textBox_EmpWeight.Text); empModel.StateOfHealth = textBox_EmpStateOfHealth.Text; //员工家庭信息 empModel.HomeAddress = textBox_EmployeeHomeAddress.Text; #region 为员工试用日期,员工转正日期,合同有效期,续签有效期,离职日期赋值 string strEmpProDate, strEmpOffDate, strEmpConExpDate, strEmpConExpAppDate, strEmpDimTime; if (cb_EmployeeProbationDate.Checked) { strEmpProDate = dtp_EmployeeProbationDate.Value.ToString(); } else { strEmpProDate = "1900-1-1 00:00:01"; } if (cb_EmployeeOfficiallyDate.Checked) { strEmpOffDate = dtp_EmployeeOfficiallyDate.Value.ToString(); } else { strEmpOffDate = "1900-1-1 00:00:01"; } if (cb_EmployeeContractExpDate.Checked) { strEmpConExpDate = dtp_EmployeeContractExpDate.Value.ToString(); } else { strEmpConExpDate = "1900-1-1 00:00:01"; } if (cb_EmployeeContractExpAppendDate.Checked) { strEmpConExpAppDate = dtp_EmployeeContractExpAppendDate.Value.ToString(); } else { strEmpConExpAppDate = "1900-1-1 00:00:01"; } if (cb_EmployeeDimissionTime.Checked) { strEmpDimTime = dtp_EmployeeDimissionTime.Value.ToString(); } else { strEmpDimTime = "1900-1-1 00:00:01"; } #endregion //员工进公司信息 empModel.ProbationDate = Convert.ToDateTime((strEmpProDate)); empModel.OfficiallyDate = Convert.ToDateTime(strEmpOffDate); empModel.ContractExpDate = Convert.ToDateTime(strEmpConExpDate); empModel.ContractExpAppendDate = Convert.ToDateTime(strEmpConExpAppDate); empModel.IsGearShift = checkbox_EmployeeGearShift.Checked; empModel.HireTypeID = Convert.ToInt32(combobox_EmployeeHireType.SelectedValue); empModel.Archives = textBox_EmployeeArchives.Text; empModel.DimissionTime = Convert.ToDateTime(strEmpDimTime); //员工在公司信息 empModel.DeptID = Convert.ToInt32(comboBox_EmployeeDepartment.SelectedValue); empModel.DeptName = comboBox_EmployeeDepartment.Text; empModel.DutyID = Convert.ToInt32(combobox_EmployeeDuty.SelectedValue); empModel.DutyName = combobox_EmployeeDuty.Text; empModel.MaxSecTime = (Convert.ToInt32(textBox_EmpMaxHour.Text) * 3600) + (Convert.ToInt32(textBox_EmpMaxMinute.Text) * 60) + Convert.ToInt32(textBox_EmpMaxSecond.Text); empModel.MinSecTime = (Convert.ToInt32(textBox_EmpMinHour.Text) * 3600) + (Convert.ToInt32(textBox_EmpMinMinute.Text) * 60) + Convert.ToInt32(textBox_EmpMinSecond.Text); int intSelectMode; if (rdb_Dept.Checked) { intSelectMode = 1; } else if (rdb_Emp.Checked) { intSelectMode = 2; } else { intSelectMode = 3; } empModel.SelectMode = intSelectMode; empModel.ClassGroup = textBox_EmpGroup.Text.Trim(); empModel.WorkPlace = textBox_EmpWorkPlace.Text.Trim(); //员工照片信息 if (bPhoto != null) { empModel.Photo = bPhoto; } //员工工种信息 //工种1 EmpWorkType empWorkType1 = new EmpWorkType(); //if (Convert.ToInt32(comboBox_EmpWorkTypeName.SelectedValue) != 0) //{ empWorkType1.WorkTypeID = Convert.ToInt32(comboBox_EmpWorkTypeName.SelectedValue); empWorkType1.WorkTypeName = comboBox_EmpWorkTypeName.Text; empWorkType1.IsMostly = true; empWorkType1.IsEnable = true; empModel.WorkType1 = empWorkType1; //} #endregion return empModel; }