1,178
社区成员
发帖
与我相关
我的任务
分享
AnsiString strSQL = "SELECT * FROM worker WHERE ";
if (!Edit1->Text.IsEmpty())
strSQL += " num='"+ Edit1->Text + "' AND";
if (!Edit2->Text.IsEmpty())
strSQL += " wname='"+ Edit2->Text + "' AND";
AnsiString strXB;
if (RadioButton1->Checked)
strXB = "男";
if ( RadioButton2->Checked)
strXB = "女";
if (!strXB.IsEmpty())
strSQL += " sex='" + strXB + "' AND";
if (!Edit3->Text.IsEmpty())
strSQL += " id='" + Edit3->Text + "' AND";
if (ComboBox1->Text == "请选择")
strSQL += " department IS NOT NULL";
else
strSQL += " department='" + ComboBox1->Text + "'";
重写了一点,看是不是你要的结果