dw_assetdef_mod.srd 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. $PBExportHeader$dw_assetdef_mod.srd
  2. $PBExportComments$By Kivens.Jiang(kivens@21cn.com)
  3. release 9;
  4. datawindow ( units=0 timer_interval=0 color=67108864 processing=0 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.size=0 print.paper.source=0 print.canusedefaultprinter=yes selected.mouse=no)
  5. header(height=0 )
  6. summary(height=0 color="536870912" )
  7. footer(height=0 color="536870912" )
  8. detail(height=816 color="536870912" )
  9. table(column=(type=long key=yes updatewhereclause=yes initial="0" name=accsetid dbname="cw_assetcard.accsetid" )
  10. column=(type=long key=yes updatewhereclause=yes initial="0" name=assetcardid dbname="cw_assetcard.assetcardid" )
  11. column=(type=char(10) update=yes updatewhereclause=yes initial="empty" name=assetcardcode dbname="cw_assetcard.assetcardcode" )
  12. column=(type=char(40) update=yes updatewhereclause=yes initial="empty" name=assetcardname dbname="cw_assetcard.assetcardname" )
  13. column=(type=long update=yes updatewhereclause=yes initial="0" name=assetypeid dbname="cw_assetcard.assetypeid"
  14. values="" )
  15. column=(type=char(20) update=yes updatewhereclause=yes initial="empty" name=spectype dbname="cw_assetcard.spectype" )
  16. column=(type=long update=yes updatewhereclause=yes initial="0" name=deprediateid dbname="cw_assetcard.deprediateid"
  17. values="" )
  18. column=(type=long update=yes updatewhereclause=yes initial="0" name=deptid dbname="cw_assetcard.deptid"
  19. values="" )
  20. column=(type=long update=yes updatewhereclause=yes initial="0" name=incrdecrid dbname="cw_assetcard.incrdecrid"
  21. values="" )
  22. column=(type=char(10) update=yes updatewhereclause=yes initial="empty" name=unit dbname="cw_assetcard.unit" )
  23. column=(type=char(18) update=yes updatewhereclause=yes initial="empty" name=subid dbname="cw_assetcard.subid" )
  24. column=(type=char(60) update=yes updatewhereclause=yes initial="empty" name=location dbname="cw_assetcard.location" )
  25. column=(type=char(100) update=yes updatewhereclause=yes name=dscrp dbname="cw_assetcard.dscrp" )
  26. column=(type=char(18) update=yes updatewhereclause=yes name=othersubid dbname="cw_assetcard.othersubid" )
  27. column=(type=char(18) update=yes updatewhereclause=yes name=assetsubid dbname="cw_assetcard.assetsubid" )
  28. column=(type=char(18) update=yes updatewhereclause=yes name=deprsubid dbname="cw_assetcard.deprsubid" )
  29. retrieve=" SELECT cw_assetcard.accsetid,
  30. cw_assetcard.assetcardid,
  31. cw_assetcard.assetcardcode,
  32. cw_assetcard.assetcardname,
  33. cw_assetcard.assetypeid,
  34. cw_assetcard.spectype,
  35. cw_assetcard.deprediateid,
  36. cw_assetcard.deptid,
  37. cw_assetcard.incrdecrid,
  38. cw_assetcard.unit,
  39. cw_assetcard.subid,
  40. cw_assetcard.location,
  41. cw_assetcard.dscrp,
  42. cw_assetcard.othersubid ,
  43. cw_assetcard.assetsubid ,
  44. cw_assetcard.deprsubid
  45. FROM cw_assetcard
  46. WHERE ( cw_assetcard.accsetid = :arg_accsetid ) AND
  47. ( cw_assetcard.assetcardid = :arg_assetcardid ) AND
  48. ( cw_assetcard.clearflag = 0 )
  49. "
  50. update="cw_assetcard" updatewhere=0 updatekeyinplace=no
  51. arguments=(("arg_accsetid", number), ("arg_assetcardid", number))
  52. )
  53. button(name=btn_subid visible="1" 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" filename="" action="0" vtextalign="0" htextalign="0" x="1952" y="356" height="84" width="73" color="0" text=".." defaultpicture=no suppresseventprocessing=no enabled=yes )
  54. button(name=btn_othersubid visible="1" 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" filename="" action="0" vtextalign="0" htextalign="0" x="1952" y="444" height="84" width="73" color="0" text=".." defaultpicture=no suppresseventprocessing=no enabled=yes )
  55. button(name=btn_assetsubid visible="1" 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" filename="" action="0" vtextalign="0" htextalign="0" x="946" y="532" height="84" width="73" color="0" text=".." defaultpicture=no suppresseventprocessing=no enabled=yes )
  56. text(name=assetcardcode_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="41" y="28" height="56" width="334" text="固定资产编号" )
  57. text(name=assetcardname_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="41" y="112" height="56" width="334" text="固定资产名称" )
  58. text(name=assetypeid_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="8388608" alignment="1" border="0" x="41" y="196" height="56" width="334" text="固定资产类别" )
  59. text(name=deptid_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="8388608" alignment="1" border="0" x="41" y="364" height="56" width="334" text="所 属 部 门" )
  60. text(name=spectype_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="41" y="280" height="56" width="334" text="规 格 型 号" )
  61. text(name=location_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="41" y="628" height="56" width="334" text="存 放 位 置" )
  62. text(name=t_4 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="41" y="716" height="56" width="334" text="摘要" )
  63. text(name=incrdecrid_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="8388608" alignment="1" border="0" x="41" y="448" height="56" width="334" text="增 减 方 式" )
  64. text(name=t_3 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="27" y="532" height="56" width="347" text="固定资产科目" )
  65. text(name=t_2 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="1042" y="448" height="56" width="347" text="对方科目" )
  66. text(name=subid_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="1042" y="364" height="56" width="347" text="对应折旧科目" )
  67. text(name=t_1 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="1042" y="280" height="56" width="347" text="折旧方法" )
  68. column(name=assetcardcode visible="1" tag="固定资产编号" band=detail id=3 x="389" y="28" height="68" width="608" color="16711680" border="5" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=10 )
  69. column(name=assetcardname visible="1" tag="固定资产名称" band=detail id=4 x="389" y="112" height="68" width="1632" color="16711680" border="5" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=20 )
  70. column(name=assetypeid visible="1" tag="固定资产类别" band=detail id=5 x="389" y="196" height="68" width="1632" color="8388608" border="5" alignment="0" format="" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=assettypeid dddw.displaycolumn=assettypename dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_assettype dddw.nilisnull=no dddw.percentwidth=100 dddw.lines=20 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=30 )
  71. column(name=deptid visible="1" tag="所属部门" band=detail id=8 x="389" y="364" height="68" width="617" color="8388608" border="5" alignment="0" format="" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=departmentid dddw.displaycolumn=departmentname dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_deptid dddw.nilisnull=no dddw.percentwidth=100 dddw.lines=30 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=60 )
  72. column(name=spectype visible="1" tag="规格型号" band=detail id=6 x="389" y="280" height="68" width="617" color="16711680" border="5" 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=20 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=40 )
  73. column(name=location visible="1" tag="存放位置" band=detail id=12 x="389" y="628" height="68" width="1632" color="16711680" border="5" 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=60 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=120 )
  74. column(name=dscrp visible="1" band=detail id=13 x="389" y="716" height="68" width="1632" color="16711680" border="5" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=130 )
  75. column(name=incrdecrid visible="1" tag="增减方式" band=detail id=9 x="389" y="448" height="68" width="617" color="8388608" border="5" alignment="0" format="" 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 dddw.nilisnull=no dddw.percentwidth=100 dddw.lines=20 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=70 )
  76. column(name=assetsubid visible="1" band=detail id=15 x="389" y="532" height="68" width="544" color="16711680" border="5" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=100 )
  77. column(name=deprediateid visible="1" band=detail id=7 x="1403" y="280" height="68" width="617" color="16711680" border="5" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=deprediateid dddw.displaycolumn=deprediatename dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_deprediateid 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=50 )
  78. column(name=subid visible="1" tag="对应折旧科目" band=detail id=11 x="1403" y="364" height="68" width="544" color="16711680" border="5" 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=18 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=80 )
  79. column(name=othersubid visible="1" band=detail id=14 x="1403" y="448" height="68" width="544" color="16711680" border="5" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=90 )
  80. column(name=deprsubid visible="1" band=detail id=16 x="1403" y="532" height="68" width="544" color="16711680" border="5" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=no 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=110 )
  81. button(name=btn_deprsubid visible="1" 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" filename="" action="0" vtextalign="0" htextalign="0" x="1952" y="532" height="84" width="73" color="0" text=".." defaultpicture=no suppresseventprocessing=no enabled=yes )
  82. text(name=t_5 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="67108864" color="16711680" alignment="1" border="0" x="1042" y="532" height="56" width="347" text="累计折旧科目" )
  83. htmltable(border="1" )
  84. htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
  85. export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  86. import.xml()
  87. export.pdf(method=0 distill.customPostScript="0" xslfop.print="0" )