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