/// <summary> /// 基于jgGrid的分页 /// </summary> /// <param name="pg"></param> /// <param name="jq"></param> /// <returns></returns> public Tuple <int, List <SystemUser> > PageSystemUsers(PubPage pg, JqGridModel.JqGrid jq) { var queryable = BaseContext.Set <SystemUser>().AsQueryable(); if (!string.IsNullOrEmpty(pg.keyword)) { queryable = queryable.Where(c => c.Telephone == pg.keyword); } if (!string.IsNullOrEmpty(pg.startDate.ToString())) { queryable = queryable.Where(c => c.CreateTime >= pg.startDate); } if (!string.IsNullOrEmpty(pg.endDate.ToString())) { var dt = DateTimeHelper.EndDateTime(pg.endDate); queryable = queryable.Where(c => c.CreateTime <= dt); } var count = queryable.Count(); if (string.Equals(jq.sord, "ASC", StringComparison.CurrentCultureIgnoreCase)) { var list = queryable.OrderByz(jq.sidx).Skip(jq.rows * (jq.page - 1)).Take(jq.rows).ToList(); return(new Tuple <int, List <SystemUser> >(count, list)); } else { var list = queryable.OrderByDescendingz(jq.sidx).Skip(jq.rows * (jq.page - 1)).Take(jq.rows).ToList(); return(new Tuple <int, List <SystemUser> >(count, list)); } }
public ActionResult GetLogList(JqGridModel.JqGrid jq, PubPage fg) { if (jq.page == 0) { jq.page = 1; jq.rows = 10; jq.sidx = "CreateTime"; jq.sord = "DESC"; } var list = _iSysLogServices.PageSysLog(fg, jq); return(Json(JqGridModel.GridData(list.Item1, jq, list.Item2), JsonRequestBehavior.AllowGet)); }
public Tuple <int, List <SysLog> > PageSysLog(PubPage pg, JqGridModel.JqGrid jq) { return(_sysUserRepository.PageSysLog(pg, jq)); }