Página inicial Explorar Ajuda
Entrar
Neil
/
Q5
1
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: 3c03c1be77
Branches Tags
Q5
/
ws_objects
/
Ew_epmmsg.pbl.src
/
dw_billemp_edit.srd

dw_billemp_edit.srd 5.6 KB
Histórico Raw

12345678910111213141516171819202122232425262728293031 
  1. $PBExportHeader$dw_billemp_edit.srd
    2. 

  2. release 9;
    3. 

  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. 

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

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

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

  7. detail(height=76 color="536870912" )
    8. 

  8. table(column=(type=char(10) update=yes updatewhereclause=yes key=yes name=billcode dbname="u_billemp.billcode" initial="empty" )
    9. 

  9.  column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empcode dbname="u_rs_empinfo.Empcode" initial="empty" )
    10. 

  10.  column=(type=long update=yes updatewhereclause=yes key=yes name=empid dbname="u_billemp.empid" initial="0" )
    11. 

  11.  column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empname dbname="u_rs_empinfo.Empname" initial="empty" )
    12. 

  12.  retrieve="SELECT u_billemp.billcode,u_rs_empinfo.Empcode,  u_billemp.empid, 
    13. 

  13.       u_rs_empinfo.Empname
    14. 

  14. FROM u_billemp INNER JOIN
    15. 

  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. 

  16. group(level=1 header.height=0 trailer.height=64 by=("billcode" ) header.color="536870912" trailer.color="536870912" )
    17. 

  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. 

  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. 

  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. 

  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. 

  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. 

  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. 

  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. 

  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. 

  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. 

  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. 

  27. htmltable(border="1" )
    28. 

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

  29. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    30. 

  30. import.xml()
    31. 

  31. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    32.