/// <summary>
/// 分页查询充值记录
/// </summary>
/// <param name="pager">分页</param>
/// <param name="filter">查询条件</param>
/// <remarks> 2016-04-13 刘伟豪 创建 </remarks>
public override void Search(ref Pager <CBCrRecharge> pager, ParaCrRechargeFilter filter)
{
using (var _context = Context.UseSharedConnection(true))
{
var sqlWhere = " Re.State = 1 ";
if (filter.CustomerSysNo > 0)
{
sqlWhere += " and Re.CustomerSysNo = @CustomerSysNo ";
}
if (!string.IsNullOrWhiteSpace(filter.KeyWord))
{
sqlWhere += " and ( Cr.Name like @KeyWord or Cr.NickName like @KeyWord or Cr.MobilePhoneNumber like @KeyWord or Cr.Account like @KeyWord ) ";
}
if (filter.RePaymentId > 0)
{
sqlWhere += "and RePaymentId = @RePaymentId ";
}
pager.Rows = _context.Select <CBCrRecharge>(" Re.*,Cr.Name,Cr.NickName,Cr.MobilePhoneNumber,Cr.Account,Bl.AvailableBalance ")
.From(@" CrRecharge Re
Left Join CrCustomer Cr On Re.CustomerSysNo = Cr.SysNo
Left Join CrAccountBalance Bl On Re.CustomerSysNo = Bl.CustomerSysNo")
.Where(sqlWhere)
.Parameter("CustomerSysNo", filter.CustomerSysNo)
.Parameter("KeyWord", "%" + filter.KeyWord + "%")
.Parameter("RePaymentId", filter.RePaymentId)
.OrderBy(" Re.ReAddTime Desc , Re.SysNo Desc ")
.Paging(pager.CurrentPage, pager.PageSize)
.QueryMany();
pager.TotalRows = _context.Select <int>(" count(0) ")
.From(@" CrRecharge Re
Left Join CrCustomer Cr On Re.CustomerSysNo = Cr.SysNo
Left Join CrAccountBalance Bl On Re.CustomerSysNo = Bl.CustomerSysNo")
.Where(sqlWhere)
.Parameter("CustomerSysNo", filter.CustomerSysNo)
.Parameter("KeyWord", "%" + filter.KeyWord + "%")
.Parameter("RePaymentId", filter.RePaymentId)
.QuerySingle();
}
}
/// <summary>
/// 分页查询充值记录
/// </summary>
/// <param name="pager">分页</param>
/// <param name="filter">查询条件</param>
/// <remarks> 2016-08-17 刘伟豪 创建 </remarks>
public void Search(ref Pager <CBCrRecharge> pager, ParaCrRechargeFilter filter)
{
CrRechargeDao.Instance.Search(ref pager, filter);
}
