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