public JsonResult Load(int pageIndex, int pageSize, string sort,
OrderType order, string moduleName, int parentId,
DateTime startTime, DateTime endTime)
{
PageHelper.GetPageIndex(ref pageIndex);
PageHelper.GetPageSize(ref pageSize);
var tempModules = ModuleServices.LoadEntities(m => true);
#region 查询
if (!String.IsNullOrEmpty(moduleName))
{
tempModules = tempModules.Where(u => u.Name.Contains(moduleName.Trim()));
}
if (parentId > 0)
{
tempModules = tempModules.Where(u => u.Parent.ID == parentId);
}
if (startTime > new DateTime(1970, 1, 1) && startTime != endTime)
{
tempModules = tempModules.Where(u => u.AddTime > startTime);
}
if (endTime > startTime)
{
tempModules = tempModules.Where(u => u.AddTime < endTime);
}
#endregion
#region 排序
if ("AddTime".Equals(sort, StringComparison.InvariantCultureIgnoreCase))
{
tempModules = Sort(tempModules, r => r.AddTime, order).ThenBy(r => r.ID);
}
else if ("Sort".Equals(sort, StringComparison.InvariantCultureIgnoreCase))
{
tempModules = Sort(tempModules, r => r.Sort, order).ThenBy(r => r.ID);
}
else
{
tempModules = Sort(tempModules, r => r.ID, order);
}
#endregion
var modules = ModuleServices
.LoadPageEntities(pageIndex, pageSize, tempModules);
int totalCount = modules.Count();
int pageCount = PageHelper.GetPageCount(totalCount, pageSize);
return(Json(new
{
total = totalCount,
rows = modules.Select(m => new
{
Id = m.ID,
m.Name,
m.Url,
m.IconName,
m.Sort,
ParentID = m.Parent == null ? 0 : m.Parent.ID,
ParentName = m.Parent == null ? String.Empty : m.Parent.Name,
m.AddTime
})
}));
}
