/// <summary> /// 获取关注扩展信息分页列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>关注扩展信息分页列表</returns> public PagedList <RecommendExt> GetExtPagerList(RecommendExtRequest request) { const string sqlFrom = "agent_crrecommend r LEFT JOIN crcustomer c on r.Openid = c.OpenId"; var dataCount = DBContext.Select <int>("count(0)").From(sqlFrom); var dataList = DBContext.Select <RecommendExt>("r.*,c.Grade,c.PhoneNumber as TelNumber,CASE WHEN c.SysNo IS NULL THEN 0 ELSE 1 END as IsRegister").From(sqlFrom); Action <string, string, object> setWhere = (@where, name, value) => { dataCount.AndWhere(where).Parameter(name, value); dataList.AndWhere(where).Parameter(name, value); }; if (request.ReferrerSysNo.HasValue) { setWhere("r.ReferrerSysNo = @ReferrerSysNo", "ReferrerSysNo", request.ReferrerSysNo.Value); } if (!string.IsNullOrEmpty(request.TelNumber)) { setWhere("u.tel = @tel", "tel", request.TelNumber); } return(new PagedList <RecommendExt> { TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("r.CreatedDate desc").QueryMany(), CurrentPageIndex = request.CurrentPageIndex.GetHashCode(), TotalCount = dataCount.QuerySingle() }); }
/// <summary> /// 我的粉丝分页数据 /// </summary> /// <param name="request">输入参数</param> /// <returns>Json</returns> public JsonResult MyFansQuery(RecommendExtRequest request) { request.ReferrerSysNo = CustomerContext.Context.SysNo; var pagerList = RecommendApp.Instance.GetExtPagerList(request); var data = new { Status = true, Data = pagerList.TData.ToList(), Count = pagerList.TotalCount }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取关注扩展信息分页列表 /// </summary> /// <param name="request">查询参数</param> /// <returns>关注扩展信息分页列表</returns> public PagedList <RecommendExt> GetExtPagerList(RecommendExtRequest request) { return(Using <ICrRecommend>().GetExtPagerList(request)); }