dw_tiaojian.accepttext()
if ziduan_select=0 then
messagebox('提示','还没有选定字段')
else
for gi_round=1 to 12
if dw_tiaojian.getitemstring(gi_round,'ziduan',primary!,false)<>'' and &
dw_tiaojian.getitemstring(gi_round,'tiaojian',primary!,false)<>'' and &
dw_tiaojian.getitemstring(gi_round,'neiyong',primary!,false)<>'' then
for number=1 to ziduan_select
ls_prodinfo=dw_tiaojian.getvalue('ziduan',number)
li_tab=pos(ls_prodinfo,"~t",1)
ls_prodname=left(ls_prodinfo,li_tab - 1)
if ls_prodname=&
dw_tiaojian.getitemstring(gi_round,'ziduan',primary!,false) then
ls_ziduan=&
gf_zhongwentopinyin(ddlb_cxfx.text,rb_text,li_number[number])
end if
next
ls_sqlwhere_text[gi_round]=ls_ziduan+&
+dw_tiaojian.getitemstring(gi_round,'tiaojian',primary!,false)&
+dw_tiaojian.getitemstring(gi_round,'neiyong',primary!,false)&
+' '+dw_tiaojian.getitemstring(gi_round,'logic',primary!,false)+' '
ls_ziduan=''
end if
next
end if
for gi_round=1 to 12
if ls_sqlwhere_text[gi_round]<>'' then
ls_sqlwhere=ls_sqlwhere+ls_sqlwhere_text[gi_round]
end if
next
date bb
bb=date('2002-3-5')
ls_sql="select "+ls_sqlselect+" from jy_ygsc"+" where"+" jy_ygsc.rq=date('2002-3-5','yyyy-mm-dd')"
ls_exp=trans_ds.syntaxfromsql(ls_sql,'style(type=gird)',ls_err)
dw_1.create(ls_exp)
dw_1.settransobject(trans_ds)
dw_1.retrieve()
messagebox('f',trim(ls_sql))