roomusequeryaccess.cs

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

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

namespace Hotel.Operation
{
    class RoomUseQueryAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;
        public RoomUseQueryAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        public ListView GetRoomUseQuery(ListView lv)
        {

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

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

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