/// <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="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); }