📄 excel.jsp
字号:
{
shipname =rsc.getString("shname");
}
blno =rsP.getString("blno");
add1 =rsP.getString("add1");
add2 =rsP.getString("add2");
weight =rss.getString("islbs").trim()=="0"?"LBS":"KGS";
if(uaccess=="1")
{
hline1a="";
hline1 = cname +" P I C K I N G L I S T" + " DATE: " + d_shipdt;
hline3 = "TO: " + shipname +"Route:"+ geocode +"PICK LIST: "+ blno;
}else
{
hline1a=cISO;
hline1 = cname +" P I C K I N G L I S T" + " DATE: " + d_shipdt;
hline3 = "TO: " + shipname +"BOL: "+ blno;
}
if(plant=="FERG")
{
hline2 = "FERGUS, ONTARIO";
}else
{
hline2 = "RICHMOND HILL, ONTARIO";
}
hline31=c_wname;
hline4 =add1;
hline5 =add2 +"** Weight in " +weight + " **";
HSSFRow r1=sheet.createRow(i +0);
HSSFCell r1c1=r1.createCell((short)0);
r1c1.setCellValue(hline1a);
HSSFRow r2=sheet.createRow(i +1);
HSSFCell r1c2=r2.createCell((short)0);
r1c2.setCellValue(hline1);
HSSFRow r3=sheet.createRow(i +2);
HSSFCell r1c3=r3.createCell((short)0);
r1c3.setCellValue(hline2);
HSSFRow r4=sheet.createRow(i +3);
HSSFCell r1c4=r4.createCell((short)0);
r1c4.setCellValue(hline3);
HSSFRow r5=sheet.createRow(i +4);
HSSFCell r1c5=r5.createCell((short)0);
r1c5.setCellValue(hline4);
HSSFRow r6=sheet.createRow(i +5);
HSSFCell r1c6=r6.createCell((short)0);
r1c6.setCellValue(hline5);
HSSFRow r7=sheet.createRow(i +6);
HSSFRow r8=sheet.createRow(i +7);
}
}
%>
<% HSSFSheet sheet3 = book.createSheet("Certificate");
if(!Certificate.equals("") )
{
String cname="";
String cncity="";
String cnprovst="";
String alloy="";
String cnadd1="";
String country="";
String name="";
String custpo="";
String bladd1="";
String millspec="";
String bladd2="";
String blcity="";
String blprovst="";
String worksno="";
String blcountry="";
String blpcode="";
String shipdt="";
String net="";
String islbs="";
String isimperial="";
String width="";
String gauge="";
String mt_width="";
String mt_gauge="";
String temper="";
String custprod="";
String custspec="";
String plant="";
ASResultSet rsg=Sqlca.getASResultSet("select * from global");
if(rsg.next() )
{
cname=rsg.getString("cnconame");
cncity=rsg.getString("cncity");
cnprovst=rsg.getString("cnprovst");
cnadd1=rsg.getString("cnadd1");
plant=rsg.getString("plant");
}
ASResultSet rss=Sqlca.getASResultSet("select * from shipment where blno =" +BLNO );
if(rss.next() )
{
alloy=rss.getString("alloy");
custpo=rss.getString("custpo");
worksno=rss.getString("worksno");
shipdt=rss.getString("shipdt");
net=rss.getString("net");
islbs =rss.getString("islbs");
}
ASResultSet rsc= Sqlca.getASResultSet("select * from customer where account='"+rss.getString("account") + "' and subacct='"+rss.getString("subacct")+"'");
if(rsc.next() )
{
country =rsc.getString("country");
name =rsc.getString("name");
blcity=rsc.getString("blcity");
blprovst=rsc.getString("blprovst");
blcountry=rsc.getString("blcountry");
blpcode=rsc.getString("blpcode");
isimperial=rsc.getString("isimperial");
}
ASResultSet rsi=Sqlca.getASResultSet("select * from invoice where blno="+BLNO );
if(rsi.next() )
{
bladd1 =rsi.getString("bladd1");
bladd2 =rsi.getString("bladd2");
}
ASResultSet rso=Sqlca.getASResultSet("select * from ord_item where worksno='"+worksno+"'" );
if(rso.next() )
{
millspec =rso.getString("millspec");
gauge =rso.getString("gauge");
width =rso.getString("width");
mt_gauge=rso.getString("mt_gauge");
mt_width=rso.getString("mt_width");
temper=rso.getString("temper");
alloy=rso.getString("alloy");
custprod=rso.getString("custprod");
custspec=rso.getString("custspec");
}
if(!(StringUtils.copper(alloy) || StringUtils.brass(alloy)))
{
out.print("<script>alert(''Alloy is neither brass or copper, unable to produce certificate.'');</script>");
return;
}
for (int i=0;i<Integer.parseInt(Certificate);i++ )
{
HSSFRow r1=sheet.createRow(i +0);
HSSFCell r1c1=r1.createCell((short)0);
r1c1.setCellValue("WOLVERINE RATCLIFFS "+cname);
HSSFRow r2=sheet.createRow(i +1);
HSSFCell r1c2=r2.createCell((short)0);
r1c2.setCellValue(cnadd1);
HSSFRow r3=sheet.createRow(i +2);
HSSFCell r1c3=r3.createCell((short)0);
r1c3.setCellValue(cncity +" "+ cnprovst);
HSSFRow r4=sheet.createRow(i +3);
HSSFCell r1c4=r4.createCell((short)0);
r1c4.setCellValue("CANADA");
if(country=="O")
{
HSSFRow r5=sheet.createRow(i + 4);
HSSFCell r1c5=r5.createCell((short)0);
r1c5.setCellValue(" ANALYSIS CERTIFICATE");
}
else {
HSSFRow r5=sheet.createRow(i + 4);
HSSFCell r1c5=r5.createCell((short)0);
r1c5.setCellValue(" CERTIFICATE OF COMPLIANCE ");
}
HSSFRow r6=sheet.createRow(i + 5);
HSSFCell r1c6=r6.createCell((short)0);
r1c6.setCellValue(" Customer: ");
HSSFRow r7=sheet.createRow(i + 6);
HSSFCell r1c7=r6.createCell((short)0);
r1c6.setCellValue(name + "Customer PO: "+ custpo);
HSSFRow r8=sheet.createRow(i + 7);
HSSFCell r1c8=r8.createCell((short)0);
r1c8.setCellValue(bladd1 +"Mill Spec: "+ millspec);
if(bladd2!=null)
{ HSSFRow r9=sheet.createRow(i + 8);
HSSFCell r1c9=r9.createCell((short)0);
r1c9.setCellValue(bladd2);
}
HSSFRow r10=sheet.createRow(i + 9);
HSSFCell r1c10=r10.createCell((short)0);
r1c10.setCellValue(blcity +","+blprovst +" Works Order: "+worksno );
HSSFRow r11=sheet.createRow(i + 10);
HSSFCell r1c11=r11.createCell((short)0);
r1c11.setCellValue(blcountry +" "+ blpcode );
HSSFRow r12=sheet.createRow(i + 11);
HSSFCell r1c12=r12.createCell((short)0);
r1c12.setCellValue("Ship Date: "+shipdt.substring(0,10) );
HSSFRow r13=sheet.createRow(i + 12);
HSSFCell r1c13=r13.createCell((short)0);
r1c13.setCellValue("Quantity Width Gauge Temper Alloy Part # and Spec. #");
HSSFRow r14=sheet.createRow(i + 13);
HSSFCell r1c14=r14.createCell((short)0);
r1c14.setCellValue(net+ islbs=="0"?"LBS":"Kg." );
if(isimperial=="0")
{ HSSFRow r15=sheet.createRow(i + 14);
HSSFCell r1c15=r15.createCell((short)0);
r1c15.setCellValue(width +" "+ gauge );
} else
{ HSSFRow r15=sheet.createRow(i + 14);
HSSFCell r1c15=r15.createCell((short)0);
r1c15.setCellValue(mt_width.substring(7,10) +"mm "+ mt_gauge.substring(7,10) +"mm");
}
HSSFRow r16=sheet.createRow(i + 15);
HSSFCell r1c16=r16.createCell((short)0);
r1c16.setCellValue(temper +" "+alloy + " "+custprod +" "+custspec);
if(islbs=="0")
{ HSSFRow r17=sheet.createRow(i + 16);
HSSFCell r1c17=r17.createCell((short)0);
r1c17.setCellValue(Double.valueOf(net).doubleValue() /2.2046 +"Kg.");
}else
{ HSSFRow r17=sheet.createRow(i + 16);
HSSFCell r1c17=r17.createCell((short)0);
r1c17.setCellValue(Double.valueOf(net).doubleValue() /2.2046 +"LBS.");
}
if(isimperial=="0")
{ HSSFRow r18=sheet.createRow(i + 17);
HSSFCell r1c18=r18.createCell((short)0);
r1c18.setCellValue(mt_width.substring(7,10) +"mm "+ mt_gauge.substring(7,10) +"mm");
} else
{ HSSFRow r18=sheet.createRow(i + 17);
HSSFCell r1c18=r18.createCell((short)0);
r1c18.setCellValue(width +" "+ gauge);
}
HSSFRow r19=sheet.createRow(i + 18);
HSSFCell r1c19=r19.createCell((short)0);
r1c19.setCellValue("Nominal composition %: ");
if(alloy=="14415")
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue(" Cu 99.9 Sn .10");
} else
if(alloy=="14420")
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu RMD Te .010 Sn .060");
} else
if(alloy=="14300")
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue(" Cu 99.90 RMD P .006 Cd .080");
} else
if(alloy.indexOf("11000 C1100")>0)
{HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue(" Cu 100");
}else
if(alloy.indexOf("26000 27000")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue(" Cu 70 Zn 30");
} else
if(alloy.indexOf("26120")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 69.9 Zn 30 P .030");
}else
if(alloy.indexOf("26130")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue(" Cu 69.9 Zn 30 P .030");
}else
if(alloy.indexOf("27130")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 64.9 Zn 30 As .030");
} else
if(alloy.indexOf("23000")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 85 Zn 15");
} else
if(alloy.indexOf("24000")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 80 Zn 20");
} else
if(alloy.indexOf("22000")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 90 Zn 10");
} else
if(alloy.indexOf("12200")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu 99.90 RMD P .025");
}else
if(alloy.indexOf("C1400")>0)
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("Cu RMD Pb Max .020 Fe .02 Sn 1.2-2.0 Zn 2.0-4.0 P .001-.02");
}
else
{ HSSFRow r20=sheet.createRow(i + 19);
HSSFCell r1c20=r20.createCell((short)0);
r1c20.setCellValue("*UNKNOWN*");
}
HSSFRow r21=sheet.createRow(i + 20);
HSSFCell r1c21=r21.createCell((short)0);
r1c21.setCellValue("We certify that the material identified above has been tested and found");
HSSFRow r22=sheet.createRow(i + 21);
HSSFCell r1c22=r22.createCell((short)0);
r1c22.setCellValue("to be in compliance with your specification.");
HSSFRow r23=sheet.createRow(i + 22);
HSSFCell r1c23=r23.createCell((short)0);
r1c23.setCellValue("Thank you for your order.");
if(plant=="HILL")
{ HSSFRow r24=sheet.createRow(i + 23);
HSSFCell r1c24=r24.createCell((short)0);
r1c24.setCellValue("Al Lewis");
HSSFRow r25=sheet.createRow(i + 24);
HSSFCell r1c25=r25.createCell((short)0);
r1c25.setCellValue("Quality Assurance Coordinator");
} else
{ HSSFRow r24=sheet.createRow(i + 23);
HSSFCell r1c24=r24.createCell((short)0);
r1c24.setCellValue("WOLVERINE RATCLIFFS INC.");
}
HSSFRow r25=sheet.createRow(i + 24);
HSSFRow r26=sheet.createRow(i + 25);
HSSFRow r27=sheet.createRow(i + 26);
}
}
%>
<%
book.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
%>
<%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -