itemsaccess.cs

酒店管理系统,您酒店物业管理的好帮手

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

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

        public ItemsAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获得商品
        public ListView GetItems(ListView lv,string name)
        {

            string sql = "select 商品编号=ItemID,商品名称=ItemName,商品类型=ItemName,商品价格=price,备注=remark from ItemsPrice where ItemName like'%" + name +"%'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            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;
        }


        public ListView GetItems(ListView lv, int typeID)
        {
            try
            {
                string sql = "select 商品编号=ItemID,商品名称=ItemName,商品类型=ItemName,商品价格=price,备注=remark from ItemsPrice where ItemID like '%" + typeID + "%'";
                ds = new DataSet();
                ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
                //添加表头
                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);
                }
            }
            catch (Exception ce)
            {
                MessageBox.Show(ce.Message);
            }

            return lv;
        }


        public ListView GetItems(ListView lv)
        {

            string sql = "select 商品编号=ItemID,商品名称=ItemName,商品类型=ItemName,商品价格=price,备注=remark from ItemsPrice";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            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;
        }


        public ListView Room(ListView lv)
        {
            
            string sql = "select 定单帐号=RoomUseID,顾客ID=BuyerID,客房ID=GuestRoomID,始住时间=ArriveTime,离开时间=EndTime,按天计算=CountMode,住房总费用=charge,其它消费=otherExpenses,收取押金=InForegift,退还押金=OutForegift,宾客人数=BNum,折扣=Rebate,开单员=OpenUser,填写日期=FillTime,最后费用=EndCharge,状态=State,操作员ID=UserID,结帐日期=ReckoningTime,备注=Remark from RoomUse";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            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;
        }

     
        public ListView Room(ListView lv, int id)
        {
            
            string sql = "select 定单帐号=RoomUseID,顾客ID=BuyerID,客房ID=GuestRoomID,始住时间=ArriveTime,离开时间=EndTime,按天计算=CountMode,住房总费用=charge,其它消费=otherExpenses,收取押金=InForegift,退还押金=OutForegift,宾客人数=BNum,折扣=Rebate,开单员=OpenUser,填写日期=FillTime,最后费用=EndCharge,状态=State,操作员ID=UserID,结帐日期=ReckoningTime,备注=Remark from RoomUse where RoomUseID like '%" + id + "%'";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            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;
        }

        public ListView Room2(ListView lv)
        {
            string sql = "select 清单ID=AccountID,客房ID=RoomUseID,数量=ANumber,总价=Consume,折扣=Rebate,实价=EndPrice,备注=Remark from Account";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            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;
        }

        public ListView Room2(ListView lv, int id)
        {
            string sql = "select 清单ID=AccountID,客房ID=RoomUseID,数量=ANumber,总价=Consume,折扣=Rebate,实价=EndPrice,备注=Remark from Account where GuestRoomID=(select GuestRoomID from RoomUse where RoomUseID like  '%" + id + "%') ";
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "ItemsPrice");
            //添加表头
            ColumnHeader ch = null;