js 操作word

<%@ 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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值