/// <summary> /// 新增带薪假设置信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string AddFreeLeaveDaySet(T_HR_FREELEAVEDAYSET entTemp) { string strMsg = string.Empty; try { if (entTemp == null) { return("{REQUIREDFIELDS}"); } T_HR_FREELEAVEDAYSET ent = new T_HR_FREELEAVEDAYSET(); Utility.CloneEntity <T_HR_FREELEAVEDAYSET>(entTemp, ent); ent.T_HR_LEAVETYPESETReference.EntityKey = new System.Data.EntityKey("SMT_HRM_EFModelContext.T_HR_LEAVETYPESET", "LEAVETYPESETID", entTemp.T_HR_LEAVETYPESET.LEAVETYPESETID); Utility.RefreshEntity(ent); FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); dalFreeLeaveDaySet.Add(ent); 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) { FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); string strOrderBy = string.Empty; strOrderBy = "FREELEAVEDAYSETID"; IQueryable <T_HR_FREELEAVEDAYSET> ents = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs); return(ents.Count() > 0 ? ents.ToArray() : null); }
/// <summary> /// 根据条件,获取带薪假设置信息 /// </summary> /// <param name="strOwnerID">权限控制所有人的员工序号</param> /// <param name="strLeaveTypeSetID">考勤方案外键索引</param> /// <param name="strIsFactor">是否扣全勤</param> /// <param name="strSortKey">排序字段</param> /// <returns></returns> public IQueryable <T_HR_FREELEAVEDAYSET> GetAllFreeLeaveDaySetRdListByMultSearch(string strOwnerID, string strLeaveTypeSetID, string strIsFactor, string strSortKey) { FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); StringBuilder strfilter = new StringBuilder(); List <object> objArgs = new List <object>(); string strOrderBy = string.Empty; int iIndex = 0; if (!string.IsNullOrEmpty(strLeaveTypeSetID)) { strfilter.Append(" T_HR_LEAVETYPESET.LEAVETYPESETID == @0"); objArgs.Add(strLeaveTypeSetID); } if (!string.IsNullOrEmpty(strIsFactor)) { if (!string.IsNullOrEmpty(strfilter.ToString())) { strfilter.Append(" AND"); } if (objArgs.Count() > 0) { iIndex = objArgs.Count(); } strfilter.Append(" ISPERFECTATTENDANCEFACTOR == @" + iIndex.ToString()); objArgs.Add(strIsFactor); } if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " FREELEAVEDAYSETID "; } string filterString = strfilter.ToString(); //T_HR_LEAVETYPESET //SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_FREELEAVEDAYSET"); //注释原因,使用的是T_HR_FREELEAVEDAYSET,T_HR_FREELEAVEDAYSET没有权限设置 SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_LEAVETYPESET"); var q = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray()); return(q); }
/// <summary> /// 修改带薪假设置信息 /// </summary> /// <param name="entLTRd"></param> /// <returns></returns> public string ModifyFreeLeaveDaySet(T_HR_FREELEAVEDAYSET 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(" FREELEAVEDAYSETID == @0"); objArgs.Add(entTemp.FREELEAVEDAYSETID); FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); flag = dalFreeLeaveDaySet.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_FREELEAVEDAYSET entUpdate = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); //Utility.RefreshEntity(entUpdate); Utility.CloneEntity <T_HR_FREELEAVEDAYSET>(entTemp, entUpdate); if (entUpdate.T_HR_LEAVETYPESETReference.EntityKey == null) { entUpdate.T_HR_LEAVETYPESETReference.EntityKey = new System.Data.EntityKey("TM_SaaS_OA_EFModelContext.T_HR_LEAVETYPESET", "LEAVETYPESETID", entTemp.T_HR_LEAVETYPESET.LEAVETYPESETID); } if (entUpdate.T_HR_LEAVETYPESET != null) { ModifyLeaveTypeSetDays(entTemp, entUpdate); } dalFreeLeaveDaySet.Update(entUpdate); strMsg = "{SAVESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 根据考勤方案主键索引,获取其配置的带薪假设置信息 /// </summary> /// <param name="strAttendanceSolutionId">配置带薪假的考勤方案主键索引</param> /// <param name="strSortKey">排序字段</param> /// <returns>返回带薪假设置信息</returns> public IQueryable <T_HR_FREELEAVEDAYSET> GetFreeLeaveDaySetRdListForAttendanceSolution(string strAttendanceSolutionId, string strSortKey) { FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); string strOrderBy = string.Empty; if (!string.IsNullOrEmpty(strSortKey)) { strOrderBy = strSortKey; } else { strOrderBy = " FREELEAVEDAYSETID "; } var q = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdListForAttendanceSolution(strOrderBy, strAttendanceSolutionId); return(q); }
/// <summary> /// 获取带薪假设置信息 /// </summary> /// <param name="strFreeLeaveDaySetId">主键索引</param> /// <returns></returns> public T_HR_FREELEAVEDAYSET GetFreeLeaveDaySetByID(string strFreeLeaveDaySetId) { if (string.IsNullOrEmpty(strFreeLeaveDaySetId)) { return(null); } FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); StringBuilder strfilter = new StringBuilder(); List <string> objArgs = new List <string>(); if (!string.IsNullOrEmpty(strFreeLeaveDaySetId)) { strfilter.Append(" FREELEAVEDAYSETID == @0"); objArgs.Add(strFreeLeaveDaySetId); } T_HR_FREELEAVEDAYSET entRd = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdByMultSearch(strfilter.ToString(), objArgs.ToArray()); return(entRd); }
/// <summary> /// 根据主键索引,删除带薪假设置信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteFreeLeaveDaySet(string strFreeLeaveDaySetId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strFreeLeaveDaySetId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" FREELEAVEDAYSETID == @0"); objArgs.Add(strFreeLeaveDaySetId); FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); flag = dalFreeLeaveDaySet.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_FREELEAVEDAYSET entDel = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); dalFreeLeaveDaySet.Delete(entDel); strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }
/// <summary> /// 根据主键索引,删除带薪假设置信息(注:暂定为物理删除) /// </summary> /// <param name="strVacationId">主键索引</param> /// <returns></returns> public string DeleteFreeLeaveDaySet(string strFreeLeaveDaySetId) { string strMsg = string.Empty; try { if (string.IsNullOrEmpty(strFreeLeaveDaySetId)) { return("{REQUIREDFIELDS}"); } bool flag = false; StringBuilder strFilter = new StringBuilder(); List <string> objArgs = new List <string>(); strFilter.Append(" FREELEAVEDAYSETID == @0"); objArgs.Add(strFreeLeaveDaySetId); FreeLeaveDaySetDAL dalFreeLeaveDaySet = new FreeLeaveDaySetDAL(); flag = dalFreeLeaveDaySet.IsExistsRd(strFilter.ToString(), objArgs.ToArray()); if (!flag) { return("{NOTFOUND}"); } T_HR_FREELEAVEDAYSET entDel = dalFreeLeaveDaySet.GetFreeLeaveDaySetRdByMultSearch(strFilter.ToString(), objArgs.ToArray()); T_HR_LEAVETYPESET delSet = entDel.T_HR_LEAVETYPESET; dalFreeLeaveDaySet.Delete(entDel); //删除后修改员工带薪假期中的最大天数 if (delSet != null) { var entSet = from ent in dal.GetObjects <T_HR_LEAVETYPESET>() where ent.LEAVETYPESETID == entDel.T_HR_LEAVETYPESET.LEAVETYPESETID select ent; var entFreeSets = from ent in dal.GetObjects <T_HR_FREELEAVEDAYSET>().Include("T_HR_LEAVETYPESET") where ent.T_HR_LEAVETYPESET.LEAVETYPESETID == delSet.LEAVETYPESETID select ent; if (entFreeSets != null) { if (entFreeSets.Count() > 0) { var maxDays = entFreeSets.Max(s => s.LEAVEDAYS); var maxFrees = entFreeSets.ToList().OrderByDescending(s => s.LEAVEDAYS); T_HR_FREELEAVEDAYSET maxFree = maxFrees.FirstOrDefault(); BatchModifyEmployeeFreeLeaveRecords(maxFree, maxFree); } else { //修改为t_hr_leavetypeset中的天数 if (delSet.LEAVETYPEVALUE != (Convert.ToInt32(Common.LeaveTypeValue.AdjustLeave) + 1).ToString() && delSet.LEAVETYPEVALUE != (Convert.ToInt32(Common.LeaveTypeValue.AnnualLeave) + 1).ToString()) { try { DateTime dtNow = DateTime.Now; //格式化为当前年份 //dtNow = DateTime.Parse(dtNow.Year.ToString() + "-01-01"); var ents = from ent in dal.GetObjects <T_HR_EMPLOYEELEVELDAYCOUNT>() where ent.LEAVETYPESETID == delSet.LEAVETYPESETID && ent.EFFICDATE.Value.Year >= dtNow.Year select ent; if (ents.Count() > 0) { foreach (var ent in ents) { ent.REMARK += "原来为:" + ent.DAYS.ToString() + ";修改后重新设置天数:" + entDel.LEAVEDAYS.ToString(); ent.DAYS = delSet.MAXDAYS; dal.UpdateFromContext(ent); } int intResult = dal.SaveContextChanges(); if (intResult > 0) { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数成功"); } else { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数失败"); } } } catch (Exception ex) { SMT.Foundation.Log.Tracer.Debug("公共假期类型:" + delSet.LEAVETYPENAME + "修改带薪假天数出现错误:" + ex.ToString()); } } } } } strMsg = "{DELETESUCCESSED}"; } catch (Exception ex) { strMsg = ex.Message.ToString(); } return(strMsg); }