public ActionResult ChangeList(string usercode, string truename, long changetype, DateTime?start, DateTime?end, int pageIndex = 1)
{
ChangeListModel model = new ChangeListModel();
ChangePageResult changeModel = new ChangePageResult();
//查询数据
changeModel = changeService.GetPageList(0, usercode, truename, changetype, start, end, pageIndex, PageSize);
model.changeList = changeModel.ChangeList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = PageSize;
pager.TotalCount = changeModel.TotalCount;
if (changeModel.TotalCount <= PageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(Json(new AjaxResult {
Status = "1", Data = model
}));
}
public ActionResult ChangeList()
{
ChangeListModel model = new ChangeListModel();
ChangePageResult changeModel = new ChangePageResult();
List <ChangeTypeDTO> dtolist = changetypeService.GetList();
if (dtolist != null)
{
model.changeTypeList = dtolist;
}
var selectItemList = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "请选择", Selected = true
}
};
var selectList = new SelectList(model.changeTypeList, "ID", "TypeName");
selectItemList.AddRange(selectList);
ViewBag.changetype = selectItemList;
//查询数据
changeModel = changeService.GetPageList(0, "", "", 0, null, null, 1, PageSize);
model.changeList = changeModel.ChangeList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = 1;
pager.PageSize = PageSize;
pager.TotalCount = changeModel.TotalCount;
if (changeModel.TotalCount <= PageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(View(model));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="UserID"></param>
/// <param name="UserCode"></param>
/// <param name="ToUserCode"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public ChangePageResult GetPageList(long UserID, string UserCode, string ToUserCode, long ChangeType, DateTime?start, DateTime?end, int pageIndex, int pageSize)
{
using (MyDbContext dbcontext = new MyDbContext())
{
CommonService <ChangeEntity> change = new CommonService <ChangeEntity>(dbcontext);
ChangePageResult pageResult = new ChangePageResult();
var ChangeQuery = change.GetAll();
if (UserID > 0)
{
ChangeQuery = ChangeQuery.Where(p => p.UserID == UserID);
}
if (!string.IsNullOrEmpty(UserCode))
{
ChangeQuery = ChangeQuery.Where(p => p.UserInfo.UserCode.Contains(UserCode));
}
if (ChangeType > 0)
{
ChangeQuery = ChangeQuery.Where(p => p.ChangeType == ChangeType);
}
if (!string.IsNullOrEmpty(ToUserCode))
{
ChangeQuery = ChangeQuery.Where(p => p.ToUserInfo.UserCode.Contains(ToUserCode));
}
if (start != null)
{
ChangeQuery = ChangeQuery.Where(p => p.CreateTime >= start);
}
if (end != null)
{
ChangeQuery = ChangeQuery.Where(p => p.CreateTime <= end);
}
pageResult.TotalCount = ChangeQuery.Count();
pageResult.ChangeList = ChangeQuery.OrderByDescending(p => p.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(pageResult);
}
}
