public ActionResult GetShareFileList(GetShareFileListInput input)
{
input.UserID = Session["UserID"].ToString();
var output = fileShareService.GetShareFileList(input);
return(Json(new { code = "0", msg = "", count = output.Count, data = output.Items }, JsonRequestBehavior.AllowGet));
}
public GetShareFileListOutput GetShareFileList(GetShareFileListInput input)
{
var query = from shareuser in _context.FileUsers
join personalFile in _context.PersonalFiles on shareuser.FileId equals personalFile.Id
join document in _context.DocumentInfos on personalFile.DocumentID equals document.Id
where shareuser.UserId == input.UserID
select new FileListDto
{
Id = personalFile.Id,
DocumentID = personalFile.DocumentID,
Size = document.Size,
FileName = document.FileName,
Permission = shareuser.Permission,
CreateUserName = personalFile.CreateUserName,
ModifyUserName = personalFile.ModifyUserName,
TempTime = personalFile.ModifyTime,
Path = document.Path,
RelativePath = document.RelativePath
};
if (!string.IsNullOrEmpty(input.FileName))
{
query = query.Where(a => a.FileName.Contains(input.FileName));
}
var count = query.Count();
var tmpList = query.OrderBy(a => a.Id).Skip(input.Limit * (input.Page - 1)).Take(input.Limit).ToList();
foreach (var item in tmpList)
{
item.ModifyTime = item.TempTime.ToString("yyyy-MM-dd HH:mm:ss");
}
return(new GetShareFileListOutput
{
Count = count,
Items = tmpList
});
}