Etusivu Tutki Apua
Kirjaudu sisään
Neil
/
Q5
1
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Branch: master
Branchit Tagit
Q5
/
ws_objects
/
Ew_printbill.pbl.src
/
dw_rp_inware_buy_edit_audit.srd

dw_rp_inware_buy_edit_audit.srd 14 KB
Pysyvä linkki Historia Raaka

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 
  1. $PBExportHeader$dw_rp_inware_buy_edit_audit.srd
    2. 

  2. release 9;
    3. 

  3. datawindow(units=1 timer_interval=0 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. 

  4. header(height=104 color="536870912" )
    5. 

  5. summary(height=0 color="536870912" )
    6. 

  6. footer(height=23 color="536870912" )
    7. 

  7. detail(height=23 color="536870912"  height.autosize=yes)
    8. 

  8. table(column=(type=long updatewhereclause=yes name=u_inware_inwareid dbname="u_inware.inwareid" initial="null" values="单据ID	/" )
    9. 

  9.  column=(type=long updatewhereclause=yes name=u_inware_storageid dbname="u_inware.storageid" initial="null" )
    10. 

  10.  column=(type=datetime updatewhereclause=yes name=u_inware_indate dbname="u_inware.indate" initial="null" )
    11. 

  11.  column=(type=char(10) updatewhereclause=yes name=u_inware_inrep dbname="u_inware.inrep" initial="null" )
    12. 

  12.  column=(type=char(50) updatewhereclause=yes name=u_inware_part dbname="u_inware.part" initial="null" values="相关号码	/" )
    13. 

  13.  column=(type=char(255) updatewhereclause=yes name=u_inware_dscrp dbname="u_inware.dscrp" initial="null" )
    14. 

  14.  column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" initial="null" )
    15. 

  15.  column=(type=datetime updatewhereclause=yes name=u_inware_opdate dbname="u_inware.opdate" initial="null" values="建立时间	/" )
    16. 

  16.  column=(type=char(10) updatewhereclause=yes name=u_inware_opemp dbname="u_inware.opemp" initial="null" )
    17. 

  17.  column=(type=long updatewhereclause=yes name=u_inware_flag dbname="u_inware.flag" initial="null" values="默认0审核标志（0未审核，1审核）	/" )
    18. 

  18.  column=(type=datetime updatewhereclause=yes name=u_inware_auditingdate dbname="u_inware.auditingdate" initial="null" values="审核时间	/" )
    19. 

  19.  column=(type=char(10) updatewhereclause=yes name=u_inware_auditingrep dbname="u_inware.auditingrep" initial="null" values="审核人	/" )
    20. 

  20.  column=(type=char(30) updatewhereclause=yes name=u_inware_inwarecode dbname="u_inware.inwarecode" initial="null" )
    21. 

  21.  column=(type=long updatewhereclause=yes name=u_inware_sptid dbname="u_inware.sptid" initial="null" values="供应商id（记帐模式使用）	/" )
    22. 

  22.  column=(type=long updatewhereclause=yes name=u_inware_balcflag dbname="u_inware.balcflag" initial="null" values="日结标记：0（默认）-未日结，1-已日结	/" )
    23. 

  23.  column=(type=char(20) updatewhereclause=yes name=u_spt_sptcode dbname="u_spt.sptcode" initial="null" values="供应商编号	/" )
    24. 

  24.  column=(type=char(100) updatewhereclause=yes name=u_spt_tele dbname="u_spt.tele" initial="null" )
    25. 

  25.  column=(type=long updatewhereclause=yes name=u_inware_thflag dbname="u_inware.thflag" initial="null" values="退货标记	/" )
    26. 

  26.  column=(type=long updatewhereclause=yes name=u_inware_printnum dbname="u_inware.printnum" initial="null" values="打印次数	/" )
    27. 

  27.  column=(type=long updatewhereclause=yes name=u_inware_relint_1 dbname="u_inware.relint_1" initial="null" )
    28. 

  28.  retrieve="SELECT  u_inware.inwareid ,
    29. 

  29.            u_inware.storageid ,
    30. 

  30.            u_inware.indate ,
    31. 

  31.            u_inware.inrep ,
    32. 

  32.            u_inware.part ,
    33. 

  33.            u_inware.dscrp ,
    34. 

  34.            u_spt.name ,
    35. 

  35.            u_inware.opdate ,   
    36. 

  36.            u_inware.opemp ,
    37. 

  37.            u_inware.flag ,
    38. 

  38.            u_inware.auditingdate ,
    39. 

  39.            u_inware.auditingrep ,
    40. 

  40.            u_inware.inwarecode ,
    41. 

  41.            u_inware.sptid ,
    42. 

  42.            u_inware.balcflag ,
    43. 

  43.            u_spt.sptcode ,
    44. 

  44.            u_spt.tele ,
    45. 

  45.            u_inware.thflag ,
    46. 

  46. 				u_inware.printnum,
    47. 

  47. 				u_inware.relint_1
    48. 

  48.         FROM u_inware LEFT OUTER JOIN 
    49. 

  49. 				 u_spt ON u_inware.sptid = u_spt.sptid 				
    50. 

  50.         WHERE ( u_inware.billtype = 1 ) and
    51. 

  51. 				  ( u_inware.inwareid = :arg_inwareid ) and
    52. 

  52. 				  ( u_inware.scid = :arg_scid ) and
    53. 

  53. 				  ( :arg_printrow = :arg_printrow ) and
    54. 

  54. 				  ( :arg_top = :arg_top )
    55. 

  55. 				" arguments=(("arg_scid", number),("arg_inwareid", number),("arg_printrow", number),("arg_top", number)) )
    56. 

  56. bitmap(band=header filename="cus_logo.bmp" x="2" y="2" height="88" width="127" border="0"  name=p_1 visible="1"  moveable=1 )
    57. 

  57. compute(band=header alignment="0" expression="if( u_inware_printnum > 0,'(重复打印-'+string(u_inware_printnum)+')','')"border="0" color="0" x="445" y="5" height="25" width="126" format="[GENERAL]" html.valueishtml="0"  name=compute_1  tag="if( u_inware_printnum > 0,'(重复打印-'+string(u_inware_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" )
    58. 

  58. compute(band=header alignment="0" expression="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'"border="0" color="0" x="576" y="17" height="13" width="150" format="[general]" html.valueishtml="0"  name=compute_2  tag="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'" visible="1~tif( pageCount()>1,1,0)"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    59. 

  59. text(band=header alignment="2" text="收货清单" border="0" color="33554432" x="170" y="3" height="27" width="268" html.valueishtml="0"  name=t_6 visible="1"  resizeable=1  moveable=1  font.face="宋体" font.height="-18" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    60. 

  60. line(band=header x1="217" y1="34" x2="391" y2="34"  name=l_1 visible="1" pen.style="0" pen.width="2" pen.color="33554432"  background.mode="2" background.color="16777215" )
    61. 

  61. text(band=header alignment="1" text="单据编号:" border="0" color="0" x="538" y="39" height="17" width="67" html.valueishtml="0"  name=inwarecode_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" )
    62. 

  62. text(band=header alignment="1" text="进仓时间:" border="0" color="0" x="539" y="61" height="17" width="66" html.valueishtml="0"  name=indate_t visible="1"  resizeable=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" )
    63. 

  63. column(band=header id=2 alignment="0" tabsequence=32766 border="4" color="0" x="201" y="61" height="17" width="134" format="[general]" html.valueishtml="0"  name=u_inware_storageid  tag="u_inware_storageid" visible="1"  resizeable=1  moveable=1 dddw.name=dw_dddw_storage dddw.displaycolumn=storagename dddw.datacolumn=storageid dddw.percentwidth=100 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    64. 

  64. column(band=header id=17 alignment="0" tabsequence=32766 border="4" color="33554432" x="369" y="61" height="17" width="168" format="[general]" html.valueishtml="0"  name=u_spt_tele  tag="u_spt_tele" 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" )
    65. 

  65. text(band=header alignment="0" text="电话:" border="0" color="33554432" x="337" y="61" height="15" width="31" html.valueishtml="0"  name=t_9 visible="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. 

  66. text(band=header alignment="1" text="供应商:" border="0" color="0" x="151" y="39" height="15" width="49" html.valueishtml="0"  name=u_spt_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. 

  67. text(band=header alignment="1" text="仓  库:" border="0" color="0" x="151" y="61" height="15" width="49" html.valueishtml="0"  name=storageid_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" )
    68. 

  68. text(band=header alignment="1" text="备  注:" border="0" color="33554432" x="151" y="83" height="15" width="49" html.valueishtml="0"  name=t_8 visible="1"  resizeable=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" )
    69. 

  69. column(band=header id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="201" y="83" height="19" width="523" format="[general]" html.valueishtml="0"  name=u_inware_dscrp  tag="u_inware_dscrp" visible="1"  resizeable=1  moveable=1 edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-11" font.weight="700"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    70. 

  70. column(band=header id=13 alignment="0" tabsequence=32766 border="4" color="0" x="607" y="39" height="17" width="120" format="[general]" html.valueishtml="0"  name=u_inware_inwarecode  tag="u_inware_inwarecode" 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="-10" font.weight="700"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    71. 

  71. column(band=header id=3 alignment="0" tabsequence=32766 border="4" color="0" x="607" y="61" height="17" width="120" format="yyyy-mm-dd" html.valueishtml="0"  name=u_inware_indate  tag="u_inware_indate" visible="1"  resizeable=1  moveable=1 edit.limit=0 edit.case=any edit.format="yyyy-mm-dd" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=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" )
    72. 

  72. column(band=header id=7 alignment="0" tabsequence=32766 border="4" color="0" x="201" y="39" height="18" width="335" format="[general]" html.valueishtml="0"  name=u_spt_name  tag="u_spt_name" visible="1"  resizeable=1  moveable=1 edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-12" font.weight="700"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    73. 

  73. report(band=detail dataobject="dw_rp_inwaremx_buy_edit_audit" x="2" y="1" height="20" width="731" border="0"  height.autosize=yes criteria="" nest_arguments=((" arg_scid "),(" arg_inwareid "),(" arg_printrow "),(" arg_top ")) trail_footer = yes  name=mxreport visible="1"  slideleft=yes  slideup=directlyabove )
    74. 

  74. text(band=footer alignment="0" text="供方送货人:" border="0" color="0" x="497" y="0" height="15" width="83" html.valueishtml="0"  name=t_4 visible="1"  resizeable=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"  height.autosize=yes)
    75. 

  75. text(band=footer alignment="0" text="购货人：" border="0" color="0" x="228" y="1" height="15" width="56" html.valueishtml="0"  name=t_2 visible="1"  resizeable=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"  height.autosize=yes)
    76. 

  76. text(band=footer alignment="1" text="制单人:" border="0" color="0" x="3" y="1" height="15" width="49" html.valueishtml="0"  name=operator_t visible="1"  resizeable=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"  height.autosize=yes)
    77. 

  77. column(band=footer id=9 alignment="0" tabsequence=32766 border="4" color="0" x="54" y="1" height="17" width="90" format="[general]" html.valueishtml="0"  name=u_inware_opemp  tag="u_inware_opemp" visible="1"  resizeable=1  moveable=1  slideup=allabove height.autosize=yes 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" )
    78. 

  78. text(band=footer alignment="0" text="                   " border="4" color="0" x="582" y="0" height="17" width="137" html.valueishtml="0"  name=t_5 visible="1"  resizeable=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" )
    79. 

  79. column(band=footer id=4 alignment="0" tabsequence=32766 border="4" color="33554432" x="286" y="1" height="17" width="122" format="[general]" html.valueishtml="0"  name=u_inware_inrep  tag="u_inware_inrep" 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="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    80. 

  80. htmltable(border="0" )
    81. 

  81. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
    82. 

  82. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    83. 

  83. import.xml()
    84. 

  84. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    85.