dw_billemp_edit.srd 5.6 KB

12345678910111213141516171819202122232425262728293031
  1. $PBExportHeader$dw_billemp_edit.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 )
  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=char(10) update=yes updatewhereclause=yes key=yes name=billcode dbname="u_billemp.billcode" initial="empty" )
  9. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empcode dbname="u_rs_empinfo.Empcode" initial="empty" )
  10. column=(type=long update=yes updatewhereclause=yes key=yes name=empid dbname="u_billemp.empid" initial="0" )
  11. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empname dbname="u_rs_empinfo.Empname" initial="empty" )
  12. retrieve="SELECT u_billemp.billcode,u_rs_empinfo.Empcode, u_billemp.empid,
  13. u_rs_empinfo.Empname
  14. FROM u_billemp INNER JOIN
  15. u_rs_empinfo ON u_billemp.empid = u_rs_empinfo.empid" update="u_billemp" updatewhere=0 updatekeyinplace=no sort="billcode A u_rs_empinfo_empcode A " )
  16. group(level=1 header.height=0 trailer.height=64 by=("billcode" ) header.color="536870912" trailer.color="536870912" )
  17. text(band=header alignment="2" text="单据" border="0" color="16711680" x="9" y="8" height="56" width="681" html.valueishtml="0" name=billcode_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" )
  18. column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="16711680" x="9" y="4" height="68" width="681" format="[general]" html.valueishtml="0" name=billcode visible="1" dddw.name=ddd_billstyle dddw.displaycolumn=billstyle dddw.datacolumn=firststr dddw.percentwidth=150 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="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  19. column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="0" x="1152" y="4" height="68" width="407" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empname 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="1" background.color="536870912" )
  20. column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="8388608" x="699" y="4" height="68" width="443" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empcode 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="1" background.color="536870912" )
  21. compute(band=trailer.1 alignment="2" expression="count(u_rs_empinfo_empcode for group 1)"border="0" color="0" x="699" y="4" height="56" width="443" format="[general]" html.valueishtml="0" name=compute_3 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" )
  22. compute(band=trailer.1 alignment="2" expression=" billcode "border="0" color="0" x="9" y="4" height="56" width="681" format="[GENERAL]" html.valueishtml="0" name=compute_4 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" )
  23. compute(band=footer alignment="2" expression="count(u_rs_empinfo_empcode for all)"border="0" color="8388608" x="699" y="4" height="56" width="443" 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="1" background.color="536870912" )
  24. compute(band=footer alignment="2" expression="count(billcode for all distinct)"border="0" color="16711680" x="9" y="4" height="56" width="681" format="[general]" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  25. text(band=header alignment="2" text="姓名" border="0" color="0" x="1152" y="8" height="56" width="407" html.valueishtml="0" name=u_rs_empinfo_empname_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="553648127" )
  26. text(band=header alignment="2" text="员工号" border="0" color="8388608" x="699" y="8" height="56" width="443" html.valueishtml="0" name=u_rs_empinfo_empcode_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="553648127" )
  27. htmltable(border="1" )
  28. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  29. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  30. import.xml()
  31. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )