?? 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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -