/// <summary> /// 年休假设置信息添加 /// </summary> /// <param name="YearHolidayM">YearHolidayM</param> /// <param name="StrYearHoliday">年休假设置信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static string AddYearHolidayInfoSet(YearHolidayModel YearHolidayM, string StrYearHoliday) { return(YearHolidayDBHelper.AddYearHolidayInfoSet(YearHolidayM, StrYearHoliday)); }
/// <summary> /// 年休假设置信息添加 /// </summary> /// <param name="YearHolidayM">YearHolidayM</param> /// <param name="StrYearHoliday">年休假设置信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static string AddYearHolidayInfoSet(YearHolidayModel YearHolidayM, string StrYearHoliday) { string[] strarray = null; string recorditems = ""; string[] inseritems = null; string ErrMsg = ""; try { strarray = StrYearHoliday.Split('|'); for (int i = 0; i < strarray.Length; i++) { StringBuilder StrYearHolidaySql = new StringBuilder(); recorditems = strarray[i]; inseritems = recorditems.Split(','); if (recorditems.Length != 0) { string EmployeeID = inseritems[0].ToString().Trim(); //员工ID string HolidayHours = inseritems[1].ToString().Trim(); //时长 string UserName = inseritems[2].ToString().Trim(); //姓名 if (YearHolidayIsExist(EmployeeID) == 0) //插入 { #region 添加SQL StrYearHolidaySql.AppendLine("INSERT INTO officedba.YearHoliday"); StrYearHolidaySql.AppendLine(" (CompanyCD "); StrYearHolidaySql.AppendLine(" ,EmployeeID "); StrYearHolidaySql.AppendLine(" ,HolidayHours "); StrYearHolidaySql.AppendLine(" ,ModifiedDate "); StrYearHolidaySql.AppendLine(" ,ModifiedUserID) "); StrYearHolidaySql.AppendLine("VALUES "); StrYearHolidaySql.AppendLine(" ('"+ YearHolidayM.CompanyCD + "' "); StrYearHolidaySql.AppendLine(" ,"+ Convert.ToInt32(EmployeeID) + " "); StrYearHolidaySql.AppendLine(" ,"+ Convert.ToDecimal(HolidayHours) + " "); StrYearHolidaySql.AppendLine(" ,'"+ YearHolidayM.ModifiedDate + "' "); StrYearHolidaySql.AppendLine(" ,'"+ YearHolidayM.ModifiedUserID + "') "); #endregion } else//更新 { #region 更新SQL StrYearHolidaySql.AppendLine("UPDATE officedba.YearHoliday"); StrYearHolidaySql.AppendLine(" SET CompanyCD='"+ YearHolidayM.CompanyCD + "' "); StrYearHolidaySql.AppendLine(" ,HolidayHours="+ Convert.ToDecimal(HolidayHours) + " "); StrYearHolidaySql.AppendLine(" ,ModifiedDate='"+ YearHolidayM.ModifiedDate + "' "); StrYearHolidaySql.AppendLine(" ,ModifiedUserID='"+ YearHolidayM.ModifiedUserID + "' "); StrYearHolidaySql.AppendLine(" WHERE EmployeeID="+ Convert.ToInt32(EmployeeID) + " "); #endregion } SqlHelper.ExecuteTransSql(StrYearHolidaySql.ToString()); if (SqlHelper.Result.OprateCount <= 0) { ErrMsg = UserName + ','; } } } return(ErrMsg); } catch (Exception ex) { return(ex.ToString()); } }