dw_credence_edit_popup.srd 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. $PBExportHeader$dw_credence_edit_popup.srd
  2. $PBExportComments$By Kivens.Jiang(kivens@21cn.com)
  3. release 9;
  4. datawindow ( units=3 timer_interval=0 color=15793151 processing=0 print.printername="" print.documentname="" print.orientation=0 print.margin.left=635 print.margin.right=635 print.margin.top=635 print.margin.bottom=635 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=1190 color="536870912" )
  8. detail(height=10398 color="536870912" )
  9. table(column=(type=long key=yes updatewhereclause=yes initial="0" name=credid dbname="cw_credence.credid" )
  10. column=(type=long key=yes updatewhereclause=yes initial="0" name=accsetid dbname="cw_credence.accsetid" )
  11. column=(type=long key=yes updatewhereclause=yes initial="0" name=subaccsetid dbname="cw_credence.subaccsetid" )
  12. column=(type=char(10) updatewhereclause=yes initial="empty" name=credtype dbname="cw_credence.credtype"
  13. values="" )
  14. column=(type=long updatewhereclause=yes initial="0" name=credno dbname="cw_credence.credno" )
  15. column=(type=datetime updatewhereclause=yes name=reldate dbname="cw_credence.reldate" )
  16. column=(type=char(50) updatewhereclause=yes name=reldcode dbname="cw_credence.reldcode" )
  17. column=(type=datetime updatewhereclause=yes initial="today" name=creddate dbname="cw_credence.creddate" )
  18. column=(type=long updatewhereclause=yes initial="0" name=billnumber dbname="cw_credence.billnumber" )
  19. column=(type=long updatewhereclause=yes initial="0" name=readtype dbname="cw_credence.readtype"
  20. values=" 0/结转损益 100/资产增加 200/计提折旧 201/资产减少 202/自转凭证 300/结转 301/出纳 888/" )
  21. column=(type=long updatewhereclause=yes name=cmonth dbname="cw_credence.cmonth" )
  22. column=(type=char(20) updatewhereclause=yes initial="empty" name=billmaker dbname="cw_credence.billmaker" )
  23. column=(type=datetime updatewhereclause=yes name=billmakerdate dbname="cw_credence.billmakerdate" )
  24. column=(type=char(20) updatewhereclause=yes initial="empty" name=billcheck dbname="cw_credence.billcheck" )
  25. column=(type=datetime updatewhereclause=yes name=billcheckdate dbname="cw_credence.billcheckdate" )
  26. column=(type=char(20) updatewhereclause=yes initial="empty" name=billpost dbname="cw_credence.billpost" )
  27. column=(type=datetime updatewhereclause=yes name=billpostdate dbname="cw_credence.billpostdate" )
  28. column=(type=long updatewhereclause=yes name=checkflag dbname="cw_credence.checkflag" )
  29. column=(type=long updatewhereclause=yes name=postflag dbname="cw_credence.postflag" )
  30. column=(type=long updatewhereclause=yes name=relevantbillid dbname="cw_credence.relevantbillid" )
  31. column=(type=char(20) updatewhereclause=yes name=modemp dbname="cw_credence.modemp" )
  32. column=(type=datetime updatewhereclause=yes name=moddate dbname="cw_credence.moddate" )
  33. column=(type=long updatewhereclause=yes name=ifauto dbname="cw_credence.ifauto"
  34. values=" 1/ 0" )
  35. retrieve=" SELECT cw_credence.credid,
  36. cw_credence.accsetid,
  37. cw_credence.subaccsetid,
  38. cw_credence.credtype,
  39. cw_credence.credno,
  40. cw_credence.reldate,
  41. cw_credence.reldcode,
  42. cw_credence.creddate,
  43. cw_credence.billnumber,
  44. cw_credence.readtype,
  45. cw_credence.cmonth,
  46. cw_credence.billmaker,
  47. cw_credence.billmakerdate,
  48. cw_credence.billcheck,
  49. cw_credence.billcheckdate,
  50. cw_credence.billpost,
  51. cw_credence.billpostdate,
  52. cw_credence.checkflag,
  53. cw_credence.postflag,
  54. cw_credence.relevantbillid ,
  55. cw_credence.modemp ,
  56. cw_credence.moddate ,
  57. cw_credence.ifauto
  58. FROM cw_credence
  59. WHERE cw_credence.accsetid = :arg_accsetid
  60. "
  61. update="cw_credence" updatewhere=0 updatekeyinplace=no
  62. arguments=(("arg_accsetid", number))
  63. )
  64. column(name=billcheckdate visible="1" tag="审核时间" band=footer id=15 x="10265" y="662" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" 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=yes 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 )
  65. text(name=billcheckdate_t visible="1" 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="0" alignment="1" border="0" x="8704" y="662" height="370" width="1508" text="审核时间:" )
  66. column(name=billmakerdate visible="1" band=footer id=13 x="6058" y="662" height="476" width="2592" 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 )
  67. column(name=billpostdate visible="1" tag="登帐时间" band=footer id=17 x="14472" y="662" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" 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=yes 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 )
  68. text(name=billpostdate_t visible="1" 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="0" alignment="1" border="0" x="12911" y="662" height="370" width="1508" text="登帐时间:" )
  69. column(name=billpost visible="1" tag="登帐" band=footer id=16 x="14472" y="80" height="476" width="2592" 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=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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  70. text(name=billpost_t visible="1" 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="0" alignment="1" border="0" x="12911" y="80" height="370" width="1508" text="登 帐:" )
  71. column(name=billcheck visible="1" tag="审核" band=footer id=14 x="10265" y="80" height="476" width="2592" 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=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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  72. text(name=billcheck_t visible="1" 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="0" alignment="1" border="0" x="8704" y="80" height="370" width="1508" text="审 核:" )
  73. column(name=billmaker visible="1" tag="制单" band=footer id=12 x="6058" y="80" height="476" width="2592" 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=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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  74. text(name=billmaker_t visible="1" 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="0" alignment="1" border="0" x="4497" y="80" height="370" width="1508" text="制 单:" )
  75. text(name=billmakerdate_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="1" border="0" x="4497" y="662" height="370" width="1508" text="制单时间:" )
  76. column(name=moddate visible="1" band=footer id=22 x="1852" y="662" height="476" width="2592" 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=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  77. text(name=t_6 visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="1" border="0" x="291" y="662" height="370" width="1508" text="修改时间:" )
  78. text(name=t_7 visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="1" border="0" x="291" y="80" height="370" width="1508" text="修 改:" )
  79. column(name=modemp visible="1" band=footer id=21 x="1852" y="80" height="476" width="2592" 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="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  80. text(name=t_1 visible="1" band=detail font.charset="134" font.face="楷体_GB2312" font.family="1" font.height="-20" font.pitch="1" font.weight="700" background.mode="1" background.color="536870912" color="0" alignment="2" border="0" x="6482" y="80" height="820" width="4550" text="记 帐 凭 证" )
  81. text(name=subaccsetid_t visible="1 0" band=detail 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="1" border="0" x="17885" y="477" height="370" width="1640" text="子 帐:" )
  82. column(name=subaccsetid visible="1 0" tag="子帐ID" band=detail id=3 x="19658" y="371" height="476" width="1905" color="0" border="5" alignment="1" 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=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=0 )
  83. text(name=credtype_t visible="1" band=detail 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="1" border="0" x="79" y="186" height="370" width="1666" text="凭 证 字:" )
  84. 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="15793151" color="0" alignment="1" border="0" x="16668" y="768" height="370" width="370" text="张" )
  85. column(name=credtype visible="1" tag="凭证字类型" band=detail id=4 x="1852" y="80" height="476" width="2169" color="0" border="5" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=yes dddw.datacolumn=credenceword dddw.displaycolumn=credenceword dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_credword dddw.nilisnull=no dddw.percentwidth=100 dddw.lines=10 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 )
  86. column(name=credno visible="1" tag="编号" band=detail id=5 x="1852" y="662" height="476" width="2169" color="0" border="5" alignment="0" format="###0" edit.format="###0" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  87. column(name=reldate visible="1" band=detail id=6 x="1852" y="1244" height="476" width="2169" color="0" border="5" alignment="2" format="[shortdate] [time]" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=yes editmask.useformat=no editmask.spinincr=1 editmask.spinrange="~~" editmask.mask="yyyy-mm-dd" editmask.imemode=0 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 )
  88. 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="1" background.color="536870912" color="0" alignment="1" border="0" x="4180" y="1350" height="370" width="1349" text="相关号:" )
  89. 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="1" background.color="553648127" color="0" alignment="1" border="0" x="13096" y="186" height="370" width="1693" text="凭证类型:" )
  90. text(name=creddate_t visible="1" band=detail 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="1" border="0" x="13096" y="1350" height="370" width="1693" text="凭证日期:" )
  91. column(name=readtype visible="1" band=detail id=10 x="14896" y="80" height="476" width="2169" color="0" border="5" alignment="0" format="[general]" ddlb.allowedit=no ddlb.autohscroll=no ddlb.imemode=0 ddlb.limit=0 ddlb.showlist=no ddlb.sorted=no ddlb.useasborder=no ddlb.vscrollbar=no ddlb.nilisnull=no ddlb.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="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  92. column(name=billnumber visible="1" tag="附件" band=detail id=9 x="14896" y="662" height="476" width="1693" color="0" border="5" alignment="0" format="##0" edit.format="##0" edit.focusrectangle=no 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=0 )
  93. text(name=credno_t visible="1" band=detail 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="1" border="0" x="79" y="768" height="370" width="1666" text="凭证编号:" )
  94. 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="1" background.color="536870912" color="0" alignment="1" border="0" x="79" y="1350" height="370" width="1666" text="相关日期:" )
  95. column(name=creddate visible="1" tag="日期" band=detail id=8 x="14896" y="1244" height="476" width="2169" color="0" border="5" alignment="2" format="yyyy-mm-dd" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=yes editmask.useformat=no editmask.spinincr=1 editmask.spinrange="~~" editmask.mask="yyyy-mm-dd" editmask.imemode=0 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 )
  96. text(name=billnumber_t visible="1" band=detail 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="1" border="0" x="13096" y="768" height="370" width="1693" text="附 件:" )
  97. text(name=t_8 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="15793151" color="33554432" alignment="1" border="0" x="11641" y="768" height="370" width="793" text="自动" )
  98. column(name=reldcode visible="1" band=detail id=7 x="5662" y="1244" height="476" width="7223" color="0" border="5" alignment="0" format="[general]" 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="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  99. column(name=ifauto visible="1" band=detail id=23 x="12514" y="768" height="370" width="370" color="0" border="0" alignment="0" 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="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
  100. htmltable(border="1" )
  101. htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
  102. export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  103. import.xml()
  104. export.pdf(method=0 distill.customPostScript="0" xslfop.print="0" )