private void toolStripButton2_Click(object sender, EventArgs e)
{
//if (null == this.sum_queryDataGridView.CurrentRow) return;
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.sumCard_DataSet.Sum_query.Columns, ls);
filterForm.ShowDialog();
filterString = filterForm.GetFilterString();
if (null == filterString)
{
filterString = "";
}
setfilterStr();
AddSummationRow(sum_queryBindingSource, sum_queryDataGridView);
}
private void toolStripButton19_Click(object sender, EventArgs e)
{
if (null == this.ly_sales_standard_SumDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseRepair.ly_quality_debug_Sum.Columns, ls);
filterForm.ShowDialog();
this.ly_quality_debug_SumBindingSource.Filter = filterForm.GetFilterString();
}
private void toolStripButton19_Click(object sender, EventArgs e)
{
if (null == this.ly_sales_repair_detail_View_NewDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseRepair.ly_sales_repair_detail_View_New.Columns, ls);
filterForm.ShowDialog();
string filterstr = filterForm.GetFilterString();
if (!string.IsNullOrEmpty(filterstr))
{
this.ly_sales_repair_detail_View_NewBindingSource.Filter = filterstr;
}
//AddSummationRow_New(ly_sales_repair_detail_View_NewBindingSource, ly_sales_repair_detail_View_NewDataGridView);
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(ly_inma0010DataGridView.Columns, ls);
filterForm.ShowDialog();
string nowfilter = filterForm.GetFilterString();
if (string.IsNullOrEmpty(nowfilter))
{
this.lY_InventoryMaintenance_query_newBindingSource.Filter = nowfilter;
}
else
{
this.lY_InventoryMaintenance_query_newBindingSource.Filter = "(" + nowfilter + ")" + " or 仓库='总计'";
}
//CountMoney(lY_InventoryMaintenance_query_newBindingSource, ly_inma0010DataGridView);
}
private void toolStripButton19_Click(object sender, EventArgs e)
{
if (null == this.ly_production_submit_periodDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYProductMange.ly_production_submit_period.Columns, ls);
filterForm.ShowDialog();
this.ly_production_submit_periodBindingSource.Filter = filterForm.GetFilterString();
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (null == this.ly_salesAndrepair_MaopossReportDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseMange2.ly_salesAndrepair_MaopossReport.Columns, ls);
filterForm.ShowDialog();
this.ly_salesAndrepair_MaopossReportBindingSource.Filter = filterForm.GetFilterString();
}
private void toolStripButton19_Click(object sender, EventArgs e)
{
if (null == this.ly_material_task_viewNewDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYPlanMange.ly_material_task_viewNew.Columns, ls);
filterForm.ShowDialog();
string filterstr = filterForm.GetFilterString();
if (!string.IsNullOrEmpty(filterstr))
{
this.ly_material_task_viewNewBindingSource.Filter = "(" + filterstr + ") or 计划编码='合计'";
}
AddSummationRow_New(ly_material_task_viewNewBindingSource, ly_material_task_viewNewDataGridView);
}
private void toolStripButton11_Click(object sender, EventArgs e)
{
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(ly_inma0010DataGridView.Columns, ls);
filterForm.ShowDialog();
string nowfilter = filterForm.GetFilterString();
if (string.IsNullOrEmpty(nowfilter))
{
this.ly_inma0010cpBindingSource.Filter = nowfilter;
}
else
{
//this.ly_inma0010BindingSource.Filter = "(" + nowfilter + ")" + " or 仓库='总计'";
this.ly_inma0010cpBindingSource.Filter = nowfilter;
}
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
if (null == this.ly_purchase_contract_mainDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYOutsourceData.ly_outsource_contract_main11.Columns, ls);
filterForm.ShowDialog();
this.ly_outsource_contract_main11BindingSource.Filter = filterForm.GetFilterString();
//this.ly_outsource_contract_main11TableAdapter.Fill(this.lYOutsourceData.ly_outsource_contract_main11, this.dateTimePicker1.Value, this.dateTimePicker2.Value.AddDays(1));
//AddSummationRow_New(ly_outsource_contract_main11BindingSource, ly_purchase_contract_mainDataGridView);
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
if (null == this.ly_sales_contract_standard_ReportDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseMange2.ly_sales_cost_Report.Columns, ls);
filterForm.ShowDialog();
string filterstr = filterForm.GetFilterString();
if (!string.IsNullOrEmpty(filterstr))
{
this.lysalescostReportBindingSource.Filter = "(" + filterstr + ") or 清单号='合计'";
}
AddSummationRow_New(lysalescostReportBindingSource, ly_sales_contract_standard_ReportDataGridView);
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(ly_inma0010_inoutDataGridView.Columns, ls);
filterForm.ShowDialog();
this.ly_waste_inoutBindingSource.Filter = filterForm.GetFilterString();
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (null == this.ly_store_outnumDateDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(ly_store_outnumDateDataGridView.Columns, ls);
filterForm.ShowDialog();
this.ly_store_outnumDateBindingSource.Filter = filterForm.GetFilterString();
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (null == this.ly_purchase_contract_inspectionRepDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYQualityInspector.qz_dz_report.Columns, ls);
filterForm.ShowDialog();
this.qzdzreportBindingSource.Filter = filterForm.GetFilterString();
}
//private void chehao_Click(object sender, EventArgs e)
//{
// string sel = "SELECT distinct vehicle_code as 车号 FROM YX_daywork_record " +
// " where vehicle_code is not null and len(vehicle_code) > 0 and (service_number is null or len(service_number) < 1) ";
// QueryForm queryForm = new QueryForm();
// queryForm.Sel = sel;
// queryForm.Constr = SQLDatabase.Connectstring;
// //Set the Column Collection to the filter Table
// //queryForm.SetSourceColumns(this.billMainDataSet.BalanceBill.Columns);
// queryForm.ShowDialog();
// this.textBox3.Text = queryForm.Result;
//}
//private void kehu_Click(object sender, EventArgs e)
//{
// string sel = "SELECT Name as 姓名, Card_number as 卡号 FROM YX_client";
// QueryForm queryForm = new QueryForm();
// queryForm.Sel = sel;
// queryForm.Constr = SQLDatabase.Connectstring;
// //Set the Column Collection to the filter Table
// //queryForm.SetSourceColumns(this.billMainDataSet.BalanceBill.Columns);
// queryForm.ShowDialog();
// this.textBox3.Text = queryForm.Result;
//}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (null == ds)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string> ();
ls.Add("id");
filterForm.SetSourceColumns(ds.Tables[0].Columns, ls);
filterForm.ShowDialog();
this.bindingSource2.Filter = filterForm.GetFilterString();
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
if (null == this.dataGridView5.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseMange.GetOrderByBussCodeAll.Columns, ls);
filterForm.ShowDialog();
this.getOrderByBussCodeAllBindingSource.Filter = filterForm.GetFilterString();
AddSummationRow_New(getOrderByBussCodeAllBindingSource, dataGridView5);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (null == this.dataGridView1.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseMange2.ly_plan_getmaterial_department.Columns, ls);
filterForm.ShowDialog();
this.ly_plan_getmaterial_departmentBindingSource1.Filter = filterForm.GetFilterString();
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (null == this.lY_qualityDebug_historyInfoDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYSalseMange.LY_qualityDebug_historyInfo.Columns, ls);
filterForm.ShowDialog();
this.lY_qualityDebug_historyInfoBindingSource.Filter = filterForm.GetFilterString();
//AddSummationRow_New(ly_sales_repairstandard_ReportBindingSource, ly_sales_contract_standard_ReportDataGridView);
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
if (null == this.ly_purchase_contract_mainDataGridView.CurrentRow)
{
return;
}
FilterForm filterForm = new FilterForm();
//SumQueryDataSet qds;
//qds = new SumQueryDataSet();
List <string> ls = new List <string>();
ls.Add("id");
filterForm.SetSourceColumns(this.lYMaterielRequirements.ly_purchase_contract_main11.Columns, ls);
filterForm.ShowDialog();
this.ly_purchase_contract_main11BindingSource.Filter = filterForm.GetFilterString();
//////AddSummationRow_New(ly_sales_repairstandard_ReportBindingSource, ly_sales_contract_standard_ReportDataGridView);
}
