Home Explore Help
Sign In
Neil
/
Q5
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Q5
/
ws_objects
/
Ew_define.pbl.src
/
dw_spt_rep.srd

dw_spt_rep.srd 8.6 KB
Permalink History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 
  1. $PBExportHeader$dw_spt_rep.srd
    2. 

  2. release 9;
    3. 

  3. datawindow(units=0 timer_interval=0 color=1073741824 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=72 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=long update=yes updatewhereclause=yes key=yes name=repid dbname="u_spt_rep.repid" initial="0" )
    9. 

  9.  column=(type=long update=yes updatewhereclause=yes name=sptid dbname="u_spt_rep.sptid" initial="0" )
    10. 

  10.  column=(type=char(20) update=yes updatewhereclause=yes name=repname dbname="u_spt_rep.repname" initial="empty" )
    11. 

  11.  column=(type=char(30) update=yes updatewhereclause=yes name=duty dbname="u_spt_rep.duty" initial="empty" )
    12. 

  12.  column=(type=char(2) update=yes updatewhereclause=yes name=sex dbname="u_spt_rep.sex" initial="男" values="男	男/女	女/" )
    13. 

  13.  column=(type=char(30) update=yes updatewhereclause=yes name=officetel dbname="u_spt_rep.officetel" initial="empty" )
    14. 

  14.  column=(type=char(30) update=yes updatewhereclause=yes name=handtel dbname="u_spt_rep.handtel" initial="empty" )
    15. 

  15.  column=(type=char(30) update=yes updatewhereclause=yes name=faxno dbname="u_spt_rep.faxno" initial="empty" )
    16. 

  16.  column=(type=char(30) update=yes updatewhereclause=yes name=email dbname="u_spt_rep.email" initial="empty" )
    17. 

  17.  column=(type=char(255) update=yes updatewhereclause=yes name=dscrp dbname="u_spt_rep.dscrp" initial="empty" )
    18. 

  18.  retrieve="SELECT 
    19. 

  19.  repid,
    20. 

  20.  sptid,
    21. 

  21.  repname,
    22. 

  22.  duty,
    23. 

  23.  sex,
    24. 

  24.  officetel,
    25. 

  25.  handtel,
    26. 

  26.  faxno, 
    27. 

  27.  email,
    28. 

  28.  dscrp 
    29. 

  29. FROM u_spt_rep   
    30. 

  30. where sptid=:arg_sptid" update="u_spt_rep" updatewhere=1 updatekeyinplace=no arguments=(("arg_sptid", number)) )
    31. 

  31. text(band=header alignment="2" text="姓名" border="0" color="16711680" x="9" y="8" height="56" width="247" html.valueishtml="0"  name=repname_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" )
    32. 

  32. text(band=header alignment="2" text="职务" border="0" color="16711680" x="265" y="8" height="56" width="265" html.valueishtml="0"  name=duty_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" )
    33. 

  33. text(band=header alignment="2" text="性别" border="0" color="16711680" x="539" y="8" height="56" width="187" html.valueishtml="0"  name=sex_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" )
    34. 

  34. text(band=header alignment="2" text="办公电话" border="0" color="16711680" x="736" y="8" height="56" width="640" html.valueishtml="0"  name=officetel_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" )
    35. 

  35. text(band=header alignment="2" text="移动电话" border="0" color="16711680" x="1385" y="8" height="56" width="768" html.valueishtml="0"  name=handtel_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" )
    36. 

  36. text(band=header alignment="2" text="传真" border="0" color="16711680" x="2162" y="8" height="56" width="667" html.valueishtml="0"  name=faxno_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" )
    37. 

  37. text(band=header alignment="2" text="Email" border="0" color="16711680" x="2839" y="8" height="56" width="718" html.valueishtml="0"  name=email_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" )
    38. 

  38. text(band=header alignment="2" text="备注
" border="0" color="16711680" x="3566" y="8" height="56" width="946" 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" )
    39. 

  39. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="0" x="9" y="4" height="68" width="247" format="[general]" html.valueishtml="0"  name=repname visible="1" edit.limit=20 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" )
    40. 

  40. column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="0" x="265" y="4" height="68" width="265" format="[general]" html.valueishtml="0"  name=duty 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
    41. 

  41. column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="0" x="736" y="4" height="68" width="640" format="[general]" html.valueishtml="0"  name=officetel 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
    42. 

  42. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="0" x="1385" y="4" height="68" width="768" format="[general]" html.valueishtml="0"  name=handtel 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
    43. 

  43. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="0" x="2162" y="4" height="68" width="667" format="[general]" html.valueishtml="0"  name=faxno 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
    44. 

  44. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="0" x="2839" y="4" height="68" width="718" format="[general]" html.valueishtml="0"  name=email 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
    45. 

  45. column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="0" x="3566" y="4" height="68" width="946" format="[general]" html.valueishtml="0"  name=dscrp 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" )
    46. 

  46. column(band=detail id=5 alignment="2" tabsequence=32766 border="0" color="0" x="539" y="4" height="68" width="187" format="[general]" html.valueishtml="0"  name=sex visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.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" )
    47. 

  47. compute(band=footer alignment="2" expression="count(repname for all)"border="0" color="16711680" x="9" y="4" height="56" width="247" 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" )
    48. 

  48. htmltable(border="1" )
    49. 

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

  50. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    51. 

  51. import.xml()
    52. 

  52. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    53.