📄 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,住房总费用=charge,其它消费=otherExpenses,收取押金=InForegift,退还押金=OutForegift,宾客人数=BNum,折扣=Rebate,开单员=OpenUser,填写日期=FillTime,最后费用=EndCharge,状态=State,操作员ID=UserID,结帐日期=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,数量=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,联系电话=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,联系电话=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,联系电话=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,联系电话=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;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -