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); } } }