<%@ page
language="java"
contentType="text/html; charset=GBK"
pageEncoding="GBK"
%>
<%@ page import="java.util.*"%>
<%@ page import="com.icss.common.db.DataMsg"%>
<%@ page import="com.icss.common.db.Data"%>
<%@ page import="com.icss.basedb.basecode.code.Dictionary"%>
<%
DataMsg dataMsg = (DataMsg)request.getAttribute("dataMsg");
if(dataMsg == null){
dataMsg = new DataMsg();
}
Map dictMap = (Map) request.getAttribute("DICT");
if(dictMap == null){
dictMap = new HashMap();
}
%>
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=GBK">
<META name="GENERATOR" content="IBM WebSphere Studio">
<TITLE>打印</TITLE>
<script language="javascript">
function getWord() {
//var wd;
var wd = document.getElementById("office");
//新建文档
wd.CreateNew("Word.Document");
return wd;
}
function printWord(data,datalb){
//word对象
//将页面中表格的内容存放在数组中
var wdapp = getWord();
var column = 5;
//var range = wdapp.ActiveDocument.Range(0,1);
wdapp.visible=true;
//range.Text="订单信息列表"+"\n";
//range.Text="";
wdapp.ActiveDocument.Application.Selection.ParagraphFormat.Alignment = 1;
//wdapp.ActiveDocument.Application.Selection.ParagraphFormat.LineSpacingRule = 4;
//wdapp.ActiveDocument.Application.Selection.ParagraphFormat.LineSpacing = 10;
//wdapp.ActiveDocument.Application.Selection.HorizontalAlignment = 1;
// wdapp.Activedocument.Paragraphs.Add(range);
wdapp.Activedocument.Paragraphs.Add();
var row = 32;
rngcurrent=wdapp.Activedocument.Paragraphs(2).Range;
var objTable=wdapp.ActiveDocument.Tables.Add(rngcurrent,row,column); //插入表格
objTable.Columns(1).width = 125;
objTable.Columns(2).width = 100;
objTable.Columns(3).width = 105;
objTable.Columns(4).width = 50;
objTable.Columns(5).width = 50;
objTable.Borders.OutsideLineStyle = 1;
objTable.Borders.InsideLineStyle = 1;
var u =0;
<% for (int i=0;i<dataMsg.size();i++){
Data data = dataMsg.getData(i);
String nysczlmc = data.getString("NYSCZL","");
String fbqjmc = data.getString("FBQJ","");
String drtmc = data.getString("DRT","");
String wxhxpmc = data.getString("WXHXP","");
String rqqjmc = data.getString("RQQJ","");
String dxdlmc = data.getString("DXDL","");
String kjmc = data.getString("KJ","");
String rzbmc = data.getString("RZB","");
String jzgcmc = data.getString("JZGC","");
String dydqmc = data.getString("DYDQ","");
String qcpjmc = data.getString("QCPJ","");
String ldfhypmc = data.getString("LDFHYP","");
String etwjmc = data.getString("ETWJ","");
String jydqmc = data.getString("JYDQ","");
Map map =new HashMap();
if(!"".equals(nysczlmc)){
String nysczl = Dictionary.value(dictMap,"PCJD_CPLB_NYSCZL",nysczlmc);
map.put("农业生产材料",nysczl);
}
if(!"".equals(fbqjmc)){
String fbqj = Dictionary.value(dictMap,"PCJD_CPLB_FBQJ",fbqjmc);
map.put("防爆器具",fbqj);
}
if(!"".equals(drtmc)){
String drt = Dictionary.value(dictMap,"PCJD_CPLB_DRT",drtmc);
map.put("电热毯",drt);
}
if(!"".equals(wxhxpmc)){
String wxhxp = Dictionary.value(dictMap,"PCJD_CPLB_WXHXP",wxhxpmc);
map.put("危险化学品",wxhxp);
}
if(!"".equals(rqqjmc)){
String rqqj = Dictionary.value(dictMap,"PCJD_CPLB_RQQJ",rqqjmc);
map.put("燃气器具",rqqj);
}
if(!"".equals(dxdlmc)){
String dxdl = Dictionary.value(dictMap,"PCJD_CPLB_DXDL",dxdlmc);
map.put("电线电缆",dxdl);
}
if(!"".equals(kjmc)){
String kj = Dictionary.value(dictMap,"PCJD_CPLB_KJ",kjmc);
map.put("扣件",kj);
}
if(!"".equals(rzbmc)){
String rzb = Dictionary.value(dictMap,"PCJD_CPLB_RZB",rzbmc);
map.put("人造板",rzb);
}
if(!"".equals(jzgcmc)){
String jzgc = Dictionary.value(dictMap,"PCJD_CPLB_JZGC",jzgcmc);
map.put("建筑钢材",jzgc);
}
if(!"".equals(dydqmc)){
String dydq = Dictionary.value(dictMap,"PCJD_CPLB_DYDQ",dydqmc);
map.put("低压电器",dydq);
}
if(!"".equals(qcpjmc)){
String qcpj = Dictionary.value(dictMap,"PCJD_CPLB_QCPJ",qcpjmc);
map.put("汽车配件",qcpj);
}
if(!"".equals(ldfhypmc)){
String ldfhyp = Dictionary.value(dictMap,"PCJD_CPLB_LDFHYP",ldfhypmc);
map.put("劳动防护用品",ldfhyp);
}
if(!"".equals(etwjmc)){
String etwj = Dictionary.value(dictMap,"PCJD_CPLB_ETWJ",etwjmc);
map.put("儿童玩具",etwj);
}
if(!"".equals(jydqmc)){
String jydq = Dictionary.value(dictMap,"PCJD_CPLB_JYDQ",jydqmc);
map.put("家用电器",jydq);
}
int y = map.size();
%>
//第一行
<% if(i==0) {%>
objTable.Cell(1,1).Range.Font.Bold = 9999998;
objTable.Cell(1,1).Range.Font.Size = 12;
objTable.Cell(1,1).Range.Font.Name = "宋体";
objTable.Cell(1,1).Height = 22;
objTable.Cell(1,1).Range.Text = "重点产品生产加工企业普查建档登记表";
objTable.Cell(1, 1).Merge(objTable.Cell(1, 5));
//第二行
objTable.Cell(2,1).Range.Font.Bold = 9999998;
objTable.Cell(2,1).Range.Font.Size = 10;
objTable.Cell(2,1).Range.Font.Name = "宋体";
objTable.Cell(2,1).Range.Text = "企业名称(以公章为主):";
objTable.Cell(2,2).Range.Font.Bold = 0000000;
objTable.Cell(2,2).Range.Font.Size = 10;
objTable.Cell(2,2).Range.Font.Name = "宋体";
objTable.Cell(2,2).Range.Text = '<%=data.getString("QYMC")%>';
objTable.Cell(2, 2).Merge(objTable.Cell(2, 5));
//第三行
objTable.Cell(3,1).Range.Font.Bold = 9999998;
objTable.Cell(3,1).Range.Font.Size = 10;
objTable.Cell(3,1).Range.Font.Name = "宋体";
objTable.Cell(3,1).Range.Text = "所在地详细地址:";
objTable.Cell(3,2).Range.Font.Bold = 0000000;
objTable.Cell(3,2).Range.Font.Size = 10;
objTable.Cell(3,2).Range.Font.Name = "宋体";
objTable.Cell(3,2).Range.Text = '<%=Dictionary.value(dictMap,"101001",data.getString("SHI"))%><%=Dictionary.value(dictMap,"101001",data.getString("XIAN"))%><%=data.getString("SZDXXDZ")%>';
objTable.Cell(3, 2).Merge(objTable.Cell(3, 5));
//第四行
objTable.Cell(4,1).Range.Font.Bold = 9999998;
objTable.Cell(4,1).Range.Font.Size = 10;
objTable.Cell(4,1).Range.Font.Name = "宋体";
objTable.Cell(4,1).Range.Text = "法人代表或负责人:";
objTable.Cell(4,2).Range.Font.Bold = 0000000;
objTable.Cell(4,2).Range.Font.Size = 10;
objTable.Cell(4,2).Range.Font.Name = "宋体";
objTable.Cell(4,2).Range.Text = '<%=data.getString("FRDBHFZR")%>';
objTable.Cell(4,3).Range.Font.Bold = 9999998;
objTable.Cell(4,3).Range.Font.Size = 10;
objTable.Cell(4,3).Range.Font.Name = "宋体";
objTable.Cell(4,3).Range.Text = "企业人数:";
objTable.Cell(4,4).Range.Font.Bold = 0000000;
objTable.Cell(4,4).Range.Font.Size = 10;
objTable.Cell(4,4).Range.Font.Name = "宋体";
objTable.Cell(4,4).Range.Text = '<%=data.getString("QYRS")%>人';
objTable.Cell(4, 4).Merge(objTable.Cell(4, 5));
//第五行
objTable.Cell(5,1).Range.Font.Bold = 9999998;
objTable.Cell(5,1).Range.Font.Size = 10;
objTable.Cell(5,1).Range.Font.Name = "宋体";
objTable.Cell(5,1).Range.Text = "联系电话:";
objTable.Cell(5,2).Range.Font.Bold = 0000000;
objTable.Cell(5,2).Range.Font.Size = 10;
objTable.Cell(5,2).Range.Font.Name = "宋体";
objTable.Cell(5,2).Range.Text = '<%=data.getString("LXDH")%>';
objTable.Cell(5,3).Range.Font.Bold = 9999998;
objTable.Cell(5,3).Range.Font.Size = 10;
objTable.Cell(5,3).Range.Font.Name = "宋体";
objTable.Cell(5,3).Range.Text = "邮政编码:";
objTable.Cell(5,4).Range.Font.Bold = 0000000;
objTable.Cell(5,4).Range.Font.Size = 10;
objTable.Cell(5,4).Range.Font.Name = "宋体";
objTable.Cell(5,4).Range.Text = '<%=data.getString("YZBM")%>';
objTable.Cell(5, 4).Merge(objTable.Cell(5, 5));
//第六行
objTable.Cell(6,1).Range.Font.Bold = 9999998;
objTable.Cell(6,1).Range.Font.Size = 10;
objTable.Cell(6,1).Range.Font.Name = "宋体";
objTable.Cell(6,1).Range.Text = "营业执照:";
objTable.Cell(6,2).Range.Font.Bold = 0000000;
objTable.Cell(6,2).Range.Font.Size = 10;
objTable.Cell(6,2).Range.Font.Name = "宋体";
objTable.Cell(6,2).Range.Text = '<% if("1".equals(data.getString("YYZZ",""))){ out.print("有");}else if("0".equals(data.getString("YYZZ"))){out.print("无");} %>';
objTable.Cell(6,3).Range.Font.Bold = 9999998;
objTable.Cell(6,3).Range.Font.Size = 10;
objTable.Cell(6,3).Range.Font.Name = "宋体";
objTable.Cell(6,3).Range.Text = "营业执照编号:";
objTable.Cell(6,4).Range.Font.Bold = 0000000;
objTable.Cell(6,4).Range.Font.Size = 10;
objTable.Cell(6,4).Range.Font.Name = "宋体";
objTable.Cell(6,4).Range.Text = '<%=data.getString("YYZZBH")%>';
objTable.Cell(6, 4).Merge(objTable.Cell(6, 5));
//第七行
objTable.Cell(7,1).Range.Font.Bold = 9999998;
objTable.Cell(7,1).Range.Font.Size = 10;
objTable.Cell(7,1).Range.Font.Name = "宋体";
objTable.Cell(7,1).Range.Text = "企业代码证:";
objTable.Cell(7,2).Range.Font.Bold = 0000000;
objTable.Cell(7,2).Range.Font.Size = 10;
objTable.Cell(7,2).Range.Font.Name = "宋体";
objTable.Cell(7,2).Range.Text = '<% if("1".equals(data.getString("QYDMZ",""))){ out.print("有");}else if("0".equals(data.getString("QYDMZ"))){out.print("无");} %>';
objTable.Cell(7,3).Range.Font.Bold = 9999998;
objTable.Cell(7,3).Range.Font.Size = 10;
objTable.Cell(7,3).Range.Font.Name = "宋体";
objTable.Cell(7,3).Range.Text = "企业代码证编号:";
objTable.Cell(7,4).Range.Font.Bold = 0000000;
objTable.Cell(7,4).Range.Font.Size = 10;
objTable.Cell(7,4).Range.Font.Name = "宋体";
objTable.Cell(7,4).Range.Text = '<%=data.getString("QYDMZBH")%>';
objTable.Cell(7, 4).Merge(objTable.Cell(7, 5));
//第八行
objTable.Cell(8,1).Range.Font.Bold = 9999998;
objTable.Cell(8,1).Range.Font.Size = 10;
objTable.Cell(8,1).Range.Font.Name = "宋体";
objTable.Cell(8,1).Range.Text = "是否获得工业产品生产许可证:";
objTable.Cell(8,2).Range.Font.Bold = 0000000;
objTable.Cell(8,2).Range.Font.Size = 10;
objTable.Cell(8,2).Range.Font.Name = "宋体";
objTable.Cell(8,2).Range.Text = '<% if("1".equals(data.getString("SFHDGYCPSCXKZ",""))){ out.print("已获得");}else if("0".equals(data.getString("SFHDGYCPSCXKZ"))){out.print("未获得");}%>';
objTable.Cell(8,3).Range.Font.Bold = 9999998;
objTable.Cell(8,3).Range.Font.Size = 10;
objTable.Cell(8,3).Range.Font.Name = "宋体";
objTable.Cell(8,3).Range.Text = "工业产品生产许可证编号:";
objTable.Cell(8,4).Range.Font.Bold = 0000000;
objTable.Cell(8,4).Range.Font.Size = 10;
objTable.Cell(8,4).Range.Font.Name = "宋体";
objTable.Cell(8,4).Range.Text = '<%=data.getString("GYCPSCXKZBH")%>';
objTable.Cell(8, 4).Merge(objTable.Cell(8, 5));
//第九行
//objTable.Cell(9,1).Range.HorizontalAlignment = 3;
objTable.Cell(9,1).Range.Font.Bold = 9999998;
objTable.Cell(9,1).Range.Font.Size = 10;
objTable.Cell(9,1).Range.Font.Name = "宋体";
objTable.Cell(9,1).Range.Text = "工业许可证获证单元:";
objTable.Cell(9, 1).Merge(objTable.Cell(10, 1));
objTable.Cell(9, 1).Merge(objTable.Cell(11, 1));
objTable.Cell(9,2).Range.Font.Bold = 9999998;
objTable.Cell(9,2).Range.Font.Size = 10;
objTable.Cell(9,2).Range.Font.Name = "宋体";
objTable.Cell(9,2).Range.Text = "应获数量:";
objTable.Cell(9,3).Range.Font.Bold = 0000000;
objTable.Cell(9,3).Range.Font.Size = 10;
objTable.Cell(9,3).Range.Font.Name = "宋体";
objTable.Cell(9,3).Range.Text = '<%=data.getString("YHSL")%>';
objTable.Cell(9, 3).Merge(objTable.Cell(9, 5));
//第十行
objTable.Cell(10,2).Range.Font.Bold = 9999998;
objTable.Cell(10,2).Range.Font.Size = 10;
objTable.Cell(10,2).Range.Font.Name = "宋体";
objTable.Cell(10,2).Range.Text = "已获数量:";
objTable.Cell(10,3).Range.Font.Bold = 0000000;
objTable.Cell(10,3).Range.Font.Size = 10;
objTable.Cell(10,3).Range.Font.Name = "宋体";
objTable.Cell(10,3).Range.Text = '<%=data.getString("YIHSL")%>';
objTable.Cell(10, 3).Merge(objTable.Cell(10, 5));
//第十一行
objTable.Cell(11,2).Range.Font.Bold = 9999998;
objTable.Cell(11,2).Range.Font.Size = 10;
objTable.Cell(11,2).Range.Font.Name = "宋体";
objTable.Cell(11,2).Range.Text = "未获数量:";
objTable.Cell(11,3).Range.Font.Bold = 0000000;
objTable.Cell(11,3).Range.Font.Size = 10;
objTable.Cell(11,3).Range.Font.Name = "宋体";
objTable.Cell(11,3).Range.Text = '<%=data.getString("WHSL")%>';
objTable.Cell(11, 3).Merge(objTable.Cell(11, 5));
//第十二行
objTable.Cell(12,1).Range.Font.Bold = 9999998;
objTable.Cell(12,1).Range.Font.Size = 10;
objTable.Cell(12,1).Range.Font.Name = "宋体";
objTable.Cell(12,1).Range.Text = "产品质量是否获得免检:";
objTable.Cell(12,2).Range.Font.Bold = 0000000;
objTable.Cell(12,2).Range.Font.Size = 10;
objTable.Cell(12,2).Range.Font.Name = "宋体";
objTable.Cell(12,2).Range.Text = '<% if("1".equals(data.getString("CPZLSFHDMJ",""))){ out.print("已获得");}else if("0".equals(data.getString("CPZLSFHDMJ"))){out.print("未获得");}%>';
objTable.Cell(12,3).Range.Font.Bold = 9999998;
objTable.Cell(12,3).Range.Font.Size = 10;
objTable.Cell(12,3).Range.Font.Name = "宋体";
objTable.Cell(12,3).Range.Text = "免检证书编号:";
objTable.Cell(12,4).Range.Font.Bold = 0000000;
objTable.Cell(12,4).Range.Font.Size = 10;
objTable.Cell(12,4).Range.Font.Name = "宋体";
objTable.Cell(12,4).Range.Text = '<%=data.getString("MJZSBH")%>';
objTable.Cell(12, 4).Merge(objTable.Cell(12, 5));
//第十三行
objTable.Cell(13,1).Range.Font.Bold = 9999998;
objTable.Cell(13,1).Range.Font.Size = 10;
objTable.Cell(13,1).Range.Font.Name = "宋体";
objTable.Cell(13,1).Range.Text = "免检证书有效期:";
objTable.Cell(13,2).Range.Font.Bold = 0000000;
objTable.Cell(13,2).Range.Font.Size = 10;
objTable.Cell(13,2).Range.Font.Name = "宋体";
objTable.Cell(13,2).Range.Text = '<%=data.getString("MJZSYXQ")%>';
objTable.Cell(13, 2).Merge(objTable.Cell(13, 5));
//第十四行
objTable.Cell(14,1).Range.Font.Bold = 9999998;
objTable.Cell(14,1).Range.Font.Size = 10;
objTable.Cell(14,1).Range.Font.Name = "宋体";
objTable.Cell(14,1).Range.Text = "是否获得3C认证:";
objTable.Cell(14, 1).Merge(objTable.Cell(15, 1));
objTable.Cell(14,2).Range.Font.Bold = 0000000;
objTable.Cell(14,2).Range.Font.Size = 10;
objTable.Cell(14,2).Range.Font.Name = "宋体";
objTable.Cell(14,2).Range.Text = '<% if("1".equals(data.getString("SFH3CRZ",""))){ out.print("已获得");}else if("0".equals(data.getString("SFH3CRZ"))){out.print("未获得");} %>';
objTable.Cell(14, 2).Merge(objTable.Cell(15, 2));
objTable.Cell(14,3).Range.Font.Bold = 9999998;
objTable.Cell(14,3).Range.Font.Size = 10;
objTable.Cell(14,3).Range.Font.Name = "宋体";
objTable.Cell(14,3).Range.Text = "已获得3C证书状态:";
objTable.Cell(14, 3).Merge(objTable.Cell(15, 3));
objTable.Cell(14,4).Range.Font.Bold = 9999998;
objTable.Cell(14,4).Range.Font.Size = 10;
objTable.Cell(14,4).Range.Font.Name = "宋体";
objTable.Cell(14,4).Range.Text = "有效期";
objTable.Cell(14,5).Range.Font.Bold = 0000000;
objTable.Cell(14,5).Range.Font.Size = 10;
objTable.Cell(14,5).Range.Font.Name = "宋体";
objTable.Cell(14,5).Range.Text = '<%=data.getString("YH3CYXS")%>';
//第十五行
objTable.Cell(15,4).Range.Font.Bold = 9999998;
objTable.Cell(15,4).Range.Font.Size = 10;
objTable.Cell(15,4).Range.Font.Name = "宋体";
objTable.Cell(15,4).Range.Text = "有效期";
objTable.Cell(15,5).Range.Font.Bold = 0000000;
objTable.Cell(15,5).Range.Font.Size = 10;
objTable.Cell(15,5).Range.Font.Name = "宋体";
objTable.Cell(15,5).Range.Text = '<%=data.getString("YH3CWXS")%>';
//第十六行
//objTable.Cell(9,1).Range.HorizontalAlignment = 3;
objTable.Cell(16,1).Range.Font.Bold = 9999998;
objTable.Cell(16,1).Range.Font.Size = 10;
objTable.Cell(16,1).Range.Font.Name = "宋体";
objTable.Cell(16,1).Range.Text = "3C认证获证单元:";
objTable.Cell(16, 1).Merge(objTable.Cell(17, 1));
objTable.Cell(16, 1).Merge(objTable.Cell(18, 1));
objTable.Cell(16,2).Range.Font.Bold = 9999998;
objTable.Cell(16,2).Range.Font.Size = 10;
objTable.Cell(16,2).Range.Font.Name = "宋体";
objTable.Cell(16,2).Range.Text = "应获数量:";
objTable.Cell(16,3).Range.Font.Bold = 0000000;
objTable.Cell(16,3).Range.Font.Size = 10;
objTable.Cell(16,3).Range.Font.Name = "宋体";
objTable.Cell(16,3).Range.Text = '<%=data.getString("TCYHSL")%>';
objTable.Cell(16, 3).Merge(objTable.Cell(16, 5));
//第十七行
objTable.Cell(17,2).Range.Font.Bold = 9999998;
objTable.Cell(17,2).Range.Font.Size = 10;
objTable.Cell(17,2).Range.Font.Name = "宋体";
objTable.Cell(17,2).Range.Text = "已获数量:";
objTable.Cell(17,3).Range.Font.Bold = 0000000;
objTable.Cell(17,3).Range.Font.Size = 10;
objTable.Cell(17,3).Range.Font.Name = "宋体";
objTable.Cell(17,3).Range.Text = '<%=data.getString("TCYIHSL")%>';
objTable.Cell(17, 3).Merge(objTable.Cell(17, 5));
//第十八行
objTable.Cell(18,2).Range.Font.Bold = 9999998;
objTable.Cell(18,2).Range.Font.Size = 10;
objTable.Cell(18,2).Range.Font.Name = "宋体";
objTable.Cell(18,2).Range.Text = "未获数量:";
objTable.Cell(18,3).Range.Font.Bold = 0000000;
objTable.Cell(18,3).Range.Font.Size = 10;
objTable.Cell(18,3).Range.Font.Name = "宋体";
objTable.Cell(18,3).Range.Text = '<%=data.getString("TCWHSL")%>';
objTable.Cell(18, 3).Merge(objTable.Cell(18, 5));
//第十九行
objTable.Cell(19,1).Range.Font.Bold = 9999998;
objTable.Cell(19,1).Range.Font.Size = 10;
objTable.Cell(19,1).Range.Font.Name = "宋体";
objTable.Cell(19,1).Range.Text = "其他认证项目:";
objTable.Cell(19,2).Range.Font.Bold = 0000000;
objTable.Cell(19,2).Range.Font.Size = 10;
objTable.Cell(19,2).Range.Font.Name = "宋体";
objTable.Cell(19,2).Range.Text = '<%=data.getString("QTRZXM")%>';
objTable.Cell(19,3).Range.Font.Bold = 9999998;
objTable.Cell(19,3).Range.Font.Size = 10;
objTable.Cell(19,3).Range.Font.Name = "宋体";
objTable.Cell(19,3).Range.Text = "证书编号:";
objTable.Cell(19,4).Range.Font.Bold = 0000000;
objTable.Cell(19,4).Range.Font.Size = 10;
objTable.Cell(19,4).Range.Font.Name = "宋体";
objTable.Cell(19,4).Range.Text = '<%=data.getString("ZSBH")%>';
objTable.Cell(19, 4).Merge(objTable.Cell(19, 5));
//第二十行
objTable.Cell(20,1).Range.Font.Bold = 9999998;
objTable.Cell(20,1).Range.Font.Size = 10;
objTable.Cell(20,1).Range.Font.Name = "宋体";
objTable.Cell(20,1).Range.Text = "证书有效期:";
objTable.Cell(20,2).Range.Font.Bold = 0000000;
objTable.Cell(20,2).Range.Font.Size = 10;
objTable.Cell(20,2).Range.Font.Name = "宋体";
objTable.Cell(20,2).Range.Text = '<%=data.getString("ZSYXQ")%>';
objTable.Cell(20, 2).Merge(objTable.Cell(20, 5));
//第二十一行
objTable.Cell(21,1).Range.Font.Bold = 9999998;
objTable.Cell(21,1).Range.Font.Size = 10;
objTable.Cell(21,1).Range.Font.Name = "宋体";
objTable.Cell(21,1).Range.Text = "企业生产执行标准:";
objTable.Cell(21,2).Range.Font.Bold = 0000000;
objTable.Cell(21,2).Range.Font.Size = 10;
objTable.Cell(21,2).Range.Font.Name = "宋体";
objTable.Cell(21,2).Range.Text = '<%="1".equals(data.getString("ZXBZGZBZ",""))?"国家标准 ":""%><%="1".equals(data.getString("ZXBZHYBZ",""))?"\\n行业标准 ":""%><%="1".equals(data.getString("ZXBZDFBZ",""))?"\\n地方标准 ":""%><%="1".equals(data.getString("ZXBZQYBZ",""))?"\\n企业标准 ":""%><%="1".equals(data.getString("ZXBZWB",""))?"\\n无标准 ":""%>';
objTable.Cell(21,3).Range.Font.Bold = 9999998;
objTable.Cell(21,3).Range.Font.Size = 10;
objTable.Cell(21,3).Range.Font.Name = "宋体";
objTable.Cell(21,3).Range.Text = "是否加入中国产品电子监管网:";
objTable.Cell(21,4).Range.Font.Bold = 0000000;
objTable.Cell(21,4).Range.Font.Size = 10;
objTable.Cell(21,4).Range.Font.Name = "宋体";
objTable.Cell(21,4).Range.Text = '<% if("1".equals(data.getString("SFJRZGCPDZJGW",""))){ out.print("是");}else if("0".equals(data.getString("SFJRZGCPDZJGW"))){out.print("否");} %>';
objTable.Cell(21, 4).Merge(objTable.Cell(21, 5));
//第二十二行
objTable.Cell(22,1).Range.Font.Bold = 9999998;
objTable.Cell(22,1).Range.Font.Size = 10;
objTable.Cell(22,1).Range.Font.Name = "宋体";
objTable.Cell(22,1).Range.Text = "原材料进场验收形式:";
objTable.Cell(22,2).Range.Font.Bold = 0000000;
objTable.Cell(22,2).Range.Font.Size = 10;
objTable.Cell(22,2).Range.Font.Name = "宋体";
objTable.Cell(22,2).Range.Text = '<%="1".equals(data.getString("YSXSQYZJ",""))?"企业自检 ":""%><%="1".equals(data.getString("YSXSWTQTJGJY",""))?"委托其他机构检验 ":""%><%="1".equals(data.getString("YSXSHGZMWJ",""))?"查验供货单位和各证明文件 ":""%><%="1".equals(data.getString("YSXXXSBG",""))?"不进行任何形式的把关":""%>';
objTable.Cell(22, 2).Merge(objTable.Cell(22, 5));
//第二十三行
objTable.Cell(23,1).Range.Font.Bold = 9999998;
objTable.Cell(23,1).Range.Font.Size = 10;
objTable.Cell(23,1).Range.Font.Name = "宋体";
objTable.Cell(23,1).Range.Text = "产品出厂检验方式:";
objTable.Cell(23,2).Range.Font.Bold = 0000000;
objTable.Cell(23,2).Range.Font.Size = 10;
objTable.Cell(23,2).Range.Font.Name = "宋体";
objTable.Cell(23,2).Range.Text = '<%="1".equals(data.getString("JYFSWTQTJGJY",""))?"委托其他机构检验 ":""%><%="1".equals(data.getString("JYFSQYZJ",""))?"企业自检 ":""%><%="1".equals(data.getString("JYFSBFZJ",""))?"部分自检 ":""%><%="1".equals(data.getString("JYFSCCJY",""))?"出厂检验":""%>';
objTable.Cell(23, 2).Merge(objTable.Cell(23, 5));
//第二十四行
objTable.Cell(24,1).Range.Font.Bold = 9999998;
objTable.Cell(24,1).Range.Font.Size = 10;
objTable.Cell(24,1).Range.Font.Name = "宋体";
objTable.Cell(24,1).Range.Text = "是否名牌产品生产企业:";
objTable.Cell(24,2).Range.Font.Bold = 0000000;
objTable.Cell(24,2).Range.Font.Size = 10;
objTable.Cell(24,2).Range.Font.Name = "宋体";
objTable.Cell(24,2).Range.Text = '<%="1".equals(data.getString("GJMP",""))?"国家名牌 ":""%><%="1".equals(data.getString("SMP",""))?"省名牌 ":""%><%="1".equals(data.getString("QTMP",""))?"其他":""%>';
objTable.Cell(24, 2).Merge(objTable.Cell(24, 5));
//第二十五行
objTable.Cell(25,1).Range.Font.Bold = 9999998;
objTable.Cell(25,1).Range.Font.Size = 10;
objTable.Cell(25,1).Range.Font.Name = "宋体";
objTable.Cell(25,1).Range.Text = "产品信息";
objTable.Cell(25, 1).Merge(objTable.Cell(25, 5));
objTable.Cell(25,1).Height = 18;
//第二十六行
objTable.Cell(26,1).Range.Font.Bold = 9999998;
objTable.Cell(26,1).Range.Font.Size = 10;
objTable.Cell(26,1).Range.Font.Name = "宋体";
objTable.Cell(26,1).Range.Text = "产品类别";
objTable.Cell(26, 1).Merge(objTable.Cell(26,2));
objTable.Cell(26,2).Range.Font.Bold = 9999998;
objTable.Cell(26,2).Range.Font.Size = 10;
objTable.Cell(26,2).Range.Font.Name = "宋体";
objTable.Cell(26,2).Range.Text = "产品名称";
objTable.Cell(26, 2).Merge(objTable.Cell(26,4));
//第二十七行
<%
if( y ==0){
map.put("无","");
}
System.out.println("map="+y);
y = map.size();
for (int o=0;o<y;o++){
Iterator it = map.keySet().iterator();
String cplb = (String)it.next();
String cpmc =(String)map.get(cplb);;
%>
objTable.Rows.add(objTable.Cell(27,2));
objTable.Rows.add(objTable.Cell(27,2));
objTable.Cell(<%=27+o%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=27+o%>,1).Range.Font.Size = 10;
objTable.Cell(<%=27+o%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=27+o%>,1).Range.Text = "<%=cplb%>";
objTable.Cell(<%=27+o%>, 1).Merge(objTable.Cell(<%=27+o%>, 2));
objTable.Cell(<%=28+o%>, 1).Merge(objTable.Cell(<%=28+o%>, 2));
objTable.Cell(<%=27+o%>, 1).Merge(objTable.Cell(<%=28+o%>, 1));
objTable.Cell(<%=27+o%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=27+o%>,2).Range.Font.Size = 10;
objTable.Cell(<%=27+o%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=27+o%>,2).Range.Text = "<%=cpmc%>";
objTable.Cell(<%=27+o%>, 2).Merge(objTable.Cell(<%=27+o%>, 4));
objTable.Cell(<%=28+o%>, 2).Merge(objTable.Cell(<%=28+o%>, 4));
objTable.Cell(<%=27+o%>, 2).Merge(objTable.Cell(<%=28+o%>, 2));
<% }%>
u=<%=y%>;
//alert("u="+u);
//第二十八行
/* objTable.Cell(<%=28-1+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=28-1+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=28-1+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=28-1+y%>,1).Range.Text = "数据库字段";
objTable.Cell(<%=28-1+y%>, 1).Merge(objTable.Cell(<%=28-1+y%>, 2));
objTable.Cell(<%=28-1+y%>,2).Range.Font.Bold = 9999998;
objTable.Cell(<%=28-1+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=28-1+y%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=28-1+y%>,2).Range.Text = "数据库字段";
objTable.Cell(<%=28-1+y%>, 2).Merge(objTable.Cell(<%=28-1+y%>, 4));*/
//第二十九行
objTable.Cell(<%=27+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=27+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=27+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=27+y%>,1).Range.Text = "经济类型:";
objTable.Cell(<%=27+y%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=27+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=27+y%>,2).Range.Font.Name = "宋体";
<%
String jjlx = data.getString("JJLX","");
String jjlxmc = "";
if("1".equals(jjlx)){
jjlxmc = "国有";
}else if("2".equals(jjlx)){
jjlxmc = "个体";
}else if("3".equals(jjlx)){
jjlxmc = "集体";
}else if("4".equals(jjlx)){
jjlxmc = "股份";
}else if("5".equals(jjlx)){
jjlxmc = "私营";
}else if("6".equals(jjlx)){
jjlxmc = "三资";
}else if("7".equals(jjlx)){
jjlxmc = "其他";
}
%>
objTable.Cell(<%=27+y%>,2).Range.Text = '<%=jjlxmc%>';
objTable.Cell(<%=27+y%>, 2).Merge(objTable.Cell(<%=27+y%>, 5));
//第三十行
<%
String qysczk = data.getString("QYSCZK","");
String qysczkmc = "";
if("1".equals(qysczk)){
qysczkmc = "正常生产";
}else if("2".equals(qysczk)){
qysczkmc = "季节性停产";
}else if("3".equals(qysczk)){
qysczkmc = "停产";
}
%>
objTable.Cell(<%=28+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=28+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=28+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=28+y%>,1).Range.Text = "企业生产状况:";
objTable.Cell(<%=28+y%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=28+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=28+y%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=28+y%>,2).Range.Text = '<%=qysczkmc%>';
objTable.Cell(<%=28+y%>, 2).Merge(objTable.Cell(<%=28+y%>, 5));
//第三十一行
<%
String schqyglfl = data.getString("SCHQYGLFL","");
String schqyglflmc = "";
if("1".equals(schqyglfl)){
schqyglflmc = "A类";
}else if("2".equals(schqyglfl)){
schqyglflmc = "B类";
}else if("3".equals(schqyglfl)){
schqyglflmc = "C类";
}
%>
objTable.Cell(<%=29+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=29+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=29+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=29+y%>,1).Range.Text = "核查后企业管理分类:";
objTable.Cell(<%=29+y%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=29+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=29+y%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=29+y%>,2).Range.Text = '<%=schqyglflmc%>';
objTable.Cell(<%=29+y%>, 2).Merge(objTable.Cell(<%=29+y%>, 5));
//第三十二行
<%
String jnsjysccqk = data.getString("JNSJYSCCQK","");
String jnsjysccqkmc = "";
if("1".equals(jnsjysccqk)){
jnsjysccqkmc = "未进行过抽查";
}else if("2".equals(jnsjysccqk)){
jnsjysccqkmc = "抽查无不合格记录";
}else if("3".equals(jnsjysccqk)){
jnsjysccqkmc = "又一次不合格记录";
}else if("4".equals(jnsjysccqk)){
jnsjysccqkmc = "有两次不合格记录";
}else if("5".equals(jnsjysccqk)){
jnsjysccqkmc = "有三次不合格记录";
}
%>
objTable.Cell(<%=30+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=30+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=30+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=30+y%>,1).Range.Text = "今年市级以上抽查情况:";
objTable.Cell(<%=30+y%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=30+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=30+y%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=30+y%>,2).Range.Text = '<%=jnsjysccqkmc%>';
objTable.Cell(<%=30+y%>, 2).Merge(objTable.Cell(<%=30+y%>, 5));
//第三十三行
objTable.Cell(<%=31+y%>,1).Range.Font.Bold = 9999998;
objTable.Cell(<%=31+y%>,1).Range.Font.Size = 10;
objTable.Cell(<%=31+y%>,1).Range.Font.Name = "宋体";
objTable.Cell(<%=31+y%>,1).Range.Text = "备注:";
objTable.Cell(<%=31+y%>, 1).Merge(objTable.Cell(<%=32+y%>, 1));
objTable.Cell(<%=31+y%>,2).Range.Font.Bold = 0000000;
objTable.Cell(<%=31+y%>,2).Range.Font.Size = 10;
objTable.Cell(<%=31+y%>,2).Range.Font.Name = "宋体";
objTable.Cell(<%=31+y%>,2).Range.Text = '<%=data.getString("BZ")%>';
objTable.Cell(<%=31+y%>, 2).Merge(objTable.Cell(<%=31+y%>, 5));
objTable.Cell(<%=32+y%>, 2).Merge(objTable.Cell(<%=32+y%>, 5));
objTable.Cell(<%=31+y%>, 2).Merge(objTable.Cell(<%=32+y%>, 2));
<%} else {%>
objTable.Cell(2,2).Range.Text = '<%=data.getString("QYMC")%>';
objTable.Cell(3,2).Range.Text = '<%=Dictionary.value(dictMap,"101001",data.getString("SHI"))%><%=Dictionary.value(dictMap,"101001",data.getString("XIAN"))%><%=data.getString("SZDXXDZ")%>';
objTable.Cell(4,2).Range.Text = '<%=data.getString("FRDBHFZR")%>';
objTable.Cell(4,4).Range.Text = '<%=data.getString("QYRS")%>人';
objTable.Cell(5,2).Range.Text = '<%=data.getString("LXDH")%>';
objTable.Cell(5,4).Range.Text = '<%=data.getString("YZBM")%>';
objTable.Cell(6,2).Range.Text = '<% if("1".equals(data.getString("YYZZ",""))){ out.print("有");}else if("0".equals(data.getString("YYZZ"))){out.print("无");} %>';
objTable.Cell(6,4).Range.Text = '<%=data.getString("YYZZBH")%>';
objTable.Cell(7,2).Range.Text = '<% if("1".equals(data.getString("QYDMZ",""))){ out.print("有");}else if("0".equals(data.getString("QYDMZ"))){out.print("无");} %>';
objTable.Cell(7,4).Range.Text = '<%=data.getString("QYDMZBH")%>';
objTable.Cell(8,2).Range.Text = '<% if("1".equals(data.getString("SFHDGYCPSCXKZ",""))){ out.print("已获得");}else if("0".equals(data.getString("SFHDGYCPSCXKZ"))){out.print("未获得");}%>';
objTable.Cell(8,4).Range.Text = '<%=data.getString("GYCPSCXKZBH")%>';
objTable.Cell(9,3).Range.Text = '<%=data.getString("YHSL")%>';
objTable.Cell(10,3).Range.Text = '<%=data.getString("YHSL")%>';
objTable.Cell(11,3).Range.Text = '<%=data.getString("WHSL")%>';
objTable.Cell(12,2).Range.Text = '<% if("1".equals(data.getString("CPZLSFHDMJ",""))){ out.print("已获得");}else if("0".equals(data.getString("CPZLSFHDMJ"))){out.print("未获得");}%>';
objTable.Cell(12,4).Range.Text = '<%=data.getString("MJZSBH")%>';
objTable.Cell(13,2).Range.Text = '<%=data.getString("MJZSYXQ")%>';
objTable.Cell(14,2).Range.Text = '<% if("1".equals(data.getString("SFH3CRZ",""))){ out.print("已获得");}else if("0".equals(data.getString("SFH3CRZ"))){out.print("未获得");} %>';
objTable.Cell(14,5).Range.Text = '<%=data.getString("YH3CYXS")%>';
objTable.Cell(15,5).Range.Text = '<%=data.getString("YH3CWXS")%>';
objTable.Cell(16,3).Range.Text = '<%=data.getString("TCYHSL")%>';
objTable.Cell(17,3).Range.Text = '<%=data.getString("TCYIHSL")%>';
objTable.Cell(18,3).Range.Text = '<%=data.getString("TCWHSL")%>';
objTable.Cell(19,2).Range.Text = '<%=data.getString("QTRZXM")%>';
objTable.Cell(19,4).Range.Text = '<%=data.getString("ZSBH")%>';
objTable.Cell(20,2).Range.Text = '<%=data.getString("ZSYXQ")%>';
objTable.Cell(21,2).Range.Text = '<%="1".equals(data.getString("ZXBZGZBZ",""))?"国家标准 ":""%><%="1".equals(data.getString("ZXBZHYBZ",""))?"\\n行业标准 ":""%><%="1".equals(data.getString("ZXBZDFBZ",""))?"\\n地方标准 ":""%><%="1".equals(data.getString("ZXBZQYBZ",""))?"\\n企业标准 ":""%><%="1".equals(data.getString("ZXBZWB",""))?"\\n无标准 ":""%>';
objTable.Cell(21,4).Range.Text = '<% if("1".equals(data.getString("SFJRZGCPDZJGW",""))){ out.print("是");}else if("0".equals(data.getString("SFJRZGCPDZJGW"))){out.print("否");} %>';
objTable.Cell(22,2).Range.Text = '<%="1".equals(data.getString("YSXSQYZJ",""))?"企业自检 ":""%><%="1".equals(data.getString("YSXSWTQTJGJY",""))?"委托其他机构检验 ":""%><%="1".equals(data.getString("YSXSHGZMWJ",""))?"查验供货单位和各证明文件 ":""%><%="1".equals(data.getString("YSXXXSBG",""))?"不进行任何形式的把关":""%>';
objTable.Cell(23,2).Range.Text = '<%="1".equals(data.getString("JYFSWTQTJGJY",""))?"委托其他机构检验 ":""%><%="1".equals(data.getString("JYFSQYZJ",""))?"企业自检 ":""%><%="1".equals(data.getString("JYFSBFZJ",""))?"部分自检 ":""%><%="1".equals(data.getString("JYFSCCJY",""))?"出厂检验":""%>';
objTable.Cell(24,2).Range.Text = '<%="1".equals(data.getString("GJMP",""))?"国家名牌 ":""%><%="1".equals(data.getString("SMP",""))?"省名牌 ":""%><%="1".equals(data.getString("QTMP",""))?"其他":""%>';
//alert("u="+u);
if(u != 1){
objTable.Cell(27, 1).Merge(objTable.Cell(26+u, 1));
objTable.Cell(27, 2).Merge(objTable.Cell(26+u, 2));
objTable.Cell(27,1).Height = 30;
}
<%
if( y ==0){
map.put("无","");
}
y = map.size();
for (int o=0;o<y;o++){
Iterator it = map.keySet().iterator();
String cplb = (String)it.next();
String cpmc =(String)map.get(cplb);;
%>
if( <%=y%>>1 && o < <%=y%>-1 )
objTable.Rows.add(objTable.Cell(27,2));
objTable.Cell(<%=27+o%>,1).Range.Text = "<%=cplb%>";
objTable.Cell(<%=27+o%>,2).Range.Text = "<%=cpmc%>";
<%}%>
u=<%=y%>;
<%
String jjlx = data.getString("JJLX","");
String jjlxmc = "";
if("1".equals(jjlx)){
jjlxmc = "国有";
}else if("2".equals(jjlx)){
jjlxmc = "个体";
}else if("3".equals(jjlx)){
jjlxmc = "集体";
}else if("4".equals(jjlx)){
jjlxmc = "股份";
}else if("5".equals(jjlx)){
jjlxmc = "私营";
}else if("6".equals(jjlx)){
jjlxmc = "三资";
}else if("7".equals(jjlx)){
jjlxmc = "其他";
}
%>
objTable.Cell(<%=27+y%>,2).Range.Text = '<%=jjlxmc%>';
<%
String qysczk = data.getString("QYSCZK","");
String qysczkmc = "";
if("1".equals(qysczk)){
qysczkmc = "正常生产";
}else if("2".equals(qysczk)){
qysczk