?? itemsaccess.cs
字號:
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 Room3(ListView lv, string id)
{
string sql = "select 定單帳號=RoomUseID,顧客ID=BuyerID,客房ID=RoomUseID,始住時間=ArriveTime,離開時間=EndTime,按天計算=CountMode,住房總費(fèi)用=charge,其它消費(fèi)=otherExpenses,收取押金=InForegift,退還押金=OutForegift,賓客人數(shù)=BNum,折扣=Rebate,開單員=OpenUser,填寫日期=FillTime,最后費(fèi)用=EndCharge,狀態(tài)=State,操作員ID=UserID,結(jié)帳日期=ReckoningTime,備注=Remark from RoomUse where GuestRoomID 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 Room4(ListView lv, string id)
{
string sql = "select 清單ID=AccountID,客房ID=GuestRoomID,數(shù)量=ANumber,總價=Consume,折扣=Rebate,實價=EndPrice,備注=Remark from Account where GuestRoomID 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 InfoFile(ListView lv)
{
string sql = "select 顧客編號=BuyerID,姓名=BName,登記日期=Birthday,證件號碼=BCarNum,性別=BSex,聯(lián)系電話=Phone,國家=NationalityID,省份=ProvinceID,地址=Address,是否黑名單=Blacklist,備注=Remark from Buyer";
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 InfoFile(ListView lv, int id)
{
string sql = "select 顧客編號=BuyerID,姓名=BName,登記日期=Birthday,證件號碼=BCarNum,性別=BSex,聯(lián)系電話=Phone,國家=NationalityID,省份=ProvinceID,地址=Address,是否黑名單=Blacklist,備注=Remark from Buyer where BuyerID 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 InfoFileName(ListView lv, string name)
{
string sql = "select 顧客編號=BuyerID,姓名=BName,登記日期=Birthday,證件號碼=BCarNum,性別=BSex,聯(lián)系電話=Phone,國家=NationalityID,省份=ProvinceID,地址=Address,是否黑名單=Blacklist,備注=Remark from Buyer where BName 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 InfoFileNo(ListView lv, string no)
{
string sql = "select 顧客編號=BuyerID,姓名=BName,登記日期=Birthday,證件號碼=BCarNum,性別=BSex,聯(lián)系電話=Phone,國家=NationalityID,省份=ProvinceID,地址=Address,是否黑名單=Blacklist,備注=Remark from Buyer where BCarNum like '%" + no + "%'";
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;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -