/// <summary>
/// 获取奖金扩展记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>奖金扩展记录分页列表</returns>
public PagedList <BonusLogExt> GetPagerExtList(FnBonusLogQueryRequest request)
{
const string sqlFrom = "agent_fnbonuslog l inner join CrCustomer sc on l.SourceSysNo = sc.SysNo inner join CrCustomer c on l.CustomerSysNo = c.SysNo";
var dataCount = DBContext.Select <int>("count(0)").From(sqlFrom);
var dataList = DBContext.Select <BonusLogExt>("l.*,sc.RealName as SourceName,(sc.Level-c.Level) as SourceLevel").From(sqlFrom);
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("l.CustomerSysNo = @CustomerSysNo", "CustomerSysNo", request.CustomerSysNo.Value);
}
if (request.Type.HasValue)
{
setWhere("l.Type = @Type", "Type", request.Type.Value);
}
return(new PagedList <BonusLogExt>
{
TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("l.SysNo desc").QueryMany(),
CurrentPageIndex = request.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle()
});
}
/// <summary>
/// 获取奖金记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>奖金记录分页列表</returns>
public PagedList <FnBonusLog> GetPagerList(FnBonusLogQueryRequest request)
{
var dataCount = DBContext.Select <int>("count(0)").From("agent_fnbonuslog");
var dataList = DBContext.Select <FnBonusLog>("*").From("agent_fnbonuslog");
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("CustomerSysNo = @CustomerSysNo", "CustomerSysNo", request.CustomerSysNo.Value);
}
if (request.Type.HasValue)
{
setWhere("Type = @Type", "Type", request.Type.Value);
}
return(new PagedList <FnBonusLog>
{
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 JsonResult BonusLogQuery(FnBonusLogQueryRequest request)
{
request.CustomerSysNo = CustomerContext.Context.SysNo;
var list = FnBonusLogApp.Instance.GetPagerList(request);
var data = new
{
Status = true,
Data = list.TData.ToList(),
Count = list.TotalCount
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取奖金扩展记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>奖金扩展记录分页列表</returns>
public PagedList <BonusLogExt> GetPagerExtList(FnBonusLogQueryRequest request)
{
string[] letterArrStr = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z" };
var pagedList = Using <IFnBonusLog>().GetPagerExtList(request);
if (pagedList.TData == null || !pagedList.TData.Any())
{
return(pagedList);
}
foreach (var item in pagedList.TData.Where(item => item.SourceSysNo <= 25))
{
var level = item.SourceLevel - 1;
item.SourceLevelName = level >= 0 ? letterArrStr[level] : "";
}
return(pagedList);
}
/// <summary>
/// 获取奖金记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>奖金记录分页列表</returns>
public PagedList <FnBonusLog> GetPagerList(FnBonusLogQueryRequest request)
{
return(Using <IFnBonusLog>().GetPagerList(request));
}
