private void 订单总价ToolStripMenuItem_Click(object sender, EventArgs e) { Form_search searchOrderForm = new Form_search("订单总价"); DialogResult dialogResult = searchOrderForm.ShowDialog(); if (dialogResult == DialogResult.OK) { CurrencyManager cm = (CurrencyManager)BindingContext[dataGridView1.DataSource]; cm.SuspendBinding(); //挂起数据绑定 using (var db = new OrderModel()) { double price = double.Parse(searchOrderForm.infomation); var orders = db.Orders.Where(p => p.orderPrice == price); foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows) // 对每一行判断 { dataGridViewRow.Visible = false; foreach (Order order in orders)//对每一个符合要求的订单号判断 { if ((int)dataGridViewRow.Cells[0].Value == order.orderNumber) { dataGridViewRow.Visible = true; break; } } } } cm.ResumeBinding(); //继续数据绑定 } }
// 筛选按钮触发事件 private void 订单IDToolStripMenuItem_Click(object sender, EventArgs e) { Form_search searchOrderForm = new Form_search("订单ID"); DialogResult dialogResult = searchOrderForm.ShowDialog(); if (dialogResult == DialogResult.OK) { CurrencyManager cm = (CurrencyManager)BindingContext[dataGridView1.DataSource]; cm.SuspendBinding(); //挂起数据绑定 foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows) { if ((int)dataGridViewRow.Cells[0].Value != int.Parse(searchOrderForm.infomation)) { dataGridViewRow.Visible = false; } } cm.ResumeBinding(); //继续数据绑定 } }
private void 订单货物ToolStripMenuItem_Click(object sender, EventArgs e) { Form_search searchOrderForm = new Form_search("订单货物"); DialogResult dialogResult = searchOrderForm.ShowDialog(); if (dialogResult == DialogResult.OK) { CurrencyManager cm = (CurrencyManager)BindingContext[dataGridView1.DataSource]; cm.SuspendBinding(); //挂起数据绑定 for (int i = 0; i < bindingSource1.List.Count; i++) { Order order = (Order)bindingSource1.List[i]; if (!order.hasTheCargo(searchOrderForm.infomation)) { //i 也可以用于表示该订单在哪一行(包括不可见行) dataGridView1.Rows[i].Visible = false; } } cm.ResumeBinding(); //继续数据绑定 } }