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

namespace BusinessLayer
{
    public class BLL_waiter
    {
        SqlDataAccess sql = new SqlDataAccess();

        public DataTable SelectWaiter()
        {
            return sql.ExecuteDataSetBySelect("proc_SelectWaiter");
        }

        public DataTable SelectWaiterByLevel(Waiter w)
        {
            return sql.ExecuteDateSetBySelect("proc_SelectWaiterByLevel",w.Dj);
        }
        public int InsertWaiter(Waiter w)
        {
            return sql.ExecuteDataSetByUpdate("proc_InsertWaiter",w.ID,w.Name,w.JP,w.Sex,w.Dj,w.Lxfs,w.Sfh,w.Fxrq,w.Reamrk);
        }
        public int UpdateWaiter(Waiter w)
        {
            return sql.ExecuteDataSetByUpdate("proc_UpdateWaiter",w.ID,w.Name,w.JP,w.Sex,w.Dj,w.Lxfs,w.Sfh,w.Fxrq,w.Reamrk);
        }
        public Waiter SelectWaiterByID(Waiter w)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("proc_SelectWaiterByID", w.ID);
            w.Name = dt.Rows[0][1].ToString();
            w.JP = dt.Rows[0][2].ToString();
            w.Sex = dt.Rows[0][3].ToString();
            w.Dj = int.Parse(dt.Rows[0][4].ToString());
            w.Lxfs = dt.Rows[0][5].ToString();
            w.Sfh = dt.Rows[0][6].ToString();
            w.Fxrq = dt.Rows[0][7].ToString();
            w.Reamrk = dt.Rows[0][7].ToString();
            return w;
        }
        public int DeleteWaiterByID(Waiter w)
        {
            return sql.ExecuteDataSetByUpdate("proc_DeleteWaiterByID", w.ID);
        }
        
    }
}