/// <summary> /// 根据工作日历主键索引,删除与工作日历关联的列外日期记录 /// </summary> /// <param name="strVacationId">工作日历主键索引</param> /// <returns></returns> public string DeleteByVacationID(string strVacationId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strVacationId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" T_HR_VACATIONSET.VACATIONID == @0"); objArgs.Add(strVacationId); OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL(); flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } string strOrderBy = " OUTPLANDAYID "; var q = dalOutPlanDays.GetOutPlanDaysRdListByMultSearch(strOrderBy, strFilter.ToString(), objArgs.ToArray()); if (q == null) { return(strMsg); } if (q.Count() == 0) { return(strMsg); } foreach (T_HR_OUTPLANDAYS item in q) { dalOutPlanDays.Delete(item); } strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 新增列外日期信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string AddOutPlanDays(T_HR_OUTPLANDAYS entTemp) { string strMsg = string.Empty; try { if (entTemp == null) { return("{REQUIREDFIELDS}"); } T_HR_VACATIONSET entVacSet = entTemp.T_HR_VACATIONSET; if (entVacSet == null) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" OUTPLANDAYID == @0"); objArgs.Add(entTemp.OUTPLANDAYID); OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL(); flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (flag) { return("{ALREADYEXISTSRECORD}"); } T_HR_OUTPLANDAYS ent = new T_HR_OUTPLANDAYS(); Utility.CloneEntity <T_HR_OUTPLANDAYS>(entTemp, ent); ent.T_HR_VACATIONSETReference.EntityKey = new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_HR_VACATIONSET", "VACATIONID", entTemp.T_HR_VACATIONSET.VACATIONID); Utility.RefreshEntity(ent); dalOutPlanDays.Add(ent); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 修改列外日期信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string ModifyOutPlanDays(T_HR_OUTPLANDAYS entTemp) { string strMsg = string.Empty; try { if (entTemp == null) { return("{REQUIREDFIELDS}"); } T_HR_VACATIONSET entVacSet = entTemp.T_HR_VACATIONSET; if (entVacSet == null) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" OUTPLANDAYID == @0"); objArgs.Add(entTemp.OUTPLANDAYID); OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL(); flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_OUTPLANDAYS entUpdate = dalOutPlanDays.GetOutPlanDaysRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); Utility.CloneEntity(entTemp, entUpdate); dalOutPlanDays.Update(entUpdate); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 根据主键索引,删除列外日期信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteOutPlanDays(string strOutPlanDaysId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strOutPlanDaysId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" OUTPLANDAYID == @0"); objArgs.Add(strOutPlanDaysId); OutPlanDaysDAL dalOutPlanDays = new OutPlanDaysDAL(); flag = dalOutPlanDays.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_OUTPLANDAYS entDel = dalOutPlanDays.GetOutPlanDaysRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); dalOutPlanDays.Delete(entDel); strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }