//private bool IsExistWelfareDetails(T_OA_WELFAREDETAIL DetailsWelfare)//检查子表
//{
// SMT_OA_EFModelContext context = new SMT_OA_EFModelContext();
// bool IsExist = false;
// var ents = from a in context.T_OA_WELFAREDETAIL
// where ((a.ISLEVEL == DetailsWelfare.ISLEVEL && a.POSTLEVELA == DetailsWelfare.POSTLEVELA && a.POSTLEVELB == DetailsWelfare.POSTLEVELB) ||
// (a.ISLEVEL == DetailsWelfare.ISLEVEL && a.POSTID == DetailsWelfare.POSTID))
// select a;
// //var ents = from a in context.T_OA_WELFAREDETAIL
// // where a.POSTID == DetailsWelfare.POSTID && a.POSTLEVELA == DetailsWelfare.POSTLEVELA && a.POSTLEVELB == DetailsWelfare.POSTLEVELB
// // select a;
// if (ents.Count() > 0)
// {
// IsExist = true;
// }
// return IsExist;
//}
#endregion
#region 根据福利备注检查
public List <string> GetWelfareRoomNameInfos()
{
BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL();
var query = from p in bad.GetTable()
orderby p.CREATEDATE descending
select p.REMARK;
return(query.ToList <string>());
}
/// <summary>
/// 获取福利标准信息
/// </summary>
/// <returns></returns>
public List <T_OA_WELFAREMASERT> GetWelfareRooms()
{
BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL();
var query = from p in bad.GetTable()
orderby p.CREATEDATE descending
select p;
return(query.ToList <T_OA_WELFAREMASERT>());
}
/// <summary>
/// 获取所有的福利标准信息
/// </summary>
/// <returns>返回结果</returns>
public IQueryable <T_OA_WELFAREMASERT> GetWelfareStandard()
{
BenefitsAdministrationDAL bad = new BenefitsAdministrationDAL();
var entity = from p in bad.GetTable()
orderby p.CREATEDATE descending
select p;
return(entity.Count() > 0 ? entity : null);
}
