/// <summary> /// 会员提现信息 /// </summary> /// <param name="filter">会员提现信息</param> /// <returns>返回会员提现信息</returns> /// <remarks>2015-09-15 王耀发 创建</remarks> public override Pager <CrPredepositCash> GetCrPredepositCashList(ParaCrPredepositCashFilter filter) { string sql = @"(select a.* from CrPredepositCash a where (@0 is null or charindex(a.PdcTradeNo,@1)>0) and (@2 is null or charindex(a.PdcTradeNo,@3)>0) " + (string.IsNullOrWhiteSpace(filter.SysNoList)?"":" and a.sysNo in(" + filter.SysNoList + ") ") + @" ) tb"; var dataList = Context.Select <CrPredepositCash>("tb.*").From(sql); var dataCount = Context.Select <int>("count(1)").From(sql); var paras = new object[] { filter.PdcTradeNo, filter.PdcTradeNo, filter.PdcUserName, filter.PdcUserName }; dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CrPredepositCash> { CurrentPage = filter.Id, PageSize = filter.PageSize }; var totalRows = dataCount.QuerySingle(); var rows = dataList.OrderBy("tb.PdcAddTime desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany(); pager.TotalRows = totalRows; pager.Rows = rows; return(pager); }
public ActionResult DoCrPredepositCashQuery(ParaCrPredepositCashFilter filter) { filter.PageSize = 10; var pager = CrPredepositCashBo.Instance.GetCrPredepositCashList(filter); var list = new PagedList <CrPredepositCash> { TData = pager.Rows, CurrentPageIndex = pager.CurrentPage, TotalItemCount = pager.TotalRows }; return(PartialView("_CrPredepositCashPager", list)); }
/// <summary> /// 获取分销商列表 /// </summary> /// <param name="sysNo">分销商系统编号</param> /// <returns>分销商列表</returns> /// <remarks>2015-08-30 王耀发 创建</remarks> public abstract Pager <CrPredepositCash> GetCrPredepositCashList(ParaCrPredepositCashFilter filter);
/// <summary> /// 分页获取会员提现 /// </summary> /// <param name="filter">筛选条件</param> /// <returns>分页列表</returns> /// <remarks>2015-08-06 王耀发 创建</remarks> public Pager <CrPredepositCash> GetCrPredepositCashList(ParaCrPredepositCashFilter filter) { return(ICrPredepositCashDao.Instance.GetCrPredepositCashList(filter)); }