/// <summary> /// 获取分页列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>会分页列表</returns> public PagedList <CrAgency> GetAdminPager(CrAgencyQueryRequest request) { var dataCount = DBContext.Select <int>("count(0)").From("agent_cragency"); var dataList = DBContext.Select <CrAgency>("*").From("agent_cragency"); Action <string, string, object> setWhere = (@where, name, value) => { dataCount.AndWhere(where).Parameter(name, value); dataList.AndWhere(where).Parameter(name, value); }; //if (request.CustomerSysNo.HasValue) //{ //setWhere(string.Format("CONCAT(',',LevelCustomerStr,',') like '%,{0},%'", request.LevelCustomerSysNo.Value), "", ""); //} return(new PagedList <CrAgency> { TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("SysNo desc").QueryMany(), CurrentPageIndex = request.CurrentPageIndex.GetHashCode(), TotalCount = dataCount.QuerySingle() }); }
/// <summary> /// 获取奖金记录分页列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>奖金记录分页列表</returns> public PagedList <CrAgency> GetPagerList(CrAgencyQueryRequest request) { return(Using <ICrAgency>().GetPagerList(request)); }