public IQueryable <BaseAudit> Query(User user, Expression <Func <BaseAudit, bool> > expression)
{
IQueryable <UserRole> roles = _user2RoleDal.GetUser2RoleByUserId(user.Id);
List <DataPermission> permissions = new List <DataPermission>();
foreach (var role in roles)
{
permissions.AddRange(_permissionDal.GetAll().Where(t => t.RoleID == role.RoleID));
}
string[] permissionsId = permissions.Distinct().Select(p => p.DataPermissionID).ToArray();
expression = expression.And(p => permissionsId.Contains(p.DistrictID));
expression = expression.And(p => permissionsId.Contains(p.SalesGroupID));
//expression = expression.Or(p => p.CreateUser == user.UserName);
return(_auditDal.GetAll().Where(expression).OrderByDescending(t => t.CreateTime));
}
private void UpdateAuditCaseNum(BaseAuditDAL baseAuditDal, SalesGroupDAL salesGroupDal)
{
string[] caseNum = baseAuditDal.GetAll().Where(p => p.CaseNum != null).Select(p => p.CaseNum).Distinct().ToArray();
caseNum.ForEach(p =>
{
var sameCaseNumCases = baseAuditDal.GetAllBase().Where(c => c.CaseNum == p).ToList();
var salesGroupId = sameCaseNumCases.First().SalesGroupID;
var salesGroup = salesGroupDal.GetAll().First(t => t.ID == salesGroupId);
sameCaseNumCases.ForEach(t =>
{
t.CaseNum = (Convert.ToInt32(t.CaseNum.Substring(4)) + 100000).ToString();
t.NewCaseNum = "L" + salesGroup.ShortCode + "-" + t.CaseNum;
});
baseAuditDal.UpdateRange(sameCaseNumCases);
baseAuditDal.AcceptAllChange();
});
}
/// <summary>
/// 获取所有贷后案件
/// </summary>
/// <returns></returns>
private IQueryable <BaseAudit> GetAllAfterCases()
{
return(_auditDal.GetAll().Where(p => p.CaseStatus == CaseStatus.AfterCase));
}
/// <summary>
/// 获取所有已结清案件
/// </summary>
/// <returns>结清案件</returns>
private IQueryable <BaseAudit> GetAllFinishedCase()
{
return(_auditDal.GetAll(p => p.CaseStatus == CaseStatus.FinishCase));
}