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