private void button_pWPSQueryAdvance_Click(object sender, EventArgs e)
{
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(Enum_DataTable.WPS.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_WPSQuery g = new EventArgs_WPSQuery(myForm.str_Filter);
Publisher_WPSQuery.OnEventName(g);
}
}
private void button_Query_Click(object sender, EventArgs e)
{
if (this.dataGridView_Data.Tag == null)
{
return;
}
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(this.dataGridView_Data.Tag.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
((DataView)this.dataGridView_Data.DataSource).RowFilter = string.Format("KindofEmployer='{0}' And ({1})", this.myEventArgs_KindofEmployer.str_KindofEmployer, myForm.str_Filter);;
}
}
private void button_Query_Click(object sender, EventArgs e)
{
if (this.dataGridView_Data.Tag == null)
{
return;
}
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(this.dataGridView_Data.Tag.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_DataManager my_e = new EventArgs_DataManager(this.myEventArgs_DataManager.str_DataManagerText, this.myEventArgs_DataManager.str_DataManagerName, this.myEventArgs_DataManager.str_DataManagerTag);
my_e.str_Filter = myForm.str_Filter;
Publisher_DataManager.OnEventName(my_e);
}
}
private void button_QueryAdvance_Click(object sender, EventArgs e)
{
Form_QueryFilter myForm = new Form_QueryFilter();
if (this.bool_GXTheory == false)
{
myForm.InitControl(Enum_DataTable.Issue.ToString());
}
else
{
myForm.InitControl(Enum_DataTable.GXTheoryIssue.ToString());
}
if (myForm.ShowDialog() == DialogResult.OK)
{
EventArgs_ShipClassification g = new EventArgs_ShipClassification(null, this.bool_GXTheory);
g.str_Filter = myForm.str_Filter;
Publisher_ShipClassification.OnEventName(g);
}
}
private void button_QueryFilter_Click(object sender, EventArgs e)
{
Form_QueryFilter myForm = new Form_QueryFilter();
myForm.InitControl(Enum_DataTable.Welder.ToString());
if (myForm.ShowDialog() == DialogResult.OK)
{
SqlCommand myCmd_Temp = new SqlCommand("Person_Welder_Query", Class_zwjPublic.myClass_SqlConnection.mySqlConn);
myCmd_Temp.CommandType = CommandType.StoredProcedure;
myCmd_Temp.Parameters.Add("@Filter", SqlDbType.NVarChar, 4000).Value = myForm.str_Filter;
SqlDataAdapter myAdapter = new SqlDataAdapter(myCmd_Temp);
this.myDataTable = new DataTable();
myAdapter.Fill(myDataTable);
this.dataGridView_Query.DataSource = new DataView(myDataTable);
if (bool_QueryBatch)
{
DataColumn myDataColumn = new DataColumn("Checked");
myDataColumn.DataType = System.Type.GetType("System.Boolean");
myDataColumn.DefaultValue = true;
myDataTable.Columns.Add(myDataColumn);
}
}
}
