public IQueryable <NoticeVtual> QueryNotice(NoticeSearch search, Page page, out int count)
{
var query = from A in DataContext.Notice
join B in DataContext.System_Users on A.Creator_UID equals B.Account_UID
where A.State == "进行中" || A.State == "未开始"
orderby A.Creat_Time descending
select new NoticeVtual
{
UID = A.UID,
Notice_Content = A.Notice_Content,
Start_Time = A.Start_Time,
End_Time = A.End_Time,
Color = A.Color,
Scope = A.Scope,
State = A.State,
Creator_User = B.User_Name,
Creat_Time = A.Creat_Time,
RepeatTime = A.RepeatTime
};
count = query.Count();
query = query.GetPage(page);
return(query);
}
public ActionResult QueryNotice(NoticeSearch search, Page page)
{
var apiUrl = "Chart/QueryNoticeAPI";
HttpResponseMessage responMessage = APIHelper.APIPostAsync(search, page, apiUrl);
var result = responMessage.Content.ReadAsStringAsync().Result;
return(Content(result, "application/json"));
}
public PagedListModel <NoticeVM> QueryNotice(NoticeSearch search, Page page)
{
var totalCount = 0;
var list = NoticeRepository.QueryNotice(search, page, out totalCount);
IList <NoticeVM> listDTO = new List <NoticeVM>();
foreach (var item in list)
{
var ent = new NoticeVM();
ent.Creator_User = item.Creator_User;
ent.Creat_Time = item.Creat_Time;
ent.Notice_Content = item.Notice_Content;
ent.Period = item.Start_Time.ToLocalTime() + "~" + item.End_Time.ToLocalTime();
ent.Scope = item.Scope;
ent.State = item.State;
ent.UID = item.UID;
listDTO.Add(ent);
}
return(new PagedListModel <NoticeVM>(totalCount, listDTO));
}
public ActionResult QueryORTImg(NoticeSearch search, Page page)
{
var dirPath = Server.MapPath("~/Upload/ORTImg");
//若无文件夹则创建
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
var dir = new DirectoryInfo(dirPath);
var imgVMs = dir.EnumerateFiles("*.*").Where(s => s.Name.ToLower().EndsWith(".jpg") || s.Name.ToLower().EndsWith(".jpeg") || s.Name.ToLower().EndsWith(".png")).Select(f => new ORTImgVM()
{
Name = f.Name, FullPath = f.FullName, LastWriteTime = f.LastWriteTime
});
var orderedImgVMs = imgVMs.OrderByDescending(f => f.LastWriteTime).Skip(page.Skip).Take(page.PageSize);
var ORTImagList = new List <ORTImgVM>();
foreach (var item in orderedImgVMs)
{
var buildingName = item.Name.Split('.')[0];
if (buildingName.Contains("_"))
{
buildingName = buildingName.Split('_')[0];
}
ORTImagList.Add(new ORTImgVM()
{
Name = item.Name, FullPath = item.FullPath, BuildingName = buildingName, LastWriteTime = item.LastWriteTime
});
}
//var serializeStr = JsonConvert.SerializeObject(orderedImgVMs);
var pagedImgVMs = new PagedListModel <ORTImgVM>(imgVMs.Count(), ORTImagList);
var serializeStr = JsonConvert.SerializeObject(pagedImgVMs);
return(Content(serializeStr, "application/json"));
}
public async Task <IActionResult> OnPostDataAsync(int page, int rows, NoticeSearch where)
{
var data = await _service.GetListAsync(page, rows, where, null);
return(PagerData(data.items, page, rows, data.count));
}
public async Task <IActionResult> GetList(int page, int rows, NoticeSearch where)
{
var data = await _service.GetListAsync(page, rows, where, new { StickyNum = "desc", PublishedTime = "desc" });
return(PagerData(data.items, page, rows, data.count));
}