DA/CheckoutMethodDal .cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Common;
using System.Data;
using System.Data.SqlClient;
namespace DA
{
  public  class CheckoutMethodDal
    {

      string sql;
      SqlHelpers sqlh;
      Common.COpenBills copenbills = new COpenBills();
      CheckoutMethod checkoutmethod = new CheckoutMethod();
      
      #region 分开汇总现金支付，会员卡支付，餐卷支付，银行卡支付，团购支付金额
      /// <summary>
      /// 汇总现金支付的金额
      /// </summary>
      /// <param name="checkoutmethod"></param>
      /// <returns></returns>
      public DataSet CashPayment(CheckoutMethod checkoutmethod)
      {        
          List<SqlParameter> pars = new List<SqlParameter>();       

          sql = "select PaymentTime, sum(CashPayment) from CheckoutMethod group by PaymentTime where CashPayment>=0";
          return sqlh.ExcuteSelect(sql, "CheckoutMethod", pars);          
      }
      /// <summary>
      /// 汇总会员卡支付的金额
      /// </summary>
      /// <param name="checkoutmethod"></param>
      /// <returns></returns>
      public DataSet MSCardPayment(CheckoutMethod checkoutmethod)
      {
          List<SqlParameter> pars = new List<SqlParameter>();
          sql = "select PaymentTime, sum(MSCardPayment) from CheckoutMethd group by PaymentTime where MSCardPayment>=0";
          return sqlh.ExcuteSelect(sql, "CheckoutMethod", pars);
      }
      /// <summary>
      /// 汇总银行卡支付的金额
      /// </summary>
      /// <param name="checkoutmethod"></param>
      /// <returns></returns>
      public DataSet BankCardPayment(CheckoutMethod checkoutmethod)
      {
          List<SqlParameter> pars = new List<SqlParameter>();
          sql = "select PaymentTime, sum(BankCardPayment) from CheckoutMethd group by PaymentTime where BankCardPayment>=0";
          return sqlh.ExcuteSelect(sql, "CheckoutMethod", pars);
      }
      /// <summary>
      /// 汇总餐卷支付的金额
      /// </summary>
      /// <param name="checkoutmethod"></param>
      /// <returns></returns>
      public DataSet VoucherPayment(CheckoutMethod checkoutmethod)
      {
          List<SqlParameter> pars = new List<SqlParameter>();