release 6;
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.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=72 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=long update=yes updatewhereclause=yes key=yes name=t_no dbname="th01.t_no" )
 column=(type=char(10) update=yes updatewhereclause=yes key=yes name=prj_id dbname="th01.prj_id" )
 column=(type=char(20) update=yes updatewhereclause=yes name=bianhao dbname="th01.bianhao" )
 column=(type=char(40) update=yes updatewhereclause=yes name=kmmc dbname="th01.kmmc" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=user_zmjz dbname="th01.user_zmjz" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=zmjz dbname="th01.zmjz" )
 retrieve="  SELECT t_no,prj_id,bianhao,kmmc,
         user_zmjz,zmjz
    FROM th01  
   WHERE ( th01.prj_id = :as ) AND  
         ( th01.is_visible = '1' )    
" update="th01" updatewhere=1 updatekeyinplace=yes arguments=(("as", string))  sort="t_no A " )
text(band=header alignment="2" text="序号"border="0" color="0" x="9" y="8" height="56" width="119"  name=t_no_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="编号"border="0" color="0" x="137" y="8" height="56" width="293"  name=bianhao_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="科目名称"border="0" color="0" x="439" y="8" height="56" width="704"  name=kmmc_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="企业账面数"border="0" color="0" x="1152" y="8" height="56" width="457"  name=user_zmjz_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="填报数"border="0" color="0" x="1618" y="8" height="56" width="443"  name=zmjz_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="比较差值"border="0" color="0" x="2071" y="8" height="56" width="334"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="1" tabsequence=10 border="0" color="0" x="9" y="8" height="68" width="119" format="[general]" protect="0~t1"  name=t_no edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=20 border="0" color="0" x="137" y="8" height="68" width="293" format="[general]" protect="0~t1"  name=bianhao edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=30 border="0" color="0" x="439" y="8" height="68" width="704" format="[general]" protect="0~t1"  name=kmmc edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="1" tabsequence=40 border="0" color="0" x="1152" y="8" height="68" width="457" format="#,##0.00"  name=user_zmjz edit.name="###,###.00" editmask.useformat=yes editmask.mask="###,###.00" editmask.focusrectangle=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="1" tabsequence=50 border="0" color="0" x="1618" y="8" height="68" width="443" format="#,##0.00"  name=zmjz edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
compute(band=detail alignment="1" expression="if(isnull( zmjz),0, zmjz) - if(isnull(user_zmjz),0,user_zmjz)"border="0" color="0~tif( cz = 0,rgb(0,0,0),rgb(255,0,0))" x="2071" y="8" height="68" width="334" format="#,##0.00"  name=cz  font.face="宋体" font.height="-9" font.weight="400~tif( cz = 0,400,700)"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")  