《鸿信四级穿透预算管理体系平台系统V10软件源程序代码.docx》由会员分享，可在线阅读，更多相关《鸿信四级穿透预算管理体系平台系统V10软件源程序代码.docx（120页珍藏版）》请在三一办公上搜索。
1、120鸿信四级穿透预算管理体系平台系统V1.0 鸿信四级穿透预算管理体系平台系统V1.0源代码江苏鸿信系统集成有限公司2012年8月RptInfoAction.java/* * RptInfoAction.java Created on Jul 9, 2009 * Copyright 2009JSHX. * All right reserved. */package com.jshx.glkj.web.action.report.rptinfo;import java.io.BufferedInputStream;import java.io.DataInputStream;import ja
2、va.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.UnsupportedEncodingException;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.ArrayList;im
3、port java.util.Calendar;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.zip.ZipEntry;import java.util.zip.ZipOutputStream;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import net.sf.json.JSONArray
4、;import jxl.Cell;import jxl.HeaderFooter;import jxl.Sheet;import jxl.Workbook;import jxl.biff.DisplayFormat;import jxl.format.CellFormat;import jxl.format.Colour;import jxl.format.UnderlineStyle;import jxl.read.biff.BiffException;import jxl.write.Blank;import jxl.write.Formula;import jxl.write.Label
5、;import jxl.write.Number;import jxl.write.NumberFormat;import jxl.write.NumberFormats;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.WriteException;import jxl.write.biff.RowsExceededException;import
6、mon.base.BaseAction;import mon.base.Constant;import mon.base.MapBean;import mon.exception.AppBaseException;import mon.utils.DTUtil;import mon.utils.DateTimeUtil;import mon.utils.ExcelUtil;import mon.utils.StringUtil;import mon.utils.SysLog;import com.jshx.glkj.dao.ibatis.model.CBZX;import com.jshx.g
7、lkj.dao.ibatis.model.GlkjRptCol;import com.jshx.glkj.dao.ibatis.model.GlkjRptMb;import com.jshx.glkj.dao.ibatis.model.RPTDYNAMICCOL;import com.jshx.glkj.dao.ibatis.model.SysCompany;import com.jshx.glkj.dao.ibatis.model.Syscbzx;import com.jshx.glkj.dao.ibatis.model.YytBaseInfo;import com.jshx.glkj.da
8、o.ibatis.model.YytBaseInfo_SD;import com.jshx.glkj.dao.ibatis.model.Ztcs;import com.jshx.glkj.dao.ibatis.model.glkj.qd.GlkjYdzdqd;import com.jshx.glkj.dao.ibatis.model.glkj.report.GlkjRptData;import com.jshx.glkj.dao.ibatis.model.glkj.report.GlkjRptInfo;import com.jshx.glkj.dao.ibatis.model.glkj.rep
9、ort.GlkjSjctJygsBaseInfo;import com.jshx.glkj.dao.ibatis.model.glkj.report.JycbzxRptInfo;import com.jshx.glkj.dao.ibatis.model.glkj.zb.GlkjZbdmsj;import com.jshx.glkj.service.report.luru.YidzdQudService;import com.jshx.glkj.service.report.rptinfo.DivisionNumber;import com.jshx.glkj.service.report.rp
10、tinfo.RptInfoService;import com.jshx.glkj.service.system.SysZhangtService;import com.jshx.glkj.service.system.impl.SysCompanyService;import com.jshx.glkj.service.zhibiao.ZbdmGlkjsjService;import edu.emory.mathcs.backport.java.util.concurrent.CountDownLatch;/import org.apache.tools.zip.ZipEntry;/impo
11、rt org.apache.tools.zip.ZipOutputStream;import com.jshx.glkj.service.report.tools.CountQx;import com.jshx.glkj.service.report.tools.SrftTest;/* * 报表信息维护 Action * * Time 2:34:26 PM * author mengxiankong */public class RptInfoAction extends BaseAction private static final long serialVersionUID = 1L;pr
12、ivate SysZhangtService sysZhangtService;private GlkjRptInfo rpt;private RptInfoService rptInfoService;private YidzdQudService yidzdQudService;private ZbdmGlkjsjService zbdmGlkjsjService;private Date rptDate;private String rptIds;private String dwdm;private String ztCode;private String ztids;private
13、SysCompanyService sysCompanyService;private String tempFileName;private String tempFilePath;private GlkjRptCol glkjrptcol;private String reportid;private String ztdm;private File impExcelFile;/导入的Excel文件private String time;/时间private MapBean ywlBean;/private String id;/ private String tag; private S
14、tring ssds;/所属地市 private String cbzxdm;/成本中心代码 private String zfjmc;/支分局名称 private String bdwmc;/本地网名称 private String sxgsmc;/市县公司名称 private String zjmc;/支局名称 private String zjcbzxdm;/支局成本中心代码 private String colName;/列名 private String jsTag;/计算标记 private String gdlx;/过渡类型 private List rptList; priva
15、te String rptTitName;/报表标题名称 private String rptUnit;/报表单位 private String rptCode;/报表编号 private String fxlx;public String getRptCode() return rptCode;public void setRptCode(String rptCode) this.rptCode = rptCode;public String getRptTitName() return rptTitName;public void setRptTitName(String rptTitNa
16、me) this.rptTitName = rptTitName;public String getRptUnit() return rptUnit;public void setRptUnit(String rptUnit) this.rptUnit = rptUnit;public List getRptList() return rptList;public void setRptList(List rptList) this.rptList = rptList;public String getJsTag() return jsTag;public void setJsTag(Stri
17、ng jsTag) this.jsTag = jsTag;public String getColName() return colName;public void setColName(String colName) this.colName = colName;public ZbdmGlkjsjService getZbdmGlkjsjService() return zbdmGlkjsjService;public void setZbdmGlkjsjService(ZbdmGlkjsjService zbdmGlkjsjService) this.zbdmGlkjsjService =
18、 zbdmGlkjsjService;public String getBdwmc() return bdwmc;public void setBdwmc(String bdwmc) this.bdwmc = bdwmc;public String getSxgsmc() return sxgsmc;public void setSxgsmc(String sxgsmc) this.sxgsmc = sxgsmc;public String getZjmc() return zjmc;public void setZjmc(String zjmc) this.zjmc = zjmc;publi
19、c String getZjcbzxdm() return zjcbzxdm;public void setZjcbzxdm(String zjcbzxdm) this.zjcbzxdm = zjcbzxdm;public static long getSerialVersionUID() return serialVersionUID;public String getSsds() return ssds;public void setSsds(String ssds) this.ssds = ssds;public String getCbzxdm() return cbzxdm;publ
20、ic void setCbzxdm(String cbzxdm) this.cbzxdm = cbzxdm;public String getZfjmc() return zfjmc;public void setZfjmc(String zfjmc) this.zfjmc = zfjmc;public String getTag() return tag;public void setTag(String tag) this.tag = tag;public String getId() return id;public void setId(String id) this.id = id;
21、public MapBean getYwlBean() return ywlBean;public void setYwlBean(MapBean ywlBean) this.ywlBean = ywlBean;public String getTime() return time;public void setTime(String time) this.time = time;public File getImpExcelFile() return impExcelFile;public void setImpExcelFile(File impExcelFile) this.impExc
22、elFile = impExcelFile;public String getFxlx() return fxlx;public void setFxlx(String fxlx) this.fxlx = fxlx;public String list() throws AppBaseException List objs = getRptInfoService().queryPageGlkjRptInfo(getPage(); this.getRequest().setAttribute(rpts, objs);this.getRequest().setAttribute(loginzhan
23、gid,this.getLoginUser().getChengbzxId();this.getRequest().setAttribute(zhangtaoselect,sysCompanyService.getCompanySelectSSC(getUserToken().getUserCode();return SUCCESS;public String getSjct() String type = this.getRequest().getParameter(sjct);if(!StringUtil.isNull(type) & 1.equals(type)getPage().get
24、Map().put(zrdy, type);getPage().getMap().put(rpttype,8);List objs = getRptInfoService().queryPageGlkjRptInfo(getPage();this.getRequest().setAttribute(rpts, objs);this.getRequest().setAttribute(loginzhangid,this.getLoginUser().getChengbzxId();this.getRequest().setAttribute(zhangtaoselect,sysCompanySe
25、rvice.getCompanySelectSSC(getUserToken().getUserCode();return SUCCESS;/* * 内部公式计算 * */public String calnbgs() rptInfoService.calnbgs(this.getRequest(), this.getLoginUser();try this.getResponse().getWriter().write(recordok); catch (IOException e) e.printStackTrace();return null;public String into() /
26、 进入新增页面if (FORWARD_ADD.equals(getFunType() return FORWARD_ADD; else if (FORWARD_EDIT.equals(getFunType() / 进入修改页面rpt = getRptInfoService().queryGlkjRptInfoByKey(Long.parseLong(getId();return FORWARD_EDIT;return ERROR;public String submit() throws AppBaseException if (FORWARD_ADD.equals(getFunType()
27、/ 新增页面提交getRptInfoService().insert(getRpt();return FORWARD_ADD; else if (FORWARD_EDIT.equals(getFunType() / 修改页面提交getRptInfoService().updateD(getRpt();return FORWARD_EDIT; else if (FORWARD_DEL.equals(getFunType() / 删除提交getRptInfoService().delete(Long.parseLong(getId();return FORWARD_DEL;return ERROR
28、;public String formulaCalculate() throws IOException String msg = ;/ 更新公式数据formulaCalculateint rt = -1;boolean bl=false,bl2=false;try if(!StringUtil.isNull(jsTag) & jsTag.equals(1) MapBean param=new MapBean(); param.put(rptId, Long.parseLong(getId(); param.put(rptDwdm,this.getDwdm(); List tempDwbmLi
29、st=getRptInfoService().getDynColDwbmList(param); if(null!=tempDwbmList & tempDwbmList.size()0) for(int i=0;itempDwbmList.size();i+) MapBean obj=tempDwbmList.get(i); rt = getRptInfoService().updateRptDataByRptID(Long.parseLong(getId(), getLoginUser(), getRptDate(),obj.getString(RPT_DWDM); bl=sjctJstb
30、DataByParam(obj.getString(RPT_DWDM); bl2=sjctTsclDataByParam(obj.getString(RPT_DWDM); else rt = getRptInfoService().updateRptDataByRptID(Long.parseLong(getId(), getLoginUser(), getRptDate(),this.getDwdm(); bl=sjctJstbDataByParam(this.getDwdm(); bl2=sjctTsclDataByParam(this.getDwdm(); catch (NumberFo
31、rmatException e) e.printStackTrace();msg = e.getMessage(); catch (AppBaseException e) e.printStackTrace();msg = e.getMessage();if (rt = 0)msg = 公式计算成功！;if (!bl)msg = 同比计算失败！;if (!bl2)msg = 特殊处理失败！;SysLog.log(msg);/ 设置页面不缓存getRequest().setAttribute(decorator, none);getResponse().setHeader(Cache-Contr
32、ol, no-cache);getResponse().setHeader(Pragma, no-cache);getResponse().setDateHeader(Expires, 0);getResponse().setContentType(text/html; charset=utf-8);getResponse().getWriter().write(msg);getResponse().getWriter().flush();getResponse().getWriter().close();return NONE;/* * 计算同比 * param dwbm * return
33、*/public boolean sjctJstbDataByParam(String dwbm) SimpleDateFormat sdf1=new SimpleDateFormat(yyyy); SimpleDateFormat sdf2=new SimpleDateFormat(MM); /计算同比 GlkjRptInfo rpt = getRptInfoService().queryGlkjRptInfoByKey(Long.parseLong(getId();/获取报表信息 String rpttype=rpt.getRptClass(); MapBean rptMap=new Ma
34、pBean(); rptMap.put(rpt_id,Long.parseLong(getId(); List rptObjList= getRptInfoService().selectSrftRptInfoIsHave(rptMap); if(null!=rptObjList & rptObjList!=null & rptObjList.size()0) if(yusuan.equals(rpttype) / 预算执行报表 HashMap paramap=new HashMap(); paramap.put(cur_year,sdf1.format(getRptDate(); param
35、ap.put(cur_month,sdf2.format(getRptDate(); paramap.put(rptid,getId(); if(StringUtil.isNull(dwbm) paramap.put(ssdw,A32); else paramap.put(ssdw,dwbm); return getRptInfoService().sjctJstbDataByParam(paramap); else if(zhijubb.equals(rpttype) HashMap paramap=new HashMap(); paramap.put(cur_year,sdf1.forma
36、t(getRptDate(); paramap.put(cur_month,sdf2.format(getRptDate(); if(StringUtil.isNull(dwbm) paramap.put(ssdw,A32); else paramap.put(ssdw,dwbm); return getRptInfoService().sjctZjJstbDataByParam(paramap); return true;/* * 四级穿透报表特殊行列处理 * param dwbm * return */public boolean sjctTsclDataByParam(String dw
37、bm) SimpleDateFormat sdf1=new SimpleDateFormat(yyyy); SimpleDateFormat sdf2=new SimpleDateFormat(MM); HashMap paramap=new HashMap(); paramap.put(cur_year,sdf1.format(getRptDate(); paramap.put(cur_month,sdf2.format(getRptDate(); paramap.put(rptid,getId(); if(StringUtil.isNull(dwbm) paramap.put(ssdw,A
38、32); else paramap.put(ssdw,dwbm); return getRptInfoService().sjctTsclDataByParam(paramap);/* * 进入报表导出页面 * * return */public String intoToExcel() /getRequest().setAttribute(ztList, getUserToken().getZhangts();List zts =new ArrayList();/ getUserToken().getChengbzxs();for(int i=0;igetUserToken().getChe
39、ngbzxs().size();i+)if(getUserToken().getChengbzxs().get(i).getCbzxCode().length()=5)zts.add(getUserToken().getChengbzxs().get(i);getRequest().setAttribute(ztList, zts);getRequest().setAttribute(rptList, getUserToken().getRpts();/ ToExcelreturn SUCCESS;public String cbzxToExcelSelect() getRequest().s
40、etAttribute(ztList,sysZhangtService.getTMSZhangTaoSelect2(getUserToken().getZhangts();List rptlist = getUserToken().getRpts();List rptlistfilt = new ArrayList();for (int i = 0; i rptlist.size(); i+) if (rptlist.get(i).getRptClass().equals(cbzxbb) rptlistfilt.add(rptlist.get(i);getRequest().setAttrib
41、ute(rptList, rptlistfilt);/ ToExcelreturn SUCCESS;public String cbzxToExcel() throws RowsExceededException, WriteException if (StringUtil.isNull(getZtids()return NONE; / 未选择帐套String months = DateTimeUtil.getMonthStr(getRptDate(), 0).trim();String queryZtids = getZtids().replaceAll( , ).split(,);if (StringUtil.isNull(getRptIds()return NONE; / 未选择报表String ids = getRptIds().split(,);long c
