/// <summary>
/// 根据条件，获取排班模板明细信息
/// </summary>
/// <param name="strTemplateMasterId">排班模板主表主键索引</param>
/// <param name="strSortKey">排序字段</param>
/// <returns></returns>
public IQueryable <T_HR_SCHEDULINGTEMPLATEDETAIL> GetAllSchedulingTemplateDetailRdListByMultSearch(string strTemplateMasterId, string strSortKey)
{
SchedulingTemplateDetailDAL dalSchedulingTemplateDetail = new SchedulingTemplateDetailDAL();
StringBuilder strfilter = new StringBuilder();
List <string> objArgs = new List <string>();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strTemplateMasterId))
{
strfilter.Append(" T_HR_SCHEDULINGTEMPLATEMASTER.TEMPLATEMASTERID == @0");
objArgs.Add(strTemplateMasterId);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " TEMPLATEDETAILID ";
}
var q = dalSchedulingTemplateDetail.GetSchedulingTemplateDetailRdListByMultSearch(strOrderBy, strfilter.ToString(), objArgs.ToArray());
return(q);
}
/// <summary>
/// 根据排班模板主表主键索引，删除关联的排班模板明细记录
/// </summary>
/// <param name="strTemplateMasterID">排班模板主表主键索引</param>
/// <returns>返回处理后的消息</returns>
public string DeleteByTemplateMasterID(string strTemplateMasterID)
{
string strMsg = string.Empty;
try
{
if (string.IsNullOrEmpty(strTemplateMasterID))
{
return("{REQUIREDFIELDS}");
}
bool flag = false;
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
strFilter.Append(" T_HR_SCHEDULINGTEMPLATEMASTER.TEMPLATEMASTERID == @0");
objArgs.Add(strTemplateMasterID);
SchedulingTemplateDetailDAL dalSchedulingTemplateDetail = new SchedulingTemplateDetailDAL();
flag = dalSchedulingTemplateDetail.IsExistsRd(strFilter.ToString(), objArgs.ToArray());
if (!flag)
{
return("{NOTFOUND}");
}
string strOrderBy = " TEMPLATEDETAILID ";
var q = dalSchedulingTemplateDetail.GetSchedulingTemplateDetailRdListByMultSearch(strOrderBy, strFilter.ToString(), objArgs.ToArray());
if (q == null)
{
return(strMsg);
}
if (q.Count() == 0)
{
return(strMsg);
}
foreach (T_HR_SCHEDULINGTEMPLATEDETAIL item in q)
{
dalSchedulingTemplateDetail.Delete(item);
}
strMsg = "{DELETESUCCESSED}";
}
catch (Exception ex)
{
strMsg = ex.Message.ToString();
}
return(strMsg);
}