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