📄 downtable1action.java
字号:
rowS.add("国家贫困县");
rowS.add("少数民族地区");
rowS.add("革命老区");
rowS.add("");
rowS.add("");
rowS.add("合计");
rowS.add("二级");
rowS.add("三级");
rowS.add("四级");
rowS.add("等外路");
rowS.add("桥梁");
rowS.add("开工年");
rowS.add("完工年");
rowS.add("");
rowS.add("");
rowS.add("");
rowS.add("合计");
rowS.add("省投资国购税");
rowS.add("地方自筹");
rowS.add("国内贷款");
rowS.add("主要建设内容");
rowS.add("");
rowS.add("");
rowS.add("");
rowS.add("");
tableContentS.add(rowS);
int typeId = Integer.parseInt(tabletype);
List planList = new ArrayList();//国家计划
List proPlanList = new ArrayList();//省计划
if (typeId == 1){
planList = getPlanHelper().getPlanListByCode(code,1); //根据编码取国家计划列表
proPlanList = getPlanHelper().getPlanListByCode(code,2); //根据编码取省计划列表
}else {
QueryStr qs =(QueryStr)session.getAttribute("queryStr");
qs.setJhlx(1);
planList = getPlanHelper().getAllPlanList(qs); //获取所有国家计划列表
qs.setJhlx(2);
proPlanList = getPlanHelper().getAllPlanList(qs); //获取所有省计划列表
}
try {
String planType = "";
String villageType = "";
int count = planList.size();
System.out.println("=============国家计划个数===" + count);
//国家计划头
Label labelC1 = new jxl.write.Label(0, 0, (String) "2006年农村公路改造工程实施计划表(国家计划)", headFc);
ws.addCell(labelC1);
for (int i = 0; i < tableContent.size(); i++) {
ArrayList row1 = (ArrayList) tableContent.get(i);
for (int j = 0; j < row1.size(); j++) {
Label labelC = new jxl.write.Label(j, i+4, (String) row1.get(j), wcfFC);
ws.addCell(labelC);
}
}
//省计划表格头
Label labelC2 = new jxl.write.Label(0, 0, (String) "2006年农村公路改造工程实施计划表(省计划)", headFc);
wss.addCell(labelC2);
for (int i = 0; i < tableContentS.size(); i++) {
ArrayList row1 = (ArrayList) tableContentS.get(i);
for (int j = 0; j < row1.size(); j++) {
Label labelC = new jxl.write.Label(j, i+4, (String) row1.get(j), wcfFC);
wss.addCell(labelC);
}
}
//国家计划
for (int i = 0; planList!= null && i < count;i++){
PlanDetail plan = (PlanDetail)planList.get(i);
String isPKX = "";
String isMZDQ = "";
String isGMLQ = "";
if (plan.getIsPKX() == 1) isPKX="√";
if (plan.getIsMZDQ() == 1) isMZDQ="√";
if (plan.getIsGMLQ() == 1) isGMLQ="√";
String jsxz = "";
if (plan.getJsxz() == 1) jsxz= "新建";
if (plan.getJsxz() == 2) jsxz= "改善";
if (plan.getJsxz() == 3) jsxz= "改造";
String zyjsnr = "";
if (plan.getZyjsnr() == 1) zyjsnr = "路面新建";
if (plan.getZyjsnr() == 2) zyjsnr = "路面改善";
if (plan.getZyjsnr() == 3) zyjsnr = "路面改建";
row = new ArrayList(); //表格内容行
row.add("安徽省");
row.add(plan.getCityName());
row.add(plan.getCountyName());
row.add(isPKX);
row.add(isMZDQ);
row.add(isGMLQ);
row.add(plan.getRoadName());
row.add(jsxz);
row.add(plan.getMilemeter()+"");
row.add("");
row.add("");
row.add(plan.getMilemeter()+"");
row.add("");
row.add(plan.getQl());
row.add(plan.getStartTime());
row.add(plan.getEndTime());
row.add(plan.getInvest() + "");
row.add(plan.getZytz()+"");
row.add(plan.getLjwctz()+"");
double hj = plan.getZytzcgs() + plan.getSsqzc(); //合计(中央车
row.add(hj+"");
row.add(plan.getZytzcgs()+"");
row.add(plan.getZygz()+"");
row.add(plan.getSsqzc()+"");
row.add(plan.getGndk()+"");
row.add(zyjsnr);
row.add(plan.getTxzmc());
row.add(plan.getTjzcmc());
row.add(plan.getQqgzjz());
row.add(plan.getNote());
for (int j = 0; j < row.size(); j++) {
if (j == 8 || j == 11 || (j >= 16 && j <=23))
continue;
Label labelC = new jxl.write.Label(j, i+6, (String) row.get(j), wcfFC);
ws.addCell(labelC);
}
jxl.write.Number labelNF8 = new jxl.write.Number(8, i+6, plan.getMilemeter(), wcfNF);
ws.addCell(labelNF8);
jxl.write.Number labelNF11 = new jxl.write.Number(11, i+6, plan.getMilemeter(), wcfNF);
ws.addCell(labelNF11);
jxl.write.Number labelNF16 = new jxl.write.Number(16, i+6, plan.getInvest(), wcfNF);
ws.addCell(labelNF16);
jxl.write.Number labelNF17 = new jxl.write.Number(17, i+6, plan.getZytz(), wcfNF);
ws.addCell(labelNF17);
jxl.write.Number labelNF18 = new jxl.write.Number(18, i+6, plan.getLjwctz(), wcfNF);
ws.addCell(labelNF18);
jxl.write.Number labelNF19 = new jxl.write.Number(19, i+6, hj, wcfNF);
ws.addCell(labelNF19);
jxl.write.Number labelNF20 = new jxl.write.Number(20, i+6, plan.getZytzcgs(), wcfNF);
ws.addCell(labelNF20);
jxl.write.Number labelNF21 = new jxl.write.Number(21, i+6, plan.getZygz(), wcfNF);
ws.addCell(labelNF21);
jxl.write.Number labelNF22 = new jxl.write.Number(22, i+6, plan.getSsqzc(), wcfNF);
ws.addCell(labelNF22);
jxl.write.Number labelNF23 = new jxl.write.Number(23, i+6, plan.getGndk(), wcfNF);
ws.addCell(labelNF23);
}
//省计划
count = proPlanList.size();
System.out.println("=============省计划个数===" + count);
for (int i = 0; proPlanList!= null && i < count;i++){
PlanDetail plan = (PlanDetail)proPlanList.get(i);
String isPKX = "";
String isMZDQ = "";
String isGMLQ = "";
if (plan.getIsPKX() == 1) isPKX="√";
if (plan.getIsMZDQ() == 1) isMZDQ="√";
if (plan.getIsGMLQ() == 1) isGMLQ="√";
String jsxz = "";
if (plan.getJsxz() == 1) jsxz= "新建";
if (plan.getJsxz() == 2) jsxz= "改善";
if (plan.getJsxz() == 3) jsxz= "改造";
String zyjsnr = "";
if (plan.getZyjsnr() == 1) zyjsnr = "路面新建";
if (plan.getZyjsnr() == 2) zyjsnr = "路面改善";
if (plan.getZyjsnr() == 3) zyjsnr = "路面改建";
row = new ArrayList(); //表格内容行
row.add("安徽省");
row.add(plan.getCityName());
row.add(plan.getCountyName());
row.add(isPKX);
row.add(isMZDQ);
row.add(isGMLQ);
row.add(plan.getRoadName());
row.add(jsxz);
row.add(plan.getMilemeter()+"");
row.add("");
row.add("");
row.add(plan.getMilemeter()+"");
row.add("");
row.add(plan.getQl());
row.add(plan.getStartTime());
row.add(plan.getEndTime());
row.add(plan.getInvest() + "");
row.add(plan.getZytz()+"");
row.add(plan.getLjwctz()+"");
double hj = plan.getProvinceSubsidy() + plan.getSsqzc(); //合计(中央车
row.add(hj+"");
row.add(plan.getProvinceSubsidy()+"");
row.add(plan.getSsqzc()+"");
row.add(plan.getGndk()+"");
row.add(zyjsnr);
row.add(plan.getTxzmc());
row.add(plan.getTjzcmc());
row.add(plan.getQqgzjz());
row.add(plan.getNote());
for (int j = 0; j < row.size(); j++) {
if (j == 8 || j == 11 || (j >= 16 && j <=22))
continue;
Label labelC = new jxl.write.Label(j, i+6, (String) row.get(j), wcfFC);
wss.addCell(labelC);
}
jxl.write.Number labelNF8 = new jxl.write.Number(8, i+6, plan.getMilemeter(), wcfNF);
wss.addCell(labelNF8);
jxl.write.Number labelNF11 = new jxl.write.Number(11, i+6, plan.getMilemeter(), wcfNF);
wss.addCell(labelNF11);
jxl.write.Number labelNF16 = new jxl.write.Number(16, i+6, plan.getInvest(), wcfNF);
wss.addCell(labelNF16);
jxl.write.Number labelNF17 = new jxl.write.Number(17, i+6, plan.getProvinceSubsidy(), wcfNF);
wss.addCell(labelNF17);
jxl.write.Number labelNF18 = new jxl.write.Number(18, i+6, plan.getLjwctz(), wcfNF);
wss.addCell(labelNF18);
jxl.write.Number labelNF19 = new jxl.write.Number(19, i+6, hj, wcfNF);
wss.addCell(labelNF19);
jxl.write.Number labelNF20 = new jxl.write.Number(20, i+6, plan.getProvinceSubsidy(), wcfNF);
wss.addCell(labelNF20);
jxl.write.Number labelNF22 = new jxl.write.Number(21, i+6, plan.getSsqzc(), wcfNF);
wss.addCell(labelNF22);
jxl.write.Number labelNF23 = new jxl.write.Number(22, i+6, plan.getGndk(), wcfNF);
wss.addCell(labelNF23);
}
wwb.write();
//关闭Excel工作薄对象
wwb.close();
} catch (Exception e) {
e.printStackTrace();
}
return actionMapping.findForward("refresh");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -