public Resp_Index <LayoutDTO> Index(Req_Index request) { var response = new Resp_Index <LayoutDTO>(); var limits = _sysRightRepository.GetRightByUserWithModule(request.userId, request.moduleId).ConvertoDto <SysUserRightView, SysModuleOperateIndexDTO>().ToList(); if (limits.IsNotNull() && limits.Count > 0 && limits.Find(s => s.IsValid == 1).IsNotNull()) { response.allowVisit = true; response.moduleOperaties = limits.OrderByDescending(t => t.IsValid).GroupBy(t => new { t.KeyCode, t.KeyName }).Select(s => new SysModuleOperateIndexDTO { KeyCode = s.Key.KeyCode, KeyName = s.Key.KeyName, IsValid = s.Sum(x => x.IsValid), }).ToList(); var query_parameter = new Layout_Query { PgIndex = 1, PgSize = request.PgSize }; response.query = Query(query_parameter); } else { _sysRightRepository.UnitOfWork.Commite(); response.allowVisit = false; response.message = "无访问权限,请联系管理员"; } return(response); }
public Resp_Query <LayoutDTO> Query(Layout_Query request) { var response = new Resp_Query <LayoutDTO>(); var records = _repository.GetAll(); records.ToMaybe() .Do(d => request.Verify()) .DoWhen(t => !string.IsNullOrEmpty(request.CarNumber), d => records = records.Where(s => s.CarNumber.Contains(request.CarNumber))) .DoWhen(t => !string.IsNullOrEmpty(request.Channel), d => records = records.Where(s => s.Channel.Equals(request.Channel))); if (!string.IsNullOrEmpty(request.Trigger) && int.TryParse(request.Trigger, out int result)) { records = records.Where(s => s.TriggerType == result); } if (request.IsValid.ToInt() == 1) { records = records.Where(s => s.IsValid == 1); } if (request.IsValid.ToInt() == 0) { records = records.Where(s => s.IsValid == 0); } if (!string.IsNullOrEmpty(request.BeginTime) && DateTime.TryParse(request.BeginTime, out DateTime start)) //Linq to entity 不支持datatime.parse函数 { records = records.Where(s => s.CreateTime >= start); } if (!string.IsNullOrEmpty(request.EndTime) && DateTime.TryParse(request.EndTime, out DateTime end)) { records = records.Where(s => s.CreateTime <= end); } response.totalCounts = records.Count(); response.totalRows = (int)Math.Ceiling((double)response.totalCounts / request.PgSize); if (!string.IsNullOrEmpty(request.Order)) { records = records.DataSorting(request.Order, request.Esc); } else { records = records.OrderByDescending(o => o.ID); } response.entities = records.Skip(request.PgSize * (request.PgIndex - 1)).Take(request.PgSize).ToList().ConvertoDto <Layout, LayoutDTO>().ToList(); return(response); }