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