And ComboBox4.Text = "全部" And ComboBox5.Text <> "全部" Then
sql = "select *from car where car_name='" + ComboBox1.Text + "'and car_color='"
+ ComboBox5.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text <> "全部" And ComboBox3.Text <> "全部"
And ComboBox4.Text = "全部" And ComboBox5.Text = "全部" Then
sql = "select *from car where car_rent_money='" + ComboBox2.Text + "'and
car_use='" + ComboBox3.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text <> "全部" And ComboBox3.Text = "全部"
And ComboBox4.Text <> "全部" And ComboBox5.Text = "全部" Then
sql = "select *from car where car_rent_money='" + ComboBox2.Text + "'and
car_passenger='" + ComboBox4.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text <> "全部" And ComboBox3.Text = "全部"
And ComboBox4.Text = "全部" And ComboBox5.Text <> "全部" Then
sql = "select *from car where car_rent_money='" + ComboBox2.Text + "'and
car_color='" + ComboBox5.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text = "全部" And ComboBox3.Text <> "全部"
And ComboBox4.Text <> "全部" And ComboBox5.Text = "全部" Then
sql = "select *from car where car_use='" + ComboBox3.Text + "'and
car_passenger='" + ComboBox4.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text = "全部" And ComboBox3.Text <> "全部"
And ComboBox4.Text = "全部" And ComboBox5.Text <> "全部" Then
sql = "select *from car where car_use='" + ComboBox3.Text + "'and car_color='" +
ComboBox5.Text + "'"
End If
If ComboBox1.Text = "全部" And ComboBox2.Text = "全部" And ComboBox3.Text = "全部"
And ComboBox4.Text <> "全部" And ComboBox5.Text <> "全部" Then
sql = "select *from car where car_passenger='" + ComboBox4.Text + "'and
car_color='" + ComboBox5.Text + "'"
End If
If ComboBox1.Text <> "全部" And ComboBox2.Text <> "全部" And ComboBox3.Text <> "全部"
And ComboBox4.Text = "全部" And ComboBox5.Text = "全部" Then
sql = "select *from car where car_name='" + ComboBox1.Text + "'and
car_rent_money='" + ComboBox2.Text + "'and car_use='" + ComboBox3.Text + "'"
End If
If ComboBox1.Text <> "全部" And ComboBox2.Text <> "全部" And ComboBox3.Text = "全部"
And ComboBox4.Text <> "全部" And ComboBox5.Text = "全部" Then
sql = "select *from car where car_name='" + ComboBox1.Text + "'and
car_rent_money='" + ComboBox2.Text + "'and car_passenger='" + ComboBox4.Text + "'"
End If