/// <summary> /// 根据条件,获取考勤异常扣款信息 /// </summary> /// <param name="strAttType"></param> /// <param name="strFineType"></param> /// <param name="strSortKey"></param> /// <returns></returns> public IQueryable <T_HR_ATTENDANCEDEDUCTMASTER> GetAllAttendanceDeductMasterRdListByMultSearch(string strOwnerID, string strAttType, string strSortKey) { AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); StringBuilder strfilter = new StringBuilder(); List <object> objArgs = new List <object>(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strAttType)) { strfilter.Append(" ATTENDABNORMALTYPE == @0"); objArgs.Add(strAttType); } if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " DEDUCTMASTERID "; } string filterString = strfilter.ToString(); SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_ATTENDANCEDEDUCTMASTER"); var q = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray()); return(q); }
/// <summary> /// 新增考勤异常扣款主表信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string AddDeductMaster(T_HR_ATTENDANCEDEDUCTMASTER entTemp) { string strMsg = string.Empty; try { StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); bool flag = false; strfilter.Append(" ATTENDABNORMALNAME == @0"); strfilter.Append(" && ATTENDABNORMALTYPE == @1"); objArgs.Add(entTemp.ATTENDABNORMALNAME); objArgs.Add(entTemp.ATTENDABNORMALTYPE); AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); flag = dalAttendanceDeductMaster.IsExistsRd(strfilter.ToString(), objArgs.ToArray()); if (flag) { return("{ALREADYEXISTSRECORD}"); } dalAttendanceDeductMaster.Add(entTemp); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
public EntityObject[] GetLookupData(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID) { AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); List <object> objArgs = new List <object>(); string strOrderBy = string.Empty; strOrderBy = " DEDUCTMASTERID "; objArgs.AddRange(paras); SetOrganizationFilter(ref filterString, ref objArgs, userID, "T_HR_ATTENDANCEDEDUCTMASTER"); IQueryable <T_HR_ATTENDANCEDEDUCTMASTER> ents = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray()); T_HR_ATTENDANCEDEDUCTMASTER[] temp = ents.Count() > 0 ? ents.ToArray() : null; return(temp); }
/// <summary> /// 修改考勤异常扣款主表信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string ModifyDeductMaster(T_HR_ATTENDANCEDEDUCTMASTER entTemp) { string strMsg = string.Empty; try { if (entTemp == null) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" DEDUCTMASTERID == @0"); objArgs.Add(entTemp.DEDUCTMASTERID); AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); flag = dalAttendanceDeductMaster.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } //dalAttendanceDeductMaster.DataContext.SaveChanges(); T_HR_ATTENDANCEDEDUCTMASTER entUpdate = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); Utility.CloneEntity(entTemp, entUpdate); dalAttendanceDeductMaster.Update(entUpdate); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 获取考勤异常扣款信息 /// </summary> /// <param name="strAttendanceDeductMasterId">主键索引</param> /// <returns></returns> public T_HR_ATTENDANCEDEDUCTMASTER GetAttendanceDeductMasterByID(string strAttendanceDeductMasterId) { if (string.IsNullOrEmpty(strAttendanceDeductMasterId)) { return(null); } AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); if (!string.IsNullOrEmpty(strAttendanceDeductMasterId)) { strfilter.Append(" DEDUCTMASTERID == @0"); objArgs.Add(strAttendanceDeductMasterId); } T_HR_ATTENDANCEDEDUCTMASTER entRd = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strfilter.ToString(), objArgs.ToArray()); return(entRd); }
/// <summary> /// 根据主键索引,删除考勤异常扣款信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteDeductMaster(string strAttendanceDeductMasterId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strAttendanceDeductMasterId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strAttDedFilter = new StringBuilder(); List <string> objAttDedArgs = new List <string>(); strAttDedFilter.Append(" DEDUCTMASTERID == @0"); objAttDedArgs.Add(strAttendanceDeductMasterId); AttendanceDeductMasterDAL dalAttendanceDeductMaster = new AttendanceDeductMasterDAL(); flag = dalAttendanceDeductMaster.IsExistsRd(strAttDedFilter.ToString(), objAttDedArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } StringBuilder strAttDetailFilter = new StringBuilder(); List <string> objAttDetailArgs = new List <string>(); strAttDetailFilter.Append(" T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @0"); objAttDetailArgs.Add(strAttendanceDeductMasterId); AttendanceDeductDetailBLL bllAttendanceDeductDetail = new AttendanceDeductDetailBLL(); bllAttendanceDeductDetail.DeleteDeductDetailByMasterID(strAttendanceDeductMasterId); StringBuilder strAttSolDedFilter = new StringBuilder(); List <string> objAttSolDedArgs = new List <string>(); strAttSolDedFilter.Append(" T_HR_ATTENDANCESOLUTION.CHECKSTATE != @0"); strAttSolDedFilter.Append(" && T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @1"); objAttSolDedArgs.Add(Convert.ToInt32(CheckStates.UnSubmit).ToString()); objAttSolDedArgs.Add(strAttendanceDeductMasterId); AttendanceSolutionDeductBLL bllAttendanceSolutionDeduct = new AttendanceSolutionDeductBLL(); flag = bllAttendanceSolutionDeduct.IsExistsRd(strAttSolDedFilter.ToString(), objAttSolDedArgs.ToArray()); if (flag) { return("已存在进入审核状态的考勤方案与当前的考勤异常扣款设置有关联,不能直接删除"); } T_HR_ATTENDANCEDEDUCTMASTER entDel = dalAttendanceDeductMaster.GetAttendanceDeductMasterRdByMultSearch(strAttDedFilter.ToString(), objAttDedArgs.ToArray()); dalAttendanceDeductMaster.Delete(entDel); strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }