DA/RetreatFoodDal.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DA
{
  public class RetreatFoodDal
    {
      //Common.COpenBills cOpenBills = new COpenBills();
      //Common.CFront cFront=new CFront ();
      string sql;
      SqlHelpers sqlh = new SqlHelpers();
      List<SqlParameter> pars = new List<SqlParameter>();
      //退菜
      //1，	数据库OpenBills 总价格opClientPay(现金付) opCardPay(卡付)更新成退菜后的价格，
      public bool UpdateopClientPayAfterRetreat(COpenBills cOpenBills,decimal Money,int msAmount)
      {
          sql = "update OpenBills set opClientPay=@opClientPay-(@Money*@msAmount) where obid=@@obid and mId=@mId";          
          pars.Clear();

          pars.Add(new SqlParameter("@opClientPay", SqlDbType.Float));
          pars[0].Value = cOpenBills.CopClientPay1;
          pars.Add(new SqlParameter("@@obid", SqlDbType.VarChar, 50));
          pars[1].Value = cOpenBills.CobId1;
          pars.Add(new SqlParameter("@mId", SqlDbType.VarChar, 50));
          pars[2].Value = cOpenBills.CmId1;
          pars.Add(new SqlParameter("@Money", SqlDbType.Money));
          pars[3].Value = Money;
          pars.Add(new SqlParameter("@msAmount", SqlDbType.Int));
          pars[4].Value = msAmount;
        
          return  sqlh.ExcuteInsertUpdateDelete(sql, pars);
      }
      
      //2,Front表修改对应tid和msid的一条消息

      public bool UpdateFrontByID(CFront cFront)
      {
          sql = "update Front set msAmount=@msAmount where tId=@tId and msId=@msId";
          pars.Clear();
          pars.Add(new SqlParameter("@msAmount",SqlDbType.Int));
          pars[0].Value = cFront.MsAmount;
          pars.Add(new SqlParameter("@tId", SqlDbType.VarChar,50));
           pars[1].Value = cFront.TId;
           pars.Add(new SqlParameter("@msId", SqlDbType.Int));
           pars[2].Value=   cFront.MsId;
          return sqlh.ExcuteInsertUpdateDelete(sql, pars);
      }
      //3，deleteBillItem表添加一条已删退菜记录理解为记录删除的日志
      public bool InSertIntoDeleteBillItem(Common.CDeleteBillItem cDeleteBillItem)
      {
          sql = "insert into DeleteBillItem values(@obid,@msId,@Number,@TotalMoney,@PayType,@DeleteTime)";
          pars.Clear();
          pars.Add(new SqlParameter("@@@obid",SqlDbType.NVarChar,50));
          pars[0].Value= cDeleteBillItem.ObId;
          pars.Add(new SqlParameter("@msId",SqlDbType.Int ));
          pars[1].Value = cDeleteBillItem.MsId;