/// <summary>
/// 后台获取奖金记录查询
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>后台获取奖金分页列表</returns>
public PagedList <BonusLogResponse> GetAdminPager(BonusLogAdminQueryRequest request)
{
var dataCount = DBContext.Select <int>("count(0)").From("agent_fnbonuslog bl");
var dataList = DBContext.Select <BonusLogResponse>("bl.SysNo,(SELECT ce.RealName FROM crcustomer ce WHERE ce.SysNo=bl.CustomerSysNo) as Receiver,(SELECT ce.ReferrerSysNo FROM crcustomer ce WHERE ce.SysNo=bl.CustomerSysNo) as ReceiverReferrerSysNo,(SELECT ce.RealName FROM crcustomer ce WHERE ce.SysNo=bl.SourceSysNo) as Supplier,bl.SourceSerialNumber,bl.Amount,bl.Type,bl.Remarks,bl.`Status`,bl.CreatedDate").From("agent_fnbonuslog bl");
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataCount.AndWhere(where).Parameter(name, value);
dataList.AndWhere(where).Parameter(name, value);
};
return(new PagedList <BonusLogResponse>
{
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 <BonusLogResponse> GetAdminPager(BonusLogAdminQueryRequest request)
{
return(Using <IFnBonusLog>().GetAdminPager(request));
}
