dw_rp_outware_sale_edit_th.srd 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. $PBExportHeader$dw_rp_outware_sale_edit_th.srd
  2. release 9;
  3. datawindow(units=1 timer_interval=60000 color=16777215 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 24 print.margin.right = 24 print.margin.top = 24 print.margin.bottom = 24 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
  4. header(height=109 color="536870912" )
  5. summary(height=21 color="536870912" )
  6. footer(height=134 color="536870912" )
  7. detail(height=30 color="536870912" height.autosize=yes)
  8. table(column=(type=long updatewhereclause=yes name=u_outware_outwareid dbname="u_outware.outwareid" initial="null" values="单据ID /" )
  9. column=(type=datetime updatewhereclause=yes name=u_outware_outdate dbname="u_outware.outdate" initial="null" )
  10. column=(type=char(10) updatewhereclause=yes name=u_outware_outrep dbname="u_outware.outrep" initial="null" values="业务员 /" )
  11. column=(type=char(50) updatewhereclause=yes name=u_outware_part dbname="u_outware.part" initial="null" values="相关号码 /" )
  12. column=(type=char(255) updatewhereclause=yes name=u_outware_dscrp dbname="u_outware.dscrp" initial="null" )
  13. column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="null" )
  14. column=(type=char(20) updatewhereclause=yes name=u_outware_outwarecode dbname="u_outware.outwarecode" initial="null" )
  15. column=(type=datetime updatewhereclause=yes name=u_outware_opdate dbname="u_outware.opdate" initial="null" values="建立时间 /" )
  16. column=(type=char(10) updatewhereclause=yes name=u_outware_opemp dbname="u_outware.opemp" initial="null" )
  17. column=(type=datetime updatewhereclause=yes name=u_outware_auditingdate dbname="u_outware.auditingdate" initial="null" values="审核时间 /" )
  18. column=(type=long updatewhereclause=yes name=u_outware_flag dbname="u_outware.flag" initial="null" values="审核标志 /" )
  19. column=(type=char(10) updatewhereclause=yes name=u_outware_auditingrep dbname="u_outware.auditingrep" initial="null" values="审核人 /" )
  20. column=(type=long updatewhereclause=yes name=u_outware_cusid dbname="u_outware.cusid" initial="null" values="客户id /" )
  21. column=(type=long updatewhereclause=yes name=u_outware_balcflag dbname="u_outware.balcflag" initial="null" values="日结标记 /" )
  22. column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="null" )
  23. column=(type=char(100) updatewhereclause=yes name=u_cust_tele dbname="u_cust.tele" initial="null" )
  24. column=(type=char(4099) updatewhereclause=yes name=u_cust_address dbname="address" initial="null" )
  25. column=(type=long updatewhereclause=yes name=u_outware_relid dbname="u_outware.relid" initial="null" values="相关ID /" )
  26. column=(type=long updatewhereclause=yes name=u_outware_relint_1 dbname="u_outware.relint_1" initial="null" )
  27. column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_1 dbname="u_outware.relstr_1" initial="null" )
  28. column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_2 dbname="u_outware.relstr_2" initial="null" )
  29. column=(type=long updatewhereclause=yes name=u_outware_printnum dbname="u_outware.printnum" initial="null" values="打印次数 /" )
  30. retrieve="SELECT u_outware.outwareid,
  31. u_outware.outdate,
  32. u_outware.outrep,
  33. u_outware.part,
  34. u_outware.dscrp,
  35. u_cust.name,
  36. u_outware.outwarecode,
  37. u_outware.opdate,
  38. u_outware.opemp,
  39. u_outware.auditingdate,
  40. u_outware.flag,
  41. u_outware.auditingrep,
  42. u_outware.cusid,
  43. u_outware.balcflag,
  44. u_cust.cuscode,
  45. u_cust.tele,
  46. convert (text,u_cust.address) as address,
  47. u_outware.relid,
  48. u_outware.relint_1,
  49. u_outware.relstr_1,
  50. u_outware.relstr_2,
  51. u_outware.printnum
  52. FROM u_cust,
  53. u_outware
  54. WHERE ( u_cust.cusid = u_outware.cusid ) and
  55. ( u_outware.billtype = 1 ) AND
  56. ( u_outware.outwareid = :arg_outwareid ) and
  57. ( u_outware.scid = :arg_scid ) and
  58. ( :arg_printrow = :arg_printrow ) and
  59. ( :arg_top = :arg_top )
  60. " arguments=(("arg_scid", number),("arg_outwareid", number),("arg_printrow", number),("arg_top", number)) )
  61. line(band=header x1="276" y1="37" x2="450" y2="37" name=l_4 visible="1" pen.style="0" pen.width="2" pen.color="33554432" background.mode="2" background.color="1073741824" )
  62. text(band=header alignment="2" text="退货单" border="0" color="0" x="203" y="2" height="31" width="319" html.valueishtml="0" name=title visible="1" resizeable=1 moveable=1 font.face="宋体" font.height="-20" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  63. compute(band=header alignment="0" expression="if( u_outware_printnum > 0,'(重复打印-'+string( u_outware_printnum )+')','')"border="0" color="0" x="532" y="27" height="22" width="182" format="[GENERAL]" html.valueishtml="0" name=compute_6 tag="if( u_outware_printnum > 0,'(重复打印-'+string( u_outware_printnum )+')','')" visible="1" font.face="宋体" font.height="-12" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  64. compute(band=header alignment="2" expression="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'"border="0" color="0" x="532" y="6" height="15" width="144" format="[general]" html.valueishtml="0" name=compute_2 tag="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'" visible="1~tif( pageCount()>1,1,0)" moveable=1 font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  65. text(band=header alignment="0" text="客户编号:" border="0" color="0" x="3" y="59" height="17" width="61" html.valueishtml="0" name=u_cust_cuscode_t visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  66. text(band=header alignment="1" text="客户名称:" border="0" color="0" x="220" y="59" height="17" width="67" html.valueishtml="0" name=u_cust_name_t visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  67. column(band=header id=15 alignment="0" tabsequence=32766 border="0" color="0" x="66" y="59" height="19" width="151" format="[general]" html.valueishtml="0" name=u_cust_cuscode tag="u_cust_cuscode" visible="1" resizeable=1 moveable=1 edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-14" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  68. column(band=header id=6 alignment="0" tabsequence=32766 border="0" color="0" x="289" y="59" height="19" width="256" format="[general]" html.valueishtml="0" name=u_cust_name tag="u_cust_name" visible="1" resizeable=1 moveable=1 edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-14" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  69. text(band=header alignment="0" text="单据编号:" border="0" color="0" x="548" y="59" height="17" width="61" html.valueishtml="0" name=u_outware_outwarecode_t visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  70. column(band=header id=7 alignment="0" tabsequence=32766 border="0" color="0" x="611" y="59" height="17" width="104" format="[general]" html.valueishtml="0" name=u_outware_outwarecode tag="u_outware_outwarecode" visible="1" resizeable=1 moveable=1 edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  71. text(band=header alignment="0" text="客户电话:" border="0" color="0" x="3" y="88" height="17" width="61" html.valueishtml="0" name=t_2 visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  72. text(band=header alignment="1" text="客户地址:" border="0" color="0" x="220" y="88" height="17" width="67" html.valueishtml="0" name=t_3 visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  73. column(band=header id=17 alignment="0" tabsequence=32766 border="0" color="0" x="289" y="88" height="17" width="255" format="[general]" html.valueishtml="0" name=u_cust_address tag="u_cust_address" visible="1" resizeable=1 moveable=1 edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  74. text(band=header alignment="0" text="日 期:" border="0" color="0" x="548" y="88" height="15" width="61" html.valueishtml="0" name=u_outware_outdate_t visible="1" moveable=1 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  75. column(band=header id=2 alignment="0" tabsequence=32766 border="0" color="0" x="611" y="88" height="17" width="104" format="yyyy-mm-dd" html.valueishtml="0" name=u_outware_outdate tag="u_outware_outdate" visible="1" moveable=1 edit.limit=0 edit.case=any edit.format="yyyy-mm-dd h:mm" edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  76. column(band=header id=16 alignment="0" tabsequence=32766 border="0" color="0" x="66" y="88" height="17" width="151" format="[general]" html.valueishtml="0" name=u_cust_tele tag="u_cust_tele" visible="1" resizeable=1 moveable=1 edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  77. report(band=detail dataobject="dw_rp_outwaremx_sale_index_th" x="3" y="2" height="25" width="718" border="0" height.autosize=yes criteria="" nest_arguments=((" arg_scid "),(" arg_outwareid"),(" arg_printrow "),(" arg_top ")) trail_footer = yes name=mxreport visible="1" slideleft=yes slideup=directlyabove )
  78. compute(band=summary alignment="1" expression="pageCount() + '页' "border="0" color="0" x="13" y="3" height="18" width="48" format="[general]" html.valueishtml="0" name=compute_5 tag="pageCount() + '页' " visible="1~tif(pageCount()>1,1,0)" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  79. report(band=summary dataobject="dw_rp_outwaremx_saletask_sumamt_th" x="59" y="0" height="20" width="661" border="0" height.autosize=yes criteria="" nest_arguments=((" arg_scid "),(" arg_outwareid ")) trail_footer = yes name=dw_1 visible="1" slideup=directlyabove )
  80. rectangle(band=footer x="3" y="3" height="82" width="718" name=r_1 visible="1" slideup=allabove brush.hatch="6" brush.color="16777215" pen.style="0" pen.width="1" pen.color="0" background.mode="2" background.color="33554432" )
  81. line(band=footer x1="3" y1="30" x2="721" y2="30" name=l_1 visible="1" slideup=allabove pen.style="0" pen.width="1" pen.color="0" background.mode="2" background.color="0" )
  82. line(band=footer x1="3" y1="59" x2="721" y2="59" name=l_2 visible="1" slideup=allabove pen.style="0" pen.width="1" pen.color="0" background.mode="2" background.color="0" )
  83. line(band=footer x1="341" y1="30" x2="341" y2="59" name=l_3 visible="1" slideup=allabove pen.style="0" pen.width="1" pen.color="0" background.mode="2" background.color="0" )
  84. text(band=footer alignment="0" text="[说明]" border="0" color="0" x="8" y="116" height="15" width="710" html.valueishtml="0" name=t_7 visible="1" moveable=1 slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  85. column(band=footer id=5 alignment="0" tabsequence=32766 border="0" color="0" x="72" y="8" height="17" width="641" format="[general]" html.valueishtml="0" name=u_outware_dscrp tag="备注" visible="1" resizeable=1 moveable=1 slideup=allabove height.autosize=yes edit.limit=200 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.autovscroll=yes edit.imemode=0 edit.vscrollbar=yes font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  86. column(band=footer id=19 alignment="0" tabsequence=32766 border="0" color="0" x="72" y="36" height="18" width="203" format="[general]" html.valueishtml="0" name=u_outware_relint_1 tag="u_outware_relint_1" visible="1" slideup=allabove dddw.name=ddd_sale_taketype dddw.displaycolumn=banktypename dddw.datacolumn=banktypeid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 font.face="宋体" font.height="-11" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  87. text(band=footer alignment="1" text="备 注:" border="0" color="0" x="9" y="8" height="15" width="61" html.valueishtml="0" name=u_outware_dscrp_t visible="1" moveable=1 slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  88. text(band=footer alignment="0" text="收款方式:" border="0" color="0" x="9" y="36" height="15" width="61" html.valueishtml="0" name=t_1 visible="1" slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  89. text(band=footer alignment="0" text="送货地址:" border="0" color="0" x="9" y="64" height="15" width="61" html.valueishtml="0" name=t_9 visible="1" slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  90. column(band=footer id=9 alignment="0" tabsequence=32766 border="0" color="0" x="72" y="91" height="15" width="70" format="[general]" html.valueishtml="0" name=u_outware_opemp tag="u_outware_opemp" visible="1" slideup=allabove edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  91. text(band=footer alignment="0" text="制 单 人:" border="0" color="0" x="9" y="91" height="15" width="61" html.valueishtml="0" name=u_outware_operator_t visible="1" moveable=1 slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  92. column(band=footer id=20 alignment="0" tabsequence=32766 border="0" color="0" x="72" y="64" height="17" width="269" format="[general]" html.valueishtml="0" name=u_outware_relstr_1 tag="u_outware_relstr_1" visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  93. column(band=footer id=21 alignment="0" tabsequence=32766 border="0" color="0" x="417" y="64" height="16" width="300" format="[general]" html.valueishtml="0" name=u_outware_relstr_2 tag="u_outware_relstr_2" visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  94. text(band=footer alignment="1" text="收货单位(签名生效):" border="0" color="0" x="518" y="91" height="15" width="141" html.valueishtml="0" name=t_6 visible="1" moveable=1 slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  95. text(band=footer alignment="1" text="欠收金额:" border="0" color="0" x="579" y="36" height="15" width="80" html.valueishtml="0" name=t_8 visible="1" slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  96. text(band=footer alignment="0" text="送货人签名:" border="0" color="0" x="346" y="91" height="15" width="77" html.valueishtml="0" name=t_5 visible="1" moveable=1 slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  97. text(band=footer alignment="0" text="电 话:" border="0" color="0" x="346" y="64" height="15" width="69" html.valueishtml="0" name=t_10 visible="1" slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  98. text(band=footer alignment="0" text="已收订金:" border="0" color="0" x="346" y="36" height="15" width="72" html.valueishtml="0" name=t_4 visible="1" slideup=allabove font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  99. htmltable(border="0" )
  100. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  101. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  102. import.xml()
  103. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )