//sure
private void button2_Click(object sender, EventArgs e)
{
string strWh = "1=1";
if (!string.IsNullOrEmpty(comboBox1.Text))
{
strWh = strWh + " AND BAR001='" + comboBox1.Text + "'";
}
if (!string.IsNullOrEmpty(comboBox2.Text))
{
strWh = strWh + " AND BAR006='" + comboBox2.Text + "'";
}
if (!string.IsNullOrEmpty(comboBox3.Text))
{
strWh = strWh + " AND BAR007='" + comboBox3.Text + "'";
}
if (!string.IsNullOrEmpty(comboBox4.Text))
{
strWh = strWh + " AND BAR008='" + comboBox4.Text + "'";
}
if (!string.IsNullOrEmpty(comboBox7.Text))
{
strWh = strWh + " AND BAR011='" + comboBox7.Text + "'";
}
if (!string.IsNullOrEmpty(comboBox8.Text))
{
strWh = strWh + " AND BAR012='" + comboBox8.Text + "'";
}
PassDataWinFormEventArgs args = new PassDataWinFormEventArgs(strWh);
if (PassDataBetweenForm != null)
{
PassDataBetweenForm(this, args);
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
private void query_PassDataBetweenForm(object sender, PassDataWinFormEventArgs e)
{
strWhere = e.StrW;
}