12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589 |
- $PBExportHeader$w_reissue_bj.srw
- forward
- global type w_reissue_bj from w_publ_1ton_share_detail
- end type
- type ddlb_scid from uo_ddlb_scid within w_reissue_bj
- end type
- type ddlb_status from dropdownlistbox within w_reissue_bj
- end type
- type st_3 from statictext within w_reissue_bj
- end type
- type st_2 from statictext within w_reissue_bj
- end type
- end forward
- global type w_reissue_bj from w_publ_1ton_share_detail
- string title = "客户补件单"
- boolean maxbox = true
- windowstate windowstate = maximized!
- event insert_childrow ( )
- ddlb_scid ddlb_scid
- ddlb_status ddlb_status
- st_3 st_3
- st_2 st_2
- end type
- global w_reissue_bj w_reissue_bj
- type variables
- uo_reissue uo_ware
- Long cur_scid
- Long cur_scid_arr[]
- Long cur_flag = -1
- end variables
- forward prototypes
- public function integer wf_flagstatus_rf ()
- public function integer wf_refresh_curuc (long arg_scid, long arg_reissueid)
- public function integer wf_addmx (long arg_scid, long arg_outwareid, ref string arg_msg)
- public function integer wf_adduc (long arg_scid, long arg_outwareid, 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
- public function integer wf_flagstatus_rf ();Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = FALSE
- GOTO ext
- END IF
- IF dw_edit_mode THEN
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = FALSE
- ELSE
- IF dw_pageretr.Object.flag[pagerert_row] = 0 THEN
- cb_auditing.Enabled = TRUE
- cb_auditing_cancel.Enabled = FALSE
- ELSEIF dw_pageretr.Object.flag[pagerert_row] = 1 THEN
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = TRUE
- END IF
- END IF
- ext:
- RETURN 0
- end function
- public function integer wf_refresh_curuc (long arg_scid, long arg_reissueid);IF arg_reissueid <= 0 OR IsNull(arg_reissueid) THEN RETURN 0
- Long uc_row
- uc_row = dw_pageretr.GetRow()
- IF uc_row <= 0 THEN RETURN 0
- Long cusid
- DateTime reissuedate
- String dscrp
- String reissuecode
- DateTime opdate
- String operator
- Int flag
- DateTime auditingdate ,moddate
- String Auditingrep ,modemp
- String relcode
- Long relid,moneyid
- Long r_type
- string reissueemp,cusname,cuscode
- long ll_printnum
- long itemid
- string ls_itemcode,ls_itemname
- SELECT u_reissue.reissuecode,
- u_reissue.cusid,
- u_reissue.reissuedate,
- u_reissue.relid,
- u_reissue.relcode,
- u_reissue.dscrp,
- u_reissue.opemp,
- u_reissue.opdate,
- u_reissue.modemp,
- u_reissue.moddate,
- u_reissue.auditingrep,
- u_reissue.auditingdate,
- u_reissue.flag ,
- u_reissue.type,
- u_reissue.moneyid,
- u_reissue.reissueemp,
- u_reissue.printnum ,
- u_cust.name,
- u_cust.cuscode,
- u_reissue.itemid,
- u_itemdef.itemcode,
- u_itemdef.itemname
- INTO :reissuecode,
- :cusid,
- :reissuedate,
- :relid,
- :relcode,
- :dscrp,
- :operator,
- :opdate,
- :modemp,
- :moddate,
- :Auditingrep,
- :Auditingdate,
- :flag,
- :r_type,
- :moneyid,
- :reissueemp,
- :ll_printnum,
- :cusname,
- :cuscode,
- :itemid,
- :ls_itemcode,
- :ls_itemname
- FROM u_reissue LEFT OUTER JOIN
- u_itemdef ON u_reissue.itemid = u_itemdef.itemid LEFT OUTER JOIN
- u_cust ON u_reissue.cusid = u_cust.cusid
- WHERE ( u_reissue.reissueid = :arg_reissueid ) AND
- ( u_reissue.scid = :arg_scid);
- IF sqlca.SQLCode <> 0 THEN
- MessageBox('错误',"查询操作失败(错误单据唯一码)",stopsign!,OK!)
- RETURN 0
- END IF
- dw_pageretr.Object.scid[uc_row] = arg_scid
- dw_pageretr.Object.reissueid[uc_row] = arg_reissueid
- dw_pageretr.Object.reissuedate[uc_row] = reissuedate
- dw_pageretr.Object.dscrp[uc_row] = dscrp
- dw_pageretr.Object.reissuecode[uc_row] = reissuecode
- dw_pageretr.Object.opdate[uc_row] = opdate
- dw_pageretr.Object.opemp[uc_row] = operator
- dw_pageretr.Object.flag[uc_row] = flag
- dw_pageretr.Object.relid[uc_row] = relid
- dw_pageretr.Object.relcode[uc_row] = relcode
- dw_pageretr.Object.auditingdate[uc_row] = auditingdate
- dw_pageretr.Object.Auditingrep[uc_row] = Auditingrep
- dw_pageretr.Object.cusid[uc_row] = cusid
- dw_pageretr.Object.moddate[uc_row] = moddate
- dw_pageretr.Object.modemp[uc_row] = modemp
- dw_pageretr.Object.TYPE[uc_row] = r_type
- dw_pageretr.Object.moneyid[uc_row] = moneyid
- dw_pageretr.Object.reissueemp[uc_row] = reissueemp
- dw_pageretr.Object.printnum[uc_row] = printnum
- dw_pageretr.Object.u_cust_cuscode[uc_row] = cuscode
- dw_pageretr.Object.u_cust_name[uc_row] = cusname
- dw_pageretr.Object.u_itemdef_itemcode[uc_row] = ls_itemcode
- dw_pageretr.Object.u_itemdef_itemname[uc_row] = ls_itemname
- dw_pageretr.Object.u_reissue_itemid[uc_row] = itemid
- 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_addmx (long arg_scid, long arg_outwareid, ref string arg_msg);//wf_saletaskmtrltoarr(long arg_taskid,ref s_saletask_mtrl arg_s_rqmtrl[],ref long arg_p_rqmtrl,ref string arg_msg)
- //查询合同物料资料
- //把物料资料写入数组
- long rslt=1
- long ls_mtrlid
- string ls_mtrlcode,ls_mtrlname
- dec ls_qty
- Long child_row
- child_row = dw_child.GetRow()
- //查询合同物料
- DECLARE pf_cur CURSOR FOR
- SELECT u_mtrldef.mtrlid AS mtrlid, u_mtrldef.mtrlcode AS mtrlcode,
- u_mtrldef.mtrlname AS mtrlname,u_outwaremx.qty
- FROM u_outwaremx INNER JOIN
- u_mtrldef ON u_outwaremx.mtrlid = u_mtrldef.mtrlid
- WHERE ( u_outwaremx.outwareid = :arg_outwareid )
- and ( u_outwaremx.scid = :arg_scid );
- open pf_cur;
- fetch pf_cur into :ls_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_qty;
- do while sqlca.sqlcode=0
- IF dw_child.GetRow() > 0 THEN
- IF dw_child.Object.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.mtrlid[child_row]=ls_mtrlid
- dw_child.object.mtrlcode[child_row]=ls_mtrlcode
- dw_child.object.mtrlname[child_row]=ls_mtrlname
- dw_child.object.qty[child_row]=ls_qty
- fetch pf_cur into :ls_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_qty;
- loop
- close pf_cur;
- dw_child.accepttext()
- return rslt
- end function
- public function integer wf_adduc (long arg_scid, long arg_outwareid, ref string arg_msg);//wf_saletaskmtrltoarr(long arg_taskid,ref s_saletask_mtrl arg_s_rqmtrl[],ref long arg_p_rqmtrl,ref string arg_msg)
- //查询合同物料资料
- //把物料资料写入数组
- long rslt=1
- long ls_cusid
- string ls_cuscode,ls_cusname,ls_relcode
- long li_row
- SELECT u_cust.cusid, u_cust.cuscode, u_cust.name,u_outware.outwarecode
- into :ls_cusid,:ls_cuscode,:ls_cusname,:ls_relcode
- FROM u_outware INNER JOIN
- u_cust ON u_outware.cusid = u_cust.cusid
- where u_outware.outwareid=:arg_outwareid and
- u_outware.scid=:arg_scid using sqlca;
- if sqlca.sqlcode<>0 then
- rslt=0
- arg_msg="查询操作失败,销售单客户"
- goto ext
- end if
- dw_uc.object.cusid[dw_uc.getrow()]=ls_cusid
- dw_uc.object.cuscode[dw_uc.getrow()]=ls_cuscode
- dw_uc.object.cusname[dw_uc.getrow()]=ls_cusname
- dw_uc.object.relid[dw_uc.getrow()]=arg_outwareid
- dw_uc.object.relcode[dw_uc.getrow()]=ls_relcode
- dw_uc.accepttext()
- wf_addmx(arg_scid,arg_outwareid,arg_msg)
- 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_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.scid[LS_ROW]
- ////可选设置///
- 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.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.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_reissue_bj.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
- 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
- end on
- on w_reissue_bj.destroy
- call super::destroy
- destroy(this.ddlb_scid)
- destroy(this.ddlb_status)
- destroy(this.st_3)
- destroy(this.st_2)
- end on
- event retrieve_pageretr;Boolean cb_nextpage_enabled,cb_retrieveall_enabled
- Boolean 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
- Int li_option_outrep, li_option_area
- IF sys_power_issuper THEN
- li_option_outrep = 0
- ELSE
- li_option_outrep = sys_option_outrep
- END IF
- IF sys_power_issuper THEN
- li_option_area = 0
- ELSE
- li_option_area = sys_option_cusarea
- END IF
- dw_uc.Retrieve()
- dw_pageretr.Retrieve(cur_scid_arr,cur_flag,sys_areaid,li_option_area)
- IF dw_pageretr.RowCount() > 0 THEN
- dw_pageretr.SetRow(1)
- dw_pageretr.TriggerEvent(RowFocusChanged!)
- END IF
- wf_flagstatus_rf()
- 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+'( reissuecode LIKE "%'+trim(sle_usual_query.text)+'%" )'
- ELSE
- obj_expr=obj_expr+'( reissuecode 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.SetRow(1)
- dw_pageretr.SelectRow(1,True)
- END IF
- dw_pageretr.TriggerEvent(RowFocusChanged!)
- 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_reissue.reissuecode like '%"+trim(sle_usual_query.text)+"%')"
- else
- ls_querystrpart="(u_reissue.reissuecode 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;call super::open;uc_column_int = 9 //uc dw前7列可以编辑
- child_column_int = 4 //子dw前8列可以编辑
- uo_ware = CREATE uo_reissue
- uo_ware.commit_transaction = sqlca
- 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;ddlb_status.Enabled = NOT dw_edit_mode
- ddlb_scid.Enabled = NOT dw_edit_mode
- end event
- event close;call super::close;destroy uo_ware
- end event
- event ue_f8;call super::ue_f8;//用于选择明细内容,被F8[默认]\dw_child.doubleclicked调用
- IF NOT dw_edit_mode THEN RETURN
- Long child_row
- child_row = dw_child.GetRow()
- 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.f_long = -1
-
- Long chc = 1,ls_j
- dw_child.AcceptText()
- IF dw_child.GetRow() > 0 THEN s_ch_tran.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
- 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.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.mtrlid[child_row] = S_INSCUST.mtrlid[ls_j]
- dw_child.Object.u_mtrldef_mtrlcode[child_row] = S_INSCUST.mtrlcode[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_unit[child_row] = S_INSCUST.unit[ls_j]
- END IF
- NEXT
- dw_child.SetFocus()
- END IF
- end event
- event retrieve_childdw;call super::retrieve_childdw;Long row,uc_relid,uc_scid
- row = dw_pageretr.GetRow()
- IF row > 0 THEN
- uc_relid = dw_pageretr.Object.reissueid[row]
- uc_scid = dw_pageretr.Object.scid[row]
- dw_child.SetRedraw (FALSE)
- dw_child.Retrieve(uc_scid,uc_relid)
- dw_child.SetRedraw (TRUE)
- IF dw_child.RowCount() > 0 THEN
- dw_child.SelectRow(0,FALSE)
- dw_child.SelectRow(1,TRUE)
- dw_child.SetRow(1)
- END IF
- ELSE
- dw_child.Reset()
- END IF
- end event
- event ue_f9;call super::ue_f9;IF NOT dw_edit_mode THEN RETURN
- Long child_row
- child_row = dw_uc.GetRow()
- IF child_row = 0 THEN
- MessageBox('提示','请选定补件单!',information!,OK!)
- RETURN
- END IF
- IF NOT IsValid(W_cust_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 (备用)
- //查询列(物料编码)部分内容,用于初步筛选
-
- dw_uc.AcceptText()
- s_ch_tran.arg_string_code = Upper(Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()]))
-
- OpenWithParm(W_cust_edit,s_ch_tran) //调用
-
- s_custom S_INSCUST
- S_INSCUST = Message.PowerObjectParm //接受返回结构
-
- IF S_INSCUST.cusid > 0 THEN //正常返回值则可以取以下值
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.cusid[child_row] = S_INSCUST.cusid
- dw_uc.Object.u_cust_name[child_row] = S_INSCUST.Name
- dw_uc.Object.u_cust_cuscode[child_row] = S_INSCUST.cuscode
- dw_uc.SetRedraw(TRUE)
- dw_uc.SetFocus()
- dw_uc.SetColumn("moneyid")
- END IF
- END IF
- end event
- event ue_viewprint;call super::ue_viewprint;
- IF NOT f_power_ind(1042) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- Long LS_ROW
- LS_ROW = dw_pageretr.GetRow()
- IF LS_ROW <= 0 THEN
- MessageBox('提示','没有打印目标单据!',information!,OK!)
- RETURN
- END IF
- S_print_MSG LS_PRMSG
- 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
- IF NOT f_power_ind(1042) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- LS_PRMSG.obj_dwNAME = 'dw_rp_reissue_print_bj'
- END IF
- IF LS_PRMSG.obj_dwNAME = '' THEN RETURN
- LS_PRMSG.printrow = ll_prownum
- LS_PRMSG.TAG_TEXT = '客户补件单'
- LS_PRMSG.FILTER_STRING = ''
- LS_PRMSG.retr_pram_falg = 15
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.retr_scid = dw_pageretr.Object.scid[LS_ROW]
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.reissueid[LS_ROW]
- 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_reissue',printnum,dw_pageretr.Object.scid[dw_pageretr.GetRow()],dw_pageretr.Object.reissueid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event ue_print;call super::ue_print;//--直接打印
- IF NOT f_power_ind(1042) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- uo_print_preview uo_print
- IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
- S_print_MSG LS_PRMSG
- Long LS_ROW
- LS_ROW = dw_pageretr.GetRow()
- IF LS_ROW <= 0 THEN
- MessageBox('提示','没有打印目标单据!',information!,OK!)
- RETURN
- 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
-
- IF NOT f_power_ind(1042) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- LS_PRMSG.obj_dwNAME = 'dw_rp_reissue_print_bj'
- END IF
- if LS_PRMSG.obj_dwNAME = '' then return
- LS_PRMSG.retr_pram_falg = 15
- LS_PRMSG.printrow = ll_prownum
- LS_PRMSG.TAG_TEXT = '客户补件单'
- LS_PRMSG.FILTER_STRING = ''
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.retr_scid = dw_pageretr.Object.scid[LS_ROW]
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.reissueid[LS_ROW]
- 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 = 1
- f_update_printnum('u_reissue',printnum,dw_pageretr.Object.scid[dw_pageretr.GetRow()],dw_pageretr.Object.reissueid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event ue_addzy;call super::ue_addzy;if not f_power_ind(1043) 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.scid[uc_row],dw_pageretr.Object.reissueid[uc_row],ls_str,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- ELSE
- MessageBox('提示','添加备注操作成功!',information!,OK!)
- wf_refresh_curuc(dw_pageretr.object.scid[uc_row],dw_pageretr.Object.reissueid[uc_row])
- END IF
- end event
- event ue_rpt_print;call super::ue_rpt_print;
- 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.scid[row]
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.reissueid[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_reissue',printnum,dw_pageretr.Object.scid[dw_pageretr.GetRow()],dw_pageretr.Object.reissueid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
- end event
- event ue_rpt_viewprint;call super::ue_rpt_viewprint;
- 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.scid[row]
- s_print.retr_pramnmb = dw_pageretr.Object.reissueid[row]
- s_print.rowcnt = dw_child.RowCount()
- OpenWithParm(w_rpt_preview,s_print)
- //更新打印次数
- string arg_msg
- printnum = Message.DoubleParm
- f_update_printnum('u_reissue',printnum,dw_pageretr.Object.scid[dw_pageretr.GetRow()],dw_pageretr.Object.reissueid[dw_pageretr.GetRow()],'','',arg_msg,TRUE)
-
- end event
- event ue_f7;call super::ue_f7;//用于选择明细内容,被F9[默认]
- IF NOT dw_edit_mode THEN RETURN
- Long uc_row
- String ls_itemcode
- uc_row = dw_uc.GetRow()
- ls_itemcode = Trim(dw_uc.Object.u_itemdef_itemcode[uc_row])
- IF uc_row = 0 THEN
- MessageBox('提示','请选定单据!',information!,OK!)
- RETURN
- END IF
- dw_uc.AcceptText()
- IF NOT IsValid(w_itemdef_ch) THEN
- s_edit_index_tran s_ch_tran //传递参数使用
- s_ch_tran.if_retrieve_all = local_retrieve_all //是否一次retrieve所有行
- s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
- s_ch_tran.arg_pkid = 0 //目标定位pkid (备用)
- s_ch_tran.arg_string_code = ls_itemcode //查询列(物料编码)部分内容,用于初步筛选
-
- OpenWithParm(w_itemdef_ch,s_ch_tran) //调用
-
- s_itemdef s_inscust
- s_inscust = Message.PowerObjectParm //接受返回结构
-
- IF s_inscust.itemid > 0 THEN //正常返回值则可以取以下值
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.u_reissue_itemid[uc_row] = s_inscust.itemid
- dw_uc.Object.u_itemdef_itemcode[uc_row] = s_inscust.itemcode
- dw_uc.Object.u_itemdef_itemname[uc_row] = s_inscust.itemname
-
- dw_uc.SetColumn("dscrp")
- dw_uc.SetRedraw(TRUE)
- END IF
- END IF
- end event
- type cb_func from w_publ_1ton_share_detail`cb_func within w_reissue_bj
- end type
- type cb_exit from w_publ_1ton_share_detail`cb_exit within w_reissue_bj
- integer x = 2514
- integer width = 146
- end type
- type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_reissue_bj
- integer width = 549
- end type
- type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_reissue_bj
- integer x = 2962
- end type
- type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_reissue_bj
- integer x = 2661
- end type
- type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_reissue_bj
- integer x = 1710
- integer width = 1829
- integer height = 1028
- string dataobject = "dw_reissue_index_bj"
- end type
- event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_flagstatus_rf()
- end event
- type st_1 from w_publ_1ton_share_detail`st_1 within w_reissue_bj
- integer x = 27
- end type
- type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_reissue_bj
- integer x = 3113
- end type
- type dw_uc from w_publ_1ton_share_detail`dw_uc within w_reissue_bj
- integer width = 1710
- integer height = 1024
- string dataobject = "dw_reissue_edit_bj"
- end type
- event dw_uc::dwnkey;PARENT.TriggerEvent('user_key')
- IF Key = KeyDownArrow! THEN RETURN 1
- IF dw_edit_mode THEN
- IF dw_uc.GetColumnName ( ) = 'dscrp' AND Key = KeyEnter! THEN
- dw_child.SetFocus()
- dw_child.ScrollToRow(1)
- dw_child.SetColumn ('u_mtrldef_mtrlcode')
- RETURN 1
- ELSEIF dw_uc.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN
- String ls_code
-
- dw_uc.AcceptText()
- ls_code = Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()])
-
- s_custom arg_s_cust
-
- IF f_find_cust(ls_code,arg_s_cust) = 0 THEN
- PARENT.TriggerEvent('ue_f9')
- RETURN 1
- ELSE
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.cusid[dw_uc.GetRow()] = arg_s_cust.cusid
- dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()] = arg_s_cust.cuscode
- dw_uc.Object.u_cust_name[dw_uc.GetRow()] = arg_s_cust.Name
- dw_uc.SetRedraw(TRUE)
- dw_uc.SetColumn("moneyid")
- RETURN 1
- END IF
- ELSEIF dw_uc.GetColumnName ( ) = 'u_itemdef_itemcode' AND Key = KeyEnter! THEN
- String ls_itemcode,ls_itemname
- Long ls_itemid
-
- dw_uc.AcceptText()
- ls_itemcode = Upper(Trim(dw_uc.Object.u_itemdef_itemcode[dw_uc.GetRow()]))
- SELECT
- u_itemdef.itemid,
- u_itemdef.itemname
- INTO
- :ls_itemid,
- :ls_itemname
- FROM u_itemdef
- Where ( u_itemdef.itemcode = :ls_itemcode );
- IF sqlca.SQLCode <> 0 THEN
- PARENT.TriggerEvent('ue_f7')
- RETURN 1
- ELSE
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.u_reissue_itemid[dw_uc.GetRow()] = ls_itemid
- dw_uc.Object.u_itemdef_itemname[dw_uc.GetRow()] = ls_itemname
- dw_uc.SetRedraw(TRUE)
- dw_uc.SetColumn("dscrp")
- RETURN 1
- END IF
- 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 event
- event dw_uc::buttonclicked;call super::buttonclicked;IF NOT dw_edit_mode THEN RETURN
- IF row <= 0 THEN RETURN
- IF dwo.Name = 'b_cus' THEN
- PARENT.TriggerEvent('ue_f9')
- END IF
- end event
- event dw_uc::doubleclicked;IF dw_edit_mode AND row > 0 THEN
- IF dwo.Name = 'u_itemdef_itemcode' OR dwo.Name = 'u_itemdef_itemname' THEN
- PARENT.TriggerEvent('ue_f7')
- ELSE
- PARENT.TriggerEvent('ue_f9')
- END IF
- END IF
- end event
- type gb_2 from w_publ_1ton_share_detail`gb_2 within w_reissue_bj
- integer x = 585
- integer y = 456
- integer width = 293
- integer height = 156
- end type
- type dw_child from w_publ_1ton_share_detail`dw_child within w_reissue_bj
- integer y = 1324
- integer width = 3543
- integer height = 876
- string dataobject = "dw_reissuemx_index_bj"
- end type
- event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key')
- String ls_mtrlcode,ls_mtrlname,ls_mtrlmode,ls_unit
- Long ls_mtrlid
- s_mtrldef_array arg_s_mtrldef
- Long child_row
- IF dw_edit_mode THEN
- 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,-1,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]
- END IF
-
-
- dw_child.Object.mtrlid[child_row] = ls_mtrlid
- dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode
- 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
-
- 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( ) = 'dscrp' 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_reissue_bj
- integer x = 1870
- end type
- type cb_print from w_publ_1ton_share_detail`cb_print within w_reissue_bj
- integer x = 1678
- end type
- type cb_add from w_publ_1ton_share_detail`cb_add within w_reissue_bj
- end type
- event cb_add::clicked;IF NOT f_power_ind(1038) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- String arg_msg = ''
- Long uc_row
- Long i
- IF dw_edit_mode THEN
- dw_uc.AcceptText()
- dw_child.AcceptText()
- uc_row = dw_uc.GetRow()
- IF uc_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
-
- IF NOT dw_uc.Object.reissuedate[uc_row] > DateTime(2000-01-01,Now()) THEN
- MessageBox('提示','不合理发生时间',information!,OK!)
- dw_uc.SetFocus()
- dw_uc.SetColumn("reissuedate")
- RETURN
- END IF
-
- IF trim(dw_uc.Object.reissueemp[uc_row]) = '' THEN
- MessageBox('提示','请输入经手人',information!,OK!)
- dw_uc.SetFocus()
- dw_uc.SetColumn("reissueemp")
- RETURN
- END IF
-
- IF dw_uc.Object.relid[uc_row] = 0 THEN
- MessageBox('提示','请选择结算方式',information!,OK!)
- dw_uc.SetFocus()
- dw_uc.SetColumn("relid")
- RETURN
- END IF
-
- IF dw_uc.Object.moneyid[uc_row] = 0 THEN
- MessageBox('提示','请选择币种',information!,OK!)
- dw_uc.SetFocus()
- dw_uc.SetColumn("moneyid")
- RETURN
- END IF
- IF dw_uc.Object.u_reissue_itemid[uc_row] = 0 THEN
- MessageBox('提示','请选择项目',information!,OK!)
- dw_uc.SetFocus()
- dw_uc.SetColumn("u_reissue_itemid")
- RETURN
- END IF
- uo_ware.reissuedate = dw_uc.Object.reissuedate[uc_row] // 发生时间
- uo_ware.dscrp = dw_uc.Object.dscrp[uc_row] //备注
- uo_ware.cusid = dw_uc.Object.cusid[uc_row]
- uo_ware.relcode = dw_uc.Object.relcode[uc_row]
- uo_ware.r_type = 0
- uo_ware.relid = dw_uc.Object.relid[uc_row]
- uo_ware.moneyid = dw_uc.Object.moneyid[uc_row]
- uo_ware.reissueemp = dw_uc.Object.reissueemp[uc_row]
- uo_ware.itemid = dw_uc.Object.u_reissue_itemid[uc_row]
-
-
-
- FOR i = 1 TO dw_child.RowCount()
- IF uo_ware.acceptmx( dw_child.Object.qty[i],&
- dw_child.Object.price[i],&
- dw_child.Object.amt1[i],&
- dw_child.Object.dscrp[i],&
- i,&
- arg_msg,&
- dw_child.Object.mtrlid[i],'') = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- NEXT
-
- IF uo_ware.Save(TRUE,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- MessageBox('提示','保存操作成功!',information!,OK!)
-
- //write ini
- SetProfileString (sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.moneyid[dw_uc.GetRow()]))
- //
- long ll_row
- ll_row = dw_pageretr.getrow()
- dw_pageretr.SelectRow(0,FALSE)
- dw_pageretr.SelectRow(ll_row,TRUE)
- wf_refresh_curuc(cur_scid,uo_ware.reissueid) //刷新uc
-
- ELSE
- IF uo_ware.newbegin(cur_scid,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
- END IF
- CALL SUPER::Clicked
- //read ini
- IF dw_edit_mode THEN
- PARENT.TriggerEvent("insert_childrow")
-
- String ls_moneyid
- ls_moneyid = ProfileString(sys_inifilename,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0')
- dw_uc.SetRedraw(FALSE)
- dw_uc.Object.moneyid[dw_uc.GetRow()] = Long(ls_moneyid)
- dw_uc.SetColumn("u_cust_cuscode")
- 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_reissue_bj
- end type
- event cb_edit::clicked;IF NOT f_power_ind(1038) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- String arg_msg = ''
- Long uc_row
- uc_row = dw_pageretr.GetRow()
- IF uc_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- IF NOT dw_edit_mode THEN
- IF uo_ware.updatebegin(dw_pageretr.Object.scid[uc_row],dw_pageretr.Object.reissueid[uc_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- RETURN
- END IF
-
- wf_refresh_curuc(dw_pageretr.Object.scid[uc_row],dw_pageretr.Object.reissueid[uc_row])
- PARENT.TriggerEvent("retrieve_childdw")
- END IF
- CALL SUPER::Clicked
- end event
- type cb_delet from w_publ_1ton_share_detail`cb_delet within w_reissue_bj
- integer width = 146
- end type
- event cb_delet::clicked;call super::clicked;IF NOT f_power_ind(1039) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- 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('提示','请选定当前目标单据!',information!,OK!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要删除当前单据?",question!,yesno! ) = 2 THEN RETURN
- IF uo_ware.del(dw_pageretr.Object.scid[uc_row],dw_pageretr.Object.reissueid[uc_row],arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,OK!)
- ELSE
- //日志
- Long ls_id
- String ls_code
- ls_id = dw_pageretr.Object.reissueid[uc_row]
- ls_code = dw_pageretr.Object.reissuecode[uc_row]
- f_setsysoplog('客户补件单','客户补件单删除,id:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE)
- //--
- MessageBox('提示','删除单据'+String(dw_pageretr.Object.reissuecode[uc_row])+'成功!',information!,OK!)
-
- dw_pageretr.DeleteRow(uc_row)
- dw_pageretr.Triggerevent(rowfocuschanged!)
- END IF
- end event
- type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_reissue_bj
- integer x = 1175
- end type
- event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu
- string menustr
- menustr="Text=增加备注~tEvent=ue_addzy"
- 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_reissue_bj
- integer x = 832
- end type
- event cb_auditing::clicked;call super::clicked;IF NOT f_power_ind(1040) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- 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.scid[pagerert_row],dw_pageretr.Object.reissueid[pagerert_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,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.scid[pagerert_row],dw_pageretr.Object.reissueid[pagerert_row])
- END IF
- end event
- type cb_xm from w_publ_1ton_share_detail`cb_xm within w_reissue_bj
- integer x = 1426
- end type
- type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_reissue_bj
- end type
- type cb_xls from w_publ_1ton_share_detail`cb_xls within w_reissue_bj
- integer x = 2062
- end type
- type cb_help from w_publ_1ton_share_detail`cb_help within w_reissue_bj
- integer x = 2363
- end type
- type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_reissue_bj
- integer x = 1024
- end type
- event cb_auditing_cancel::clicked;call super::clicked;IF NOT f_power_ind(1041) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
- 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_pageretr.Object.scid[pagerert_row],dw_pageretr.Object.reissueid[pagerert_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,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_pageretr.Object.reissuecode[pagerert_row]
- ls_opemp = dw_pageretr.Object.opemp[pagerert_row]
- ls_outpart = dw_pageretr.Object.relcode[pagerert_row]
- f_setsysoplog('客户补件单','客户补件单撤审'+',code:'+ls_code+',相关号码:'+ls_outpart+',建立人:'+ls_opemp,arg_msg,TRUE)
- //--
- wf_refresh_curuc(dw_pageretr.Object.scid[pagerert_row],dw_pageretr.Object.reissueid[pagerert_row])
- END IF
- end event
- type p_msg from w_publ_1ton_share_detail`p_msg within w_reissue_bj
- end type
- type p_help from w_publ_1ton_share_detail`p_help within w_reissue_bj
- end type
- type p_encl from w_publ_1ton_share_detail`p_encl within w_reissue_bj
- end type
- type p_other from w_publ_1ton_share_detail`p_other within w_reissue_bj
- end type
- type gb_3 from w_publ_1ton_share_detail`gb_3 within w_reissue_bj
- end type
- type ln_bar from w_publ_1ton_share_detail`ln_bar within w_reissue_bj
- end type
- type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_reissue_bj
- end type
- type r_bar from w_publ_1ton_share_detail`r_bar within w_reissue_bj
- end type
- type ln_1 from w_publ_1ton_share_detail`ln_1 within w_reissue_bj
- end type
- type ln_2 from w_publ_1ton_share_detail`ln_2 within w_reissue_bj
- end type
- type ddlb_scid from uo_ddlb_scid within w_reissue_bj
- integer x = 887
- integer y = 188
- 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_reissue_bj
- integer x = 1609
- integer y = 188
- integer width = 375
- 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
- elseif index=2 then
- cur_flag= 0
- elseif index=3 then
- cur_flag= 1
- end if
- parent.triggerevent('retrieve_pageretr')
- end event
- type st_3 from statictext within w_reissue_bj
- integer x = 1435
- integer y = 204
- integer width = 160
- 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 = "状态"
- alignment alignment = right!
- boolean focusrectangle = false
- end type
- type st_2 from statictext within w_reissue_bj
- integer x = 718
- integer y = 204
- integer width = 160
- 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 = "分部"
- alignment alignment = right!
- boolean focusrectangle = false
- end type
|