$PBExportHeader$w_wfjg_pk.srw forward global type w_wfjg_pk from w_publ_1ton_share_detail end type type ddlb_scid from uo_ddlb_scid within w_wfjg_pk end type type st_3 from statictext within w_wfjg_pk end type type st_2 from statictext within w_wfjg_pk end type type ddlb_status from dropdownlistbox within w_wfjg_pk end type end forward global type w_wfjg_pk from w_publ_1ton_share_detail string title = "外协商盘亏单" boolean maxbox = true windowstate windowstate = maximized! event insert_childrow ( ) event ue_p_jgdscrp ( ) ddlb_scid ddlb_scid st_3 st_3 st_2 st_2 ddlb_status ddlb_status end type global w_wfjg_pk w_wfjg_pk type variables Long cur_scid //分店ID Int cur_flag = -1 Int cur_secflag = -1 uo_inware_wfjg uo_ware uo_spt_price uo_sptprice Long cur_id = 0 Int cur_editfocus = 0 //1:新建2:修改 Long flag = 0 Long secflag = 0 String ol_cdw_str = '' long child_column_bef datastore ds_copypaste_in,ds_copypaste_out end variables forward prototypes public function integer wf_refresh_curuc (long arg_scid, long arg_inwareid) public function integer wf_flagstatus_rf () public function integer wf_check_print (ref string arg_msg) public function integer wf_bef_to_aft (ref string arg_msg) public function integer wf_xls_retrievedata (long arg_ationid, ref s_xls_billlist arg_str_billlist, ref uo_sendtoexcel arg_obj_st, ref string arg_msg) public function integer wf_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg) end prototypes event insert_childrow();Long li_row li_row = dw_child.InsertRow(0) dw_child.ScrollToRow(li_row) dw_child.SetColumn ('u_mtrldef_mtrlcode') end event event ue_p_jgdscrp();IF NOT dw_edit_mode THEN MessageBox('提示','非编辑状态下不可用') RETURN END IF Long ll_i dw_child.AcceptText() IF dw_child.RowCount() = 0 THEN RETURN FOR ll_i = 1 TO dw_child.RowCount() IF ll_i = 1 THEN CONTINUE dw_child.Object.ow_wfjgmx_in_bef_mxdscrp[ll_i] = dw_child.Object.ow_wfjgmx_in_bef_mxdscrp[1] NEXT end event public function integer wf_refresh_curuc (long arg_scid, long arg_inwareid);IF arg_inwareid <= 0 OR IsNull(arg_inwareid) THEN RETURN 0 Long uc_row uc_row = dw_pageretr.GetRow() IF uc_row <= 0 THEN RETURN 0 Long storageid DateTime indate String inrep String part String dscrp String inwarecode String sptname DateTime opdate String opemp String modemp DateTime moddate Int aflag DateTime Auditingdate String Auditingrep DateTime secAuditingdate String secAuditingrep String storagename Int thflag Int asecflag String sptcode Long sptid long balcflag, balcdateint,ll_printnum SELECT ow_wfjg_in.storageid, ow_wfjg_in.indate, ow_wfjg_in.inrep, ow_wfjg_in.part, ow_wfjg_in.dscrp, ow_wfjg_in.opdate, ow_wfjg_in.opemp, ow_wfjg_in.flag, ow_wfjg_in.auditingdate, ow_wfjg_in.auditingrep, ow_wfjg_in.secflag, ow_wfjg_in.secauditingdate, ow_wfjg_in.secauditingrep, ow_wfjg_in.inwarecode, ow_wfjg_in.sptname, ow_wfjg_in.modemp, ow_wfjg_in.moddate, ow_wfjg_in.thflag, u_spt.name, u_spt.sptcode, ow_wfjg_in.sptid, ow_wfjg_in.balcflag, ow_wfjg_in.balcdateint, ow_wfjg_in.printnum INTO :storageid, :indate, :inrep, :part, :dscrp, :opdate, :opemp, :aflag, :Auditingdate, :Auditingrep, :asecflag, :secAuditingdate, :secAuditingrep, :inwarecode, :sptname, :modemp, :moddate, :thflag, :sptname, :sptcode, :sptid, :balcflag, :balcdateint , :ll_printnum FROM ow_wfjg_in,u_spt WHERE ( ow_wfjg_in.inwareid = :arg_inwareid ) AND (ow_wfjg_in.sptid = u_spt.sptid ) And ( ow_wfjg_in.scid = :arg_scid ); IF sqlca.SQLCode <> 0 THEN MessageBox('系统提示',"查询操作失败(错误单据唯一码)"+sqlca.SQLErrText) RETURN 0 END IF dw_pageretr.Object.ow_wfjg_in_scid[uc_row] = arg_scid dw_pageretr.Object.inwareid[uc_row] = arg_inwareid dw_pageretr.Object.indate[uc_row] = indate dw_pageretr.Object.part[uc_row] = part dw_pageretr.Object.inrep[uc_row] = inrep dw_pageretr.Object.u_spt_name[uc_row] = sptname dw_pageretr.Object.dscrp[uc_row] = dscrp dw_pageretr.Object.inwarecode[uc_row] = inwarecode dw_pageretr.Object.opdate[uc_row] = opdate dw_pageretr.Object.ow_wfjg_in_opemp[uc_row] = opemp dw_pageretr.Object.ow_wfjg_in_moddate[uc_row] = moddate dw_pageretr.Object.ow_wfjg_in_modemp[uc_row] = modemp dw_pageretr.Object.flag[uc_row] = aflag dw_pageretr.Object.Auditingdate[uc_row] = Auditingdate dw_pageretr.Object.Auditingrep[uc_row] = Auditingrep dw_pageretr.Object.ow_wfjg_in_thflag[uc_row] = thflag dw_pageretr.Object.ow_wfjg_in_secAuditingdate[uc_row] = secAuditingdate dw_pageretr.Object.ow_wfjg_in_secAuditingrep[uc_row] = secAuditingrep dw_pageretr.Object.ow_wfjg_in_secflag[uc_row] = asecflag dw_pageretr.Object.u_spt_sptcode[uc_row] = sptcode dw_pageretr.Object.sptid[uc_row] = sptid dw_pageretr.Object.ow_wfjg_in_balcflag[uc_row] = balcflag dw_pageretr.Object.ow_wfjg_in_balcdateint[uc_row] = balcdateint dw_pageretr.Object.ow_wfjg_in_printnum[uc_row] = ll_printnum 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_flagstatus_rf ();//==================================================================== // Function: wf_flagstatus_rf() //-------------------------------------------------------------------- // Description: //-------------------------------------------------------------------- // Arguments:(None) //-------------------------------------------------------------------- // Returns: integer //-------------------------------------------------------------------- // Author: yyx Date: 2003.12.26 //-------------------------------------------------------------------- // Modify History: // //==================================================================== Long pagerert_row pagerert_row = dw_pageretr.GetRow() IF pagerert_row <= 0 THEN cb_auditing.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_check_print (ref string arg_msg);long cnt int rslt = 1 string ls_msg string str_dwSQl,str_SyntaxFromSQL datastore ds_maxid datetime ld_cur_dt ld_cur_dt = datetime(today(),time(0)) if sys_option_mustprint = 0 then rslt = 1 goto ext end if string ls_storagestr,tmp_str ls_storagestr = sys_user_storagestr if ls_storagestr <> '0' and ls_storagestr <> '-1' then ls_storagestr = mid(ls_storagestr,2) ls_storagestr = left(ls_storagestr,len(ls_storagestr) - 1 ) end if ds_maxid= create datastore str_dwSQl="select count(*) as countnum from u_inware where indate < '" +string(ld_cur_dt,'yyyy-mm-dd hh:mm:ss')+ "' and billtype = 1 and flag = 0 and " if pos(ls_storagestr,',') > 0 or long(ls_storagestr) > 0 then tmp_str = '(' + 'storageid in (' + ls_storagestr + '))' else tmp_str = '(' + ls_storagestr + ' = 0 or storageid in (' + ls_storagestr + '))' end if str_dwSQl=str_dwSQl + tmp_str //messagebox("",str_dwSQl) str_SyntaxFromSQL =sqlca.SyntaxFromSQL(str_dwSQl,"style(type=grid)",ls_msg) if ls_msg>'' then arg_msg="dw语法生成失败" rslt = 0 goto ext end if ds_maxid.Create(str_SyntaxFromSQL,ls_msg) if ls_msg>'' then arg_msg="建立相关DW失败" rslt=0 goto ext end if ds_maxid.settransobject(sqlca) ds_maxid.retrieve() cnt=ds_maxid.GetItemNumber(1,1) if isnull(cnt) then cnt = 0 destroy ds_maxid if cnt > 0 then arg_msg = '仓库还有收货单未打印,不能新建' rslt = 0 goto ext end if ext: return rslt end function public function integer wf_bef_to_aft (ref string arg_msg);Long rslt = 1 //IF NOT dw_edit_mode THEN // rslt = 0 // arg_msg = '非编辑状态不可用' // GOTO ext //END IF // //dw_bef.AcceptText() //Long ll_dw_bef_rowcount // //ll_dw_bef_rowcount = dw_bef.RowCount() //IF ll_dw_bef_rowcount <= 0 THEN // rslt = 0 // arg_msg = '没有可复制的明细内容' // GOTO ext //END IF // //IF ll_dw_bef_rowcount > 0 THEN // dw_aft.SetRedraw(FALSE) // dw_aft.Reset() // Long ls_i // FOR ls_i = 1 TO ll_dw_bef_rowcount // dw_aft.Object.ow_wfjgmx_in_aft_mtrlid[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_mtrlid[ls_i] // dw_aft.Object.u_mtrldef_mtrlcode[ls_i] = dw_bef.Object.u_mtrldef_mtrlcode[ls_i] // dw_aft.Object.u_mtrldef_mtrlname[ls_i] = dw_bef.Object.u_mtrldef_mtrlname[ls_i] // dw_aft.Object.u_mtrldef_mtrlmode[ls_i] = dw_bef.Object.u_mtrldef_mtrlmode[ls_i] // dw_aft.Object.u_mtrldef_mtrlsectype[ls_i] = dw_bef.Object.u_mtrldef_mtrlsectype[ls_i] // dw_aft.Object.u_mtrldef_zxmtrlmode[ls_i] = dw_bef.Object.u_mtrldef_zxmtrlmode[ls_i] // dw_aft.Object.u_mtrldef_unit[ls_i] = dw_bef.Object.u_mtrldef_unit[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_qty[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_qty[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_status[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_status[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_woodcode[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_woodcode[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_pcode[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_pcode[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_fprice[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_fprice[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_plancode[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_plancode[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_mxdscrp[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_mxdscrp[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_fprice[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_fprice[ls_i] // // dw_aft.Object.ow_wfjgmx_in_aft_unit[ls_i] = dw_bef.Object.u_mtrldef_unit[ls_i] // dw_aft.Object.ow_wfjgmx_in_aft_uqty[ls_i] = dw_bef.Object.ow_wfjgmx_in_bef_qty[ls_i] // // NEXT // // dw_aft.SetRedraw(TRUE) //END IF // // //dw_aft.AcceptText() // //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.ow_wfjg_in_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.ow_wfjg_in_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.ow_wfjgmx_in_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_wfjg_pk.create int iCurrent call super::create this.ddlb_scid=create ddlb_scid this.st_3=create st_3 this.st_2=create st_2 this.ddlb_status=create ddlb_status iCurrent=UpperBound(this.Control) this.Control[iCurrent+1]=this.ddlb_scid this.Control[iCurrent+2]=this.st_3 this.Control[iCurrent+3]=this.st_2 this.Control[iCurrent+4]=this.ddlb_status end on on w_wfjg_pk.destroy call super::destroy destroy(this.ddlb_scid) destroy(this.st_3) destroy(this.st_2) destroy(this.ddlb_status) 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 dw_uc.Retrieve() dw_pageretr.Retrieve(cur_scid,cur_flag,cur_secflag) 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+'( inwarecode LIKE "%'+trim(sle_usual_query.text)+'%" )' ELSE obj_expr=obj_expr+'( inwarecode LIKE "'+trim(sle_usual_query.text)+'" )' END IF end if dw_pageretr.setfilter(obj_expr) dw_pageretr.SetRedraw(False) dw_pageretr.filter() if dw_pageretr.rowcount()>=1 then dw_pageretr.selectrow(0,false) dw_pageretr.selectrow(1,true) end if dw_pageretr.SetRedraw(TRUE) end event event ue_usual_query_retr;call super::ue_usual_query_retr;string ls_querystrpart='' ls_newselect=lower(ori_oldselect) if trim(sle_usual_query.text)<>'' then if pos(trim(sle_usual_query.text),'%')=0 then ls_querystrpart="(ow_wfjg_in.inwarecode like '%"+trim(sle_usual_query.text)+"%')" else ls_querystrpart="(ow_wfjg_in.inwarecode like '"+trim(sle_usual_query.text)+"')" end if if Pos(ls_newselect," where ") <> 0 then ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')' else ls_newselect=ls_newselect+" where ("+ls_querystrpart+')' end if end if wf_retrieveuc(dw_pageretr,ls_newselect,1) this.triggerevent('retrieve_pageretr') end event event open;THIS.TriggerEvent('ue_before_open') wf_movetocenter() OLD_TITLE = THIS.Title s_tran = Message.PowerObjectParm IF NOT IsNull(s_tran) THEN retrieve_all = s_tran.if_retrieve_all mode = s_tran.work_mode arg_pkid = s_tran.arg_pkid arg_string_code = s_tran.arg_string_code if_sharedata = s_tran.if_sharedata //是否应用sharedata，当retrieve_all＝true是生效 ds_share = s_tran.ds_share END IF dw_pageretr.RBUTTON_FILTER_USE = TRUE //右键查询功能开关 dw_pageretr.titleclick_sort_use = TRUE //单击标题排序功能开关 dw_pageretr.SetTransObject (sqlca) pkcolumndbtname = wf_get_pkcolumndbtname(dw_pageretr) //取第一列为关键字 ori_oldselect = dw_pageretr.DESCRIBE("DataWindow.Table.Select") ls_newselect = ori_oldselect ds_curquery = CREATE DATASTORE ds_curquery.DataObject = 'd_extr_find' ds_curquery.SetTransObject (sqlca) wf_editindex_lockf() IF s_tran.d_long = 2 THEN cur_scid = s_tran.c_long Int li_item li_item = ddlb_scid.FindItem(s_tran.d_string,0) IF li_item > 0 THEN ddlb_scid.SelectItem(li_item) END IF END IF sle_usual_query.Text = Trim(arg_string_code) IF NOT retrieve_all THEN THIS.TriggerEvent("ue_usual_query_RETR") //修改ls_newselect,retrieve ELSE IF if_sharedata THEN ds_share.ShareData(dw_pageretr) ELSE wf_retrieveuc(dw_pageretr,ls_newselect,1) THIS.TriggerEvent('RETRIEVE_pageretr') END IF END IF IF retrieve_all THEN THIS.TriggerEvent("ue_usual_query_filt") END IF uc_column_int = 7 //uc dw前7列可以编辑 child_column_int = 4 //子dw前8列可以编辑 uo_ware = CREATE uo_inware_wfjg uo_ware.commit_transaction = sqlca uo_sptprice = CREATE uo_spt_price end event event refresh_interface;call super::refresh_interface;wf_flagstatus_rf() ddlb_status.enabled=not dw_edit_mode ddlb_scid.enabled=not dw_edit_mode end event event close;call super::close;destroy uo_ware destroy uo_sptprice end event event ue_f8;////用于选择明细内容,被f8[默认]\dw_aft.doubleclicked调用 //IF NOT dw_edit_mode THEN RETURN //Long child_row,cnt_childdw //Long ls_sptid //Dec ls_lastprice,ls_rebate // //s_edit_index_tran s_tranf8 //s_tranf8.if_retrieve_all = FALSE //s_tranf8.arg_pkid = 0 //s_tranf8.arg_string_code = '' //s_tranf8.b_long = 2 // //Long chc = 1,ls_j // // //child_row = dw_aft.GetRow() //cnt_childdw = dw_aft.RowCount() // //ls_sptid = dw_uc.Object.sptid[dw_uc.GetRow()] // //IF IsNull(ls_sptid) OR ls_sptid = 0 THEN // THIS.TriggerEvent("ue_f9") //END IF //IF NOT IsValid(w_mtrldef_edit) THEN // s_edit_index_tran s_ch_tran // s_ch_tran.if_retrieve_all = FALSE // s_ch_tran.work_mode = 1 // s_ch_tran.arg_pkid = 0 // s_ch_tran.arg_string_code = '' // s_ch_tran.b_long = 3 // s_ch_tran.c_long = -1 // s_ch_tran.f_long = -1 // s_ch_tran.if_select_all = TRUE // // dw_aft.AcceptText() // IF dw_aft.GetRow() > 0 THEN s_ch_tran.arg_string_code = Trim(dw_aft.Object.u_mtrldef_mtrlcode[dw_aft.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_aft.GetRow() > 0 THEN // IF dw_aft.Object.ow_wfjgmx_in_aft_mtrlid[child_row] <> 0 THEN // child_row = dw_aft.InsertRow (0) // ELSE // child_row = dw_aft.GetRow() // END IF // ELSE // child_row = dw_aft.InsertRow (0) // END IF // // dw_aft.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j] // dw_aft.Object.u_mtrldef_mtrlname[child_row] = s_inscust.mtrlname[ls_j] // dw_aft.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[ls_j] // dw_aft.Object.u_mtrldef_unit[child_row] = s_inscust.unit[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_mtrlid[child_row] = s_inscust.mtrlid[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_fprice[child_row] = s_inscust.planprice[ls_j] // dw_aft.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j] // dw_aft.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j] // dw_aft.Object.u_mtrldef_statusflag[child_row] = S_INSCUST.statusflag[ls_j] // dw_aft.Object.u_mtrldef_statustype[child_row] = S_INSCUST.statustype[ls_j] // dw_aft.Object.u_mtrldef_woodcodeflag[child_row] = S_INSCUST.woodcodeflag[ls_j] // dw_aft.Object.u_mtrldef_woodcodetype[child_row] = S_INSCUST.woodcodetype[ls_j] // dw_aft.Object.u_mtrldef_pcodeflag[child_row] = S_INSCUST.pcodeflag[ls_j] // dw_aft.Object.u_mtrldef_pcodetype[child_row] = S_INSCUST.pcodetype[ls_j] // // // Decimal ls_1stnewcost,ls_1stzqrate,ls_1strate // String arg_msg // String ls_1stunit,ls_jgdscrp // // ls_jgdscrp = dw_aft.Object.ow_wfjgmx_in_aft_jgdscrp[child_row] // // IF cur_editfocus = 1 THEN // IF uo_sptprice.uof_getmtrlsptprice(ls_sptid,s_inscust.mtrlid[ls_j],ls_1stunit,ls_jgdscrp,ls_1stnewcost,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN // dw_aft.Object.ow_wfjgmx_in_aft_jgprice[child_row] = s_inscust.mprice[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_rebate[child_row] = 1 // dw_aft.Object.ow_wfjgmx_in_aft_unit[child_row] = s_inscust.unit[ls_j] // ELSE // dw_aft.Object.ow_wfjgmx_in_aft_jgprice[child_row] = ls_1stnewcost // dw_aft.Object.ow_wfjgmx_in_aft_rebate[child_row] = ls_1stzqrate // dw_aft.Object.ow_wfjgmx_in_aft_unit[child_row] = ls_1stunit // END IF // ELSE // IF dw_aft.Object.ow_wfjgmx_in_aft_unit[child_row] = '' THEN // dw_aft.Object.ow_wfjgmx_in_aft_unit[child_row] = s_inscust.unit[ls_j] // END IF // END IF // dw_aft.setcolumn('ow_wfjgmx_in_aft_qty') // // END IF // NEXT //END IF // // //this.triggerevent('ue_allowedit') //dw_aft.SetRedraw(TRUE) //dw_aft.SetFocus() // // // end event event retrieve_childdw;call super::retrieve_childdw;Long row,uc_relid,uc_scid row = dw_pageretr.GetRow() IF row > 0 THEN uc_scid = dw_pageretr.Object.ow_wfjg_in_scid[row] uc_relid=dw_pageretr.object.inwareid[row] dw_child.SetRedraw (FALSE) dw_child.Retrieve(uc_scid,uc_relid) dw_child.SetRedraw (TRUE) ELSE dw_child.Reset() END IF 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('系统提示','请选定进仓单!') 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 (备用) //查询列(物料编码)部分内容,用于初步筛选 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.sptid[uc_row] = S_INSCUST.sptid dw_uc.Object.u_spt_name[uc_row] = S_INSCUST.Name dw_uc.Object.u_spt_sptcode[uc_row] = S_INSCUST.sptcode datetime ld_indate ld_indate = dw_uc.Object.indate[uc_row] dw_uc.Object.ow_wfjg_in_plandate[uc_row] = f_findspt_paydate(S_INSCUST.sptid,ld_indate) dw_uc.SetRedraw(TRUE) dw_uc.SetColumn("part") END IF END IF end event event ue_viewprint;call super::ue_viewprint; IF NOT f_power_ind(1429) THEN MessageBox('提示','你没有使用权限！',information!,OK!) RETURN END IF Long LS_ROW LS_ROW = dw_pageretr.GetRow() IF LS_ROW <= 0 THEN MessageBox('NO','没有打印目标单据!') 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('NO','目标单据还未审核,不能打印!') RETURN END IF END IF LS_PRMSG.obj_dwNAME = ls_newname ELSE IF Not f_power_ind(1429) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF LS_PRMSG.obj_dwNAME = '' 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.ow_wfjg_in_scid[LS_ROW] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.inwareid[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('ow_wfjg_in',printnum,dw_pageretr.Object.ow_wfjg_in_scid[LS_ROW],dw_pageretr.Object.inwareid[LS_ROW],'','',arg_msg,TRUE) end event event ue_f7;call super::ue_f7;//IF NOT dw_edit_mode THEN RETURN //Long child_row,ls_sptid,ls_j //child_row = dw_aft.GetRow() // //Int li_statusflag,li_woodcodeflag,li_pcodeflag //Long ll_statustype,ll_woodcodetype,ll_pcodetype //s_mtrldef_array arg_s_mtrldef // //ls_sptid = dw_uc.Object.sptid[dw_uc.GetRow()] //IF ls_sptid <= 0 THEN // MessageBox("系统提示","请先选择供应商") // RETURN //END IF // //s_edit_index_tran s_tranf8 //s_tranf8.if_retrieve_all = FALSE //s_tranf8.arg_pkid = 0 //s_tranf8.arg_string_code = '' //s_tranf8.b_long = 2 //s_tranf8.d_long = ls_sptid //s_tranf8.f_long = 0 // //IF NOT IsValid(w_inware_wfjg_ch) THEN // OpenWithParm(w_inware_wfjg_ch,s_tranf8) // // s_mtrldef_wfjg_array s_inscust // s_inscust = Message.PowerObjectParm //接受返回结构 // dw_aft.SetRedraw(FALSE) // FOR ls_j = 1 TO UpperBound(s_inscust.wfjgid) // IF s_inscust.wfjgid[ls_j] > 0 THEN //正常返回值则可以取以下值 // // IF dw_aft.GetRow() > 0 THEN // IF dw_aft.Object.ow_wfjgmx_in_aft_relid[child_row] <> 0 THEN // child_row = dw_aft.InsertRow (0) // ELSE // child_row = dw_aft.GetRow() // END IF // ELSE // child_row = dw_aft.InsertRow (0) // END IF // dw_aft.Object.ow_wfjgmx_in_aft_ifrel[child_row] = 1 // dw_aft.Object.ow_wfjgmx_in_aft_relid[child_row] = s_inscust.wfjgid[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_mtrlid[child_row] = s_inscust.mtrlid[ls_j] // dw_aft.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_relcode[child_row] = s_inscust.taskcode[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_jgprice[child_row] = s_inscust.price[ls_j] // dw_aft.Object.u_mtrldef_mtrlname[child_row] = s_inscust.mtrlname[ls_j] // dw_aft.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[ls_j] // dw_aft.Object.u_mtrldef_unit[child_row] = s_inscust.unit[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_qty[child_row] = s_inscust.qty[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_status[child_row] = s_inscust.status[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_sptid_cusid[child_row] = s_inscust.orderid[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_woodcode[child_row] = s_inscust.woodcode[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_pcode[child_row] = s_inscust.pcode[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_mxdscrp[child_row] = s_inscust.dscrp[ls_j] // // dw_aft.Object.u_mtrldef_mtrlsectype[child_row] = s_inscust.mtrlsectype[ls_j] // dw_aft.Object.u_mtrldef_zxmtrlmode[child_row] = s_inscust.zxmtrlmode[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_jgdscrp[child_row] = s_inscust.jgdscrp[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_relprintid[child_row] = s_inscust.printid[ls_j] // dw_aft.Object.ow_wfjgmx_in_aft_unit[child_row] = s_inscust.unit[ls_j] // // IF f_find_mtrl(s_inscust.mtrlcode[ls_j],-1,arg_s_mtrldef) = 0 THEN // li_statusflag = 0 // li_woodcodeflag = 0 // li_pcodeflag = 0 // ll_statustype = 0 // ll_woodcodetype = 0 // ll_pcodetype = 0 // ELSE // li_statusflag = arg_s_mtrldef.statusflag[1] // ll_statustype = arg_s_mtrldef.statustype[1] // li_woodcodeflag = arg_s_mtrldef.woodcodeflag[1] // ll_woodcodetype = arg_s_mtrldef.woodcodetype[1] // li_pcodeflag = arg_s_mtrldef.pcodeflag[1] // ll_pcodetype = arg_s_mtrldef.pcodetype[1] // END IF // // dw_aft.Object.u_mtrldef_statusflag[child_row] = li_statusflag // dw_aft.Object.u_mtrldef_statustype[child_row] = ll_statustype // dw_aft.Object.u_mtrldef_woodcodeflag[child_row] = li_woodcodeflag // dw_aft.Object.u_mtrldef_woodcodetype[child_row] = ll_woodcodetype // dw_aft.Object.u_mtrldef_pcodeflag[child_row] = li_pcodeflag // dw_aft.Object.u_mtrldef_pcodetype[child_row] = ll_pcodetype // // // END IF // NEXT // this.triggerevent('ue_allowedit') // dw_aft.SetColumn('u_mtrldef_mtrlcode') // dw_aft.SetRedraw(TRUE) //END IF // // // // // end event event ue_print;call super::ue_print;//--直接打印 IF NOT f_power_ind(1429) THEN MessageBox('提示','你没有使用权限！',information!,OK!) RETURN END IF uo_print_preview uo_print IF MessageBox ("IF","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN S_print_MSG LS_PRMSG Long LS_ROW LS_ROW = dw_pageretr.GetRow() IF LS_ROW <= 0 THEN MessageBox('NO','没有打印目标单据!') RETURN END IF IF ls_newname <> '' THEN IF li_auditprint = 1 THEN IF dw_pageretr.Object.flag[dw_pageretr.GetRow()] = 0 THEN MessageBox('NO','目标单据还未审核,不能打印!') RETURN END IF END IF LS_PRMSG.obj_dwNAME = ls_newname ELSE IF Not f_power_ind(1429) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF LS_PRMSG.obj_dwNAME = '' END IF IF LS_PRMSG.obj_dwNAME = '' THEN RETURN LS_PRMSG.printrow = ll_prownum LS_PRMSG.retr_pram_falg = 15 LS_PRMSG.TAG_TEXT = '外协商盘亏单' LS_PRMSG.FILTER_STRING = '' LS_PRMSG.PAGECH_FLAG = 0 LS_PRMSG.retr_scid = dw_pageretr.Object.ow_wfjg_in_scid[dw_pageretr.GetRow()] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.inwareid[dw_pageretr.GetRow()] LS_PRMSG.rowcnt = dw_child.RowCount() IF ifpic = 1 THEN String ls_msg IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN MessageBox('提示','下载图片失败!',information!,OK!) RETURN END IF END IF uo_print.FACT_PRINT_MSG = LS_PRMSG String arg_msg IF uo_print.uof_print_begin(arg_msg) = 0 THEN MessageBox("系统提示",arg_msg) 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('ow_wfjg_in',printnum,dw_pageretr.Object.ow_wfjg_in_scid[LS_ROW],dw_pageretr.Object.inwareid[LS_ROW],'','',arg_msg,TRUE) end event event ue_f11;call super::ue_f11;//用于选择明细内容,被F8[默认]\dw_child.doubleclicked调用 IF NOT dw_edit_mode THEN RETURN Long child_row,ins_sptid = 0 ins_sptid = dw_uc.Object.sptid[dw_uc.GetRow()] IF ins_sptid = 0 OR IsNull(ins_sptid) THEN MessageBox(publ_operator,'请先选择加工商') RETURN END IF child_row = dw_child.GetRow() IF NOT IsValid(w_sptware_sptid_ch) THEN s_edit_index_tran s_tranf8 //传递参数使用 s_tranf8.if_retrieve_all = FALSE //是否一次RETRIEVE所有行 s_tranf8.arg_pkid = 0 //目标定位PKID (备用) s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选 s_tranf8.b_long = - 1 //选择原料或产品 s_tranf8.d_long = ins_sptid s_tranf8.e_long = cur_scid s_tranf8.f_long =cur_scid Long chc = 1,ls_j dw_child.AcceptText() IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()]) OpenWithParm(w_sptware_sptid_ch,s_tranf8) //调用 s_sptware_array S_INSCUST S_INSCUST = Message.PowerObjectParm //接受返回结构 FOR ls_j = 1 TO UpperBound(S_INSCUST.mtrlwareid) IF S_INSCUST.mtrlwareid[ls_j] > 0 THEN IF dw_child.GetRow() > 0 THEN IF dw_child.Object.ow_wfjgmx_in_bef_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.ow_wfjgmx_in_bef_mtrlwareid[child_row] = S_INSCUST.mtrlwareid[ls_j] dw_child.Object.ow_wfjgmx_in_bef_mtrlid[child_row] = S_INSCUST.mtrlid[ls_j] dw_child.Object.u_mtrldef_mtrlcode[child_row] = S_INSCUST.u_mtrldef_mtrlcode[ls_j] dw_child.Object.u_mtrldef_mtrlname[child_row] = S_INSCUST.u_mtrldef_mtrlname[ls_j] dw_child.Object.u_mtrldef_mtrlmode[child_row] = S_INSCUST.u_mtrldef_mtrlmode[ls_j] dw_child.Object.u_mtrldef_unit[child_row] = S_INSCUST.u_mtrldef_unit[ls_j] dw_child.Object.u_mtrldef_mtrlsectype[child_row] = S_INSCUST.mtrlsectype[ls_j] dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = S_INSCUST.zxmtrlmode[ls_j] dw_child.Object.ow_wfjgmx_in_bef_qty[child_row] = S_INSCUST.noallocqty[ls_j] dw_child.Object.ow_wfjgmx_in_bef_fprice[child_row] = S_INSCUST.cost[ls_j] dw_child.Object.ow_wfjgmx_in_bef_plancode[child_row] = S_INSCUST.plancode[ls_j] dw_child.Object.ow_wfjgmx_in_bef_status[child_row] = S_INSCUST.status[ls_j] dw_child.Object.ow_wfjgmx_in_bef_woodcode[child_row] = S_INSCUST.woodcode[ls_j] dw_child.Object.ow_wfjgmx_in_bef_pcode[child_row] = S_INSCUST.pcode[ls_j] END IF NEXT dw_child.SetColumn('ow_wfjgmx_in_bef_qty') END IF end event event ue_addzy;call super::ue_addzy;IF NOT f_power_ind(1428) THEN MessageBox(publ_operator,'你没有使用权限！') 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('系统提示','请选定当前目标单据!') 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.ow_wfjg_in_scid[uc_row],dw_pageretr.object.inwareid[uc_row],ls_str,arg_msg)=0 then messagebox('error!',arg_msg) return else messagebox(publ_operator,'添加备注操作成功!') wf_refresh_curuc(dw_pageretr.object.ow_wfjg_in_scid[uc_row],dw_pageretr.object.inwareid[uc_row]) 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.flag[row] = 0 THEN MessageBox('NO','目标单据还未审核,不能打印!') 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.ow_wfjg_in_scid[row] s_print.retr_pramnmb = dw_pageretr.Object.inwareid[row] s_print.rowcnt = dw_child.RowCount() OpenWithParm(w_rpt_preview,s_print) //**更新打印次料 String arg_msg printnum = Message.DoubleParm String ls_code ll_scid = dw_pageretr.Object.ow_wfjg_in_scid[row] ls_code = dw_pageretr.Object.inwarecode[row] //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('系统信息','没有可打印的单据！') RETURN END IF IF ls_rpname = '' THEN RETURN IF li_auditprint = 1 THEN IF dw_pageretr.Object.flag[row] = 0 THEN MessageBox('NO','目标单据还未审核,不能打印!') RETURN END IF END IF IF MessageBox ("IF","是否确定要打印当前单据吗?",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.ow_wfjg_in_scid[row] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.inwareid[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) RETURN END IF uo_print.ds_print() //**更新打印次料 printnum = Message.DoubleParm String ls_code ll_scid = dw_pageretr.Object.ow_wfjg_in_scid[row] ls_code = dw_pageretr.Object.inwarecode[row] //f_update_printnum(ll_scid,ls_code,TRUE,printnum,arg_msg,TRUE) end event type cb_func from w_publ_1ton_share_detail`cb_func within w_wfjg_pk end type type cb_exit from w_publ_1ton_share_detail`cb_exit within w_wfjg_pk integer x = 2546 integer width = 142 end type type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_wfjg_pk integer width = 549 end type type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_wfjg_pk integer x = 3003 integer width = 142 end type type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_wfjg_pk integer x = 2702 end type type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_wfjg_pk integer x = 2007 integer width = 1531 integer height = 916 string dataobject = "dw_wfjg_pk_index" end type event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_flagstatus_rf() IF dw_edit_mode THEN RETURN IF currentrow <=0 THEN dw_child.reset() RETURN end if this.selectrow(0,false) this.selectrow(currentrow,true) DW_UC.SETROW(currentrow) DW_UC.ScrollToRow (currentrow) if not dw_edit_mode then parent.triggerevent('retrieve_childdw') end event type st_1 from w_publ_1ton_share_detail`st_1 within w_wfjg_pk integer x = 23 end type type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_wfjg_pk integer x = 3145 end type type dw_uc from w_publ_1ton_share_detail`dw_uc within w_wfjg_pk integer width = 2007 integer height = 912 string dataobject = "dw_wfjg_pk_edit" 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(dw_child.RowCount()) dw_child.SetColumn ('u_mtrldef_mtrlcode') RETURN 1 ELSEIF dw_uc.GetColumnName ( ) = 'u_spt_sptcode' And Key = KeyEnter! THEN String ls_code dw_uc.AcceptText() ls_code = Trim(dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()]) s_spt arg_s_spt IF f_find_spt(ls_code,arg_s_spt) = 0 THEN Parent.TriggerEvent('ue_f9') RETURN 1 ELSE dw_uc.SetRedraw(False) dw_uc.Object.sptid[dw_uc.GetRow()] = arg_s_spt.sptid dw_uc.Object.u_spt_sptcode[dw_uc.GetRow()] = arg_s_spt.sptcode dw_uc.Object.u_spt_name[dw_uc.GetRow()] = arg_s_spt.Name DateTime ld_indate ld_indate = dw_uc.Object.indate[dw_uc.GetRow()] dw_uc.Object.ow_wfjg_in_plandate[dw_uc.GetRow()] = f_findspt_paydate(arg_s_spt.sptid,ld_indate) dw_uc.SetRedraw(True) dw_uc.SetColumn("part") 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_spt' then parent.TRIGGEREVENT('ue_f9') end if end event type gb_2 from w_publ_1ton_share_detail`gb_2 within w_wfjg_pk integer x = 347 integer y = 400 integer width = 539 integer height = 168 end type type dw_child from w_publ_1ton_share_detail`dw_child within w_wfjg_pk integer y = 1216 integer width = 3529 integer height = 896 string dataobject = "dw_wfjgmx_pk_edit" end type event dw_child::doubleclicked;PARENT.TriggerEvent('ue_f11') end event type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_wfjg_pk integer x = 1902 end type type cb_print from w_publ_1ton_share_detail`cb_print within w_wfjg_pk integer x = 1710 end type type cb_add from w_publ_1ton_share_detail`cb_add within w_wfjg_pk end type event cb_add::clicked;IF NOT f_power_ind(1424) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF String arg_msg = '' Long uc_row,j IF NOT dw_edit_mode THEN IF wf_check_print(arg_msg) = 0 THEN MessageBox('系统提示',arg_msg) RETURN END IF END IF IF dw_edit_mode THEN dw_uc.AcceptText() dw_child.AcceptText() uc_row = dw_uc.GetRow() IF uc_row <= 0 THEN MessageBox('系统提示','请选定当前目标单据!') RETURN END IF IF NOT dw_uc.Object.indate[uc_row] > DateTime(2000-01-01,Now()) THEN MessageBox('系统提示','不合理发生时间!') dw_uc.SetFocus() dw_uc.SetColumn("indate") RETURN END IF IF NOT Len(String(dw_uc.Object.inrep[uc_row])) > 0 THEN MessageBox('系统提示','请填写经手人!') dw_uc.SetFocus() dw_uc.SetColumn("inrep") RETURN END IF uo_ware.indate = dw_uc.Object.indate[uc_row] uo_ware.inrep = dw_uc.Object.inrep[uc_row] uo_ware.part = dw_uc.Object.part[uc_row] uo_ware.dscrp = dw_uc.Object.dscrp[uc_row] uo_ware.sptid = dw_uc.Object.sptid[uc_row] uo_ware.thflag = 0 Long i FOR i = 1 TO dw_child.RowCount() IF dw_child.Object.ow_wfjgmx_in_bef_mtrlid[i] > 0 THEN IF uo_ware.acceptmx_bef(dw_child.Object.ow_wfjgmx_in_bef_mtrlwareid[i],& dw_child.Object.ow_wfjgmx_in_bef_qty[i],0,& dw_child.Object.ow_wfjgmx_in_bef_mxdscrp[i],& dw_child.Object.printid[i],& arg_msg,dw_child.Object.u_mtrldef_unit[i],dw_child.Object.ow_wfjgmx_in_bef_qty[i],1 ) = 0 THEN MessageBox('Error!',arg_msg) RETURN END IF END IF NEXT IF uo_ware.Save(TRUE,arg_msg) = 0 THEN MessageBox('Error!',arg_msg) RETURN END IF MessageBox(publ_operator,'保存操作成功!') 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.inwareid) //刷新uc ELSE IF uo_ware.newbegin(cur_scid,9,arg_msg) = 0 THEN MessageBox('Error!',arg_msg) RETURN END IF END IF CALL SUPER::Clicked //IF NOT dw_edit_mode THEN // Int li_row, li_cur_row // li_cur_row = dw_pageretr.GetRow() // li_row = dw_pageretr.InsertRow (li_cur_row) // dw_pageretr.ScrollToRow (li_row) // dw_child.Reset() // dw_uc.SetFocus() //END IF // //dw_edit_mode = NOT dw_edit_mode //wf_refresh_interface() // //read ini IF dw_edit_mode THEN PARENT.TriggerEvent("insert_childrow") cur_editfocus = 1 ELSE PARENT.TriggerEvent("retrieve_childdw") cur_editfocus = 0 END IF // THIS.TriggerEvent('refresh_interface') end event type cb_edit from w_publ_1ton_share_detail`cb_edit within w_wfjg_pk end type event cb_edit::clicked;IF NOT f_power_ind(1424) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF String arg_msg = '' Long uc_row uc_row = dw_pageretr.GetRow() IF uc_row <= 0 THEN MessageBox('系统提示','请选定当前目标单据!') RETURN END IF IF NOT dw_edit_mode THEN IF uo_ware.updatebegin(dw_pageretr.Object.ow_wfjg_in_scid[uc_row],dw_pageretr.Object.inwareid[uc_row],5,arg_msg) = 0 THEN MessageBox('Error!',arg_msg) RETURN END IF wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_in_scid[uc_row],dw_pageretr.Object.inwareid[uc_row]) PARENT.TriggerEvent("retrieve_childdw") PARENT.TriggerEvent("insert_childrow_out") parent.triggerevent('ue_allowedit') END IF CALL SUPER::Clicked IF dw_edit_mode THEN cur_editfocus = 2 ELSE cur_editfocus = 0 END IF end event type cb_delet from w_publ_1ton_share_detail`cb_delet within w_wfjg_pk integer width = 142 end type event cb_delet::clicked;call super::clicked;IF NOT f_power_ind(1425) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF String arg_msg = '' IF dw_edit_mode THEN RETURN Long uc_row uc_row = dw_pageretr.GetRow() IF uc_row <= 0 THEN MessageBox('系统提示','请选定当前目标单据!') RETURN END IF IF MessageBox ("if","是否确定要删除当前单据?",question!,yesno! ) = 2 THEN RETURN IF uo_ware.del(dw_pageretr.Object.ow_wfjg_in_scid[uc_row],dw_pageretr.Object.inwareid[uc_row],arg_msg,TRUE) = 0 THEN MessageBox('error!',arg_msg) ELSE //日志 Long ls_id String ls_code ls_id = dw_pageretr.Object.inwareid[uc_row] ls_code = dw_pageretr.Object.inwarecode[uc_row] f_setsysoplog('外协商盘亏单','外协商盘亏单删除,id:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE) //-- MessageBox(publ_operator,'删除单据'+String(dw_pageretr.Object.inwarecode[uc_row])+'成功!') 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_wfjg_pk integer x = 1170 integer width = 288 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_p_jgdscrp" 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_wfjg_pk integer x = 827 end type event cb_auditing::clicked;call super::clicked; IF NOT f_power_ind(1426) THEN MessageBox(publ_operator,'你没有使用权限！') RETURN END IF IF dw_edit_mode THEN RETURN String arg_msg = '' IF NOT KeyDown(KeyControl!) THEN Long pagerert_row pagerert_row = dw_pageretr.GetRow() IF pagerert_row <= 0 THEN MessageBox('系统提示','请选定当前目标单据!') RETURN END IF IF MessageBox ("if","是否确定要审核当前单据?",question!,yesno! ) = 2 THEN RETURN IF uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_in_scid[pagerert_row],dw_pageretr.Object.inwareid[pagerert_row],arg_msg) = 0 THEN MessageBox('error!',arg_msg) RETURN END IF IF uo_ware.auditing(TRUE,arg_msg) = 0 THEN MessageBox('error!',arg_msg) ELSE MessageBox(publ_operator,'审核成功!') wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_in_scid[pagerert_row],dw_pageretr.Object.inwareid[pagerert_row]) END IF ELSE IF MessageBox ("if","是否确定要批审核列表中未审核的单据?",question!,yesno! ) = 2 THEN RETURN Long ll_i,ll_billid Int li_flag Long ll_suc,ll_fail dw_pageretr.AcceptText() Open(w_sys_wait_jdt) //初始化进度条 w_sys_wait_jdt.Show() w_sys_wait_jdt.wf_accepttol(dw_pageretr.RowCount()) FOR ll_i = 1 TO dw_pageretr.RowCount() w_sys_wait_jdt.st_msg.Text = dw_pageretr.Object.inwarecode[ll_i] + " 正在审核..." //进度信息 li_flag = dw_pageretr.Object.flag[ll_i] IF li_flag = 1 THEN CONTINUE ll_billid = dw_pageretr.Object.inwareid[ll_i] IF uo_ware.getinfo(cur_scid,ll_billid,arg_msg) = 0 THEN ll_fail++ CONTINUE END IF IF uo_ware.auditing(TRUE,arg_msg) = 0 THEN ll_fail++ CONTINUE END IF ll_suc++ w_sys_wait_jdt.wf_inc(ll_i) //进度 NEXT Close(w_sys_wait_jdt) MessageBox(publ_operator,'批审核成功!成功:'+String(ll_suc)+',失败:'+String(ll_fail)) PARENT.TriggerEvent('retrieve_pageretr') END IF end event type cb_xm from w_publ_1ton_share_detail`cb_xm within w_wfjg_pk integer x = 1458 end type type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_wfjg_pk end type type cb_xls from w_publ_1ton_share_detail`cb_xls within w_wfjg_pk integer x = 2094 end type type cb_help from w_publ_1ton_share_detail`cb_help within w_wfjg_pk integer x = 2395 end type type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_wfjg_pk integer x = 1019 end type event cb_auditing_cancel::clicked;call super::clicked;IF NOT f_power_ind(1427) THEN MessageBox(publ_operator,'你没有使用权限！') 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('系统提示','请选定当前目标单据!') RETURN END IF IF MessageBox ("IF","是否确定要"+THIS.Text+"当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN IF uo_ware.getinfo(dw_pageretr.Object.ow_wfjg_in_scid[pagerert_row],dw_pageretr.Object.inwareid [pagerert_row],arg_msg) = 0 THEN MessageBox('Error!',arg_msg) RETURN END IF IF uo_ware.c_auditing(TRUE,arg_msg) = 0 THEN MessageBox('Error!',arg_msg) ELSE MessageBox(publ_operator,'撤审成功!') wf_refresh_curuc(dw_pageretr.Object.ow_wfjg_in_scid[pagerert_row],dw_pageretr.Object.inwareid[pagerert_row]) END IF end event type p_msg from w_publ_1ton_share_detail`p_msg within w_wfjg_pk end type type p_help from w_publ_1ton_share_detail`p_help within w_wfjg_pk end type type p_encl from w_publ_1ton_share_detail`p_encl within w_wfjg_pk end type type p_other from w_publ_1ton_share_detail`p_other within w_wfjg_pk end type type gb_3 from w_publ_1ton_share_detail`gb_3 within w_wfjg_pk end type type ln_bar from w_publ_1ton_share_detail`ln_bar within w_wfjg_pk end type type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_wfjg_pk end type type r_bar from w_publ_1ton_share_detail`r_bar within w_wfjg_pk end type type ln_1 from w_publ_1ton_share_detail`ln_1 within w_wfjg_pk end type type ln_2 from w_publ_1ton_share_detail`ln_2 within w_wfjg_pk end type type ddlb_scid from uo_ddlb_scid within w_wfjg_pk integer x = 887 integer y = 192 integer width = 549 integer height = 1120 integer taborder = 20 boolean bringtotop = true 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_wfjg_pk integer x = 1422 integer y = 204 integer width = 151 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_wfjg_pk integer x = 727 integer y = 204 integer width = 151 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 ddlb_status from dropdownlistbox within w_wfjg_pk integer x = 1586 integer y = 192 integer width = 370 integer height = 556 integer taborder = 40 boolean bringtotop = true integer textsize = -9 integer weight = 400 fontcharset fontcharset = gb2312charset! fontpitch fontpitch = variable! string facename = "宋体" long textcolor = 33554432 string text = "[全部]" boolean sorted = false string item[] = {"[全部]","待仓库审","待财务审","审核完毕"} borderstyle borderstyle = stylelowered! end type event selectionchanged;IF Index = 1 THEN cur_flag = -1 cur_secflag = -1 ELSEIF Index = 2 THEN cur_flag = 0 cur_secflag = 0 ELSEIF Index = 3 THEN cur_flag = 1 cur_secflag = 0 ELSEIF Index = 4 THEN cur_flag = 1 cur_secflag = 1 END IF PARENT.TriggerEvent('retrieve_pageretr') end event