public async Task <IActionResult> LibraryFileList(FilePageRequest request, string type = "image", int groupId = -1)
{
var groupList = await GetUploadGroupList(type);
var data = await GetUploadFileList(request, groupId, type);
request.Data = data;
request.LastPage = (int)Math.Ceiling(request.Total * 1.0f / request.PerPage * 1.0f);
return(YesResult(new { groupList = groupList, fileList = request }));
}
public async Task <IActionResult> LibraryFileList(FilePageRequest request, string type = "image", int group_id = -1)
{
var group_list = await GetUploadGroupList(type);
var data = GetUploadFileList(group_id, type, request);
request.data = data;
request.last_page = (int)Math.Ceiling(request.total * 1.0f / request.per_page * 1.0f);
return(YesResult(new { group_list, file_list = request }));
}
private async Task <List <UploadFile> > GetUploadFileList(FilePageRequest request, int groupId, string type = "image")
{
var select = _fsql.Select <UploadFile>();
return(groupId == -1
? await @select.Where(l => l.FileType == type && l.IsDelete == 0).OrderBy(l => l.FileId)
.Page(request.CurPage, request.PerPage).ToListAsync()
: await @select.Where(l => l.FileType == type && l.IsDelete == 0 && l.GroupId == groupId)
.OrderBy(l => l.FileId).Page(request.CurPage, request.PerPage).ToListAsync());
}
private IEnumerable <yoshop_upload_file> GetUploadFileList(int group_id, string type = "image", FilePageRequest request = null)
{
return(group_id == -1
? UploadFileService.LoadPageEntities <uint>(request.current_page, request.per_page, ref request.total, l => l.file_type == type && l.is_delete == 0, l => l.file_id, true)
: UploadFileService.LoadPageEntities <uint>(request.current_page, request.per_page, ref request.total, l => l.file_type == type && l.is_delete == 0 && l.group_id == group_id, l => l.file_id, true));
}