private void FrmConsumer_Load(object sender, EventArgs e)
{
//让时间赋值为一天前
DateTime yestoday = DateTime.Now.AddDays(-1);
this.dtg.Text = yestoday.ToString("yyyy-MM-dd");
//获取数据
string name = this.txts.Text;
DateTime now1 = this.dtg.Value;
DateTime now2 = this.dte.Value;
this.cbos.SelectedIndex = 0;
//在加载的时候显示全部
List <ConsumerDetails> list = CDBLL.Select(now1.ToString(), now2.ToString());
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.Tname.ToString());
lvi.SubItems.Add(item.Pname.ToString());
lvi.SubItems.Add(item.CDPrice.ToString());
lvi.SubItems.Add(item.CDAmount.ToString());
lvi.SubItems.Add(item.CDDate.ToString());
this.lv.Items.Add(lvi);
}
}
private void btns_Click(object sender, EventArgs e)
{
//获取数据
string name = this.txts.Text;
DateTime now1 = this.dtg.Value;
DateTime now2 = this.dte.Value;
//如果下标等于零就查询全部
if (cbos.SelectedIndex == 0)
{
this.lv.Items.Clear();
List <ConsumerDetails> list = CDBLL.Select(now1.ToString(), now2.ToString());
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.Tname.ToString());
lvi.SubItems.Add(item.Pname.ToString());
lvi.SubItems.Add(item.CDPrice.ToString());
lvi.SubItems.Add(item.CDAmount.ToString());
lvi.SubItems.Add(item.CDDate.ToString());
this.lv.Items.Add(lvi);
}
}
//如果下标等于一就根据餐台号查询
else if (cbos.SelectedIndex == 1)
{
this.lv.Items.Clear();
List <ConsumerDetails> list = CDBLL.SelectbyTname(now1.ToString(), now2.ToString(), name);
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.Tname.ToString());
lvi.SubItems.Add(item.Pname.ToString());
lvi.SubItems.Add(item.CDPrice.ToString());
lvi.SubItems.Add(item.CDAmount.ToString());
lvi.SubItems.Add(item.CDDate.ToString());
this.lv.Items.Add(lvi);
}
}
//如果下标等于二就根据消费项目查询
else if (cbos.SelectedIndex == 2)
{
this.lv.Items.Clear();
List <ConsumerDetails> list = CDBLL.SelectbyPname(now1.ToString(), now2.ToString(), name);
foreach (var item in list)
{
ListViewItem lvi = new ListViewItem(item.Tname.ToString());
lvi.SubItems.Add(item.Pname.ToString());
lvi.SubItems.Add(item.CDPrice.ToString());
lvi.SubItems.Add(item.CDAmount.ToString());
lvi.SubItems.Add(item.CDDate.ToString());
this.lv.Items.Add(lvi);
}
}
}
