hyhandylit
- 浏览: 67175 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
公共函数：
//求表格的合计数据。
function js(row,cell){
var hj=0;
for(var i=0;i<maintb.rows.length;i++){
if(maintb.rows(i).tableID!=''&&maintb.rows(i).tableID==row){
for(var j=0;j<maintb.rows(i).cells.length;j++){
if(maintb.rows(i).cells(j).id!=''&&maintb.rows
(i).cells(j).id==cell){
hj=hj+(maintb.rows(i).cells(j).innerText*1)
}
}
}
}
return hj;
}
get('B10').innerText=js('row8','B8');
get('C10').innerText=js('row8','C8');
get('D10').innerText=js('row8','D8');
get('E10').innerText=js('row8','E8');
get('F10').innerText=js('row8','F8');
get('G10').innerText=js('row8','G8');
get('H10').innerText=js('row8','H8');
get('I10').innerText=js('row8','I8');
get('J10').innerText=js('row8','J8');
get('K10').innerText=js('row8','K8');
参照jsp页面看maintb和表格行：
<!--buldtype=class:0-->
<%@ page contentType="text/html; charset=GB2312" %>
<META http-equiv="content-type" content="text/html; charset=gb2312">
<META http-equiv="pragma" content="no-cache">
<META http-equiv="Cache-Control" content="no-cache">
<META NAME="Generator" CONTENT="websync平台">
<%@ page import="java.util.*" %>
<%@ page import="com.web.*" %>
<%@ page import="com.obj.*" %>
<%@ page import="com.pub.*" %>
<%@ page import="com.dataset.SResultSetEx" %>
<%session.setAttribute("s_fileIDString","zjgc/zscsg/jd/rpt/cycdt.xml");%>
<%@include file="/app/arc/arc_oversession.jsp"%>
<%SResultSetEx rs =new SResultSetEx("source-user",request.getServerPort());%>
<%String sql=""; %>
<HTML xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:print xmlns:v="urn:schemas-microsoft-com:vml">
<HEAD>
<LINK href="/app/app.css" type="text/css" rel="stylesheet" id="app">
<SCRIPT src="/app/js/common.js" language="JScript.encode"></SCRIPT>
<SCRIPT src="/app/js/input.js" language="JScript.encode"></SCRIPT>
<SCRIPT src="/app/js/myapp.js" language="JScript.encode"></SCRIPT>
<TITLE>采油厂、地区生产动态表</TITLE>
<SCRIPT src="/app/js/tool.js" language="JScript.encode"></SCRIPT>
<%
//package userdsn.zjgc.zscsg.jd.rpt
class CycdtHandler extends Handler{
private static final String JNDI_NAME = "cycdt";
public Ireq performTask(HttpServletRequest request){
Ireq ireq=new Ireq();
String port=String.valueOf(request.getServerPort());
ireq.setArc((Arc)request.getAttribute("arc"));
String m_addedtdel=(String)request.getAttribute("m_addedtdel");
Arc arc =ireq.getArc();
String _A3_B1=ireq.rsetValue("_A3_B1",request,CommonEx.f_today());
String _A3_D1=ireq.rsetValue("_A3_D1",request,"1");
String q_row8_order=ireq.rsetValue("q_row8_order",request,"");
String q_row8_order_old=ireq.rsetValue("q_row8_order_old",request,"");
String q_row8_pageno=ireq.rsetValue("q_row8_pageno",request,"0");
String q_row8_pagerows=ireq.rsetValue("q_row8_pagerows",request,"1");
String q_row9_order=ireq.rsetValue("q_row9_order",request,"");
String q_row9_order_old=ireq.rsetValue("q_row9_order_old",request,"");
String q_row9_pageno=ireq.rsetValue("q_row9_pageno",request,"0");
String q_row9_pagerows=ireq.rsetValue("q_row9_pagerows",request,"1");
String q_rows_idx=ireq.rsetValue("q_rows_idx",request,"");
if(!m_addedtdel.equals(Arc.SEARCH)){
}
if(!m_addedtdel.equals(Arc.SEARCH)){
ireq=save(ireq,port,m_addedtdel);
}
ireq=search(ireq,port);
return ireq;
}
//}//public class CycdtEJB extends SessionEJB {
public Ireq befsearch(Ireq ireq,String port){//获得属性函数参数值
return ireq;
}
public Ireq search(Ireq ireq,String port){
SResultSetEx rs =new SResultSetEx("source-user",port);
Arc arc =ireq.getArc();
String savetype=ireq.getSaveCode();
String sql="";
String _A3_B1=ireq.getValue("_A3_B1");
String _A3_D1=ireq.getValue("_A3_D1");
String q_row8_order=ireq.getValue("q_row8_order");
String q_row8_order_old=ireq.getValue("q_row8_order_old");
String q_row8_pageno=ireq.getValue("q_row8_pageno");
String q_row8_pagerows=ireq.getValue("q_row8_pagerows");
String q_row9_order=ireq.getValue("q_row9_order");
String q_row9_order_old=ireq.getValue("q_row9_order_old");
String q_row9_pageno=ireq.getValue("q_row9_pageno");
String q_row9_pagerows=ireq.getValue("q_row9_pagerows");
String q_rows_idx=ireq.getValue("q_rows_idx");
sql ="SELECT 1 ,A.bc_mc AS a_bc_mc_1,A.id AS a_id_1";
sql+=" FROM bbz_glzxsj A";
sql+=" WHERE 1=1 ";
rs.executeQuery(sql);
Table list_A3_D1=ireq.setTable("list_A3_D1",rs.getTable());
String $bbz_glzxsja_bc_mc_1=rs.getFieldValue(0,"a_bc_mc_1");
String $bbz_glzxsja_id_1=rs.getFieldValue(0,"a_id_1");
sql ="SELECT 1 ,SUM(A.bnjj+A.qnjj) AS bqnjj_1,SUM(A.brzjs) AS a_brzjs_1,SUM(A.bnjj) AS a_bnjj_1,A.ssjf_mc AS a_ssjf_mc_1,SUM(A.bnjc) AS a_bnjc_1,SUM(A.byjc) AS a_byjc_1,SUM(A.bykz) AS a_bykz_1,SUM(A.qnjj) AS a_qnjj_1,SUM(A.bnkz) AS a_bnkz_1,SUM(A.brjc) AS a_brjc_1,SUM(A.byjj) AS a_byjj_1";
sql+=" FROM vzsc_v_sgrbbc A";
sql+=" WHERE 1=1 ";
sql+=" AND A.bc_rq='"+_A3_B1+"' AND ('"+_A3_D1+"'='' OR A.id_glzxsj='"+_A3_D1+"') AND (1=1 OR A.scfl_mc='')";
sql+=" GROUP BY A.scfl_mc,A.ssjf_bm,A.ssjf_mc";
sql+=" ORDER BY ";
if(!q_row8_order.trim().equals("")) sql+=q_row8_order;
else sql+="A.ssjf_bm asc,case when scfl_mc like '%关联%' then 1 when scfl_mc like '%本%' then 2 else 3 end asc";
rs.executeQuery(sql,q_row8_pageno,q_row8_pagerows);
Table row8=ireq.setTable("row8",rs.getTable());
String vzscsg_jdbccycbqnjj_1=rs.getFieldValue(0,"bqnjj_1");
String vzscsg_jdbccyca_brzjs_1=rs.getFieldValue(0,"a_brzjs_1");
String vzscsg_jdbccyca_bnjj_1=rs.getFieldValue(0,"a_bnjj_1");
String vzscsg_jdbccyca_ssjf_mc_1=rs.getFieldValue(0,"a_ssjf_mc_1");
String vzscsg_jdbccyca_bnjc_1=rs.getFieldValue(0,"a_bnjc_1");
String vzscsg_jdbccyca_byjc_1=rs.getFieldValue(0,"a_byjc_1");
String vzscsg_jdbccyca_bykz_1=rs.getFieldValue(0,"a_bykz_1");
String vzscsg_jdbccyca_qnjj_1=rs.getFieldValue(0,"a_qnjj_1");
String vzscsg_jdbccyca_bnkz_1=rs.getFieldValue(0,"a_bnkz_1");
String vzscsg_jdbccyca_brjc_1=rs.getFieldValue(0,"a_brjc_1");
String vzscsg_jdbccyca_byjj_1=rs.getFieldValue(0,"a_byjj_1");
sql ="SELECT 1 ,SUM(A.bnjj+A.qnjj) AS bqnjj_1,SUM(A.brzjs) AS a_brzjs_1,SUM(A.bnjj) AS a_bnjj_1,SUM(A.bnjc) AS a_bnjc_1,SUM(A.byjc) AS a_byjc_1,A.ssjf_mc AS row9_cyc,SUM(A.bykz) AS a_bykz_1,SUM(A.qnjj) AS a_qnjj_1,SUM(A.bnkz) AS a_bnkz_1,SUM(A.brjc) AS a_brjc_1,SUM(A.byjj) AS a_byjj_1,A.qk_mc AS a_qk_mc_1";
sql+=" FROM vzsc_v_sgrbbc A";
sql+=" WHERE 1=1 ";
sql+=" AND A.bc_rq='"+_A3_B1+"' AND ('"+_A3_D1+"'='' OR A.id_glzxsj='"+_A3_D1+"') AND (1=1 OR A.scfl_mc='')";
String L9_in="";///条件替换L9 in(L8) row8.getFieldValue(i,"a_ssjf_mc_1")
for(int i=0;i<row8.getRow();i++){
L9_in+=",'"+row8.getFieldValue(i,"a_ssjf_mc_1")+"'";
}
if(L9_in.startsWith(",")) L9_in=L9_in.substring(1);
sql+=" AND (A.ssjf_mc in ("+L9_in+"))";
sql+=" GROUP BY A.qk_mc,A.scfl_mc,A.ssjf_mc";
if(!q_row9_order.equals("")) sql+=" ORDER BY "+q_row9_order;
rs.executeQuery(sql,q_row9_pageno,q_row9_pagerows);
Table row9=ireq.setTable("row9",rs.getTable());
String vzscsg_jdbcqkbqnjj_1=rs.getFieldValue(0,"bqnjj_1");
String vzscsg_jdbcqka_brzjs_1=rs.getFieldValue(0,"a_brzjs_1");
String vzscsg_jdbcqka_bnjj_1=rs.getFieldValue(0,"a_bnjj_1");
String vzscsg_jdbcqka_bnjc_1=rs.getFieldValue(0,"a_bnjc_1");
String vzscsg_jdbcqka_byjc_1=rs.getFieldValue(0,"a_byjc_1");
String vzscsg_jdbcqkrow9_cyc=rs.getFieldValue(0,"row9_cyc");
String vzscsg_jdbcqka_bykz_1=rs.getFieldValue(0,"a_bykz_1");
String vzscsg_jdbcqka_qnjj_1=rs.getFieldValue(0,"a_qnjj_1");
String vzscsg_jdbcqka_bnkz_1=rs.getFieldValue(0,"a_bnkz_1");
String vzscsg_jdbcqka_brjc_1=rs.getFieldValue(0,"a_brjc_1");
String vzscsg_jdbcqka_byjj_1=rs.getFieldValue(0,"a_byjj_1");
String vzscsg_jdbcqka_qk_mc_1=rs.getFieldValue(0,"a_qk_mc_1");
ireq.setMathValue("_A3_B1","{@}"+_A3_B1);
ireq.setMathValue("_A3_D1","{@}"+_A3_D1);
ireq.setMathValue("A8","{@}"+vzscsg_jdbccyca_ssjf_mc_1+"(小计)");
ireq.setMathValue("B8","{@}"+vzscsg_jdbccyca_brzjs_1);
ireq.setMathValue("C8","{@}"+vzscsg_jdbccyca_bykz_1);
ireq.setMathValue("D8","{@}"+vzscsg_jdbccyca_bnkz_1);
ireq.setMathValue("E8","{@}"+vzscsg_jdbccyca_byjj_1);
ireq.setMathValue("F8","{@}"+vzscsg_jdbccycbqnjj_1);
ireq.setMathValue("G8","{@}"+vzscsg_jdbccyca_bnjj_1);
ireq.setMathValue("H8","{@}"+vzscsg_jdbccyca_qnjj_1);
ireq.setMathValue("I8","{@}"+vzscsg_jdbccyca_brjc_1);
ireq.setMathValue("J8","{@}"+vzscsg_jdbccyca_byjc_1);
ireq.setMathValue("K8","{@}"+vzscsg_jdbccyca_bnjc_1);
ireq.setMathValue("L8","{@}"+vzscsg_jdbccyca_ssjf_mc_1);
ireq.setMathValue("A9","{@}"+vzscsg_jdbcqka_qk_mc_1);
ireq.setMathValue("B9","{@}"+vzscsg_jdbcqka_brzjs_1);
ireq.setMathValue("C9","{@}"+vzscsg_jdbcqka_bykz_1);
ireq.setMathValue("D9","{@}"+vzscsg_jdbcqka_bnkz_1);
ireq.setMathValue("E9","{@}"+vzscsg_jdbcqka_byjj_1);
ireq.setMathValue("F9","{@}"+vzscsg_jdbcqkbqnjj_1);
ireq.setMathValue("G9","{@}"+vzscsg_jdbcqka_bnjj_1);
ireq.setMathValue("H9","{@}"+vzscsg_jdbcqka_qnjj_1);
ireq.setMathValue("I9","{@}"+vzscsg_jdbcqka_brjc_1);
ireq.setMathValue("J9","{@}"+vzscsg_jdbcqka_byjc_1);
ireq.setMathValue("K9","{@}"+vzscsg_jdbcqka_bnjc_1);
ireq.setMathValue("L9","{@}"+vzscsg_jdbcqkrow9_cyc);
return ireq;
}
public Ireq save(Ireq ireq,String port, String m_addedtdel){
SResultSetEx rs =new SResultSetEx("source-user",port);
Arc arc =ireq.getArc();
String sql="";
String _A3_B1=ireq.getValue("_A3_B1");//日期
String _A3_D1=ireq.getValue("_A3_D1");//班次
//查询变量String ;_A3_B1;_A3_D1;
return ireq;
}
}
%><%
String m_addedtdel=Arc.getAddedtdelx(request,"zjgcvzscsgvjdvrptvcycdt");
if(m_addedtdel.equals(Arc.XLS)){
response.setContentType("application/vnd.ms-excel;charset=gb2312");
m_addedtdel=Arc.SEARCH;
}
request.setAttribute("arc",session.getAttribute("arc"));
request.setAttribute("m_addedtdel",m_addedtdel);
Ireq ireq=new CycdtHandler().performTask(request);
String _A3_B1=ireq.getValue("_A3_B1");
String _A3_D1=ireq.getValue("_A3_D1");
String q_row8_order=ireq.getValue("q_row8_order");
String q_row8_order_old=ireq.getValue("q_row8_order_old");
String q_row8_pageno=ireq.getValue("q_row8_pageno");
String q_row8_pagerows=ireq.getValue("q_row8_pagerows");
String q_row9_order=ireq.getValue("q_row9_order");
String q_row9_order_old=ireq.getValue("q_row9_order_old");
String q_row9_pageno=ireq.getValue("q_row9_pageno");
String q_row9_pagerows=ireq.getValue("q_row9_pagerows");
String q_rows_idx=ireq.getValue("q_rows_idx");
String savetype=ireq.getSaveCode();
if(!savetype.equals(Arc.SEARCH)){
%><script>alert("<%=ireq.getSaveMsg()%>")</script><%
}
Table row8=ireq.getTable("row8");
int q_row8_pagecount=row8.getPageCount();
int row8_pageno=row8.getCurPage();
int row8_dbrow= row8.getRow();
int row8_pagerows= Integer.parseInt(q_row8_pagerows);
if(!q_row8_pageno.equals("0")) q_row8_pageno=String.valueOf(row8_pageno);
row8_pagerows=row8_pagerows<row8_dbrow?row8_dbrow:row8_pagerows;
Table list_A3_D1=ireq.getTable("list_A3_D1");
Table row9=ireq.getTable("row9");
int q_row9_pagecount=row9.getPageCount();
int row9_pageno=row9.getCurPage();
int row9_dbrow= row9.getRow();
int row9_pagerows= Integer.parseInt(q_row9_pagerows);
if(!q_row9_pageno.equals("0")) q_row9_pageno=String.valueOf(row9_pageno);
row9_pagerows=row9_pagerows<row9_dbrow?row9_dbrow:row9_pagerows;
Maths math=ireq.getMath();
out.println(math.printErro("id_math_erro"));
String L9_in=math.getExpValue("L9_IN");
out.print(ireq.getPrint());
%>
<script>var savetype="<%=savetype%>";</script>
</HEAD>
<BODY fileType="lstrpt" class="BodyWhiteStyle" onhelp="F1Help();" onunload="endpage()" onload="bgnpage()" fileEngName="zjgc/zscsg/jd/rpt/cycdt.xml" scroll="no" onkeydown="return keypressdown()" outputfile="/app/userfile/zjgc/zscsg/jd/rpt/cycdt_print.jsp">
<FORM name="brow" method="post" id="brow">
<%if(!ireq.isMedia(request)){%><DIV style="display:none" id="para_div">
<INPUT value="<%=session.getAttribute("m_synIDzjgcvzscsgvjdvrptvcycdt")%>" type="hidden" name="m_clientsynID">
<INPUT value="0" type="hidden" name="m_addedtdel">
<INPUT value="<%=q_row8_order%>" type="hidden" name="q_row8_order">
<INPUT value="<%=q_row8_order_old%>" type="hidden" name="q_row8_order_old">
<INPUT value="<%=q_row8_pageno%>" type="hidden" name="q_row8_pageno">
<INPUT value="<%=q_row8_pagerows%>" type="hidden" name="q_row8_pagerows">
<INPUT value="<%=q_row8_pagecount%>" type="hidden" name="q_row8_pagecount">
<INPUT value="<%=q_row9_order%>" type="hidden" name="q_row9_order">
<INPUT value="<%=q_row9_order_old%>" type="hidden" name="q_row9_order_old">
<INPUT value="<%=q_row9_pageno%>" type="hidden" name="q_row9_pageno">
<INPUT value="<%=q_row9_pagerows%>" type="hidden" name="q_row9_pagerows">
<INPUT value="<%=q_row9_pagecount%>" type="hidden" name="q_row9_pagecount">
<INPUT value="<%=q_rows_idx%>" type="hidden" name="q_rows_idx">
</DIV><%}%>
<DIV style="WIDTH: 100%; HEIGHT: 100%;POSITION:absolute;OVERFLOW:auto;TOP:0;LEFT:0;" id="maindv">
<TABLE cellPadding="0" ondblclick="editCell(this)" style="TABLE-LAYOUT:fixed" border="0" cellSpacing="0" id="maintb">
<COLGROUP>
<COL style="WIDTH: 130px" id="maintb_A">
<COL style="WIDTH: 91px" id="maintb_B">
<COL style="WIDTH: 72px" id="maintb_C">
<COL style="WIDTH: 72px" id="maintb_D">
<COL style="WIDTH: 69px" id="maintb_E">
<COL style="WIDTH: 92px" id="maintb_F">
<COL style="WIDTH: 100px" id="maintb_G">
<COL style="WIDTH: 104px" id="maintb_H">
<COL style="WIDTH: 97px" id="maintb_I">
<COL style="WIDTH: 97px" id="maintb_J">
<COL style="WIDTH: 75px" id="maintb_K">
<COL style="WIDTH: 75px;display:none;" id="maintb_L">
</COLGROUP>
<TBODY>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A1">
</TD>
<TD id="B1">
</TD>
<TD id="C1">
</TD>
<TD id="D1">
</TD>
<TD id="E1">
</TD>
<TD id="F1">
</TD>
<TD id="G1">
</TD>
<TD id="H1">
</TD>
<TD id="I1">
</TD>
<TD id="J1">
</TD>
<TD id="K1">
</TD>
<TD id="L1">
</TD>
</TR>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A2">
</TD>
<TD id="B2">
</TD>
<TD id="C2">
</TD>
<TD id="D2">
</TD>
<TD id="E2">
</TD>
<TD id="F2">
</TD>
<TD id="G2">
</TD>
<TD id="H2">
</TD>
<TD id="I2">
</TD>
<TD id="J2">
</TD>
<TD id="K2">
</TD>
<TD id="L2">
</TD>
</TR>
<TR style="HEIGHT:25">
<TD class="TdTool" colSpan="11" style="VERTICAL-ALIGN: top; TEXT-ALIGN: left" id="A3">
<DIV style="TOP:0;LEFT:0;WIDTH:100%;HEIGHT:100%;" id="A3_div">
<TABLE cellPadding="0" style="TABLE-LAYOUT:fixed" border="0" cellSpacing="0" id="A3_tb">
<COLGROUP>
<COL style="WIDTH: 59px" id="A3_A">
<COL style="WIDTH: 91px" id="A3_B">
<COL style="WIDTH: 43px" id="A3_C">
<COL style="WIDTH: 80px" id="A3_D">
<COL style="WIDTH: 37px" id="A3_E">
<COL style="WIDTH: 58px" id="A3_F">
<COL style="WIDTH: 100px" id="A3_G">
<COL style="WIDTH: 58px" id="A3_H">
<COL style="WIDTH: 97px" id="A3_I">
</COLGROUP>
<TBODY>
<TR style="HEIGHT: 25px">
<TD class="TdTool" style="TEXT-ALIGN: right" id="A3_A1">
日期
</TD>
<TD class="TdTool" id="A3_B1">
<INPUT chsName="日期" isSerchCtrl="1" maxLength="10" value="<%=_A3_B1%>" dataType="date" ondblclick="getDate(this,false)" style="WIDTH: 81px; HEIGHT: 20px;ime-mode:disabled;" onkeydown="keydown(this)" name="_A3_B1" onblur="inputblur(this)">
</TD>
<TD class="TdTool" style="TEXT-ALIGN: right" id="A3_C1">
班次
</TD>
<TD class="TdTool" id="A3_D1">
<SELECT chsName="班次" isSerchCtrl="1" tableID="list_A3_D1" style="WIDTH: 70px; HEIGHT: 20px" initVal="<%="1"%>" name="_A3_D1">
<%for(int j=0;j<list_A3_D1.getRow();j++){%>
<OPTION <%=_A3_D1.equals(list_A3_D1.getFieldValue(j,"a_id_1"))?"selected":""%> value="<%=list_A3_D1.getFieldValue(j,"a_id_1")%>"><%=list_A3_D1.getFieldValue(j,"a_bc_mc_1")%></OPTION>
<%}%>
</SELECT>
</TD>
<TD class="TdTool" id="A3_E1">
</TD>
<TD class="TdTool" id="A3_F1">
<INPUT value="查询" btnType="btnFind" title="查询" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_F1" settool="0" onmouseup="this.className='ButtonNow'" style="WIDTH: 50px; HEIGHT: 20px" onmouseover="this.className='ButtonOn'">
</TD>
<TD class="TdTool" id="A3_G1">
</TD>
<TD class="TdTool" id="A3_H1">
<INPUT value="打印" btnType="btnPrintWeb" title="打印" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_H1" settool="0" onmouseup="this.className='ButtonNow'" style="WIDTH: 50px; HEIGHT: 20px" onmouseover="this.className='ButtonOn'">
</TD>
<TD class="TdTool" style="WIDTH: 60px" id="A3_I1">
<INPUT value="任意编辑" btnType="btnEdtCell" title="任意编辑" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_I1" style="WIDTH: 70px; HEIGHT: 20px" onmouseup="this.className='ButtonNow'" onmouseover="this.className='ButtonOn'">
</TD>
</TR>
</TBODY>
</TABLE>
</DIV>
</TD>
<TD class="TdFilt" id="L3">
</TD>
</TR>
<TR style="HEIGHT: 10px">
<TD id="A4">
</TD>
<TD id="B4">
</TD>
<TD colSpan="2" id="C4">
</TD>
<TD colSpan="4" id="E4">
</TD>
<TD colSpan="3" id="I4">
</TD>
<TD id="L4">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadT" rowSpan="3" style="TEXT-ALIGN: center" id="A5">
采油厂、区块
</TD>
<TD class="TdFiltHeadT" rowSpan="3" style="TEXT-ALIGN: center" id="B5">
动用钻机<BR>（台）
</TD>
<TD class="TdFiltHeadT" colSpan="2" style="TEXT-ALIGN: center" id="C5">
开钻（口）
</TD>
<TD class="TdFiltHeadT" colSpan="4" style="TEXT-ALIGN: center" id="E5">
交井（口）
</TD>
<TD class="TdFiltHeadT" colSpan="3" style="TEXT-ALIGN: center" id="I5">
进尺（米）
</TD>
<TD id="L5">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="C6">
本月
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="D6">
年累计
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="E6">
本月
</TD>
<TD class="TdFiltHeadTnU" colSpan="3" style="TEXT-ALIGN: center" id="F6">
年累计
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="I6">
日进尺
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="J6">
本月
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="K6">
年累计
</TD>
<TD id="L6">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="F7">
合计
</TD>
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="G7">
今年
</TD>
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="H7">
去年
</TD>
<TD class="TdFiltHeadTnU" id="I7">
</TD>
</TR>
<%
for(int row8_i=0;row8_i<row8_pagerows;row8_i++){//row8
String row8_A8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_ssjf_mc_1")+"(小计)");
String row8_B8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_brzjs_1"));
String row8_C8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bykz_1"));
String row8_D8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnkz_1"));
String row8_E8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_byjj_1"));
String row8_F8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"bqnjj_1"));
String row8_G8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnjj_1"));
String row8_H8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_qnjj_1"));
String row8_I8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_brjc_1"));
String row8_J8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_byjc_1"));
String row8_K8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnjc_1"));
String row8_L8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_ssjf_mc_1"));
%>
<TR <%=(row8_i<row8_dbrow)?"onmousedown=\"downRow(this);\" ondblclick=\"dblclickrow(this);;\"":""%> tableID="row8" selbgColor="#9CF9F9" style="HEIGHT: 22px" selTrClass="TrCurRow" id="row8" isTrListgroup="1" gridFillType="GOON">
<TD value="<%=row8_A8%>" class="TdCell" style="BACKGROUND-COLOR: #c4df9b" id="A8">
<%=Maths.getFmtValues(row8_A8,"char","")%>
</TD>
<TD value="<%=row8_B8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="B8">
<%=Maths.getFmtValues(row8_B8,"num","####")%>
</TD>
<TD value="<%=row8_C8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="C8">
<%=Maths.getFmtValues(row8_C8,"num","####")%>
</TD>
<TD value="<%=row8_D8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="D8">
<%=Maths.getFmtValues(row8_D8,"num","####")%>
</TD>
<TD value="<%=row8_E8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="E8">
<%=Maths.getFmtValues(row8_E8,"num","####")%>
</TD>
<TD value="<%=row8_F8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="F8">
<%=Maths.getFmtValues(row8_F8,"num","####")%>
</TD>
<TD value="<%=row8_G8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="G8">
<%=Maths.getFmtValues(row8_G8,"num","####")%>
</TD>
<TD value="<%=row8_H8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="H8">
<%=Maths.getFmtValues(row8_H8,"num","####")%>
</TD>
<TD value="<%=row8_I8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="I8">
<%=Maths.getFmtValues(row8_I8,"num","####")%>
</TD>
<TD value="<%=row8_J8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="J8">
<%=Maths.getFmtValues(row8_J8,"num","####")%>
</TD>
<TD value="<%=row8_K8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="K8">
<%=Maths.getFmtValues(row8_K8,"num","####")%>
</TD>
<TD value="<%=row8_L8%>" style="BACKGROUND-COLOR: #c4df9b" id="L8">
<%=Maths.getFmtValues(row8_L8,"char","")%>
</TD>
</TR>
<%row9.resetFilt();
for(int row9_i=0;row9_i<row9.getRow(); row9_i++){
if(!row8_L8.equals(row9.getFieldValue(row9_i,"row9_cyc")))continue;
row9.selFiltValue(row9_i);
}
row9.applyFilt();
row9_dbrow=row9.getRow();
row9_pagerows=Integer.parseInt(q_row9_pagerows);
row9_pagerows=row9_pagerows<row9_dbrow?row9_dbrow:row9_pagerows;%>
<%for(int row9_i=0;row9_i<row9_pagerows;row9_i++){//row9
String row9_cyc=row9.getFieldValue(row9_i,"row9_cyc");String row9_CYC=row9_cyc;
String row9_A9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_qk_mc_1"));
String row9_B9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_brzjs_1"));
String row9_C9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bykz_1"));
String row9_D9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnkz_1"));
String row9_E9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_byjj_1"));
String row9_F9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"bqnjj_1"));
String row9_G9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnjj_1"));
String row9_H9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_qnjj_1"));
String row9_I9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_brjc_1"));
String row9_J9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_byjc_1"));
String row9_K9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnjc_1"));
String row9_L9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"row9_cyc"));
%>
<TR tableID="row9" cyc="<%=row9_cyc%>" id="row9" isTrListgroup="1" <%=(row9_i<row9_dbrow)?"onmousedown=\"downRow(this);\" ondblclick=\"dblclickrow(this);;\"":""%> pnames="cyc" selbgColor="#9CF9F9" style="HEIGHT: 22px" selTrClass="TrCurRow" gridFillType="GOON">
<TD value="<%=row9_A9%>" dent="10" class="TdCell" style="PADDING-LEFT: 10px; TEXT-ALIGN: left" id="A9">
<%=Maths.getFmtValues(row9_A9,"char","")%>
</TD>
<TD value="<%=row9_B9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="B9">
<%=Maths.getFmtValues(row9_B9,"num","####")%>
</TD>
<TD value="<%=row9_C9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="C9">
<%=Maths.getFmtValues(row9_C9,"num","####")%>
</TD>
<TD value="<%=row9_D9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="D9">
<%=Maths.getFmtValues(row9_D9,"num","####")%>
</TD>
<TD value="<%=row9_E9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="E9">
<%=Maths.getFmtValues(row9_E9,"num","####")%>
</TD>
<TD value="<%=row9_F9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="F9">
<%=Maths.getFmtValues(row9_F9,"num","####")%>
</TD>
<TD value="<%=row9_G9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="G9">
<%=Maths.getFmtValues(row9_G9,"num","####")%>
</TD>
<TD value="<%=row9_H9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="H9">
<%=Maths.getFmtValues(row9_H9,"num","####")%>
</TD>
<TD value="<%=row9_I9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="I9">
<%=Maths.getFmtValues(row9_I9,"num","####")%>
</TD>
<TD value="<%=row9_J9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="J9">
<%=Maths.getFmtValues(row9_J9,"num","####")%>
</TD>
<TD value="<%=row9_K9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="K9">
<%=Maths.getFmtValues(row9_K9,"num","####")%>
</TD>
<TD value="<%=row9_L9%>" id="L9">
<%=Maths.getFmtValues(row9_L9,"char","")%>
</TD>
</TR>
<%}//row9%>
<%}//row8%>
<TR style="HEIGHT: 22px">
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="A10">
合计:
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="B10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="C10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="D10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="E10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="F10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="G10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="H10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="I10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="J10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="K10">
</TD>
<TD style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="L10">
</TD>
</TR>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A11">
</TD>
<TD id="B11">
</TD>
<TD id="C11">
</TD>
<TD id="D11">
</TD>
<TD id="E11">
</TD>
<TD id="F11">
</TD>
<TD hideTxt="1" id="G11">
</TD>
<TD id="H11">
</TD>
<TD id="I11">
</TD>
<TD id="J11">
</TD>
<TD id="K11">
</TD>
<TD id="L11">
</TD>
</TR>
</TBODY>
</TABLE>
<DIV class="dsnInput" style="DISPLAY: none; POSITION: absolute; " contentEditable="true" id="grid_edt">
</DIV>
</DIV>
</FORM>
</BODY>
<%if(!ireq.isMedia(request)){%><print:webprint linkTable="maintb" pageSize="||selIndex=B4(JIS)||repWidth=257||repHeight=364||portrait=false||tabTop=25||tabBottom=10||tabLeft=20||tabRight=4.24||tabHead=1||tabCauda=0||topOffset=0||leftOffset=0||coverPrint=false||changeUserDate=true||compressWidth=0||compressHeight=0||compressFont=0||compressPrint=0||offsetAdjust=10||phead=||pfoot=||copies=1||" id="printgrid">
<iframe width="1" height="1" style="visibility:hidden;" src="/myblank.html">
</iframe>
</print:webprint><%}%>
</HTML>
<SCRIPT language='javascript'>
var tb_row_objs=new Array();//所有列表
var tb_row8=new Object();
tb_row8.nowtr=null;
tb_row8.tableID="row8";
tb_row8.dbrow=<%=row8_dbrow%>;
tb_row8.edttype="";
tb_row8.hidectrl=null;
tb_row_objs[tb_row_objs.length]=tb_row8;
var tb_row9=new Object();
tb_row9.nowtr=null;
tb_row9.tableID="row9";
tb_row9.dbrow=<%=row9_dbrow%>;
tb_row9.edttype="";
tb_row9.hidectrl=null;
tb_row_objs[tb_row_objs.length]=tb_row9;
</SCRIPT>
<SCRIPT language='javascript'>
var fm=document.brow;
var path=getParent();
setparenttool(this,'bgn');
function endpage(){
setparenttool(this,'end');
}
function bgnpage(){
pagestatus('normal');
if(path!=null){
path.normalstatus();
path.settoolStatus('editcell',true,'caneditcell()');
}
setdsntoolStatus(null);
}
function btnClick(obj){
if(typeof(obj.btnType)=='undefined') return;
if(typeof(obj.settool)=='undefined') obj.settool=1;
if(setAction(obj.btnType)&&1==obj.settool)setdsntoolStatus(obj);
}
function setAction(type){
if(type=='btnFind'){if(!submitCheck('find')) return false;mysubmit(fm);}
else if(type=='btnReset'){fm.reset();}
else if(type=='btnPrintWeb'){printReport(0);}
else if(type=='btnWindowClose'){if(getIsDlg()) window.close();else window.location='about:';}
else if(type=='btnPrintXls'){toXlsDsn();}
else if(type=='btnSaveHtm'){toHtmDsn();}
else if(type=='btnEdtCell'){caneditcell();}
else if(type=='btnHelp'){F1Help();}
else if(type=='btnFilt'){filtDsn();}
else if(type=='btnCols'){ctrlTbCols();}
return true;
}
function submitCheck(chktype){
if(!checkNulls(chktype)) return false;
if(!setlineAction(chktype)) return false; //only for line saveflag
return true;
}
</SCRIPT>
<SCRIPT language='javascript'>
function js(row,cell){
var hj=0;
for(var i=0;i<maintb.rows.length;i++){
if(maintb.rows(i).tableID!=''&&maintb.rows(i).tableID==row){
for(var j=0;j<maintb.rows(i).cells.length;j++){
if(maintb.rows(i).cells(j).id!=''&&maintb.rows(i).cells(j).id==cell){
hj=hj+(maintb.rows(i).cells(j).innerText*1)
}
}
}
}
return hj;
}
get('B10').innerText=js('row8','B8');
get('C10').innerText=js('row8','C8');
get('D10').innerText=js('row8','D8');
get('E10').innerText=js('row8','E8');
get('F10').innerText=js('row8','F8');
get('G10').innerText=js('row8','G8');
get('H10').innerText=js('row8','H8');
get('I10').innerText=js('row8','I8');
get('J10').innerText=js('row8','J8');
get('K10').innerText=js('row8','K8');
</SCRIPT>
//求表格的合计数据。
function js(row,cell){
var hj=0;
for(var i=0;i<maintb.rows.length;i++){
if(maintb.rows(i).tableID!=''&&maintb.rows(i).tableID==row){
for(var j=0;j<maintb.rows(i).cells.length;j++){
if(maintb.rows(i).cells(j).id!=''&&maintb.rows
(i).cells(j).id==cell){
hj=hj+(maintb.rows(i).cells(j).innerText*1)
}
}
}
}
return hj;
}
get('B10').innerText=js('row8','B8');
get('C10').innerText=js('row8','C8');
get('D10').innerText=js('row8','D8');
get('E10').innerText=js('row8','E8');
get('F10').innerText=js('row8','F8');
get('G10').innerText=js('row8','G8');
get('H10').innerText=js('row8','H8');
get('I10').innerText=js('row8','I8');
get('J10').innerText=js('row8','J8');
get('K10').innerText=js('row8','K8');
参照jsp页面看maintb和表格行：
<!--buldtype=class:0-->
<%@ page contentType="text/html; charset=GB2312" %>
<META http-equiv="content-type" content="text/html; charset=gb2312">
<META http-equiv="pragma" content="no-cache">
<META http-equiv="Cache-Control" content="no-cache">
<META NAME="Generator" CONTENT="websync平台">
<%@ page import="java.util.*" %>
<%@ page import="com.web.*" %>
<%@ page import="com.obj.*" %>
<%@ page import="com.pub.*" %>
<%@ page import="com.dataset.SResultSetEx" %>
<%session.setAttribute("s_fileIDString","zjgc/zscsg/jd/rpt/cycdt.xml");%>
<%@include file="/app/arc/arc_oversession.jsp"%>
<%SResultSetEx rs =new SResultSetEx("source-user",request.getServerPort());%>
<%String sql=""; %>
<HTML xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:print xmlns:v="urn:schemas-microsoft-com:vml">
<HEAD>
<LINK href="/app/app.css" type="text/css" rel="stylesheet" id="app">
<SCRIPT src="/app/js/common.js" language="JScript.encode"></SCRIPT>
<SCRIPT src="/app/js/input.js" language="JScript.encode"></SCRIPT>
<SCRIPT src="/app/js/myapp.js" language="JScript.encode"></SCRIPT>
<TITLE>采油厂、地区生产动态表</TITLE>
<SCRIPT src="/app/js/tool.js" language="JScript.encode"></SCRIPT>
<%
//package userdsn.zjgc.zscsg.jd.rpt
class CycdtHandler extends Handler{
private static final String JNDI_NAME = "cycdt";
public Ireq performTask(HttpServletRequest request){
Ireq ireq=new Ireq();
String port=String.valueOf(request.getServerPort());
ireq.setArc((Arc)request.getAttribute("arc"));
String m_addedtdel=(String)request.getAttribute("m_addedtdel");
Arc arc =ireq.getArc();
String _A3_B1=ireq.rsetValue("_A3_B1",request,CommonEx.f_today());
String _A3_D1=ireq.rsetValue("_A3_D1",request,"1");
String q_row8_order=ireq.rsetValue("q_row8_order",request,"");
String q_row8_order_old=ireq.rsetValue("q_row8_order_old",request,"");
String q_row8_pageno=ireq.rsetValue("q_row8_pageno",request,"0");
String q_row8_pagerows=ireq.rsetValue("q_row8_pagerows",request,"1");
String q_row9_order=ireq.rsetValue("q_row9_order",request,"");
String q_row9_order_old=ireq.rsetValue("q_row9_order_old",request,"");
String q_row9_pageno=ireq.rsetValue("q_row9_pageno",request,"0");
String q_row9_pagerows=ireq.rsetValue("q_row9_pagerows",request,"1");
String q_rows_idx=ireq.rsetValue("q_rows_idx",request,"");
if(!m_addedtdel.equals(Arc.SEARCH)){
}
if(!m_addedtdel.equals(Arc.SEARCH)){
ireq=save(ireq,port,m_addedtdel);
}
ireq=search(ireq,port);
return ireq;
}
//}//public class CycdtEJB extends SessionEJB {
public Ireq befsearch(Ireq ireq,String port){//获得属性函数参数值
return ireq;
}
public Ireq search(Ireq ireq,String port){
SResultSetEx rs =new SResultSetEx("source-user",port);
Arc arc =ireq.getArc();
String savetype=ireq.getSaveCode();
String sql="";
String _A3_B1=ireq.getValue("_A3_B1");
String _A3_D1=ireq.getValue("_A3_D1");
String q_row8_order=ireq.getValue("q_row8_order");
String q_row8_order_old=ireq.getValue("q_row8_order_old");
String q_row8_pageno=ireq.getValue("q_row8_pageno");
String q_row8_pagerows=ireq.getValue("q_row8_pagerows");
String q_row9_order=ireq.getValue("q_row9_order");
String q_row9_order_old=ireq.getValue("q_row9_order_old");
String q_row9_pageno=ireq.getValue("q_row9_pageno");
String q_row9_pagerows=ireq.getValue("q_row9_pagerows");
String q_rows_idx=ireq.getValue("q_rows_idx");
sql ="SELECT 1 ,A.bc_mc AS a_bc_mc_1,A.id AS a_id_1";
sql+=" FROM bbz_glzxsj A";
sql+=" WHERE 1=1 ";
rs.executeQuery(sql);
Table list_A3_D1=ireq.setTable("list_A3_D1",rs.getTable());
String $bbz_glzxsja_bc_mc_1=rs.getFieldValue(0,"a_bc_mc_1");
String $bbz_glzxsja_id_1=rs.getFieldValue(0,"a_id_1");
sql ="SELECT 1 ,SUM(A.bnjj+A.qnjj) AS bqnjj_1,SUM(A.brzjs) AS a_brzjs_1,SUM(A.bnjj) AS a_bnjj_1,A.ssjf_mc AS a_ssjf_mc_1,SUM(A.bnjc) AS a_bnjc_1,SUM(A.byjc) AS a_byjc_1,SUM(A.bykz) AS a_bykz_1,SUM(A.qnjj) AS a_qnjj_1,SUM(A.bnkz) AS a_bnkz_1,SUM(A.brjc) AS a_brjc_1,SUM(A.byjj) AS a_byjj_1";
sql+=" FROM vzsc_v_sgrbbc A";
sql+=" WHERE 1=1 ";
sql+=" AND A.bc_rq='"+_A3_B1+"' AND ('"+_A3_D1+"'='' OR A.id_glzxsj='"+_A3_D1+"') AND (1=1 OR A.scfl_mc='')";
sql+=" GROUP BY A.scfl_mc,A.ssjf_bm,A.ssjf_mc";
sql+=" ORDER BY ";
if(!q_row8_order.trim().equals("")) sql+=q_row8_order;
else sql+="A.ssjf_bm asc,case when scfl_mc like '%关联%' then 1 when scfl_mc like '%本%' then 2 else 3 end asc";
rs.executeQuery(sql,q_row8_pageno,q_row8_pagerows);
Table row8=ireq.setTable("row8",rs.getTable());
String vzscsg_jdbccycbqnjj_1=rs.getFieldValue(0,"bqnjj_1");
String vzscsg_jdbccyca_brzjs_1=rs.getFieldValue(0,"a_brzjs_1");
String vzscsg_jdbccyca_bnjj_1=rs.getFieldValue(0,"a_bnjj_1");
String vzscsg_jdbccyca_ssjf_mc_1=rs.getFieldValue(0,"a_ssjf_mc_1");
String vzscsg_jdbccyca_bnjc_1=rs.getFieldValue(0,"a_bnjc_1");
String vzscsg_jdbccyca_byjc_1=rs.getFieldValue(0,"a_byjc_1");
String vzscsg_jdbccyca_bykz_1=rs.getFieldValue(0,"a_bykz_1");
String vzscsg_jdbccyca_qnjj_1=rs.getFieldValue(0,"a_qnjj_1");
String vzscsg_jdbccyca_bnkz_1=rs.getFieldValue(0,"a_bnkz_1");
String vzscsg_jdbccyca_brjc_1=rs.getFieldValue(0,"a_brjc_1");
String vzscsg_jdbccyca_byjj_1=rs.getFieldValue(0,"a_byjj_1");
sql ="SELECT 1 ,SUM(A.bnjj+A.qnjj) AS bqnjj_1,SUM(A.brzjs) AS a_brzjs_1,SUM(A.bnjj) AS a_bnjj_1,SUM(A.bnjc) AS a_bnjc_1,SUM(A.byjc) AS a_byjc_1,A.ssjf_mc AS row9_cyc,SUM(A.bykz) AS a_bykz_1,SUM(A.qnjj) AS a_qnjj_1,SUM(A.bnkz) AS a_bnkz_1,SUM(A.brjc) AS a_brjc_1,SUM(A.byjj) AS a_byjj_1,A.qk_mc AS a_qk_mc_1";
sql+=" FROM vzsc_v_sgrbbc A";
sql+=" WHERE 1=1 ";
sql+=" AND A.bc_rq='"+_A3_B1+"' AND ('"+_A3_D1+"'='' OR A.id_glzxsj='"+_A3_D1+"') AND (1=1 OR A.scfl_mc='')";
String L9_in="";///条件替换L9 in(L8) row8.getFieldValue(i,"a_ssjf_mc_1")
for(int i=0;i<row8.getRow();i++){
L9_in+=",'"+row8.getFieldValue(i,"a_ssjf_mc_1")+"'";
}
if(L9_in.startsWith(",")) L9_in=L9_in.substring(1);
sql+=" AND (A.ssjf_mc in ("+L9_in+"))";
sql+=" GROUP BY A.qk_mc,A.scfl_mc,A.ssjf_mc";
if(!q_row9_order.equals("")) sql+=" ORDER BY "+q_row9_order;
rs.executeQuery(sql,q_row9_pageno,q_row9_pagerows);
Table row9=ireq.setTable("row9",rs.getTable());
String vzscsg_jdbcqkbqnjj_1=rs.getFieldValue(0,"bqnjj_1");
String vzscsg_jdbcqka_brzjs_1=rs.getFieldValue(0,"a_brzjs_1");
String vzscsg_jdbcqka_bnjj_1=rs.getFieldValue(0,"a_bnjj_1");
String vzscsg_jdbcqka_bnjc_1=rs.getFieldValue(0,"a_bnjc_1");
String vzscsg_jdbcqka_byjc_1=rs.getFieldValue(0,"a_byjc_1");
String vzscsg_jdbcqkrow9_cyc=rs.getFieldValue(0,"row9_cyc");
String vzscsg_jdbcqka_bykz_1=rs.getFieldValue(0,"a_bykz_1");
String vzscsg_jdbcqka_qnjj_1=rs.getFieldValue(0,"a_qnjj_1");
String vzscsg_jdbcqka_bnkz_1=rs.getFieldValue(0,"a_bnkz_1");
String vzscsg_jdbcqka_brjc_1=rs.getFieldValue(0,"a_brjc_1");
String vzscsg_jdbcqka_byjj_1=rs.getFieldValue(0,"a_byjj_1");
String vzscsg_jdbcqka_qk_mc_1=rs.getFieldValue(0,"a_qk_mc_1");
ireq.setMathValue("_A3_B1","{@}"+_A3_B1);
ireq.setMathValue("_A3_D1","{@}"+_A3_D1);
ireq.setMathValue("A8","{@}"+vzscsg_jdbccyca_ssjf_mc_1+"(小计)");
ireq.setMathValue("B8","{@}"+vzscsg_jdbccyca_brzjs_1);
ireq.setMathValue("C8","{@}"+vzscsg_jdbccyca_bykz_1);
ireq.setMathValue("D8","{@}"+vzscsg_jdbccyca_bnkz_1);
ireq.setMathValue("E8","{@}"+vzscsg_jdbccyca_byjj_1);
ireq.setMathValue("F8","{@}"+vzscsg_jdbccycbqnjj_1);
ireq.setMathValue("G8","{@}"+vzscsg_jdbccyca_bnjj_1);
ireq.setMathValue("H8","{@}"+vzscsg_jdbccyca_qnjj_1);
ireq.setMathValue("I8","{@}"+vzscsg_jdbccyca_brjc_1);
ireq.setMathValue("J8","{@}"+vzscsg_jdbccyca_byjc_1);
ireq.setMathValue("K8","{@}"+vzscsg_jdbccyca_bnjc_1);
ireq.setMathValue("L8","{@}"+vzscsg_jdbccyca_ssjf_mc_1);
ireq.setMathValue("A9","{@}"+vzscsg_jdbcqka_qk_mc_1);
ireq.setMathValue("B9","{@}"+vzscsg_jdbcqka_brzjs_1);
ireq.setMathValue("C9","{@}"+vzscsg_jdbcqka_bykz_1);
ireq.setMathValue("D9","{@}"+vzscsg_jdbcqka_bnkz_1);
ireq.setMathValue("E9","{@}"+vzscsg_jdbcqka_byjj_1);
ireq.setMathValue("F9","{@}"+vzscsg_jdbcqkbqnjj_1);
ireq.setMathValue("G9","{@}"+vzscsg_jdbcqka_bnjj_1);
ireq.setMathValue("H9","{@}"+vzscsg_jdbcqka_qnjj_1);
ireq.setMathValue("I9","{@}"+vzscsg_jdbcqka_brjc_1);
ireq.setMathValue("J9","{@}"+vzscsg_jdbcqka_byjc_1);
ireq.setMathValue("K9","{@}"+vzscsg_jdbcqka_bnjc_1);
ireq.setMathValue("L9","{@}"+vzscsg_jdbcqkrow9_cyc);
return ireq;
}
public Ireq save(Ireq ireq,String port, String m_addedtdel){
SResultSetEx rs =new SResultSetEx("source-user",port);
Arc arc =ireq.getArc();
String sql="";
String _A3_B1=ireq.getValue("_A3_B1");//日期
String _A3_D1=ireq.getValue("_A3_D1");//班次
//查询变量String ;_A3_B1;_A3_D1;
return ireq;
}
}
%><%
String m_addedtdel=Arc.getAddedtdelx(request,"zjgcvzscsgvjdvrptvcycdt");
if(m_addedtdel.equals(Arc.XLS)){
response.setContentType("application/vnd.ms-excel;charset=gb2312");
m_addedtdel=Arc.SEARCH;
}
request.setAttribute("arc",session.getAttribute("arc"));
request.setAttribute("m_addedtdel",m_addedtdel);
Ireq ireq=new CycdtHandler().performTask(request);
String _A3_B1=ireq.getValue("_A3_B1");
String _A3_D1=ireq.getValue("_A3_D1");
String q_row8_order=ireq.getValue("q_row8_order");
String q_row8_order_old=ireq.getValue("q_row8_order_old");
String q_row8_pageno=ireq.getValue("q_row8_pageno");
String q_row8_pagerows=ireq.getValue("q_row8_pagerows");
String q_row9_order=ireq.getValue("q_row9_order");
String q_row9_order_old=ireq.getValue("q_row9_order_old");
String q_row9_pageno=ireq.getValue("q_row9_pageno");
String q_row9_pagerows=ireq.getValue("q_row9_pagerows");
String q_rows_idx=ireq.getValue("q_rows_idx");
String savetype=ireq.getSaveCode();
if(!savetype.equals(Arc.SEARCH)){
%><script>alert("<%=ireq.getSaveMsg()%>")</script><%
}
Table row8=ireq.getTable("row8");
int q_row8_pagecount=row8.getPageCount();
int row8_pageno=row8.getCurPage();
int row8_dbrow= row8.getRow();
int row8_pagerows= Integer.parseInt(q_row8_pagerows);
if(!q_row8_pageno.equals("0")) q_row8_pageno=String.valueOf(row8_pageno);
row8_pagerows=row8_pagerows<row8_dbrow?row8_dbrow:row8_pagerows;
Table list_A3_D1=ireq.getTable("list_A3_D1");
Table row9=ireq.getTable("row9");
int q_row9_pagecount=row9.getPageCount();
int row9_pageno=row9.getCurPage();
int row9_dbrow= row9.getRow();
int row9_pagerows= Integer.parseInt(q_row9_pagerows);
if(!q_row9_pageno.equals("0")) q_row9_pageno=String.valueOf(row9_pageno);
row9_pagerows=row9_pagerows<row9_dbrow?row9_dbrow:row9_pagerows;
Maths math=ireq.getMath();
out.println(math.printErro("id_math_erro"));
String L9_in=math.getExpValue("L9_IN");
out.print(ireq.getPrint());
%>
<script>var savetype="<%=savetype%>";</script>
</HEAD>
<BODY fileType="lstrpt" class="BodyWhiteStyle" onhelp="F1Help();" onunload="endpage()" onload="bgnpage()" fileEngName="zjgc/zscsg/jd/rpt/cycdt.xml" scroll="no" onkeydown="return keypressdown()" outputfile="/app/userfile/zjgc/zscsg/jd/rpt/cycdt_print.jsp">
<FORM name="brow" method="post" id="brow">
<%if(!ireq.isMedia(request)){%><DIV style="display:none" id="para_div">
<INPUT value="<%=session.getAttribute("m_synIDzjgcvzscsgvjdvrptvcycdt")%>" type="hidden" name="m_clientsynID">
<INPUT value="0" type="hidden" name="m_addedtdel">
<INPUT value="<%=q_row8_order%>" type="hidden" name="q_row8_order">
<INPUT value="<%=q_row8_order_old%>" type="hidden" name="q_row8_order_old">
<INPUT value="<%=q_row8_pageno%>" type="hidden" name="q_row8_pageno">
<INPUT value="<%=q_row8_pagerows%>" type="hidden" name="q_row8_pagerows">
<INPUT value="<%=q_row8_pagecount%>" type="hidden" name="q_row8_pagecount">
<INPUT value="<%=q_row9_order%>" type="hidden" name="q_row9_order">
<INPUT value="<%=q_row9_order_old%>" type="hidden" name="q_row9_order_old">
<INPUT value="<%=q_row9_pageno%>" type="hidden" name="q_row9_pageno">
<INPUT value="<%=q_row9_pagerows%>" type="hidden" name="q_row9_pagerows">
<INPUT value="<%=q_row9_pagecount%>" type="hidden" name="q_row9_pagecount">
<INPUT value="<%=q_rows_idx%>" type="hidden" name="q_rows_idx">
</DIV><%}%>
<DIV style="WIDTH: 100%; HEIGHT: 100%;POSITION:absolute;OVERFLOW:auto;TOP:0;LEFT:0;" id="maindv">
<TABLE cellPadding="0" ondblclick="editCell(this)" style="TABLE-LAYOUT:fixed" border="0" cellSpacing="0" id="maintb">
<COLGROUP>
<COL style="WIDTH: 130px" id="maintb_A">
<COL style="WIDTH: 91px" id="maintb_B">
<COL style="WIDTH: 72px" id="maintb_C">
<COL style="WIDTH: 72px" id="maintb_D">
<COL style="WIDTH: 69px" id="maintb_E">
<COL style="WIDTH: 92px" id="maintb_F">
<COL style="WIDTH: 100px" id="maintb_G">
<COL style="WIDTH: 104px" id="maintb_H">
<COL style="WIDTH: 97px" id="maintb_I">
<COL style="WIDTH: 97px" id="maintb_J">
<COL style="WIDTH: 75px" id="maintb_K">
<COL style="WIDTH: 75px;display:none;" id="maintb_L">
</COLGROUP>
<TBODY>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A1">
</TD>
<TD id="B1">
</TD>
<TD id="C1">
</TD>
<TD id="D1">
</TD>
<TD id="E1">
</TD>
<TD id="F1">
</TD>
<TD id="G1">
</TD>
<TD id="H1">
</TD>
<TD id="I1">
</TD>
<TD id="J1">
</TD>
<TD id="K1">
</TD>
<TD id="L1">
</TD>
</TR>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A2">
</TD>
<TD id="B2">
</TD>
<TD id="C2">
</TD>
<TD id="D2">
</TD>
<TD id="E2">
</TD>
<TD id="F2">
</TD>
<TD id="G2">
</TD>
<TD id="H2">
</TD>
<TD id="I2">
</TD>
<TD id="J2">
</TD>
<TD id="K2">
</TD>
<TD id="L2">
</TD>
</TR>
<TR style="HEIGHT:25">
<TD class="TdTool" colSpan="11" style="VERTICAL-ALIGN: top; TEXT-ALIGN: left" id="A3">
<DIV style="TOP:0;LEFT:0;WIDTH:100%;HEIGHT:100%;" id="A3_div">
<TABLE cellPadding="0" style="TABLE-LAYOUT:fixed" border="0" cellSpacing="0" id="A3_tb">
<COLGROUP>
<COL style="WIDTH: 59px" id="A3_A">
<COL style="WIDTH: 91px" id="A3_B">
<COL style="WIDTH: 43px" id="A3_C">
<COL style="WIDTH: 80px" id="A3_D">
<COL style="WIDTH: 37px" id="A3_E">
<COL style="WIDTH: 58px" id="A3_F">
<COL style="WIDTH: 100px" id="A3_G">
<COL style="WIDTH: 58px" id="A3_H">
<COL style="WIDTH: 97px" id="A3_I">
</COLGROUP>
<TBODY>
<TR style="HEIGHT: 25px">
<TD class="TdTool" style="TEXT-ALIGN: right" id="A3_A1">
日期
</TD>
<TD class="TdTool" id="A3_B1">
<INPUT chsName="日期" isSerchCtrl="1" maxLength="10" value="<%=_A3_B1%>" dataType="date" ondblclick="getDate(this,false)" style="WIDTH: 81px; HEIGHT: 20px;ime-mode:disabled;" onkeydown="keydown(this)" name="_A3_B1" onblur="inputblur(this)">
</TD>
<TD class="TdTool" style="TEXT-ALIGN: right" id="A3_C1">
班次
</TD>
<TD class="TdTool" id="A3_D1">
<SELECT chsName="班次" isSerchCtrl="1" tableID="list_A3_D1" style="WIDTH: 70px; HEIGHT: 20px" initVal="<%="1"%>" name="_A3_D1">
<%for(int j=0;j<list_A3_D1.getRow();j++){%>
<OPTION <%=_A3_D1.equals(list_A3_D1.getFieldValue(j,"a_id_1"))?"selected":""%> value="<%=list_A3_D1.getFieldValue(j,"a_id_1")%>"><%=list_A3_D1.getFieldValue(j,"a_bc_mc_1")%></OPTION>
<%}%>
</SELECT>
</TD>
<TD class="TdTool" id="A3_E1">
</TD>
<TD class="TdTool" id="A3_F1">
<INPUT value="查询" btnType="btnFind" title="查询" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_F1" settool="0" onmouseup="this.className='ButtonNow'" style="WIDTH: 50px; HEIGHT: 20px" onmouseover="this.className='ButtonOn'">
</TD>
<TD class="TdTool" id="A3_G1">
</TD>
<TD class="TdTool" id="A3_H1">
<INPUT value="打印" btnType="btnPrintWeb" title="打印" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_H1" settool="0" onmouseup="this.className='ButtonNow'" style="WIDTH: 50px; HEIGHT: 20px" onmouseover="this.className='ButtonOn'">
</TD>
<TD class="TdTool" style="WIDTH: 60px" id="A3_I1">
<INPUT value="任意编辑" btnType="btnEdtCell" title="任意编辑" type="button" class="ButtonNow" onclick="btnClick(this)" onmouseout="this.className='ButtonNow'" id="_A3_I1" style="WIDTH: 70px; HEIGHT: 20px" onmouseup="this.className='ButtonNow'" onmouseover="this.className='ButtonOn'">
</TD>
</TR>
</TBODY>
</TABLE>
</DIV>
</TD>
<TD class="TdFilt" id="L3">
</TD>
</TR>
<TR style="HEIGHT: 10px">
<TD id="A4">
</TD>
<TD id="B4">
</TD>
<TD colSpan="2" id="C4">
</TD>
<TD colSpan="4" id="E4">
</TD>
<TD colSpan="3" id="I4">
</TD>
<TD id="L4">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadT" rowSpan="3" style="TEXT-ALIGN: center" id="A5">
采油厂、区块
</TD>
<TD class="TdFiltHeadT" rowSpan="3" style="TEXT-ALIGN: center" id="B5">
动用钻机<BR>（台）
</TD>
<TD class="TdFiltHeadT" colSpan="2" style="TEXT-ALIGN: center" id="C5">
开钻（口）
</TD>
<TD class="TdFiltHeadT" colSpan="4" style="TEXT-ALIGN: center" id="E5">
交井（口）
</TD>
<TD class="TdFiltHeadT" colSpan="3" style="TEXT-ALIGN: center" id="I5">
进尺（米）
</TD>
<TD id="L5">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="C6">
本月
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="D6">
年累计
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="E6">
本月
</TD>
<TD class="TdFiltHeadTnU" colSpan="3" style="TEXT-ALIGN: center" id="F6">
年累计
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="I6">
日进尺
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="J6">
本月
</TD>
<TD class="TdFiltHeadTnU" rowSpan="2" style="TEXT-ALIGN: center" id="K6">
年累计
</TD>
<TD id="L6">
</TD>
</TR>
<TR style="HEIGHT: 22px">
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="F7">
合计
</TD>
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="G7">
今年
</TD>
<TD class="TdFiltHeadTnU" style="TEXT-ALIGN: center" id="H7">
去年
</TD>
<TD class="TdFiltHeadTnU" id="I7">
</TD>
</TR>
<%
for(int row8_i=0;row8_i<row8_pagerows;row8_i++){//row8
String row8_A8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_ssjf_mc_1")+"(小计)");
String row8_B8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_brzjs_1"));
String row8_C8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bykz_1"));
String row8_D8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnkz_1"));
String row8_E8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_byjj_1"));
String row8_F8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"bqnjj_1"));
String row8_G8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnjj_1"));
String row8_H8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_qnjj_1"));
String row8_I8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_brjc_1"));
String row8_J8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_byjc_1"));
String row8_K8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_bnjc_1"));
String row8_L8=(row8_i>=row8_dbrow)?"":(row8.getFieldValue(row8_i,"a_ssjf_mc_1"));
%>
<TR <%=(row8_i<row8_dbrow)?"onmousedown=\"downRow(this);\" ondblclick=\"dblclickrow(this);;\"":""%> tableID="row8" selbgColor="#9CF9F9" style="HEIGHT: 22px" selTrClass="TrCurRow" id="row8" isTrListgroup="1" gridFillType="GOON">
<TD value="<%=row8_A8%>" class="TdCell" style="BACKGROUND-COLOR: #c4df9b" id="A8">
<%=Maths.getFmtValues(row8_A8,"char","")%>
</TD>
<TD value="<%=row8_B8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="B8">
<%=Maths.getFmtValues(row8_B8,"num","####")%>
</TD>
<TD value="<%=row8_C8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="C8">
<%=Maths.getFmtValues(row8_C8,"num","####")%>
</TD>
<TD value="<%=row8_D8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="D8">
<%=Maths.getFmtValues(row8_D8,"num","####")%>
</TD>
<TD value="<%=row8_E8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="E8">
<%=Maths.getFmtValues(row8_E8,"num","####")%>
</TD>
<TD value="<%=row8_F8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="F8">
<%=Maths.getFmtValues(row8_F8,"num","####")%>
</TD>
<TD value="<%=row8_G8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="G8">
<%=Maths.getFmtValues(row8_G8,"num","####")%>
</TD>
<TD value="<%=row8_H8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="H8">
<%=Maths.getFmtValues(row8_H8,"num","####")%>
</TD>
<TD value="<%=row8_I8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="I8">
<%=Maths.getFmtValues(row8_I8,"num","####")%>
</TD>
<TD value="<%=row8_J8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="J8">
<%=Maths.getFmtValues(row8_J8,"num","####")%>
</TD>
<TD value="<%=row8_K8%>" dataType="num" class="TdCell" style="BACKGROUND-COLOR: #c4df9b; TEXT-ALIGN: center" id="K8">
<%=Maths.getFmtValues(row8_K8,"num","####")%>
</TD>
<TD value="<%=row8_L8%>" style="BACKGROUND-COLOR: #c4df9b" id="L8">
<%=Maths.getFmtValues(row8_L8,"char","")%>
</TD>
</TR>
<%row9.resetFilt();
for(int row9_i=0;row9_i<row9.getRow(); row9_i++){
if(!row8_L8.equals(row9.getFieldValue(row9_i,"row9_cyc")))continue;
row9.selFiltValue(row9_i);
}
row9.applyFilt();
row9_dbrow=row9.getRow();
row9_pagerows=Integer.parseInt(q_row9_pagerows);
row9_pagerows=row9_pagerows<row9_dbrow?row9_dbrow:row9_pagerows;%>
<%for(int row9_i=0;row9_i<row9_pagerows;row9_i++){//row9
String row9_cyc=row9.getFieldValue(row9_i,"row9_cyc");String row9_CYC=row9_cyc;
String row9_A9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_qk_mc_1"));
String row9_B9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_brzjs_1"));
String row9_C9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bykz_1"));
String row9_D9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnkz_1"));
String row9_E9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_byjj_1"));
String row9_F9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"bqnjj_1"));
String row9_G9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnjj_1"));
String row9_H9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_qnjj_1"));
String row9_I9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_brjc_1"));
String row9_J9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_byjc_1"));
String row9_K9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"a_bnjc_1"));
String row9_L9=(row9_i>=row9_dbrow)?"":(row9.getFieldValue(row9_i,"row9_cyc"));
%>
<TR tableID="row9" cyc="<%=row9_cyc%>" id="row9" isTrListgroup="1" <%=(row9_i<row9_dbrow)?"onmousedown=\"downRow(this);\" ondblclick=\"dblclickrow(this);;\"":""%> pnames="cyc" selbgColor="#9CF9F9" style="HEIGHT: 22px" selTrClass="TrCurRow" gridFillType="GOON">
<TD value="<%=row9_A9%>" dent="10" class="TdCell" style="PADDING-LEFT: 10px; TEXT-ALIGN: left" id="A9">
<%=Maths.getFmtValues(row9_A9,"char","")%>
</TD>
<TD value="<%=row9_B9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="B9">
<%=Maths.getFmtValues(row9_B9,"num","####")%>
</TD>
<TD value="<%=row9_C9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="C9">
<%=Maths.getFmtValues(row9_C9,"num","####")%>
</TD>
<TD value="<%=row9_D9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="D9">
<%=Maths.getFmtValues(row9_D9,"num","####")%>
</TD>
<TD value="<%=row9_E9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="E9">
<%=Maths.getFmtValues(row9_E9,"num","####")%>
</TD>
<TD value="<%=row9_F9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="F9">
<%=Maths.getFmtValues(row9_F9,"num","####")%>
</TD>
<TD value="<%=row9_G9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="G9">
<%=Maths.getFmtValues(row9_G9,"num","####")%>
</TD>
<TD value="<%=row9_H9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="H9">
<%=Maths.getFmtValues(row9_H9,"num","####")%>
</TD>
<TD value="<%=row9_I9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="I9">
<%=Maths.getFmtValues(row9_I9,"num","####")%>
</TD>
<TD value="<%=row9_J9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="J9">
<%=Maths.getFmtValues(row9_J9,"num","####")%>
</TD>
<TD value="<%=row9_K9%>" dataType="num" class="TdCell" style="TEXT-ALIGN: center" id="K9">
<%=Maths.getFmtValues(row9_K9,"num","####")%>
</TD>
<TD value="<%=row9_L9%>" id="L9">
<%=Maths.getFmtValues(row9_L9,"char","")%>
</TD>
</TR>
<%}//row9%>
<%}//row8%>
<TR style="HEIGHT: 22px">
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="A10">
合计:
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="B10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="C10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="D10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="E10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="F10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="G10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="H10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="I10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="J10">
</TD>
<TD class="TdCell" style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="K10">
</TD>
<TD style="FONT-WEIGHT: bolder; TEXT-ALIGN: center" id="L10">
</TD>
</TR>
<TR isDisplay="0" style="HEIGHT: 22px;display:none;">
<TD id="A11">
</TD>
<TD id="B11">
</TD>
<TD id="C11">
</TD>
<TD id="D11">
</TD>
<TD id="E11">
</TD>
<TD id="F11">
</TD>
<TD hideTxt="1" id="G11">
</TD>
<TD id="H11">
</TD>
<TD id="I11">
</TD>
<TD id="J11">
</TD>
<TD id="K11">
</TD>
<TD id="L11">
</TD>
</TR>
</TBODY>
</TABLE>
<DIV class="dsnInput" style="DISPLAY: none; POSITION: absolute; " contentEditable="true" id="grid_edt">
</DIV>
</DIV>
</FORM>
</BODY>
<%if(!ireq.isMedia(request)){%><print:webprint linkTable="maintb" pageSize="||selIndex=B4(JIS)||repWidth=257||repHeight=364||portrait=false||tabTop=25||tabBottom=10||tabLeft=20||tabRight=4.24||tabHead=1||tabCauda=0||topOffset=0||leftOffset=0||coverPrint=false||changeUserDate=true||compressWidth=0||compressHeight=0||compressFont=0||compressPrint=0||offsetAdjust=10||phead=||pfoot=||copies=1||" id="printgrid">
<iframe width="1" height="1" style="visibility:hidden;" src="/myblank.html">
</iframe>
</print:webprint><%}%>
</HTML>
<SCRIPT language='javascript'>
var tb_row_objs=new Array();//所有列表
var tb_row8=new Object();
tb_row8.nowtr=null;
tb_row8.tableID="row8";
tb_row8.dbrow=<%=row8_dbrow%>;
tb_row8.edttype="";
tb_row8.hidectrl=null;
tb_row_objs[tb_row_objs.length]=tb_row8;
var tb_row9=new Object();
tb_row9.nowtr=null;
tb_row9.tableID="row9";
tb_row9.dbrow=<%=row9_dbrow%>;
tb_row9.edttype="";
tb_row9.hidectrl=null;
tb_row_objs[tb_row_objs.length]=tb_row9;
</SCRIPT>
<SCRIPT language='javascript'>
var fm=document.brow;
var path=getParent();
setparenttool(this,'bgn');
function endpage(){
setparenttool(this,'end');
}
function bgnpage(){
pagestatus('normal');
if(path!=null){
path.normalstatus();
path.settoolStatus('editcell',true,'caneditcell()');
}
setdsntoolStatus(null);
}
function btnClick(obj){
if(typeof(obj.btnType)=='undefined') return;
if(typeof(obj.settool)=='undefined') obj.settool=1;
if(setAction(obj.btnType)&&1==obj.settool)setdsntoolStatus(obj);
}
function setAction(type){
if(type=='btnFind'){if(!submitCheck('find')) return false;mysubmit(fm);}
else if(type=='btnReset'){fm.reset();}
else if(type=='btnPrintWeb'){printReport(0);}
else if(type=='btnWindowClose'){if(getIsDlg()) window.close();else window.location='about:';}
else if(type=='btnPrintXls'){toXlsDsn();}
else if(type=='btnSaveHtm'){toHtmDsn();}
else if(type=='btnEdtCell'){caneditcell();}
else if(type=='btnHelp'){F1Help();}
else if(type=='btnFilt'){filtDsn();}
else if(type=='btnCols'){ctrlTbCols();}
return true;
}
function submitCheck(chktype){
if(!checkNulls(chktype)) return false;
if(!setlineAction(chktype)) return false; //only for line saveflag
return true;
}
</SCRIPT>
<SCRIPT language='javascript'>
function js(row,cell){
var hj=0;
for(var i=0;i<maintb.rows.length;i++){
if(maintb.rows(i).tableID!=''&&maintb.rows(i).tableID==row){
for(var j=0;j<maintb.rows(i).cells.length;j++){
if(maintb.rows(i).cells(j).id!=''&&maintb.rows(i).cells(j).id==cell){
hj=hj+(maintb.rows(i).cells(j).innerText*1)
}
}
}
}
return hj;
}
get('B10').innerText=js('row8','B8');
get('C10').innerText=js('row8','C8');
get('D10').innerText=js('row8','D8');
get('E10').innerText=js('row8','E8');
get('F10').innerText=js('row8','F8');
get('G10').innerText=js('row8','G8');
get('H10').innerText=js('row8','H8');
get('I10').innerText=js('row8','I8');
get('J10').innerText=js('row8','J8');
get('K10').innerText=js('row8','K8');
</SCRIPT>
分享到：
发表评论
相关推荐
使用 Bootstrap-table表格进行分页，表格汇总统计，方便我们做报表
绝对可以的，java生成excel报表 行和列
滴答表格控件做报表,无需编写代码 继绑定测试版本发布后,滴答3.8.2正式版本增强控件稳定性,优化控件速度,修正绑定模块的BUG;同时在设计器中添加了绑定模块的实例,从而让用户方便的设计报表模板,而无需再编写代码;...
主要为大家详细介绍了jqGrid表格底部汇总、合计行footerrow处理，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
滴答表格控件做报表,无需编写代码 继绑定测试版本发布后,滴答3.8.2正式版本增强控件稳定性,优化控件速度,修正绑定模块的BUG;同时在设计器中添加了绑定模块的实例,从而让用户方便的设计报表模板,而无需再编写代码;...
Ver2.45.407 重大功能完善： 1.当计算公式出错导致生成报表...10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档
最新2022年1季度-沪深A股所有上市公司2010年-2022年1季度共12年的财务报表——利润表，含4700多个股票报表数据，包含每个公司公布的各季度、年度数据，数据汇总到一张EXCEL表，包含主要的利润表科目，报表合计16万行...
Anycell Report(简称AC Report)是一款中国式报表组件，是国内最早的基于表格，支持图文混排、公式和脚本的中国式报表工具之一。就如Anycell Report的名称那样，灵活强大的表格功能一直是AC Report区别于其它软件或...
沪深A股所有上市公司2000年-2020年3月末20年的财务报表——资产负债表，共4486个股票报表数据，包含每个公司公布的各季度、年度数据，数据汇总到一张EXCEL表，有资产、负债、权益科目130多项，报表合计22万4千行，供...
2.6主要变动: ...10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档 12.支持自定义字间距和行间距设置
10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档 2.4主要变动： 1.可拖动对象功能增强（现在AC不仅可以支持...
开放了部分源码AC Report是一套功能强大、基于表格的中国式报表组件，同时也是一款中文化程度最高、最终用户最易学习的报表组件，操作简单方便、计算功能强大、容易与程序集成及易于扩充，是迄今为止国产最完美的...
5、报表数据来源丰富：支持绑定(报表数据拉模式)与非绑定(报表数据推模式)，一切数据库数据与其它数据都可以作为报表数据源。 6、提供图表功能，包括：饼图、叠加饼图、柱状图、气泡图、折线图、曲线图、散列点图等...
本文讲述了用Style Report报表工具简单实现跨单元格的数据统计。
8、设计器增加数据提供事件接口，在设计报表时可以用给报表加载自定义数据源。 ★打印与打印预览： 1、横向分页时，在数据不多的情况下，分页直接显示在本页，而不是在下一页。 2、在模板中可以保存默认打印机名称...
大学老师要我们学习郭永清老师的《财务报表分析与股票估值》这本书，布置了最后两章的作业， 对郭永清老师的《财务报表分析与股票估值》这本书内容的实现 注意事项 代码是基于《财务报表分析与股票估值》的，其中...
10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档 Ver 2.25 主要新增或修改的功能 一、 增加报表行对象隐藏...
表格带有财务栏功能(按元角分显示金额，并可自定义位数)，在表格的标题栏或合计栏那里可以点右键弹出操作菜单，对数值型数据进行是否按会计方式显示金额，并可自动生成相应报表格式；从表格中移除的字段可以选择在...
10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档 Ver 2.3主要新增或修改的功能 一、增加的功能： 1、支持二...
10. 既可以使用应用程序中的数据集，也支持在报表中直接连接各种数据库，通过SQL直接获得报表需要的数据。 11.无失真导出为Excel、Word、Html格式的文档 Ver 2.25 主要新增或修改的功能 一、 增加报表行对象隐藏...