dw_workprice_change_index.srd 13 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. $PBExportHeader$dw_workprice_change_index.srd
  2. release 9;
  3. datawindow(units=0 timer_interval=0 color=16777215 processing=1 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 grid.lines=0 selected.mouse=no )
  4. header(height=68 color="536870912" )
  5. summary(height=0 color="536870912" )
  6. footer(height=64 color="536870912" )
  7. detail(height=76 color="536870912" )
  8. table(column=(type=long update=yes updatewhereclause=yes key=yes name=billid dbname="u_workprice_change.billid" initial="0" )
  9. column=(type=datetime update=yes updatewhereclause=yes name=billdate dbname="u_workprice_change.billdate" initial="today" )
  10. column=(type=char(50) update=yes updatewhereclause=yes name=relcode dbname="u_workprice_change.relcode" initial="empty" )
  11. column=(type=char(10) update=yes updatewhereclause=yes name=rep dbname="u_workprice_change.rep" initial="empty" )
  12. column=(type=char(255) update=yes updatewhereclause=yes name=dscrp dbname="u_workprice_change.dscrp" initial="empty" )
  13. column=(type=long update=yes updatewhereclause=yes name=flag dbname="u_workprice_change.flag" initial="0" values=" 1/ 0" )
  14. column=(type=datetime update=yes updatewhereclause=yes name=opdate dbname="u_workprice_change.opdate" )
  15. column=(type=char(10) update=yes updatewhereclause=yes name=opemp dbname="u_workprice_change.opemp" initial="empty" )
  16. column=(type=datetime update=yes updatewhereclause=yes name=moddate dbname="u_workprice_change.moddate" )
  17. column=(type=char(10) update=yes updatewhereclause=yes name=modemp dbname="u_workprice_change.modemp" initial="empty" )
  18. column=(type=datetime update=yes updatewhereclause=yes name=auditingdate dbname="u_workprice_change.auditingdate" )
  19. column=(type=char(10) update=yes updatewhereclause=yes name=auditingrep dbname="u_workprice_change.auditingrep" initial="empty" )
  20. column=(type=char(20) update=yes updatewhereclause=yes name=procode dbname="u_workprice_change.procode" initial="empty" )
  21. column=(type=char(50) update=yes updatewhereclause=yes name=proname dbname="u_workprice_change.proname" initial="empty" )
  22. column=(type=char(15) update=yes updatewhereclause=yes name=billcode dbname="u_workprice_change.billcode" initial="empty" )
  23. retrieve="SELECT billid,
  24. billdate,
  25. relcode,
  26. rep,
  27. dscrp,
  28. flag,
  29. opdate,
  30. opemp,
  31. moddate,
  32. modemp,
  33. auditingdate,
  34. auditingrep,
  35. procode,
  36. proname,
  37. billcode
  38. FROM u_workprice_change
  39. where (flag = :arg_flag or :arg_flag = -1)
  40. " update="u_workprice_change" updatewhere=1 updatekeyinplace=no arguments=(("arg_flag", number)) sort="billcode D " )
  41. text(band=header alignment="2" text="单据日期" border="0" color="0" x="448" y="8" height="56" width="361" html.valueishtml="0" name=billdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  42. text(band=header alignment="2" text="相关号" border="0" color="0" x="818" y="8" height="56" width="347" html.valueishtml="0" name=relcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  43. text(band=header alignment="2" text="经手人" border="0" color="0" x="1175" y="8" height="56" width="352" html.valueishtml="0" name=rep_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  44. text(band=header alignment="2" text="备注" border="0" color="0" x="1541" y="8" height="56" width="937" html.valueishtml="0" name=dscrp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  45. text(band=header alignment="2" text="审核" border="0" color="0" x="9" y="8" height="56" width="114" html.valueishtml="0" name=flag_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  46. text(band=header alignment="2" text="建立时间" border="0" color="0" x="2487" y="8" height="56" width="448" html.valueishtml="0" name=opdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  47. text(band=header alignment="2" text="建立人" border="0" color="0" x="2944" y="8" height="56" width="270" html.valueishtml="0" name=opemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  48. text(band=header alignment="2" text="修改时间" border="0" color="0" x="3223" y="8" height="56" width="453" html.valueishtml="0" name=moddate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  49. text(band=header alignment="2" text="修改人" border="0" color="0" x="3685" y="8" height="56" width="238" html.valueishtml="0" name=modemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  50. text(band=header alignment="2" text="审核时间" border="0" color="0" x="3931" y="8" height="56" width="485" html.valueishtml="0" name=auditingdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  51. text(band=header alignment="2" text="审核人" border="0" color="0" x="4425" y="8" height="56" width="261" html.valueishtml="0" name=auditingrep_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  52. text(band=header alignment="2" text="单据编号" border="0" color="0" x="133" y="8" height="56" width="306" html.valueishtml="0" name=billcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  53. column(band=detail id=2 alignment="2" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="448" y="4" height="68" width="361" format="yyyy-mm-dd" html.valueishtml="0" name=billdate visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  54. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="818" y="4" height="68" width="347" format="[general]" html.valueishtml="0" name=relcode 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  55. column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="1175" y="4" height="68" width="352" format="[general]" html.valueishtml="0" name=rep 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  56. column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="1541" y="4" height="68" width="937" format="[general]" html.valueishtml="0" name=dscrp visible="1" edit.limit=255 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  57. column(band=detail id=6 alignment="2" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="9" y="4" height="68" width="114" format="[general]" html.valueishtml="0" name=flag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  58. column(band=detail id=7 alignment="2" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="2487" y="4" height="68" width="448" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=opdate visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  59. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="2944" y="4" height="68" width="270" format="[general]" html.valueishtml="0" name=opemp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  60. column(band=detail id=9 alignment="2" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="3223" y="4" height="68" width="453" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=moddate visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  61. column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="3685" y="4" height="68" width="238" format="[general]" html.valueishtml="0" name=modemp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  62. column(band=detail id=11 alignment="2" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="3931" y="4" height="68" width="485" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=auditingdate visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  63. column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="4425" y="4" height="68" width="261" format="[general]" html.valueishtml="0" name=auditingrep 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  64. column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="0~tif( flag =0,rgb(255,0,0),rgb(0,0,0))" x="133" y="4" height="68" width="306" format="[general]" html.valueishtml="0" name=billcode visible="1" edit.limit=15 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
  65. compute(band=footer alignment="2" expression="count( billcode for all )"border="0" color="16711680" x="133" y="4" height="56" width="306" format="[GENERAL]" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
  66. htmltable(border="1" )
  67. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  68. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  69. import.xml()
  70. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )