$PBExportHeader$w_saletask_sc.srw forward global type w_saletask_sc from w_publ_1ton_share_detail end type type ddlb_retrstatus from dropdownlistbox within w_saletask_sc end type type ddlb_scid from uo_ddlb_scid within w_saletask_sc end type type st_2 from statictext within w_saletask_sc end type type st_3 from statictext within w_saletask_sc end type end forward global type w_saletask_sc from w_publ_1ton_share_detail integer height = 2480 string title = "销售排产打印单" boolean maxbox = true windowstate windowstate = maximized! long dw_pageretr_w = 52828948 long dw_child_h = 34912024 long dw_child_w = 34817496 event insert_childrow ( ) event ue_tempstoptask ( ) event ue_stopsaletask ( ) event ue_finishtask ( ) event ue_importseleprice ( ) event ue_ctempstoptask ( ) event ue_importcusseleprice ( ) event ue_importcusseleprice_his ( ) event ue_fj_edit ( ) event ue_fj_view ( ) event ue_f13 ( ) event ue_f14 ( ) ddlb_retrstatus ddlb_retrstatus ddlb_scid ddlb_scid st_2 st_2 st_3 st_3 end type global w_saletask_sc w_saletask_sc type variables int cur_status=0 //当前查询订单状态// -1 所有 uo_saletask obj_saletask long cur_scid long cur_scid_arr[] uo_cusprice uo_cus_price end variables forward prototypes public function integer wf_cusdetail () public function integer wf_statusbtn_fc () public function integer wf_refresh_curuc (long arg_scid, long arg_taskid) 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) end prototypes event insert_childrow();long li_row li_row=dw_child.insertrow(0) dw_child.scrolltorow(li_row) dw_child.SetColumn ('u_saletaskmx_outtype') end event event ue_tempstoptask();//IF dw_edit_mode THEN // MessageBox('系统提示',"编辑状态下不可以使用!") // return //END IF // //if not f_power_ind(9) then // messagebox(publ_operator,'你没有使用权限!') // return //end if // //string arg_msg='' //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 obj_saletask.tempstoptask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row],arg_msg,true)=0 then // messagebox('Error!',arg_msg) //ELSE // messagebox(publ_operator,"订单作暂停操作成功!") // if cur_status <> -1 then // dw_uc.deleterow(pagerert_row) // else // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row]) // end if //end if end event event ue_stopsaletask();//IF dw_edit_mode THEN // MessageBox('系统提示',"编辑状态下不可以使用!") // return //END IF // //IF NOT f_power_ind(10) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //String arg_msg = '' //Long pagerert_row // //pagerert_row = dw_pageretr.GetRow() //IF pagerert_row <= 0 THEN // MessageBox('系统提示','请选定当前目标订单!') // RETURN //END IF //IF MessageBox ("警告","是否确定要对当前订单作终止吗? (终止后订单将归档只读)",Question!,YesNo! ) = 2 THEN RETURN // // //IF obj_saletask.stopsaletask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN // MessageBox('Error!',arg_msg) //ELSE // MessageBox(publ_operator,'订单终止操作成功!') // IF cur_status <> -1 THEN // dw_uc.DeleteRow(pagerert_row) // ELSE // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row]) // END IF //END IF // end event event ue_finishtask();//IF dw_edit_mode THEN // MessageBox('系统提示',"编辑状态下不可以使用!") // RETURN //END IF // //IF NOT f_power_ind(10) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //String arg_msg = '' //Long pagerert_row // //pagerert_row = dw_pageretr.GetRow() //IF pagerert_row <= 0 THEN // MessageBox('系统提示','请选定当前目标销售订单!') // RETURN //END IF //IF MessageBox ("警告","是否确定要对当前销售订单作完成吗? (完成后销售订单将归档只读)",Question!,YesNo! ) = 2 THEN RETURN // // //Long ls_taskid //ls_taskid = dw_pageretr.Object.taskid[pagerert_row] // //IF obj_saletask.finishtask(dw_pageretr.Object.u_saletask_scid[pagerert_row],ls_taskid,arg_msg,TRUE) = 0 THEN // MessageBox('Error!',arg_msg) //ELSE // MessageBox(publ_operator,'销售订单完成操作成功!') // IF cur_status <> -1 THEN // dw_uc.DeleteRow(pagerert_row) // ELSE // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row]) // END IF //END IF // // end event event ue_importseleprice();//IF NOT dw_edit_mode THEN // MessageBox('系统提示',"非编辑状态下不可以使用!") // RETURN //END IF // //Long ls_row,ls_cusid,ls_mtrlid //String ls_cuscode,ls_cusname,arg_msg //Long uc_row //Decimal obj_price ,obj_rebate //String err_str = '' //Boolean if_exist_price = TRUE //Long ls_pricelistid,ll_moneyid //String ls_status,ls_pcode,ls_woodcode,ls_unit //s_pricelist_ch s_pricelist // //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox(publ_operator,'请先选择币种') // RETURN //END IF // ////直接查询价格表 //// IF MessageBox (publ_operator,"是否直接选择价格表?",Question!,YesNo! ) = 2 THEN RETURN // //Open(w_sale_price_list_ch) //s_pricelist = Message.PowerObjectParm //IF s_pricelist.pricelistid <= 0 THEN RETURN //FOR ls_row = 1 TO dw_child.RowCount() // ls_mtrlid = dw_child.Object.mtrlid[ls_row] // ls_status = dw_child.Object.u_saletaskmx_status[ls_row] // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row] // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row] // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row] // // IF sys_option_price_if_status = 0 THEN // ls_status = '' // ls_pcode = '' // ls_woodcode = '' // END IF // // // SELECT u_sale_price_mx.price // INTO :obj_price // FROM u_sale_price_mx // WHERE (u_sale_price_mx.pricelistid = :s_pricelist.pricelistid) AND // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND // ( u_sale_price_mx.status = :ls_status ) AND // ( u_sale_price_mx.pcode = :ls_pcode ) AND // ( u_sale_price_mx.woodcode = :ls_woodcode ) AND // ( u_sale_price_mx.unit = :ls_unit ); // IF sqlca.SQLCode <> 0 THEN // err_str = err_str + "当前价格表的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n" // ELSE // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price // END IF //NEXT // // //IF err_str <> '' THEN // MessageBox('系统提示',err_str) //END IF // end event event ue_ctempstoptask();//IF dw_edit_mode THEN // MessageBox('系统提示',"编辑状态下不可以使用!") // RETURN //END IF // //IF NOT f_power_ind(9) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //String arg_msg = '' //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 obj_saletask.tempstoptask(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN // MessageBox('Error!',arg_msg) //ELSE // MessageBox(publ_operator,"订单作取消暂停操作成功!") // IF cur_status <> -1 THEN // dw_uc.DeleteRow(pagerert_row) // ELSE // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row]) // END IF //END IF // end event event ue_importcusseleprice();////查询客户价格表 ////如果客户无价格表则提示是否直接查询价格表 //Long ls_row,ls_cusid,ls_mtrlid //String ls_cuscode,ls_cusname,arg_msg //Long uc_row //Decimal obj_price ,obj_rebate //String err_str = '' //Boolean if_exist_price = TRUE //Long ls_pricelistid,ll_moneyid //String ls_status,ls_pcode,ls_woodcode,ls_unit //s_pricelist_ch s_pricelist // //uc_row = dw_uc.GetRow() // //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] // //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox(publ_operator,'请先选择币种') // RETURN //END IF // //IF dw_uc.Object.cusid[uc_row] = 0 OR IsNull(dw_uc.Object.cusid[uc_row]) THEN // MessageBox('系统提示',"请选择销售客户!") // RETURN //END IF // //ls_cusid = dw_uc.Object.cusid[uc_row] // //SELECT u_cust.pricelistid INTO :ls_pricelistid FROM u_cust Where u_cust.cusid = :ls_cusid; //IF sqlca.SQLCode <> 0 OR ls_pricelistid <= 0 THEN // if_exist_price = FALSE //END IF // // //IF if_exist_price = FALSE THEN // IF MessageBox('系统提示',"当前客户的计划售价尚未设定!是否查询价格列表?",Question!,YesNo!) = 2 THEN RETURN // Open(w_sale_price_list_ch) // s_pricelist = Message.PowerObjectParm // IF s_pricelist.pricelistid <= 0 THEN RETURN //END IF // //FOR ls_row = 1 TO dw_child.RowCount() // // ls_mtrlid = dw_child.Object.mtrlid[ls_row] // ls_status = dw_child.Object.u_saletaskmx_status[ls_row] // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row] // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row] // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row] // // IF sys_option_price_if_status = 0 THEN // ls_status = '' // ls_pcode = '' // ls_woodcode = '' // END IF // // IF if_exist_price THEN //查询客户价格表 // IF Not (IsNull(ls_mtrlid) OR ls_mtrlid = 0 ) THEN // SELECT u_sale_price_mx.price // INTO :obj_price // FROM u_sale_price_list ,u_cust,u_sale_price_mx // WHERE (u_sale_price_list.pricelistid = u_cust.pricelistid) AND // (u_sale_price_mx.pricelistid = u_sale_price_list.pricelistid) AND // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND // ( u_cust.cusid = :ls_cusid ) AND // ( u_sale_price_mx.status = :ls_status ) AND // ( u_sale_price_mx.pcode = :ls_pcode ) AND // ( u_sale_price_mx.woodcode = :ls_woodcode ) and // ( u_sale_price_list.moneyid=:ll_moneyid ) and // ( u_sale_price_mx.unit =:ls_unit ); // IF sqlca.SQLCode <> 0 THEN // err_str = err_str + "当前客户的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n" // ELSE // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price // END IF // END IF // ELSE //查询价格列表 // SELECT u_sale_price_mx.price // INTO :obj_price // FROM u_sale_price_mx // WHERE ( u_sale_price_mx.pricelistid = :s_pricelist.pricelistid ) AND // ( u_sale_price_mx.mtrlid = :ls_mtrlid ) AND // ( u_sale_price_mx.status = :ls_status ) AND // ( u_sale_price_mx.pcode = :ls_pcode ) AND // ( u_sale_price_mx.woodcode = :ls_woodcode ) AND // ( u_sale_price_mx.unit = :ls_unit ); // IF sqlca.SQLCode <> 0 THEN // err_str = err_str + "当前价格表的 "+String(dw_child.Object.mtrlname[ls_row])+" 的计划售价尚未设定! ~n" // ELSE // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price // END IF // END IF //NEXT //IF err_str <> '' THEN // MessageBox('系统提示',err_str) //END IF // // // end event event ue_importcusseleprice_his();//// //导入客户历史售价 //Long ls_row,ls_cusid,ls_mtrlid //String ls_cuscode,ls_cusname,arg_msg //Long uc_row //Decimal obj_price ,obj_rebate,obj_rate //String err_str = '' //Boolean if_exist_price = TRUE //Long ls_pricelistid,ll_moneyid //String ls_status,ls_pcode,ls_woodcode,ls_unit //s_pricelist_ch s_pricelist //uc_row = dw_uc.GetRow() // //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox(publ_operator,'请先选择币种') // RETURN //END IF // //IF dw_uc.Object.cusid[uc_row] = 0 OR IsNull(dw_uc.Object.cusid[uc_row]) THEN // MessageBox('系统提示',"请选择销售客户!") // RETURN //END IF //ls_cusid = dw_uc.Object.cusid[uc_row] //ls_cuscode = dw_uc.Object.u_cust_cuscode[uc_row] //ls_cusname = dw_uc.Object.u_cust_name[uc_row] // //IF dw_child.RowCount() <= 0 THEN // MessageBox('系统提示',"请选择产品!") // RETURN //END IF // //FOR ls_row = 1 TO dw_child.RowCount() // ls_mtrlid = dw_child.Object.mtrlid[ls_row] // ls_status = dw_child.Object.u_saletaskmx_status[ls_row] // ls_pcode = dw_child.Object.u_saletaskmx_pcode[ls_row] // ls_woodcode = dw_child.Object.u_saletaskmx_woodcode[ls_row] // ls_unit = dw_child.Object.u_saletaskmx_unit[ls_row] // // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_cusid,ls_unit,ls_woodcode,ls_status,ls_pcode,0,obj_price,obj_rebate,obj_rate,arg_msg) <> 1 THEN // err_str = err_str + "导入客户["+ls_cuscode+ls_cusname+"]的 "+String(dw_child.Object.mtrlname[ls_row])+" 的最新售价失败,或没有最新售价! ~n " // ELSE // dw_child.Object.u_saletaskmx_enprice[ls_row] = obj_price // dw_child.Object.u_saletaskmx_rebate[ls_row] = obj_rebate // dw_child.Object.u_saletaskmx_rate[ls_row] = obj_rate // END IF //NEXT // // //IF err_str <> '' THEN // MessageBox('系统提示',err_str) //END IF // 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 = 102 //销售订单的mainID s_pic.f_string = dw_pageretr.Object.taskcode[ls_row] s_pic.g_long = dw_pageretr.Object.taskid[ls_row] s_pic.e_long = dw_pageretr.Object.u_saletask_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 = 102 //销售订单的mainID s_pic.f_string = dw_pageretr.Object.taskcode[ls_row] s_pic.g_long = dw_pageretr.Object.taskid[ls_row] s_pic.e_long = dw_pageretr.Object.u_saletask_scid[ls_row] s_pic.sqltransaction = sys_filedb_sqlca OpenWithParm(w_fj_bill_view,s_pic) end event event ue_f13();//s_view_dscrp s_view,s_return //String ls_dscrp //dw_uc.AcceptText() // //ls_dscrp = dw_uc.Object.dscrp[dw_uc.GetRow()] //s_view.Title = '销售订单备注' //s_view.dscrp = ls_dscrp //s_view.editmode = dw_edit_mode //OpenWithParm(w_view_dscrp,s_view) //IF dw_edit_mode THEN // s_return = Message.PowerObjectParm // dw_uc.Object.dscrp[dw_uc.GetRow()] = s_return.dscrp //END IF // // // // end event event ue_f14();//s_view_dscrp s_view,s_return //String ls_dscrp //dw_uc.AcceptText() // //ls_dscrp = dw_uc.Object.u_saletask_dscrp2[dw_uc.GetRow()] //s_view.Title = '销售订单辅助备注' //s_view.dscrp = ls_dscrp //s_view.editmode = dw_edit_mode //OpenWithParm(w_view_dscrp,s_view) //IF dw_edit_mode THEN // s_return = Message.PowerObjectParm // dw_uc.Object.u_saletask_dscrp2[dw_uc.GetRow()] = s_return.dscrp //END IF // // // // end event public function integer wf_cusdetail ();////wf_cusdetail // //long ls_row,ls_cusid // //ls_row=dw_uc.getrow() //if ls_row=0 then // messagebox('系统提示','没有选定当前行!') // if isvalid(w_cust_mtrlprice) then close(w_cust_mtrlprice) // return 0 //else // ls_cusid=dw_uc.object.cusid[ls_row] // if isnull(ls_cusid) or ls_cusid<=0 then // messagebox('系统提示','没有选定当前客户,请在编辑状态双击或按F9选择客户!') // if isvalid(w_cust_mtrlprice) then close(w_cust_mtrlprice) // return 0 // end if //end if // //if isvalid(w_cust_mtrlprice) then // Send(Handle(w_cust_mtrlprice), 274, 61728, 0) //else // open(w_cust_mtrlprice) //end if // w_cust_mtrlprice.wf_refresh(ls_cusid) // return 1 end function public function integer wf_statusbtn_fc ();//wf_statusbtn_fc if dw_edit_mode then cb_auditing_cancel.enabled=false cb_auditing.enabled=false return 0 end if long ls_row,status ls_row=dw_pageretr.getrow() if not ls_row>0 then cb_auditing_cancel.enabled=false cb_auditing.enabled=false return 0 end if status=dw_pageretr.object.u_saletask_status[ls_row] CHOOSE CASE status CASE 0 cb_auditing_cancel.enabled=false cb_auditing.enabled=true CASE 1 cb_auditing_cancel.enabled=true cb_auditing.enabled=false CASE 2 cb_auditing_cancel.enabled=false cb_auditing.enabled=false CASE 3 cb_auditing_cancel.enabled=false cb_auditing.enabled=false CASE 4 cb_auditing_cancel.enabled=false cb_auditing.enabled=false CASE 5 cb_auditing_cancel.enabled=false cb_auditing.enabled=false CASE else cb_auditing_cancel.enabled=true cb_auditing.enabled=true END CHOOSE return 0 end function public function integer wf_refresh_curuc (long arg_scid, long arg_taskid);//wf_refresh_curuc Int rslt = 1 IF arg_taskid <= 0 OR IsNull(arg_taskid) THEN rslt = 0 GOTO ext END IF Long uc_row uc_row = dw_pageretr.GetRow() IF uc_row <= 0 THEN rslt = 0 GOTO ext END IF Int Kind DateTime requiredate String assign_emp String dscrp String dscrp2 string paytype String taskcode Long cusid DateTime accomplishdate Int status String operator String permit_emp DateTime opdate String last_emp String u_cust_name String u_cust_cuscode long moneyid long banktypeid decimal mrate string relcode decimal damt decimal otheramt string cus_address string cus_tele string freight string cus_fax string freight_tele SELECT u_saletask.kind, u_saletask.requiredate, u_saletask.assign_emp, u_saletask.dscrp, u_saletask.dscrp2, u_saletask.paytype, u_saletask.taskcode, u_saletask.cusid, u_saletask.accomplishdate, u_saletask.status, u_saletask.opemp, u_saletask.permit_emp, u_saletask.opdate, u_cust.name, u_cust.cuscode, u_saletask.moneyid, u_saletask.banktypeid, u_saletask.mrate, u_saletask.relcode, u_saletask.damt, u_saletask.otheramt, u_saletask.cus_address, u_saletask.cus_tele, u_saletask.freight, u_saletask.cus_fax, u_saletask.freight_tele INTO :Kind, :requiredate, :assign_emp, :dscrp, :dscrp2, :paytype, :taskcode, :cusid, :accomplishdate, :status, :operator, :permit_emp, :opdate, :u_cust_name, :u_cust_cuscode, :moneyid, :banktypeid, :mrate, :relcode, :damt, :otheramt, :cus_address, :cus_tele, :freight, :cus_fax, :freight_tele FROM u_saletask left OUTER join u_cust on ( u_saletask.cusid = u_cust.cusid ) WHERE ( u_saletask.taskid = :arg_taskid ) AND ( scid = :arg_scid ); IF sqlca.SQLCode <> 0 THEN MessageBox('错误',"查询操作失败(错误订单唯一码)",stopsign!,OK!) rslt = 0 GOTO ext END IF dw_pageretr.Object.u_saletask_scid [uc_row] = arg_scid dw_pageretr.Object.taskid[uc_row] = arg_taskid dw_pageretr.Object.Kind[uc_row] = Kind dw_pageretr.Object.requiredate[uc_row] = requiredate dw_pageretr.Object.assign_emp[uc_row] = assign_emp dw_pageretr.Object.dscrp[uc_row] = dscrp dw_pageretr.Object.u_saletask_dscrp2[uc_row] = dscrp2 dw_pageretr.Object.u_saletask_paytype[uc_row] = paytype dw_pageretr.Object.taskcode[uc_row] = taskcode dw_pageretr.Object.u_saletask_cusid[uc_row] = cusid dw_pageretr.Object.accomplishdate[uc_row] = accomplishdate dw_pageretr.Object.u_saletask_status[uc_row] = status dw_pageretr.Object.u_saletask_opemp[uc_row] = operator dw_pageretr.Object.permit_emp[uc_row] = permit_emp dw_pageretr.Object.u_saletask_opdate[uc_row] = opdate dw_pageretr.Object.u_cust_name[uc_row] = u_cust_name dw_pageretr.Object.u_cust_cuscode[uc_row] = u_cust_cuscode dw_pageretr.Object.u_saletask_moneyid[uc_row] = moneyid dw_pageretr.Object.u_saletask_banktypeid[uc_row] = banktypeid dw_pageretr.Object.u_saletask_mrate[uc_row] = mrate dw_pageretr.Object.u_saletask_relcode[uc_row] = relcode dw_pageretr.Object.u_saletask_damt[uc_row] = damt dw_pageretr.Object.u_saletask_otheramt[uc_row] = otheramt dw_pageretr.Object.u_saletask_cus_address[uc_row] = cus_address dw_pageretr.Object.u_saletask_cus_tele[uc_row] = cus_tele dw_pageretr.Object.u_saletask_freight[uc_row] = freight dw_pageretr.Object.u_saletask_cus_fax[uc_row] = cus_fax dw_pageretr.Object.u_saletask_freight_tele[uc_row] = freight_tele 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) THIS.PostEvent('retrieve_childdw') ext: wf_statusbtn_fc() RETURN rslt end function 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.taskid[row] ll_scid = dw_pageretr.Object.u_saletask_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 = 102 //客户投拆单的 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);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_saletask_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 = 102); IF sqlca.SQLCode <> 0 THEN ll_classid = 0 END IF IF ll_classid > 0 THEN //如果已经指定好附件类型,则循环明细表查询每个明细的图片信息. FOR ll_i = 1 TO dw_child.RowCount() ll_mtrlid = dw_child.Object.mtrlid[ll_i] //取该附件类型中的第一个附件. 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) IF ll_ifpic = 1 and ll_classid > 0 THEN IF arg_str_billlist.bill[i].datawindow = 'dw_xls_saletaskmx' AND arg_str_billlist.bill[i].ds_data.RowCount() > 0 THEN //设置图片路径 FOR ll_j = 1 TO arg_str_billlist.bill[i].ds_data.RowCount() arg_str_billlist.bill[i].ds_data.Object.pic[ll_j] = s_pic.path[ll_j] NEXT END IF END IF NEXT DESTROY ls_uo_fjbt RETURN 1 end function on w_saletask_sc.create int iCurrent call super::create this.ddlb_retrstatus=create ddlb_retrstatus this.ddlb_scid=create ddlb_scid this.st_2=create st_2 this.st_3=create st_3 iCurrent=UpperBound(this.Control) this.Control[iCurrent+1]=this.ddlb_retrstatus this.Control[iCurrent+2]=this.ddlb_scid this.Control[iCurrent+3]=this.st_2 this.Control[iCurrent+4]=this.st_3 end on on w_saletask_sc.destroy call super::destroy destroy(this.ddlb_retrstatus) destroy(this.ddlb_scid) destroy(this.st_2) destroy(this.st_3) end on event retrieve_pageretr;boolean cb_firstpage_enabled,cb_nextpage_enabled,cb_retrieveall_enabled boolean cb_priorpage_enabled,cb_func_enabled,cb_retrieve_enabled cb_nextpage_enabled=cb_nextpage.enabled cb_retrieveall_enabled=cb_retrieveall.enabled cb_func_enabled=cb_func.enabled cb_nextpage.enabled=false cb_retrieveall.enabled=false cb_func.enabled=false dw_uc.Retrieve() //dw_uc的dw改左select top 0 并肯不带参数 dw_pageretr.Retrieve(cur_scid_arr,cur_status,sys_areaid) IF dw_pageretr.RowCount() > 0 THEN dw_pageretr.SetRow(1) dw_pageretr.triggerevent(rowfocuschanged!) end if this.triggerevent('retrieve_childdw') cb_nextpage.enabled=cb_nextpage_enabled cb_retrieveall.enabled=cb_retrieveall_enabled cb_func.enabled=cb_func_enabled end event event 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() 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 = 19 //uc dw前5列可以编辑 child_column_int = 13 //子dw前3列可以编辑 obj_saletask = CREATE uo_saletask obj_saletask.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 ue_f9;// //IF NOT dw_edit_mode THEN RETURN //Long child_row //child_row = dw_uc.GetRow() //IF child_row = 0 THEN // MessageBox('提示','请选定订单!',information!,OK!) // RETURN //END IF //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.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.assign_emp[child_row] = S_INSCUST.bsntype // dw_uc.Object.u_saletask_freight[child_row] = S_INSCUST.freight // dw_uc.Object.u_saletask_freight_tele[child_row] = S_INSCUST.freight_tele // dw_uc.Object.u_saletask_cus_address[dw_uc.GetRow()] = S_INSCUST.Address // dw_uc.Object.u_saletask_cus_tele[dw_uc.GetRow()] = S_INSCUST.tele // dw_uc.Object.u_saletask_cus_fax[dw_uc.GetRow()] = S_INSCUST.faxno // dw_uc.SetRedraw(TRUE) // dw_uc.setfocus() // dw_uc.SetColumn("u_saletask_cus_address") // END IF //END IF // ////this.enabled = true // // 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,ll_moneyid //child_row = dw_child.GetRow() // //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox('提示','请先选择币种',information!,OK!) // RETURN //END IF // //ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()] //IF IsNull(ls_cusid) OR ls_cusid = 0 THEN // THIS.TriggerEvent("ue_f9") //END IF // //IF NOT IsValid(w_mtrlware_storageid_ch_saletask) 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 //选产品 // s_tranf8.d_long = -1 // // Long ls_j // IF dw_child.GetRow() > 0 THEN s_tranf8.arg_string_code = Trim(dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()]) // OpenWithParm(w_mtrlware_storageid_ch_saletask,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.mtrlid[child_row] <> 0 THEN // child_row = dw_child.InsertRow (0) // ELSE // child_row = dw_child.GetRow() // END IF // ELSE // child_row = dw_child.InsertRow (0) // END IF // // dw_child.Object.mtrlid[child_row] = s_inscust.mtrlid[ls_j] // dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j] // dw_child.Object.mtrlname[child_row] = s_inscust.mtrlname[ls_j] // dw_child.Object.saleqty[child_row] = 0 // dw_child.Object.plprice[child_row] = s_inscust.planprice[ls_j] // dw_child.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[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.u_saletaskmx_unit[child_row] = s_inscust.unit[ls_j] // // IF sys_option_price_if_status = 0 THEN // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate // String arg_msg // IF f_getmtrlcusprice(ll_moneyid,s_inscust.mtrlid[ls_j],ls_cusid,s_inscust.unit[ls_j],'','','',0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN // dw_child.Object.u_saletaskmx_enprice[child_row] = 0 // dw_child.Object.u_saletaskmx_rebate[child_row] = 1 // ELSE // dw_child.Object.u_saletaskmx_enprice[child_row] = ls_1stnewprice // dw_child.Object.u_saletaskmx_rebate[child_row] = ls_1stzqrate // dw_child.Object.u_saletaskmx_rate[child_row] = ls_1strate // END IF // END IF // dw_child.SetColumn('usaleqty') // END IF // NEXT //END IF //dw_child.SetFocus() // // // end event event refresh_interface;call super::refresh_interface;ddlb_retrstatus.enabled=not dw_edit_mode wf_statusbtn_fc() if dw_edit_mode then ddlb_scid.enabled=false else if sys_scid > 0 then ddlb_scid.enabled=false else ddlb_scid.enabled=true end if end if end event event retrieve_childdw;call super::retrieve_childdw;long row,uc_relid,ll_scid row=dw_pageretr.getrow() if row>0 then ll_scid=dw_pageretr.object.u_saletask_scid[row] uc_relid=dw_pageretr.object.taskid[row] dw_child.SetRedraw (false) dw_child.retrieve(ll_scid,uc_relid) dw_child.SetRedraw (true) else dw_child.reset() end if end event event close;f_SetProfileString (sys_empid, "saletask", "status", string(cur_status)) wf_del_tempfilepathname() end event event ue_usual_query_retr;call super::ue_usual_query_retr;string ls_querystrpart='' ls_newselect=lower(ori_oldselect) if trim(sle_usual_query.text)<>'' then if pos(trim(sle_usual_query.text),'%')=0 then ls_querystrpart="(u_saletask.taskcode like '%"+trim(sle_usual_query.text)+"%')" else ls_querystrpart="(u_saletask.taskcode like '"+trim(sle_usual_query.text)+"')" end if if Pos(ls_newselect," where ") <> 0 then ls_newselect=ls_newselect+" AND ("+ls_querystrpart+')' else ls_newselect=ls_newselect+" where ("+ls_querystrpart+')' end if end if wf_retrieveuc(dw_pageretr,ls_newselect,1) this.triggerevent('retrieve_pageretr') end event event ue_usual_query_filt;call super::ue_usual_query_filt;string obj_expr='' if trim(sle_usual_query.text)<>'' then IF POS(trim(sle_usual_query.text),'%')=0 THEN obj_expr=obj_expr+'( taskcode LIKE "%'+trim(sle_usual_query.text)+'%" )' ELSE obj_expr=obj_expr+'( taskcode 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) dw_pageretr.SetRow(1) dw_pageretr.triggerevent(rowfocuschanged!) end if dw_pageretr.SetRedraw(TRUE) end event event ue_viewprint;call super::ue_viewprint;IF NOT f_power_ind(984) 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_SaleTask_Status[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_saletask_print_sc' END IF IF LS_PRMSG.obj_dwNAME = 'dw_rp_saletask_day_print' THEN datetime ld_fdt,ld_edt String ls_print_day Open(w_saletask_print_day) ls_print_day = message.stringparm IF ls_print_day = '1900-01-01' THEN RETURN ld_fdt = datetime(date(ls_print_day),time(0)) ld_edt = datetime(date(ls_print_day),time('23:59:59')) LS_PRMSG.TAG_TEXT = '销售订单' LS_PRMSG.FILTER_STRING = '' LS_PRMSG.retr_pram_falg = 6 LS_PRMSG.PAGECH_FLAG = 0 LS_PRMSG.retr_pramfdt = ld_fdt LS_PRMSG.retr_pramedt = ld_edt ELSE 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_saletask_scid[dw_pageretr.GetRow()] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[LS_ROW] LS_PRMSG.rowcnt = dw_child.RowCount() END IF OpenWithParm(w_publ_preview,LS_PRMSG) //**更新打印次料 String arg_msg printnum = Message.DoubleParm f_update_printnum('u_saletask',printnum,dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()],dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE) end event event ue_print;call super::ue_print; //--直接打印 IF NOT f_power_ind(984) THEN MessageBox('提示','你没有使用权限!',information!,OK!) RETURN END IF uo_print_preview uo_print IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN S_print_MSG LS_PRMSG Long LS_ROW LS_ROW = dw_pageretr.GetRow() IF LS_ROW <= 0 THEN MessageBox('提示','没有打印目标单据!',information!,OK!) RETURN END IF LS_PRMSG.retr_pram_falg = 15 IF ls_newname <> '' THEN IF li_auditprint = 1 THEN IF dw_pageretr.Object.u_SaleTask_Status[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_saletask_print_sc' END IF LS_PRMSG.TAG_TEXT = '销售订单' LS_PRMSG.FILTER_STRING = '' LS_PRMSG.PAGECH_FLAG = 0 LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[LS_ROW] 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() //**更新打印次料 f_update_printnum('u_saletask',1,cur_scid,dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE) end event event ue_f10;call super::ue_f10;//IF NOT dw_edit_mode THEN RETURN //Long child_row //String ls_colorname // //child_row = dw_child.GetRow() // //IF child_row <= 0 THEN RETURN // //IF NOT IsValid(w_color_edit) THEN // Open(w_color_edit) // ls_colorname = Message.StringParm // IF ls_colorname = '' THEN RETURN // dw_child.Object.u_saletaskmx_status[child_row] = ls_colorname // dw_child.SetFocus() //END IF // // end event event ue_addzy;call super::ue_addzy;//IF dw_edit_mode THEN // MessageBox('系统提示',"编辑状态下不可以使用!") // RETURN //END IF // //IF NOT f_power_ind(698) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //String arg_msg = '',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 obj_saletask.add_dscrp(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.Object.taskid[uc_row],LS_STR,arg_msg,TRUE) = 0 THEN // MessageBox('Error!',arg_msg) // RETURN //ELSE // MessageBox(publ_operator,'添加备注操作成功!') // wf_refresh_curuc(cur_scid,dw_pageretr.Object.taskid[uc_row]) //END IF // // end event event ue_f11;call super::ue_f11;//IF NOT dw_edit_mode THEN RETURN //Long child_row //Long ls_outtypeid // //child_row = dw_child.GetRow() // //IF child_row <= 0 THEN RETURN // //IF NOT IsValid(w_outtype_edit) THEN // Open(w_outtype_edit) // ls_outtypeid = Message.doubleparm // // datawindowchild childdw // dw_child.getchild("u_saletaskmx_outtype",childdw) // childdw.SetTransObject (sqlca) // IF childdw.retrieve() = 0 then // childdw.insertrow(0) // end if // // IF ls_outtypeid = 0 THEN RETURN // // dw_child.Object.u_saletaskmx_outtype[child_row] = ls_outtypeid // dw_child.SetFocus() //END IF // end event event ue_f12;call super::ue_f12;//IF NOT IsValid(w_unit_ch) THEN // IF dw_child.GetRow() < 1 THEN RETURN // Long ls_mtrlid,ls_cusid,ls_moneyid // string ls_1stunit,arg_msg,ls_status,ls_woodcode,ls_pcode // Decimal rtn_price,rtn_zqrate,rtn_rate // // ls_mtrlid = dw_child.Object.mtrlid[dw_child.GetRow()] // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()] // ls_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] // ls_status = dw_child.object.u_saletaskmx_status[dw_child.GetRow()] // ls_woodcode = dw_child.object.u_saletaskmx_woodcode[dw_child.GetRow()] // ls_pcode = dw_child.object.u_saletaskmx_pcode[dw_child.GetRow()] // // IF IsNull(ls_cusid) OR ls_cusid = 0 THEN // THIS.TriggerEvent("ue_f9") // END IF // // OpenWithParm(w_unit_ch,ls_mtrlid) // s_unit s_inscust // s_inscust = Message.PowerObjectParm //接受返回结构 // // IF s_inscust.unit <> '' THEN // dw_child.Object.u_saletaskmx_unit[dw_child.GetRow()] = s_inscust.unit // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()] // ls_1stunit = s_inscust.unit // IF f_getmtrlcusprice(ls_moneyid,ls_mtrlid,ls_cusid,ls_1stunit,'','','',0,rtn_price,rtn_zqrate,rtn_rate,arg_msg) <> 1 THEN // dw_child.Object.u_saletaskmx_rate[dw_child.GetRow()] = s_inscust.rate // ELSE // dw_child.Object.u_saletaskmx_enprice[dw_child.GetRow()]= rtn_price // dw_child.Object.u_saletaskmx_rebate[dw_child.GetRow()] = rtn_zqrate // dw_child.Object.u_saletaskmx_rate[dw_child.GetRow()] = rtn_rate // END IF // END IF //END IF // // // end event event ue_f6;call super::ue_f6;////用于选择明细内容,被f8[默认]\dw_child.doubleclicked调用 //IF NOT dw_edit_mode THEN RETURN //Long child_row //Long ls_cusid,ll_moneyid //child_row = dw_child.GetRow() //dw_uc.accepttext() // //ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] //IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox('提示','请先选择币种',information!,OK!) // RETURN //END IF // //ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()] //IF IsNull(ls_cusid) OR ls_cusid = 0 THEN // THIS.TriggerEvent("ue_f9") //END IF // //IF NOT IsValid(w_saletask_mtrl_his_ch) THEN // s_edit_index_tran s_tranf8 //传递参数使用 // s_tranf8.if_retrieve_all = FALSE //是否一次retrieve所有行 // s_tranf8.work_mode = 1 //0-单纯编辑模式 1-选择\编辑模式 // s_tranf8.arg_pkid = 0 //目标定位pkid (备用) // s_tranf8.arg_string_code = '' //查询列(物料编码)部分内容,用于初步筛选 // s_tranf8.if_select_all = TRUE //多选 // s_tranf8.b_long = 0 // s_tranf8.d_long = ls_cusid // // Long ls_j // OpenWithParm(w_saletask_mtrl_his_ch,s_tranf8) //调用 // // s_saletask_mtrl s_inscust // s_inscust = Message.PowerObjectParm //接受返回结构 // FOR ls_j = 1 TO UpperBound(s_inscust.mtrlid) // IF s_inscust.mtrlid[ls_j] > 0 THEN //正常返回值则可以取以下值 // IF dw_child.GetRow() > 0 THEN // IF dw_child.Object.mtrlid[child_row] <> 0 THEN // child_row = dw_child.InsertRow (0) // ELSE // child_row = dw_child.GetRow() // END IF // ELSE // child_row = dw_child.InsertRow (0) // END IF // // dw_child.Object.mtrlid[child_row] = s_inscust.mtrlid[ls_j] // dw_child.Object.u_mtrldef_mtrlcode[child_row] = s_inscust.mtrlcode[ls_j] // dw_child.Object.mtrlname[child_row] = s_inscust.mtrlname[ls_j] // dw_child.Object.saleqty[child_row] = 0 // dw_child.Object.plprice[child_row] = s_inscust.planprice[ls_j] // dw_child.Object.u_mtrldef_mtrlmode[child_row] = s_inscust.mtrlmode[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.u_saletaskmx_unit[child_row] = s_inscust.unit[ls_j] // dw_child.Object.u_saletaskmx_enprice[child_row] = s_inscust.price[ls_j] // dw_child.Object.u_saletaskmx_rebate[child_row] = s_inscust.rebate[ls_j] // dw_child.Object.u_saletaskmx_status[child_row] = s_inscust.status[ls_j] // dw_child.Object.u_saletaskmx_woodcode[child_row] = s_inscust.woodcode[ls_j] // dw_child.Object.u_saletaskmx_pcode [child_row] = s_inscust.pcode[ls_j] // // // dw_child.SetColumn('usaleqty') // END IF // NEXT //END IF //dw_child.SetFocus() // // // // end event event ue_rpt_viewprint;call super::ue_rpt_viewprint;IF NOT f_power_ind(984) THEN MessageBox('提示','你没有使用权限!',information!,OK!) RETURN END IF Long row,uc_relid,ll_scid row = dw_pageretr.GetRow() IF row = 0 THEN RETURN END IF s_rpt_print_msg s_print s_print.retr_pram_falg = 15 s_print.rpid = ls_msgprintid_rpt s_print.retr_flag = TRUE s_print.tag_text = THIS.Title s_print.rpname = ls_rpname s_print.retr_scid = dw_pageretr.Object.u_saletask_scid[row] s_print.retr_pramnmb = dw_pageretr.Object.taskid[row] s_print.rowcnt = dw_child.RowCount() OpenWithParm(w_rpt_preview,s_print) //**更新打印次料 String arg_msg printnum = Message.DoubleParm f_update_printnum('u_saletask',printnum,dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()],dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE) end event event ue_rpt_print;call super::ue_rpt_print;IF NOT f_power_ind(984) THEN MessageBox('提示','你没有使用权限!',information!,OK!) RETURN END IF Long row,uc_relid,ll_scid row = dw_pageretr.GetRow() uo_rpt_print_preview uo_print S_rpt_print_MSG LS_PRMSG IF dw_uc.RowCount() = 0 THEN MessageBox('提示','没有可打印的单据!',information!,OK!) RETURN END IF IF MessageBox ("询问","是否确定要打印当前单据吗?",Question!,YesNo! ) = 2 THEN RETURN LS_PRMSG.retr_pram_falg = 15 LS_PRMSG.TAG_TEXT = '销售订单' LS_PRMSG.rpname = ls_rpname LS_PRMSG.FILTER_STRING = '' LS_PRMSG.PAGECH_FLAG = 0 LS_PRMSG.rpid = ls_msgprintid_rpt LS_PRMSG.retr_scid = dw_pageretr.Object.u_saletask_scid[dw_pageretr.GetRow()] LS_PRMSG.retr_pramnmb = dw_pageretr.Object.taskid[dw_pageretr.GetRow()] LS_PRMSG.rowcnt = dw_child.RowCount() uo_print.FACT_PRINT_MSG = LS_PRMSG String arg_msg IF uo_print.uof_print_begin(arg_msg) = 0 THEN MessageBox("错误",arg_msg,stopsign!,OK!) RETURN END IF uo_print.ds_print() //**更新打印次料 printnum = Message.DoubleParm f_update_printnum('u_saletask',1,cur_scid,dw_pageretr.Object.taskid[dw_pageretr.GetRow()],'','',arg_msg,TRUE) end event type cb_func from w_publ_1ton_share_detail`cb_func within w_saletask_sc integer taborder = 20 end type type cb_exit from w_publ_1ton_share_detail`cb_exit within w_saletask_sc integer x = 1138 integer taborder = 240 end type type sle_usual_query from w_publ_1ton_share_detail`sle_usual_query within w_saletask_sc integer x = 206 integer y = 188 integer width = 549 end type type cb_retrieveall from w_publ_1ton_share_detail`cb_retrieveall within w_saletask_sc integer x = 1605 integer taborder = 200 end type type em_pagerowno from w_publ_1ton_share_detail`em_pagerowno within w_saletask_sc integer x = 1289 integer width = 320 integer taborder = 180 end type type dw_pageretr from w_publ_1ton_share_detail`dw_pageretr within w_saletask_sc integer x = 2117 integer y = 296 integer width = 1445 integer height = 736 integer taborder = 30 string title = "销售订单摘要内容" string dataobject = "dw_saletask_index_sc" boolean hscrollbar = false boolean border = true borderstyle borderstyle = stylebox! end type event dw_pageretr::rowfocuschanged;call super::rowfocuschanged;wf_statusbtn_fc() wf_check_billfj() if currentrow<=0 then dw_child.reset() end event event dw_pageretr::retrieveend;wf_statusbtn_fc() end event type st_1 from w_publ_1ton_share_detail`st_1 within w_saletask_sc integer y = 208 integer width = 178 alignment alignment = right! end type type cb_nextpage from w_publ_1ton_share_detail`cb_nextpage within w_saletask_sc integer x = 1755 integer taborder = 230 end type type dw_uc from w_publ_1ton_share_detail`dw_uc within w_saletask_sc integer y = 296 integer width = 2112 integer height = 736 integer taborder = 120 string dataobject = "dw_saletask_input_sc" 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.ScrollToRow(1) dw_child.SetFocus() dw_child.SetColumn ('u_saletaskmx_outtype') RETURN 1 ELSEIF dw_uc.GetColumnName ( ) = 'u_cust_cuscode' AND Key = KeyEnter! THEN String ls_code,ls_name,ls_custype,ls_find_code String ls_freight,ls_freight_tele String ls_cus_address,ls_cus_tele,ls_cus_fax 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, u_cust.freight_tele, u_cust.address, u_cust.tele, u_cust.faxno INTO :ls_cusid,:ls_name,:ls_custype,:ls_code, :ls_freight,:ls_freight_tele, :ls_cus_address,:ls_cus_tele,:ls_cus_fax 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, u_cust.freight, u_cust.freight_tele, u_cust.address, u_cust.tele, u_cust.faxno INTO :ls_cusid,:ls_code,:ls_name, :ls_freight,:ls_freight_tele, :ls_cus_address,:ls_cus_tele,:ls_cus_fax 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.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.assign_emp[dw_uc.GetRow()] = ls_custype dw_uc.Object.u_saletask_freight[dw_uc.GetRow()] = ls_freight dw_uc.Object.u_saletask_freight_tele[dw_uc.GetRow()] = ls_freight_tele dw_uc.Object.u_saletask_cus_address[dw_uc.GetRow()] = ls_cus_address dw_uc.Object.u_saletask_cus_tele[dw_uc.GetRow()] = ls_cus_tele dw_uc.Object.u_saletask_cus_fax[dw_uc.GetRow()] = ls_cus_fax dw_uc.SetRedraw(TRUE) dw_uc.SetColumn("u_saletask_cus_address") 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::itemchanged;call super::itemchanged;if not dw_edit_mode then return dw_uc.accepttext() if dw_uc.getrow() <= 0 then return if dwo.name <> 'u_saletask_moneyid' then return long ll_moneyid ll_moneyid = dw_uc.object.u_saletask_moneyid[dw_uc.getrow()] dw_uc.setredraw(false) dw_uc.object.u_saletask_mrate[dw_uc.getrow()]=f_get_mrate(ll_moneyid) dw_uc.setredraw(true) end event event dw_uc::clicked;call super::clicked; IF row <= 0 THEN RETURN IF dwo.Name = 'p_dview1' THEN PARENT.TriggerEvent('ue_f13') elseIF dwo.Name = 'p_dview2' THEN PARENT.TriggerEvent('ue_f14') END IF IF NOT dw_edit_mode THEN RETURN IF dwo.Name = 'p_p' THEN PARENT.TriggerEvent('ue_f9') //ELSEIF dwo.Name = 'b_1' THEN // IF NOT IsValid(w_outrepdef_edit_ch) THEN // Open(w_outrepdef_edit_ch) // s_outrepdef s_outrep_ch // s_outrep_ch = Message.PowerObjectParm // IF s_outrep_ch.outrepname <> '' THEN // dw_uc.Object.assign_emp[dw_uc.GetRow()] = s_outrep_ch.outrepname // END IF // END IF ELSEIF dwo.Name = 'b_2' THEN PARENT.TriggerEvent ('ue_f6') END IF end event event dw_uc::doubleclicked;IF dw_edit_mode AND row > 0 THEN IF dwo.Name = 'u_cust_cuscode' OR dwo.Name = 'u_cust_name' THEN PARENT.TriggerEvent('ue_f9') END IF END IF end event type gb_2 from w_publ_1ton_share_detail`gb_2 within w_saletask_sc end type type dw_child from w_publ_1ton_share_detail`dw_child within w_saletask_sc integer y = 1032 integer width = 3570 integer height = 1220 integer taborder = 160 string title = "销售订单明细" string dataobject = "dw_saletaskmx_sc" end type event dw_child::dwnkey;call super::dwnkey;//PARENT.TriggerEvent('user_key') // //String ls_mtrlcode,ls_mtrlname,ls_unit,ls_mtrlmode,ls_mtrlsectype,ls_zxmtrlmode //Long ls_mtrlid,ls_cusid //Dec ls_planprice,ls_lmsaleprice,ls_price,ls_rebate // //s_mtrldef_array arg_s_mtrldef // //Long child_row //Long ls_null,ll_moneyid //SetNull(ls_null) //String arg_msg = '' //string ls_woodcode,ls_status,ls_pcode //IF dw_edit_mode THEN // dw_uc.AcceptText() // // ll_moneyid = dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] // IF ll_moneyid = 0 OR IsNull(ll_moneyid) THEN // MessageBox('提示','请先选择币种',information!,OK!) // RETURN // END IF // // // ls_cusid = dw_uc.Object.cusid[dw_uc.GetRow()] // IF IsNull(ls_cusid) OR ls_cusid = 0 THEN // THIS.TriggerEvent("ue_f9") // 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!) AND NOT KeyDown(keycontrol!) AND NOT KeyDown(keyshift!) THEN // IF dw_child.GetColumnName() = 'u_mtrldef_mtrlcode' THEN // dw_child.AcceptText() // child_row = dw_child.GetRow() // // ls_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[child_row] // // IF f_find_mtrl(ls_mtrlcode,-1,arg_s_mtrldef) = 0 THEN // PARENT.TriggerEvent('ue_f8') // RETURN 1 // ELSE // ls_mtrlid = arg_s_mtrldef.mtrlid[1] // ls_mtrlcode = arg_s_mtrldef.mtrlcode[1] // ls_mtrlname = arg_s_mtrldef.mtrlname[1] // ls_unit = arg_s_mtrldef.unit[1] // ls_mtrlmode = arg_s_mtrldef.mtrlmode[1] // ls_planprice = arg_s_mtrldef.planprice[1] // ls_lmsaleprice = arg_s_mtrldef.lmsaleprice[1] // ls_mtrlsectype=arg_s_mtrldef.mtrlsectype[1] // ls_zxmtrlmode=arg_s_mtrldef.zxmtrlmode[1] // END IF // dw_child.Object.mtrlid[child_row] = ls_mtrlid // dw_child.Object.mtrlname[child_row] = ls_mtrlname // dw_child.Object.u_mtrldef_unit[child_row] = ls_unit // dw_child.Object.u_mtrldef_mtrlmode[child_row] = ls_mtrlmode // dw_child.Object.u_mtrldef_mtrlcode[child_row] = ls_mtrlcode // dw_child.Object.u_mtrldef_zxmtrlmode[child_row] = ls_zxmtrlmode // dw_child.Object.u_mtrldef_mtrlsectype[child_row] = ls_mtrlsectype // dw_child.Object.u_saletaskmx_unit[child_row] = ls_unit // // IF sys_option_price_if_status = 0 THEN // Decimal ls_1stnewprice,ls_1stzqrate,ls_1strate // IF f_getmtrlcusprice(ll_moneyid,ls_mtrlid,ls_cusid,ls_unit,'','','',0,ls_1stnewprice,ls_1stzqrate,ls_1strate,arg_msg) <> 1 THEN // dw_child.Object.u_saletaskmx_enprice[child_row] = 0 // dw_child.Object.u_saletaskmx_rebate[child_row] = 1 // ELSE // dw_child.Object.u_saletaskmx_enprice[child_row] = ls_1stnewprice // dw_child.Object.u_saletaskmx_rebate[child_row] = ls_1stzqrate // dw_child.Object.u_saletaskmx_rate[child_row] = ls_1strate // END IF // END IF // // IF Key = keyenter! THEN // keybd_event ( 9, 0, 0 , 0 ) // 按下tab // keybd_event ( 9, 0, 2, 0 ) // 释放tab // RETURN 1 // END IF // ELSEIF dw_child.GetColumnName( ) = 'u_saletaskmx_rebate' THEN // Long i_mtrlid // String i_mtrlcode // Decimal i_price,i_zqrate // dw_child.AcceptText() // // i_mtrlid = dw_child.Object.mtrlid[dw_child.GetRow()] // i_mtrlcode = dw_child.Object.u_mtrldef_mtrlcode[dw_child.GetRow()] // i_price = dw_child.Object.u_saletaskmx_fprice[dw_child.GetRow()] // i_zqrate = dw_child.Object.u_saletaskmx_rebate[dw_child.GetRow()] // //// if uo_mtrl_cus_p.uf_check_price(ls_cusid,i_mtrlid,i_price * i_zqrate,0,arg_msg)=0 then //// messagebox("系统提示",arg_msg) //// dw_child.setfocus() //// dw_child.setcolumn("u_saletaskmx_fprice") //// 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 // // ELSEIF dw_child.GetColumnName( ) = 'u_saletaskmx_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 // //// u_mtrldef_mtrlcode //// acprice //// mtrlid //// mtrlname //// plprice // // // // // // // // end event event dw_child::doubleclicked;IF dw_edit_mode THEN IF dwo.Name = 'u_saletaskmx_status' THEN PARENT.TriggerEvent('ue_f10') ELSEIF dwo.Name = 'u_saletaskmx_outtype' THEN PARENT.TriggerEvent('ue_f11') ELSEIF dwo.Name = 'u_saletaskmx_unit' THEN PARENT.TriggerEvent('ue_f12') ELSE PARENT.TriggerEvent('ue_f8') END IF END IF end event type cb_viewprint from w_publ_1ton_share_detail`cb_viewprint within w_saletask_sc integer x = 494 integer taborder = 40 end type type cb_print from w_publ_1ton_share_detail`cb_print within w_saletask_sc integer x = 302 integer taborder = 150 end type type cb_add from w_publ_1ton_share_detail`cb_add within w_saletask_sc boolean visible = false integer taborder = 140 end type event cb_add::clicked;//IF NOT f_power_ind(5) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //String arg_msg = '' //Long uc_row,pagerert_row,i //Long relid_pageretr,reld_uc // //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 dw_uc.Object.u_saletask_moneyid[uc_row] = 0 THEN // MessageBox('系统提示','请选择币种!') // dw_uc.SetFocus() // dw_uc.SetColumn("u_saletask_moneyid") // RETURN // END IF // // IF dw_uc.Object.u_saletask_banktypeid[uc_row] = 0 THEN // MessageBox('系统提示','请选择结算方式!') // dw_uc.SetFocus() // dw_uc.SetColumn("u_saletask_banktypeid") // RETURN // END IF // // IF Year(Date(dw_uc.Object.requiredate[uc_row])) < 2000 THEN // MessageBox('系统提示','要求完成日期为空或不合理!') // dw_uc.SetFocus() // dw_uc.SetColumn("requiredate") // RETURN // END IF // IF NOT Len(String(dw_uc.Object.assign_emp[uc_row])) > 0 THEN // MessageBox('系统提示','请选择业务员!') // dw_uc.SetFocus() // dw_uc.SetColumn("assign_emp") // RETURN // END IF // // IF NOT sys_power_issuper AND f_power_ind(977) THEN // arg_msg = '' // FOR i = 1 TO dw_child.RowCount() // IF dw_child.Object.u_saletaskmx_enprice[i] = 0 THEN // arg_msg = arg_msg + '第' + String(i) + '行,产品:' + dw_child.Object.u_mtrldef_mtrlcode[i] + ',单价为零!~n ' // END IF // NEXT // IF arg_msg <> '' THEN // MessageBox('系统提示',arg_msg + '受系统限制,不能保存!') // RETURN // END IF // END IF // // obj_saletask.requiredate = dw_uc.Object.requiredate[uc_row] // obj_saletask.assign_emp = dw_uc.Object.assign_emp[uc_row] // obj_saletask.Kind = dw_uc.Object.Kind[uc_row] // obj_saletask.cusid = dw_uc.Object.cusid[uc_row] // obj_saletask.dscrp = dw_uc.Object.dscrp[uc_row] // obj_saletask.dscrp2 = dw_uc.Object.u_saletask_dscrp2[uc_row] // obj_saletask.taskdate = dw_uc.Object.u_saletask_taskdate[uc_row] // obj_saletask.banktypeid = dw_uc.Object.u_saletask_banktypeid[uc_row] // obj_saletask.moneyid = dw_uc.Object.u_saletask_moneyid[uc_row] // obj_saletask.damt = dw_uc.Object.u_saletask_damt[uc_row] // obj_saletask.otheramt = dw_uc.Object.u_saletask_otheramt[uc_row] // obj_saletask.relcode = dw_uc.Object.u_saletask_relcode[uc_row] // obj_saletask.paytype = dw_uc.Object.u_saletask_paytype[uc_row] // obj_saletask.freight = dw_uc.Object.u_saletask_freight[uc_row] // obj_saletask.freight_tele = dw_uc.Object.u_saletask_freight_tele[uc_row] // obj_saletask.cus_address = dw_uc.Object.u_saletask_cus_address[uc_row] // obj_saletask.cus_tele = dw_uc.Object.u_saletask_cus_tele[uc_row] // obj_saletask.cus_fax = dw_uc.Object.u_saletask_cus_fax[uc_row] // obj_saletask.mrate = dw_uc.Object.u_saletask_mrate[uc_row] // // // FOR i = 1 TO dw_child.RowCount() // IF dw_child.Object.mtrlid[i] > 0 THEN // IF obj_saletask.acceptmx(dw_child.Object.mtrlid[i],& // dw_child.Object.usaleqty[i],& // dw_child.Object.u_saletaskmx_orderqty[i],& // dw_child.Object.u_saletaskmx_needbuyqty[i],& // dw_child.Object.u_saletaskmx_enprice[i],& // dw_child.Object.u_saletaskmx_rebate[i],& // dw_child.Object.plprice[i],& // dw_child.Object.u_saletaskmx_mxdscrp[i],& // dw_child.Object.u_mtrldef_mtrlcode[i],& // dw_child.Object.u_saletaskmx_status[i],& // dw_child.Object.u_saletaskmx_woodcode[i],& // dw_child.Object.u_saletaskmx_pcode[i],& // dw_child.Object.u_saletaskmx_mtrlcuscode[i],& // dw_child.Object.pid[i],& // dw_child.Object.u_saletaskmx_outtype[i],& // arg_msg,& // dw_child.Object.u_saletaskmx_unit[i],& // dw_child.Object.u_saletaskmx_rate[i],& // '',dw_child.Object.u_saletaskmx_addqty[i]) = 0 THEN // MessageBox('error!',arg_msg) // RETURN // END IF // END IF // NEXT // // IF obj_saletask.savesubmit(publ_operator,arg_msg,TRUE) = 0 THEN // MessageBox('error!',arg_msg) // RETURN // END IF // // messagebox(publ_operator,'保存操作成功!') // //write ini // f_SetProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",String(dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()])) // f_SetProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",String(dw_uc.Object.u_saletask_banktypeid[dw_uc.GetRow()])) // // // // Long ll_row // ll_row = dw_pageretr.GetRow() // dw_pageretr.SelectRow(0,FALSE) // dw_pageretr.SelectRow(ll_row,TRUE) // wf_refresh_curuc(cur_scid,obj_saletask.taskid) //刷新uc // //ELSE // IF obj_saletask.newbegin(cur_scid,arg_msg) = 0 THEN //生产令领料 // MessageBox('error!',arg_msg) // RETURN // END IF //END IF // //CALL SUPER::Clicked // //IF dw_edit_mode THEN // PARENT.TriggerEvent("insert_childrow") // String ls_moneyid,ls_banktype // // ls_moneyid = f_ProfileString (sys_empid,publ_userid+'_'+dw_uc.DataObject, "moneyid",'0') // ls_banktype = f_ProfileString (sys_empid,dw_uc.DataObject, "dft_banktype",'0') // dw_uc.SetRedraw(FALSE) // dw_uc.Object.u_saletask_moneyid[dw_uc.GetRow()] = Long(ls_moneyid) // dw_uc.Object.u_saletask_mrate[dw_uc.GetRow()] = f_get_mrate(Long(ls_moneyid)) // dw_uc.Object.u_saletask_banktypeid[dw_uc.GetRow()] = Long(ls_banktype) // dw_uc.SetColumn("u_saletask_moneyid") // dw_uc.SetRedraw(TRUE) //ELSE // PARENT.TriggerEvent("retrieve_childdw") //END IF // // // // // // // end event type cb_edit from w_publ_1ton_share_detail`cb_edit within w_saletask_sc boolean visible = false integer taborder = 110 end type event cb_edit::clicked;//if not f_power_ind(5) then // messagebox(publ_operator,'你没有使用权限!') // 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('系统提示','请选定当前目标单据!') // return // end if //end if // //if not dw_edit_mode then // if obj_saletask.updatebegin(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.object.taskid[uc_row],arg_msg)=0 then // messagebox('Error!',arg_msg) // return // end if //end if // //call super::clicked end event type cb_delet from w_publ_1ton_share_detail`cb_delet within w_saletask_sc boolean visible = false integer taborder = 170 end type event cb_delet::clicked;call super::clicked;//if not f_power_ind(579) then // messagebox(publ_operator,'你没有使用权限!') // return //end if // //if dw_edit_mode then return // //string arg_msg='' //long uc_row // //uc_row=dw_pageretr.getrow() //if uc_row<=0 then // messagebox('系统提示','请选定当前目标订单!') // return //end if // //IF MessageBox ("IF","是否确定要删除当前吗",Question!,YesNo! ) = 2 THEN RETURN // // //if obj_saletask.cancel(dw_pageretr.Object.u_saletask_scid[uc_row],dw_pageretr.object.taskid[uc_row],arg_msg,true)=0 then // messagebox('Error!',arg_msg) //ELSE // //日志 // long ls_id // string ls_code // ls_id=dw_pageretr.object.taskid[uc_row] // ls_code=dw_pageretr.object.taskCODE[uc_row] // f_setsysoplog('销售订单','删除,ID:'+string(LS_id)+',code:'+ls_code,arg_msg,true) // //-- // MESSAGEBOX(publ_operator,'删除单据'+string(dw_pageretr.object.taskCODE[uc_row])+'成功!') // // // dw_pageretr.deleterow(uc_row) // dw_pageretr.postevent(rowfocuschanged!) //end if end event type cb_addzy from w_publ_1ton_share_detail`cb_addzy within w_saletask_sc boolean visible = false 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_tempstoptask" menustr=menustr + "|" + "Text=取消暂停~tEvent=ue_ctempstoptask" menustr=menustr + "|" + "Text=终止订单~tEvent=ue_stopsaletask" menustr=menustr + "|" + "Text=完成订单~tEvent=ue_finishtask" menustr=menustr + "|" + "Text=-" menustr=menustr + "|" + "Text=导入单价~tEvent=ue_importseleprice" menustr=menustr + "|" + "Text=导入客户历史售价~tEvent=ue_importcusseleprice_his" menustr=menustr + "|" + "Text=导入客户单价~tEvent=ue_importcusseleprice" menustr = menustr + "|" + "Text=-" menustr = menustr + "|" + "Text=查看附件~tEvent=ue_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_saletask_sc boolean visible = false integer taborder = 190 end type event cb_auditing::clicked;call super::clicked;//if not f_power_ind(6) then // messagebox(publ_operator,'你没有使用权限!') // return //end if // //if dw_edit_mode then return //string arg_msg='' //long pagerert_row // //pagerert_row=dw_pageretr.getrow() //if pagerert_row<=0 then // messagebox('系统提示','请选定当前目标订单!') // return //end if //IF MessageBox ("IF","是否确定要对当前订单作销售审核吗?",Question!,YesNo! ) = 2 THEN RETURN // //if obj_saletask.salepermit(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row],publ_operator,arg_msg,true)=0 then // messagebox('Error!',arg_msg) //ELSE // messagebox(publ_operator,'订单销售审核成功!') // if cur_status <> -1 then // dw_uc.deleterow(pagerert_row) // else // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.object.taskid[pagerert_row]) // end if //end if end event type cb_xm from w_publ_1ton_share_detail`cb_xm within w_saletask_sc boolean visible = false integer taborder = 70 end type type cb_retrieve from w_publ_1ton_share_detail`cb_retrieve within w_saletask_sc integer taborder = 130 end type type cb_xls from w_publ_1ton_share_detail`cb_xls within w_saletask_sc integer x = 686 end type type cb_help from w_publ_1ton_share_detail`cb_help within w_saletask_sc integer x = 987 integer taborder = 100 end type type cb_auditing_cancel from w_publ_1ton_share_detail`cb_auditing_cancel within w_saletask_sc boolean visible = false end type event cb_auditing_cancel::clicked;call super::clicked;//IF NOT f_power_ind(8) THEN // MessageBox(publ_operator,'你没有使用权限!') // RETURN //END IF // //IF dw_edit_mode THEN RETURN //String arg_msg = '' //Long pagerert_row // //pagerert_row = dw_pageretr.GetRow() //IF pagerert_row <= 0 THEN // MessageBox('系统提示','请选定当前目标订单!') // RETURN //END IF //IF MessageBox ("IF","是否确定要对当前订单作取消审核吗?",Question!,YesNo! ) = 2 THEN RETURN // //IF obj_saletask.cancelpermit(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row],arg_msg,TRUE) = 0 THEN // MessageBox('Error!',arg_msg) //ELSE // MessageBox(publ_operator,'订单取消审核成功!') // // //日志 // String ls_code,ls_opemp,ls_relcode // ls_code = dw_pageretr.Object.taskcode[pagerert_row] // ls_opemp = dw_pageretr.Object.u_saletask_opemp[pagerert_row] // ls_relcode = dw_pageretr.Object.u_saletask_relcode[pagerert_row] // f_setsysoplog('销售订单','撤审'+',code:'+ls_code+',相关号码:'+ls_relcode+',建立人:'+ls_opemp,arg_msg,TRUE) // //-- // // IF cur_status <> -1 THEN // // dw_uc.DeleteRow(pagerert_row) // ELSE // wf_refresh_curuc(dw_pageretr.Object.u_saletask_scid[pagerert_row],dw_pageretr.Object.taskid[pagerert_row]) // END IF //END IF end event type p_msg from w_publ_1ton_share_detail`p_msg within w_saletask_sc end type type p_help from w_publ_1ton_share_detail`p_help within w_saletask_sc end type type p_encl from w_publ_1ton_share_detail`p_encl within w_saletask_sc end type type p_other from w_publ_1ton_share_detail`p_other within w_saletask_sc end type type gb_3 from w_publ_1ton_share_detail`gb_3 within w_saletask_sc end type type ln_bar from w_publ_1ton_share_detail`ln_bar within w_saletask_sc end type type ln_bar2 from w_publ_1ton_share_detail`ln_bar2 within w_saletask_sc end type type r_bar from w_publ_1ton_share_detail`r_bar within w_saletask_sc integer height = 168 end type type ln_1 from w_publ_1ton_share_detail`ln_1 within w_saletask_sc integer endx = 3227 end type type ln_2 from w_publ_1ton_share_detail`ln_2 within w_saletask_sc integer endx = 3227 end type type ddlb_retrstatus from dropdownlistbox within w_saletask_sc integer x = 1787 integer y = 192 integer width = 489 integer height = 856 integer taborder = 80 integer textsize = -9 integer weight = 400 fontcharset fontcharset = gb2312charset! fontpitch fontpitch = variable! string facename = "宋体" long textcolor = 33554432 string text = "待审批" boolean sorted = false boolean vscrollbar = true string item[] = {"待审批","在进行","已暂停","已终止","已完成","[所有]",""} borderstyle borderstyle = stylelowered! end type event selectionchanged;choose case index case 1 //待销售审批 cur_status=0 case 2 //在进行 cur_status=1 case 3 //'已暂停' cur_status=2 case 4 //'已终止' cur_status=3 case 5 //'已完成' cur_status=5 case else cur_status= -1 end choose parent.triggerevent("retrieve_pageretr") end event event constructor;cur_status=long(f_ProfileString (sys_empid, "saletask", "status", "-1")) choose case cur_status case 0 ddlb_retrstatus.text="待审核" case 1 ddlb_retrstatus.text="在进行" case 2 ddlb_retrstatus.text="已暂停" case 3 ddlb_retrstatus.text="已终止" case 5 ddlb_retrstatus.text="已完成" case -1 ddlb_retrstatus.text="[所有]" end choose end event type ddlb_scid from uo_ddlb_scid within w_saletask_sc integer x = 1015 integer y = 192 integer width = 549 integer height = 620 integer taborder = 50 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_2 from statictext within w_saletask_sc integer x = 818 integer y = 208 integer width = 174 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 = "分 部" alignment alignment = right! boolean focusrectangle = false end type type st_3 from statictext within w_saletask_sc integer x = 1591 integer y = 208 integer width = 174 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 = "状 态" alignment alignment = right! boolean focusrectangle = false end type