//表M-1-1：总体摸底情况表

tfy1332

于 2014-10-29 09:35:58 发布

阅读量747

点赞数

本文链接：https://blog.csdn.net/tfy1332/article/details/40581501

版权

<%@page contentType="text/html;charset=GBK"%>

<%@page import="java.util.*,
com.fsm.db.*"
%>

<%@page import="com.fsm.datetime.DateTime"%>
<%@page import="java.text.DecimalFormat"%>

<%
DBService dbservice = new DBService();
DateTime dateTime = new DateTime();
DecimalFormat df1 = new DecimalFormat("0.00%");

DBSet dbset = null;
DBSet dbset1 = null;
DBSet dbset2 = null;
DBSet dbset3 = null;
DBSet dbset4 = null;
DBSet dbset5 = null;
DBSet dbset6 = null;
DBSet dbset7 = null;
DBSet dbset8 = null;
DBSet dbset9 = null;

DBMap dbmap1 = new DBMap();
DBMap dbmap2 = new DBMap();
DBMap dbmap3 = new DBMap();
DBMap dbmap4 = new DBMap();
DBMap dbmap5 = new DBMap();
DBMap dbmap6 = new DBMap();
DBMap dbmap7 = new DBMap();
DBMap dbmap8 = new DBMap();
DBMap dbmap9 = new DBMap();

String strDeptID =(String)session.getAttribute("DeptID");
String strDeptName =(String)session.getAttribute("DeptName");

//request. setCharacterEncoding("UTF-8");

String strPlant=request.getParameter("plant");
String strArea=request.getParameter("area");

String strCompany=request.getParameter("company");
String strHurtpersonfalg=request.getParameter("hurtpersonflag");

String strIsdiffcompensate=request.getParameter("ISDIFFCOMPENSATE");
String strInsurancepersontype=request.getParameter("INSURANCEPERONTYPE");

String strIsappeal=request.getParameter("ISAPPEAL");
String strAmountfalg=request.getParameter("AMOUNTFLAG");

String strCaseagefalg=request.getParameter("CASEAGEFLAG");

strPlant = dbservice.postGBK(strPlant);
strArea = dbservice.postGBK(strArea);
strCompany = dbservice.postGBK(strCompany);

strHurtpersonfalg = dbservice.postGBK(strHurtpersonfalg);
strIsdiffcompensate = dbservice.postGBK(strIsdiffcompensate);
strInsurancepersontype = dbservice.postGBK(strInsurancepersontype);
strIsappeal = dbservice.postGBK(strIsappeal);
strAmountfalg = dbservice.postGBK(strAmountfalg);
strCaseagefalg = dbservice.postGBK(strCaseagefalg);

String strWhere = "";
String strWhere1= "";
String strID = "EventAreaID";

if(strPlant!=null&&!"".equals(strPlant))
{
strWhere=strWhere+" and CASECODE='"+strPlant+"' ";
}
if(strArea!=null&&!"".equals(strArea))
{
strWhere=strWhere+" and UNDERWRITEPROAREA='"+strArea+"' ";
}

if(strCompany!=null&&!"".equals(strCompany))
{
strWhere=strWhere+" and UNDERWRITEPROCODE='"+strCompany+"' ";
}

if(strHurtpersonfalg!=null&&!"".equals(strHurtpersonfalg))
{
strWhere=strWhere+" and hurtpersonFlag='"+strHurtpersonfalg+"' ";
}

if(strIsdiffcompensate!=null&&!"".equals(strIsdiffcompensate))
{
strWhere=strWhere+" and ISDIFFCOMPENSATE='"+strIsdiffcompensate+"' ";
}
if(strInsurancepersontype!=null&&!"".equals(strInsurancepersontype))
{
strWhere=strWhere+" and INSURANCEPERONTYPE='"+strInsurancepersontype+"' ";
}
if(strIsappeal!=null&&!"".equals(strIsappeal))
{
strWhere=strWhere+" and ISAPPEAL='"+strIsappeal+"' ";
}

if(strAmountfalg!=null&&!"".equals(strAmountfalg))
{
strWhere=strWhere+" and AMOUNTFLAG='"+strAmountfalg+"' ";
}
if(strCaseagefalg!=null&&!"".equals(strCaseagefalg))
{
strWhere=strWhere+" and CASEAGEFLAG='"+strCaseagefalg+"' ";
}

