/// <summary> /// 查询数据 /// </summary> /// <returns></returns> public ActionResult List(string name, string number, int?timeoutSettingId, DateTime?startDate, DateTime?endDate, bool?isUsed, bool isEnabled = true, int pageIndex = 1, int pageSize = 10) { var adminId = AuthorityHelper.OperatorId.Value; var query = _contract.Entities.Where(e => e.IsEnabled == isEnabled); // 权限--可管理部门 var departmentIds = _storeContract.QueryManageDepartmentId(adminId, false); query = query.Where(e => e.RequestAdminId == adminId || departmentIds.Contains(e.DepartmentId)); if (!string.IsNullOrEmpty(name)) { query = query.Where(e => e.RequestAdmin.Member.RealName.StartsWith(name)); } if (!string.IsNullOrEmpty(number) && number.Length > 0) { query = query.Where(e => e.Number.StartsWith(number)); } if (timeoutSettingId.HasValue) { query = query.Where(e => e.TimeoutSettingId == timeoutSettingId.Value); } if (startDate.HasValue) { query = query.Where(e => e.CreatedTime >= startDate.Value); } if (endDate.HasValue) { query = query.Where(e => e.CreatedTime <= endDate.Value); } if (isUsed.HasValue) { query = query.Where(e => e.IsUsed == isUsed.Value); } var list = query.OrderByDescending(e => e.UpdatedTime) .Skip((pageIndex - 1) * pageSize) .Take(pageSize) .Select(e => new { e.Id, e.IsDeleted, e.IsEnabled, e.CreatedTime, e.UpdatedTime, e.Department.DepartmentName, TimeoutType = e.TimeoutType.Name, e.Number, e.Timeouts, RequestName = e.RequestAdmin.Member.RealName, VerifyName = e.VerifyAdmin.Member.RealName, State = e.State.ToString(), e.IsUsed }).ToList(); var res = new OperationResult(OperationResultType.Success, string.Empty, new { pageData = list, pageInfo = new PageDto { pageIndex = pageIndex, pageSize = pageSize, totalCount = query.Count(), } }); return(Json(res, JsonRequestBehavior.AllowGet)); }