bll_consume.cs

饮食管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataAccess;
using Entity;


namespace BusinessLayer
{
   public class BLL_Consume
    {
       Consume con = new Consume();
       SqlDataAccess sql = new SqlDataAccess();

       public int InsertConsume(Consume con)
       {
           con.Zdh = "ZD" + System.DateTime.Now.ToString().Replace("-","").Replace(" ","").Replace(":","");
           return sql.ExecuteDataSetByUpdate("proc_InsertConsume",con.Zdh,con.TableID,con.RoomId,con.Gkrs,con.WaiterID,con.Reamrk,con.DateTime);
       }
       public DataTable SelectConSumeByTableID(string t)
       {
          return sql.ExecuteDateSetBySelect("proc_SelectConSumeByTableID",t);
          
       }
       public int UpdateConsumeByZdh(Consume c)
       {

           return sql.ExecuteDataSetByUpdate("proc_UpdateConsumeByZdh", c.Zdh, c.User, c.Xfzf, c.Yhje, c.Hj, c.Zf, c.Zl, c.Zt);
       }

    }
}