/// <summary> /// 将人员信息从 DataTable 转化为 EmployeeInfoModel /// </summary> /// <param name="data">人员信息</param> /// <returns>EmployeeInfoModel形式的人员信息</returns> private static EmployeeInfoModel ChangeEmplDataToModel(DataRow data) { //定义返回的 EmployeeInfoModel EmployeeInfoModel model = new EmployeeInfoModel(); //人员信息存在时,转化为model形式的数据 if (data != null) { model.ID = GetSafeData.ValidateDataRow_Int(data, "ID"); //内部id,自动生成 model.EmployeeNum = GetSafeData.ValidateDataRow_String(data, "EmployeeNum"); //员工工号 model.EmployeeNo = GetSafeData.ValidateDataRow_String(data, "EmployeeNo"); //员工编号 model.PYShort = GetSafeData.ValidateDataRow_String(data, "PYShort"); //拼音缩写 model.CompanyCD = GetSafeData.ValidateDataRow_String(data, "CompanyCD"); //公司代码 model.CardID = GetSafeData.ValidateDataRow_String(data, "CardID"); //身份证 model.SafeguardCard = GetSafeData.ValidateDataRow_String(data, "SafeguardCard"); //社保卡号 model.EmployeeName = GetSafeData.ValidateDataRow_String(data, "EmployeeName"); //姓名 model.UsedName = GetSafeData.ValidateDataRow_String(data, "UsedName"); //曾用名 model.NameEn = GetSafeData.ValidateDataRow_String(data, "NameEn"); //英文名 model.Sex = GetSafeData.ValidateDataRow_String(data, "Sex"); //性别 model.Birth = GetSafeData.GetStringFromDateTime(data, "Birth", "yyyy-MM-dd"); //出生年月 model.Account = GetSafeData.ValidateDataRow_String(data, "Account"); //户口 model.AccountNature = GetSafeData.ValidateDataRow_String(data, "AccountNature"); //户口性质(1城市,2农村) model.CountryID = GetSafeData.GetStringFromInt(data, "CountryID"); //国籍(对应分类代码表ID,国家地区) model.Height = GetSafeData.GetStringFromInt(data, "Height"); //身高(单位厘米) model.Weight = GetSafeData.GetStringFromDecimal(data, "Weight"); //体重(单位千克) model.Sight = GetSafeData.GetStringFromDecimal(data, "Sight"); //视力 model.Degree = GetSafeData.ValidateDataRow_String(data, "Degree"); //最高学位 model.PositionID = GetSafeData.GetStringFromInt(data, "PositionID"); //职称ID(对应分类代码表ID,职称) model.DocuType = GetSafeData.ValidateDataRow_String(data, "DocuType"); //证件类型 //model.CreateUserID = GetSafeData.ValidateDataRow_String(data, "CreateUserID"); //创建人 //model.CreateUserName = GetSafeData.ValidateDataRow_String(data, "CreateUserName"); //创建人 //model.CreateDate = GetSafeData.ValidateDataRow_DateTime(data, "CreateDate"); //创建时间 model.National = GetSafeData.GetStringFromInt(data, "NationalID"); //民族ID(对应分类代码表ID) model.MarriageStatus = GetSafeData.GetStringFromInt(data, "MarriageStatus"); //婚姻状况ID(对应分类代码表ID) model.Origin = GetSafeData.ValidateDataRow_String(data, "Origin"); //籍贯 model.Landscape = GetSafeData.GetStringFromInt(data, "Landscape"); //政治面貌ID(对应分类代码表ID) model.Religion = GetSafeData.GetStringFromInt(data, "Religion"); //宗教信仰ID(对应分类代码表ID) model.Telephone = GetSafeData.ValidateDataRow_String(data, "Telephone"); //联系电话 model.Mobile = GetSafeData.ValidateDataRow_String(data, "Mobile"); //手机号码 model.EMail = GetSafeData.ValidateDataRow_String(data, "EMail"); //电子邮件 model.OtherContact = GetSafeData.ValidateDataRow_String(data, "OtherContact"); //其他联系方式 model.HomeAddress = GetSafeData.ValidateDataRow_String(data, "HomeAddress"); //家庭住址 model.HealthStatus = GetSafeData.ValidateDataRow_String(data, "HealthStatus"); //健康状况 model.CultureLevel = GetSafeData.GetStringFromInt(data, "CultureLevel"); //学历ID(对应分类代码表ID) model.GraduateSchool = GetSafeData.ValidateDataRow_String(data, "GraduateSchool"); //毕业院校 model.Professional = GetSafeData.GetStringFromInt(data, "Professional"); //专业ID(对应分类代码表ID) model.Features = GetSafeData.ValidateDataRow_String(data, "Features"); //特长 model.ComputerLevel = GetSafeData.ValidateDataRow_String(data, "ComputerLevel"); //计算机水平 model.ForeignLanguage1 = GetSafeData.GetStringFromInt(data, "ForeignLanguage1"); //外语语种1 ID(对应分类代码表ID) model.ForeignLanguageLevel1 = GetSafeData.ValidateDataRow_String(data, "ForeignLanguageLevel1"); //外语水平1(1一般,2熟练,3精通) model.ForeignLanguage2 = GetSafeData.GetStringFromInt(data, "ForeignLanguage2"); //外语语种2 model.ForeignLanguageLevel2 = GetSafeData.ValidateDataRow_String(data, "ForeignLanguageLevel2"); //外语水平2(1一般,2熟练,3精通) model.ForeignLanguage3 = GetSafeData.GetStringFromInt(data, "ForeignLanguage3"); //外语语种3 model.ForeignLanguageLevel3 = GetSafeData.ValidateDataRow_String(data, "ForeignLanguageLevel3"); //外语水平3(1一般,2熟练,3精通) model.WorkTime = GetSafeData.GetStringFromDateTime(data, "WorkTime", "yyyy-MM-dd"); //参加工作时间 model.TotalSeniority = GetSafeData.GetStringFromDecimal(data, "TotalSeniority"); //总工龄 model.PhotoURL = GetSafeData.ValidateDataRow_String(data, "PhotoURL"); //员工相片 model.PositionTitle = GetSafeData.ValidateDataRow_String(data, "PositionTitle"); //应聘职务 model.Flag = GetSafeData.ValidateDataRow_String(data, "Flag"); //分类标识 model.ModifiedDate = GetSafeData.ValidateDataRow_DateTime(data, "ModifiedDate"); //更新日期 model.ModifiedUserID = GetSafeData.ValidateDataRow_String(data, "ModifiedUserID"); //更新用户ID model.QuarterID = GetSafeData.GetStringFromInt(data, "QuarterID"); //目前所在岗位ID(对应岗位表ID) model.DeptID = Convert.ToInt32(data["DeptID"].ToString()); model.DeptName = data["DeptName"].ToString(); model.AdminLevelID = Convert.ToInt32(data["AdminLevelID"].ToString()); //model.EnterDate = data["EnterDate"].ToString() == "" ? DateTime.dat Convert.ToDateTime(data["EnterDate"].ToString()); model.EnterDate = GetSafeData.ValidateDataRow_DateTime(data, "EnterDate"); //入职日期 model.Resume = GetSafeData.ValidateDataRow_String(data, "Resume"); //简历 model.ProfessionalDes = GetSafeData.ValidateDataRow_String(data, "ProfessionalDes"); //专业描述 } return model; }
/// <summary> /// 更新人员信息 /// </summary> /// <param name="model">人员信息</param> /// <returns></returns> public static bool UpdateEmployeeInfo(EmployeeInfoModel model) { #region 更新SQL拼写 StringBuilder updateSql = new StringBuilder(); updateSql.AppendLine("UPDATE officedba.EmployeeInfo "); updateSql.AppendLine(" SET "); updateSql.AppendLine(" EmployeeNum = @EmployeeNum "); updateSql.AppendLine(" ,PYShort = @PYShort "); updateSql.AppendLine(" ,CardID = @CardID "); updateSql.AppendLine(" ,SafeguardCard = @SafeguardCard "); updateSql.AppendLine(" ,EmployeeName = @EmployeeName "); updateSql.AppendLine(" ,UsedName = @UsedName "); updateSql.AppendLine(" ,NameEn = @NameEn "); updateSql.AppendLine(" ,Sex = @Sex "); updateSql.AppendLine(" ,Birth = @Birth "); updateSql.AppendLine(" ,Account = @Account "); updateSql.AppendLine(" ,AccountNature = @AccountNature "); updateSql.AppendLine(" ,CountryID = @CountryID "); updateSql.AppendLine(" ,Height = @Height "); updateSql.AppendLine(" ,Weight = @Weight "); updateSql.AppendLine(" ,Sight = @Sight "); updateSql.AppendLine(" ,Degree = @Degree "); updateSql.AppendLine(" ,PositionID = @PositionID "); updateSql.AppendLine(" ,DocuType = @DocuType "); updateSql.AppendLine(" ,NationalID = @National "); updateSql.AppendLine(" ,MarriageStatus = @MarriageStatus "); updateSql.AppendLine(" ,Origin = @Origin "); updateSql.AppendLine(" ,Landscape = @Landscape "); updateSql.AppendLine(" ,Religion = @Religion "); updateSql.AppendLine(" ,Telephone = @Telephone "); updateSql.AppendLine(" ,Mobile = @Mobile "); updateSql.AppendLine(" ,EMail = @EMail "); updateSql.AppendLine(" ,OtherContact = @OtherContact "); updateSql.AppendLine(" ,HomeAddress = @HomeAddress "); updateSql.AppendLine(" ,HealthStatus = @HealthStatus "); updateSql.AppendLine(" ,CultureLevel = @CultureLevel "); updateSql.AppendLine(" ,GraduateSchool = @GraduateSchool "); updateSql.AppendLine(" ,Professional = @Professional "); updateSql.AppendLine(" ,Features = @Features "); updateSql.AppendLine(" ,ComputerLevel = @ComputerLevel "); updateSql.AppendLine(" ,ForeignLanguage1 = @ForeignLanguage1 "); updateSql.AppendLine(" ,ForeignLanguageLevel1 = @ForeignLanguageLevel1"); updateSql.AppendLine(" ,ForeignLanguage2 = @ForeignLanguage2 "); updateSql.AppendLine(" ,ForeignLanguageLevel2 = @ForeignLanguageLevel2"); updateSql.AppendLine(" ,ForeignLanguage3 = @ForeignLanguage3 "); updateSql.AppendLine(" ,ForeignLanguageLevel3 = @ForeignLanguageLevel3"); updateSql.AppendLine(" ,WorkTime = @WorkTime "); updateSql.AppendLine(" ,TotalSeniority = @TotalSeniority "); updateSql.AppendLine(" ,PhotoURL = @PhotoURL "); updateSql.AppendLine(" ,PositionTitle = @PositionTitle "); updateSql.AppendLine(" ,Flag = @Flag "); updateSql.AppendLine(" ,ModifiedDate = getdate() "); updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID "); updateSql.AppendLine(" ,QuarterID = @QuarterID "); updateSql.AppendLine(" ,DeptID = @DeptID "); updateSql.AppendLine(" ,AdminLevelID = @AdminLevelID "); updateSql.AppendLine(" ,EnterDate = @EnterDate "); updateSql.AppendLine(" ,Resume = @Resume "); updateSql.AppendLine(" ,ProfessionalDes = @ProfessionalDes "); updateSql.AppendLine(" WHERE CompanyCD = @CompanyCD "); updateSql.AppendLine(" AND EmployeeNo = @EmployeeNo "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = updateSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //定义更新列表 ArrayList lstUpdate = new ArrayList(); //添加基本信息更新命令 lstUpdate.Add(comm); //登陆或者更新履历信息 EditEmployeeHistoryInfo(lstUpdate, model.HistoryList, model.EmployeeNo, model.CompanyCD); //登陆或者更新技能信息 EditEmployeeSkillInfo(lstUpdate, model.SkillList, model.EmployeeNo, model.CompanyCD); //执行更新操作并返回更新结果 return SqlHelper.ExecuteTransWithArrayList(lstUpdate); }
/// <summary> /// 保存时基本信息参数设置 /// </summary> /// <param name="comm">命令</param> /// <param name="model">人员信息</param> private static void SetSaveParameter(SqlCommand comm, EmployeeInfoModel model) { //设置参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeNum", model.EmployeeNum)); //员工编码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeNo", model.EmployeeNo)); //员工工号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PYShort", model.PYShort)); //拼音缩写 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CardID", model.CardID)); //身份证 comm.Parameters.Add(SqlHelper.GetParameterFromString("@SafeguardCard", model.SafeguardCard)); //社保卡号 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EmployeeName", model.EmployeeName)); //姓名 comm.Parameters.Add(SqlHelper.GetParameterFromString("@UsedName", model.UsedName)); //曾用名 comm.Parameters.Add(SqlHelper.GetParameterFromString("@NameEn", model.NameEn)); //英文名 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Sex", model.Sex)); //性别 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Birth", model.Birth)); //出生年月 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Account", model.Account)); //户口 comm.Parameters.Add(SqlHelper.GetParameterFromString("@AccountNature", model.AccountNature)); //户口性质(1城市,2农村) comm.Parameters.Add(SqlHelper.GetParameterFromString("@CountryID", model.CountryID)); //国籍(对应分类代码表ID,国家地区) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Height", model.Height)); //身高(单位厘米) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Weight", model.Weight)); //体重(单位千克) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Sight", model.Sight)); //视力 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Degree", model.Degree)); //最高学位 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PositionID", model.PositionID)); //职称ID(对应分类代码表ID,职称) comm.Parameters.Add(SqlHelper.GetParameterFromString("@DocuType", model.DocuType)); //证件类型 ////登陆时,设置下面两参数 //if (ConstUtil.EDIT_FLAG_INSERT.Equals(model.EditFlag)) //{ // comm.Parameters.Add(SqlHelper.GetParameterFromString("@CreateUserID", model.CreateUserID)); //创建人 // comm.Parameters.Add(SqlHelper.GetParameter("@CreateDate", model.CreateDate)); //创建时间 //} comm.Parameters.Add(SqlHelper.GetParameterFromString("@National", model.National)); //民族ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@MarriageStatus", model.MarriageStatus)); //婚姻状况ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Origin", model.Origin)); //籍贯 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Landscape", model.Landscape)); //政治面貌ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Religion", model.Religion)); //宗教信仰ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Telephone", model.Telephone)); //联系电话 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Mobile", model.Mobile)); //手机号码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@EMail", model.EMail)); //电子邮件 comm.Parameters.Add(SqlHelper.GetParameterFromString("@OtherContact", model.OtherContact)); //其他联系方式 comm.Parameters.Add(SqlHelper.GetParameterFromString("@HomeAddress", model.HomeAddress)); //家庭住址 comm.Parameters.Add(SqlHelper.GetParameterFromString("@HealthStatus", model.HealthStatus)); //健康状况 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CultureLevel", model.CultureLevel)); //学历ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@GraduateSchool", model.GraduateSchool)); //毕业院校 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Professional", model.Professional)); //专业ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Features", model.Features)); //特长 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ComputerLevel", model.ComputerLevel)); //计算机水平 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguage1", model.ForeignLanguage1)); //外语语种1 ID(对应分类代码表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguageLevel1", model.ForeignLanguageLevel1)); //外语水平1(1一般,2熟练,3精通) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguage2", model.ForeignLanguage2)); //外语语种2 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguageLevel2", model.ForeignLanguageLevel2)); //外语水平2(1一般,2熟练,3精通) comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguage3", model.ForeignLanguage3)); //外语语种3 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ForeignLanguageLevel3", model.ForeignLanguageLevel3)); //外语水平3(1一般,2熟练,3精通) comm.Parameters.Add(SqlHelper.GetParameterFromString("@WorkTime", model.WorkTime)); //参加工作时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@TotalSeniority", model.TotalSeniority)); //总工龄 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PhotoURL", model.PagePhotoURL)); //员工相片 comm.Parameters.Add(SqlHelper.GetParameterFromString("@PositionTitle", model.PositionTitle)); //应聘职务 comm.Parameters.Add(SqlHelper.GetParameterFromString("@Flag", model.Flag)); //分类标识 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@QuarterID", model.QuarterID)); //目前所在岗位ID(对应岗位表ID) comm.Parameters.Add(SqlHelper.GetParameterFromString("@Resume", model.PageResume)); //简历 comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.DeptID.ToString())); //部门ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@AdminLevelID", model.AdminLevelID.ToString())); //岗位职等ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@EnterDate", model.EnterDate.ToString())); //入职时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ProfessionalDes", model.ProfessionalDes)); //专业描述 }
/// <summary> /// 添加人员信息 /// </summary> /// <param name="model">人员信息</param> /// <returns></returns> public static bool InsertEmployeeInfo(EmployeeInfoModel model) { #region 插入SQL拼写 StringBuilder insertSql = new StringBuilder(); insertSql.AppendLine("INSERT INTO officedba.EmployeeInfo "); insertSql.AppendLine(" (EmployeeNum "); insertSql.AppendLine(" ,EmployeeNo "); insertSql.AppendLine(" ,PYShort "); insertSql.AppendLine(" ,CompanyCD "); insertSql.AppendLine(" ,CardID "); insertSql.AppendLine(" ,SafeguardCard "); insertSql.AppendLine(" ,EmployeeName "); insertSql.AppendLine(" ,UsedName "); insertSql.AppendLine(" ,NameEn "); insertSql.AppendLine(" ,Sex "); insertSql.AppendLine(" ,Birth "); insertSql.AppendLine(" ,Account "); insertSql.AppendLine(" ,AccountNature "); insertSql.AppendLine(" ,CountryID "); insertSql.AppendLine(" ,Height "); insertSql.AppendLine(" ,Weight "); insertSql.AppendLine(" ,Sight "); insertSql.AppendLine(" ,Degree "); insertSql.AppendLine(" ,PositionID "); insertSql.AppendLine(" ,DocuType "); //insertSql.AppendLine(" ,CreateUserID "); //insertSql.AppendLine(" ,CreateDate "); insertSql.AppendLine(" ,NationalID "); insertSql.AppendLine(" ,MarriageStatus "); insertSql.AppendLine(" ,Origin "); insertSql.AppendLine(" ,Landscape "); insertSql.AppendLine(" ,Religion "); insertSql.AppendLine(" ,Telephone "); insertSql.AppendLine(" ,Mobile "); insertSql.AppendLine(" ,EMail "); insertSql.AppendLine(" ,OtherContact "); insertSql.AppendLine(" ,HomeAddress "); insertSql.AppendLine(" ,HealthStatus "); insertSql.AppendLine(" ,CultureLevel "); insertSql.AppendLine(" ,GraduateSchool "); insertSql.AppendLine(" ,Professional "); insertSql.AppendLine(" ,Features "); insertSql.AppendLine(" ,ComputerLevel "); insertSql.AppendLine(" ,ForeignLanguage1 "); insertSql.AppendLine(" ,ForeignLanguageLevel1 "); insertSql.AppendLine(" ,ForeignLanguage2 "); insertSql.AppendLine(" ,ForeignLanguageLevel2 "); insertSql.AppendLine(" ,ForeignLanguage3 "); insertSql.AppendLine(" ,ForeignLanguageLevel3 "); insertSql.AppendLine(" ,WorkTime "); insertSql.AppendLine(" ,TotalSeniority "); insertSql.AppendLine(" ,PhotoURL "); insertSql.AppendLine(" ,PositionTitle "); insertSql.AppendLine(" ,Flag "); insertSql.AppendLine(" ,ModifiedDate "); insertSql.AppendLine(" ,ModifiedUserID "); insertSql.AppendLine(" ,QuarterID "); insertSql.AppendLine(" ,DeptID "); insertSql.AppendLine(" ,AdminLevelID "); insertSql.AppendLine(" ,EnterDate "); insertSql.AppendLine(" ,ProfessionalDes "); insertSql.AppendLine(" ,Resume) "); insertSql.AppendLine(" VALUES "); insertSql.AppendLine(" (@EmployeeNum "); insertSql.AppendLine(" ,@EmployeeNo "); insertSql.AppendLine(" ,@PYShort "); insertSql.AppendLine(" ,@CompanyCD "); insertSql.AppendLine(" ,@CardID "); insertSql.AppendLine(" ,@SafeguardCard "); insertSql.AppendLine(" ,@EmployeeName "); insertSql.AppendLine(" ,@UsedName "); insertSql.AppendLine(" ,@NameEn "); insertSql.AppendLine(" ,@Sex "); insertSql.AppendLine(" ,@Birth "); insertSql.AppendLine(" ,@Account "); insertSql.AppendLine(" ,@AccountNature "); insertSql.AppendLine(" ,@CountryID "); insertSql.AppendLine(" ,@Height "); insertSql.AppendLine(" ,@Weight "); insertSql.AppendLine(" ,@Sight "); insertSql.AppendLine(" ,@Degree "); insertSql.AppendLine(" ,@PositionID "); insertSql.AppendLine(" ,@DocuType "); //insertSql.AppendLine(" ,@CreateUserID "); //insertSql.AppendLine(" ,@CreateDate "); insertSql.AppendLine(" ,@National "); insertSql.AppendLine(" ,@MarriageStatus "); insertSql.AppendLine(" ,@Origin "); insertSql.AppendLine(" ,@Landscape "); insertSql.AppendLine(" ,@Religion "); insertSql.AppendLine(" ,@Telephone "); insertSql.AppendLine(" ,@Mobile "); insertSql.AppendLine(" ,@EMail "); insertSql.AppendLine(" ,@OtherContact "); insertSql.AppendLine(" ,@HomeAddress "); insertSql.AppendLine(" ,@HealthStatus "); insertSql.AppendLine(" ,@CultureLevel "); insertSql.AppendLine(" ,@GraduateSchool "); insertSql.AppendLine(" ,@Professional "); insertSql.AppendLine(" ,@Features "); insertSql.AppendLine(" ,@ComputerLevel "); insertSql.AppendLine(" ,@ForeignLanguage1 "); insertSql.AppendLine(" ,@ForeignLanguageLevel1 "); insertSql.AppendLine(" ,@ForeignLanguage2 "); insertSql.AppendLine(" ,@ForeignLanguageLevel2 "); insertSql.AppendLine(" ,@ForeignLanguage3 "); insertSql.AppendLine(" ,@ForeignLanguageLevel3 "); insertSql.AppendLine(" ,@WorkTime "); insertSql.AppendLine(" ,@TotalSeniority "); insertSql.AppendLine(" ,@PhotoURL "); insertSql.AppendLine(" ,@PositionTitle "); insertSql.AppendLine(" ,@Flag "); insertSql.AppendLine(" ,getdate() "); insertSql.AppendLine(" ,@ModifiedUserID "); insertSql.AppendLine(" ,@QuarterID "); insertSql.AppendLine(" ,@DeptID "); insertSql.AppendLine(" ,@AdminLevelID "); insertSql.AppendLine(" ,@EnterDate "); insertSql.AppendLine(" ,@ProfessionalDes "); insertSql.AppendLine(" ,@Resume) "); #endregion //定义更新基本信息的命令 SqlCommand comm = new SqlCommand(); comm.CommandText = insertSql.ToString(); //设置保存的参数 SetSaveParameter(comm, model); //定义更新列表 ArrayList lstInsert = new ArrayList(); //添加基本信息更新命令 lstInsert.Add(comm); //登陆或者更新履历信息 EditEmployeeHistoryInfo(lstInsert, model.HistoryList, model.EmployeeNo, model.CompanyCD); //登陆或者更新技能信息 EditEmployeeSkillInfo(lstInsert, model.SkillList, model.EmployeeNo, model.CompanyCD); //执行更新操作并返回更新结果 return SqlHelper.ExecuteTransWithArrayList(lstInsert); }
/// <summary> /// 设置技能信息 /// </summary> /// <param name="employModel">人员信息</param> private void InitSkillInfo(EmployeeInfoModel employModel) { //获取技能信息 DataTable dtSkill = employModel.SkillInfo; //定义保存技能详细信息变量 StringBuilder sbSkillInfo = new StringBuilder(); //技能信息存在时,设置技能信息 if (dtSkill != null && dtSkill.Rows.Count > 0) { //遍历所有技能信息 for (int i = 0; i < dtSkill.Rows.Count; i++) { //插入行开始标识 sbSkillInfo.AppendLine("<tr>"); //选择框 sbSkillInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblSkill_chkSelect_" + (i + 1).ToString() + "'></td>"); //技能名称 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "SkillName") + "' class='tdinput' id='txtSkillName_" + (i + 1).ToString() + "'></td>"); //证件名称 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateName") + "' class='tdinput' id='txtCertificateName_" + (i + 1).ToString() + "'></td>"); //证件编号 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateNo") + "' class='tdinput' id='txtCertificateNo_" + (i + 1).ToString() + "'></td>"); //证件等级 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "CertificateLevel") + "' class='tdinput' id='txtCertificateLevel_" + (i + 1).ToString() + "'></td>"); //发证单位 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "IssueCompany") + "' class='tdinput' id='txtIssueCompany_" + (i + 1).ToString() + "'></td>"); //发证时间 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='" + GetSafeData.GetStringFromDateTime(dtSkill.Rows[i], "IssueDate", "yyyy-MM-dd") + "' class='tdinput' id='txtIssueDate_" + (i + 1).ToString() + "' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtIssueDate_" + (i + 1).ToString() + "')})\"></td>"); //有效期 sbSkillInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '25' value='" + GetSafeData.ValidateDataRow_String(dtSkill.Rows[i], "Validity") + "' class='tdinput' id='txtValidity_" + (i + 1).ToString() + "'></td>"); //插入行结束标识 sbSkillInfo.AppendLine("</tr>"); } } //技能信息设置到DIV中表示 divSkillInfo.InnerHtml = CreateSkillTable() + sbSkillInfo.ToString() + EndTable(); }
/// <summary> /// 设置人员工作履历以及学习履历 /// </summary> /// <param name="employModel">人员信息</param> private void InitHistoryInfo(EmployeeInfoModel employModel) { //获取技能信息 DataTable dtHistory = employModel.HistoryInfo; //定义保存工作履历详细信息变量 StringBuilder sbWorkInfo = new StringBuilder(); //定义保存学习履历详细信息变量 StringBuilder sbStudyInfo = new StringBuilder(); //技能信息存在时,设置技能信息 if (dtHistory != null && dtHistory.Rows.Count > 0) { //工作履历记录数 int workCount = 1; //学习履历记录数 int studyCount = 1; //遍历所有技能信息 for (int i = 0; i < dtHistory.Rows.Count; i++) { //区分 string flag = GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Flag"); //工作履历 if (ConstUtil.HUMAN_HISTORY_WORK.Equals(flag)) { //插入行开始标识 sbWorkInfo.AppendLine("<tr>"); //选择框 sbWorkInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblWorkHistory_chkSelect_" + workCount.ToString() + "'></td>"); //开始时间 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='" + GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "StartDate", "yyyy-MM-dd") + "' class='tdinput' readonly id='txtWorkStart_" + workCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtWorkStart_" + workCount.ToString() + "')})\"></td>"); //结束时间 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='" + GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "EndDate", "yyyy-MM-dd") + "' class='tdinput' readonly id='txtWorkEnd_" + workCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtWorkEnd_" + workCount.ToString() + "')})\"></td>"); //工作单位 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Company") + "' class='tdinput' id='txtWorkCompany_" + workCount.ToString() + "'></td>"); //所在部门 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "Department") + "' class='tdinput' id='txtWorkDept_" + workCount.ToString() + "'></td>"); //工作内容 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "WorkContent") + "' class='tdinput' id='txtWorkContent_" + workCount.ToString() + "'></td>"); //离职原因 sbWorkInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "LeaveReason") + "' class='tdinput' id='txtLeaveReason_" + workCount.ToString() + "'></td>"); //插入行结束标识 sbWorkInfo.AppendLine("</tr>"); //增长工作履历数 workCount++; } //学习履历 else if (ConstUtil.HUMAN_HISTORY_STUDY.Equals(flag)) { //插入行开始标识 sbStudyInfo.AppendLine("<tr>"); //选择框 sbStudyInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tblStudyHistory_chkSelect_" + studyCount.ToString() + "'></td>"); //开始时间 sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='" + GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "StartDate", "yyyy-MM-dd") + "' class='tdinput' readonly id='txtStudyStart_" + studyCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtStudyStart_" + studyCount.ToString() + "')})\"></td>"); //结束时间 sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '10' value='" + GetSafeData.GetStringFromDateTime(dtHistory.Rows[i], "EndDate", "yyyy-MM-dd") + "' class='tdinput' readonly id='txtStudyEnd_" + studyCount.ToString() + "' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtStudyEnd_" + studyCount.ToString() + "')})\"></td>"); //学校名称 sbStudyInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='" + GetSafeData.ValidateDataRow_String(dtHistory.Rows[i], "SchoolName") + "' class='tdinput' id='txtSchoolName_" + studyCount.ToString() + "'></td>"); //专业 sbStudyInfo.AppendLine("<td class='tdColInput'>" + CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_PROFESSIONAL , "ddlProfessional_" + studyCount.ToString(), "tdinput", false, GetSafeData.GetStringFromInt(dtHistory.Rows[i], "Professional")) + "</td>"); //学历 sbStudyInfo.AppendLine("<td class='tdColInput'>" + CodePublicTypeBus.CreateSelectInputControlString(ConstUtil.CODE_TYPE_HUMAN, ConstUtil.CODE_TYPE_CULTURE , "ddlCultureLevel_" + studyCount.ToString(), "tdinput", false, GetSafeData.GetStringFromInt(dtHistory.Rows[i], "CultureLevel")) + "</td>"); //插入行结束标识 sbStudyInfo.AppendLine("</tr>"); //增长学习履历数 studyCount++; } } } //工作履历设置到DIV中表示 divWorkInfo.InnerHtml = CreateWorkTable() + sbWorkInfo.ToString() + EndTable(); //学习履历设置到DIV中表示 divStudyInfo.InnerHtml = CreateStudyTable() + sbStudyInfo.ToString() + EndTable(); }
/// <summary> /// 设置人员基本信息 /// </summary> /// <param name="employModel">人员信息</param> private void InitEmployeeBaseInfo(EmployeeInfoModel employModel) { //设置人员编号 divEmployeeNo.InnerText = employModel.EmployeeNo; divEmployeeNo.Attributes.Add("style", "display:block;"); //自动生成编号的控件设置为不可见 divCodeRule.Attributes.Add("style", "display:none;"); //姓名 txtEmployeeName.Value = employModel.EmployeeName; //工号 txtEmployeeNum.Text = employModel.EmployeeNum; //拼音缩写 txtPYShort.Text = employModel.PYShort; //曾用名 txtUsedName.Text = employModel.UsedName; //英文名 txtNameEn.Text = employModel.NameEn; //人员分类 string flag = employModel.Flag; ddlFlag.Value = flag; //人才储备时 //if ("2".Equals(flag)) //{ // //标题设置 // divJobTitle.InnerHtml = "应聘职务"; // //职称控件不显示 // divPosition.Attributes.Add("style", "display:none;"); // //应聘职务控件显示 // divPositionTitle.Attributes.Add("style", "display:block;"); // //应聘职务值设置 txtPositionTitle.Text = employModel.PositionTitle; // //所在岗位标题设置清除 // //divQuarter.InnerHtml = ""; // //所在岗位控件不显示 // divQuarterValue.Attributes.Add("style", "display:none;"); //} //else //{ // //职称 ddlPosition.SelectedValue = employModel.PositionID; // divPosition.Attributes.Add("style", "display:block;"); // txtPositionTitle.Visible = false; // //所在岗位 ddlQuarter_ddlCodeType.SelectedValue = employModel.QuarterID; // divQuarterValue.Attributes.Add("style", "display:block;"); // divQuarter.Attributes.Add("style", "display:block;"); //} //身份证 txtCardID.Text = employModel.CardID; //社保卡号 txtSafeguardCard.Text = employModel.SafeguardCard; //性别 ddlSex.SelectedValue = employModel.Sex; //出身年月日 txtBirth.Text = employModel.Birth; //婚姻状况 ddlMarriage.SelectedValue = employModel.MarriageStatus; //籍贯 txtOrigin.Text = employModel.Origin; //联系电话 txtTelephone.Text = employModel.Telephone; //手机号码 txtMobile.Text = employModel.Mobile; //电子邮件 txtEMail.Text = employModel.EMail; //其他联系方式 txtOtherContact.Text = employModel.OtherContact; //家庭住址 txtHomeAddress.Text = employModel.HomeAddress; //健康状况 ddlHealth.SelectedValue = employModel.HealthStatus; //学历 ddlCulture.SelectedValue = employModel.CultureLevel; //毕业院校 txtSchool.Text = employModel.GraduateSchool; //专业 ddlProfessional.SelectedValue = employModel.Professional; //政治面貌 ddlLandscape.SelectedValue = employModel.Landscape; //宗教信仰 ddlReligion.SelectedValue = employModel.Religion; //民族 ddlNational.SelectedValue = employModel.National; //户口 txtAccount.Text = employModel.Account; //户口性质 ddlAccountNature.SelectedValue = employModel.AccountNature; //国籍 ddlCountry.SelectedValue = employModel.CountryID; //身高 txtHeight.Text = employModel.Height; //体重 txtWeight.Text = employModel.Weight; //视力 txtSight.Text = employModel.Sight; //最高学位 txtDegree.Text = employModel.Degree; //证件类型 txtDocuType.Text = employModel.DocuType; //特长 txtFeatures.Text = employModel.Features; //计算机水平 txtComputerLevel.Text = employModel.ComputerLevel; //参加工作时间 txtWorkTime.Text = employModel.WorkTime; //if (txtWorkTime.Text.Trim() != "") //{ // DateTime oldDate = Convert.ToDateTime(txtWorkTime.Text.Trim()); // DateTime newDate = DateTime.Now; // TimeSpan ts = newDate - oldDate; // int differenceInDays = ts.Days/365 + 1; // //总工龄 // txtTotalSeniority.Text = differenceInDays.ToString();//employModel.TotalSeniority.ToString(); //} //外语语种1 ddlLanguage1.SelectedValue = employModel.ForeignLanguage1; //外语语种2 ddlLanguage2.SelectedValue = employModel.ForeignLanguage2; //外语语种3 ddlLanguage3.SelectedValue = employModel.ForeignLanguage3; //外语水平1 ddlLanguageLevel1.SelectedValue = employModel.ForeignLanguageLevel1; //外语水平2 ddlLanguageLevel2.SelectedValue = employModel.ForeignLanguageLevel2; //外语水平3 ddlLanguageLevel3.SelectedValue = employModel.ForeignLanguageLevel3; //创建人 //txtCreateUserName.Text = employModel.CreateUserName; ////创建时间 //txtCreateDate.Text = employModel.CreateDate.ToString("yyyy-MM-dd"); txtProfessionalDes.Text = employModel.ProfessionalDes; //简历 string resumeUrl = employModel.Resume; ddlAdminLevelID.SelectedValue = employModel.AdminLevelID.ToString(); DeptName.Value = employModel.DeptName; hdDeptID.Value = employModel.DeptID.ToString(); //txtEnterDate.Value = Convert.ToDateTime(employModel.EnterDate.ToString()).ToShortDateString(); txtEnterDate.Value = (employModel.EnterDate == null || employModel.EnterDate <= DateTime.MinValue) ? "" : Convert.ToDateTime(employModel.EnterDate).ToShortDateString(); //简历存在的时候 if (!string.IsNullOrEmpty(resumeUrl)) { hfResume.Value = resumeUrl; hfPageResume.Value = resumeUrl; //上传简历不显示 divUploadResume.Attributes.Add("style", "display:none;"); //简历处理显示 divDealResume.Attributes.Add("style", "display:block;"); int j = resumeUrl.LastIndexOf("\\") + 1; spanAttachmentName.InnerHtml = resumeUrl.Substring(j, resumeUrl.Length - j); } else { //简历处理不显示 divDealResume.Attributes.Add("style", "display:none;"); //上传简历显示 divUploadResume.Attributes.Add("style", "display:block;"); } //相片 string photoURL = employModel.PhotoURL; if (string.IsNullOrEmpty(photoURL)) { imgPhoto.Src = "~/Images/Pic/Pic_Nopic.jpg"; } else { imgPhoto.Src = "~/Images/Photo/" + photoURL; hfPhotoUrl.Value = photoURL; hfPagePhotoUrl.Value = photoURL; } }
/// <summary> /// 编辑人员信息 /// </summary> /// <param name="model">人员信息</param> /// <returns></returns> public static bool SaveEmployeeInfo(EmployeeInfoModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //操作日志 LogInfoModel logModel = InitLogInfo(model.EmployeeNo); //ID存在时,更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { //设置操作日志类型 修改 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;//操作对象 //执行更新操作 isSucc = EmployeeInfoDBHelper.UpdateEmployeeInfo(model); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { //设置操作日志类型 新建 logModel.Element = ConstUtil.LOG_PROCESS_INSERT;//操作对象 //执行插入操作 isSucc = EmployeeInfoDBHelper.InsertEmployeeInfo(model); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } } //更新成功时,删除原来文件 if (isSucc) { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; //操作前相片路径 //string photoUrl = model.PhotoURL; //相片存在时,删除相片 //if (!string.IsNullOrEmpty(photoUrl) && !model.PhotoURL.Equals(model.PagePhotoURL)) //{ // //删除文件 System.Web.HttpContext.Current.Server.MapPath("Photo") + // FileUtil.DeleteFile(photoUrl); //} //操作前简历路径 string resumeUrl = model.Resume; //简历存在时,删除简历 if (!string.IsNullOrEmpty(resumeUrl) && !model.Resume.Equals(model.PageResume)) { //删除文件 FileUtil.DeleteFile(resumeUrl); } } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; ////删除上传的相片 新的相片路径 //string pagePhotoUrl = model.PagePhotoURL; ////相片存在时,删除相片 //if (!string.IsNullOrEmpty(pagePhotoUrl)) //{ // //删除文件 // FileUtil.DeleteFile(ConstUtil.SERVER_PATH + "\\" + pagePhotoUrl); //} ////操作前简历路径 //string pageResumeUrl = model.PageResume; ////简历存在时,删除简历 //if (!string.IsNullOrEmpty(pageResumeUrl)) //{ // //删除文件 // FileUtil.DeleteFile(ConstUtil.SERVER_PATH + "\\" + pageResumeUrl); //} } //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; }