String strSQL="select * from Tab_2014_M_1_1 where "+strWhere1+" order by tid asc";
dbset=dbservice.getSelectSet(strSQL);

//表M-1-1：总体摸底情况表
String strSQL1 = "select count(CASENO) as casenumber,sum(RealAmount) as RealAmount,sum(RealAmount)/count(CASENO) averageamount from Tab_2014_M_1_1 where 1=1 "+strWhere;
System.out.println("=========表M-1-1：总体摸底情况表=======strSQL1======"+strSQL1);
dbset1=dbservice.getSelectSet(strSQL1);

if(dbset1!=null)
{
if(dbset1.size()>0)
{
for(int i=0;i<dbset1.size();i++)
{
String strTValue=dbset1.getValue(i,"TValue");
String strTID=dbset1.getValue(i,"TID");
dbmap1.put(strTID,strTValue);
}
}
}
%>

<html>
<head>

<style type="text/css">
span{
font-family:"tahoma", "宋体";
cursor: hand;
}

.button1 {
cursor: hand;
background-image: url('../../images/btn.gif');
height:20px;
font-size: 14px;
padding: 2px 4px;
border-top: 1px solid #848484;
border-right: 1px solid #848484;
border-bottom: 1px solid #848484;
border-left: 1px solid #848484;
text-align: center;
min-width: 60px;
color: #333333;
behavior: url('../../css/btn_event.htc')
}


</style>
<style media="print">
#Noprint{display:none;}
</style>
<style media="screen">
.NoScreen{display:none;}
</style>
<script src="../js/title.js"></script>
<title>表M-1-1：总体摸底情况表</title>
<link href="../../windows7/css/dzda.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" media="all" href="../../css/calendar/calendar.css" title="Aqua" />
<script src="../../js/calendar.js" ></script>
<script src="../../js/validate.js" ></script>
<script type="text/javascript" src="../../js/jquery.js"></script>
<script src="../../js/jquery.selectoption.js" ></script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="form1" method="post">
<input type="hidden" name="SQL">
<input type="hidden" name="TName">
<input type="hidden" name="BeginAppealDate" value="2014-07-13">
<input type="hidden" name="EndAppealDate" value="2014-08-12">
</form>

<br>
<table width="99%" cellspacing="0" cellpadding="0" align="center" border="0">

<tbody><tr>
<td align="center" class="table-head-font"><b>表M-1-2：总体摸底情况表</b>
</td>
</tr>
<tr>
<td height="10"> </td>
</tr>
<tr>
<td align="center" class="table-head-font">时间： 2014-07-13 至 2014-08-12
</td>
</tr>
<tr>
</tr>
<tr><td height="10"></td></tr>
<tr><td>
<table border="2" style="BORDER-COLLAPSE: collapse" bordercolor="#000000" cellspacing="0" cellpadding="0" align="center" width="100%" id="datatab">

<tbody><tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1" rowspan="2"><b>时间</b></td>
<td align="center" class="ms-classicl-t1" colspan="10">未结整体</td>
<td align="center" class="ms-classicl-t1" colspan="1"><b></b></td>
</tr>
<tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1"><b>件数</b></td>
<td align="center" class="ms-classicl-t1" colspan="1"><b>估损金额</b></td>
<td align="center" class="ms-classicl-t1" colspan="1"><b>件均估损金额</b></td>
<td align="center" class="ms-classicl-t1" colspan="1"><b>件数同比</b></td>
<td align="center" class="ms-classicl-t1" colspan="1"><b>估损金额同比</b></td>
<td align="center" class="ms-classicl-t1" colspan="1"><b>件均估损金额同比</b></td>
</tr>

