1,075
社区成员
发帖
与我相关
我的任务
分享
dw_pricespec.visible = false
dw_discitem.visible = false
dw_customertype.visible = false
dw_pricespec.settransobject( sqlca )
dw_discitem.settransobject( sqlca )
dw_discitem.retrieve( )
dw_customertype.settransobject( sqlca )
dw_customertype.retrieve( )
dw_item.settransobject( sqlca )
long ll_loop1, ll_loop2, ll_loop3
long ll_itemrows, ll_custyperows, ll_pricerows
long ll_row
ll_itemrows = dw_discitem.rowcount( )
ll_custyperows = dw_customertype.rowcount( )
string ls_custypeno, ls_itemno
for ll_loop1 = 1 to ll_itemrows
for ll_loop2 = 1 to ll_custyperows
ls_itemno = dw_discitem.getitemstring( ll_loop1, 'v_itemno' )
ls_custypeno = dw_customertype.getitemstring( ll_loop2, 'v_customertypeno' )
ll_pricerows = dw_pricespec.retrieve( ls_custypeno )
if dw_pricespec.find( "v_itemno = '" + ls_itemno + "'", 1, ll_pricerows ) <= 0 then
ll_row = dw_item.insertrow( 0 )
dw_item.setitem( ll_row, 'typeno', dw_discitem.getitemstring( ll_loop1, 'v_itemtypeno' ) )
dw_item.setitem( ll_row, 'subtypeno', dw_discitem.getitemstring( ll_loop1, 'v_subtypeno' ) )
dw_item.setitem( ll_row, 'itemno', dw_discitem.getitemstring( ll_loop1, 'v_itemno' ) )
dw_item.setitem( ll_row, 'name', dw_discitem.getitemstring( ll_loop1, 'v_name1' ) )
dw_item.setitem( ll_row, 'unit', dw_discitem.getitemstring( ll_loop1, 'v_unit' ) )
dw_item.setitem( ll_row, 'price', dw_discitem.getitemdecimal( ll_loop1, 'n_price' ) )
dw_item.setitem( ll_row, 'priceclub', dw_discitem.getitemdecimal( ll_loop1, 'n_priceclub' ) )
dw_item.setitem( ll_row, 'i_type', dw_discitem.getitemnumber( ll_loop1, 'i_type' ) )
exit
end if
next
next