private void 查询会员消费()
{
this.lv1.Items.Clear();
List <ConsumerBill> list = VipsConsumerBillBLL.select();
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.VID.ToString());
lvi.SubItems.Add(item.VipName.ToString());
lvi.SubItems.Add(item.CBID.ToString());
lvi.SubItems.Add(item.money.ToString());
lvi.SubItems.Add(item.CBSale.ToString());
this.lv1.Items.Add(lvi);
}
}
private void button1_Click(object sender, EventArgs e)
{
//接收数据
string sji = this.dte.Value.ToString();
string sj = this.dtg.Value.ToString();
Boolean b = false; //判断是否为int类型 false-否 true-是
string name = this.txtname.Text;
int bid = 0;
List <ConsumerBill> list;
try
{
bid = int.Parse(name);
b = true;
}
catch (Exception)
{
b = false;
}
if (b == true)
{
list = VipsConsumerBillBLL.Selbid(bid, sj, sji);
}
else
{
list = VipsConsumerBillBLL.Selname(name, sj, sji);
}
this.lv1.Items.Clear();
this.lv2.Items.Clear();
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.VID.ToString());
lvi.SubItems.Add(item.VipName.ToString());
lvi.SubItems.Add(item.CBID.ToString());
lvi.SubItems.Add(item.money.ToString());
lvi.SubItems.Add(item.CBSale.ToString());
this.lv1.Items.Add(lvi);
}
}
