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

namespace BusinessLayer
{
    public class BLL_tableState
    {
        tableState state = new tableState();
        leftZt leftzt = new leftZt();
        SqlDataAccess sql = new SqlDataAccess();


        public DataTable SelectTableState()
        {
           
            return sql.ExecuteDataSetBySelect("proc_SelectTableState");
        }
        public DataTable SelectTableStateByTableID(tableState t)
        {
            return sql.ExecuteDateSetBySelect("proc_SelectTableStateByTableID", t.ID);
        }
        public DataTable SelectTableStateAndWaiter()
        {

            return sql.ExecuteDataSetBySelect("proc_SelectTableStateAndWaiter");
        }
        public DataTable SelectTableStateAndWaiterByRoomID(RoomType r)
        {
            return sql.ExecuteDateSetBySelect("proc_SelectTableStateAndWaiterByRoomID",r.RoomId);
        }
    
        public DataTable SelectByRoom(tableState ts)
        {
            return sql.ExecuteDateSetBySelect("proc_SelectByRoom", ts.ID);
        }

        public int SelectStateIdbyTableID(tableState ts)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("proc_SelectStateIdbyTableID", ts.ID);
            int i =int.Parse( dt.Rows[0][0].ToString());
            return i;
        }

        public int SelectRoomByTableID(tableState ts)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("proc_SelectRoomByTableID",ts.ID);
            int i = int.Parse(dt.Rows[0][0].ToString());
            return i;
        }
        public int UpdateTableStateByState(tableState ts)
        {
            return sql.ExecuteDataSetByUpdate("proc_UpdateTableStateByState", ts.ID, ts.State);
        }
        public int UpdateTableStateByTableID(tableState ts)
        {
            return sql.ExecuteDataSetByUpdate("proc_UpdateTableStateByTableID",ts.ID,ts.RoomID,ts.WaiterID);
        }
        public int DeleteTableStateByTableID(tableState ts)
        {
            return sql.ExecuteDataSetByUpdate("proc_DeleteTableStateByTableID", ts.ID);
        }
        public leftZt SelectTableCount()
        {
            DataSet dt=sql.DataSetBySelect("proc_SelectTableCount");
            leftzt.Ctzs = dt.Tables[0].Rows[0][0].ToString();
            leftzt.Dqky = dt.Tables[1].Rows[0][0].ToString();
            leftzt.Dqzy = dt.Tables[2].Rows[0][0].ToString();
            leftzt.Dqty = dt.Tables[3].Rows[0][0].ToString();
            leftzt.Dqyd = dt.Tables[4].Rows[0][0].ToString();
            float f = float.Parse(leftzt.Dqzy);
            float f2 = float.Parse(leftzt.Ctzs);
            float f3 = f / f2*100;
            leftzt.czl = f3.ToString() + "%";
            return leftzt;
        }


        public int InsertTableState(tableState t)
        {
            return sql.ExecuteDataSetByUpdate("proc_InsertTableState",t.ID,t.State,t.RoomID,t.WaiterID);
        }

        //public byte SelectTableStateByTid(tableState ts)
        //{ 
        //    DataTable tempDt=sql.ExecuteDateSetBySelect();
            
        //}
    }
}