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