Kezdőlap Felfedezés Súgó
Bejelentkezés
Neil
/
Q5
1
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Fa: e6d5b7865b
Branch-ok Tag-ek
Q5
/
ws_objects
/
cw_account.pbl.src
/
dw_credence_auto_index.srd

dw_credence_auto_index.srd 9.3 KB
Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. $PBExportHeader$dw_credence_auto_index.srd
    2. 

  2. $PBExportComments$By Kivens.Jiang(kivens@21cn.com)
    3. 

  3. release 9;
    4. 

  4. datawindow ( units=0 timer_interval=0 color=16777215 processing=1 print.documentname=""  print.orientation=0 print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 print.paper.size=0 print.paper.source=0 grid.lines=0 selected.mouse=no)
    5. 

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

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

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

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

  9. table(column=(type=long key=yes update=yes updatewhereclause=yes name=credid dbname="cw_credence_auto.credid"  )
    10. 

  10. column=(type=char(30) update=yes updatewhereclause=yes name=credname dbname="cw_credence_auto.Credname"  )
    11. 

  11. column=(type=char(10) update=yes updatewhereclause=yes name=credtype dbname="cw_credence_auto.credtype"  )
    12. 

  12. column=(type=long update=yes updatewhereclause=yes initial="1" name=ifalways dbname="cw_credence_auto.ifalways" 
    13. 

  13.  values="	1/	0"  )
    14. 

  14. column=(type=long update=yes updatewhereclause=yes name=billnumber dbname="cw_credence_auto.billnumber"  )
    15. 

  15. column=(type=long key=yes update=yes updatewhereclause=yes name=accsetid dbname="cw_credence_auto.accsetid"  )
    16. 

  16. column=(type=long update=yes updatewhereclause=yes name=credkind dbname="cw_credence_auto.Credkind"  )
    17. 

  17. column=(type=char(100) update=yes updatewhereclause=yes name=monthdscrp dbname="cw_credence_auto.monthdscrp"  )
    18. 

  18. column=(type=datetime updatewhereclause=yes name=moddate dbname="cw_credence_auto.moddate"  )
    19. 

  19. column=(type=char(20) updatewhereclause=yes name=modemp dbname="cw_credence_auto.modemp"  )
    20. 

  20. column=(type=datetime updatewhereclause=yes name=opdate dbname="cw_credence_auto.opdate"  )
    21. 

  21. column=(type=char(20) updatewhereclause=yes name=opemp dbname="cw_credence_auto.opemp"  )
    22. 

  22.  retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"cw_credence_auto~" ) COLUMN(NAME=~"cw_credence_auto.credid~") COLUMN(NAME=~"cw_credence_auto.Credname~") COLUMN(NAME=~"cw_credence_auto.credtype~") COLUMN(NAME=~"cw_credence_auto.ifalways~") COLUMN(NAME=~"cw_credence_auto.billnumber~") COLUMN(NAME=~"cw_credence_auto.accsetid~") COLUMN(NAME=~"cw_credence_auto.Credkind~") COLUMN(NAME=~"cw_credence_auto.monthdscrp~") COLUMN(NAME=~"cw_credence_auto.moddate~") COLUMN(NAME=~"cw_credence_auto.modemp~") COLUMN(NAME=~"cw_credence_auto.opdate~") COLUMN(NAME=~"cw_credence_auto.opemp~")WHERE(    EXP1 =~"cw_credence_auto.Credkind~"   OP =~"=~"    EXP2 =~"1~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"cw_credence_auto.accsetid~"   OP =~"=~"    EXP2 =~":arg_accsetid~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"(cw_credence_auto.ifalways~"   OP =~"=~"    EXP2 =~":arg_ifalways~"    LOGIC =~"or~" ) WHERE(    EXP1 =~":arg_ifalways~"   OP =~"=~"    EXP2 =~"-1)~" ) ) ARG(NAME = ~"arg_accsetid~" TYPE = number)  ARG(NAME = ~"arg_ifalways~" TYPE = number) "
    23. 

  23.   update="cw_credence_auto" updatewhere=1 updatekeyinplace=no
    24. 

  24.   arguments=(("arg_accsetid", number), ("arg_ifalways", number))
    25. 

  25. )
    26. 

  26. text(name=credname_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="2" border="0" x="9" y="8" height="56" width="814" text="凭证名称" )
    27. 

  27. text(name=credtype_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="2" border="0" x="832" y="8" height="56" width="224" text="凭证字" )
    28. 

  28. text(name=ifalways_t band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="2" border="0" x="1065" y="8" height="56" width="142" text="常用" )
    29. 

  29. text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="2199" y="8" height="56" width="498" text="修改时间" )
    30. 

  30. text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="1970" y="8" height="56" width="219" text="修改人" )
    31. 

  31. text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="1463" y="8" height="56" width="498" text="建立时间" )
    32. 

  32. text(band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="0" alignment="2" border="0" x="1216" y="8" height="56" width="238" text="建立人" )
    33. 

  33. compute(band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="16711680" x="9" y="4" height="56" width="814" format="[general]" expression="count(credname for all)" alignment="2" border="0" crosstab.repeat=no )
    34. 

  34. column(name=credname band=detail id=2 x="9" y="4" height="68" width="814" color="0" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=30 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    35. 

  35. column(name=credtype band=detail id=3 x="832" y="4" height="68" width="224" color="0" border="0" alignment="2" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    36. 

  36. column(name=ifalways band=detail id=4 x="1065" y="4" height="68" width="142" color="0" border="0" alignment="2" format="[general]" checkbox.lefttext=no checkbox.scale=no checkbox.threed=yes checkbox.text="" checkbox.on="1" checkbox.off="0" criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    37. 

  37. column(name=moddate band=detail id=9 x="2199" y="4" height="68" width="498" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    38. 

  38. column(name=modemp band=detail id=10 x="1970" y="4" height="68" width="219" color="0" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    39. 

  39. column(name=opdate band=detail id=11 x="1463" y="4" height="68" width="498" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    40. 

  40. column(name=opemp band=detail id=12 x="1216" y="4" height="68" width="238" color="0" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    41. 

  41. htmltable(border="1" cellPadding="0" cellSpacing="0" generateCSS="no" noWrap="yes" )
    42. 

  42. htmlgen()
    43. 

  43. export.xml(metadatatype=0 savemetadata=0 )
    44. 

  44. import.xml()
    45. 

  45. export.pdf(method=0 )
    46.