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