<%
if(dbset1!=null){
if(dbset1.size()>0){
for(int i=0;i<dbset1.size();i++){
DecimalFormat formatStr = new DecimalFormat("###,##0.00");

DecimalFormat formatStrint = new DecimalFormat("###,##0");
String strCasenumber=dbset1.getValue(i,"casenumber");
//处理查询结果为空的数据。
if("".equals(strCasenumber)){
strCasenumber="0";
}
strCasenumber = formatStrint.format(Double.parseDouble(strCasenumber));

String strRealAmount=dbset1.getValue(i,"RealAmount");//averageamount
//处理查询结果为空的数据。
if("".equals(strRealAmount)){
strRealAmount="0";
}
strRealAmount = formatStr.format(Double.parseDouble(strRealAmount));

String strAverageamount=dbset1.getValue(i,"averageamount");//averageamount

//处理查询结果为空的数据。
if("".equals(strAverageamount)){
strAverageamount="0";
}
strAverageamount = formatStr.format(Double.parseDouble(strAverageamount));



%>
<tr height='25'>
<td align="center" class="ms-classicl-t1" colspan="1">2014</td>
<td align=center class='ms-classicl-t1' colspan="1"><%=strCasenumber %></td>
<td align=center class='ms-classicl-t1' colspan="1"><span οnclick="openWin('<%=strRealAmount%>','<%=strRealAmount%>')"><%=strRealAmount %></span></td>
<td align=center class='ms-classicl-t1' colspan="1"><%=strAverageamount %></td>
<td align=center class='ms-classicl-t1' colspan="1"><%=strCasenumber %></td>
<td align=center class='ms-classicl-t1' colspan="1"><span οnclick="openWin('<%=strRealAmount%>','<%=strRealAmount%>')"><%=strRealAmount %></span></td>
<td align=center class='ms-classicl-t1' colspan="1"><%=strAverageamount %></td>
</tr>
<%
}
}
}
%>
<tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1">2012</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370100%27+order+by+AppealDate+asc','济南市')">21</span></td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>
<td align="center" class="ms-classicl-t1" colspan="1">-16.00%</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+AppealFlag%3D1+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370100%27+order+by+AppealDate+asc','济南市')">3</span></td>
<td align="center" class="ms-classicl-t1" colspan="1">14.29%</td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>

</tr>

<tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1">2013</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370200%27+order+by+AppealDate+asc','青岛市')">26</span></td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>
<td align="center" class="ms-classicl-t1" colspan="1">-46.94%</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+AppealFlag%3D1+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370200%27+order+by+AppealDate+asc','青岛市')">6</span></td>
<td align="center" class="ms-classicl-t1" colspan="1">23.08%</td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>

</tr><tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1">2014</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370300%27+order+by+AppealDate+asc','淄博市')">3</span></td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>
<td align="center" class="ms-classicl-t1" colspan="1">-62.50%</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+AppealFlag%3D1+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27370300%27+order+by+AppealDate+asc','淄博市')"></span></td>
<td align="center" class="ms-classicl-t1" colspan="1">0.00%</td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>

</tr><tr height="25">
<td align="center" class="ms-classicl-t1" colspan="1">菏泽市</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27371700%27+order+by+AppealDate+asc','菏泽市')">14</span></td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>
<td align="center" class="ms-classicl-t1" colspan="1">133.33%</td>
<td align="center" class="ms-classicl-t1" colspan="1"><span οnclick="openWin('select+*+from+j_appeal+where+AppealDate%3E%3D%272014-07-13%27+and+AppealDate%3C%3D%272014-08-12%27+and+AppealFlag%3D1+and+DeptLevel+in%28%271%27%29+and+EventAreaID%3D%27371700%27+order+by+AppealDate+asc','菏泽市')">5</span></td>
<td align="center" class="ms-classicl-t1" colspan="1">35.71%</td>
<td align="center" class="ms-classicl-t1" colspan="1"></td>

</tr>

</tbody></table>

</td>
</tr>
<tr><td height="10"></td></tr>
<tr>
<td align="right" class="table-data-font">
制表单位：保监会 
</td>
</tr>
</tbody></table>
<div align="center"><input type="button" id="Noprint" name="submitbutton" οnclick="doprint()" class="button1" value="打印"></div>

<script language="javascript">
function openWin(data1,data2)
{
form1.SQL.value=data1;
form1.TName.value=data2;
form1.action='rep_fromLetter2.jsp';
form1.target='_blank';
form1.submit();
}

function openWin2(data1)
{
form2.DeptID.value=data1;
form2.action='rep1_fromLetter1.jsp';
form2.target='_blank';
form2.submit();
}

function doprint(){
window.print();
}
</script>
</body>
</html>
<SCRIPT language="javascript">
document.all('ad_item').focus();
function doSubmit()
{
if(doValidate(form1))
{
if(form1.ad_item.value==''&&form1.ad_position.value=='')
{
alert("就读学校和工作单位不能同时为空！");
}
else
{
form1.action='e_advert_updatesubmit.jsp';
form1.target='_self';
form1.submit();
form1.submitbut1.disabled=true;
}
}
}
</SCRIPT>