帮忙简化

[rocklicong]

string l_cb1,l_cb2,l_cb3,l_cb4,l_sql,sqlstring
l_cb1=trim(string(sle_1.text));
l_cb2=trim(string(sle_2.text));
l_cb3=trim(string(sle_3.text));
l_cb4=trim(string(sle_4.text));

if l_cb1='' or isnull(l_cb1) then
l_cb1=''
else
l_cb1=" and order_custom ="+l_cb1
end if

if l_cb2='' or isnull(l_cb2) then
l_cb2=''
else
l_cb2=" and order_id like "+"'%"+l_cb2+"%'"
end if

if l_cb3='' or isnull(l_cb3) then
l_cb3=''
else
l_cb3=" and order_id like "+"'%"+l_cb3+"%'"
end if

if l_cb4='' or isnull(l_cb3) then
l_cb4=''
else
l_cb4=" and order_id like "+"'%"+l_cb4+"%'"
end if


l_sql= " where 1=1 " +l_cb1+l_cb2+l_cb3+l_cb4

[yyoinge]

int i
string ls_col1[] = {"order_custom = ", "order_id like '%", "order_id like '%", "order_id like '%"}
string ls_col2[] = {"", "%'", "%'", "%'"}
string ls_data[]
string l_sql= " where 1=1 "
ls_data = {sle_1.text,sle_2.text,sle_3.text,sle_4.text}
for i = 1 to upperbound(ls_col1)
	if not(ls_data[i] = '' or isnull(ls_data[i])) then l_sql += " and " + ls_col1[i] + ls_data[i] + ls_col2[i]	
next

[WorldMobile]

把

if l_cb3='' or isnull(l_cb3) then
l_cb3=''
else
l_cb3=" and order_id like "+"'%"+l_cb3+"%'"
end if

写成函数，然后调用，程序就可以简化了

[路人甲cw]

[Quote=引用 2 楼 yyoinge 的回复:]

C/C++ code
int i
string ls_col1[] = {"order_custom = ", "order_id like '%", "order_id like '%", "order_id like '%"}
string ls_col2[] = {"", "%'", "%'", "%'"}
string ls_data[]
string l_sql= " where 1……
[/Quote]
支持!!!