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(); //继续数据绑定
}
}
