12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396 |
- $PBExportHeader$w_sptamt_other.srw
- forward
- global type w_sptamt_other from w_publ_1ton_share_detail
- end type
- type ddlb_status from dropdownlistbox within w_sptamt_other
- end type
- type ddlb_scid from uo_ddlb_scid within w_sptamt_other
- end type
- type st_3 from statictext within w_sptamt_other
- end type
- type st_2 from statictext within w_sptamt_other
- end type
- type cbx_2 from checkbox within w_sptamt_other
- end type
- type cbx_1 from checkbox within w_sptamt_other
- end type
- end forward
- global type w_sptamt_other from w_publ_1ton_share_detail
- integer height = 2060
- string title = "其他付款单"
- event ue_update_spt ( )
- event insert_childrow ( )
- event ue_confirm ( )
- event ue_confirm_cancel ( )
- event ue_p_ttakeamt ( )
- event ue_p_tzqamt ( )
- event ue_set_zqamt ( )
- event ue_p_cmpl ( )
- event ue_fj_view ( )
- event ue_fj_edit ( )
- ddlb_status ddlb_status
- ddlb_scid ddlb_scid
- st_3 st_3
- st_2 st_2
- cbx_2 cbx_2
- cbx_1 cbx_1
- end type
- global w_sptamt_other w_sptamt_other
- type variables
- uo_sptamt_other uo_take
- Int cur_flag = -1
- int cur_secflag = -1
- Int cur_confirmflag = -1
- Long cur_scid
- int if_auto ,if_autodetail
- datastore ds_autodetail
- end variables
- forward prototypes
- public function integer wf_refresh_curuc (long arg_billid)
- public function integer wf_flagstatus_rf ()
- public function integer wf_check_mx_amt (long arg_row, ref string arg_msg)
- public subroutine wf_autodetail ()
- end prototypes
- event ue_update_spt();//用于选择明细内容,被F9[默认]
- IF dw_edit_mode THEN RETURN
- IF Not f_power_ind(1514) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- Long uc_row,ll_Baid
- String arg_msg
- dw_uc.AcceptText()
- uc_row = dw_uc.GetRow()
- IF uc_row = 0 THEN
- MessageBox('系统提示','请选定单据!')
- RETURN
- END IF
- ll_Baid = dw_uc.Object.u_Bmstamt_Baid[uc_row]
- IF Not IsValid(w_spt_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()
-
- OpenWithParm(w_spt_edit,s_ch_tran) //调用
-
- s_spt S_INSCUST
- S_INSCUST = Message.PowerObjectParm //接受返回结构
-
- IF S_INSCUST.sptid > 0 THEN //正常返回值则可以取以下值
- IF uo_take.uof_update_cust(ll_Baid,S_INSCUST.sptid,arg_msg,True) = 0 THEN
- MessageBox('提示',arg_msg)
- RETURN
- END IF
- MessageBox('提示','更新成功')
- wf_refresh_curuc(ll_Baid)
- END IF
- END IF
- end event
- event insert_childrow();long li_row
- li_row=dw_child.insertrow(0)
- dw_child.scrolltorow(li_row)
- dw_child.SetColumn ('ttakeamt')
- end event
- event ue_confirm();//确认
- IF NOT f_power_ind(1754) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,ok!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要确认当前单据?",question!,yesno! ) = 2 THEN RETURN
- IF uo_take.confirm(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','确认成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- end event
- event ue_confirm_cancel();//反确认
- IF NOT f_power_ind(1756) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,ok!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要反确认当前单据?",question!,yesno! ) = 2 THEN RETURN
- IF uo_take.cconfirm(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','反确认成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- end event
- event ue_p_ttakeamt();Long i, ll_row
- Decimal lde_takeamt, lde_not_takeamt , lde_ttakeamt_add
- dw_uc.AcceptText()
- ll_row = dw_uc.GetRow()
- IF ll_row <= 0 THEN
- MessageBox('系统提示','请选择目标单据')
- RETURN
- END IF
- IF MessageBox('确定','是否确定批计算本次应收金额?',question!, yesno!) = 2 THEN RETURN
- lde_takeamt = dw_uc.Object.bmstamt[ll_row]
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- lde_takeamt -= lde_not_takeamt
- END IF
- NEXT
- IF lde_takeamt < 0 THEN lde_takeamt = 0
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- lde_ttakeamt_add = lde_not_takeamt
- // lde_takeamt -= lde_ttakeamt_add
- ELSE
- lde_ttakeamt_add = Min(lde_takeamt, lde_not_takeamt)
- lde_takeamt -= lde_ttakeamt_add
- END IF
- dw_child.Object.ttakeamt[i] = lde_ttakeamt_add
- NEXT
- end event
- event ue_p_tzqamt();Long i, ll_row
- Decimal lde_zqamt, lde_not_takeamt , lde_tzqamt_add
- dw_uc.AcceptText()
- ll_row = dw_uc.GetRow()
- IF ll_row <= 0 THEN
- MessageBox('系统提示','请选择目标单据')
- RETURN
- END IF
- IF MessageBox('确定','是否确定批计算本次应收金额?',question!, yesno!) = 2 THEN RETURN
- lde_zqamt = dw_uc.Object.u_bmstamt_zqamt[ll_row]
- IF lde_zqamt < 0 THEN lde_zqamt = 0
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- lde_tzqamt_add = 0
- ELSE
- lde_tzqamt_add = Min(lde_zqamt, lde_not_takeamt)
- lde_zqamt -= lde_tzqamt_add
- END IF
- dw_child.Object.tzqamt[i] = lde_tzqamt_add
- NEXT
- end event
- event ue_set_zqamt();Long i, ll_row
- Decimal lde_zqamt, lde_not_takeamt , lde_ttakeamt_add, lde_tzqamt_add, lde_zqamt_add
- dw_uc.AcceptText()
- dw_child.AcceptText()
- ll_row = dw_uc.GetRow()
- IF ll_row <= 0 THEN
- MessageBox('系统提示','请选择目标单据')
- RETURN
- END IF
- IF MessageBox('确定','是否确定计算余额作为折扣金额?',question!, yesno!) = 2 THEN RETURN
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- lde_ttakeamt_add = dw_child.Object.ttakeamt[i]
- IF lde_ttakeamt_add >= lde_not_takeamt THEN
- lde_tzqamt_add = 0
- ELSE
- lde_tzqamt_add = lde_not_takeamt - lde_ttakeamt_add
- lde_zqamt_add += lde_tzqamt_add
- END IF
- dw_child.Object.tzqamt[i] = lde_tzqamt_add
- NEXT
- dw_uc.Object.u_bmstamt_zqamt[ll_row] = lde_zqamt_add
- end event
- event ue_p_cmpl();Long i, ll_row
- Decimal lde_takeamt, lde_not_takeamt , lde_ttakeamt_add
- Decimal lde_zqamt, lde_tzqamt_add, lde_zqamt_add
- dw_uc.AcceptText()
- ll_row = dw_uc.GetRow()
- IF ll_row <= 0 THEN
- MessageBox('系统提示','请选择目标单据')
- RETURN
- END IF
- IF MessageBox('确定','是否确定分配收款且余款作为折扣金额?',question!, yesno!) = 2 THEN RETURN
- lde_takeamt = dw_uc.Object.bmstamt[ll_row]
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- lde_takeamt -= lde_not_takeamt
- END IF
- NEXT
- IF lde_takeamt < 0 THEN lde_takeamt = 0
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- lde_ttakeamt_add = lde_not_takeamt
- // lde_takeamt -= lde_ttakeamt_add
- ELSE
- lde_ttakeamt_add = Min(lde_takeamt, lde_not_takeamt)
- lde_takeamt -= lde_ttakeamt_add
- END IF
- dw_child.Object.ttakeamt[i] = lde_ttakeamt_add
- NEXT
- FOR i = 1 To dw_child.RowCount()
- lde_not_takeamt = dw_child.Object.msttakeamt[i] - dw_child.Object.takeamt[i]
- IF lde_not_takeamt < 0 THEN
- dw_child.Object.tzqamt[i] = 0
- CONTINUE
- END IF
-
- lde_ttakeamt_add = dw_child.Object.ttakeamt[i]
- IF lde_ttakeamt_add >= lde_not_takeamt THEN
- lde_tzqamt_add = 0
- ELSE
- lde_tzqamt_add = lde_not_takeamt - lde_ttakeamt_add
- lde_zqamt_add += lde_tzqamt_add
- END IF
- dw_child.Object.tzqamt[i] = lde_tzqamt_add
- NEXT
- dw_uc.Object.u_bmstamt_zqamt[ll_row] = lde_zqamt_add
- end event
- event ue_fj_view();IF dw_edit_mode THEN
- MessageBox('提示','编辑状态下不可用',information!,OK!)
- RETURN
- END IF
- 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 = 561 //
- s_pic.f_string = dw_pageretr.Object.u_bmstamt_bacode[ls_row]
- s_pic.g_long = dw_pageretr.Object.u_bmstamt_baid[ls_row]
- s_pic.e_long = dw_pageretr.Object.u_bmstamt_scid[ls_row]
- s_pic.sqltransaction = sys_filedb_sqlca
- OpenWithParm(w_fj_bill_view,s_pic)
- end event
- event ue_fj_edit();IF dw_edit_mode THEN
- MessageBox('提示','编辑状态下不可用',information!,OK!)
- RETURN
- END IF
- //IF NOT f_power_ind(1098) THEN
- // MessageBox(publ_operator,sys_msg_pow)
- // RETURN
- //END IF
- 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 = 561 //
- s_pic.f_string = dw_pageretr.Object.u_bmstamt_bacode[ls_row]
- s_pic.g_long = dw_pageretr.Object.u_bmstamt_baid[ls_row]
- s_pic.e_long = dw_pageretr.Object.u_bmstamt_scid[ls_row]
- s_pic.sqltransaction = sys_filedb_sqlca
- OpenWithParm(w_fj_bill_mng,s_pic)
- end event
- public function integer wf_refresh_curuc (long arg_billid);IF arg_billid <= 0 OR IsNull(arg_billid) THEN RETURN 0
- Long uc_row
- uc_row = dw_pageretr.GetRow()
- IF uc_row <= 0 THEN RETURN 0
- Long scid
- String sptcode
- Long accountid
- DateTime BaDate
- Decimal Bmstamt, zqamt
- String dscrp
- Long cusid
- String BaCode
- Int flag
- DateTime opdate
- String opemp
- String Name
- String auditemp
- DateTime auditdate
- Long Baid
- String BaRep
- Long moneyid
- Long itemid
- String itemcode
- String itemname
- String accountsname
- String moneyname
- String confirmemp
- DateTime confirmdate
- Int confirmflag
- Long relid
- Long banktypeid
- Decimal mrate
- DateTime viewdate
- string relcode
- string fpcode
- long secflag
- string secemp
- datetime secdate
- long acmoneyid
- string rep
- string bankstr
- string idcode
- string ls_dscrp
- string accountrep
- SELECT u_Bmstamt.scid,
- u_spt.sptcode,
- u_Bmstamt.accountid,
- u_Bmstamt.BaDate,
- u_Bmstamt.Bmstamt,
- u_Bmstamt.zqamt,
- u_Bmstamt.dscrp,
- u_Bmstamt.cusid,
- u_Bmstamt.BaCode,
- u_Bmstamt.flag,
- u_Bmstamt.opdate,
- u_Bmstamt.opemp,
- u_spt.name,
- u_Bmstamt.auditemp,
- u_Bmstamt.auditdate,
- u_Bmstamt.Baid,
- u_Bmstamt.BaRep,
- u_Bmstamt.moneyid,
- u_Bmstamt.mrate,
- u_Bmstamt.viewdate,
- u_Bmstamt.banktypeid,
- u_Bmstamt.itemid,
- u_itemdef.itemcode,
- u_itemdef.itemname,
- u_accounts.accountsname,
- cw_currency.name,
- u_Bmstamt.relid,
- u_Bmstamt.confirmemp,
- u_Bmstamt.confirmdate,
- u_Bmstamt.confirmflag,
- u_Bmstamt.relcode,
- u_Bmstamt.fpcode,
- u_Bmstamt.secflag,
- u_Bmstamt.secemp,
- u_Bmstamt.secdate,
- u_accounts.moneyid,
- u_spt.rep,
- u_accounts.bankstr,
- u_accounts.idcode,
- u_accounts.dscrp,
- u_accounts.accountrep
- INTO :scid,
- :sptcode,
- :accountid,
- :BaDate,
- :Bmstamt,
- :zqamt,
- :dscrp,
- :cusid,
- :BaCode,
- :flag,
- :opdate,
- :opemp,
- :Name,
- :auditemp ,
- :auditdate,
- :Baid,
- :BaRep,
- :moneyid,
- :mrate,
- :viewdate,
- :banktypeid,
- :itemid,
- :itemcode,
- :itemname,
- :accountsname,
- :moneyname,
- :relid,
- :confirmemp,
- :confirmdate,
- :confirmflag,
- :relcode,
- :fpcode,
- :secflag,
- :secemp,
- :secdate,
- :acmoneyid,
- :rep,
- :bankstr,
- :idcode,
- :ls_dscrp,
- :accountrep
- FROM u_Bmstamt LEFT OUTER JOIN u_itemdef
- ON u_Bmstamt.itemid = u_itemdef.itemid LEFT OUTER JOIN u_accounts
- ON u_Bmstamt.accountid = u_accounts.accountsid LEFT OUTER JOIN cw_currency
- ON u_Bmstamt.moneyid = cw_currency.moneyid LEFT OUTER JOIN u_spt
- ON u_Bmstamt.cusid = u_spt.sptid
- WHERE ( u_Bmstamt.Baid = :arg_billid );
-
- IF sqlca.SQLCode <> 0 THEN
- MessageBox('错误',"查询单据操作失败"+sqlca.SQLErrText,stopsign!,ok!)
- RETURN 0
- END IF
- dw_pageretr.SetRedraw(FALSE)
- dw_pageretr.Object.u_Bmstamt_scid[uc_row] = scid
- dw_pageretr.Object.u_spt_sptcode[uc_row] = sptcode
- dw_pageretr.Object.u_Bmstamt_accountid[uc_row] = accountid
- dw_pageretr.Object.u_Bmstamt_BaDate[uc_row] = BaDate
- dw_pageretr.Object.u_Bmstamt_Bmstamt[uc_row] = Bmstamt
- dw_pageretr.Object.u_Bmstamt_zqamt[uc_row] = zqamt
- dw_pageretr.Object.u_Bmstamt_dscrp[uc_row] = dscrp
- dw_pageretr.Object.u_Bmstamt_cusid[uc_row] = cusid
- dw_pageretr.Object.u_Bmstamt_BaCode[uc_row] = BaCode
- dw_pageretr.Object.u_Bmstamt_flag[uc_row] = flag
- dw_pageretr.Object.u_Bmstamt_opemp[uc_row] = opemp
- dw_pageretr.Object.u_Bmstamt_opdate[uc_row] = opdate
- dw_pageretr.Object.u_Bmstamt_auditemp[uc_row] = auditemp
- dw_pageretr.Object.u_Bmstamt_auditemp[uc_row] = auditemp
- dw_pageretr.Object.u_Bmstamt_auditdate[uc_row] = auditdate
- dw_pageretr.Object.u_Bmstamt_moneyid[uc_row] = moneyid
- dw_pageretr.Object.u_Bmstamt_mrate[uc_row] = mrate
- dw_pageretr.Object.u_Bmstamt_viewdate[uc_row] = viewdate
- dw_pageretr.Object.u_Bmstamt_banktypeid[uc_row] = banktypeid
- dw_pageretr.Object.u_Bmstamt_BaRep[uc_row] = BaRep
- dw_pageretr.Object.u_itemdef_itemcode[uc_row] = itemcode
- dw_pageretr.Object.u_itemdef_itemname[uc_row] = itemname
- dw_pageretr.Object.u_Bmstamt_itemid[uc_row] = itemid
- dw_pageretr.Object.u_accounts_accountsname[uc_row] = accountsname
- dw_pageretr.Object.cw_currency_name[uc_row] = moneyname
- dw_pageretr.Object.u_Bmstamt_confirmemp[uc_row] = confirmemp
- dw_pageretr.Object.u_Bmstamt_confirmdate[uc_row] = confirmdate
- dw_pageretr.Object.u_Bmstamt_confirmflag[uc_row] = confirmflag
- dw_pageretr.Object.u_Bmstamt_relid[uc_row] = relid
- dw_pageretr.Object.u_Bmstamt_Baid[uc_row] = arg_billid
- dw_pageretr.Object.u_spt_name[uc_row] = name
- dw_pageretr.Object.u_spt_rep[uc_row] = rep
- dw_pageretr.Object.u_Bmstamt_relcode[uc_row] = relcode
- dw_pageretr.Object.u_accounts_moneyid[uc_row] = acmoneyid
- dw_pageretr.Object.u_Bmstamt_fpcode[uc_row] = fpcode
- dw_pageretr.Object.u_Bmstamt_secflag[uc_row] = secflag
- dw_pageretr.Object.u_Bmstamt_secemp[uc_row] = secemp
- dw_pageretr.Object.u_Bmstamt_secdate[uc_row] = secdate
- dw_pageretr.Object.u_accounts_bankstr[uc_row] = bankstr
- dw_pageretr.Object.u_accounts_idcode[uc_row] = idcode
- dw_pageretr.Object.u_accounts_dscrp[uc_row] = ls_dscrp
- dw_pageretr.Object.u_accounts_accountrep[uc_row] = accountrep
- dw_pageretr.SetRedraw(TRUE)
- dw_uc.Reset()
- dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!)
- wf_flagstatus_rf()
- RETURN 1
- end function
- public function integer wf_flagstatus_rf ();//wf_flagstatus_rf
- Long pagerert_row
- Int li_flag,li_confirmflag,li_secflag
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = FALSE
- cur_flag = -1
- cur_secflag = -1
- GOTO ext
- END IF
- li_flag = dw_pageretr.Object.u_Bmstamt_flag[pagerert_row]
- li_secflag = dw_pageretr.Object.u_Bmstamt_secflag[pagerert_row]
- li_confirmflag = dw_pageretr.Object.u_Bmstamt_confirmflag[pagerert_row]
- IF dw_edit_mode THEN
- cb_auditing.Text = '审核&F'
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = FALSE
- ELSE
- IF sys_option_msttake_takeamt_secaudit = 0 THEN
- cb_auditing.Text = '审核&F'
- cb_auditing_cancel.Text = '撤审'
-
- IF li_flag = 0 THEN
- cb_auditing.Enabled = TRUE
- cb_auditing_cancel.Enabled = FALSE
- ELSEIF li_flag = 1 THEN
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = TRUE
- END IF
- ELSE
-
- IF li_flag = 0 THEN
- cb_auditing.Text = '初审&F'
- cb_auditing_cancel.Text = '初撤'
- cb_auditing.Enabled = TRUE
- cb_auditing_cancel.Enabled = FALSE
- ELSEIF li_flag = 1 AND li_secflag = 0 THEN
- cb_auditing.Text = '终审&F'
- cb_auditing_cancel.Text = '初撤'
- cb_auditing.Enabled = TRUE
- cb_auditing_cancel.Enabled = TRUE
- ELSEIF li_flag = 1 AND li_secflag = 1 THEN
- cb_auditing.Text = '终审&F'
- cb_auditing_cancel.Text = '终撤'
- cb_auditing.Enabled = FALSE
- cb_auditing_cancel.Enabled = TRUE
- END IF
- END IF
- END IF
- cb_auditing.TriggerEvent('ue_textchange')
- cb_auditing_cancel.TriggerEvent('ue_textchange')
- ext:
- RETURN 0
- end function
- public function integer wf_check_mx_amt (long arg_row, ref string arg_msg);Int rslt = 1
- dw_child.AcceptText()
- IF dw_child.Object.ttakeamt[arg_row] < 0 THEN
- rslt = 0
- arg_msg = '第' + String(arg_row) + '行本次付款金额小于0'
- GOTO ext
- END IF
- IF dw_child.Object.ttakeamt[arg_row] > dw_child.Object.untakeamt[arg_row] THEN
- rslt = 0
- arg_msg = '第' + String(arg_row) + '行本次付款金额 大于 未付金额'
- GOTO ext
- END IF
- ext:
- RETURN rslt
- end function
- public subroutine wf_autodetail ();
- If Not dw_edit_mode Then Return
- Long child_row ,i
- Long ll_cusid, ll_scid, ll_moneyid
- Dec ld_bmstamt,ld_total_take
- dw_uc.AcceptText()
- If dw_uc.GetRow() = 0 Then Return
- ll_scid = dw_uc.Object.scid[dw_uc.GetRow()]
- ll_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
- If IsNull(ll_cusid) Or ll_cusid = 0 Then
- This.TriggerEvent("ue_f9")
- ll_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
- If IsNull(ll_cusid) Or ll_cusid = 0 Then
- MessageBox('提示','请选择供应商', Information!, OK! )
- Return
- End If
- End If
- ll_moneyid = dw_uc.Object.u_Bmstamt_moneyid[dw_uc.GetRow()]
- If ll_moneyid = 0 Then
- MessageBox('提示','请选择币种', Information!, OK! )
- Return
- End If
- ld_bmstamt = dw_uc.Object.bmstamt[dw_uc.GetRow()]
- If IsNull(ld_bmstamt) Or ld_bmstamt = 0 Then
- MessageBox('提示','请填写金额', Information!, OK! )
- Return
- End If
- If sys_option_scid_msttake_mstpay = 1 Then
- Else
- ll_scid = -1
- End If
- Int li_flag = 0
- ld_total_take = ld_bmstamt
- For child_row = 1 To dw_child.RowCount()
- If li_flag = 1 Then
- dw_child.Object.ttakeamt[child_row] = 0
- Else
- If ld_total_take <= 0 Then Exit
- If ld_total_take > dw_child.Object.msttakeamt[child_row] - dw_child.Object.takeamt[child_row] Then
- dw_child.Object.ttakeamt[child_row] = dw_child.Object.msttakeamt[child_row] - dw_child.Object.takeamt[child_row]
- ld_total_take = ld_total_take - (dw_child.Object.msttakeamt[child_row] - dw_child.Object.takeamt[child_row])
- Else
- dw_child.Object.ttakeamt[child_row] = ld_total_take
- ld_total_take = 0
- li_flag = 1
- End If
-
- End If
- Next
- If ld_total_take <= 0 Then Return
- child_row = dw_child.GetRow()
- Int ll_findrow = 0
- ds_autodetail.Retrieve(ll_scid,ll_cusid)
- For i = 1 To ds_autodetail.RowCount()
-
- If ld_total_take <= 0 Then Exit
-
- ll_findrow = dw_child.Find("billcode='"+String(ds_autodetail.Object.billcode[i])+"'",1,dw_child.RowCount())
- If ll_findrow > 0 Then
- Continue
- End If
- If dw_child.GetRow() > 0 Then
- If dw_child.Object.takeid[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.takeid[child_row] = ds_autodetail.Object.billid[i]
-
- dw_child.Object.billcode [child_row] = ds_autodetail.Object.billcode[i]
- dw_child.Object.relcode[child_row] = ds_autodetail.Object.part[i]
- dw_child.Object.takedate[child_row] = ds_autodetail.Object.takedate[i]
-
- dw_child.Object.msttakeamt[child_row] = ds_autodetail.Object.msttakeamt[i]
- dw_child.Object.takeamt[child_row] = ds_autodetail.Object.takeamt[i]
-
- If ld_total_take > ds_autodetail.Object.msttakeamt[i] - ds_autodetail.Object.takeamt[i] Then
- dw_child.Object.ttakeamt[child_row] = ds_autodetail.Object.msttakeamt[i] - ds_autodetail.Object.takeamt[i]
- Else
- dw_child.Object.ttakeamt[child_row] = ld_total_take
- End If
- ld_total_take = ld_total_take - ds_autodetail.Object.msttakeamt[i] + ds_autodetail.Object.takeamt[i]
-
- Next
- dw_child.SetColumn('ttakeamt')
- dw_child.SetFocus()
- This.TriggerEvent('ue_allowedit')
- end subroutine
- on w_sptamt_other.create
- int iCurrent
- call super::create
- this.ddlb_status=create ddlb_status
- this.ddlb_scid=create ddlb_scid
- this.st_3=create st_3
- this.st_2=create st_2
- this.cbx_2=create cbx_2
- this.cbx_1=create cbx_1
- iCurrent=UpperBound(this.Control)
- this.Control[iCurrent+1]=this.ddlb_status
- this.Control[iCurrent+2]=this.ddlb_scid
- this.Control[iCurrent+3]=this.st_3
- this.Control[iCurrent+4]=this.st_2
- this.Control[iCurrent+5]=this.cbx_2
- this.Control[iCurrent+6]=this.cbx_1
- end on
- on w_sptamt_other.destroy
- call super::destroy
- destroy(this.ddlb_status)
- destroy(this.ddlb_scid)
- destroy(this.st_3)
- destroy(this.st_2)
- destroy(this.cbx_2)
- destroy(this.cbx_1)
- end on
- 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_Bmstamt.BaCode like '%"+Trim(sle_usual_query.Text)+"%')"
- ELSE
- ls_querystrpart = "(u_Bmstamt.BaCode 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 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+'( u_Bmstamt_BaCode like "%'+trim(sle_usual_query.text)+'%" )'
- else
- obj_expr=obj_expr+'( u_Bmstamt_BaCode 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 close;call super::close;destroy uo_take
- end event
- event open;call super::open;uc_column_int = 15 //uc dw前6列可以编辑
- child_column_int = 6
- uo_take = CREATE uo_sptamt_other
- ds_autodetail = create datastore
- ds_autodetail.dataobject='ds_mstpay_other'
- ds_autodetail.SetTransObject(sqlca)
- IF s_tran.d_long = 1 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
- String arg_msg
- cb_add.TriggerEvent(Clicked!)
- IF dw_uc.GetRow() > 0 THEN
- IF s_tran.e_long > 0 THEN
- String ls_cuscode,ls_cusname
- SELECT cuscode,name
- INTO :ls_cuscode,:ls_cusname
- FROM u_cust
- Where cusid = :s_tran.e_long;
- IF sqlca.SQLCode = 0 THEN
- dw_uc.Object.cusid[dw_uc.GetRow()] = s_tran.e_long
- dw_uc.Object.u_cust_name[dw_uc.GetRow()] = ls_cusname
- dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()] = ls_cuscode
- END IF
- END IF
- END IF
- END IF
- end event
- event refresh_interface;call super::refresh_interface;ddlb_status.Enabled = NOT dw_edit_mode
- ddlb_scid.Enabled = NOT dw_edit_mode
- cb_auditing.Enabled = NOT dw_edit_mode
- cb_auditing_cancel.Enabled = NOT dw_edit_mode
- end event
- 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
- datawindowchild childdw
- dw_uc.SetTransObject (sqlca)
- dw_uc.GetChild("accountid",childdw)
- childdw.SetTransObject (sqlca)
- IF childdw.Retrieve(sys_user_account) = 0 THEN
- childdw.InsertRow(0)
- END IF
- Int li_ifspttype
- IF sys_power_issuper THEN
- li_ifspttype = 0
- ELSE
- li_ifspttype = 1
- END IF
- dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数
- dw_pageretr.Retrieve(cur_scid,cur_flag,cur_secflag,cur_confirmflag,li_ifspttype,sys_user_spttype)
- 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_f9;call super::ue_f9;//用于选择明细内容,被F9[默认]
- IF Not dw_edit_mode THEN RETURN
- Long uc_row
- uc_row = dw_uc.GetRow()
- IF uc_row = 0 THEN
- MessageBox('提示','请选定进仓单!',information!,ok!)
- RETURN
- END IF
- dw_uc.AcceptText()
- IF NOT IsValid(w_spt_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_spt_sptcode[dw_uc.GetRow()]))
-
- OpenWithParm(w_spt_edit,s_ch_tran) //调用
-
- s_spt S_INSCUST
- S_INSCUST = Message.PowerObjectParm //接受返回结构
-
- IF S_INSCUST.sptid > 0 THEN //正常返回值则可以取以下值
- dw_uc.SetRedraw(False)
- dw_uc.Object.cusid[uc_row] = S_INSCUST.sptid
- dw_uc.Object.u_spt_sptcode[uc_row] = S_INSCUST.sptcode
- dw_uc.Object.u_spt_name[uc_row] = S_INSCUST.Name
- // dw_uc.Object.u_Bmstamt_BaRep[uc_row] = S_INSCUST.bsntype
- dw_uc.Object.u_spt_rep[uc_row] = S_INSCUST.rep
-
- dw_uc.Object.u_bmstamt_banktypeid[uc_row] = S_INSCUST.dftbanktypeid
- dw_uc.Object.u_bmstamt_moneyid[uc_row] = S_INSCUST.dftmoneyid
- dw_uc.Object.u_bmstamt_mrate[uc_row] = f_get_mrate(S_INSCUST.dftmoneyid)
-
- dw_uc.SetRedraw(True)
- dw_uc.SetColumn("BaDate")
- END IF
- END IF
- end event
- event ue_viewprint;call super::ue_viewprint;
- 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 Not f_power_ind(ls_powerid) THEN
- // MessageBox(publ_operator,'你没有使用权限!')
- // RETURN
- // END IF
-
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.u_Bmstamt_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(1881) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
-
- LS_PRMSG.obj_dwNAME = 'dw_rp_sptamt_other'
- 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 = 2
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_Bmstamt_Baid[LS_ROW]
- LS_PRMSG.rowcnt = dw_child.RowCount()
- OpenWithParm(w_publ_preview,LS_PRMSG)
- //**更新打印次料
- String arg_msg
- printnum = Message.DoubleParm
- Long ll_scid
- ll_scid = dw_pageretr.Object.u_Bmstamt_scid[dw_pageretr.GetRow()]
- f_update_printnum('u_Bmstamt',printnum,ll_scid,dw_pageretr.Object.u_Bmstamt_Baid[LS_ROW],'','',arg_msg,True)
- end event
- event ue_print;call super::ue_print;//--直接打印
- 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 Not f_power_ind(ls_powerid) THEN
- // MessageBox(publ_operator,'你没有使用权限!')
- // RETURN
- // END IF
-
- IF li_auditprint = 1 THEN
- IF dw_pageretr.Object.u_Bmstamt_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(1881) THEN
- MessageBox('提示','你没有使用权限!',information!,OK!)
- RETURN
- END IF
-
- LS_PRMSG.obj_dwNAME = 'dw_rp_sptamt_other'
- END IF
- IF LS_PRMSG.obj_dwNAME = '' THEN RETURN
- LS_PRMSG.retr_pram_falg = 2
- LS_PRMSG.printrow = ll_prownum
- LS_PRMSG.TAG_TEXT = This.Title
- LS_PRMSG.FILTER_STRING = ''
- LS_PRMSG.PAGECH_FLAG = 0
- LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_Bmstamt_Baid[LS_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 = 1
- Long ll_scid
- ll_scid = dw_pageretr.Object.u_Bmstamt_scid[dw_pageretr.GetRow()]
- f_update_printnum('u_Bmstamt',printnum,ll_scid,dw_pageretr.Object.u_Bmstamt_Baid[LS_ROW],'','',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_response) 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_response,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_Bmstamt_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
- event resize;
- ln_bar.EndX = THIS.Width
- ln_bar2.EndX = THIS.Width
- ln_1.EndX = THIS.Width
- ln_2.EndX = THIS.Width
- r_bar.Width = THIS.Width
- Long w_width,w_height
- w_width = 4500
- w_height = 2100
- IF newwidth < w_width THEN THIS.Width = w_width
- IF newheight < w_height THEN THIS.Height = w_height
- //dw_child.Width = THIS.Width - (w_width - dw_child_w)
- //dw_child.Height = THIS.Height - (w_height - dw_child_h)
- //dw_pageretr.Width = THIS.Width - (w_width - dw_pageretr_w)
- //==============================================================================
- //YYX081007
- //==============================================================================
- IF uc_width > 0 THEN
- dw_uc.Width = uc_width
- END IF
- IF uc_height > 0 THEN
- dw_uc.Height = uc_height
- END IF
- dw_pageretr.X = dw_uc.X + dw_uc.Width
- dw_pageretr.Y = dw_uc.Y
- dw_pageretr.Width = THIS.Width - dw_pageretr.X - 40
- dw_pageretr.Height = dw_uc.Height
- //dw_child.Y = dw_uc.Y + dw_uc.Height - 10
- //dw_child.Width = THIS.Width - dw_child.X - 40
- //dw_child.Height = THIS.Height - dw_child.Y - 100
- this.triggerevent('resize_p')
- end event
- event retrieve_childdw;call super::retrieve_childdw;Long row,uc_relid
- row = dw_pageretr.GetRow()
- IF row > 0 THEN
- uc_relid = dw_pageretr.Object.u_Bmstamt_Baid[row]
- dw_child.SetRedraw (FALSE)
- dw_child.Retrieve(uc_relid)
- dw_child.SetRedraw (TRUE)
- ELSE
- dw_child.Reset()
- END IF
- 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.u_Bmstamt_flag[row] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
- RETURN
- END IF
- END IF
- s_rpt_print_msg s_print
- s_print.retr_pram_falg = 2
- 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_pramnmb = dw_pageretr.Object.u_Bmstamt_Baid[row]
- s_print.rowcnt = dw_child.RowCount()
- OpenWithParm(w_rpt_preview,s_print)
- //**更新打印次料
- String arg_msg
- printnum = Message.DoubleParm
- String ls_code
- ll_scid = 0
- ls_code = dw_pageretr.Object.u_Bmstamt_BaCode[row]
- f_update_printnum('u_Bmstamt',printnum,ll_scid,dw_pageretr.Object.u_Bmstamt_Baid[ROW],'','',arg_msg,TRUE)
- //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
- 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.u_Bmstamt_flag[row] = 0 THEN
- MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!)
- RETURN
- END IF
- END IF
- IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN
- LS_PRMSG.retr_pram_falg = 2
- 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_pramnmb = dw_pageretr.Object.u_Bmstamt_Baid[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
- String ls_code
- ll_scid = 0
- ls_code = dw_pageretr.Object.u_Bmstamt_BaCode[row]
- f_update_printnum('u_Bmstamt',printnum,ll_scid,dw_pageretr.Object.u_Bmstamt_Baid[ROW],'','',arg_msg,TRUE)
- //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE)
- end event
- event ue_addzy;call super::ue_addzy;IF NOT f_power_ind(1760) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- String arg_msg = '',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_take.add_dscrp(dw_pageretr.Object.u_Bmstamt_Baid[uc_row],LS_STR,arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,information!,ok!)
- RETURN
- ELSE
- MessageBox('提示','添加备注操作成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[uc_row])
- END IF
- end event
- event ue_f8;call super::ue_f8;//用于选择明细内容,被F8[默认]\dw_child.doubleclicked调用
- IF Not dw_edit_mode THEN RETURN
- Long child_row
- Long ll_cusid, ll_scid, ll_moneyid
- dw_uc.AcceptText()
- IF dw_uc.GetRow() = 0 THEN RETURN
- ll_scid = dw_uc.Object.scid[dw_uc.GetRow()]
- ll_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
- IF IsNull(ll_cusid) Or ll_cusid = 0 THEN
- This.TriggerEvent("ue_f9")
- ll_cusid = dw_uc.Object.cusid[dw_uc.GetRow()]
- IF IsNull(ll_cusid) Or ll_cusid = 0 THEN
- MessageBox('提示','请选择供应商', Information!, OK! )
- RETURN
- END IF
- END IF
- ll_moneyid = dw_uc.Object.u_Bmstamt_moneyid[dw_uc.GetRow()]
- IF ll_moneyid = 0 THEN
- MessageBox('提示','请选择币种', Information!, OK! )
- RETURN
- END IF
- child_row = dw_child.GetRow()
- IF Not IsValid(w_mstpay_other_ch) THEN
- s_edit_index_tran s_tranf8 //传递参数使用
- s_tranf8.if_retrieve_all = False //是否一次RETRIEVE所有行
- s_tranf8.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
- s_tranf8.arg_pkid = ll_cusid //目标定位PKID (备用)
- s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
- s_tranf8.if_select_all = True //多选
-
- s_tranf8.b_long = ll_scid //分部
- s_tranf8.c_long = ll_cusid //客户
- s_tranf8.d_long = ll_moneyid //币种
-
- Long chc = 1,ls_j
- IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.billcode[dw_child.GetRow()])
- OpenWithParm(w_mstpay_other_ch,s_tranf8) //调用
-
- s_bmsttake_arr S_INSCUST
- S_INSCUST = Message.PowerObjectParm //接受返回结构
- FOR ls_j = 1 To UpperBound(S_INSCUST.takeid)
- IF S_INSCUST.takeid[ls_j] > 0 THEN //正常返回值则可以取以下值
-
- IF dw_child.GetRow() > 0 THEN
- IF dw_child.Object.takeid[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.takeid[child_row] = S_INSCUST.takeid[ls_j]
-
- // dw_child.Object.billid [child_row] = S_INSCUST.billid[ls_j]
- dw_child.Object.billcode [child_row] = S_INSCUST.billcode[ls_j]
- dw_child.Object.relcode[child_row] = S_INSCUST.relcode[ls_j]
- dw_child.Object.takedate[child_row] = S_INSCUST.takedate[ls_j]
-
- dw_child.Object.msttakeamt[child_row] = S_INSCUST.msttakeamt[ls_j]
- dw_child.Object.takeamt[child_row] = S_INSCUST.takeamt[ls_j]
-
-
- dw_child.Object.ttakeamt[child_row] = S_INSCUST.msttakeamt[ls_j] - S_INSCUST.takeamt[ls_j]
-
-
- // dw_child.Object.zqamt[child_row] = S_INSCUST.zqamt[ls_j]
- END IF
-
- NEXT
- dw_child.SetColumn('ttakeamt')
- dw_child.SetFocus()
- This.TriggerEvent('ue_allowedit')
- END IF
- end event
- event ue_f10;call super::ue_f10;//用于选择明细内容,被F10[默认]
- If Not dw_edit_mode Then Return
- Long uc_row
- Long ll_rst_accountsid,ll_accountid,ll_moneyid,ll_moneyid_account
- uc_row = dw_uc.GetRow()
- If uc_row = 0 Then
- MessageBox('系统提示','请选定单据!')
- Return
- End If
- dw_uc.AcceptText()
- If Not IsValid(w_accounts_ch) Then
- s_edit_index_tran s_ch_tran //传递参数使用
- s_ch_tran.if_retrieve_all = True //是否一次retrieve所有行
- s_ch_tran.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式
- s_ch_tran.arg_pkid = 0 //目标定位pkid (备用)
- s_ch_tran.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选
-
-
- OpenWithParm(w_accounts_ch,s_ch_tran) //调用
-
-
- ll_rst_accountsid = Message.DoubleParm //接受返回结构
-
- If ll_rst_accountsid > 0 Then //正常返回值则可以取以下值
- dw_uc.SetRedraw(False)
-
- ll_moneyid = dw_uc.Object.u_bmstamt_moneyid[uc_row]
- dw_uc.Object.accountid[uc_row] = ll_rst_accountsid
-
- Select moneyid Into :ll_moneyid_account
- From u_accounts
- Where accountsid = :ll_rst_accountsid;
- If sqlca.SQLCode <> 0 Then
- ll_moneyid_account = 0
- Return
- End If
-
- dw_uc.Object.u_accounts_moneyid[uc_row] = ll_moneyid_account
- If ll_moneyid = ll_moneyid_account Then
- dw_uc.Object.u_bmstamt_mrate[uc_row] = 1
- Else
- dw_uc.Object.u_bmstamt_mrate[dw_uc.GetRow()] = f_get_mrate(ll_moneyid)
- End If
- dw_uc.SetColumn("accountid")
- dw_uc.SetRedraw(True)
- End If
- End If
- end event
- type cb_func from w_publ_1ton_share_detail`cb_func within w_sptamt_other
- end type
- type cb_exit from w_publ_1ton_share_detail`cb_exit within w_sptamt_other
- end type
- type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_sptamt_other
- integer x = 197
- integer width = 549
- end type
- type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_sptamt_other
- integer x = 3378
- integer width = 142
- end type
- type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_sptamt_other
- integer x = 3077
- end type
- type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_sptamt_other
- event dwnkey pbm_dwnkey
- integer x = 1829
- integer width = 1719
- integer height = 1664
- string dataobject = "dw_sptamt_other_index"
- boolean rbutton_filter_use = true
- boolean titleclick_sort_use = true
- end type
- event dw_pageretr::dwnkey;call super::dwnkey;//int i = 0
- end event
- 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_sptamt_other
- integer x = 14
- end type
- type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_sptamt_other
- integer x = 3520
- end type
- type dw_uc from w_publ_1ton_share_detail`dw_uc within w_sptamt_other
- integer width = 1819
- integer height = 1656
- string dataobject = "dw_sptamt_other_edit"
- end type
- event dw_uc::dwnkey;Parent.TriggerEvent('user_key')
- IF Key = KeyDownArrow! THEN RETURN 1
- IF dw_edit_mode THEN
-
- IF Key = KeyEnter! THEN
- IF dw_uc.GetColumnName ( ) = 'dscrp' THEN
- // dw_child.ScrollToRow(1)
- // dw_child.SetFocus()
- // dw_child.SetColumn ('ttakeamt')
- // RETURN 1
- ELSEIF dw_uc.GetColumnName ( ) = 'u_spt_sptcode' THEN
- String ls_code,ls_name,ls_rep
- Long ls_sptid
-
- dw_uc.AcceptText()
- ls_code = Upper(Trim(dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()]))
- SELECT sptid, name, rep
- INTO :ls_sptid,:ls_name, :ls_rep
- FROM u_spt
- Where (sptcode = :ls_code);
-
- IF sqlca.SQLCode <> 0 THEN
- Parent.TriggerEvent('ue_f9')
- RETURN 1
- ELSE
- dw_uc.SetRedraw(False)
- dw_uc.Object.cusid[dw_uc.GetRow()] = ls_sptid
- dw_uc.Object.u_spt_name[dw_uc.GetRow()] = ls_name
- dw_uc.Object.u_spt_rep[dw_uc.GetRow()] = ls_rep
- dw_uc.SetRedraw(True)
- dw_uc.SetColumn("u_Bmstamt_banktypeid")
- RETURN 1
- END IF
- ELSEIF dw_uc.GetColumnName ( ) = 'u_itemdef_itemcode' 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_Bmstamt_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! and dw_uc.GetColumnName ( ) <> 'dscrp' 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 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')
- ElseIf dwo.Name = 'accountid' Then
- Parent.TriggerEvent('ue_f10')
- Else
- Parent.TriggerEvent('ue_f9')
- End If
- End If
- end event
- event dw_uc::itemchanged;call super::itemchanged;IF Not dw_edit_mode THEN RETURN
- This.AcceptText()
- Long ll_moneyid_account,ll_moneyid
- Long ll_accountid
- IF dwo.Name = 'accountid' THEN
- This.SetRedraw(False)
- // THIS.Object.accountid[row] > 0
- ll_accountid = This.Object.accountid[row]
- ll_moneyid = This.Object.u_Bmstamt_moneyid[row]
-
-
- SELECT moneyid INTO :ll_moneyid_account
- FROM u_accounts
- Where accountsid = :ll_accountid;
- IF sqlca.SQLCode <> 0 THEN
- ll_moneyid_account = 0
- RETURN
- END IF
-
- This.Object.u_accounts_moneyid[row] = ll_moneyid_account
-
- IF ll_moneyid = 0 THEN
- This.Object.u_Bmstamt_moneyid[row] = ll_moneyid_account
- ll_moneyid = ll_moneyid_account
- END IF
-
- // IF ll_moneyid = ll_moneyid_account THEN
- // THIS.Object.u_Bmstamt_mrate[row] = 1
- // ELSE
- This.Object.u_Bmstamt_mrate[row] = f_get_mrate(ll_moneyid)
- // END IF
-
- This.SetRedraw(True)
- ELSEIF dwo.Name = 'u_Bmstamt_moneyid' THEN
- ll_moneyid = This.Object.u_Bmstamt_moneyid[row]
- This.Object.u_Bmstamt_mrate[row] = f_get_mrate(ll_moneyid)
- elseif dwo.name = 'u_bmstamt_banktypeid' then
- //elseif dwo.name = 'bmstamt' then
- // if cbx_1.checked = true then wf_autodetail()
- END IF
- //If (dwo.Name = 'u_Bmstamt_moneyid' OR dwo.Name = 'accountid') AND THIS.Object.accountid[row] > 0 THEN
- // THIS.SetRedraw(FALSE)
- //
- // ll_accountid = THIS.Object.accountid[row]
- // ll_moneyid = THIS.Object.u_Bmstamt_moneyid[row]
- //
- //
- // SELECT moneyid INTO :ll_moneyid_account
- // FROM u_accounts
- // Where accountsid = :ll_accountid;
- // IF sqlca.SQLCode <> 0 THEN
- // ll_moneyid_account = 0
- // RETURN
- // END IF
- //
- // THIS.Object.u_accounts_moneyid[row] = ll_moneyid_account
- //
- //// if ll_moneyid = 0 then
- //// THIS.Object.u_Bmstamt_moneyid[row] = ll_moneyid_account
- //// ll_moneyid = ll_moneyid_account
- //// end if
- //
- // IF ll_moneyid = ll_moneyid_account THEN
- // THIS.Object.u_Bmstamt_mrate[row] = 1
- // ELSE
- // THIS.Object.u_Bmstamt_mrate[dw_uc.GetRow()] = f_get_mrate(ll_moneyid)
- // END IF
- //
- // THIS.SetRedraw(TRUE)
- //END IF
- end event
- event dw_uc::buttonclicked;call super::buttonclicked;IF dw_edit_mode AND row > 0 THEN
- END IF
- end event
- type gb_2 from w_publ_1ton_share_detail`gb_2 within w_sptamt_other
- integer x = 1358
- integer y = 332
- integer width = 311
- integer height = 1104
- end type
- type dw_child from w_publ_1ton_share_detail`dw_child within w_sptamt_other
- boolean visible = false
- integer y = 1960
- integer width = 3131
- integer height = 332
- string title = "付款对单明细内容"
- string dataobject = "dw_sptamt_other_mx_edit"
- end type
- type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_sptamt_other
- end type
- type cb_print from w_publ_1ton_share_detail`cb_print within w_sptamt_other
- end type
- type cb_add from w_publ_1ton_share_detail`cb_add within w_sptamt_other
- end type
- event cb_add::clicked;IF Not f_power_ind(1874) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- String arg_msg = ''
- Long uc_row, i, ll_printid
- s_bmstamtmx s_mx
- dec{4} sumamt
- 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.BaDate[uc_row] > DateTime(2000-01-01,Now()) THEN
- MessageBox('提示','不合理日期',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('BaDate')
- RETURN
- END IF
-
-
- IF dw_uc.Object.accountid[uc_row] = 0 THEN
- MessageBox('提示','请选择帐号!',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('accountid')
- RETURN
- END IF
-
- IF dw_uc.Object.u_Bmstamt_banktypeid[uc_row] = 0 THEN
- MessageBox('提示','请选择结算方式!',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('u_Bmstamt_banktypeid')
- RETURN
- END IF
-
- IF dw_uc.Object.u_Bmstamt_moneyid[uc_row] = 0 THEN
- MessageBox('提示','请选择币种!',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('u_Bmstamt_moneyid')
- RETURN
- END IF
-
- IF Trim(dw_uc.Object.u_Bmstamt_BaRep[uc_row]) = '' THEN
- MessageBox('提示','请输入经手人!',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('u_Bmstamt_BaRep')
- RETURN
- END IF
-
-
- IF dw_uc.Object.cusid[uc_row] = 0 THEN
- MessageBox('提示','请选择供应商!',information!,ok!)
- dw_uc.SetFocus()
- dw_uc.SetColumn('u_cust_cuscode')
- RETURN
- END IF
- //if cbx_1.checked = true then wf_autodetail()
- //
- // FOR i = 1 To dw_child.RowCount()
- // IF wf_check_mx_amt(i,arg_msg) = 0 THEN
- // MessageBox('提示',arg_msg)
- //
- // RETURN
- // END IF
- // NEXT
-
- uo_take.scid = dw_uc.Object.scid[uc_row]
- uo_take.accountid = dw_uc.Object.accountid[uc_row]
- uo_take.cusid = dw_uc.Object.cusid[uc_row]
- uo_take.Bmstamt = dw_uc.Object.Bmstamt[uc_row]
- uo_take.zqamt = dw_uc.Object.u_Bmstamt_zqamt[uc_row]
- uo_take.dscrp = Trim(dw_uc.Object.dscrp[uc_row])
- uo_take.BaDate = dw_uc.Object.BaDate[uc_row]
- uo_take.banktypeid = dw_uc.Object.u_Bmstamt_banktypeid[uc_row]
- uo_take.itemid = dw_uc.Object.u_Bmstamt_itemid[uc_row]
- uo_take.moneyid = dw_uc.Object.u_Bmstamt_moneyid[uc_row]
- uo_take.mrate = dw_uc.Object.u_Bmstamt_mrate[uc_row]
- uo_take.BaRep = Trim(dw_uc.Object.u_Bmstamt_BaRep[uc_row])
- uo_take.viewdate = dw_uc.Object.u_Bmstamt_viewdate[uc_row]
- uo_take.relcode = dw_uc.Object.u_Bmstamt_relcode[uc_row]
- uo_take.fpcode = dw_uc.Object.u_Bmstamt_fpcode[uc_row]
- uo_take.billtype = 3
-
- // FOR i = 1 To dw_child.RowCount()
- // IF dw_child.Object.takeid[i] > 0 THEN
- // //ll_printid ++
- // s_mx.printid = i //只做行数记录,不是保存的db的printid
- // s_mx.takeid = dw_child.Object.takeid[i]
- // s_mx.billcode = dw_child.Object.billcode[i]
- // s_mx.relcode = dw_child.Object.relcode[i]
- // s_mx.msttakeamt = dw_child.Object.msttakeamt[i]
- // s_mx.takeamt = dw_child.Object.takeamt[i]
- // s_mx.zqamt = dw_child.Object.zqamt[i]
- // s_mx.ttakeamt = dw_child.Object.ttakeamt[i]
- // s_mx.tzqamt = dw_child.Object.tzqamt[i]
- // s_mx.relid = dw_child.Object.relid[i]
- // s_mx.relprintid = dw_child.Object.relprintid[i]
- // s_mx.mxdscrp = dw_child.Object.mxdscrp[i]
- // s_mx.takedate = dw_child.Object.takedate[i]
- //
- // sumamt = s_mx.ttakeamt +sumamt
- //
- // IF uo_take.acceptmx(s_mx,arg_msg) = 0 THEN
- // MessageBox('错误',arg_msg,stopsign!,ok!)
- // RETURN
- // END IF
- // END IF
- // NEXT
- //
- // if sumamt<>uo_take.Bmstamt then
- // IF MessageBox ("询问","主表金额不等于明细金额汇总,是否继续保存?",Question!,YesNo! ) = 2 THEN
- // RETURN
- // END IF
- // end if
-
- IF uo_take.Save(arg_msg,True) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- RETURN
- END IF
- //MessageBox('提示','保存操作成功!',information!,ok!)
- //write ini
- f_SetProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_Bmstamt_moneyid[dw_uc.GetRow()]))
- f_SetProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",String(dw_uc.Object.u_Bmstamt_banktypeid[dw_uc.GetRow()]))
- f_SetProfileString (sys_empid,dw_uc.DataObject, "itemid",String(dw_uc.Object.u_Bmstamt_itemid[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(uo_take.Baid)
- ELSE
- IF uo_take.newbegin(cur_scid,arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- RETURN
- END IF
- END IF
- CALL Super::Clicked
- IF dw_edit_mode THEN
- Parent.TriggerEvent("insert_childrow")
- String ls_moneyid,ls_banktype, ls_itemid
-
- ls_moneyid = f_ProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0')
- ls_banktype = f_ProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",'0')
- ls_itemid = f_ProfileString (sys_empid,dw_uc.DataObject, "itemid",'0')
- dw_uc.SetRedraw(False)
- dw_uc.Object.u_Bmstamt_moneyid[dw_uc.GetRow()] = Long(ls_moneyid)
- dw_uc.Object.u_Bmstamt_mrate[dw_uc.GetRow()] = f_get_mrate(Long(ls_moneyid))
- dw_uc.Object.u_Bmstamt_banktypeid[dw_uc.GetRow()] = Long(ls_banktype)
- dw_uc.Object.scid[dw_uc.GetRow()] = cur_scid
- dw_uc.Object.u_Bmstamt_itemid[dw_uc.GetRow()] = Long(ls_itemid)
- dw_uc.Object.u_itemdef_itemcode[dw_uc.GetRow()] = f_get_itemcode(Long(ls_itemid))
- dw_uc.Object.u_itemdef_itemname[dw_uc.GetRow()] = f_get_itemname(Long(ls_itemid))
- dw_uc.Object.u_Bmstamt_BaRep[dw_uc.GetRow()] = publ_operator
- dw_uc.SetColumn("u_Bmstamt_relcode")
- 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_sptamt_other
- end type
- event cb_edit::clicked;IF NOT f_power_ind(1875) 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_take.updatebegin(dw_pageretr.Object.u_Bmstamt_scid[uc_row],dw_pageretr.Object.u_Bmstamt_Baid[uc_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- RETURN
- END IF
-
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[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_sptamt_other
- end type
- event cb_delet::clicked;call super::clicked;IF Not f_power_ind(1876) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- 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_take.del(cur_scid,dw_pageretr.Object.u_Bmstamt_Baid[uc_row],arg_msg) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- //日志
- Long ls_id
- String ls_code
- ls_id = dw_pageretr.Object.u_Bmstamt_Baid[uc_row]
- ls_code = dw_pageretr.Object.u_Bmstamt_BaCode[uc_row]
- f_setsysoplog('供应商付款结算单','删除,id:'+String(ls_id)+',code:'+ls_code,arg_msg,True)
- //--
-
- MessageBox('提示','删除单据'+String(dw_pageretr.Object.u_Bmstamt_BaCode[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_sptamt_other
- 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_update_spt"
- menustr=menustr + "|" + "Text=-"
- menustr = menustr + "|" + "Text=确认~tEvent=ue_confirm"
- menustr = menustr + "|" + "Text=反确认~tEvent=ue_confirm_cancel"
- menustr += "|" + "Text=-"
- menustr += "|" + "Text=查看附件~tEvent=ue_fj_view"
- 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_sptamt_other
- end type
- event cb_auditing::clicked;call super::clicked;
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,ok!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要审核当前单据?",question!,yesno! ) = 2 THEN RETURN
- IF sys_option_msttake_takeamt_secaudit = 0 OR &
- sys_option_msttake_takeamt_secaudit = 1 AND dw_pageretr.Object.u_Bmstamt_flag[pagerert_row] = 0 THEN
- IF NOT f_power_ind(1877) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF uo_take.auditing(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','审核成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- ELSE
- IF NOT f_power_ind(1880) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF uo_take.secauditing(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],publ_operator,arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','二级审核成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- END IF
- end event
- type cb_xm from w_publ_1ton_share_detail`cb_xm within w_sptamt_other
- end type
- event cb_xm::clicked;is_mx_menustr = ''
- is_mx_menustr = is_mx_menustr + "|" + "Text=分配收款且余款作为折扣金额~tEvent=ue_p_cmpl"
- is_mx_menustr = is_mx_menustr + "|" + "Text=-"
- is_mx_menustr = is_mx_menustr + "|" + "Text=分配收款~tEvent=ue_p_ttakeamt"
- is_mx_menustr = is_mx_menustr + "|" + "Text=余款作为折扣金额~tEvent=ue_set_zqamt"
- call super::clicked
- //is_mx_menustr = is_mx_menustr + "|" + "Text=明细物料图片查看~tEvent=ue_fj_view"
- end event
- type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_sptamt_other
- end type
- type cb_xls from w_publ_1ton_share_detail`cb_xls within w_sptamt_other
- end type
- type cb_help from w_publ_1ton_share_detail`cb_help within w_sptamt_other
- end type
- type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_sptamt_other
- end type
- event cb_auditing_cancel::clicked;call super::clicked;
- IF dw_edit_mode THEN RETURN
- String arg_msg = ''
- Long pagerert_row
- pagerert_row = dw_pageretr.GetRow()
- IF pagerert_row <= 0 THEN
- MessageBox('提示','请选定当前目标单据!',information!,ok!)
- RETURN
- END IF
- IF MessageBox ("询问","是否确定要撤消审核当前单据?",question!,yesno! ) = 2 THEN RETURN
- IF sys_option_msttake_takeamt_secaudit = 0 OR &
- sys_option_msttake_takeamt_secaudit = 1 AND &
- dw_pageretr.Object.u_Bmstamt_flag[pagerert_row] = 1 AND &
- dw_pageretr.Object.u_Bmstamt_secflag[pagerert_row] = 0 THEN
- IF NOT f_power_ind(1878) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF uo_take.auditing_cancel(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],arg_msg,TRUE) = 0 THEN
- MessageBox('错误',arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','撤消审核成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- ELSE
- IF NOT f_power_ind(1880) THEN
- MessageBox('提示','你没有使用权限!',information!,ok!)
- RETURN
- END IF
- IF uo_take.c_secauditing(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row],arg_msg,TRUE) = 0 THEN
- MessageBox('错误','撤消二级审核失改,'+arg_msg,stopsign!,ok!)
- ELSE
- MessageBox('提示','撤消二级审核成功!',information!,ok!)
- wf_refresh_curuc(dw_pageretr.Object.u_Bmstamt_Baid[pagerert_row])
- END IF
- END IF
- end event
- type p_msg from w_publ_1ton_share_detail`p_msg within w_sptamt_other
- end type
- type p_help from w_publ_1ton_share_detail`p_help within w_sptamt_other
- end type
- type p_encl from w_publ_1ton_share_detail`p_encl within w_sptamt_other
- end type
- type p_other from w_publ_1ton_share_detail`p_other within w_sptamt_other
- end type
- type gb_3 from w_publ_1ton_share_detail`gb_3 within w_sptamt_other
- end type
- type ln_bar from w_publ_1ton_share_detail`ln_bar within w_sptamt_other
- integer beginx = 9
- integer endx = 3209
- end type
- type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_sptamt_other
- end type
- type r_bar from w_publ_1ton_share_detail`r_bar within w_sptamt_other
- integer x = 2935
- integer height = 148
- end type
- type ln_1 from w_publ_1ton_share_detail`ln_1 within w_sptamt_other
- end type
- type ln_2 from w_publ_1ton_share_detail`ln_2 within w_sptamt_other
- end type
- type ddlb_status from dropdownlistbox within w_sptamt_other
- integer x = 1577
- integer y = 188
- integer width = 393
- integer height = 400
- integer taborder = 10
- 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_confirmflag = -1
- cur_secflag = -1
- ELSEIF Index = 2 THEN
- cur_flag = 0
- cur_secflag = 0
- cur_confirmflag = -1
- ELSEIF Index = 3 THEN
- cur_flag = 1
- cur_secflag = 0
- cur_confirmflag = -1
- ELSEIF Index = 4 THEN
- cur_flag = -1
- cur_secflag = -1
- cur_confirmflag = 0
- ELSE
- cur_flag = 1
- cur_secflag = 1
- cur_confirmflag = 1
- END IF
- PARENT.TriggerEvent('retrieve_pageretr')
- end event
- type ddlb_scid from uo_ddlb_scid within w_sptamt_other
- integer x = 896
- integer y = 188
- integer width = 549
- integer height = 1120
- end type
- event constructor;call super::constructor;cur_scid=this.uo_scid
- end event
- event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid
- parent.triggerevent("retrieve_pageretr")
- end event
- type st_3 from statictext within w_sptamt_other
- integer x = 1403
- integer y = 204
- integer width = 165
- 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_sptamt_other
- integer x = 713
- integer y = 204
- integer width = 165
- 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 cbx_2 from checkbox within w_sptamt_other
- boolean visible = false
- integer x = 2144
- integer y = 200
- integer width = 905
- integer height = 56
- boolean bringtotop = true
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 33554432
- long backcolor = 134217739
- string text = "保存时根据明细自动计算单据金额"
- boolean checked = true
- end type
- event clicked;if this.checked then
- if_auto=1
- cbx_1.checked = false
- if_autodetail = 0
- else
- if_auto=0
- end if
- f_SetProfileString (sys_empid, 'w_sptamt_other', "if_auto", string(if_auto))
- f_SetProfileString (sys_empid, 'w_sptamt_other', "if_autodetail", string(if_autodetail))
-
- end event
- event constructor;if_auto=integer(f_ProfileString (sys_empid, 'w_sptamt_other', "if_auto", '1'))
- if if_auto=0 then
- this.checked=false
- else
- this.checked=true
- cbx_1.checked = false
- if_autodetail = 0
- end if
-
- end event
- type cbx_1 from checkbox within w_sptamt_other
- boolean visible = false
- integer x = 3067
- integer y = 200
- integer width = 905
- integer height = 56
- boolean bringtotop = true
- integer textsize = -9
- integer weight = 400
- fontcharset fontcharset = gb2312charset!
- fontpitch fontpitch = variable!
- string facename = "宋体"
- long textcolor = 33554432
- long backcolor = 134217739
- string text = "自动分配明细金额"
- end type
- event clicked;if this.checked then
- cbx_2.checked = false
- if_auto= 0
- if_autodetail=1
- else
- if_autodetail=0
- end if
- f_SetProfileString (sys_empid, 'w_sptamt_other', "if_autodetail", string(if_autodetail))
- f_SetProfileString (sys_empid, 'w_sptamt_other', "if_auto", string(if_auto))
- end event
- event constructor;if_autodetail=integer(f_ProfileString (sys_empid, 'w_sptamt_other', "if_autodetail", '1'))
- if if_autodetail=0 then
- this.checked=false
- else
- this.checked=true
- cbx_2.checked = false
- if_auto = 0
- end if
- end event
|