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