Sākums Izpētīt Palīdzība
Pierakstīties
Neil
/
Q5
1
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Koks: e6d5b7865b
Atzari Tagi
Q5
/
ws_objects
/
cw_asset.pbl.src
/
dw_assetclear_index.srd

dw_assetclear_index.srd 10.0 KB
Vēsture Neapstrādāts

1234567891011121314151617181920212223242526272829303132333435363738394041424344 
  1. $PBExportHeader$dw_assetclear_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=char(10) updatewhereclause=yes initial="empty" name=cw_assetcard_assetcardcode dbname="cw_assetcard.assetcardcode"  )
    10. 

  10. column=(type=long updatewhereclause=yes initial="0" name=cw_astclear_incrdecid dbname="cw_astclear.incrdecid" 
    11. 

  11.  values=""  )
    12. 

  12. column=(type=decimal(2) updatewhereclause=yes initial="0" name=cw_astclear_earing dbname="cw_astclear.earing"  )
    13. 

  13. column=(type=decimal(2) updatewhereclause=yes initial="0" name=cw_astclear_payout dbname="cw_astclear.payout"  )
    14. 

  14. column=(type=char(100) updatewhereclause=yes initial="empty" name=cw_astclear_dscrp dbname="cw_astclear.dscrp"  )
    15. 

  15. column=(type=char(40) updatewhereclause=yes initial="empty" name=cw_assetcard_assetcardname dbname="cw_assetcard.assetcardname"  )
    16. 

  16. column=(type=long updatewhereclause=yes initial="0" name=cw_astclear_accsetid dbname="cw_astclear.accsetid"  )
    17. 

  17. column=(type=long updatewhereclause=yes initial="0" name=cw_astclear_assetcardid dbname="cw_astclear.assetcardid"  )
    18. 

  18. column=(type=long updatewhereclause=yes initial="0" name=cw_astclear_astclearid dbname="cw_astclear.astclearid"  )
    19. 

  19.  retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"cw_assetcard~" )  TABLE(NAME=~"cw_astclear~" ) COLUMN(NAME=~"cw_assetcard.assetcardcode~") COLUMN(NAME=~"cw_astclear.incrdecid~") COLUMN(NAME=~"cw_astclear.earing~") COLUMN(NAME=~"cw_astclear.payout~") COLUMN(NAME=~"cw_astclear.dscrp~") COLUMN(NAME=~"cw_assetcard.assetcardname~") COLUMN(NAME=~"cw_astclear.accsetid~") COLUMN(NAME=~"cw_astclear.assetcardid~") COLUMN(NAME=~"cw_astclear.astclearid~")    JOIN (LEFT=~"cw_assetcard.accsetid~"    OP =~"=~"RIGHT=~"cw_astclear.accsetid~" )    JOIN (LEFT=~"cw_assetcard.assetcardid~"    OP =~"=~"RIGHT=~"cw_astclear.assetcardid~" )WHERE(    EXP1 =~"cw_astclear.accsetid~"   OP =~"=~"    EXP2 =~":arg_accsetid~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"cw_astclear.astclearid~"   OP =~"=~"    EXP2 =~":arg_astclearid~" ) ) ARG(NAME = ~"arg_accsetid~" TYPE = number)  ARG(NAME = ~"arg_astclearid~" TYPE = number) "
    20. 

  20.   arguments=(("arg_accsetid", number), ("arg_astclearid", number))
    21. 

  21.  sort="cw_assetcard_assetcardcode A"
    22. 

  22. )
    23. 

  23. text(name=cw_assetcard_assetcardname_t 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="530" y="8" height="56" width="951" text="资产名称" )
    24. 

  24. text(name=cw_astclear_earing_t 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="16711680" alignment="2" border="0" x="2039" y="8" height="56" width="416" text="清理收入" )
    25. 

  25. text(name=cw_astclear_incrdecid_t 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="16711680" alignment="2" border="0" x="1490" y="8" height="56" width="539" text="增减方式" )
    26. 

  26. text(name=cw_astclear_payout_t 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="16711680" alignment="2" border="0" x="2464" y="8" height="56" width="416" text="清理费用" )
    27. 

  27. 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="16711680" alignment="2" border="0" x="2889" y="8" height="56" width="859" text="备注" )
    28. 

  28. text(name=cw_assetcard_assetcardcode_t 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="8388608" alignment="2" border="0" x="87" y="8" height="56" width="434" 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="9" y="8" height="56" width="69" text="序" )
    30. 

  30. 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="87" y="4" height="56" width="434" format="[general]" expression="count(cw_assetcard_assetcardcode for all)" alignment="2" border="0" crosstab.repeat=no )
    31. 

  31. compute(band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="16711680" x="2039" y="4" height="56" width="416" format="#,##0.00" expression="sum(cw_astclear_earing for all)" alignment="1" border="0" crosstab.repeat=no )
    32. 

  32. compute(band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="16711680" x="2464" y="4" height="56" width="416" format="#,##0.00" expression="sum(cw_astclear_payout for all)" alignment="1" border="0" crosstab.repeat=no )
    33. 

  33. column(name=cw_assetcard_assetcardname tag="固定资产名称" band=detail id=6 x="530" y="4" height="68" width="951" 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=40 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 )
    34. 

  34. column(name=cw_astclear_incrdecid band=detail id=2 x="1490" y="4" height="68" width="539" color="16711680" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=incrdecrid dddw.displaycolumn=incrdecrname dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_incrdecrid_2 dddw.nilisnull=no dddw.percentwidth=100 dddw.required=no dddw.showlist=no dddw.vscrollbar=yes criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
    35. 

  35. column(name=cw_astclear_earing tag="清理收入" band=detail id=3 x="2039" y="4" height="68" width="416" color="16711680" border="0" alignment="1" format="#,##0.00" 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=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 )
    36. 

  36. column(name=cw_astclear_payout tag="清理费用" band=detail id=4 x="2464" y="4" height="68" width="416" color="16711680" border="0" alignment="1" format="#,##0.00" 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=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 )
    37. 

  37. column(name=cw_astclear_dscrp band=detail id=5 x="2889" y="4" height="68" width="859" color="16711680" 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 )
    38. 

  38. column(name=cw_assetcard_assetcardcode tag="固定资产编号" band=detail id=1 x="87" y="4" height="68" width="434" color="8388608" 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=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 )
    39. 

  39. compute(band=detail 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" x="9" y="4" height="68" width="69" format="[general]" expression="getrow()" alignment="2" border="0" crosstab.repeat=no )
    40. 

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

  41. htmlgen()
    42. 

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

  43. import.xml()
    44. 

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