using System;
using System.Collections;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;
using Hotel.DAO;
using Hotel.Entity;


namespace Hotel.Operation
{
    public class UserInfoAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;
        UserInfo userInfoEntity = null;
        SqlDataReader dr = null;

        public UserInfoAccess()
        {
            objGetDatabase=new GetDatabase();
        }
        //獲取所有用戶名
        public ArrayList GetUserID()
        {
            string sql = "select UserID from userInfo";
            ds = new DataSet();
            ds=objGetDatabase.GetDataSet(sql,"userInfo");
            ArrayList arr = new ArrayList();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                arr.Add(ds.Tables[0].Rows[i][0].ToString());
            }
            //objGetDatabase.DataClose();
            return arr;
        }
        //判斷用戶密碼
        public bool GetPassword(string userID,string pwd)
        {
            bool le = false;
            string sql = "select Password from userInfo where userID='"+userID+"'";
            ds = new DataSet();
            ds=objGetDatabase.GetDataSet(sql,"userInfo");
            if (ds.Tables[0].Rows[0][0].ToString() == pwd)
            {
                 le = true;
                 objGetDatabase.DataClose();
                 return le;
            }
            else
            {
                le=false;
                objGetDatabase.DataClose();
                return le; 
            }
        }
        //實現屏幕鎖屏功能的方法
        public bool LockPwd(string pwd)
        {
            bool Lock = false;
            string sql = "select Password from userInfo";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "userInfo");
            objGetDatabase.DataClose();
            if (ds.Tables[0].Rows[0][0].ToString() == pwd)
            {
                Lock = true;
                return Lock;
            }
            else
            {
                Lock = false;
                return Lock;
            }
        }

        //添加用戶信息到表
        public ListView GetGrant(ListView lsvBuyer)
        {
            string sql = "select UserID as 用戶帳號,姓名=(select EmployeeName from Employee where "+
                "EmployeeID=userInfo.EmployeeID),State as 狀態,前臺管理=case when frontManage='0' "+
                "then '否' else '是' end ,財務查詢=case when financingManage='0' "+
                "then '否' else '是' end,系統管理=case when SystemManage='0' then '否' else '是' end,"+
                "價格管理=case when PriceManage='0' then '否' else '是' end,信息管理=case when"+
                " InfoManage='0' then '否' else '是' end from UserInfo";
            ds = new DataSet();
            //objGetDatabase = new GetDatabase();
            ds = objGetDatabase.GetDataSet(sql, "UserInfo");
           
            //建表頭
            ColumnHeader head = null;
            
            lsvBuyer.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                head = new ColumnHeader();
                head.Width = 80;
                head.Text = ds.Tables[0].Columns[i].ToString();
                lsvBuyer.Columns.Add(head);
            }
            

            lsvBuyer.Items.Clear();
            ListViewItem lsvItem = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                lsvItem = new ListViewItem(ds.Tables[0].Rows[i][0].ToString());
                for (int j = 1; j < ds.Tables[0].Columns.Count; j++)
                {
                    lsvItem.SubItems.Add(ds.Tables[0].Rows[i][j].ToString());
                    lsvItem.ImageIndex = 1;
                }
                lsvBuyer.Items.Add(lsvItem);
            }
            objGetDatabase.DataClose();
            return lsvBuyer;

        }
        //修改用戶權限
        public int UpdateGrant(UserInfo objuserinfo)
        {
            //objGetDatabase = new GetDatabase();
            string sql = "update UserInfo set state='"+objuserinfo.State+"',frontManage=" + objuserinfo.FrontManage + ",financingManage=" + objuserinfo.FinancingManage + ",SystemManage=" + objuserinfo.SystemManage + ",PriceManage=" + objuserinfo.PriceManage + ",InfoManage=" + objuserinfo.InfoManage + "where UserID='" + objuserinfo.UserID + "'";
            int k = this.objGetDatabase.ExecuteSql(sql);
            objGetDatabase.DataClose();
            return k;
        }

        //注冊新用戶
        public int AddNewuser(UserInfo objuserinfo)
        {
            //objGetDatabase = new GetDatabase();
            string sql = "insert into UserInfo values('" + objuserinfo.UserID + "','" + objuserinfo.EmployeeID + "','" + objuserinfo.Password + "','" + objuserinfo.State + "'," + objuserinfo.FrontManage + "," + objuserinfo.FinancingManage + "," + objuserinfo.SystemManage + "," + objuserinfo.PriceManage + "," + objuserinfo.InfoManage + ")";
            int k=this.objGetDatabase.ExecuteSql(sql);
            //objGetDatabase.DataClose();
            return k;
        }
        //獲取權限信息
        public UserInfo GetPopedomInfo(string str)
        {
            userInfoEntity = new UserInfo();
            string sql = "select * from UserInfo where UserID='"+str+"'";
          
            dr=objGetDatabase.GetDataReader(sql);
            if (dr.HasRows)
            {
                dr.Read();
                userInfoEntity.State = dr[3].ToString();
               
                string r=dr[4].ToString();
                if (r=="False")
                    userInfoEntity.FrontManage = 0;
                else if(r=="True")
                    userInfoEntity.FrontManage = 1;

                string f = dr[5].ToString();
                if (f == "False")
                    userInfoEntity.FinancingManage = 0;
                else if (f == "True")
                    userInfoEntity.FinancingManage = 1;

                string s = dr[6].ToString();
                if (s == "False")
                    userInfoEntity.SystemManage = 0;
                else if (s == "True")
                    userInfoEntity.SystemManage = 1;

                string p = dr[7].ToString();
                if (p == "False")
                    userInfoEntity.PriceManage = 0;
                else if (p == "True")
                    userInfoEntity.PriceManage = 1;

                string i = dr[8].ToString();
                if (i == "False")
                    userInfoEntity.InfoManage = 0;
                else if (i == "True")
                    userInfoEntity.InfoManage = 1;
            }
            objGetDatabase.DataClose();
            return userInfoEntity;
        }
        //判斷是否已注冊的員工
        public int IsLogin(string emID)
        {
            int k = 0;
            string sql = "select * from UserInfo where EmployeeID='"+emID+"'";
            SqlDataReader dr=objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                objGetDatabase.DrClose(dr);
                return k=1;
            }
            else
            {
                objGetDatabase.DrClose(dr);
                return k;
            }
            
        }
        //修改用戶密碼
        public int ModifiPwd(string pwd,string name)
        {
            string sql = "update userInfo set Password='"+pwd+"' where UserID='"+name+"'";
            int k = objGetDatabase.ExecuteSql(sql);
            objGetDatabase.DataClose(); 
            return k;
        }
    }
}