/// <summary> /// 查询配送方式支付方式关联信息 /// </summary> /// <param name="pager">配送方式支付方式关联列表分页对象</param> /// <param name="filter">配送方式支付方式关联查询条件</param> /// <returns></returns> /// <remarks> /// 2013-08-02 郑荣华 创建 /// </remarks> public override void GetBsDeliveryPaymentList(ref Pager <CBBsDeliveryPayment> pager, ParaBsDeliveryPaymentFilter filter) { const string whereSql = @"(@paymentsysno is null or t.paymentsysno=@paymentsysno) and (@deliverysysno is null or t.deliverysysno=@deliverysysno ) and (@parentsysno is null or b.parentsysno=@parentsysno) and (@paymenttype is null or a.paymenttype=@paymenttype) and b.parentsysno<>0 "; //去掉第一级配送方式 const string sqlcount = @"select count(1) from BsDeliveryPayment t left join bspaymenttype a on t.paymentsysno=a.sysno left join lgdeliverytype b on t.deliverysysno=b.sysno where " + whereSql; const string fromSql = @"BsDeliveryPayment t left join bspaymenttype a on t.paymentsysno=a.sysno left join lgdeliverytype b on t.deliverysysno=b.sysno left join lgdeliverytype c on b.parentsysno=c.sysno"; using (var context = Context.UseSharedConnection(true)) { pager.TotalRows = context.Sql(sqlcount) .Parameter("paymentsysno", filter.PaymentSysNo) //.Parameter("paymentsysno", filter.PaymentSysNo) .Parameter("deliverysysno", filter.DeliverySysNo) //.Parameter("deliverysysno", filter.DeliverySysNo) .Parameter("parentsysno", filter.ParentSysNo) //.Parameter("parentsysno", filter.ParentSysNo) .Parameter("paymenttype", filter.PaymentType) //.Parameter("paymenttype", filter.PaymentType) .QuerySingle <int>(); pager.Rows = context.Select <CBBsDeliveryPayment>(@"t.*,a.paymentname,a.paymenttype,a.isonlinepay, b.parentsysno,b.deliverytypename,c.deliverytypename parentname") .From(fromSql) .Where(whereSql) .Parameter("paymentsysno", filter.PaymentSysNo) //.Parameter("paymentsysno", filter.PaymentSysNo) .Parameter("deliverysysno", filter.DeliverySysNo) //.Parameter("deliverysysno", filter.DeliverySysNo) .Parameter("parentsysno", filter.ParentSysNo) //.Parameter("parentsysno", filter.ParentSysNo) .Parameter("paymenttype", filter.PaymentType) //.Parameter("paymenttype", filter.PaymentType) .OrderBy("t.deliverysysno,t.PaymentSysNo") .Paging(pager.CurrentPage, pager.PageSize) .QueryMany(); } }
/// <summary> /// 查询配送方式支付方式关联信息 /// </summary> /// <param name="pager">配送方式支付方式关联列表分页对象</param> /// <param name="filter">配送方式支付方式关联查询条件</param> /// <returns></returns> /// <remarks> /// 2013-08-02 郑荣华 创建 /// </remarks> public abstract void GetBsDeliveryPaymentList(ref Pager <CBBsDeliveryPayment> pager, ParaBsDeliveryPaymentFilter filter);
/// <summary> /// 查询配送方式支付方式关联信息 /// </summary> /// <param name="pager">配送方式支付方式关联列表分页对象</param> /// <param name="filter">配送方式支付方式关联查询条件</param> /// <returns></returns> /// <remarks> /// 2013-08-02 郑荣华 创建 /// </remarks> public void GetListByPayment(ref Pager <CBBsDeliveryPayment> pager, ParaBsDeliveryPaymentFilter filter) { IBsDeliveryPaymentDao.Instance.GetBsDeliveryPaymentList(ref pager, filter); }