/// <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;
}
