var sql = " 1=1 ";
if (getItemValue("WHAO0000") !=null && getItemValue("WHAO0000").trim().length()>0){
sql += " and ITEM_WHAO0000='" +getItemValue("WHAO0000")+"'";
}
if (getItemValue("rqi00000") !=null && getItemValue("rqi00000").trim().length()>0){
sql += " and ITEM_rqi00000='" +getItemValue("rqi00000")+"'";
}
if (getItemValue("lwjguan0") !=null && getItemValue("lwjguan0").trim().length()>0){
sql += " and ITEM_lwjguan0='" +getItemValue("lwjguan0")+"'";
}
if (getItemValue("swhao000") !=null && getItemValue("swhao000").trim().length()>0){
sql += " and ITEM_swhao000='" +getItemValue("swhao000")+"'";
}
var sql1 ="SELECT * FROM tlk_cbtwlwgl where " + sql ;
sql1;
全部加上了,我这回不查视图了,我直接查基表,还是这样啊.... |