/// <summary> /// 获取限制数据权限后的数据 /// 数据权限限制为分公司或者创建者 /// yanminchun 2016-10-12 增加数据权限限制 /// </summary> /// <param name="start"></param> /// <param name="end"></param> /// <param name="user"></param> /// <returns></returns> public IQueryable <BaseAudit> GetAllAuthorizeAndSelf(DateTime?start, DateTime?end, Infrastructure.Identity.Model.User user) { BaseAuditDAL bd = new BaseAuditDAL(); var pers = GetDataPermission(user); var predicate = PredicateBuilder.True <BaseAudit>(); predicate = predicate.And(testc => pers.Contains(testc.DistrictID)); predicate = predicate.And(testc => pers.Contains(testc.SalesGroupID)); predicate = predicate.Or(t => t.CreateUser == user.UserName); var modellist = bd.GetHasStatus(CaseStatus.Lending); modellist = modellist.Where(predicate); if (start != null) { var starttime = new DateTime(start.Value.Year, start.Value.Month, start.Value.Day).AddSeconds(-1); modellist = modellist.Where(t => t.LendingDate >= starttime); } if (end != null) { var endtime = new DateTime(end.Value.Year, end.Value.Month, end.Value.Day).AddDays(1); modellist = modellist.Where(t => t.LendingDate < endtime); } return(modellist); }
public IQueryable <BaseAudit> GetAll(DateTime?start, DateTime?end) { BaseAuditDAL bd = new BaseAuditDAL(); var modellist = bd.GetHasStatus(CaseStatus.Lending); if (start != null) { var starttime = new DateTime(start.Value.Year, start.Value.Month, start.Value.Day).AddSeconds(-1); modellist = modellist.Where(t => t.LendingDate >= starttime); } if (end != null) { var endtime = new DateTime(end.Value.Year, end.Value.Month, end.Value.Day).AddDays(1); modellist = modellist.Where(t => t.LendingDate < endtime); } return(modellist); }