dw_addzero_mtrldef.srd 11 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. $PBExportHeader$dw_addzero_mtrldef.srd
  2. release 9;
  3. datawindow(units=0 timer_interval=0 color=1073741824 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 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. summary(height=0 color="536870912" )
  5. footer(height=0 color="536870912" )
  6. detail(height=1056 color="536870912" )
  7. table(column=(type=char(30) updatewhereclause=yes name=mtrlcode dbname="u_mtrldef.mtrlcode" initial="empty" )
  8. column=(type=char(50) updatewhereclause=yes name=mtrlname dbname="u_mtrldef.mtrlname" initial="empty" )
  9. column=(type=char(30) updatewhereclause=yes name=mtrltype dbname="u_mtrldef.mtrltype" initial="empty" )
  10. column=(type=char(30) updatewhereclause=yes name=mtrlmode dbname="u_mtrldef.mtrlmode" initial="empty" )
  11. column=(type=char(10) updatewhereclause=yes name=unit dbname="u_mtrldef.unit" initial="empty" )
  12. column=(type=char(50) updatewhereclause=yes name=status dbname="status" initial="empty" )
  13. column=(type=char(50) updatewhereclause=yes name=woodcode dbname="woodcode" initial="empty" )
  14. column=(type=char(50) updatewhereclause=yes name=pcode dbname="pcode" initial="empty" )
  15. column=(type=char(50) updatewhereclause=yes name=plancode dbname="plancode" initial="empty" )
  16. column=(type=char(50) updatewhereclause=yes name=sptcode dbname="sptcode" initial="empty" )
  17. column=(type=char(50) updatewhereclause=yes name=sptname dbname="sptname" initial="empty" )
  18. column=(type=long updatewhereclause=yes name=sptid dbname="sptid" initial="0" )
  19. retrieve=" SELECT u_mtrldef.mtrlcode,
  20. u_mtrldef.mtrlname,
  21. u_mtrldef.mtrltype,
  22. u_mtrldef.mtrlmode,
  23. u_mtrldef.unit ,
  24. SPACE(50) as status,
  25. SPACE(50) as woodcode,
  26. SPACE(50) as pcode,
  27. SPACE(50) as plancode,
  28. SPACE(50) as sptcode,
  29. SPACE(50) as sptname,
  30. 0 as sptid
  31. FROM u_mtrldef
  32. where u_mtrldef.mtrlid=:arg_mtrlid" arguments=(("arg_mtrlid", number)) )
  33. column(band=detail id=1 alignment="0" tabsequence=32766 border="4" color="33554432" x="293" y="20" height="68" width="1065" format="[general]" html.valueishtml="0" name=mtrlcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  34. column(band=detail id=2 alignment="0" tabsequence=32766 border="4" color="33554432" x="293" y="124" height="68" width="1065" format="[general]" html.valueishtml="0" name=mtrlname visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  35. column(band=detail id=3 alignment="0" tabsequence=32766 border="4" color="33554432" x="293" y="228" height="68" width="1065" format="[general]" html.valueishtml="0" name=mtrltype visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  36. column(band=detail id=4 alignment="0" tabsequence=32766 border="4" color="33554432" x="293" y="332" height="68" width="544" format="[general]" html.valueishtml="0" name=mtrlmode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  37. text(band=detail alignment="1" text="库存单位" border="0" color="33554432" x="864" y="332" height="56" width="242" html.valueishtml="0" name=unit_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  38. column(band=detail id=5 alignment="0" tabsequence=32766 border="4" color="33554432" x="1120" y="332" height="68" width="238" format="[general]" html.valueishtml="0" name=unit visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  39. text(band=detail alignment="1" text="颜色" border="0" color="16711680" x="37" y="436" height="56" width="242" html.valueishtml="0" name=status_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  40. text(band=detail alignment="1" text="材质" border="0" color="16711680" x="37" y="540" height="56" width="242" html.valueishtml="0" name=woodcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  41. text(band=detail alignment="1" text="皮料" border="0" color="16711680" x="37" y="644" height="56" width="242" html.valueishtml="0" name=pcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  42. text(band=detail alignment="1" text="批号" border="0" color="16711680" x="37" y="748" height="56" width="242" html.valueishtml="0" name=plancode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  43. text(band=detail alignment="1" text="编 码" border="0" color="33554432" x="32" y="20" height="56" width="247" html.valueishtml="0" name=mtrlcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  44. text(band=detail alignment="1" text="品 名" border="0" color="33554432" x="32" y="124" height="56" width="247" html.valueishtml="0" name=mtrlname_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  45. text(band=detail alignment="1" text="类 别" border="0" color="33554432" x="32" y="228" height="56" width="247" html.valueishtml="0" name=mtrltype_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  46. text(band=detail alignment="1" text="规 格" border="0" color="0" x="37" y="332" height="56" width="242" html.valueishtml="0" name=mtrlmode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  47. text(band=detail alignment="1" text="供应商编号" border="0" color="16711680" x="0" y="852" height="56" width="302" html.valueishtml="0" name=t_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  48. column(band=detail id=7 alignment="0" tabsequence=20 border="4" color="16711680" x="293" y="540" height="68" width="1065" format="[general]" html.valueishtml="0" name=woodcode visible="1" dddw.name=ddd_color_wood dddw.displaycolumn=woodcode dddw.datacolumn=woodcode dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.hscrollbar=yes dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  49. column(band=detail id=6 alignment="0" tabsequence=10 border="4" color="16711680" x="293" y="436" height="68" width="1065" format="[general]" html.valueishtml="0" name=status visible="1" dddw.name=ddd_color dddw.displaycolumn=colorname dddw.datacolumn=colorname dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.hscrollbar=yes dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  50. column(band=detail id=8 alignment="0" tabsequence=30 border="4" color="16711680" x="293" y="644" height="68" width="1065" format="[general]" html.valueishtml="0" name=pcode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  51. column(band=detail id=9 alignment="0" tabsequence=40 border="4" color="16711680" x="293" y="748" height="68" width="1065" format="[general]" html.valueishtml="0" name=plancode visible="1" edit.limit=0 edit.case=any edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  52. column(band=detail id=10 alignment="0" tabsequence=50 border="4" color="16711680" x="320" y="852" height="68" width="1033" format="[general]" html.valueishtml="0" name=sptcode visible="1" edit.limit=0 edit.case=any edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  53. text(band=detail alignment="1" text="供应商名称" border="0" color="16711680" x="0" y="956" height="56" width="302" html.valueishtml="0" name=t_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  54. column(band=detail id=11 alignment="0" tabsequence=32766 border="4" color="33554432" x="320" y="952" height="68" width="1033" format="[general]" html.valueishtml="0" name=sptname visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  55. htmltable(border="1" )
  56. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  57. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  58. import.xml()
  59. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )