$PBExportHeader$w_incase.srw forward global type w_incase from w_publ_1ton_share_detail end type type st_2 from statictext within w_incase end type type ddlb_scid from uo_ddlb_scid within w_incase end type type st_3 from statictext within w_incase end type type ddlb_status from dropdownlistbox within w_incase end type end forward global type w_incase from w_publ_1ton_share_detail integer width = 3863 string title = "装箱单" boolean maxbox = true windowstate windowstate = maximized! long dw_child_h = 12681084 long dw_child_w = 47087720 event insert_childrow ( ) event ue_find_pf ( ) event ue_fj_edit ( ) event ue_fj_view ( ) st_2 st_2 ddlb_scid ddlb_scid st_3 st_3 ddlb_status ddlb_status end type global w_incase w_incase type variables long cur_scid =0 //分店ID long cur_flag= -1 //-1：全部，0未审,1已审核 int cur_editfocus=0 //1:新建2:修改 uo_incase uo_incase_mtrl end variables forward prototypes public function integer wf_refresh_curuc (long arg_scid, long arg_incaseid) public function integer wf_autoaddmx (long arg_outwareid, string arg_outwarecode, long arg_scid, ref string arg_msg) public function integer wf_find_pf (long arg_outwareid, string arg_outwarecode, long arg_mtrlid, long arg_qty) public subroutine wf_change_color () public subroutine wf_check_billfj () 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_flagstatus_rf () 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) if li_row > 1 then dw_child.accepttext() dw_child.object.u_incasemx_cusid[li_row] = dw_child.object.u_incasemx_cusid[1] dw_child.object.u_cust_cuscode[li_row] = dw_child.object.u_cust_cuscode[1] dw_child.object.u_cust_name[li_row] = dw_child.object.u_cust_name[1] end if dw_child.SetColumn ('mtrlstatus') end event event ue_find_pf();IF not dw_edit_mode THEN RETURN Int ls_i = 1,ls_j Long ll_fathermtrlid String ls_mtrlstatus Int ls_rowcount Decimal ls_qty dw_child.AcceptText() ls_rowcount = dw_child.RowCount() IF ls_rowcount <= 0 THEN MessageBox('提示','没有计算项',information!,ok!) RETURN END IF DO WHILE ls_i <= ls_rowcount AND dw_child.Object.u_incasemx_ifson_flag[ls_i] = 0 ls_qty = dw_child.Object.u_incasemx_qty[ls_i] ls_mtrlstatus = dw_child.Object.mtrlstatus[ls_i] ll_fathermtrlid = dw_child.Object.u_incasemx_mtrlid[ls_i] IF ls_qty <= 0 THEN MessageBox('提示', '数量不正确,在'+ls_mtrlstatus,information!,ok!) RETURN END IF ls_i++ IF ls_i > ls_rowcount THEN dw_child.Object.u_incasemx_packqty[ls_i - 1] = ls_qty goto ext END IF ls_j = 0 DO WHILE dw_child.Object.u_incasemx_ifson_flag[ls_i] = 1 AND dw_child.Object.fathermtrlid[ls_i] = ll_fathermtrlid dw_child.Object.u_incasemx_packqty[ls_i] = ls_qty ls_mtrlstatus = dw_child.Object.mtrlstatus[ls_i] ls_j++ ls_i++ IF ls_i > ls_rowcount THEN dw_child.Object.u_incasemx_packqty[ls_i - ls_j - 1] = ls_qty*ls_j goto ext END IF LOOP IF ls_j = 0 THEN dw_child.Object.u_incasemx_packqty[ls_i - 1] = ls_qty ELSE dw_child.Object.u_incasemx_packqty[ls_i - ls_j - 1] = ls_qty*ls_j END IF LOOP ls_i = ls_i - 1 IF ls_i <> ls_rowcount THEN MessageBox('提示', ' 循环计算出错,可能是明细内容出错',information!,ok!) this.TriggerEvent('retrieve_pageretr') RETURN END IF ext: dw_child.AcceptText() //计算包装 long ll_mtrlid,ll_father_mtrlid string ls_prdpackcode decimal ld_packqty long ls_k decimal ld_caseqty decimal ld_Sonscale decimal ld_fatherqty for ls_k = 1 to dw_child.rowcount() ll_mtrlid = dw_child.object.u_incasemx_mtrlid[ls_k] ll_father_mtrlid = dw_child.object.fathermtrlid[ls_k] if dw_child.Object.u_incasemx_ifson_flag[ls_k] = 0 then ld_fatherqty=dw_child.Object.u_incasemx_qty[ls_k] else SELECT Sonscale into :ld_Sonscale FROM u_PrdPF where Mtrlid=:ll_father_mtrlid and Sonmtrlid=:ll_mtrlid and pfcode='包件BOM'; if sqlca.sqlcode<>0 then messagebox('错误','查询操作失败：产品包装耗料量：'+sqlca.sqlerrtext,stopsign!,ok!) continue end if dw_child.Object.u_incasemx_qty[ls_k] = ld_Sonscale*ld_fatherqty end if select prdpackcode,packqty into :ls_prdpackcode,:ld_packqty from u_mtrldef where u_mtrldef.mtrlid=:ll_mtrlid using sqlca; if sqlca.sqlcode<>0 then messagebox('错误','查询操作失败：包装件数'+sqlca.sqlerrtext,stopsign!,ok!) continue end if if ld_packqty=0 then continue end if dw_child.accepttext() // if dw_child.object.u_incasemx_ifson_flag[ls_k] = 0 then ld_caseqty = dw_child.Object.u_incasemx_qty[ls_k] // else // ld_caseqty = dw_child.Object.u_incasemx_packqty[ls_k] // end if if mod(ld_caseqty,ld_packqty) = 0 then dw_child.Object.packqty_1[ls_k]= ld_caseqty/ld_packqty else dw_child.Object.packqty_1[ls_k]=Truncate(ld_caseqty/ld_packqty,0)+1 end if dw_child.Object.u_incasemx_packunit[ls_k] = ls_prdpackcode dw_child.Object.u_mtrldef_packqty[ls_k] = ld_packqty next dw_child.AcceptText() //循环计算成品的包装箱数 decimal ld_sumcpqty ld_sumcpqty=0 for ls_k=ls_rowcount to 1 STEP -1 if dw_child.Object.u_incasemx_ifson_flag[ls_k] = 0 then if ld_sumcpqty<>0 then dw_child.Object.packqty_1[ls_k] = ld_sumcpqty ld_sumcpqty=0 end if else ld_sumcpqty = ld_sumcpqty+dw_child.Object.packqty_1[ls_k] end if next wf_change_color() 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,'你没有使用权限！') // 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 = 130 //销售订单的mainID s_pic.f_string = dw_pageretr.Object.u_incase_incasecode[ls_row] s_pic.g_long = dw_pageretr.Object.u_incase_incaseid[ls_row] s_pic.e_long = dw_pageretr.Object.u_incase_scid[ls_row] s_pic.sqltransaction = sys_filedb_sqlca OpenWithParm(w_fj_bill_mng,s_pic) wf_check_billfj() 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 = 130 //销售订单的mainID s_pic.f_string = dw_pageretr.Object.u_incase_incasecode[ls_row] s_pic.g_long = dw_pageretr.Object.u_incase_incaseid[ls_row] s_pic.e_long = dw_pageretr.Object.u_incase_scid[ls_row] s_pic.sqltransaction = sys_filedb_sqlca OpenWithParm(w_fj_bill_view,s_pic) end event public function integer wf_refresh_curuc (long arg_scid, long arg_incaseid);if arg_incaseid<=0 or isnull(arg_incaseid) then return 0 long uc_row uc_row=dw_pageretr.getrow() if uc_row<=0 then return 0 datetime incasedate string incaserep string dscrp string incasecode datetime opdate string opemp string modemp datetime moddate int flag datetime Auditingdate string Auditingrep long custid string relcode long relid string assign_emp SELECT u_incase.incasecode, u_incase.cusid, u_incase.incasedate, u_incase.assign_emp, u_incase.relcode, u_incase.dscrp, u_incase.opemp, u_incase.opdate, u_incase.modemp, u_incase.moddate, u_incase.relid, u_incase.auditingrep, u_incase.auditingdate, u_incase.flag into :incasecode, :custid, :incasedate, :assign_emp, :relcode, :dscrp, :opemp, :opdate, :modemp, :moddate, :relid, :Auditingrep, :Auditingdate, :flag FROM u_incase WHERE ( u_incase.incaseid = :arg_incaseid ) and ( u_incase.scid=:arg_scid ); if sqlca.sqlcode<>0 then messagebox('错误',"查询操作失败(错误单据唯一码)",stopsign!,ok!) return 0 end if dw_pageretr.object.u_incase_scid[uc_row]=arg_scid dw_pageretr.object.u_incase_incaseid[uc_row]=arg_incaseid dw_pageretr.object.u_incase_incasedate[uc_row]=incasedate dw_pageretr.object.u_incase_incasecode[uc_row]=incasecode dw_pageretr.object.u_incase_cusid[uc_row]= custid dw_pageretr.object.u_incase_assign_emp[uc_row]=assign_emp dw_pageretr.object.u_incase_dscrp[uc_row]= dscrp dw_pageretr.object.u_incase_relcode[uc_row]= relcode dw_pageretr.object.u_incase_opdate[uc_row]= opdate dw_pageretr.object.u_incase_opemp[uc_row]= opemp dw_pageretr.object.u_incase_moddate[uc_row]= moddate dw_pageretr.object.u_incase_modemp[uc_row]= modemp dw_pageretr.object.u_incase_flag[uc_row]= flag dw_pageretr.object.u_incase_auditingdate[uc_row]= Auditingdate dw_pageretr.object.u_incase_Auditingrep[uc_row]=Auditingrep dw_pageretr.object.u_incase_relid[uc_row]=relid dw_pageretr.resetupdate() dw_pageretr.setredraw(true) dw_uc.Reset() dw_pageretr.RowsCopy(dw_pageretr.GetRow(), dw_pageretr.GetRow(), Primary!, dw_uc, 1, Primary!) dw_uc.ResetUpdate() dw_uc.SetRedraw(TRUE) wf_flagstatus_rf() return 1 end function public function integer wf_autoaddmx (long arg_outwareid, string arg_outwarecode, long arg_scid, ref string arg_msg);long rslt=1 long child_row,uc_row child_row=dw_child.getrow() uc_row=dw_pageretr.getrow() long ll_mtrlid,ll_cusid string ls_mtrlname,ls_mtrlmode,ls_cuscode,ls_cusname,ls_mtrlcode,ls_unit,ls_freight decimal ls_gross_weight,ls_net_weight,ls_cubage decimal ls_qty DECLARE sale_incase CURSOR FOR SELECT u_outwaremx.mtrlid, u_mtrldef.mtrlcode,u_mtrldef.mtrlname, u_mtrldef.mtrlmode, u_mtrldef.unit,u_outware.cusid, u_cust.cuscode, u_cust.name, u_outwaremx.qty,u_cust.freight FROM u_outware INNER JOIN u_outwaremx ON u_outware.scid = u_outwaremx.scid AND u_outware.outwareid = u_outwaremx.outwareid INNER JOIN u_mtrldef ON u_outwaremx.mtrlid = u_mtrldef.mtrlid INNER JOIN u_cust ON u_outware.cusid = u_cust.cusid where u_outware.outwareid=:arg_outwareid and u_outware.scid=:arg_scid; open sale_incase; fetch sale_incase into :ll_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_mtrlmode,:ls_unit,:ll_cusid,:ls_cuscode,:ls_cusname,:ls_qty,:ls_freight; do while sqlca.sqlcode=0 IF dw_child.GetRow() > 0 THEN IF dw_child.Object.u_incasemx_mtrlid[child_row] <> 0 THEN child_row = dw_child.InsertRow (0) ELSE child_row = dw_child.GetRow() END IF ELSE child_row = dw_child.InsertRow (0) END IF dw_child.Object.u_incasemx_relid_outware[child_row] = arg_outwareid dw_child.Object.u_incasemx_relcode_outware[child_row] = arg_outwarecode dw_child.Object.u_incasemx_mtrlid[child_row] = ll_mtrlid dw_child.Object.mtrlstatus [child_row] = ls_mtrlname+ls_mtrlmode dw_child.Object.fathermtrlid[child_row] = ll_mtrlid dw_child.Object.u_incasemx_cusid[child_row] = ll_cusid dw_child.Object.u_cust_cuscode[child_row] = ls_cuscode dw_child.Object.u_cust_name[child_row] = ls_cusname dw_uc.Object.prdship[uc_row] = ls_freight dw_child.Object.u_incasemx_qty[child_row] = ls_qty dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode dw_child.Object.u_mtrldef_mtrlname[child_row] = ls_mtrlname dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode dw_child.Object.u_mtrldef_unit[child_row] = ls_unit SELECT u_mtrldef.gross_weight, u_mtrldef.net_weight, u_mtrldef.cubage INTO :ls_gross_weight,:ls_net_weight,:ls_cubage FROM u_mtrldef Where ( u_mtrldef.mtrlid = :ll_mtrlid); IF sqlca.SQLCode <> 0 THEN MessageBox('错误','错误的产品，在'+ls_mtrlcode,stopsign!,ok!) rslt=0 goto ext END IF IF wf_find_pf(arg_outwareid,arg_outwarecode,ll_mtrlid,0) = 0 THEN dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage END IF fetch sale_incase into :ll_mtrlid,:ls_mtrlcode,:ls_mtrlname,:ls_mtrlmode,:ls_unit,:ll_cusid,:ls_cuscode,:ls_cusname,:ls_qty,:ls_freight; loop close sale_incase; ext: return rslt end function public function integer wf_find_pf (long arg_outwareid, string arg_outwarecode, long arg_mtrlid, long arg_qty);Long ll_sonmtrlid Int ls_i = 0,li_rownum,row_count String ls_mtrlname,ls_nowcode,ls_mtrlmode,ls_zxmtrlmode Decimal ld_gross_weight,ld_net_weight,ld_cubage,LD_Sonscale string ls_mtrlcode,ls_unit DECLARE find_sonmtrlid CURSOR FOR SELECT DISTINCT (u_PrdPF.SonMtrlid), u_mtrldef.mtrlname, u_mtrldef.gross_weight, u_mtrldef.net_weight, u_mtrldef.cubage, u_mtrldef.mtrlmode, u_mtrldef.zxmtrlmode, u_mtrldef.mtrlcode, u_mtrldef.unit, u_PrdPF.Sonscale FROM u_PrdPF INNER JOIN u_mtrldef ON u_PrdPF.SonMtrlid = u_mtrldef.mtrlid WHERE u_PrdPF.mtrlid = :arg_mtrlid Order By u_PrdPF.SonMtrlid; OPEN find_sonmtrlid; FETCH find_sonmtrlid INTO :ll_sonmtrlid,:ls_mtrlname,:ld_gross_weight,:ld_net_weight,:ld_cubage,:ls_mtrlmode,:ls_zxmtrlmode,:ls_mtrlcode,:ls_unit,:LD_Sonscale; DO WHILE sqlca.SQLCode = 0 ls_i++ li_rownum = dw_child.InsertRow(0) dw_child.Object.u_incasemx_mtrlid[li_rownum] = ll_sonmtrlid dw_child.Object.mtrlstatus[li_rownum] = ls_mtrlname //增加编号 dw_child.Object.u_incasemx_relcode_outware[li_rownum] = arg_outwarecode dw_child.Object.u_incasemx_relid_outware[li_rownum] = arg_outwareid dw_child.Object.u_incasemx_pfcode[li_rownum] = String(ls_i) dw_child.Object.u_incasemx_grossweight[li_rownum] = ld_gross_weight dw_child.Object.u_incasemx_netweight[li_rownum] = ld_net_weight dw_child.Object.u_incasemx_cubage[li_rownum] = ld_cubage dw_child.Object.u_incasemx_packqty[li_rownum] = arg_qty dw_child.Object.u_incasemx_ifson_flag[li_rownum] = 1 dw_child.Object.fathermtrlid[li_rownum] = arg_mtrlid dw_child.Object.u_incasemx_packsize[li_rownum] = ls_zxmtrlmode dw_child.Object.u_mtrldef_mtrlcode[li_rownum] = ls_mtrlcode dw_child.Object.u_mtrldef_unit[li_rownum] = ls_unit dw_child.Object.u_mtrldef_mtrlmode[li_rownum] = ls_mtrlmode dw_child.Object.u_mtrldef_mtrlname[li_rownum] = ls_mtrlname dw_child.Object.u_incasemx_sonscale[li_rownum] = LD_Sonscale dw_child.accepttext() if li_rownum<=1 then dw_child.object.u_incasemx_cusid[li_rownum] = dw_child.object.u_incasemx_cusid[1] dw_child.object.u_cust_cuscode[li_rownum] = dw_child.object.u_cust_cuscode[1] dw_child.object.u_cust_name[li_rownum] = dw_child.object.u_cust_name[1] else dw_child.object.u_incasemx_cusid[li_rownum] = dw_child.object.u_incasemx_cusid[li_rownum - 1] dw_child.object.u_cust_cuscode[li_rownum] = dw_child.object.u_cust_cuscode[li_rownum - 1] dw_child.object.u_cust_name[li_rownum] = dw_child.object.u_cust_name[li_rownum - 1] end if FETCH find_sonmtrlid INTO :ll_sonmtrlid,:ls_mtrlname,:ld_gross_weight,:ld_net_weight,:ld_cubage,:ls_mtrlmode,:ls_zxmtrlmode,:ls_mtrlcode,:ls_unit,:LD_Sonscale; LOOP CLOSE find_sonmtrlid; dw_child.AcceptText() row_count = ls_i DO WHILE ls_i > 0 ls_nowcode = dw_child.Object.u_incasemx_pfcode[li_rownum] ls_nowcode = ls_nowcode+'/'+String(row_count) dw_child.Object.u_incasemx_pfcode[li_rownum] = ls_nowcode ls_i = ls_i - 1 li_rownum = li_rownum - 1 LOOP RETURN row_count end function public subroutine wf_change_color ();long ls_rowcount ls_rowcount = dw_child.rowcount( ) if ls_rowcount <=0 then return long ls_i for ls_i=2 to ls_rowcount if dw_child.object.u_incasemx_ifson_flag[ls_i] = 1 and dw_child.object.u_incasemx_ifson_flag[ls_i - 1] = 0 then dw_child.object.ifover[ls_i - 1] = 1 end if next dw_child.accepttext( ) dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_incasemx_pfcode.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_incasemx_relcode_outware.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_cust_name.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_mtrldef_mtrlcode.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_mtrldef_mtrlname.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_mtrldef_mtrlmode.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_mtrldef_unit.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "u_mtrldef_packqty.Color='0~tIf(ifover=1,255,0)'") dw_child.Modify( "mtrlstatus.Color='0~tIf(ifover=1,255,0)'") //dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'") //dw_child.Modify( "u_cust_cuscode.Color='0~tIf(ifover=1,255,0)'") end subroutine public subroutine wf_check_billfj ();String arg_msg Long ll_ConnectionID Long cur_billtype long ll_relid,ll_relid_mx,ll_scid Long ls_filecount = 0 Int rslt = 1 uo_fj_mng_billtype ls_uo_fjbt ls_uo_fjbt = CREATE uo_fj_mng_billtype Long row,uc_relid row = dw_pageretr.GetRow() IF row > 0 THEN ll_relid = dw_pageretr.Object.u_incase_incaseid[row] ll_scid = dw_pageretr.Object.u_incase_scid[row] ll_relid_mx = 0 ELSE rslt = 0 GOTO ext END IF IF f_get_outerconnection(ll_ConnectionID,arg_msg) = 0 THEN rslt = 0 GOTO ext END IF cur_billtype = 130 //客户投拆单的 mainiD ls_uo_fjbt.uf_check_billfj( cur_billtype, ll_relid,ll_relid_mx,ll_scid, sys_fileDB_sqlca, arg_msg, ls_filecount) IF ls_filecount > 0 THEN rslt = 1 GOTO ext ELSE rslt = 0 GOTO ext END IF ext: wf_encl(rslt) DESTROY ls_uo_fjbt end subroutine 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.u_incase_scid[LS_ROW] //查询所选模版是否含有图片信息 Long ll_ifpic Long ll_classid SELECT ifpic INTO :ll_ifpic FROM U_XLS_Templates Where id = :ll_xls_Templatesid; IF sqlca.SQLCode <> 0 THEN ll_ifpic = 0 END IF Long ll_i,ll_j Long ll_mtrlid Long ll_fileid Blob ls_filedata SetNull(ls_filedata) String Pathname,ls_filename,ls_filetype String errmsg uo_fj_mng_billtype ls_uo_fjbt ls_uo_fjbt = CREATE uo_fj_mng_billtype s_xls_pic_list s_pic //结构数组-用于保存图片路径 IF ll_ifpic = 1 THEN //如果含有图片信息,则查询本类型单据需要带出哪类附件 SELECT classid INTO :ll_classid FROM u_billpic_fileclass Where (billtype = 130); IF sqlca.SQLCode <> 0 THEN ll_classid = 0 END IF IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息. FOR ll_i = 1 TO dw_child.RowCount() ll_mtrlid = dw_child.Object.u_incasemx_mtrlid[ll_i] //取该附件类型中的第一个附件. SELECT top 1 fileid,DisplayName,FileType INTO :ll_fileid,:ls_filename,:ls_filetype FROM u_file WHERE relid = :ll_mtrlid AND classid = :ll_classid AND (filetype = 'bmp' OR filetype = 'rle' OR filetype = 'wmf' OR filetype = 'tif' OR filetype = 'jpg' OR filetype = 'gif' OR filetype = 'jpeg') USING sys_fileDB_sqlca; IF sys_fileDB_sqlca.SQLCode <> 0 THEN ll_fileid = 0 END IF IF ll_fileid > 0 THEN Pathname = sys_cur_path+ins_fjtemppath+'\'+String(Today(),'yymmdd')+String(Now(),'hhmmss')+'_'+ls_filename+'.'+ls_filetype IF Trim(Pathname) <> '' THEN IF ls_uo_fjbt.uf_getfjbolb_fromdb( ll_fileid, ls_filedata, sys_fileDB_sqlca, arg_msg) = 0 THEN RETURN 0 END IF IF f_saveblobtofile(ls_filedata,Pathname,errmsg) = 0 THEN RETURN 0 ELSE s_pic.path[ll_i] = Pathname //记录临时文件位置,本窗口退出后删除 wf_addlog_tempfilepathname(Pathname) END IF ELSE s_pic.path[ll_i] = '' END IF ELSE s_pic.path[ll_i] = '' END IF NEXT END IF // END IF ////可选设置/// arg_obj_st.uo_const.create_new_pwd( ) //创建随机密码 if sys_option_xls_ifuse_passwd = 1 then arg_obj_st.uo_const.pwd = trim(sys_option_xls_user_passwd) //默认加密密码 默认为随即密码 boolean xls_locked xls_locked = not (sys_option_xls_lock = 1) /// Excel 的可选设置 if arg_obj_st.of_setoption(arg_ationid, xls_locked,true,arg_msg) <> 1 then return 0 end if for i = 1 to arg_str_billlist.count ////可选操作/// arg_str_billlist.bill[i].ds_data = create datastore // arg_str_billlist.bill[i].ds_data.dataobject = arg_str_billlist.bill[i].datawindow // arg_str_billlist.bill[i].ds_data.settransobject(sqlca) //修改点:注意retrieve 参数与上文对应 arg_str_billlist.bill[i].ds_data.retrieve(ll_scid,ll_id) next return 1 end function public function integer wf_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.u_incase_flag[pagerert_row]=0 then cb_auditing.enabled=true cb_auditing_cancel.enabled=false elseif dw_pageretr.object.u_incase_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_print_retrievedata (ref s_print_pic_list arg_s_pic, ref string arg_msg);Long LS_ROW,ll_id,i,ll_scid LS_ROW = dw_pageretr.GetRow() IF LS_ROW <= 0 THEN arg_msg = '没有目标单据!' RETURN 0 END IF //修改点:获取 指定retriev参数 ll_id = dw_pageretr.Object.#1[LS_ROW] ll_scid = dw_pageretr.Object.u_incase_scid[LS_ROW] Long ll_i,ll_j Long ll_mtrlid Long ll_fileid Blob ls_filedata SetNull(ls_filedata) String Pathname,ls_filename,ls_filetype String errmsg uo_fj_mng_billtype ls_uo_fjbt ls_uo_fjbt = CREATE uo_fj_mng_billtype Long ll_classid SELECT classid INTO :ll_classid FROM u_billpic_fileclass Where (billtype = 102); IF sqlca.SQLCode <> 0 THEN ll_classid = 0 END IF IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息. FOR ll_i = 1 TO dw_child.RowCount() ll_mtrlid = dw_child.Object.u_incasemx_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_incase.create int iCurrent call super::create this.st_2=create st_2 this.ddlb_scid=create ddlb_scid this.st_3=create st_3 this.ddlb_status=create ddlb_status iCurrent=UpperBound(this.Control) this.Control[iCurrent+1]=this.st_2 this.Control[iCurrent+2]=this.ddlb_scid this.Control[iCurrent+3]=this.st_3 this.Control[iCurrent+4]=this.ddlb_status end on on w_incase.destroy call super::destroy destroy(this.st_2) destroy(this.ddlb_scid) destroy(this.st_3) destroy(this.ddlb_status) end on event open;THIS.TriggerEvent('ue_before_open') wf_movetocenter() ds_copy_bill = CREATE datastore ds_copy_bill.DataObject = dw_child.dataobject ds_copy_bill.SetTransObject(sqlca) 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() 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 = 6 //uc dw前7列可以编辑 child_column_int = 13 //子dw前8列可以编辑 uo_incase_mtrl = CREATE uo_incase uo_incase_mtrl.commit_transaction = sqlca s_hide_col s_col_mtrlsectype s_col_mtrlsectype.col_1 = 'u_mtrldef_mtrlsectype' f_hide_col(1308,dw_child,s_col_mtrlsectype) s_hide_col s_col_zxmtrlmode s_col_zxmtrlmode.col_1 = 'u_mtrldef_zxmtrlmode' f_hide_col(1309,dw_child,s_col_zxmtrlmode) end event event close;call super::close;destroy uo_incase_mtrl wf_del_tempfilepathname() end event event retrieve_childdw;long row,uc_relid row=dw_pageretr.getrow() if row>0 then uc_relid=dw_pageretr.object.u_incase_incaseid[row] dw_child.SetRedraw (false) dw_child.retrieve(cur_scid,uc_relid) dw_child.SetRedraw (true) else dw_child.reset() end if end event event retrieve_pageretr;boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled cb_nextpage_enabled=cb_nextpage.enabled cb_retrieveall_enabled=cb_retrieveall.enabled cb_func_enabled=cb_func.enabled cb_nextpage.enabled=false cb_retrieveall.enabled=false cb_func.enabled=false dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数 dw_pageretr.Retrieve(cur_scid,cur_flag) IF dw_pageretr.RowCount() > 0 THEN dw_pageretr.SetRow(1) dw_pageretr.triggerevent(rowfocuschanged!) end if this.triggerevent('retrieve_childdw') cb_nextpage.enabled=cb_nextpage_enabled cb_retrieveall.enabled=cb_retrieveall_enabled cb_func.enabled=cb_func_enabled end event event ue_usual_query_filt;string obj_expr='' if trim(sle_usual_query.text)<>'' then IF POS(trim(sle_usual_query.text),'%')=0 THEN obj_expr=obj_expr+'( incasecode LIKE "%'+trim(sle_usual_query.text)+'%" )' ELSE obj_expr=obj_expr+'( incasecode 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;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="( incasecode like '%"+trim(sle_usual_query.text)+"%')" else ls_querystrpart="( incasecode 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_f9;call super::ue_f9;// //if not dw_edit_mode then return //long child_row //child_row=dw_uc.getrow() //if child_row=0 then // messagebox('系统提示','请选定装箱单!') // return //end if //dw_uc.accepttext() //if not isvalid(W_cust_edit) then // s_edit_index_tran s_ch_tran //传递参数使用 // s_ch_tran.if_retrieve_all=false //是否一次RETRIEVE所有行 // s_ch_tran.work_mode=1 //0-单纯编辑模式 1-选择\编辑模式 // s_ch_tran.arg_pkid=0 //目标定位PKID (备用) // //查询列(物料编码)部分内容,用于初步筛选 // s_ch_tran.arg_string_code=upper(trim(dw_uc.object.u_cust_cuscode[dw_uc.getrow()])) // // OPENwithparm(W_cust_edit,s_ch_tran) //调用 // // s_custom S_INSCUST // S_INSCUST=Message.PowerObjectParm //接受返回结构 // // IF S_INSCUST.cusid>0 THEN //正常返回值则可以取以下值 // dw_uc.object.u_incase_cusid[child_row]=S_INSCUST.cusid // dw_uc.object.u_cust_name[child_row]=S_INSCUST.name // dw_uc.object.u_cust_cuscode[child_row]=S_INSCUST.cuscode // dw_uc.object.u_incase_assign_emp[child_row]=S_INSCUST.bsntype // dw_uc.setredraw(true) // dw_uc.setcolumn("u_incase_incasedate") // END IF //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 ls_cusid String ls_sonmtrlname child_row = dw_child.GetRow() Dec ls_gross_weight,ls_net_weight,ls_cubage ls_cusid = dw_uc.Object.u_incase_cusid[dw_uc.GetRow()] IF IsNull(ls_cusid) OR ls_cusid = 0 THEN THIS.TriggerEvent("ue_f9") END IF IF NOT IsValid(w_mtrldef_edit) 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 = 0 //目标定位pkid (备用) s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选 s_tranf8.if_select_all = TRUE //多选 s_tranf8.b_long = 0 //选产品 Long ls_j IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.mtrlstatus[dw_child.GetRow()]) OpenWithParm(w_mtrldef_edit,s_tranf8) //调用 s_mtrldef_array s_inscust s_inscust = Message.PowerObjectParm //接受返回结构 FOR ls_j = 1 TO UpperBound(s_inscust.mtrlid) IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值 IF dw_child.GetRow() > 0 THEN IF dw_child.Object.u_incasemx_mtrlid[child_row] <> 0 THEN child_row = dw_child.InsertRow (0) ELSE child_row = dw_child.GetRow() END IF ELSE child_row = dw_child.InsertRow (0) END IF dw_child.Object.u_incasemx_mtrlid[child_row] = s_inscust.mtrlid[ls_j] dw_child.Object.mtrlstatus [child_row] = s_inscust.mtrlname[ls_j]+s_inscust.mtrlmode[ls_j] dw_child.Object.fathermtrlid[child_row] = s_inscust.mtrlid[ls_j] SELECT u_mtrldef.gross_weight, u_mtrldef.net_weight, u_mtrldef.cubage INTO :ls_gross_weight,:ls_net_weight,:ls_cubage FROM u_mtrldef Where ( u_mtrldef.mtrlid = :s_inscust.mtrlid[ls_j]); IF sqlca.SQLCode <> 0 THEN MessageBox('错误','错误的产品，在'+s_inscust.mtrlcode[ls_j],stopsign!,ok!) RETURN END IF IF wf_find_pf(0,'',s_inscust.mtrlid[ls_j],0) = 0 THEN dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage END IF dw_child.SetColumn ('mtrlstatus') END IF NEXT dw_child.SetFocus() END IF end event event ue_viewprint;call super::ue_viewprint; //if not (f_power_ind(ls_powerid)) then // messagebox('提示','你没有使用权限！',information!,ok!) // return //end if lONG LS_ROW LS_ROW=dw_pageretr.getrow() IF LS_ROW<=0 THEN MESSAGEBOX('提示','没有打印目标单据!',information!,ok!) RETURN END IF S_print_MSG LS_PRMSG if ls_newname<>'' then IF li_auditprint = 1 THEN IF dw_pageretr.Object.u_incase_flag[dw_pageretr.GetRow()] = 0 THEN MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!) RETURN END IF END IF LS_PRMSG.obj_dwNAME = ls_newname else LS_PRMSG.obj_dwNAME = 'dw_rp_incase_printview' end if 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.u_incase_scid[LS_ROW] LS_PRMSG.retr_pramnmb=dw_pageretr.object.u_incase_incaseid[LS_ROW] IF ifpic = 1 THEN String ls_msg IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN MessageBox('提示','下载图片失败!',information!,OK!) RETURN END IF END IF Openwithparm(w_publ_preview,LS_PRMSG) IF ifpic = 1 THEN Long li FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path) IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN FileDelete(LS_PRMSG.s_pic.path[li]) END IF NEXT END IF //**更新打印次料 string arg_msg printnum = message.doubleparm f_update_printnum('u_incase',printnum,dw_pageretr.object.u_incase_scid[LS_ROW],dw_pageretr.object.u_incase_incaseid[LS_ROW],'','',arg_msg,true) end event event resize;call super::resize;//long w_width,w_height //w_width = 3611 //w_height = 2332 // // //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 - 3575) //dw_child.height=this.height - (w_height - 912) // // //cb_add.y=this.height - (w_height - 2128) //cb_edit.y=this.height - (w_height - 2128) //cb_delet.y=this.height - (w_height - 2128) //cb_addzy.y=this.height - (w_height - 2128) //cb_add_xm.y=this.height - (w_height - 2128) //cb_dele_xm.y=this.height - (w_height - 2128) //cb_exit.y=this.height - (w_height - 2128) //cb_auditing.y=this.height - (w_height - 2128) //cb_1.y=this.height - (w_height - 2128) //cb_2.y=this.height - (w_height - 2128) end event event ue_print;call super::ue_print;//--直接打印 //IF Not (f_power_ind(ls_powerid)) THEN // MessageBox('提示','你没有使用权限！',information!,ok!) // RETURN //END IF uo_print_preview uo_print IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN S_print_MSG LS_PRMSG IF dw_uc.RowCount() = 0 THEN MessageBox('提示','没有可打印的单据！',information!,ok!) RETURN END IF LS_PRMSG.retr_pram_falg = 15 IF ls_newname <> '' THEN IF li_auditprint = 1 THEN IF dw_pageretr.Object.u_incase_flag[dw_pageretr.GetRow()] = 0 THEN MessageBox('提示','目标单据还未审核,不能打印!',information!,ok!) RETURN END IF END IF LS_PRMSG.obj_dwNAME = ls_newname ELSE LS_PRMSG.obj_dwNAME = 'dw_rp_incase_printview' END IF LS_PRMSG.TAG_TEXT = '装箱单' LS_PRMSG.FILTER_STRING = '' LS_PRMSG.PAGECH_FLAG = 0 LS_PRMSG.retr_scid = dw_pageretr.Object.u_incase_scid[dw_pageretr.GetRow()] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.u_incase_incaseid[dw_pageretr.GetRow()] IF ifpic = 1 THEN String ls_msg IF wf_print_retrievedata(LS_PRMSG.s_pic,ls_msg) = 0 THEN MessageBox('提示','下载图片失败!',information!,OK!) RETURN END IF END IF uo_print.FACT_PRINT_MSG = LS_PRMSG String arg_msg IF uo_print.uof_print_begin(arg_msg) = 0 THEN MessageBox("错误",arg_msg,stopsign!,ok!) RETURN END IF uo_print.ds_print() IF ifpic = 1 THEN Long li FOR li = 1 TO UpperBound(LS_PRMSG.s_pic.path) IF Len(Trim(LS_PRMSG.s_pic.path[li])) > 0 THEN FileDelete(LS_PRMSG.s_pic.path[li]) END IF NEXT END IF //**更新打印次料 printnum = Message.DoubleParm f_update_printnum('u_incase',1,dw_pageretr.Object.u_incase_scid[dw_pageretr.GetRow()],dw_pageretr.Object.u_incase_incaseid[dw_pageretr.GetRow()],'','',arg_msg,TRUE) end event event ue_f11;call super::ue_f11; if not dw_edit_mode then return long child_row child_row=dw_child.getrow() if child_row=0 then messagebox('提示','请选定装箱单!',information!,ok!) return end if dw_child.accepttext() if not isvalid(W_cust_edit) then s_edit_index_tran s_ch_tran //传递参数使用 s_ch_tran.if_retrieve_all=false //是否一次RETRIEVE所有行 s_ch_tran.work_mode=1 //0-单纯编辑模式 1-选择\编辑模式 s_ch_tran.arg_pkid=0 //目标定位PKID (备用) //查询列(物料编码)部分内容,用于初步筛选 s_ch_tran.arg_string_code=upper(trim(dw_child.object.u_cust_cuscode[child_row])) OPENwithparm(W_cust_edit,s_ch_tran) //调用 s_custom S_INSCUST S_INSCUST=Message.PowerObjectParm //接受返回结构 IF S_INSCUST.cusid>0 THEN //正常返回值则可以取以下值 dw_child.object.u_incasemx_cusid[child_row]=S_INSCUST.cusid dw_child.object.u_cust_name[child_row]=S_INSCUST.name dw_child.object.u_cust_cuscode[child_row]=S_INSCUST.cuscode dw_child.setredraw(true) dw_child.setcolumn("mtrlstatus") END IF dw_child.SetFocus() end if end event event ue_f7;Long child_row Long ls_j Dec ls_gross_weight,ls_net_weight,ls_cubage child_row = dw_child.GetRow() string arg_msg='' IF NOT IsValid(w_outware_incase_ch) THEN s_edit_index_tran s_tranf7 s_tranf7.if_retrieve_all = FALSE s_tranf7.work_mode = 1 s_tranf7.arg_pkid = 0 s_tranf7.if_select_all = true //多选 // s_tranf7.arg_string_code = dw_child.object.u_mtrldef_mtrlcode [child_row] OpenWithParm(w_outware_incase_ch,s_tranf7) //调用 s_outware_incase_array S_INSCUST S_INSCUST = Message.PowerObjectParm //接受返回结构 FOR ls_j = 1 TO UpperBound(S_INSCUST.outwareid) IF S_INSCUST.outwareid[ls_j] > 0 THEN //正常返回值则可以取以下值 if wf_autoaddmx(S_INSCUST.outwareid[ls_j],S_INSCUST.outwarecode[ls_j],cur_scid,arg_msg)=0 then messagebox('错误',arg_msg,stopsign!,ok!) return end if dw_child.SetColumn ('mtrlstatus') end if NEXT dw_child.SetFocus() END IF end event event ue_addzy;call super::ue_addzy;IF NOT (f_power_ind(832) or f_power_ind(835)) 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_incase_mtrl.p_getinfo(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row],arg_msg)=0 then messagebox('错误',arg_msg,stopsign!,ok!) return end if if uo_incase_mtrl.add_dscrp(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row],LS_STR,arg_msg,true)=0 then messagebox('错误',arg_msg,stopsign!,ok!) return else messagebox('提示','添加备注操作成功!',information!,ok!) wf_refresh_curuc(dw_pageretr.object.u_incase_scid[uc_row],dw_pageretr.object.u_incase_incaseid[uc_row]) end if end event type cb_func from w_publ_1ton_share_detail`cb_func within w_incase end type type cb_exit from w_publ_1ton_share_detail`cb_exit within w_incase end type type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_incase integer x = 174 integer width = 549 end type type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_incase integer x = 2930 integer width = 146 end type type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_incase integer y = 36 integer width = 265 end type type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_incase integer x = 2021 integer width = 1595 integer height = 972 string dataobject = "dw_incase_index" end type event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_check_billfj() wf_flagstatus_rf() end event type st_1 from w_publ_1ton_share_detail`st_1 within w_incase integer x = 0 end type type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_incase integer x = 3077 end type type dw_uc from w_publ_1ton_share_detail`dw_uc within w_incase integer x = 9 integer width = 2007 integer height = 960 string dataobject = "dw_incase_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 ( ) = 'u_incase_dscrp' AND Key = KeyEnter! THEN dw_child.ScrollToRow(1) dw_child.SetFocus() dw_child.SetColumn ('mtrlstatus') RETURN 1 ELSEIF dw_uc.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN String ls_code,ls_name,ls_custype,ls_find_code,ls_freight Long ls_cusid Long cnt = 0 Boolean if_find = FALSE dw_uc.AcceptText() ls_code = Trim(dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()]) SELECT u_cust.cusid, u_cust.name, u_cust.custype, u_cust.cuscode, u_cust.freight INTO :ls_cusid,:ls_name,:ls_custype,:ls_code,:ls_freight FROM u_cust Where (cuscode = :ls_code OR Name = :ls_code); IF sqlca.SQLCode <> 0 THEN IF Pos(Trim(ls_code),'%') = 0 THEN ls_find_code = '%'+ Trim(ls_code) + '%' ELSE ls_find_code = Trim(ls_code) END IF SELECT count(*) INTO :cnt FROM u_cust Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code ); IF sqlca.SQLCode <> 0 THEN PARENT.TriggerEvent('ue_f9') RETURN 1 END IF IF cnt <> 1 THEN PARENT.TriggerEvent('ue_f9') RETURN 1 ELSE SELECT u_cust.cusid, u_cust.cuscode, u_cust.name INTO :ls_cusid,:ls_code,:ls_name FROM u_cust Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code ); IF sqlca.SQLCode <> 0 THEN PARENT.TriggerEvent('ue_f9') RETURN 1 ELSE if_find = TRUE END IF END IF ELSE if_find = TRUE END IF IF if_find THEN dw_uc.SetRedraw(FALSE) dw_uc.Object.u_incase_cusid[dw_uc.GetRow()] = ls_cusid dw_uc.Object.u_cust_cuscode[dw_uc.GetRow()] = ls_code dw_uc.Object.u_cust_name[dw_uc.GetRow()] = ls_name dw_uc.Object.u_incase_assign_emp[dw_uc.GetRow()] = ls_custype dw_uc.Object.prdship[dw_uc.GetRow()] = ls_freight dw_uc.SetRedraw(TRUE) dw_uc.SetColumn("u_incase_incasedate") 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_sale' then parent.TRIGGEREVENT('ue_f7') end if end event type gb_2 from w_publ_1ton_share_detail`gb_2 within w_incase end type type dw_child from w_publ_1ton_share_detail`dw_child within w_incase integer y = 1256 integer width = 3575 integer height = 952 string dataobject = "dw_incasemx_index" end type event dw_child::dwnkey;call super::dwnkey;PARENT.TriggerEvent('user_key') String ls_mtrlcode,ls_mtrlname,ls_mtrlmode,ls_unit Long ls_mtrlid,ls_cusid Dec ls_gross_weight,ls_net_weight,ls_cubage Long child_row Long ls_null SetNull(ls_null) String arg_msg = '' IF dw_edit_mode THEN ls_cusid = dw_child.Object.u_incasemx_cusid[dw_uc.GetRow()] IF IsNull(ls_cusid) OR ls_cusid = 0 THEN THIS.TriggerEvent("ue_f11") END IF IF KeyDown(keydownarrow!) THEN Long li_row IF dw_child.GetRow() = dw_child.RowCount() THEN PARENT.TriggerEvent("insert_childrow") END IF ELSE If (KeyDown(keyenter!) OR KeyDown(keytab!)) AND NOT KeyDown(keycontrol!) AND NOT KeyDown(keyshift!) THEN IF dw_child.GetColumnName() = 'u_mtrldef_mtrlcode' THEN IF dw_child.Object.u_incasemx_ifson_flag[dw_child.GetRow()] = 0 THEN dw_child.AcceptText() child_row = dw_child.GetRow() ls_mtrlcode = dw_child.Object.mtrlstatus[child_row] SELECT u_mtrldef.mtrlid, u_mtrldef.mtrlname, u_mtrldef.gross_weight, u_mtrldef.net_weight, u_mtrldef.cubage, u_mtrldef.mtrlmode, u_mtrldef.mtrlcode, u_mtrldef.unit INTO :ls_mtrlid,:ls_mtrlname,:ls_gross_weight,:ls_net_weight,:ls_cubage,:ls_mtrlmode,:ls_mtrlcode,:ls_unit FROM u_mtrldef Where ( u_mtrldef.mtrlcode = :ls_mtrlcode); IF sqlca.SQLCode = 100 THEN dw_child.Object.u_incasemx_mtrlid[child_row] = 0 PARENT.TriggerEvent('ue_f8') RETURN 1 END IF dw_child.Object.u_incasemx_mtrlid[child_row] = ls_mtrlid dw_child.Object.mtrlstatus[child_row] = ls_mtrlname+ls_mtrlmode //（编号+名称+规格）作为品种规格 dw_child.Object.u_incasemx_ifson_flag[child_row] = 0 dw_child.Object.fathermtrlid[child_row]=ls_mtrlid dw_child.Object.u_mtrldef_mtrlcode[child_row]=ls_mtrlcode dw_child.Object.u_mtrldef_mtrlmode[child_row]=ls_mtrlmode dw_child.Object.u_mtrldef_mtrlname[child_row]=ls_mtrlname dw_child.Object.u_mtrldef_mtrlcode[child_row]=ls_mtrlcode dw_child.Object.u_mtrldef_unit[child_row]=ls_unit IF wf_find_pf(0,'',ls_mtrlid,0) = 0 THEN dw_child.Object.u_incasemx_grossweight[child_row] = ls_gross_weight dw_child.Object.u_incasemx_netweight[child_row] = ls_net_weight dw_child.Object.u_incasemx_cubage[child_row] = ls_cubage dw_child.Object.u_incasemx_packsize[child_row] = ls_mtrlmode END IF dw_child.SetColumn ('mtrlstatus') // if key = keyenter! then // keybd_event ( 9, 0, 0 , 0 ) // 按下tab // keybd_event ( 9, 0, 2, 0 ) // 释放tab // 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 ELSEIF dw_child.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN String ls_code,ls_name,ls_custype,ls_find_code Long ls_cusid_1 Long cnt = 0 Boolean if_find = FALSE dw_child.AcceptText() ls_code = Trim(dw_child.Object.u_cust_cuscode[dw_child.GetRow()]) SELECT u_cust.cusid, u_cust.name, u_cust.custype, u_cust.cuscode INTO :ls_cusid_1,:ls_name,:ls_custype,:ls_code FROM u_cust Where (cuscode = :ls_code OR Name = :ls_code); IF sqlca.SQLCode <> 0 THEN IF Pos(Trim(ls_code),'%') = 0 THEN ls_find_code = '%'+ Trim(ls_code) + '%' ELSE ls_find_code = Trim(ls_code) END IF SELECT count(*) INTO :cnt FROM u_cust Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code ); IF sqlca.SQLCode <> 0 THEN PARENT.TriggerEvent('ue_f11') RETURN 1 END IF IF cnt <> 1 THEN PARENT.TriggerEvent('ue_f11') RETURN 1 ELSE SELECT u_cust.cusid, u_cust.cuscode, u_cust.name INTO :ls_cusid_1,:ls_code,:ls_name FROM u_cust Where ( cuscode Like :ls_find_code OR Name Like :ls_find_code ); IF sqlca.SQLCode <> 0 THEN PARENT.TriggerEvent('ue_f11') RETURN 1 ELSE if_find = TRUE END IF END IF ELSE if_find = TRUE END IF IF if_find THEN dw_child.SetRedraw(FALSE) dw_child.Object.u_incasemx_cusid[dw_child.GetRow()] = ls_cusid_1 dw_child.Object.u_cust_cuscode[dw_child.GetRow()] = ls_code dw_child.Object.u_cust_name[dw_child.GetRow()] = ls_name dw_child.SetRedraw(TRUE) dw_child.SetColumn("mtrlstatus") RETURN 1 END IF ELSEIF dw_child.GetColumnName( ) = 'u_incasemx_mxdscrp' AND dw_child.GetRow() = dw_child.RowCount() THEN PARENT.TriggerEvent("insert_childrow") RETURN 1 ELSE IF Key = keyenter! THEN keybd_event ( 9, 0, 0 , 0 ) // 按下tab keybd_event ( 9, 0, 2, 0 ) // 释放tab RETURN 1 END IF END IF END IF END IF END IF end event event dw_child::doubleclicked;if dw_edit_mode then choose case dwo.name case 'u_cust_cuscode' parent.triggerevent('ue_f11') case 'u_mtrldef_mtrlcode' parent.triggerevent('ue_f8') end choose end if end event type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_incase integer x = 2025 end type event cb_viewprint::clicked;string ls_dft_old_dwname, ls_dft_new_dwname,ls_dwtype long ls_dwprintid int ls_i IF NOT f_power_ind(836) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF DECLARE dft_dwprint CURSOR FOR SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype FROM sys_dft_dwprint_dynamic where dwtype='w_incase'; open dft_dwprint; fetch dft_dwprint into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype; if sqlca.sqlcode<>0 then parent.triggerevent('ue_viewprint',0,0) else m_dft_dwprint_item m_1 m_1=create m_dft_dwprint_item ls_i=1 do while sqlca.sqlcode=0 f_add_menuItem_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid)) fetch dft_dwprint into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype; ls_i++ loop close dft_dwprint; m_1.popmenu(this.x+50,this.y+50) end if end event type cb_print from w_publ_1ton_share_detail`cb_print within w_incase integer x = 1833 end type event cb_print::clicked;string ls_dft_old_dwname, ls_dft_new_dwname,ls_dwtype long ls_dwprintid int ls_i IF NOT f_power_ind(836) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF w_curwin = parent DECLARE dft_dwprint CURSOR FOR SELECT dwprintid,dft_old_dwname, dft_new_dwname, chnname, dwtype FROM sys_dft_dwprint_dynamic where dwtype='w_incase'; open dft_dwprint; fetch dft_dwprint into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype; if sqlca.sqlcode<>0 then parent.triggerevent('ue_print',0,0) else m_dft_dwprint_item m_1 m_1=create m_dft_dwprint_item ls_i=1 do while sqlca.sqlcode=0 f_add_menuitem_print_dft(m_1,ls_i,ls_chnname,String(ls_dwprintid)) fetch dft_dwprint into :ls_dwprintid,:ls_dft_old_dwname, :ls_dft_new_dwname,:ls_chnname, :ls_dwtype; ls_i++ loop close dft_dwprint; m_1.popmenu(this.x+50,this.y+50) end if end event type cb_add from w_publ_1ton_share_detail`cb_add within w_incase end type event cb_add::clicked;IF NOT f_power_ind(832) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF String arg_msg = '' Long uc_row,i IF dw_edit_mode THEN dw_uc.AcceptText() dw_child.AcceptText() uc_row = dw_uc.GetRow() IF uc_row <= 0 THEN MessageBox('提示','请选定当前目标单据!',information!,ok!) RETURN END IF IF NOT Len(String(dw_uc.Object.u_incase_relcode[uc_row])) > 0 THEN MessageBox('提示','请填写相关号码!',information!,ok!) dw_uc.SetFocus() dw_uc.SetColumn("u_incase_relcode") RETURN END IF IF NOT dw_uc.Object.u_incase_incasedate[uc_row] > DateTime(2000-01-01,Now()) THEN MessageBox('提示','不合理发生时间!',information!,ok!) dw_uc.SetFocus() dw_uc.SetColumn("u_incase_incasedate") RETURN END IF IF NOT Len(String(dw_uc.Object.u_incase_assign_emp[uc_row])) > 0 THEN MessageBox('提示','请填写经手人!',information!,ok!) dw_uc.SetFocus() dw_uc.SetColumn("u_incase_assign_emp") RETURN END IF uo_incase_mtrl.incasedate = dw_uc.Object.u_incase_incasedate[uc_row] // 发生时间 uo_incase_mtrl.Assign_emp = dw_uc.Object.u_incase_assign_emp[uc_row] // 经手人 uo_incase_mtrl.relcode = dw_uc.Object.u_incase_relcode[uc_row] //相关号码 uo_incase_mtrl.dscrp = dw_uc.Object.u_incase_dscrp[uc_row] //备注 uo_incase_mtrl.relid = dw_uc.Object.u_incase_relid[uc_row] uo_incase_mtrl.custid = 0 //客户ID uo_incase_mtrl.prdship = dw_uc.Object.prdship[uc_row] FOR i = 1 TO dw_child.RowCount() IF dw_child.Object.u_incasemx_mtrlid[i] > 0 THEN IF uo_incase_mtrl.acceptmx(dw_child.Object.u_incasemx_mtrlid[i],& dw_child.Object.mtrlstatus[i],& dw_child.Object.u_incasemx_pfcode[i],& dw_child.Object.u_incasemx_qty[i],& dw_child.Object.u_incasemx_packunit[i],& dw_child.Object.u_incasemx_packcode[i],& dw_child.Object.u_incasemx_packsize[i],& dw_child.Object.u_incasemx_mxdscrp[i],& dw_child.Object.u_incasemx_packqty[i],& arg_msg,& dw_child.Object.pid[i],& dw_child.Object.u_incasemx_grossweight[i],& dw_child.Object.u_incasemx_netweight[i],& dw_child.Object.u_incasemx_cubage[i],& dw_child.Object.u_incasemx_ifson_flag[i],& dw_child.Object.fathermtrlid[i],& dw_child.Object.packqty_1[i],& dw_child.Object.u_incasemx_cusid[i],& dw_child.Object.u_incasemx_relid_outware[i],& dw_child.Object.u_incasemx_relcode_outware[i],& dw_child.Object.u_incasemx_discard[i],& dw_child.Object.u_incasemx_sonscale[i]) = 0 THEN MessageBox('错误',arg_msg,stopsign!,ok!) RETURN END IF END IF NEXT IF uo_incase_mtrl.save(publ_operator,arg_msg,true) = 0 THEN MessageBox('错误',arg_msg,stopsign!,ok!) RETURN END IF MessageBox('提示','保存操作成功!',information!,ok!) 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_incase_mtrl.incaseid) //刷新uc ELSE IF uo_incase_mtrl.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") dw_uc.SetColumn("u_incase_incasedate") ELSE PARENT.TriggerEvent("retrieve_childdw") END IF end event type cb_edit from w_publ_1ton_share_detail`cb_edit within w_incase end type event cb_edit::clicked;IF NOT f_power_ind(832) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF string arg_msg='' long uc_row if not dw_edit_mode then uc_row=dw_pageretr.getrow() if uc_row<=0 then messagebox('提示','请选定当前目标单据!',information!,ok!) return end if end if if not dw_edit_mode then if uo_incase_mtrl.updatebegin(cur_scid,dw_pageretr.object.u_incase_incaseid[uc_row],arg_msg)=0 then messagebox('错误',arg_msg,stopsign!,ok!) return end if end if call super::clicked end event type cb_delet from w_publ_1ton_share_detail`cb_delet within w_incase end type event cb_delet::clicked;call super::clicked;IF NOT f_power_ind(833) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF IF dw_edit_mode THEN RETURN IF NOT KeyDown(KeyControl!) THEN IF MessageBox ("询问","是否确定要删除当前吗",Question!,YesNo! ) = 2 THEN 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 uo_incase_mtrl.Cancel(cur_scid,dw_pageretr.Object.u_incase_incaseid[uc_row],arg_msg,TRUE) = 0 THEN MessageBox('错误',arg_msg,stopsign!,ok!) ELSE //日志 Long ls_id String ls_code ls_id = dw_uc.Object.u_incase_incaseid[uc_row] ls_code = dw_uc.Object.u_incase_incasecode[uc_row] f_setsysoplog('装箱单','装箱单删除,ID:'+String(ls_id)+',code:'+ls_code,arg_msg,TRUE) //-- MessageBox('提示','删除单据'+String(dw_pageretr.Object.u_incase_incasecode[uc_row])+'成功!',information!,ok!) dw_pageretr.DeleteRow(uc_row) dw_pageretr.PostEvent(RowFocusChanged!) END IF end event type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_incase end type event cb_addzy::clicked;call super::clicked;m_Dfc_Control_PopupMenu dmPopupMenu string menustr menustr="Text=增加备注~tEvent=ue_addzy" menustr=menustr + "|" + "Text=展开包件~tEvent=ue_find_pf" menustr = menustr + "|" + "Text=-" menustr = menustr + "|" + "Text=查看附件~tEvent=ue_fj_view" menustr = menustr + "|" + "Text=添加附件~tEvent=ue_fj_edit" if len(trim(menustr))<>0 then dmPopupMenu = Create m_Dfc_Control_PopupMenu dmPopupMenu.mf_BuildMenu(This, menustr) dmPopupMenu.mf_PopMenu() Destroy dmPopupMenu end if end event type cb_auditing from w_publ_1ton_share_detail`cb_auditing within w_incase end type event cb_auditing::clicked;call super::clicked;IF NOT f_power_ind(834) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF IF dw_edit_mode THEN RETURN String arg_msg = '' Long pagerert_row Long ll_incaseid,ll_scid IF MessageBox ("询问","是否确定要对当前装箱单作审核吗?",Question!,YesNo! ) = 2 THEN RETURN pagerert_row = dw_pageretr.GetRow() IF pagerert_row <= 0 THEN MessageBox('提示','请选定当前目标单据!',information!,ok!) RETURN END IF ll_incaseid = dw_pageretr.Object.u_incase_incaseid[pagerert_row] ll_scid = dw_pageretr.Object.u_incase_scid[pagerert_row] IF uo_incase_mtrl.audit(ll_scid,ll_incaseid,publ_operator,arg_msg,TRUE) = 0 THEN MessageBox('错误',arg_msg,stopsign!,ok!) ELSE MessageBox('提示','审核成功!',information!,ok!) wf_refresh_curuc(ll_scid,ll_incaseid) END IF end event type cb_xm from w_publ_1ton_share_detail`cb_xm within w_incase end type type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_incase end type type cb_xls from w_publ_1ton_share_detail`cb_xls within w_incase integer x = 2217 end type type cb_help from w_publ_1ton_share_detail`cb_help within w_incase integer x = 1682 end type type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_incase end type event cb_auditing_cancel::clicked;call super::clicked;IF NOT f_power_ind(874) THEN MessageBox('提示','你没有使用权限！',information!,ok!) RETURN END IF IF dw_edit_mode THEN RETURN String arg_msg = '' Long pagerert_row Long ll_incaseid,ll_scid IF MessageBox ("询问","是否确定要对当前装箱单作撤消审核吗?",Question!,YesNo! ) = 2 THEN RETURN pagerert_row = dw_pageretr.GetRow() IF pagerert_row <= 0 THEN MessageBox('提示','请选定当前目标单据!',information!,ok!) RETURN END IF ll_incaseid = dw_pageretr.Object.u_incase_incaseid[pagerert_row] ll_scid = dw_pageretr.Object.u_incase_scid[pagerert_row] //撤审 IF uo_incase_mtrl.cancelaudit(ll_scid,ll_incaseid,arg_msg,TRUE) = 0 THEN MessageBox('错误',arg_msg,stopsign!,ok!) ELSE MessageBox('提示','撤审成功!',information!,ok!) wf_refresh_curuc(ll_scid,ll_incaseid) END IF end event type p_msg from w_publ_1ton_share_detail`p_msg within w_incase end type type p_help from w_publ_1ton_share_detail`p_help within w_incase end type type p_encl from w_publ_1ton_share_detail`p_encl within w_incase end type type p_other from w_publ_1ton_share_detail`p_other within w_incase end type type gb_3 from w_publ_1ton_share_detail`gb_3 within w_incase end type type ln_bar from w_publ_1ton_share_detail`ln_bar within w_incase end type type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_incase integer beginx = 0 integer beginy = 172 integer endx = 3264 integer endy = 172 end type type r_bar from w_publ_1ton_share_detail`r_bar within w_incase end type type ln_1 from w_publ_1ton_share_detail`ln_1 within w_incase integer endx = 2281 end type type ln_2 from w_publ_1ton_share_detail`ln_2 within w_incase end type type st_2 from statictext within w_incase integer x = 782 integer y = 208 integer width = 219 integer height = 48 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 focusrectangle = false end type type ddlb_scid from uo_ddlb_scid within w_incase integer x = 955 integer y = 192 integer width = 549 integer height = 468 boolean bringtotop = true end type event constructor;call super::constructor;cur_scid=this.uo_scid //cur_scid_arr = THIS.uo_scid_arr end event event selectionchanged;call super::selectionchanged;cur_scid=this.uo_scid //cur_scid_arr = THIS.uo_scid_arr parent.triggerevent("retrieve_pageretr") end event type st_3 from statictext within w_incase integer x = 1568 integer y = 204 integer width = 219 integer height = 48 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 focusrectangle = false end type type ddlb_status from dropdownlistbox within w_incase integer x = 1742 integer y = 188 integer width = 549 integer height = 468 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 elseif index=2 then cur_flag= 0 elseif index=3 then cur_flag= 1 end if parent.triggerevent('retrieve_pageretr') end event