help!help me!
slyfp 2010-01-15 10:04:29 在按钮cb_query的CLICKED事件中加入以下代码,根据用户在物料编号、物料名称和物料拼音只能够输入的内容检索出物料主文件的数据:
代码如下:
请大家帮我详细讲解代码的内涵:
string ls_wlbh,ls_wlmc,ls_wlpy,ls_select
ls_wlbh = trim(sle_wlbh.text)
ls_wlmc = trim(sle_wlmc.text)
ls_wlpy = trim(sle_wlpy.text)
ls_slect = ""
if isnull(ls_wlbh) then
ls_wlbh = ""
end if
if isnull(ls_wlmc) then
ls_wlmc = ""
end if
if isnull(ls_wlpy) then
ls_wlpy = ""
end if
ls_wlbh = "%" + ls_wlbh + "%"
ls_wlmc = "%" + ls_wlpy + "%"
ls_wlpy = "%" + ls_wlpy + "%"
ls_select = "物料编号 like '" + ls_wlbh + "'"
ls_select = ls_select + " and 物料名称 like '" + ls_wlmc + "'"
ls_select = ls_select + " and 拼音编码 like '" + ls_wlpy + "'"
ls_select = is _sql + " where " + ls_select
dw_1.setsqlselect(ls_select)
dw_1.retrieve()