private void button6_Click(object sender, EventArgs e) { string sql; if (comboBox1.SelectedIndex < 0 & textBox1.Text.ToString().Trim() != "" & textBox2.Text.ToString().Trim() != "" & textBox3.Text.ToString().Trim() != "") { sql = "select * from JDSoft_MES_Problem where 提出时间 like '%" + textBox1.Text.ToString().Trim() + "%' and 解决时间 like '%" + textBox2.Text.ToString().Trim() + "%' and 关闭时间 like '%" + textBox3.Text.ToString().Trim() + "%'"; } else if (comboBox1.SelectedIndex < 0 & textBox1.Text.ToString().Trim() == "" & textBox2.Text.ToString().Trim() != "" & textBox3.Text.ToString().Trim() != "") { sql = "select * from JDSoft_MES_Problem where 解决时间 like '%" + textBox2.Text.ToString().Trim() + "%' and 关闭时间 like '%" + textBox3.Text.ToString().Trim() + "%'"; } else if (comboBox1.SelectedIndex < 0 & textBox1.Text.ToString().Trim() == "" & textBox2.Text.ToString().Trim() == "" & textBox3.Text.ToString().Trim() != "") { sql = "select * from JDSoft_MES_Problem where 关闭时间 like '%" + textBox3.Text.ToString().Trim() + "%'"; } else if (comboBox1.SelectedIndex < 0 & textBox1.Text.ToString().Trim() == "" & textBox2.Text.ToString().Trim() == "" & textBox3.Text.ToString().Trim() == "") { sql = "select * from JDSoft_MES_Problem"; } else { sql = "select * from JDSoft_MES_Problem where 解决状态 like '%" + comboBox1.Items[comboBox1.SelectedIndex].ToString() + "%' and 提出时间 like '%" + textBox1.Text.ToString().Trim() + "%' and 解决时间 like '%" + textBox2.Text.ToString().Trim() + "%' and 关闭时间 like '%" + textBox3.Text.ToString().Trim() + "%'"; } DataTable rows = ConnectSQL.Reader(sql); dataGridView1.DataSource = rows; }
private void button5_Click(object sender, EventArgs e) //刷新 { string sql = "select * from JDSoft_MES_Problem;"; DataTable rows = ConnectSQL.Reader(sql); dataGridView1.DataSource = rows; }
private void toolStripButton3_Click(object sender, EventArgs e) { tabControl1.Visible = false; //显示合成脚本菜单 tabControl2.Visible = false; tabControl3.Visible = false; tabControl4.Visible = true; tabControl5.Visible = false; tabControl4.Dock = DockStyle.Fill;//填充窗体 string sql = "select * from JDSoft_MES_Problem;"; DataTable rows = ConnectSQL.Reader(sql); dataGridView1.DataSource = rows; }