/// <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));
}
