📄 plantotalaction.java
字号:
/* 创建日期：Dec 17, 2006
* 作 者：朱 闰
* 公 司：安徽通途信息技术有限公司
*/
package com.tongtu.Action.planManage;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.tongtu.Action.TopBaseAction;
import com.tongtu.Form.QueryForm;
import com.tongtu.util.City;
import com.tongtu.util.CurrentUser;
import com.tongtu.util.EnToChin;
import com.tongtu.util.Page;
import com.tongtu.util.PlanDetail;
import com.tongtu.util.QueryStr;
import com.tongtu.util.TotalDetail;
import com.tongtu.util.TotalInfo;
import com.tongtu.util.UserInfo;
public class PlanTotalAction extends TopBaseAction
{
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest httpServletRequest,
HttpServletResponse httpServletResponse) {
ActionErrors errors = new ActionErrors();
QueryForm form = (QueryForm) actionForm;
HttpSession session = httpServletRequest.getSession();
QueryStr qs = new QueryStr(); //查询条件
if (form.getCity() != null)
{
qs.setCity(form.getCity());
}
if (form.getCounty() !=null)
qs.setCounty(form.getCounty());
if (form.getEndTimeFrom()!=null&& form.getEndTimeFrom().length()>0)
qs.setEndTimeFrom(form.getEndTimeFrom());
if (form.getEndTimeTo()!=null && form.getEndTimeTo().length()>0)
qs.setEndTimeTo(form.getEndTimeTo());
if (form.getMilemeter()!=null && form.getMilemeter().length()>0)
qs.setMilemeter(form.getMilemeter());
else
qs.setMilemeter(null);
qs.setMileStr(form.getMileStr());
qs.setPlanType(form.getPlanType());
qs.setProStr(form.getProStr());
if (form.getProvinceSubsidy()!=null && form.getProvinceSubsidy().length()>0)
qs.setProvinceSubsidy(form.getProvinceSubsidy());
else
qs.setProvinceSubsidy(null);
if (form.getStartTimeFrom()!=null&& form.getStartTimeFrom().length()>0)
qs.setStartTimeFrom(form.getStartTimeFrom());
if (form.getStartTimeTo()!=null && form.getStartTimeTo().length()>0)
qs.setStartTimeTo(form.getStartTimeTo());
if (form.getTownName()!=null)
qs.setTownName(EnToChin.native2unicode(form.getTownName()));
if (form.getVillageName()!=null)
qs.setVillageName(EnToChin.native2unicode(form.getVillageName()));
//行政村类型
String villageList[]=httpServletRequest.getParameterValues("checkbox");
qs.setVillageType(villageList);
//查询结果
String resultList[]=httpServletRequest.getParameterValues("checkbox2");
if (resultList != null)
qs.setResultStr(resultList);
qs.setJhlx(form.getJhlx());
qs.setJsxz(form.getJsxz());
qs.setZyjsnr(form.getZyjsnr());
qs.setZtzStr(form.getZtzStr());
qs.setJhyear(form.getJhyear());
if (form.getJhztz()!=null && form.getJhztz().length()>0)
qs.setJhztz(form.getJhztz());
else
qs.setJhztz(null);
qs.setMileType(1);
qs.setProType(1);
qs.setLjkdType(1);
qs.setLmkdType(1);
qs.setInvestType(1);
qs.setStartType(2);
qs.setEndType(2);
String startTmp = httpServletRequest.getParameter("start");//获取首页的
int start = 0,count = CurrentUser.rowCount,pagenum=0;
if(startTmp!=null){
start = Integer.parseInt(startTmp);
}
// HttpSession session = httpServletRequest.getSession();
UserInfo user = (UserInfo) session.getAttribute("curuser");
List townAndVillageList = new ArrayList();
List totalList = new ArrayList();
List cityList = new ArrayList();
List allCountyList = new ArrayList();
List allTownList = new ArrayList();
int villageCount = 0;
String cityCode = "";
String cityName = "";
String countyCode = "";
String countyName = "";
int totalType = form.getTotalType();
if (totalType == 2){
List cityInfo = new ArrayList();
List xianList = new ArrayList();
if (form.getCounty().equals("0")){
if (form.getCity().equals("0")){ //全省汇总
List pro = new ArrayList();
TotalDetail proTd = new TotalDetail();
List proList = getPlanHelper().getPlanInfoByPlantype(qs,"34");
for (int p = 0 ; proList!=null&& p<proList.size();p++){
TotalInfo ti = (TotalInfo)proList.get(p);
if (ti.getPlanType() == 1){
proTd.setJhlc1(ti.getJhlc());
proTd.setJhsbe1(ti.getJhsbe());
proTd.setJhtze1(ti.getJhtze());
proTd.setJhzytz1(ti.getJhzytz());
proTd.setJhzczj1(ti.getJhzczj());
}else if (ti.getPlanType() == 2){
proTd.setJhlc2(ti.getJhlc());
proTd.setJhsbe2(ti.getJhsbe());
proTd.setJhtze2(ti.getJhtze());
proTd.setJhzytz2(ti.getJhzytz());
proTd.setJhzczj2(ti.getJhzczj());
}else if (ti.getPlanType() == 3){
proTd.setJhlc3(ti.getJhlc());
proTd.setJhsbe3(ti.getJhsbe());
proTd.setJhtze3(ti.getJhtze());
proTd.setJhzytz3(ti.getJhzytz());
proTd.setJhzczj3(ti.getJhzczj());
}else {
proTd.setJhlc4(ti.getJhlc());
proTd.setJhsbe4(ti.getJhsbe());
proTd.setJhtze4(ti.getJhtze());
proTd.setJhzytz4(ti.getJhzytz());
proTd.setJhzczj4(ti.getJhzczj());
}
}
pro.add("安徽省");
pro.add(proTd);
cityInfo.add(pro);
totalList.add(pro);
}
List tempList = getPlanHelper().getGroupByPlanList(qs, 2,"34");
for (int i= 0; tempList!=null&&i<tempList.size();i++){
TotalDetail citytd = new TotalDetail();
List temp = new ArrayList();
PlanDetail pd = (PlanDetail)tempList.get(i);
cityCode = pd.getTownsId().substring(0,4)+"00000000";
cityName = City.getCityNameByNum(cityCode);
List cityTotal = getPlanHelper().getPlanInfoByPlantype(qs, pd.getTownsId().substring(0,4));
temp.add(cityName);
for (int m = 0 ; cityTotal!=null&& m<cityTotal.size();m++){
TotalInfo ti = (TotalInfo)cityTotal.get(m);
if (ti.getPlanType() == 1){
citytd.setJhlc1(ti.getJhlc());
citytd.setJhsbe1(ti.getJhsbe());
citytd.setJhtze1(ti.getJhtze());
citytd.setJhzytz1(ti.getJhzytz());
citytd.setJhzczj1(ti.getJhzczj());
}else if (ti.getPlanType() == 2){
citytd.setJhlc2(ti.getJhlc());
citytd.setJhsbe2(ti.getJhsbe());
citytd.setJhtze2(ti.getJhtze());
citytd.setJhzytz2(ti.getJhzytz());
citytd.setJhzczj2(ti.getJhzczj());
}else if (ti.getPlanType() == 3){
citytd.setJhlc3(ti.getJhlc());
citytd.setJhsbe3(ti.getJhsbe());
citytd.setJhtze3(ti.getJhtze());
citytd.setJhzytz3(ti.getJhzytz());
citytd.setJhzczj3(ti.getJhzczj());
}else {
citytd.setJhlc4(ti.getJhlc());
citytd.setJhsbe4(ti.getJhsbe());
citytd.setJhtze4(ti.getJhtze());
citytd.setJhzytz4(ti.getJhzytz());
citytd.setJhzczj4(ti.getJhzczj());
}
}
temp.add(citytd);
cityInfo.add(temp);
totalList.add(temp);
List countyList = getPlanHelper().getGroupByPlanList(qs, 3,pd.getTownsId().substring(0,4));
for (int j = 0; countyList!=null&& j<countyList.size();j++){
List temp2 = new ArrayList();
List temp3 = new ArrayList();
PlanDetail pd1 = (PlanDetail)countyList.get(j);
countyCode = pd1.getTownsId().substring(0,6)+"000000";
countyName = getUserHelper().getCountyNameByCode(countyCode);
TotalDetail td = new TotalDetail();
List countyTotal = getPlanHelper().getPlanInfoByPlantype(qs, pd1.getTownsId().substring(0,6));
for (int n=0;countyTotal!=null&&n<countyTotal.size();n++){
TotalInfo ti = (TotalInfo)countyTotal.get(n);
if (ti.getPlanType() == 1){
td.setJhlc1(ti.getJhlc());
td.setJhsbe1(ti.getJhsbe());
td.setJhtze1(ti.getJhtze());
td.setJhzytz1(ti.getJhzytz());
td.setJhzczj1(ti.getJhzczj());
}else if (ti.getPlanType() == 2){
td.setJhlc2(ti.getJhlc());
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -