public TableData GetList(string dictType, QueryListReq req)
{
var query = _dictRepository.Table;
if (!dictType.IsBlank())
{
query = query.Where(a => a.DictType.ToLower() == dictType.ToLower());
}
if (!req.keyword.IsBlank())
{
query = query.Where(a => a.DictName.Contains(req.keyword));
}
query = query.OrderByDescending(o => o.DictID);
var pagedList = query.ToPagedList(req.page, req.pageSize);
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = pagedList
});
}
public IHttpActionResult GetList([FromUri] QueryListReq req)
{
if (null == req)
{
req = new QueryListReq();
}
var table = doorService.GetList(req);
return(Ok(new
{
code = 0,
msg = "success",
data = table
}));
}
public IHttpActionResult GetSelectList()
{
QueryListReq req = new QueryListReq()
{
page = 1, pageSize = int.MaxValue
};
var table = roleService.GetList(req);
return(Ok(new
{
code = 0,
msg = "success",
data = table.list
}));
}
public IHttpActionResult GetList(int page = 1, int pageSize = 20, string keyword = "")
{
var req = new QueryListReq()
{
page = page,
pageSize = pageSize,
keyword = keyword
};
var table = configService.GetList(req);
return(Ok(new {
code = 0,
msg = "",
data = table
}));
}
/// <summary>
/// 获取合同列表分页
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public TableData GetList(QueryListReq req)
{
var query = _contractRepository.Table;
query = query.OrderByDescending(o => o.DateFrom);
var pagedList = query.ToPagedList(req.page, req.pageSize);
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = pagedList
});
}
public TableData GetList(QueryListReq req)
{
var query = _userRepository.Table;
query = query.Where(o => !o.Deleted);
if (!string.IsNullOrEmpty(req.keyword))
{
query = query.Where(o => o.UserName.Contains(req.keyword));
}
query = query.OrderByDescending(o => o.UserID);
var pagedList = query.ToPagedList(req.page, req.pageSize);
var list = new List <UserDto>();
foreach (var user in pagedList.ToList())
{
UserDto userDto = user.MapTo <UserDto>();
if (user.Roles != null)
{
userDto.RoleIds = string.Join(",", user.Roles.Select(o => o.RoleID));
userDto.RoleNames = string.Join(",", user.Roles.Select(o => o.RoleName));
}
else
{
userDto.RoleIds = "";
userDto.RoleNames = "";
}
userDto.Password = "";
var commuity = _areaRepository.GetById(user.CommunityUUID);
userDto.CommunityName = commuity != null?commuity.ChineseName:"";
list.Add(userDto);
}
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = list
});
}
public TableData GetList(QueryListReq req)
{
var query = _configRepository.Table;
if (!req.keyword.IsBlank())
{
query = query.Where(a => a.ConfigName.Contains(req.keyword));
}
query = query.OrderByDescending(o => o.ConfigID);
var pagedList = query.ToPagedList(req.page, req.pageSize);
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = pagedList
});
}
public TableData GetList(QueryListReq req)
{
var query = _doorRepository.Table;
if (!req.communityId.IsBlank())
{
query = query.Where(a => a.CommunityUUID == req.communityId);
}
if (!req.keyword.IsBlank())
{
query = query.Where(a => a.DoorName.Contains(req.keyword));
}
query = query.OrderByDescending(o => o.CreateTime);
var pagedList = query.ToPagedList(req.page, req.pageSize);
var doorList = new List <DoorDto>();
foreach (var item in pagedList)
{
var dto = item.MapTo <DoorDto>();
dto.DeviceName = item.Device != null ? item.Device.DeviceName : "";
dto.DoorTypeName = item.DoorTypeDict.DictName;
dto.DeviceType = item.Device != null ? item.Device.DeviceType : 0;
dto.DeviceIP = item.Device.IPAddress;
var community = _areaRepository.GetById(item.CommunityUUID);
dto.CommunityName = community != null ? community.ChineseName : "";
doorList.Add(dto);
}
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = doorList
});
}
public TableData GetList(QueryListReq req)
{
var query = _roleRopsitory.Table;
query = query.Where(o => !o.Deleted);
if (!string.IsNullOrEmpty(req.keyword))
{
query = query.Where(o => o.RoleName.Contains(req.keyword));
}
query = query.OrderBy(o => o.RoleID);
var pagedList = query.ToPagedList(req.page, req.pageSize);
return(new TableData
{
currPage = req.page,
pageSize = req.pageSize,
pageTotal = pagedList.TotalPageCount,
totalCount = pagedList.TotalItemCount,
list = pagedList.MapToList <RoleDto>()
});
}
