/// <summary> /// 新增考勤方案异常扣款信息 /// </summary> /// <param name="entTemp"></param> /// <returns></returns> public string AddAttSolDeduct(T_HR_ATTENDANCESOLUTIONDEDUCT 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(" T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID == @0"); strFilter.Append(" && T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID == @1"); objArgs.Add(entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID); objArgs.Add(entTemp.T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID); AttendanceSolutionDeductDAL dalAttendanceSolutionDeduct = new AttendanceSolutionDeductDAL(); flag = dalAttendanceSolutionDeduct.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (flag) { return("{ALREADYEXISTSRECORD}"); } T_HR_ATTENDANCESOLUTIONDEDUCT ent = new T_HR_ATTENDANCESOLUTIONDEDUCT(); Utility.CloneEntity <T_HR_ATTENDANCESOLUTIONDEDUCT>(entTemp, ent); ent.T_HR_ATTENDANCESOLUTIONReference.EntityKey = new System.Data.EntityKey("SMT_HRM_EFModelContext.T_HR_ATTENDANCESOLUTION", "ATTENDANCESOLUTIONID", entTemp.T_HR_ATTENDANCESOLUTION.ATTENDANCESOLUTIONID); ent.T_HR_ATTENDANCEDEDUCTMASTERReference.EntityKey = new System.Data.EntityKey("SMT_HRM_EFModelContext.T_HR_ATTENDANCEDEDUCTMASTER", "DEDUCTMASTERID", entTemp.T_HR_ATTENDANCEDEDUCTMASTER.DEDUCTMASTERID); dalAttendanceSolutionDeduct.Add(ent); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 修改T_HR_ATTENDANCESOLUTIONDEDUCT信息 /// </summary> /// <param name="entTemp"></param> /// <returns></returns> public string ModifyAttSolDeduct(T_HR_ATTENDANCESOLUTIONDEDUCT 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(" SOLUTIONDEDUCTID == @0"); objArgs.Add(entTemp.SOLUTIONDEDUCTID); AttendanceSolutionDeductDAL dalAttendanceSolutionDeduct = new AttendanceSolutionDeductDAL(); flag = dalAttendanceSolutionDeduct.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_ATTENDANCESOLUTIONDEDUCT entUpdate = dalAttendanceSolutionDeduct.GetAttendanceSolutionDeductRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); entUpdate.T_HR_ATTENDANCESOLUTION = entTemp.T_HR_ATTENDANCESOLUTION; entUpdate.T_HR_ATTENDANCEDEDUCTMASTER = entTemp.T_HR_ATTENDANCEDEDUCTMASTER; entUpdate.REMARK = entTemp.REMARK; entUpdate.CREATEUSERID = entTemp.CREATEUSERID; entUpdate.CREATEDATE = entTemp.CREATEDATE; entUpdate.UPDATEUSERID = entTemp.UPDATEUSERID; entUpdate.UPDATEDATE = entTemp.UPDATEDATE; dalAttendanceSolutionDeduct.Update(entUpdate); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 根据参数,检查是否存在指定记录(方便进行数据增删改) /// </summary> /// <param name="strFilter">查询语句</param> /// <param name="objArgs">查询参数集合</param> /// <returns>True/False(是/否)</returns> public bool IsExistsRd(string strFilter, params object[] objArgs) { bool flag = false; if (string.IsNullOrEmpty(strFilter) && objArgs == null) { return(false); } if (objArgs.Count() == 0) { return(false); } AttendanceSolutionDeductDAL dalAttendanceSolutionDeduct = new AttendanceSolutionDeductDAL(); flag = dalAttendanceSolutionDeduct.IsExistsRd(strFilter, objArgs); return(flag); }
/// <summary> /// 根据主键索引,删除T_HR_ATTENDANCESOLUTIONDEDUCT信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteAttSolDeduct(string strAttendanceSolutionDeductId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strAttendanceSolutionDeductId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" SOLUTIONDEDUCTID == @0"); objArgs.Add(strAttendanceSolutionDeductId); AttendanceSolutionDeductDAL dalAttendanceSolutionDeduct = new AttendanceSolutionDeductDAL(); flag = dalAttendanceSolutionDeduct.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_ATTENDANCESOLUTIONDEDUCT entDel = dalAttendanceSolutionDeduct.GetAttendanceSolutionDeductRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); dalAttendanceSolutionDeduct.Delete(entDel); strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }