bll_waiterlevel.cs

饮食管理系统

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


namespace BusinessLayer
{
   public class Bll_WaiterLevel
    {
       WaiterLevel waiterlevel = new WaiterLevel();
       SqlDataAccess sql = new SqlDataAccess();

       public DataTable SelectWaiterLevel()
       {
           return sql.ExecuteDataSetBySelect("proc_SelectWaiterLevel");
       }

       public int InsertWaiterLevel(WaiterLevel wl)
       {
           return sql.ExecuteDataSetByUpdate("proc_InsertWaiterLevel",wl.Dj);
       }
       public int UpdateWaiterLevelById(WaiterLevel wl)
       {
           return sql.ExecuteDataSetByUpdate("proc_UpdateWaiterLevelById", wl.ID, wl.Dj);
       }

       public int DeleteWaiterLevelByid(WaiterLevel wl)
       {
           return sql.ExecuteDataSetByUpdate("proc_DelectWaiterLevelByid", wl.ID);
       }    

    }
}