dw_rp_warepdb_bill_edit.srd 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. $PBExportHeader$dw_rp_warepdb_bill_edit.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=136 color="536870912" )
  5. summary(height=0 color="536870912" )
  6. footer(height=27 color="536870912" )
  7. detail(height=35 color="536870912" height.autosize=yes)
  8. table(column=(type=long updatewhereclause=yes name=u_warepdb_bill_billid dbname="u_warepdb_bill.billid" initial="null" values="盘点单主表-单据ID /" )
  9. column=(type=long updatewhereclause=yes name=u_warepdb_bill_storageid dbname="u_warepdb_bill.StorageID" initial="null" values="盘点单主表-仓库ID /" )
  10. column=(type=datetime updatewhereclause=yes name=u_warepdb_bill_billdate dbname="u_warepdb_bill.billdate" initial="null" )
  11. column=(type=char(10) updatewhereclause=yes name=u_warepdb_bill_assign_emp dbname="u_warepdb_bill.Assign_Emp" initial="null" )
  12. column=(type=char(50) updatewhereclause=yes name=u_warepdb_bill_part dbname="u_warepdb_bill.part" initial="null" )
  13. column=(type=char(255) updatewhereclause=yes name=u_warepdb_bill_dscrp dbname="u_warepdb_bill.dscrp" initial="null" )
  14. column=(type=char(15) updatewhereclause=yes name=u_warepdb_bill_billcode dbname="u_warepdb_bill.billcode" initial="null" )
  15. column=(type=datetime updatewhereclause=yes name=u_warepdb_bill_opdate dbname="u_warepdb_bill.opdate" initial="null" )
  16. column=(type=char(10) updatewhereclause=yes name=u_warepdb_bill_opemp dbname="u_warepdb_bill.opemp" initial="null" )
  17. column=(type=datetime updatewhereclause=yes name=u_warepdb_bill_permit_date dbname="u_warepdb_bill.Permit_date" initial="null" values="盘点单主表-审核时间 /" )
  18. column=(type=char(10) updatewhereclause=yes name=u_warepdb_bill_permit_emp dbname="u_warepdb_bill.Permit_Emp" initial="null" values="盘点单主表-审核人 /" )
  19. column=(type=long updatewhereclause=yes name=u_warepdb_bill_flag dbname="u_warepdb_bill.flag" initial="null" values="盘点单主表-审核标记 /" )
  20. column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" initial="null" values="仓库定义表-仓库名称 /" )
  21. column=(type=long updatewhereclause=yes name=u_warepdb_bill_scid dbname="u_warepdb_bill.scid" initial="null" )
  22. column=(type=char(10) updatewhereclause=yes name=u_warepdb_bill_modemp dbname="u_warepdb_bill.Modemp" initial="null" values="盘点单主表-修改人 /" )
  23. column=(type=datetime updatewhereclause=yes name=u_warepdb_bill_moddate dbname="u_warepdb_bill.moddate" initial="null" values="盘点单主表-修改时间 /" )
  24. retrieve="SELECT u_warepdb_bill.billid,
  25. u_warepdb_bill.StorageID,
  26. u_warepdb_bill.billdate,
  27. u_warepdb_bill.Assign_Emp,
  28. u_warepdb_bill.part,
  29. u_warepdb_bill.dscrp,
  30. u_warepdb_bill.billcode,
  31. u_warepdb_bill.opdate,
  32. u_warepdb_bill.opemp,
  33. u_warepdb_bill.Permit_date,
  34. u_warepdb_bill.Permit_Emp,
  35. u_warepdb_bill.flag,
  36. u_storage.storagename,
  37. u_warepdb_bill.scid,
  38. u_warepdb_bill.Modemp,
  39. u_warepdb_bill.moddate
  40. FROM u_warepdb_bill,
  41. u_storage
  42. WHERE ( u_warepdb_bill.StorageID = u_storage.storageid ) and
  43. u_warepdb_bill.billid = :arg_billid and
  44. u_warepdb_bill.scid = :arg_scid and
  45. :arg_printrow = :arg_printrow and
  46. :arg_top = :arg_top
  47. " arguments=(("arg_scid", number),("arg_billid", number),("arg_printrow", number),("arg_top", number)) )
  48. text(band=header alignment="2" text="仓库盘点单" border="0" color="0" x="0" y="1" height="27" width="719" html.valueishtml="0" name=t_2 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" )
  49. line(band=header x1="261" y1="33" x2="460" y2="33" name=l_1 visible="1" resizeable=1 moveable=1 pen.style="0" pen.width="1" pen.color="33554432" background.mode="2" background.color="1073741824" )
  50. compute(band=header alignment="0" expression="'打印时间:'+string(today(),'yyyy-mm-dd ')+string(now(),'h:mm')+' 第 ' + page() + ' 页/共 ' + pageCount()+' 页'"border="0" color="0" x="406" y="38" height="15" width="312" format="[general]" html.valueishtml="0" name=now tag="'打印时间:'+string(today(),'yyyy-mm-dd ')+string(now(),'h:mm')+' 第 ' + page() + ' 页/共 ' + pageCount()+' 页'" 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" )
  51. text(band=header alignment="1" text="单据日期" border="0" color="33554432" x="195" y="63" height="14" width="54" html.valueishtml="0" name=u_warepdb_bill_billdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  52. column(band=header id=3 alignment="0" tabsequence=32766 border="4" color="33554432" x="254" y="61" height="17" width="120" format="[shortdate] [time]" html.valueishtml="0" name=u_warepdb_bill_billdate tag="u_warepdb_bill_billdate" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  53. text(band=header alignment="1" text="经 手 人" border="0" color="33554432" x="7" y="91" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_assign_emp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  54. text(band=header alignment="1" text="备 注" border="0" color="33554432" x="6" y="116" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_dscrp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  55. text(band=header alignment="1" text="相关号码" border="0" color="33554432" x="197" y="91" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_part_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  56. text(band=header alignment="1" text="仓 库" border="0" color="33554432" x="7" y="62" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_storageid_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  57. column(band=header id=6 alignment="0" tabsequence=32766 border="4" color="33554432" x="63" y="115" height="17" width="656" format="[general]" html.valueishtml="0" name=u_warepdb_bill_dscrp tag="u_warepdb_bill_dscrp" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  58. column(band=header id=5 alignment="0" tabsequence=32766 border="4" color="33554432" x="254" y="89" height="17" width="117" format="[general]" html.valueishtml="0" name=u_warepdb_bill_part tag="u_warepdb_bill_part" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  59. text(band=header alignment="1" text="单据编号" border="0" color="33554432" x="543" y="63" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_billcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  60. column(band=header id=7 alignment="0" tabsequence=32766 border="4" color="33554432" x="599" y="62" height="17" width="117" format="[general]" html.valueishtml="0" name=u_warepdb_bill_billcode tag="u_warepdb_bill_billcode" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  61. report(band=detail dataobject="dw_rp_warepdb_billmx_edit" x="3" y="0" height="34" width="739" border="0" height.autosize=yes criteria="" nest_arguments=((" arg_scid "),(" arg_billid ")) trail_footer = yes name=dw_1 visible="1" slideup=directlyabove )
  62. text(band=footer alignment="1" text="建立时间" border="0" color="33554432" x="4" y="6" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_opdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  63. text(band=footer alignment="1" text="建 立 人" border="0" color="33554432" x="194" y="6" height="14" width="52" html.valueishtml="0" name=u_warepdb_bill_opemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  64. column(band=footer id=9 alignment="0" tabsequence=32766 border="4" color="33554432" x="251" y="4" height="17" width="70" format="[general]" html.valueishtml="0" name=u_warepdb_bill_opemp tag="u_warepdb_bill_opemp" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  65. column(band=footer id=8 alignment="0" tabsequence=32766 border="4" color="33554432" x="60" y="4" height="17" width="117" format="[shortdate] [time]" html.valueishtml="0" name=u_warepdb_bill_opdate tag="u_warepdb_bill_opdate" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  66. column(band=header id=4 alignment="0" tabsequence=32766 border="4" color="33554432" x="63" y="89" height="17" width="117" format="[general]" html.valueishtml="0" name=u_warepdb_bill_assign_emp tag="u_warepdb_bill_assign_emp" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
  67. column(band=header id=13 alignment="0" tabsequence=0 border="4" color="33554432" x="63" y="62" height="17" width="117" html.valueishtml="0" name=u_storage_storagename visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no 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="2" background.color="16777215" )
  68. htmltable(border="0" )
  69. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  70. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  71. import.xml()
  72. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )