📄 queryyearcheckupselectprinttoexcel.jsp
字号:
<%@ page contentType="application/vnd.ms-excel; charset=gb2312" %>
<%@ page import="java.util.*"%>
<%@page import="java.util.*,com.gs.util.*"%>
<%@ page import="com.gs.control.event.PageBuilderEvent;"%>
<%@ page import="com.gs.pageBuilder.model.*;"%>
<%@ page import="com.gs.pageBuilder.util.*;"%>
<%
try{
String td="businessTd01Left";
String yearCheckupYear=(String)request.getAttribute("yearCheckupYear");
ArrayList queryResultList=(ArrayList)request.getAttribute("queryResultList");
QuerySuperResultModel querySuperResultModel= null;
int i=0;
String yearcheckupSelect=(String)request.getAttribute("yearcheckupSelect");
String showTitleStr="";
Calendar calendar=Calendar.getInstance();
String querytoShowNowDate=PageBuildUtil.dataTypeConversion((String)PubFunc.getDateStr(calendar),"4","");
String titleStr1=(String)request.getAttribute("titleStr1");
String titleStr2=(String)request.getAttribute("titleStr2");
String titleStr3=(String)request.getAttribute("titleStr3");
String titleStr4=(String)request.getAttribute("titleStr4");
String titleStr5=(String)request.getAttribute("titleStr5");
String titleStr6=(String)request.getAttribute("titleStr6");
String titleStr7=(String)request.getAttribute("titleStr7");
String titleStr8=(String)request.getAttribute("titleStr8");
String titleStr9=(String)request.getAttribute("titleStr9");
String titleStr10=(String)request.getAttribute("titleStr10");
String titleStr11=(String)request.getAttribute("titleStr11");
String titleStr12=(String)request.getAttribute("titleStr12");
if("01".equals(yearcheckupSelect)){
showTitleStr="企业监督综合情况";
}else
if("02".equals(yearcheckupSelect)){
showTitleStr=yearCheckupYear+"年度已年检的企业";
}else
if("03".equals(yearcheckupSelect)){
showTitleStr=yearCheckupYear+"年度未申报年检的企业";
}else
if("04".equals(yearcheckupSelect)){
showTitleStr=yearCheckupYear+"年度年检正在受理中的企业";
}else
if("06".equals(yearcheckupSelect)){
showTitleStr="被注销企业";
}else
if("05".equals(yearcheckupSelect)){
showTitleStr="被吊销企业";
}
else
if("07".equals(yearcheckupSelect)){
showTitleStr=yearCheckupYear+"年度未年检的企业";
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=showTitleStr%></title>
<link href="<%=request.getContextPath()%>/include/style/style01/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<center>
<form name=report action=<%=request.getContextPath()%>/pageBuilderAction.do method=post target="_blank">
<input type="hidden" value="1002" name=action>
</form>
<table border="0" width="100%">
<tr>
<td><font class=textNoPrint><img src="<%=request.getContextPath()%>/images/bg3.gif" border="0" > <font class="textBusinessTitle"><%=showTitleStr%></font></font></td>
</tr>
</table>
<table border="1" class="businessTable01" id=stockmanID width="100%">
<tr>
<td width="30" class="businessTdTitle00"><span>序号</span></td>
<%if("ON".equals(titleStr1)){%>
<td width="80" class="businessTdTitle00"><span>注册号</span></td>
<%}%>
<%if("ON".equals(titleStr2)){%>
<td width="200" class="businessTdTitle00"><span>企业名称</span></td>
<%}%>
<%if("ON".equals(titleStr3)){%>
<td width="200" class="businessTdTitle00"><span>住所</span></td>
<%}%>
<%if("ON".equals(titleStr4)){%>
<td width="160" class="businessTdTitle00"><span>负责人</span></td>
<%}%>
<%if("ON".equals(titleStr5)){%>
<td width="100" class="businessTdTitle00"><span>电话</span></td>
<%}%>
<%if("ON".equals(titleStr6)){%>
<td width="80" class="businessTdTitle00"><span>邮政编码</span></td>
<%}%>
<%if("02".equals(yearcheckupSelect)){%>
<%if("ON".equals(titleStr7)){%>
<td width="160" class="businessTdTitle00"><span>受理时间</span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td width="160" class="businessTdTitle00"><span>年检结果</span></td>
<%}%>
<%}%>
<%if("04".equals(yearcheckupSelect)||"05".equals(yearcheckupSelect)){%>
<%if("ON".equals(titleStr7)){%>
<td width="300" class="businessTdTitle00" ><span>经营范围</span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td width="160" class="businessTdTitle00" ><span>企业类型</span></td>
<%}%>
<%if("ON".equals(titleStr9)){%>
<td width="100" class="businessTdTitle00"><span>成立日期</span></td>
<%}%>
<%if("ON".equals(titleStr10)){%>
<td width="100" class="businessTdTitle00"><span>吊销时间</span></td>
<%}%>
<%if("ON".equals(titleStr11)){%>
<td width="100" class="businessTdTitle00"><span>注销时间</span></td>
<%}%>
<%if("ON".equals(titleStr12)){%>
<td width="160" class="businessTdTitle00"><span>处罚文号</span></td>
<%}%>
<%}%>
</tr>
<%
if(queryResultList!=null)
for(i=0;i<queryResultList.size();i++){
querySuperResultModel=(QuerySuperResultModel)queryResultList.get(i);
td=td=="businessTd01Left"?"businessTd00Left":"businessTd01Left";
%>
<tr>
<td class="<%=td%>"><span> <%=i+1%></span></td>
<%if("ON".equals(titleStr1)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getRegID())%></span></td>
<%}%>
<%if("ON".equals(titleStr2)){%>
<td class="<%=td%>" width="200"><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationName())%></span></td>
<%}%>
<%if("ON".equals(titleStr3)){%>
<td class="<%=td%>" width="200"><span> <%=PubFunc.toShow(querySuperResultModel.getAbode())%></span></td>
<%}%>
<%if("ON".equals(titleStr4)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getPrincipal())%></span></td>
<%}%>
<%if("ON".equals(titleStr5)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getPhonenumber())%></span></td>
<%}%>
<%if("ON".equals(titleStr6)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getPostalcode())%></span></td>
<%}%>
<%if("02".equals(yearcheckupSelect)){%>
<%if("ON".equals(titleStr7)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getCheckYearDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(GetCodingTable.getAcceptResult(querySuperResultModel.getCheckYearResult()))%></span></td>
<%}%>
<%}%>
<%if("04".equals(yearcheckupSelect)||"05".equals(yearcheckupSelect)){%>
<%if("ON".equals(titleStr7)){%>
<td class="<%=td%>" width=300><span> <%=PubFunc.toShow(querySuperResultModel.getWorkArea())%></span></td>
<%}%>
<%if("ON".equals(titleStr8)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getCorporationTypeName())%></span></td>
<%}%>
<%if("ON".equals(titleStr9)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getPracticeDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr10)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getLogoutRevokeDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr11)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getLogoutRevokeDate())%></span></td>
<%}%>
<%if("ON".equals(titleStr12)){%>
<td class="<%=td%>"><span> <%=PubFunc.toShow(querySuperResultModel.getPunishID())%></span></td>
<%}%>
<%}%>
</tr>
<%}%>
</table>
<br>
<span>满足条件的企业共计： <%=i%>个. 打印日期:<%=querytoShowNowDate%></span>
<br>
</body>
</html>
<%}
catch(Exception ex){
Debug.println("QueryYearCheckupSelectPrint.jsp exception :"+ex.getMessage());
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -