/// <summary>
/// 获取排班模板信息
/// </summary>
/// <param name="strSchedulingTemplateMasterId">主键索引</param>
/// <returns></returns>
public T_HR_SCHEDULINGTEMPLATEMASTER GetSchedulingTemplateMasterByAttSolID(string strAttendanceSolutionId)
{
if (string.IsNullOrEmpty(strAttendanceSolutionId))
{
return(null);
}
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
T_HR_SCHEDULINGTEMPLATEMASTER entRd = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterByAttSolID(strAttendanceSolutionId);
return(entRd);
}
/// <summary>
/// 根据条件，获取排班模板信息
/// </summary>
/// <param name="strSchedulingTemplateName"></param>
/// <param name="strCircleType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public IQueryable <T_HR_SCHEDULINGTEMPLATEMASTER> GetAllSchedulingTemplateMasterRdListByMultSearch(string strOwnerID, string strSchedulingTemplateName, string strCircleType, string strSortKey)
{
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
StringBuilder strfilter = new StringBuilder();
List <object> objArgs = new List <object>();
string strOrderBy = string.Empty;
int iIndex = 0;
if (!string.IsNullOrEmpty(strSchedulingTemplateName))
{
strfilter.Append(" @0.Contains(TEMPLATENAME)");
objArgs.Add(strSchedulingTemplateName);
}
if (!string.IsNullOrEmpty(strCircleType))
{
if (!string.IsNullOrEmpty(strfilter.ToString()))
{
strfilter.Append(" AND");
}
if (objArgs.Count() > 0)
{
iIndex = objArgs.Count();
}
strfilter.Append(" SCHEDULINGCIRCLETYPE == @" + iIndex.ToString());
objArgs.Add(strCircleType);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " TEMPLATEMASTERID ";
}
string filterString = strfilter.ToString();
SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_HR_OVERTIMEREWARD");
var q = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterRdListByMultSearch(strOrderBy, filterString, objArgs.ToArray());
return(q);
}
public EntityObject[] GetLookupData(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, string userID)
{
string state = ((int)EditStates.Actived).ToString();
string checkState = ((int)CheckStates.Approved).ToString();
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
string strOrderBy = string.Empty;
strOrderBy = " TEMPLATEMASTERID ";
IQueryable <T_HR_SCHEDULINGTEMPLATEMASTER> ents = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs);
return(ents.Count() > 0 ? ents.ToArray() : null);
}
/// <summary>
/// 修改排班模板信息
/// </summary>
/// <param name="entLTRd"></param>
/// <returns></returns>
public string ModifyTemplateMaster(T_HR_SCHEDULINGTEMPLATEMASTER 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(" TEMPLATEMASTERID == @0");
objArgs.Add(entTemp.TEMPLATEMASTERID);
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
flag = dalSchedulingTemplateMaster.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
T_HR_SCHEDULINGTEMPLATEMASTER entUpdate = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
entUpdate.TEMPLATENAME = entTemp.TEMPLATENAME;
entUpdate.SCHEDULINGCIRCLETYPE = entTemp.SCHEDULINGCIRCLETYPE;
entUpdate.REMARK = entTemp.REMARK;
entUpdate.UPDATEDATE = entTemp.UPDATEDATE;
entUpdate.UPDATEUSERID = entTemp.UPDATEUSERID;
entUpdate.CREATEDATE = entTemp.CREATEDATE;
entUpdate.CREATEUSERID = entTemp.CREATEUSERID;
dalSchedulingTemplateMaster.Update(entUpdate);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 根据主键索引，删除排班模板信息(注：暂定为物理删除)
/// </summary>
/// <param name="strVacationId">主键索引</param>
/// <returns></returns>
public string DeleteTemplateMaster(string strSchedulingTemplateMasterId)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strSchedulingTemplateMasterId))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" TEMPLATEMASTERID == @0");
objArgs.Add(strSchedulingTemplateMasterId);
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
flag = dalSchedulingTemplateMaster.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
//先删除明细表记录
SchedulingTemplateDetailBLL bllSchedulingTemplateDetail = new SchedulingTemplateDetailBLL();
bllSchedulingTemplateDetail.DeleteByTemplateMasterID(strSchedulingTemplateMasterId);
//无异常出现，即删除主表记录
T_HR_SCHEDULINGTEMPLATEMASTER entDel = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
dalSchedulingTemplateMaster.Delete(entDel);
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
/// <summary>
/// 获取排班模板信息
/// </summary>
/// <param name="strSchedulingTemplateMasterId">主键索引</param>
/// <returns></returns>
public T_HR_SCHEDULINGTEMPLATEMASTER GetSchedulingTemplateMasterByID(string strSchedulingTemplateMasterId)
{
if (string.IsNullOrEmpty(strSchedulingTemplateMasterId))
{
return(null);
}
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strSchedulingTemplateMasterId))
{
strfilter.Append(" TEMPLATEMASTERID == @0");
objArgs.Add(strSchedulingTemplateMasterId);
}
T_HR_SCHEDULINGTEMPLATEMASTER entRd = dalSchedulingTemplateMaster.GetSchedulingTemplateMasterRdByMultSearch(strfilter.ToString(), objArgs.ToArray());
return(entRd);
}
/// <summary>
/// 新增排班模板信息
/// </summary>
/// <param name="entTemp"></param>
/// <returns></returns>
public string AddTemplateMaster(T_HR_SCHEDULINGTEMPLATEMASTER 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(" TEMPLATENAME == @0");
objArgs.Add(entTemp.TEMPLATENAME);
SchedulingTemplateMasterDAL dalSchedulingTemplateMaster = new SchedulingTemplateMasterDAL();
flag = dalSchedulingTemplateMaster.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (flag)
{
return("{ALREADYEXISTSRECORD}");
}
dalSchedulingTemplateMaster.Add(entTemp);
strMsg = "{SAVESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}
