对dw_1里的 edit属性为 dddw 字段里的子dw过滤,增加 child.setsqlselect(ls_oldsql) 是为了避免如果下次还有查询,免得把上次的查询条件带过来
datawindowchild child
string ls_oldsql
//对字段ht_ly_depcode里的dddw进行条件过滤
if dw_1.getchild("ht_ly_depcode",child) = 1 then
child.settransobject(sqlca)
ls_oldsql = child.getsqlselect()
gf_add_where_child(child," (cDepCode in ( select value from CPGL_Option where Name = 'dep_yl') )")
child.retrieve()
child.setsqlselect(ls_oldsql)
end if