1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566 |
- $PBExportHeader$w_outware_sale_wareaudit_th.srw
- forward
- global type w_outware_sale_wareaudit_th from w_publ_1ton_share_detail
- end type
- type ddlb_scid from uo_ddlb_scid within w_outware_sale_wareaudit_th
- end type
- type ddlb_status from dropdownlistbox within w_outware_sale_wareaudit_th
- end type
- type st_3 from statictext within w_outware_sale_wareaudit_th
- end type
- type st_2 from statictext within w_outware_sale_wareaudit_th
- end type
- type st_msg from statictext within w_outware_sale_wareaudit_th
- end type
- type cbx_his from checkbox within w_outware_sale_wareaudit_th
- end type
- end forward
- global type w_outware_sale_wareaudit_th from w_publ_1ton_share_detail
- integer height = 2348
- string title = "销售退货单仓审"
- boolean maxbox = true
- windowstate windowstate = maximized!
- event insert_childrow ( )
- event ue_priceaudit ( )
- event ue_cpriceaudit ( )
- event ue_importseleprice ( )
- event ue_copy ( )
- event ue_paste ( )
- event ue_importcusseleprice ( )
- event ue_importcusseleprice_his ( )
- event ue_fj_view ( )
- event ue_fj_edit ( )
- ddlb_scid ddlb_scid
- ddlb_status ddlb_status
- st_3 st_3
- st_2 st_2
- st_msg st_msg
- cbx_his cbx_his
- end type
- global w_outware_sale_wareaudit_th w_outware_sale_wareaudit_th
- type variables
- uo_outware_sale uo_ware
- long cur_scid //分店ID
- long cur_scid_arr[]
- int cur_editfocus=0 //1:新建2:修改
- string cur_outrepcode='' //当前供销编号
- long cur_flag= -1 //-1:全部,0仓库未审,1仓库已审核
- long cur_secflag= -1 //-1:全部,0财务未审
- long flag= 0
- long secflag= 0
- string ol_cdw_str = ''
-
- end variables
- forward prototypes
- public function integer wf_flagstatus_rf ()
- public function integer wf_refresh_curuc (long arg_scid, long arg_wareid)
- public function integer wf_check_ifmtrlware (ref string arg_msg)
- public function integer wf_copy (ref string arg_msg)
- public function integer wf_paste (ref string arg_msg)
- public function integer wf_check_ifcuststorage (long arg_storageid, ref long arg_cusid, ref string arg_msg)
- public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg)
- public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg)
- end prototypes
- event insert_childrow();long li_row
- li_row=dw_child.insertrow(0)
- dw_child.scrolltorow(li_row)
- dw_child.SetColumn ('u_mtrldef_mtrlcode')
- end event
- event ue_priceaudit();IF dw_edit_mode THEN
- MessageBox('提示',"编辑状态下不可以使用!",information!,OK!)
- return
- END IF
- IF NOT f_power_ind(563) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- String arg_msg
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- IF uo_ware.priceaudit(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row],TRUE,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- MessageBox('提示','确认成功!',information!,OK!)
- wf_refresh_curuc(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row])
- end event
- event ue_cpriceaudit();IF dw_edit_mode THEN
- MessageBox('提示',"编辑状态下不可以使用!",information!,OK!)
- return
- END IF
- IF NOT f_power_ind(563) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- String arg_msg
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- IF uo_ware.c_priceaudit(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row],TRUE,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- //日志
- Long ls_id
- String ls_code
- ls_id = dw_pageretr.Object.u_outware_outwareid[pagerert_row]
- ls_code = dw_pageretr.Object.u_outware_outwarecode[pagerert_row]
- f_setsysoplog('销售退货单','反确认,id:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE)
- //--
- MessageBox('提示','反确认成功!',information!,OK!)
- wf_refresh_curuc(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row])
- end event
- event ue_importseleprice();//IF NOT dw_edit_mode THEN
- // MessageBox('提示',"非编辑状态下不可以使用!",information!,OK!)
- // RETURN
- //END IF
- //
- //Long ls_row,ls_cusid,ls_mtrlid
- //String ls_cuscode,ls_cusname,arg_msg
- //Long uc_row
- //Decimal obj_price ,obj_rebate
- //String err_str = ''
- //Boolean if_exist_price = TRUE
- //Long ls_pricelistid,ll_moneyid
- //String ls_status,ls_pcode,ls_woodcode
- //s_pricelist_ch s_pricelist
- //
- //ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
- // MessageBox('提示','请先选择币种',information!,OK!)
- // RETURN
- //END IF
- //
- ////直接查询价格表
- //// IF MessageBox (publ_operator,"是否直接选择价格表?",Question!,YesNo! ) = 2 THEN RETURN
- //Open(w_sale_price_list_ch)
- //s_pricelist = Message.PowerObjectParm
- //IF s_pricelist.pricelistid <= 0 THEN RETURN
- //FOR ls_row = 1 TO dw_child.RowCount()
- // ls_mtrlid = dw_child.Object.u_outwaremx_mtrlid[ls_row]
- // ls_status = dw_child.Object.u_outwaremx_status[ls_row]
- // ls_pcode = dw_child.Object.u_outwaremx_pcode[ls_row]
- // ls_woodcode = dw_child.Object.u_outwaremx_woodcode[ls_row]
- //
- // IF sys_option_price_if_status = 0 THEN
- // ls_status = ''
- // ls_pcode = ''
- // ls_woodcode = ''
- // END IF
- //
- //
- // SELECT u_sale_price_mx.price
- // INTO :obj_price
- // FROM u_sale_price_mx
- // WHERE (u_sale_price_mx.pricelistid = :s_pricelist.pricelistid) AND
- // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
- // ( u_sale_price_mx.status = :ls_status ) AND
- // ( u_sale_price_mx.pcode = :ls_pcode ) AND
- // ( u_sale_price_mx.woodcode = :ls_woodcode );
- // IF sqlca.SQLCode <> 0 THEN
- // err_str = err_str + "当前价格表的 "+String(dw_child.Object.u_mtrldef_mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[ls_row] = obj_price
- // END IF
- //NEXT
- //
- //
- //IF err_str <> '' THEN
- // MessageBox('错误',err_str,stopsign!,OK!)
- //END IF
- //
- //
- //
- end event
- event ue_copy();string arg_msg=''
- if wf_copy(arg_msg) = 1 then
- messagebox('提示','复制成功',information!,OK!)
- else
- messagebox('错误',arg_msg,stopsign!,OK!)
- end if
- end event
- event ue_paste();string arg_msg=''
- if wf_paste(arg_msg) = 1 then
-
- else
- messagebox('错误',arg_msg,stopsign!,OK!)
- end if
- end event
- event ue_importcusseleprice();//
- ////查询客户价格表
- ////如果客户无价格表则提示是否直接查询价格表
- //Long ls_row,ls_cusid,ls_mtrlid
- //String ls_cuscode,ls_cusname,arg_msg
- //Long uc_row
- //Decimal obj_price ,obj_rebate
- //String err_str = ''
- //Boolean if_exist_price = TRUE
- //Long ls_pricelistid,ll_moneyid
- //String ls_status,ls_pcode,ls_woodcode
- //s_pricelist_ch s_pricelist
- //
- //uc_row = dw_uc.GetRow()
- //
- //ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- //
- //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
- // MessageBox('提示','请先选择币种',information!,OK!)
- // RETURN
- //END IF
- //
- //IF dw_uc.Object.u_outware_cusid[uc_row] = 0 OR IsNull(dw_uc.Object.u_outware_cusid[uc_row]) THEN
- // MessageBox('提示',"请选择销售客户!",information!,OK!)
- // RETURN
- //END IF
- //ls_cusid = dw_uc.Object.u_outware_cusid[uc_row]
- //
- //SELECT u_cust.pricelistid INTO :ls_pricelistid FROM u_cust Where u_cust.cusid = :ls_cusid;
- //IF sqlca.SQLCode <> 0 OR ls_pricelistid <= 0 THEN
- // if_exist_price = FALSE
- //END IF
- //
- //
- //IF if_exist_price = FALSE THEN
- // IF MessageBox('询问',"当前客户的计划售价尚未设定!是否查询价格列表?",Question!,YesNo!) = 2 THEN RETURN
- // Open(w_sale_price_list_ch)
- // s_pricelist = Message.PowerObjectParm
- // IF s_pricelist.pricelistid <= 0 THEN RETURN
- //END IF
- //
- //FOR ls_row = 1 TO dw_child.RowCount()
- // ls_mtrlid = dw_child.Object.u_outwaremx_mtrlid[ls_row]
- // ls_status = dw_child.Object.u_outwaremx_status[ls_row]
- // ls_pcode = dw_child.Object.u_outwaremx_pcode[ls_row]
- // ls_woodcode = dw_child.Object.u_outwaremx_woodcode[ls_row]
- //
- // IF sys_option_price_if_status = 0 THEN
- // ls_status = ''
- // ls_pcode = ''
- // ls_woodcode = ''
- // END IF
- //
- //
- // IF if_exist_price THEN //查询客户价格表
- // IF Not (IsNull(ls_mtrlid) OR ls_mtrlid = 0 ) THEN
- // SELECT u_sale_price_mx.price
- // INTO :obj_price
- // FROM u_sale_price_list ,u_cust,u_sale_price_mx
- // WHERE (u_sale_price_list.pricelistid = u_cust.pricelistid) AND
- // (u_sale_price_mx.pricelistid = u_sale_price_list.pricelistid) AND
- // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
- // ( u_cust.cusid = :ls_cusid ) AND
- // ( u_sale_price_mx.status = :ls_status ) AND
- // ( u_sale_price_mx.pcode = :ls_pcode ) AND
- // ( u_sale_price_mx.woodcode = :ls_woodcode );
- // IF sqlca.SQLCode <> 0 THEN
- // err_str = err_str + "当前客户的 "+String(dw_child.Object.u_mtrldef_mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[ls_row] = obj_price
- // END IF
- // END IF
- // ELSE //查询价格列表
- // SELECT u_sale_price_mx.price
- // INTO :obj_price
- // FROM u_sale_price_mx
- // WHERE ( u_sale_price_mx.pricelistid = :s_pricelist.pricelistid ) AND
- // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND
- // ( u_sale_price_mx.status = :ls_status ) AND
- // ( u_sale_price_mx.pcode = :ls_pcode ) AND
- // ( u_sale_price_mx.woodcode = :ls_woodcode );
- // IF sqlca.SQLCode <> 0 THEN
- // err_str = err_str + "当前价格表的 "+String(dw_child.Object.u_mtrldef_mtrlname[ls_row])+" 的计划售价尚未设定! ~n"
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[ls_row] = obj_price
- // END IF
- // END IF
- //NEXT
- //IF err_str <> '' THEN
- // MessageBox('错误',err_str,stopsign!,OK!)
- //END IF
- //
- //
- end event
- event ue_importcusseleprice_his();//// //导入客户历史售价
- //Long ls_row,ls_cusid,ls_mtrlid
- //String ls_cuscode,ls_cusname,arg_msg
- //Long uc_row
- //Decimal obj_price ,obj_rebate,obj_rate
- //String err_str = ''
- //Boolean if_exist_price = TRUE
- //Long ls_pricelistid,ll_moneyid
- //String ls_status,ls_pcode,ls_woodcode,ls_unit
- //s_pricelist_ch s_pricelist
- //uc_row = dw_uc.GetRow()
- //
- //ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
- // MessageBox('提示','请先选择币种',information!,OK!)
- // RETURN
- //END IF
- //
- //IF dw_uc.Object.u_outware_cusid[uc_row] = 0 OR IsNull(dw_uc.Object.u_outware_cusid[uc_row]) THEN
- // MessageBox('提示',"请选择销售客户!",information!,OK!)
- // RETURN
- //END IF
- //ls_cusid = dw_uc.Object.u_outware_cusid[uc_row]
- //ls_cuscode = dw_uc.Object.u_cust_cuscode[uc_row]
- //ls_cusname = dw_uc.Object.u_cust_name[uc_row]
- //
- //IF dw_child.RowCount() <= 0 THEN
- // MessageBox('提示',"请选择产品!",information!,OK!)
- // RETURN
- //END IF
- //FOR ls_row = 1 TO dw_child.RowCount()
- // ls_mtrlid = dw_child.Object.u_outwaremx_mtrlid[ls_row]
- // ls_status = dw_child.Object.u_outwaremx_status[ls_row]
- // ls_pcode = dw_child.Object.u_outwaremx_pcode[ls_row]
- // ls_woodcode = dw_child.Object.u_outwaremx_woodcode[ls_row]
- // ls_unit = dw_child.Object.u_mtrldef_unit[ls_row]
- //
- // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_cusid,ls_unit,ls_woodcode,ls_status,ls_pcode,0,obj_price,obj_rebate,obj_rate,arg_msg) <> 1 THEN
- // err_str = err_str + "导入客户["+ls_cuscode+ls_cusname+"]的 "+String(dw_child.Object.u_mtrldef_mtrlname[ls_row])+" 的最新售价失败,或没有最新售价! ~n "
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[ls_row] = obj_price
- // dw_child.Object.u_outwaremx_rebate[ls_row] = obj_rebate
- // END IF
- //NEXT
- //
- //
- //IF err_str <> '' THEN
- // MessageBox('错误',err_str,stopsign!,OK!)
- //END IF
- //
- //
- end event
- event ue_fj_view();s_edit_index_tran s_pic
- Long ll_ConnectionID
- String arg_msg
- Long ls_row
- ls_row = dw_pageretr.GetRow()
- IF ls_row <= 0 THEN
- RETURN
- END IF
- IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
- MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
- RETURN
- END IF
- s_pic.f_long = 133 //销售订单的mainID
- s_pic.f_string = dw_pageretr.Object.u_outware_outwarecode[ls_row]
- s_pic.g_long = dw_pageretr.Object.u_outware_outwareid[ls_row]
- s_pic.e_long = dw_pageretr.Object.u_outware_scid[ls_row]
- s_pic.sqltransaction = sys_filedb_sqlca
- OpenWithParm(w_fj_bill_view,s_pic)
- end event
- event ue_fj_edit();s_edit_index_tran s_pic
- Long ll_ConnectionID
- String arg_msg
- Long ls_row
- ls_row = dw_pageretr.GetRow()
- IF ls_row <= 0 THEN
- RETURN
- END IF
- IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN
- MessageBox('提示','没有指定附件数据库连接'+arg_msg,information!,OK!)
- RETURN
- END IF
- s_pic.f_long = 133 //销售订单的mainID
- s_pic.f_string = dw_pageretr.Object.u_outware_outwarecode[ls_row]
- s_pic.g_long = dw_pageretr.Object.u_outware_outwareid[ls_row]
- s_pic.e_long = dw_pageretr.Object.u_outware_scid[ls_row]
- s_pic.sqltransaction = sys_filedb_sqlca
- OpenWithParm(w_fj_bill_mng,s_pic)
- //wf_check_billfj()
- end event
- public function integer wf_flagstatus_rf ();//wf_flagstatus_rf()
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- cb_auditing.Text = '仓审&F'
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Text = '撤审'
- cb_auditing_cancel.Enabled = FALSE
- flag = -1
- secflag = -1
- GOTO ext
- END IF
- flag = dw_pageretr.Object.flag[pagerert_row]
- secflag = dw_pageretr.Object.secflag[pagerert_row]
- IF dw_edit_mode THEN
- cb_auditing.Text = '仓审&F'
- cb_auditing.Enabled = FALSE
- IF cur_editfocus = 1 THEN
- flag = -1
- secflag = -1
- END IF
- cb_auditing_cancel.Enabled = FALSE
- ELSE
- IF flag = 0 THEN
- cb_auditing.Enabled = TRUE
- cb_auditing.Text = '仓审&F'
- cb_auditing_cancel.Enabled = FALSE
- ELSEIF flag = 1 AND secflag = 0 THEN
- cb_auditing.Enabled = false
- cb_auditing.Text = '仓审&F'
- cb_auditing_cancel.Enabled = TRUE
- cb_auditing_cancel.Text = '仓撤'
- ELSE
- cb_auditing.Text = '仓审&F'
- cb_auditing.Enabled = FALSE
-
- cb_auditing_cancel.Enabled = false
- cb_auditing_cancel.Text = '仓撤'
- END IF
- END IF
- cb_auditing.TriggerEvent('ue_textchange')
- cb_auditing_cancel.TriggerEvent('ue_textchange')
- ext:
- RETURN 0
- end function
- public function integer wf_refresh_curuc (long arg_scid, long arg_wareid);//====================================================================
- // Function: wf_refresh_curuc(arg_scid,arg_inwareid)
- //--------------------------------------------------------------------
- // Description: 刷新dw_uc
- //--------------------------------------------------------------------
- // Arguments:
- // value long arg_scid
- // value long arg_inwareid
- //--------------------------------------------------------------------
- // Returns: integer
- //--------------------------------------------------------------------
- // Author: yyx Date: 2003.11.14
- //--------------------------------------------------------------------
- // Modify History:
- //
- //====================================================================
- //wf_refresh_curuc
- if arg_wareid<=0 or isnull(arg_wareid) then return 0
- long uc_row
- uc_row=dw_pageretr.getrow()
- if uc_row<=0 then return 0
- long outwareid,cusid
- datetime outdate
- string part,cusname
- string outrep
- string dscrp
- int planflag
- int balcflag
- string outwarecode
- datetime opdate
- string operator
- int li_flag ,li_secflag ,li_priceflag
- datetime auditingdate ,secauditingdate ,moddate,pricedate
- string Auditingrep ,secAuditingrep ,modemp,priceemp
- string storagename
- int thflag
- SELECT u_outware.outdate,
- u_outware.outrep,
- u_outware.part,
- u_outware.dscrp,
- u_outware.outwarecode,
- u_outware.opdate,
- u_outware.opemp,
- u_outware.auditingdate,
- u_outware.flag,
- u_outware.auditingrep,
- u_outware.secauditingdate,
- u_outware.secflag,
- u_outware.secauditingrep,
- u_outware.balcflag,
- u_outware.cusid,
- u_cust.name,
- u_storage.storagename ,
- u_outware.thflag,
- u_outware.modemp,
- u_outware.moddate,
- u_outware.priceflag,
- u_outware.priceemp,
- u_outware.pricedate
- into :outdate,
- :outrep,
- :part,
- :dscrp,
- :outwarecode,
- :opdate,
- :operator,
- :Auditingdate,
- :li_flag,
- :Auditingrep,
- :secAuditingdate,
- :li_secflag,
- :secAuditingrep,
- :balcflag,
- :cusid,
- :cusname,
- :storagename,
- :thflag,
- :modemp,
- :moddate,
- :li_priceflag,
- :priceemp,
- :pricedate
- FROM u_outware,
- u_cust ,u_storage
- WHERE ( u_outware.cusid = u_cust.cusid ) and
- ( u_outware.outwareid = :arg_wareid ) and
- ( u_outware.storageid = u_storage.storageid) and
- ( u_outware.scid=:arg_scid);
- if sqlca.sqlcode<>0 then
- messagebox('错误',"查询操作失败(错误单据唯一码)",stopsign!,OK!)
- return 0
- end if
- dw_pageretr.object.u_outware_scid[uc_row]=arg_scid
- dw_pageretr.object.u_outware_outwareid[uc_row]=arg_wareid
- dw_pageretr.object.u_outware_outdate[uc_row]=outdate
- dw_pageretr.object.u_outware_part[uc_row]= part
- dw_pageretr.object.u_outware_outrep[uc_row]= outrep
- dw_pageretr.object.u_outware_dscrp[uc_row]= dscrp
- dw_pageretr.object.u_outware_balcflag[uc_row]= balcflag
- dw_pageretr.object.u_outware_outwarecode[uc_row]=outwarecode
- dw_pageretr.object.u_outware_opdate[uc_row]= opdate
- dw_pageretr.object.u_outware_opemp[uc_row]= operator
- dw_pageretr.object.flag[uc_row]= li_flag
- dw_pageretr.object.u_outware_Auditingdate[uc_row]= Auditingdate
- dw_pageretr.object.u_outware_Auditingrep[uc_row]=Auditingrep
- dw_pageretr.object.u_outware_cusid[uc_row]=cusid
- dw_pageretr.object.u_cust_name[uc_row]=cusname
- dw_pageretr.object.u_storage_storagename[uc_row]=storagename
- dw_pageretr.object.u_outware_thflag[uc_row]=thflag
- dw_pageretr.object.secflag[uc_row]= li_secflag
- dw_pageretr.object.u_outware_secAuditingdate[uc_row]= secAuditingdate
- dw_pageretr.object.u_outware_secAuditingrep[uc_row]=secAuditingrep
- dw_pageretr.object.u_outware_moddate[uc_row]= moddate
- dw_pageretr.object.u_outware_modemp[uc_row]=modemp
- dw_pageretr.object.u_outware_priceflag[uc_row]= li_priceflag
- dw_pageretr.object.u_outware_pricedate[uc_row]= pricedate
- dw_pageretr.object.u_outware_priceemp[uc_row]=priceemp
- dw_pageretr.resetupdate()
- dw_pageretr.setredraw(true)
- dw_uc.Reset()
- dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)
- dw_uc.ResetUpdate()
- dw_uc.SetRedraw(TRUE)
- wf_flagstatus_rf()
- return 1
- end function
- public function integer wf_check_ifmtrlware (ref string arg_msg);//
- Long i,rowcnt,rslt = 1
- Long ls_mtrlwareid,ls_mtrlid,ls_storageid,ls_dxflag,ll_cusid,ls_sptid
- String ls_mtrlcode
- String ls_plancode
- String ls_status,ls_woodcode,ls_pcode
- Decimal ls_qty,ld_cost
- rowcnt = dw_child.RowCount( )
- ls_storageid = dw_pageretr.Object.u_outware_storageid[dw_pageretr.GetRow()]
- IF ls_storageid = 0 THEN
- arg_msg = '请选择仓库'
- rslt = 0
- GOTO ext
- END IF
- Int li_if_cus_mtrlware
- SELECT balctype INTO :li_if_cus_mtrlware
- FROM u_storage
- Where storageid = :ls_storageid;
- IF sqlca.SQLCode <> 0 THEN
- arg_msg = '查询仓库是否使用客户库存失败'
- rslt = 0
- goto ext
- END IF
- IF li_if_cus_mtrlware = 1 THEN
- ll_cusid = dw_pageretr.Object.u_outware_cusid[dw_pageretr.GetRow()]
- IF ll_cusid = 0 THEN
- arg_msg = '请选择客户'
- rslt = 0
- GOTO ext
- END IF
-
- ls_sptid = ll_cusid
- ELSE
- ls_sptid = 0
- END IF
- FOR i = 1 TO rowcnt
-
- ls_mtrlwareid = dw_child.Object.u_outwaremx_mtrlwareid[i]
- ls_mtrlid = dw_child.Object.u_outwaremx_mtrlid[i]
- ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[i]
-
- ls_plancode = dw_child.Object.u_outwaremx_plancode[i]
- ls_dxflag = dw_child.Object.u_outwaremx_dxflag[i]
-
- ls_status = dw_child.Object.u_outwaremx_status[i]
- ls_woodcode = dw_child.Object.u_outwaremx_woodcode[i]
- ls_pcode = dw_child.Object.u_outwaremx_pcode[i]
-
- ls_qty = dw_child.Object.u_outwaremx_qty[i]
- ld_cost=dw_child.Object.u_outwaremx_cost[i]
-
- IF ls_mtrlid = 0 OR ls_qty = 0 THEN CONTINUE
-
-
- IF f_insert_0_mtrlware(ls_mtrlwareid,ls_mtrlid,ls_mtrlcode,ls_storageid,ls_sptid,ls_status,ls_woodcode,ls_pcode,ls_plancode,ld_cost,arg_msg) = 0 THEN
- rslt = 0
- GOTO ext
- ELSE
- dw_child.Object.u_outwaremx_mtrlwareid[i] = ls_mtrlwareid
- END IF
-
- NEXT
- dw_child.AcceptText( )
- ext:
- RETURN rslt
- end function
- public function integer wf_copy (ref string arg_msg);long rslt=1
- long ll_rowcount
- ll_rowcount=dw_child.rowcount()
- if ll_rowcount<=0 then
- rslt=0
- arg_msg='没有可复制的明细内容'
- goto ext
- end if
- //ds_copy.reset()
- //if dw_child.RowsCopy(1, ll_rowcount, Primary!, ds_copy, 1, Primary!)= - 1 then
- // rslt=0
- // arg_msg='复制明细内容失败!'
- // goto ext
- //end if
- //copy_storageid=dw_uc.object.u_outware_storageid[dw_uc.getrow()]
- //ds_copy.accepttext()
- ext:
- return rslt
- end function
- public function integer wf_paste (ref string arg_msg);long rslt=1
- if not dw_edit_mode then
- rslt=0
- arg_msg='非编辑状态下不可粘贴'
- goto ext
- end if
- long ll_rowcount
- //ll_rowcount=ds_copy.rowcount()
- if ll_rowcount<=0 then
- rslt=0
- arg_msg='没有可粘贴的明细内容'
- goto ext
- end if
- dw_child.reset()
- long ll_child_rowcount
- ll_child_rowcount = dw_child.rowcount()
- //if ds_copy.RowsCopy(1, ll_rowcount, Primary!, dw_child, 1, Primary!)= - 1 then
- // rslt=0
- // arg_msg='粘贴明细内容失败!'
- // goto ext
- //end if
- //dw_child.accepttext()
- //dw_uc.accepttext()
- //dw_uc.object.u_outware_storageid[dw_uc.getrow()]=copy_storageid
- ext:
- return rslt
- end function
- public function integer wf_check_ifcuststorage (long arg_storageid, ref long arg_cusid, ref string arg_msg);Int li_if_cus_mtrlware,rslt = 1
- Long ll_cusid
- SELECT balctype INTO :li_if_cus_mtrlware
- FROM u_storage
- Where storageid = :arg_storageid;
- IF sqlca.SQLCode <> 0 THEN
- arg_msg = '查询仓库是否使用客户库存失败'
- rslt = 0
- GOTO ext
- END IF
- IF li_if_cus_mtrlware = 1 THEN
- ll_cusid = dw_pageretr.Object.u_outware_cusid[dw_pageretr.GetRow()]
- IF ll_cusid = 0 THEN
- arg_msg = '请选择客户'
- rslt = 0
- GOTO ext
- END IF
- arg_cusid = ll_cusid
- ELSE
- arg_cusid = 0
- END IF
- ext:
- RETURN rslt
- end function
- public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg);//==============================================================================
- // 函数: w_publ_1ton_share_detail::wf_xls_retrievedata()
- //------------------------------------------------------------------------------
- // 描述: 此函数需要 重载,复制祖先范例代码,然后修改retrieve参数部分两处即可
- //------------------------------------------------------------------------------
- Long LS_ROW,ll_id,i,ll_scid
- LS_ROW = dw_uc.GetRow()
- IF LS_ROW <= 0 THEN
- arg_msg = '没有目标单据!'
- RETURN 0
- END IF
- //修改点:获取 指定retriev参数
- ll_id = dw_pageretr.Object.#1[LS_ROW]
- ll_scid = dw_pageretr.Object.u_outware_scid[LS_ROW]
- //查询所选模版是否含有图片信息
- Long ll_ifpic
- Long ll_classid
- SELECT ifpic
- INTO :ll_ifpic
- FROM U_XLS_Templates
- Where id = :ll_xls_Templatesid;
- IF sqlca.SQLCode <> 0 THEN
- ll_ifpic = 0
- END IF
- Long ll_i,ll_j
- Long ll_mtrlid
- Long ll_fileid
- Blob ls_filedata
- SetNull(ls_filedata)
- String Pathname,ls_filename,ls_filetype
- String errmsg
- uo_fj_mng_billtype ls_uo_fjbt
- ls_uo_fjbt = CREATE uo_fj_mng_billtype
- s_xls_pic_list s_pic //结构数组-用于保存图片路径
- IF ll_ifpic = 1 THEN //如果含有图片信息,则查询本类型单据需要带出哪类附件
- SELECT classid
- INTO :ll_classid
- FROM u_billpic_fileclass
- Where (billtype = 341);
- IF sqlca.SQLCode <> 0 THEN
- ll_classid = 0
- END IF
-
- IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
- FOR ll_i = 1 TO dw_child.RowCount()
- ll_mtrlid = dw_child.Object.u_outwaremx_mtrlid[ll_i]
- //取该附件类型中的第一个附件.
- SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
- FROM u_file
- WHERE relid = :ll_mtrlid
- AND classid = :ll_classid
- AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
- OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
- USING sys_fileDB_sqlca;
- IF sys_fileDB_sqlca.SQLCode <> 0 THEN
- ll_fileid = 0
- END IF
- IF ll_fileid > 0 THEN
- Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
- IF Trim(Pathname) <> '' THEN
- IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
- RETURN 0
- END IF
-
- IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
- RETURN 0
- ELSE
-
- s_pic.path[ll_i] = Pathname
- //记录临时文件位置,本窗口退出后删除
- wf_addlog_tempfilepathname(Pathname)
-
- END IF
- ELSE
- s_pic.path[ll_i] = ''
- END IF
- ELSE
- s_pic.path[ll_i] = ''
- END IF
- NEXT
- END IF
- //
- END IF
- ////可选设置///
- arg_obj_st.uo_const.create_new_pwd( ) //创建随机密码
- if sys_option_xls_ifuse_passwd = 1 then arg_obj_st.uo_const.pwd = trim(sys_option_xls_user_passwd) //默认加密密码 默认为随即密码
- boolean xls_locked
- xls_locked = not (sys_option_xls_lock = 1)
- /// Excel 的可选设置
- if arg_obj_st.of_setoption(arg_ationid, xls_locked,true,arg_msg) <> 1 then
- return 0
- end if
- for i = 1 to arg_str_billlist.count
- ////可选操作///
- arg_str_billlist.bill[i].ds_data = create datastore //
- arg_str_billlist.bill[i].ds_data.dataobject = arg_str_billlist.bill[i].datawindow //
- arg_str_billlist.bill[i].ds_data.settransobject(sqlca)
-
- //修改点:注意retrieve 参数与上文对应
- arg_str_billlist.bill[i].ds_data.retrieve(ll_scid,ll_id)
- next
- return 1
- end function
- public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg);Long LS_ROW,ll_id,i,ll_scid
- LS_ROW = dw_pageretr.GetRow()
- IF LS_ROW <= 0 THEN
- arg_msg = '没有目标单据!'
- RETURN 0
- END IF
- //修改点:获取 指定retriev参数
- ll_id = dw_pageretr.Object.#1[LS_ROW]
- ll_scid = dw_pageretr.Object.U_outware_scid[LS_ROW]
- Long ll_i,ll_j
- Long ll_mtrlid
- Long ll_fileid
- Blob ls_filedata
- SetNull(ls_filedata)
- String Pathname,ls_filename,ls_filetype
- String errmsg
- uo_fj_mng_billtype ls_uo_fjbt
- ls_uo_fjbt = CREATE uo_fj_mng_billtype
- Long ll_classid
- SELECT classid
- INTO :ll_classid
- FROM u_billpic_fileclass
- Where (billtype = 102);
- IF sqlca.SQLCode <> 0 THEN
- ll_classid = 0
- END IF
- IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息.
- FOR ll_i = 1 TO dw_child.RowCount()
- ll_mtrlid = dw_child.Object.u_outwaremx_mtrlid[ll_i]
- arg_s_pic.mtrlid[ll_i] = ll_mtrlid
- //取该附件类型中的第一个附件.
- SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype
- FROM u_file
- WHERE relid = :ll_mtrlid
- AND classid = :ll_classid
- AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf'
- OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg')
- USING sys_fileDB_sqlca;
- IF sys_fileDB_sqlca.SQLCode <> 0 THEN
- ll_fileid = 0
- END IF
- IF ll_fileid > 0 THEN
- Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype
- IF Trim(Pathname) <> '' THEN
- IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN
- RETURN 0
- END IF
-
- IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN
- RETURN 0
- ELSE
-
- arg_s_pic.path[ll_i] = Pathname
- //记录临时文件位置,本窗口退出后删除
- wf_addlog_tempfilepathname(Pathname)
- END IF
- ELSE
- arg_s_pic.path[ll_i] = ''
- END IF
- ELSE
- arg_s_pic.path[ll_i] = ''
- END IF
- NEXT
- END IF
- RETURN 1
- end function
- on w_outware_sale_wareaudit_th.create
- int iCurrent
- call super::create
- this.ddlb_scid=create ddlb_scid
- this.ddlb_status=create ddlb_status
- this.st_3=create st_3
- this.st_2=create st_2
- this.st_msg=create st_msg
- this.cbx_his=create cbx_his
- iCurrent=UpperBound(this.Control)
- this.Control[iCurrent+1]=this.ddlb_scid
- this.Control[iCurrent+2]=this.ddlb_status
- this.Control[iCurrent+3]=this.st_3
- this.Control[iCurrent+4]=this.st_2
- this.Control[iCurrent+5]=this.st_msg
- this.Control[iCurrent+6]=this.cbx_his
- end on
- on w_outware_sale_wareaudit_th.destroy
- call super::destroy
- destroy(this.ddlb_scid)
- destroy(this.ddlb_status)
- destroy(this.st_3)
- destroy(this.st_2)
- destroy(this.st_msg)
- destroy(this.cbx_his)
- end on
- event retrieve_pageretr;Boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled
- Boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled
-
- cb_nextpage_enabled = cb_nextpage.Enabled
- cb_retrieveall_enabled = cb_retrieveall.Enabled
- cb_func_enabled = cb_func.Enabled
-
- cb_nextpage.Enabled = FALSE
- cb_retrieveall.Enabled = FALSE
- cb_func.Enabled = FALSE
- //只显未自已管的仓库
- datawindowchild childdw
- String new_sqlstr,modify_str
- dw_uc.SetTransObject (sqlca)
- dw_uc.GetChild("u_outware_storageid",childdw)
- childdw.SetTransObject (sqlca)
- new_sqlstr = childdw.Describe("DataWindow.Table.Select")
- IF Len(ol_cdw_str) = 0 THEN ol_cdw_str = new_sqlstr
- new_sqlstr = f_modify_selectstr(ol_cdw_str)
- modify_str = "DataWindow.Table.Select='" + new_sqlstr +"'"
- childdw.Modify ( modify_str )
- if childdw.Retrieve(cur_scid) = 0 then
- childdw.InsertRow(0)
- END IF
- //childdw.retrieve()
- dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数
- dw_pageretr.Retrieve(cur_scid_arr,sys_user_storageid,sys_showsaledata_mindt,cur_flag,cur_secflag,sys_areaid)
- IF dw_pageretr.RowCount() > 0 THEN
- dw_pageretr.SetRow(1)
- dw_pageretr.triggerevent(rowfocuschanged!)
- end if
- THIS.TriggerEvent('retrieve_childdw')
-
- cb_nextpage.Enabled = cb_nextpage_enabled
- cb_retrieveall.Enabled = cb_retrieveall_enabled
- cb_func.Enabled = cb_func_enabled
- end event
- event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr=''
- if trim(sle_usual_query.text)<>'' then
- IF POS(trim(sle_usual_query.text),'%')=0 THEN
- obj_expr=obj_expr+'( inwarecode LIKE "%'+trim(sle_usual_query.text)+'%" )'
- ELSE
- obj_expr=obj_expr+'( inwarecode LIKE "'+trim(sle_usual_query.text)+'" )'
- END IF
- end if
- dw_pageretr.setfilter(obj_expr)
- dw_pageretr.SetRedraw(False)
- dw_pageretr.filter()
- if dw_pageretr.rowcount()>=1 then
- dw_pageretr.selectrow(0,false)
- dw_pageretr.selectrow(1,true)
- end if
- dw_pageretr.SetRedraw(TRUE)
- end event
- event ue_usual_query_retr;call super::ue_usual_query_retr;string ls_querystrpart=''
- ls_newselect=lower(ori_oldselect)
- if trim(sle_usual_query.text)<>'' then
- if pos(trim(sle_usual_query.text),'%')=0 then
- ls_querystrpart="(u_outware.outwarecode like '%"+trim(sle_usual_query.text)+"%')"
- else
- ls_querystrpart="(u_outware.outwarecode like '"+trim(sle_usual_query.text)+"')"
- end if
- if Pos(ls_newselect," where ") <> 0 then
- ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')'
- else
- ls_newselect=ls_newselect+" where ("+ls_querystrpart+')'
- end if
- end if
- wf_retrieveuc(dw_pageretr,ls_newselect,1)
- this.triggerevent('retrieve_pageretr')
- end event
- event open;THIS.TriggerEvent('ue_before_open')
- wf_movetocenter()
- OLD_TITLE = THIS.Title
- s_tran = Message.PowerObjectParm
- IF NOT IsNull(s_tran) THEN
- retrieve_all = s_tran.if_retrieve_all
- mode = s_tran.work_mode
- arg_pkid = s_tran.arg_pkid
- arg_string_code = s_tran.arg_string_code
- if_sharedata = s_tran.if_sharedata //是否应用sharedata,当retrieve_all=true是生效
- ds_share = s_tran.ds_share
- END IF
- dw_pageretr.RBUTTON_FILTER_USE = TRUE //右键查询功能开关
- dw_pageretr.titleclick_sort_use = TRUE //单击标题排序功能开关
- dw_pageretr.SetTransObject (sqlca)
- pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字
- ori_oldselect = dw_pageretr.Describe("DataWindow.Table.Select")
- //====================================================================
- // Script - w_outware_sale inherited from w_publ_1ton_share_detail for open
- // Reason:
- //--------------------------------------------------------------------
- // Modified By: yyx Date: 2003.12.01
- //--------------------------------------------------------------------
- ori_oldselect = f_modify_selectstr(ori_oldselect)//只显示所管的仓库单据
- //====================================================================
- ls_newselect = ori_oldselect
- ds_curquery = CREATE DATASTORE
- ds_curquery.DataObject = 'd_extr_find'
- ds_curquery.SetTransObject (sqlca)
- wf_editindex_lockf()
- IF s_tran.d_long = 2 THEN
- cur_scid = s_tran.c_long
- Int li_item
- li_item = ddlb_scid.FindItem(s_tran.d_string,0)
- IF li_item > 0 THEN
- ddlb_scid.SelectItem(li_item)
- END IF
- END IF
- sle_usual_query.Text = Trim(arg_string_code)
- IF NOT retrieve_all THEN
- THIS.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve
- ELSE
- IF if_sharedata THEN
- ds_share.ShareData(dw_pageretr)
- ELSE
- wf_retrieveuc(dw_pageretr,ls_newselect,1)
- THIS.TriggerEvent('RETRIEVE_pageretr')
- END IF
- END IF
- IF retrieve_all THEN
- THIS.TriggerEvent("ue_usual_query_filt")
- END IF
- uc_column_int = 13 //uc dw前7列可以编辑
- child_column_int = 13 //子dw前8列可以编辑
- uo_ware = CREATE uo_outware_sale
- uo_ware.commit_transaction = sqlca
- s_hide_col s_col
- s_col.col_1 = 'u_outwaremx_enprice'
- s_col.col_2 = 'u_outwaremx_rebate'
- s_col.col_3 = 'u_outwaremx_price'
- s_col.col_4 = 'u_outwaremx_fprice'
- s_col.col_5 = 'enamt'
- s_col.col_6 = 'amt'
- f_hide_col(122,dw_child,s_col)
- s_hide_col s_col_cost
- s_col_cost.col_1 = 'u_outwaremx_cost'
- f_hide_col(490,dw_child,s_col_cost)
- s_hide_col s_col_mtrlsectype
- s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype'
- f_hide_col(1308,dw_child,s_col_mtrlsectype)
- s_hide_col s_col_zxmtrlmode
- s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode'
- f_hide_col(1309,dw_child,s_col_zxmtrlmode)
- end event
- event refresh_interface;call super::refresh_interface;wf_flagstatus_rf()
- st_msg.Visible = dw_edit_mode
- ddlb_status.Enabled = NOT dw_edit_mode
- //编缉状态明细不选择
- IF dw_edit_mode THEN
- dw_child.SelectRow(0,FALSE)
- END IF
- IF NOT dw_edit_mode THEN cur_editfocus = 0
- IF dw_edit_mode THEN
- IF flag = 1 AND secflag = 0 THEN
- dw_uc.Modify('u_outware_storageid.protect=1')
- dw_child.Modify('u_mtrldef_mtrlcode.protect=1 ~n u_outwaremx_qty.protect=1')
- cb_xm.Enabled = FALSE
- ELSE
- dw_child.Modify('u_mtrldef_mtrlcode.protect=0 ~n u_outwaremx_qty.protect=0')
- cb_xm.Enabled = TRUE
- END IF
- ELSE
- dw_child.Modify('u_mtrldef_mtrlcode.protect=0 ~n u_outwaremx_qty.protect=0')
- END IF
- IF NOT dw_edit_mode THEN
- st_msg.Text = ''
- END IF
- IF dw_edit_mode THEN
- ddlb_scid.Enabled = FALSE
- ELSE
- IF sys_scid > 0 THEN
- ddlb_scid.Enabled = FALSE
- ELSE
- ddlb_scid.Enabled = TRUE
- END IF
- END IF
- end event
- event close;call super::close;destroy uo_ware
- wf_del_tempfilepathname()
- end event
- event ue_f8;call super::ue_f8;////用于选择明细内容,被F8[默认]\dw_child.doubleclicked调用
- //IF NOT dw_edit_mode THEN RETURN
- //
- //IF flag = 1 THEN RETURN
- //
- //Long child_row,ins_storageid = 0,cnt_childdw
- //Long ll_moneyid
- //String errmsg
- //
- //ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
- // MessageBox('提示','请先选择币种',information!,OK!)
- // RETURN
- //END IF
- //
- //ins_storageid = dw_uc.Object.u_outware_storageid[dw_uc.GetRow()]
- //IF ins_storageid = 0 OR IsNull(ins_storageid) THEN
- // MessageBox('提示','请先选择仓库',information!,OK!)
- // RETURN
- //END IF
- //
- //Long ls_null
- //s_edit_index_tran s_tranf8 //传递参数使用
- //s_tranf8.if_retrieve_all = FALSE //是否一次RETRIEVE所有行
- //s_tranf8.arg_pkid = 0 //目标定位PKID (备用)
- //s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
- //s_tranf8.b_long = cur_scid
- //
- //Long chc = 1,ls_j,ls_custid
- //SetNull(ls_null)
- //
- //ls_custid = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
- //IF IsNull(ls_custid) OR ls_custid = 0 THEN
- // THIS.TriggerEvent("ue_f9")
- //END IF
- //ls_custid = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
- //child_row = dw_child.GetRow()
- //cnt_childdw = dw_child.RowCount()
- //
- //IF cbx_his.Checked THEN //退货
- // IF dw_uc.Object.u_outware_cusid[dw_uc.GetRow()] = 0 THEN
- // THIS.TriggerEvent("ue_f9")
- // END IF
- // s_tranf8.d_long = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
- // s_tranf8.c_long = ins_storageid
- //
- // IF NOT IsValid(w_outware_tsale_ch) THEN
- // OpenWithParm(w_outware_tsale_ch,s_tranf8) //调用
- //
- // s_outware_tsale_array S_INSCUST2
- // S_INSCUST2 = Message.PowerObjectParm //接受返回结构
- //
- // FOR ls_j = 1 TO UpperBound(S_INSCUST2.mtrlwareid)
- // IF S_INSCUST2.outwareid[ls_j] > 0 THEN
- // IF dw_child.GetRow() > 0 THEN
- // IF dw_child.Object.u_outwaremx_mtrlid[child_row] <> 0 THEN
- // child_row = dw_child.InsertRow (0)
- // ELSE
- // child_row = dw_child.GetRow()
- // END IF
- // ELSE
- // child_row = dw_child.InsertRow (0)
- // END IF
- // dw_child.Object.u_mtrldef_tflag[child_row] = 1
- // dw_child.Object.u_outwaremx_mtrlwareid[child_row] = S_INSCUST2.mtrlwareid[ls_j]
- // dw_child.Object.u_outwaremx_mtrlid[child_row] = S_INSCUST2.mtrlid[ls_j]
- // dw_child.Object.u_mtrldef_mtrlcode[child_row] = S_INSCUST2.mtrlcode[ls_j]
- // dw_child.Object.u_mtrldef_mtrlname[child_row] = S_INSCUST2.mtrlname[ls_j]
- // dw_child.Object.u_mtrldef_mtrlmode[child_row] = S_INSCUST2.mtrlmode[ls_j]
- // dw_child.Object.u_mtrldef_unit[child_row] = S_INSCUST2.unit[ls_j]
- // dw_child.Object.u_outwaremx_qty[child_row] = - S_INSCUST2.qty[ls_j]
- // dw_child.Object.u_outwaremx_addqty[child_row] = - S_INSCUST2.addqty[ls_j]
- // dw_child.Object.u_outwaremx_enprice[child_row] = S_INSCUST2.enprice[ls_j]
- // dw_child.Object.u_outwaremx_rebate[child_row] = S_INSCUST2.rebate[ls_j]
- // dw_child.Object.u_outwaremx_planprice[child_row] = S_INSCUST2.planprice[ls_j]
- // dw_child.Object.u_outwaremx_dxflag[child_row] = S_INSCUST2.dxflag[ls_j]
- // dw_child.Object.u_outwaremx_storageid[child_row] = S_INSCUST2.storageid[ls_j]
- // dw_child.Object.u_outwaremx_mxdscrp[child_row] = '退:'+S_INSCUST2.outwarecode[ls_j]
- // dw_child.Object.u_outwaremx_status[child_row] = S_INSCUST2.status[ls_j]
- // dw_child.Object.u_outwaremx_woodcode[child_row] = S_INSCUST2.woodcode[ls_j]
- // dw_child.Object.u_outwaremx_pcode[child_row] = S_INSCUST2.pcode[ls_j]
- // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = S_INSCUST2.zxmtrlmode[ls_j]
- // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = S_INSCUST2.mtrlsectype[ls_j]
- // dw_child.Object.u_outwaremx_relcode[child_row] = S_INSCUST2.outwarecode[ls_j]
- // dw_child.SetColumn('u_outwaremx_qty')
- // END IF
- // NEXT
- // END IF
- //
- //
- //ELSE
- //
- // IF NOT IsValid(W_mtrldef_edit) THEN
- // s_edit_index_tran s_ch_tran //传递参数使用
- // s_ch_tran.if_retrieve_all = FALSE //是否一次RETRIEVE所有行
- // s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
- // s_ch_tran.arg_pkid = 0 //目标定位PKID (备用)
- // s_ch_tran.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
- // s_ch_tran.if_select_all = TRUE
- // s_ch_tran.b_long = -1
- // s_ch_tran.c_long = ins_storageid
- //
- // dw_child.AcceptText()
- // IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()])
- // OpenWithParm(W_mtrldef_edit,s_ch_tran)
- //
- // s_mtrldef_array S_INSCUST
- // S_INSCUST = Message.PowerObjectParm
- // IF wf_check_ifcuststorage(ins_storageid,ls_custid,errmsg) = 0 THEN
- // MessageBox('错误',errmsg,stopsign!,OK!)
- // RETURN
- // END IF
- // FOR ls_j = 1 TO UpperBound(S_INSCUST.mtrlid)
- // IF S_INSCUST.mtrlid[ls_j] > 0 THEN
- // IF dw_child.GetRow() > 0 THEN
- // IF dw_child.Object.u_outwaremx_mtrlid[child_row] <> 0 THEN
- // child_row = dw_child.InsertRow (0)
- // ELSE
- // child_row = dw_child.GetRow()
- // END IF
- // ELSE
- // child_row = dw_child.InsertRow (0)
- // END IF
- //
- //
- // s_mtrlware_noalloc_array s_ware
- //
- // if f_find_mtrlware( S_INSCUST.mtrlcode[ls_j],ins_storageid,ls_custid,s_ware)<>0 then
- // dw_child.Object.u_outwaremx_mtrlwareid[child_row] = s_ware.mtrlwareid[1]
- // dw_child.Object.u_outwaremx_cost[child_row] = s_ware.cost[1]
- // else
- // dw_child.Object.u_outwaremx_mtrlwareid[child_row] = 0
- // dw_child.Object.u_outwaremx_cost[child_row] = 0
- // end if
- //
- // dw_child.Object.u_mtrldef_mtrlcode[child_row] = S_INSCUST.mtrlcode[ls_j]
- // dw_child.Object.u_mtrldef_unit[child_row] = S_INSCUST.unit[ls_j]
- // dw_child.Object.u_outwaremx_mtrlid[child_row] = S_INSCUST.mtrlid[ls_j]
- // dw_child.Object.u_outwaremx_fprice[child_row] = S_INSCUST.planprice[ls_j]
- // dw_child.Object.u_mtrldef_mtrlname[child_row] = S_INSCUST.mtrlname[ls_j]
- // dw_child.Object.u_mtrldef_mtrlmode[child_row] = S_INSCUST.mtrlmode[ls_j]
- // dw_child.Object.u_mtrldef_prdpackcode[child_row] = S_INSCUST.prdpackcode[ls_j]
- // dw_child.Object.u_mtrldef_packqty[child_row] = S_INSCUST.packqty[ls_j]
- // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = S_INSCUST.mtrlsectype[ls_j]
- // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = S_INSCUST.zxmtrlmode[ls_j]
- //
- //
- //
- // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate
- // String arg_msg,ls_woodcode,ls_status,ls_pcode,ls_unit
- // IF cur_editfocus = 1 THEN
- // ls_woodcode = dw_child.Object.u_outwaremx_woodcode[child_row]
- // ls_status = dw_child.Object.u_outwaremx_status[child_row]
- // ls_pcode = dw_child.Object.u_outwaremx_pcode[child_row]
- // ls_unit = dw_child.Object.u_mtrldef_unit[child_row]
- //
- // IF f_getmtrlcusprice(ll_moneyid,S_INSCUST.mtrlid[ls_j],ls_custid,ls_unit,ls_woodcode,ls_status,ls_pcode,0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
- // dw_child.Object.u_outwaremx_enprice[child_row] = S_INSCUST.planprice[ls_j]
- // dw_child.Object.u_outwaremx_rebate[child_row] = 1
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[child_row] = ls_1stnewprice
- // dw_child.Object.u_outwaremx_rebate[child_row] = ls_1stzqrate
- // END IF
- // END IF
- // dw_child.SetColumn('u_outwaremx_qty')
- // END IF
- //
- // NEXT
- //
- // END IF
- //
- //
- //END IF
- //
- //dw_child.SetRedraw(TRUE)
- //dw_child.SetFocus()
- //
- //////////////////////////////////////
- //
- //
- //
- //
- //
- //
- //
- //
- //
- //
- end event
- event retrieve_childdw;call super::retrieve_childdw;long row,uc_relid,ll_scid
- row=dw_pageretr.getrow()
- if row>0 then
- ll_scid=dw_pageretr.object.u_outware_scid[row]
- uc_relid=dw_pageretr.object.u_outware_outwareid[row]
- dw_child.SetRedraw (false)
- dw_child.retrieve(ll_scid,uc_relid)
- dw_child.SetRedraw (true)
- else
- dw_child.reset()
- end if
- end event
- event ue_viewprint;call super::ue_viewprint;IF Not (f_power_ind(564) OR f_power_ind(568)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- s_print_msg ls_prmsg
- ls_prmsg.retr_pram_falg = 15
- IF dw_pageretr.RowCount() = 0 THEN
- MessageBox('提示','没有可打印的单据!',information!,OK!)
- RETURN
- END IF
- IF sys_option_auditprint_sale_th = 1 THEN
- IF dw_pageretr.Object.flag[dw_pageretr.GetRow()] <> 1 THEN
- MessageBox('提示','单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
- IF ls_newname <> '' THEN
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.flag[dw_pageretr.GetRow()] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
-
- ls_prmsg.obj_dwNAME = ls_newname
- ELSE
- ls_prmsg.obj_dwNAME = 'dw_rp_outware_sale_audit_edit_th'
- END IF
- ls_prmsg.tag_text = '销售退货单'
- ls_prmsg.filter_string = ''
- ls_prmsg.pagech_flag = 0
- ls_prmsg.retr_scid = dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()]
- ls_prmsg.retr_pramnmb = dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()]
- ls_prmsg.rowcnt = dw_child.RowCount()
- IF ifpic = 1 THEN
- String ls_msg
- IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
- MessageBox('提示','下载图片失败!',information!,OK!)
- RETURN
- END IF
- END IF
- OpenWithParm(w_publ_preview,ls_prmsg)
- IF ifpic = 1 THEN
- Long li
- FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path)
- IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN
- FileDelete(LS_PRMSG.s_pic.path[li])
- END IF
- NEXT
- END IF
- //**更新打印次料
- String arg_msg
- printnum = Message.DoubleParm
- f_update_printnum('u_outware',printnum,dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event resize;call super::resize;st_msg.width = this.width - (3600 - 1166)
- end event
- event ue_print;call super::ue_print;//--直接打印
- IF Not (f_power_ind(564) OR f_power_ind(568)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- uo_print_preview uo_print
- S_print_MSG LS_PRMSG
- IF dw_pageretr.RowCount() = 0 THEN
- MessageBox('提示','没有可打印的单据!',information!,OK!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
- IF sys_option_auditprint_sale_th = 1 THEN
- IF dw_pageretr.Object.flag[dw_pageretr.GetRow()] <> 1 THEN
- MessageBox('提示','单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
- LS_PRMSG.retr_pram_falg = 15
- IF ls_newname <> '' THEN
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.flag[dw_pageretr.GetRow()] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
-
- LS_PRMSG.obj_dwNAME = ls_newname
- ELSE
- LS_PRMSG.obj_dwNAME = 'dw_rp_outware_sale_audit_edit_th'
- END IF
- LS_PRMSG.TAG_TEXT = '销售退货单'
- LS_PRMSG.FILTER_STRING = ''
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.retr_scid = dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()]
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()]
- LS_PRMSG.rowcnt = dw_child.RowCount()
- IF ifpic = 1 THEN
- String ls_msg
- IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN
- MessageBox('提示','下载图片失败!',information!,OK!)
- RETURN
- END IF
- END IF
- uo_print.FACT_PRINT_MSG = LS_PRMSG
- String arg_msg
- IF uo_print.uof_print_begin(arg_msg) = 0 THEN
- MessageBox("错误",arg_msg,stopsign!,OK!)
- RETURN
- END IF
- uo_print.ds_print()
- IF ifpic = 1 THEN
- Long li
- FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path)
- IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN
- FileDelete(LS_PRMSG.s_pic.path[li])
- END IF
- NEXT
- END IF
- //**更新打印次料
- printnum = Message.DoubleParm
- f_update_printnum('u_outware',printnum,dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event ue_addzy;call super::ue_addzy;IF NOT (f_power_ind(700) or f_power_ind(767)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- String ls_str
- Long uc_row
- s_inputbox s_sreu
- uc_row = dw_pageretr.GetRow()
- IF uc_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- s_sreu.Title = '请输入要补充到备注的内容'
- s_sreu.old_text = ''
- OpenWithParm(w_inputbox,s_sreu)
- ls_str = Message.StringParm
- IF Trim(ls_str) = '' OR IsNull(ls_str) THEN RETURN
- IF uo_ware.add_dscrp(dw_pageretr.Object.u_outware_scid[uc_row],dw_pageretr.Object.u_outware_outwareid[uc_row],ls_str,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- ELSE
- MessageBox('提示','添加备注操作成功!',information!,OK!)
- wf_refresh_curuc(dw_pageretr.Object.u_outware_scid[uc_row],dw_pageretr.Object.u_outware_outwareid[uc_row])
- END IF
- end event
- event ue_rpt_print;call super::ue_rpt_print;//--直接打印
- IF Not (f_power_ind(564) OR f_power_ind(568)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- Long row,uc_relid,ll_scid
- row = dw_pageretr.GetRow()
- IF row = 0 THEN RETURN
- uo_rpt_print_preview uo_print
- S_rpt_print_MSG LS_PRMSG
- IF dw_pageretr.RowCount() = 0 THEN
- MessageBox('提示','没有可打印的单据!',information!,OK!)
- RETURN
- END IF
- IF ls_rpname = '' THEN RETURN
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.flag[row] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
- IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
- LS_PRMSG.retr_pram_falg = 15
- LS_PRMSG.TAG_TEXT = THIS.Title
- LS_PRMSG.rpname = ls_rpname
- LS_PRMSG.FILTER_STRING = ''
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.rpid = ls_msgprintid_rpt
- LS_PRMSG.retr_scid = dw_pageretr.Object.u_outware_scid[row]
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_outware_outwareid[row]
- LS_PRMSG.rowcnt = dw_child.RowCount()
- uo_print.FACT_PRINT_MSG = LS_PRMSG
- String arg_msg
- IF uo_print.uof_print_begin(arg_msg) = 0 THEN
- MessageBox("错误",arg_msg,stopsign!,OK!)
- RETURN
- END IF
- uo_print.ds_print()
- //**更新打印次料
- printnum = Message.DoubleParm
- f_update_printnum('u_outware',printnum,dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event ue_rpt_viewprint;call super::ue_rpt_viewprint;
- IF Not (f_power_ind(564) OR f_power_ind(568)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- Long row,uc_relid,ll_scid
- row = dw_pageretr.GetRow()
- IF row = 0 THEN RETURN
- IF ls_rpname = '' THEN RETURN
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.flag[row] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,OK!)
- RETURN
- END IF
- END IF
- s_rpt_print_msg s_print
- s_print.retr_pram_falg = 15
- s_print.rpid = ls_msgprintid_rpt
- s_print.retr_flag = TRUE
- s_print.tag_text = THIS.Title
- s_print.rpname = ls_rpname
- s_print.retr_scid = dw_pageretr.Object.u_outware_scid[row]
- s_print.retr_pramnmb = dw_pageretr.Object.u_outware_outwareid[row]
- s_print.rowcnt = dw_child.RowCount()
- OpenWithParm(w_rpt_preview,s_print)
- //**更新打印次料
- String arg_msg
- printnum = Message.DoubleParm
- f_update_printnum('u_outware',printnum,dw_pageretr.Object.u_outware_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_outware_outwareid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- type cb_func from w_publ_1ton_share_detail`cb_func within w_outware_sale_wareaudit_th
- end type
- type cb_exit from w_publ_1ton_share_detail`cb_exit within w_outware_sale_wareaudit_th
- integer x = 1733
- end type
- type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_outware_sale_wareaudit_th
- integer x = 178
- integer y = 188
- integer width = 549
- end type
- type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_outware_sale_wareaudit_th
- integer x = 2171
- end type
- type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_outware_sale_wareaudit_th
- integer x = 1883
- integer y = 40
- integer width = 293
- end type
- type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_outware_sale_wareaudit_th
- integer x = 2373
- integer width = 1166
- integer height = 844
- string dataobject = "dw_outware_sale_wareaudit_index_th"
- end type
- event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_flagstatus_rf()
- if dw_edit_mode then return
- if currentrow <=0 then
- dw_child.reset()
- return
- end if
- this.selectrow(0,false)
- this.selectrow(currentrow,true)
- dw_uc.setrow(currentrow)
- dw_uc.scrolltorow (currentrow)
- if not dw_edit_mode then parent.triggerevent('retrieve_childdw')
- end event
- type st_1 from w_publ_1ton_share_detail`st_1 within w_outware_sale_wareaudit_th
- integer x = 5
- integer y = 208
- end type
- type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_outware_sale_wareaudit_th
- integer x = 2322
- end type
- type dw_uc from w_publ_1ton_share_detail`dw_uc within w_outware_sale_wareaudit_th
- integer width = 2368
- integer height = 852
- string dataobject = "dw_outware_sale_wareaudit_edit_th"
- end type
- event dw_uc::dwnkey;parent.triggerevent('user_key')
- if key = KeyDownArrow! then return 1
- end event
- event dw_uc::itemchanged;call super::itemchanged;IF NOT dw_edit_mode THEN RETURN
- IF dwo.Name = 'u_outware_storageid' THEN
- dw_child.Reset()
- PARENT.TriggerEvent("insert_childrow")
- ELSEIF dwo.Name = 'u_outware_relint_2' THEN
- Long ll_moneyid
- dw_uc.accepttext()
- ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.u_outware_mrate[dw_uc.GetRow()] = f_get_mrate(ll_moneyid)
- dw_uc.SetRedraw(TRUE)
- END IF
- end event
- event dw_uc::doubleclicked;IF dw_edit_mode and row >0 THEN
- parent.triggerevent('ue_f9')
- END IF
- end event
- event dw_uc::clicked;call super::clicked;if not dw_edit_mode then return
- if row <= 0 then return
- if dw_uc.object.u_outware_thflag[row]=1 then return
- if dwo.name='p_p' then
- parent.TRIGGEREVENT('ue_f9')
- end if
- end event
- type gb_2 from w_publ_1ton_share_detail`gb_2 within w_outware_sale_wareaudit_th
- end type
- type dw_child from w_publ_1ton_share_detail`dw_child within w_outware_sale_wareaudit_th
- integer y = 1136
- integer width = 3543
- integer height = 1092
- string dataobject = "dw_outwaremx_sale_wareaudit_edit_th"
- end type
- event dw_child::dwnkey;call super::dwnkey;//PARENT.TriggerEvent('user_key')
- //THIS.TriggerEvent('user_key')
- //IF NOT dw_edit_mode THEN RETURN
- //IF flag = 1 THEN RETURN
- //
- //String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrlsectype,ls_zxmtrlmode
- //String ls_plancode,ls_status,ls_woodcode,ls_pcode,errmsg
- //Long ls_mtrlwareid,ls_mtrlid,ls_storageid,ll_moneyid
- //Dec ls_noallocqty,ls_noauditingqty,ls_planprice,ls_cost,ls_lmsaleprice
- //s_mtrldef_array arg_s_mtrldef
- //
- //s_mtrlware_noalloc_array arg_s_mtrlware
- //
- //Long child_row
- //Long ls_null
- //String arg_msg
- //Long ls_custid
- //
- //SetNull(ls_null)
- //
- //IF dw_edit_mode THEN
- // dw_uc.AcceptText()
- //
- // ll_moneyid = dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]
- // IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN
- // MessageBox('提示','请先选择币种',information!,OK!)
- // RETURN
- // END IF
- //
- // ls_storageid = dw_uc.Object.u_outware_storageid[dw_uc.GetRow()]
- // IF ls_storageid = 0 OR IsNull(ls_storageid) THEN
- // MessageBox('提示','请先选择仓库',information!,OK!)
- // RETURN
- // END IF
- //
- // ls_custid = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
- // IF IsNull(ls_custid) OR ls_custid = 0 THEN
- // THIS.TriggerEvent("ue_f9")
- // ls_custid = dw_uc.Object.u_outware_cusid[dw_uc.GetRow()]
- // END IF
- //
- // IF KeyDown(Keydownarrow!) THEN
- // Long li_row
- // IF dw_child.GetRow() = dw_child.RowCount() THEN
- // PARENT.TriggerEvent("insert_childrow")
- // END IF
- // ELSE
- // If (KeyDown(KeyEnter!) OR KeyDown(KeyTab!)) AND NOT KeyDown(KeyControl!) AND NOT KeyDown(KeyShift!) THEN
- // IF dw_child.GetColumnName( ) = 'u_mtrldef_mtrlcode' THEN
- //
- // dw_child.AcceptText()
- // child_row = dw_child.GetRow()
- //
- // ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[child_row]
- //
- // IF f_find_mtrl(ls_mtrlcode,ls_storageid,arg_s_mtrldef) = 0 THEN
- // PARENT.TriggerEvent('ue_f8')
- // RETURN 1
- // ELSE
- // ls_mtrlid = arg_s_mtrldef.mtrlid[1]
- // ls_mtrlcode = arg_s_mtrldef.mtrlcode[1]
- // ls_mtrlname = arg_s_mtrldef.mtrlname[1]
- // ls_unit = arg_s_mtrldef.unit[1]
- // ls_mtrlmode = arg_s_mtrldef.mtrlmode[1]
- // ls_planprice = arg_s_mtrldef.planprice[1]
- // ls_mtrlsectype = arg_s_mtrldef.mtrlsectype[1]
- // ls_zxmtrlmode = arg_s_mtrldef.zxmtrlmode[1]
- // END IF
- //
- // IF wf_check_ifcuststorage(ls_storageid,ls_custid,errmsg) = 0 THEN
- // MessageBox('错误',errmsg,stopsign!,OK!)
- // RETURN
- // END IF
- //
- // s_mtrlware_noalloc_array s_Ware
- //
- // IF f_find_mtrlware(ls_mtrlcode,ls_storageid,ls_custid,s_Ware) <> 0 THEN
- // dw_child.Object.u_outwaremx_cost[child_row] = s_Ware.cost[1]
- // dw_child.Object.u_outwaremx_mtrlwareid[child_row] = s_ware.mtrlwareid[1]//ls_mtrlwareid
- // else
- // dw_child.Object.u_outwaremx_cost[child_row] =0
- // dw_child.Object.u_outwaremx_mtrlwareid[child_row] =0
- // END IF
- //
- //
- // dw_child.Object.u_outwaremx_mtrlid[child_row] = ls_mtrlid
- // dw_child.Object.u_mtrldef_mtrlname[child_row] = ls_mtrlname
- // dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode
- // dw_child.Object.u_mtrldef_unit[child_row] = ls_unit
- // dw_child.Object.u_outwaremx_qty[child_row] = 0
- // dw_child.Object.u_outwaremx_planprice[child_row] = ls_planprice
- // dw_child.Object.u_outwaremx_storageid[child_row] = ls_storageid
- // dw_child.Object.u_outwaremx_plancode[child_row] = ls_plancode
- // dw_child.Object.u_outwaremx_status[child_row] = ls_status
- // dw_child.Object.u_outwaremx_woodcode[child_row] = ls_woodcode
- // dw_child.Object.u_outwaremx_pcode[child_row] = ls_pcode
- // dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode
- // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = ls_zxmtrlmode
- // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = ls_mtrlsectype
- //
- //
- // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate
- // IF cur_editfocus = 1 THEN
- // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_custid,ls_unit,ls_woodcode,ls_status,ls_pcode,0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN
- // dw_child.Object.u_outwaremx_enprice[child_row] = ls_planprice
- // dw_child.Object.u_outwaremx_rebate[child_row] = 1
- // ELSE
- // dw_child.Object.u_outwaremx_enprice[child_row] = ls_1stnewprice
- // dw_child.Object.u_outwaremx_rebate[child_row] = ls_1stzqrate
- // END IF
- // END IF
- //
- //
- // dw_child.Object.u_mtrldef_curware_qty[child_row] = ls_noallocqty
- // dw_child.Object.u_mtrldef_sumneed_qty[child_row] = ls_null
- // dw_child.Object.u_mtrldef_sumware_qty[child_row] = ls_null
- //
- // IF Key = KeyEnter! THEN //
- // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
- // keybd_event ( 9, 0, 2, 0 ) // 释放tab
- // RETURN 1
- // END IF
- // ELSEIF dw_child.GetColumnName( ) = 'u_outwaremx_rebate' AND dw_child.GetRow() = dw_child.RowCount() THEN
- // Long i_mtrlid
- // String i_mtrlcode
- // Decimal i_price,i_zqrate
- // Int i_thflag = 0
- // dw_child.AcceptText()
- //
- // i_mtrlid = dw_child.Object.u_outwaremx_mtrlid[dw_child.GetRow()]
- // i_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()]
- // i_price = dw_child.Object.u_outwaremx_fprice[dw_child.GetRow()]
- // i_zqrate = dw_child.Object.u_outwaremx_rebate[dw_child.GetRow()]
- //
- //
- //
- // IF Key = KeyEnter! THEN //
- // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
- // keybd_event ( 9, 0, 2, 0 ) // 释放tab
- // RETURN 1
- // END IF
- // ELSEIF dw_child.GetColumnName( ) = 'u_outwaremx_mxdscrp' AND dw_child.GetRow() = dw_child.RowCount() THEN
- // PARENT.TriggerEvent("insert_childrow")
- // RETURN 1
- // ELSE
- // IF Key = KeyEnter! THEN //
- // keybd_event ( 9, 0, 0 , 0 ) // 按下tab
- // keybd_event ( 9, 0, 2, 0 ) // 释放tab
- // RETURN 1
- // END IF
- // END IF
- // END IF
- // END IF
- //END IF
- //
- //
- //
- end event
- type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_outware_sale_wareaudit_th
- integer x = 1088
- end type
- type cb_print from w_publ_1ton_share_detail`cb_print within w_outware_sale_wareaudit_th
- integer x = 896
- end type
- type cb_add from w_publ_1ton_share_detail`cb_add within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 1733
- end type
- event cb_add::clicked;//IF Not (f_power_ind(540) OR f_power_ind(566)) THEN
- // MessageBox(publ_operator,'你没有使用权限!')
- // RETURN
- //END IF
- //
- //String arg_msg = ''
- //Long uc_row,pagerert_row
- //Long relid_pageretr,reld_uc,j,i
- //Long ll_printid,ll_outwareid,ll_scid
- //Int li_flag,li_secflag,li_priceflag
- //
- //IF dw_edit_mode THEN
- // dw_uc.AcceptText()
- // dw_child.AcceptText()
- // uc_row = dw_uc.GetRow()
- // IF uc_row <= 0 THEN
- // MessageBox('系统提示','请选定当前目标单据!')
- // RETURN
- // END IF
- //
- // IF NOT dw_uc.Object.u_outware_outdate[uc_row] > DateTime(2000-01-01,Now()) THEN
- // MessageBox('系统提示','不合理发生时间')
- // dw_uc.SetFocus()
- // dw_uc.SetColumn("u_outware_outrep")
- // RETURN
- // END IF
- //
- // IF NOT Len(String(dw_uc.Object.u_outware_outrep[uc_row])) > 0 THEN
- // MessageBox('系统提示','请填写经手人')
- // dw_uc.SetFocus()
- // dw_uc.SetColumn("u_outware_outrep")
- // RETURN
- // END IF
- //
- // IF dw_uc.Object.u_outware_relint_1[uc_row] = 0 THEN
- // MessageBox('系统提示','请选择结算方式')
- // dw_uc.SetFocus()
- // dw_uc.SetColumn("u_outware_relint_1")
- // RETURN
- // END IF
- //
- // IF dw_uc.Object.u_outware_relint_2[uc_row] = 0 THEN
- // MessageBox('系统提示','请选择币种')
- // dw_uc.SetFocus()
- // dw_uc.SetColumn("u_outware_relint_2")
- // RETURN
- // END IF
- //
- //
- // IF wf_check_ifmtrlware(arg_msg) = 0 THEN
- // MessageBox('Error!',arg_msg)
- // RETURN
- // END IF
- //
- // dw_child.AcceptText( )
- //
- //
- // //退货单输入是否负数
- //
- // FOR j = 1 TO dw_child.RowCount()
- // IF dw_child.Object.u_outwaremx_mtrlwareid[j] > 0 AND dw_child.Object.u_outwaremx_qty[j] > 0 THEN
- // dw_child.Object.u_outwaremx_qty[j] = 0 - dw_child.Object.u_outwaremx_qty[j]
- // END IF
- //
- // IF dw_child.Object.u_outwaremx_mtrlwareid[j] > 0 AND dw_child.Object.u_outwaremx_addqty[j] > 0 THEN
- // dw_child.Object.u_outwaremx_addqty[j] = 0 - dw_child.Object.u_outwaremx_addqty[j]
- // END IF
- // NEXT
- //
- //
- // uo_ware.outdate = dw_uc.Object.u_outware_outdate[uc_row] // 发生时间
- // uo_ware.outrep = dw_uc.Object.u_outware_outrep[uc_row] // 经手人
- // uo_ware.part = dw_uc.Object.u_outware_part[uc_row] //相关部门
- // uo_ware.dscrp = dw_uc.Object.u_outware_dscrp[uc_row] //备注
- // uo_ware.cusid = dw_uc.Object.u_outware_cusid[uc_row]
- // uo_ware.storageid = dw_uc.Object.u_outware_storageid[uc_row]
- // uo_ware.relid = dw_uc.Object.u_outware_relid[uc_row]
- // uo_ware.relint_1 = dw_uc.Object.u_outware_relint_1[uc_row]
- // uo_ware.relint_2 = dw_uc.Object.u_outware_relint_2[uc_row]
- // uo_ware.relstr_1 = dw_uc.Object.u_outware_relstr_1[uc_row]
- // uo_ware.relstr_2 = dw_uc.Object.u_outware_relstr_2[uc_row]
- // uo_ware.mrate = dw_uc.Object.u_outware_mrate[uc_row]
- // uo_ware.thflag = 1
- //
- // ll_scid = dw_uc.Object.u_outware_scid[uc_row]
- // ll_outwareid = dw_uc.Object.u_outware_outwareid[uc_row]
- //
- // IF ll_outwareid > 0 THEN
- // SELECT flag,secflag,priceflag
- // INTO :li_flag,:li_secflag,:li_priceflag
- // FROM u_outware
- // WHERE scid = :ll_scid
- // AND outwareid = :ll_outwareid;
- // IF sqlca.SQLCode <> 0 THEN
- // MessageBox(publ_operator,'查询销售单审核标记失败')
- // RETURN
- // END IF
- // END IF
- //
- //
- //
- // FOR i = 1 TO dw_child.RowCount()
- // IF dw_child.Object.u_outwaremx_mtrlwareid[i] > 0 THEN
- // IF li_priceflag = 0 AND li_flag = 0 THEN
- // ll_printid = i
- // ELSE
- // ll_printid = dw_child.Object.u_outwaremx_printid[i]
- // END IF
- //
- // IF uo_ware.acceptmx(dw_child.Object.u_outwaremx_mtrlwareid[i],&
- // dw_child.Object.u_outwaremx_qty[i],&
- // dw_child.Object.u_outwaremx_addqty[i],&
- // dw_child.Object.u_outwaremx_enprice[i],&
- // dw_child.Object.u_outwaremx_rebate[i],&
- // dw_child.Object.u_outwaremx_cost[i],&
- // dw_child.Object.u_outwaremx_mxdscrp[i],&
- // ll_printid,&
- // arg_msg,&
- // 0,&
- // dw_child.Object.u_outwaremx_relid[i],0,&
- // dw_child.Object.u_outwaremx_packqty[i],&
- // dw_child.Object.u_outwaremx_outtype[i]) = 0 THEN
- // MessageBox('Error!',arg_msg)
- // RETURN
- // END IF
- // END IF
- // NEXT
- //
- // IF uo_ware.Save(TRUE,arg_msg) = 0 THEN
- // MessageBox('Error!',arg_msg)
- // RETURN
- // END IF
- //// MessageBox(publ_operator,'保存操作成功!')
- // //write ini
- // SetProfileString (sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "ddlb_storageid",String(dw_uc.Object.u_outware_storageid[dw_uc.GetRow()]))
- // SetProfileString (sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()]))
- //
- // //
- // dw_pageretr.SelectRow(0,FALSE)
- // dw_pageretr.SelectRow(uc_row,TRUE)
- // wf_refresh_curuc(cur_scid,uo_ware.outwareid) //刷新uc
- //ELSE
- // IF uo_ware.newbegin(cur_scid,1,arg_msg) = 0 THEN
- // MessageBox('Error!',arg_msg)
- // RETURN
- // END IF
- // cur_editfocus = 1
- // flag = -1
- // secflag = -1
- //END IF
- //
- //CALL SUPER::Clicked
- ////read ini
- //IF dw_edit_mode THEN
- // PARENT.TriggerEvent("insert_childrow")
- // String ls_storageid,ls_moneyid
- // ls_storageid = ProfileString(sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "ddlb_storageid",'0')
- // IF f_find_storageid(ls_storageid) = '' THEN
- // ls_storageid = '0'
- // END IF
- // ls_moneyid = ProfileString(sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0')
- // dw_uc.SetRedraw(FALSE)
- // dw_uc.Object.u_outware_storageid[dw_uc.GetRow()] = Long(ls_storageid)
- // dw_uc.Object.u_outware_relint_2[dw_uc.GetRow()] = Long(ls_moneyid)
- // dw_uc.Object.u_outware_mrate[dw_uc.GetRow()] = f_get_mrate(Long(ls_moneyid))
- // dw_uc.SetColumn("u_outware_storageid")
- // dw_uc.SetRedraw(TRUE)
- //ELSE
- // PARENT.TriggerEvent("retrieve_childdw")
- //END IF
- ////
- //
- //
- //
- //
- end event
- type cb_edit from w_publ_1ton_share_detail`cb_edit within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 1925
- end type
- event cb_edit::clicked;//IF Not (f_power_ind(540) OR f_power_ind(566)) THEN
- // MessageBox(publ_operator,'你没有使用权限!')
- // RETURN
- //END IF
- //
- //string arg_msg=''
- //long uc_row
- //
- //uc_row=dw_uc.getrow()
- //if uc_row<=0 then
- // messagebox('系统提示','请选定当前目标单据!')
- // return
- //end if
- //
- //if not dw_edit_mode then
- // if uo_ware.updatebegin(dw_uc.object.u_outware_scid[uc_row],dw_uc.object.u_outware_outwareid[uc_row],1,arg_msg)=0 then
- // messagebox('Error!',arg_msg)
- // return
- // end if
- // cur_editfocus=2
- //else
- // cur_editfocus=0
- //end if
- //
- //call super::clicked
- //this.triggerevent('refresh_interface')
- end event
- type cb_delet from w_publ_1ton_share_detail`cb_delet within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 2117
- end type
- event cb_delet::clicked;call super::clicked;//IF Not (f_power_ind(581) OR f_power_ind(582)) THEN
- // MessageBox(publ_operator,'你没有使用权限!')
- // RETURN
- //END IF
- //
- //
- //string arg_msg=''
- //
- //if dw_edit_mode then return
- //long uc_row
- //uc_row=dw_pageretr.getrow()
- //if uc_row<=0 then
- // messagebox('系统提示','请选定当前目标单据!')
- // return
- //end if
- //
- //if messagebox ("if","是否确定要删除当前单据?",question!,yesno! ) = 2 then return
- //
- //if uo_ware.del(dw_uc.object.u_outware_scid[uc_row],dw_uc.object.u_outware_outwareid[uc_row],arg_msg,true)=0 then
- // messagebox('error!',arg_msg)
- //else
- // //日志
- // long ls_id
- // string ls_code
- // ls_id=dw_uc.object.u_outware_outwareid[uc_row]
- // ls_code=dw_uc.object.u_outware_outwarecode[uc_row]
- // f_setsysoplog('销售退货单','删除,id:'+string(ls_id)+',code:'+ls_code,arg_msg,true)
- // //--
- // messagebox(publ_operator,'删除单据'+string(dw_uc.object.u_outware_outwarecode[uc_row])+'成功!')
- //
- //
- // dw_pageretr.deleterow(uc_row)
- // dw_pageretr.postevent(rowfocuschanged!)
- //end if
- end event
- type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_outware_sale_wareaudit_th
- integer x = 645
- end type
- event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
- string menustr
- menustr="Text=增加备注~tEvent=ue_addzy"
- menustr=menustr + "|" + "Text=-"
- menustr=menustr + "|" + "Text=确认~tEvent=ue_priceaudit"
- menustr=menustr + "|" + "Text=反确认~tEvent=ue_cpriceaudit"
- menustr=menustr + "|" + "Text=-"
- menustr=menustr + "|" + "Text=导入单价~tEvent=ue_importseleprice"
- menustr=menustr + "|" + "Text=导入客户历史售价~tEvent=ue_importcusseleprice_his"
- menustr=menustr + "|" + "Text=导入客户单价~tEvent=ue_importcusseleprice"
- menustr=menustr + "|" + "Text=-"
- menustr=menustr + "|" + "Text=复制单据~tEvent=ue_copy"
- menustr=menustr + "|" + "Text=粘贴单据~tEvent=ue_paste"
- menustr = menustr + "|" + "Text=-"
- menustr = menustr + "|" + "Text=查看附件~tEvent=ue_fj_view"
- menustr = menustr + "|" + "Text=添加附件~tEvent=ue_fj_edit"
- if len(trim(menustr))<>0 then
- dmPopupMenu = Create m_Dfc_Control_PopupMenu
- dmPopupMenu.mf_BuildMenu(This, menustr)
- dmPopupMenu.mf_PopMenu()
- Destroy dmPopupMenu
- end if
- end event
- type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_outware_sale_wareaudit_th
- integer x = 302
- string text = "仓审&F"
- end type
- event cb_auditing::clicked;call super::clicked;IF dw_edit_mode THEN RETURN
- IF NOT KeyDown(KeyControl!) THEN
-
- String arg_msg = '',ls_code
- Long pagerert_row,ls_id
-
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
-
- IF MessageBox ("询问","是否确定要"+THIS.Text+"当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
-
-
- IF uo_ware.getinfo(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
-
- IF dw_pageretr.Object.flag[pagerert_row] = 0 THEN
- IF NOT (f_power_ind(541) OR f_power_ind(567)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- IF uo_ware.auditing(TRUE,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- ELSE
- MessageBox('提示','仓库审核成功!',information!,OK!)
- wf_refresh_curuc(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row])
- END IF
- END IF
- ELSE
- IF MessageBox ("询问","是否确定要批审核列表中未审核的单据?",Question!,YesNo! ) = 2 THEN RETURN
-
- Long ll_i,ll_billid
- Int li_flag
- Long ll_suc,ll_fail
- dw_pageretr.AcceptText()
-
- OPEN(w_sys_wait_jdt) //初始化进度条
- w_sys_wait_jdt.Show()
- w_sys_wait_jdt.wf_accepttol(dw_pageretr.RowCount())
-
- FOR ll_i = 1 TO dw_pageretr.RowCount()
- w_sys_wait_jdt.st_msg.Text = dw_pageretr.Object.u_outware_outwarecode[ll_i] + " 正在审核..." //进度信息
-
- li_flag = dw_pageretr.Object.flag[ll_i]
- IF li_flag = 1 THEN CONTINUE
- ll_billid = dw_pageretr.Object.u_outware_outwareid[ll_i]
- IF uo_ware.getinfo(cur_scid,ll_billid,arg_msg) = 0 THEN
- ll_fail++
- CONTINUE
- END IF
- IF uo_ware.auditing(TRUE,arg_msg) = 0 THEN
- ll_fail++
- CONTINUE
- END IF
- ll_suc++
- w_sys_wait_jdt.wf_inc(ll_i) //进度
- NEXT
- CLOSE(w_sys_wait_jdt)
- MessageBox('提示','批审核成功!成功:'+String(ll_suc)+',失败:'+String(ll_fail),information!,OK!)
- PARENT.TriggerEvent('retrieve_pageretr')
- END IF
- end event
- type cb_xm from w_publ_1ton_share_detail`cb_xm within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 1065
- integer y = 104
- end type
- type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_outware_sale_wareaudit_th
- end type
- type cb_xls from w_publ_1ton_share_detail`cb_xls within w_outware_sale_wareaudit_th
- integer x = 1280
- end type
- type cb_help from w_publ_1ton_share_detail`cb_help within w_outware_sale_wareaudit_th
- integer x = 1582
- end type
- type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_outware_sale_wareaudit_th
- integer x = 494
- end type
- event cb_auditing_cancel::clicked;call super::clicked;IF dw_edit_mode THEN RETURN
- String arg_msg = '',ls_code,ls_opemp,ls_outpart
- Long pagerert_row,ls_id
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要"+THIS.Text+"当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
- IF uo_ware.getinfo(dw_uc.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- //两级审
- IF dw_pageretr.Object.flag[pagerert_row] = 1 AND dw_pageretr.Object.secflag[pagerert_row] = 0 THEN
- IF Not (f_power_ind(541) OR f_power_ind(567)) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- IF uo_ware.c_auditing(TRUE,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- ELSE
- MessageBox('提示','仓库撤审成功!',information!,OK!)
- //日志
- ls_code = dw_uc.Object.u_outware_outwarecode[pagerert_row]
- ls_opemp = dw_uc.Object.u_outware_opemp[pagerert_row]
- ls_outpart = dw_uc.Object.u_outware_part[pagerert_row]
- f_setsysoplog('销售退货单','仓库撤审'+',code:'+ls_code+',相关号码:'+ls_outpart+',建立人:'+ls_opemp,arg_msg,TRUE)
- //--
- wf_refresh_curuc(dw_pageretr.Object.u_outware_scid[pagerert_row],dw_pageretr.Object.u_outware_outwareid[pagerert_row])
- END IF
-
- END IF
- end event
- type p_msg from w_publ_1ton_share_detail`p_msg within w_outware_sale_wareaudit_th
- end type
- type p_help from w_publ_1ton_share_detail`p_help within w_outware_sale_wareaudit_th
- end type
- type p_encl from w_publ_1ton_share_detail`p_encl within w_outware_sale_wareaudit_th
- end type
- type p_other from w_publ_1ton_share_detail`p_other within w_outware_sale_wareaudit_th
- end type
- type gb_3 from w_publ_1ton_share_detail`gb_3 within w_outware_sale_wareaudit_th
- end type
- type ln_bar from w_publ_1ton_share_detail`ln_bar within w_outware_sale_wareaudit_th
- end type
- type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_outware_sale_wareaudit_th
- end type
- type r_bar from w_publ_1ton_share_detail`r_bar within w_outware_sale_wareaudit_th
- end type
- type ln_1 from w_publ_1ton_share_detail`ln_1 within w_outware_sale_wareaudit_th
- integer endx = 3227
- end type
- type ln_2 from w_publ_1ton_share_detail`ln_2 within w_outware_sale_wareaudit_th
- integer endx = 3227
- end type
- type ddlb_scid from uo_ddlb_scid within w_outware_sale_wareaudit_th
- integer x = 1765
- integer y = 196
- integer width = 549
- integer height = 468
- integer taborder = 20
- boolean bringtotop = true
- end type
- event constructor;call super::constructor;cur_scid=this.uo_scid
- cur_scid_arr = THIS.uo_scid_arr
- end event
- event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
- cur_scid_arr = THIS.uo_scid_arr
- parent.triggerevent("retrieve_pageretr")
- end event
- type ddlb_status from dropdownlistbox within w_outware_sale_wareaudit_th
- integer x = 978
- integer y = 192
- integer width = 549
- integer height = 552
- integer taborder = 30
- boolean bringtotop = true
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 33554432
- string text = "[全部]"
- boolean sorted = false
- string item[] = {"[全部]","待仓库审核","待财务审核","审核完毕"}
- borderstyle borderstyle = stylelowered!
- end type
- event selectionchanged;if index=1 then
- cur_flag=-1
- cur_secflag= -1
- elseif index=2 then
- cur_flag= 0
- cur_secflag= -1
- elseif index=3 then
- cur_flag= 1
- cur_secflag= 0
- elseif index=4 then
- cur_flag= 1
- cur_secflag= 1
- end if
- parent.triggerevent('retrieve_pageretr')
- end event
- type st_3 from statictext within w_outware_sale_wareaudit_th
- integer x = 795
- integer y = 204
- integer width = 219
- integer height = 48
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 33554432
- long backcolor = 134217739
- string text = "状 态"
- boolean focusrectangle = false
- end type
- type st_2 from statictext within w_outware_sale_wareaudit_th
- integer x = 1582
- integer y = 208
- integer width = 219
- integer height = 48
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 33554432
- long backcolor = 134217739
- string text = "分 部"
- boolean focusrectangle = false
- end type
- type st_msg from statictext within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 2373
- integer y = 440
- integer width = 1166
- integer height = 788
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long backcolor = 15793151
- boolean border = true
- borderstyle borderstyle = styleraised!
- boolean focusrectangle = false
- end type
- type cbx_his from checkbox within w_outware_sale_wareaudit_th
- boolean visible = false
- integer x = 1934
- integer y = 84
- integer width = 411
- integer height = 60
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 16711680
- long backcolor = 134217739
- boolean enabled = false
- string text = "选择发货历史"
- end type
|