public Hashtable setDataHashtable(IF_SQLPager Pager) { Hashtable result = new Hashtable(); result["data"] = Pager.datalist; result["total"] = Pager.count; return(result); }
public IEnumerable<M> GetPagination<M>(IF_SQLPager pager, IQueryable<M> linq) where M : class { pager.count = linq.Count(); OrderModelField orderModelField = new OrderModelField(); orderModelField.PropertyName = pager.sortField; orderModelField.IsDESC = string.Compare("desc", pager.sortOrder, true) == 0; linq = EFCommonSort.CommonSort(linq, new OrderModelField[] { orderModelField }); var lists = linq.Skip((pager.currentPage - 1) * pager.pageSize).Take(pager.pageSize).ToList(); pager.datalist = lists; return lists; }
/// <summary> /// 初始化一个普通分页对象(不带多条件查询) /// </summary> /// <param name="request">前台的POST表单</param> /// <returns></returns> public IF_SQLPager setNormalPager(HttpRequest request) { IF_SQLPager pager = new IF_SQLPager { currentPage = Convert.ToInt32(request["pageIndex"]) + 1, sortField = request["sortField"], sortOrder = request["sortOrder"], pageSize = Convert.ToInt32(request["pageSize"]) }; return(pager); }
public IF_SQLPager setHashTablePager(Hashtable ht) { IF_SQLPager pager = new IF_SQLPager { currentPage = Convert.ToInt32(ht["pageIndex"] == null ? "0" : ht["pageIndex"].ToString()) + 1, sortField = ht["sortField"].ToString(), sortOrder = ht["sortOrder"].ToString(), pageSize = Convert.ToInt32(ht["pageSize"] == null ? "10" : ht["pageSize"].ToString()) }; return(pager); }
/// <summary> /// 初始化一个分页对象(带多条件查询的) /// </summary> /// <param name="sl">多条件查询对象</param> /// <param name="request">前台的POST表单</param> /// <returns></returns> public IF_SQLPager setPager(List <SearchField> sl, HttpRequest request) { string wherestring = ""; if (sl != null) { foreach (SearchField sf in sl) { if (string.IsNullOrEmpty(wherestring)) { sf.AndOr = Enum_SearchFieldAndOr.And; } wherestring += new IF_EntityTools().ConventToSearchText(sf); } } if (!string.IsNullOrWhiteSpace(wherestring)) { wherestring = " and (1=1 " + wherestring + ")"; } IF_SQLPager pager = setNormalPager(request); pager.where += wherestring; return(pager); }