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