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

namespace Hotel.Operation
{
    public class ItemsTypeAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;

        public ItemsTypeAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //獲取所有商品類型名稱
        public ArrayList GetItemType()
        {
            string sql = "select TypeName from ItemsType";
            ds = new DataSet();
            ArrayList arr = new ArrayList();
            ds=objGetDatabase.GetDataSet(sql, "ItemsType");
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    arr.Add(ds.Tables[0].Rows[i][0].ToString());
                }
            }
            return arr;
        }
        //獲得商品類型信息
        public ListView GetTypeInfo(ListView lv)
        {
            string sql = "select 類型編號(hào)=ItemsTypeID,類型名稱=TypeName from ItemsType";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsType");
            //建表頭
            ColumnHeader ch = null;
            lv.Columns.Clear();
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ch = new ColumnHeader();
                ch.Text = ds.Tables[0].Columns[i].ToString();
                lv.Columns.Add(ch);
                ch.Width = 70;
                if (i == 1)
                    ch.Width = 80;
            }

            lv.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());

                }
                lv.Items.Add(lsvItem);
            }
            return lv;
        }
        //以ID獲取類型名稱
        public string GetTypeName(int num)
        {
            string name = "";
            string sql = "select TypeName from ItemsType where ItemsTypeID="+num;
            SqlDataReader dr = objGetDatabase.GetDataReader(sql);
            dr.Read();
            if (dr.HasRows)
            {
                name = dr.GetValue(0).ToString();
            }
            dr.Close();
            return name;
        }
        //添加商品類型
        public int AddType(string name)
        {
            string sql = "insert ItemsType values('"+name+"')";
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //刪除商品類型
        public int DeleteItemType(int num)
        {
            string sql = "delete from ItemsType where ItemsTypeID="+num;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //修改類型名稱 
        public int ModifiTypeName(int type,string name)
        {
            string sql = "update ItemsType set TypeName='"+name+"' where ItemsTypeID="+type;
            int k = objGetDatabase.ExecuteSql(sql);
            return k;
        }
        //獲取所有類型,以數(shù)據(jù)集返回
        public DataSet GetAllType()
        {
            string sql = "select * from ItemsType";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsType");
            return ds;
        }
    }
}