FXApp/ws_objects/plugins_publ.pbl.src/uo_ddlb_storageid.sru

$PBExportHeader$uo_ddlb_storageid.sru
forward
global type uo_ddlb_storageid from dropdownlistbox
end type
end forward

global type uo_ddlb_storageid from dropdownlistbox
integer width = 247
integer height = 228
integer taborder = 10
integer textsize = -9
integer weight = 400
fontcharset fontcharset = gb2312charset!
fontpitch fontpitch = variable!
string facename = "宋体"
long textcolor = 33554432
boolean vscrollbar = true
borderstyle borderstyle = stylelowered!
end type
global uo_ddlb_storageid uo_ddlb_storageid

type variables
long uo_storageid
long uo_storageid_arr[]
end variables

event constructor;Long ll_storageid
String ls_storagename,ls_scode
Long ll_storageid_ddlb_text
String ls_storagename_ddlbtext,ls_scode_ddlbtext
String ls_ddlbtext
Long cnt = 0 
Long ll_i
Int li_inuse

FOR ll_i = 1 To UpperBound(sys_user_storageid)
	ll_storageid = sys_user_storageid[ll_i]
	SELECT storagename,scode,inuse
		INTO :ls_storagename,:ls_scode,:li_inuse
		FROM u_storage
		WHERE storageid = :ll_storageid
		Order By scode Asc;
	IF sqlca.SQLCode <> 0 Or IsNull(ls_storagename) THEN ls_storagename = ''
	IF sqlca.SQLCode <> 0 Or IsNull(ls_scode) THEN ls_scode = ''
	
	IF li_inuse = 0 THEN CONTINUE
	
	ls_ddlbtext = f_scode_name(ll_storageid,ls_scode,ls_storagename)
	
	This.AddItem (ls_ddlbtext)
	
	ll_storageid_ddlb_text = ll_storageid
	ls_storagename_ddlbtext = ls_storagename
	ls_scode_ddlbtext = ls_scode
	
	cnt++
NEXT

This.uo_storageid = ll_storageid_ddlb_text
uo_storageid_arr[1] = ll_storageid_ddlb_text
This.Text = f_scode_name(ll_storageid_ddlb_text,ls_scode_ddlbtext,ls_storagename_ddlbtext)

//SELECT count(*) Into :cnt From u_storage Where inuse = 1 ;
IF cnt > 1 THEN
	This.AddItem ('[全部仓库]')
END IF


end event

event selectionchanged;Long ll_storageid_arr[]

IF THIS.Text = '[全部仓库]' THEN
	uo_storageid = -1
	ll_storageid_arr = sys_user_storageid
	uo_storageid_arr = ll_storageid_arr
ELSE
	uo_storageid = Long(Mid ( THIS.Text,Pos(THIS.Text,'[') + 1,Len(THIS.Text) - Pos(THIS.Text,'[') - 1 ))
	ll_storageid_arr[1] = uo_storageid
	uo_storageid_arr = ll_storageid_arr
END IF



end event

on uo_ddlb_storageid.create
end on

on uo_ddlb_storageid.destroy
end on