鸿信四级穿透预算管理体系平台系统V10软件源程序代码

1、PAGE PAGE 135鸿信四级穿透预算管理体系平台系统V1.0 蔼鸿信案四级穿透预算管绊理体系平台哀系统氨V1.0哎源代码安江苏鸿信系统集埃成有限公司2012年8月扳RptInfo艾Action.奥java/* 跋 * RptI靶nfoActi罢on.java白 Create把d on Ju盎l 9, 20颁09爸 * Copy安right 2奥009JSH阿X. 巴 * All 昂right r背eserved阿. */爱package邦 com.js板hx.glkj佰.web.ac邦tion.re拜port.邦rptinfo胺;哎import 佰java.io拜.Buffer巴edIn

2、put埃Stream;癌import 氨java.io颁.DataIn板putStre般am;稗import 挨java.io百.File;昂import 昂java.io把.FileIn案putStre般am;哀import 鞍java.io熬.FileNo疤tFoundE澳xceptio凹n;芭import 挨java.io扳.FileOu摆tputStr霸eam;板import 绊java.io袄.IOExce澳ption;拌import 蔼java.io拔.InputS碍tream;拌import 捌java.io敖.Unsupp疤ortedEn隘codingE笆xceptio板n;澳

3、import 斑java.te岸xt.Date岸Format;吧import 傲java.te霸xt.Simp艾leDateF白ormat;熬import 霸java.ut耙il.Arra八yList;啊import 昂java.ut哀il.Cale爸ndar;百import 败java.ut袄il.Date搬;暗import 耙java.ut爱il.Hash败Map;斑import 芭java.ut百il.List隘;隘import 扮java.ut爱il.Map;半import 熬java.ut班il.zip.胺ZipEntr拌y;澳import 背java.ut斑il.zip.肮ZipO

4、utp敖utStrea翱m;氨import 稗javax.s安ervlet.佰http.Ht伴tpServl笆etReque盎st;癌import 笆javax.s鞍ervlet.百http.Ht办tpServl佰etRespo爱nse;鞍import 奥net.sf.叭json.JS隘ONArray碍;霸import 盎jxl.Cel把l;板import 皑jxl.Hea败derFoot懊er;耙import 翱jxl.She百et;绊import 皑jxl.Wor澳kbook;盎import 皑jxl.bif扳f.Displ案ayForma百t;啊import 跋jxl.for白mat.C

5、el叭lFormat懊;皑import 隘jxl.for俺mat.Col碍our;颁import 鞍jxl.for稗mat.Und暗erlineS胺tyle;爸import 蔼jxl.rea熬d.biff.靶BiffExc扮eption;凹import 霸jxl.wri爱te.Blan皑k;胺import 疤jxl.wri扳te.Form哎ula;俺import 捌jxl.wri败te.Labe板l;唉import 般jxl.wri唉te.Numb岸er;叭import 盎jxl.wri埃te.Numb叭erForma瓣t;澳import 跋jxl.wri啊te.Numb拔erForma氨ts

6、;凹import 敖jxl.wri鞍te.Writ靶ableCel奥lFormat靶;斑import 爱jxl.wri背te.Writ艾ableFon爱t;板import 澳jxl.wri拜te.Writ耙ableShe艾et;邦import 挨jxl.wri把te.Writ奥ableWor敖kbook;皑import 绊jxl.wri斑te.Writ敖eExcept百ion;拜import 坝jxl.wri靶te.biff版.RowsEx隘ceededE稗xceptio凹n;蔼import 袄com.jsh罢x.glkj.白common.矮base.Ba安seActio把n;稗import

7、岸com.jsh罢x.glkj.唉common.蔼base.Co哎nstant;艾import 颁com.jsh耙x.glkj.扮common.暗base.Ma版pBean;暗import 俺com.jsh班x.glkj.哎common.扮excepti芭on.AppB疤aseExce翱ption;艾import 拔com.jsh蔼x.glkj.绊common.袄utils.D啊TUtil;埃import 白com.jsh隘x.glkj.昂common.八utils.D啊ateTime熬Util;隘import 笆com.jsh白x.glkj.坝common.颁utils.E邦xcelUti扒

8、l;暗import 澳com.jsh埃x.glkj.巴common.扮utils.S哀tringUt安il;懊import 版com.jsh唉x.glkj.盎common.碍utils.S安ysLog;蔼import 皑com.jsh办x.glkj.碍dao.iba罢tis.mod蔼el.CBZX矮;癌import 碍com.jsh澳x.glkj.巴dao.iba摆tis.mod板el.Glkj袄RptCol;哎import 胺com.jsh熬x.glkj.暗dao.iba靶tis.mod巴el.Glkj扮RptMb;碍import 扮com.jsh蔼x.glkj.哀dao.iba傲tis.m

9、od吧el.RPTD瓣YNAMICC挨OL;熬import 拌com.jsh暗x.glkj.案dao.iba暗tis.mod鞍el.SysC颁ompany;凹import 稗com.jsh傲x.glkj.靶dao.iba爸tis.mod柏el.Sysc昂bzx;疤import 霸com.jsh敖x.glkj.凹dao.iba版tis.mod癌el.YytB昂aseInfo敖;败import 艾com.jsh鞍x.glkj.皑dao.iba熬tis.mod靶el.YytB白aseInfo哀_SD;肮import 笆com.jsh阿x.glkj.按dao.iba安tis.mod绊el.Ztcs版;

10、板import 稗com.jsh拔x.glkj.拌dao.iba按tis.mod笆el.glkj氨.qd.Glk拌jYdzdqd艾;吧import 笆com.jsh稗x.glkj.鞍dao.iba案tis.mod隘el.glkj巴.report白.GlkjRp胺tData;半import 爱com.jsh隘x.glkj.班dao.iba版tis.mod柏el.glkj巴.report蔼.GlkjRp案tInfo;般import 艾com.jsh邦x.glkj.绊dao.iba啊tis.mod般el.glkj盎.report八.GlkjSj隘ctJygsB耙aseInfo班;芭import 办c

11、om.jsh耙x.glkj.袄dao.iba皑tis.mod摆el.glkj伴.report吧.Jycbzx霸RptInfo袄;阿import 懊com.jsh败x.glkj.袄dao.iba百tis.mod摆el.glkj白.zb.Glk鞍jZbdmsj爸;敖import 败com.jsh爸x.glkj.艾service拜.report办.luru.Y哀idzdQud盎Service袄;靶import 霸com.jsh癌x.glkj.爸service坝.report安.rptinf昂o.Divis爱ionNumb摆er;懊import 蔼com.jsh扒x.glkj.氨service疤.re

12、port傲.rptinf斑o.RptIn绊foServi坝ce;佰import 办com.jsh八x.glkj.暗service懊.system把.SysZha班ngtServ扒ice;扮import 埃com.jsh凹x.glkj.挨service稗.system佰.impl.S白ysCompa昂nyServi吧ce;斑import 唉com.jsh把x.glkj.啊service巴.zhibia芭o.ZbdmG艾lkjsjSe斑rvice;鞍import 柏edu.emo坝ry.math捌cs.back板port.ja稗va.util邦.concur俺rent.Co捌untDown蔼Lat

13、ch;暗/impor斑t org.a伴pache.t案ools.zi佰p.ZipEn半try;伴/impor颁t org.a板pache.t办ools.zi斑p.ZipOu爱tputStr扮eam;捌import 版com.jsh罢x.g凹lkj.ser奥vice.re罢port.to熬ols.Cou懊ntQx;摆import 败com.jsh摆x.glkj.哎service艾.report坝.tools.疤SrftTes隘t;/*皑 * 报表信息安维护 Acti澳on * 傲 * Tim颁e 2:34:唉26 PM凹 * aut板hor men靶gxianko案ng */暗public 瓣c

14、lass R癌ptInfoA扳ction e般xtends 罢BaseAct鞍ion 扳绊private矮 static澳 final 蔼long se把rialVer斑sionUID疤 = 1L;笆摆private稗 SysZha罢ngtServ隘ice sys败ZhangtS百ervice;拜摆private凹 GlkjRp澳tInfo r矮pt;背疤private哎 RptInf哀oServic埃e rptIn哎foServi稗ce;版柏private澳 YidzdQ敖udServi坝ce yidz氨dQudSer捌vice;按矮private皑 ZbdmGl背kjsjSer把vice

15、zb艾dmGlkjs瓣jServic叭e;半癌private霸 Date r艾ptDate;袄八private罢 String耙 rptIds皑;捌爱private熬 String捌 dwdm;扮哎private笆 String拜 ztCode叭;唉把private叭 String矮 ztids;扳邦private靶 SysCom安panySer扮vice sy办sCompan佰yServic袄e;伴八private坝 String坝 tempFi凹leName;熬芭private蔼 String邦 tempFi翱lePath;八唉private版 GlkjRp按tCol gl爸kjrptco

16、班l;疤耙private碍 String啊 report袄id;耙耙private办 String皑 ztdm;唉袄private鞍 Fi邦le impE敖xcelFil暗e;/导入的唉Excel文件笆佰private矮 String巴 time;/疤/时间半疤private翱 MapBea跋n ywlBe瓣an;/半白private拜 String奥 id;/傲 pri爸vate St吧ring ta扳g;胺 pri敖vate St懊ring ss安ds;/所属叭地市般 pri伴vate St啊ring cb爸zxdm;/按成本中心代码邦 pri岸vate St矮ring zf把jmc;/支

17、矮分局名称昂 pri败vate St白ring bd矮wmc;/本佰地网名称唉 pri稗vate St奥ring sx捌gsmc;/阿市县公司名称爸 pri瓣vate St鞍ring zj爸mc;/支局把名称爱 pri柏vate St拔ring zj白cbzxdm;佰/支局成本中按心代码哎 pri版vate St岸ring co隘lName;/耙/列名半 pri暗vate St败ring js阿Tag;/计吧算标记搬 pri半vate St斑ring gd碍lx;/过渡班类型班 pri阿vate Li袄st rptLi矮st;哀 pri扒vate St拔ring rp爸tTitNam案e;/报

18、表标霸题名称巴 pri瓣vate St翱ring rp跋tUnit;/俺/报表单位傲 pri半vate St蔼ring rp班tCode;/拔/报表编号澳 pri叭vate St暗ring fx版lx;吧班public 矮String 笆getRptC爸ode() 背蔼板return 背rptCode傲;靶版public 绊void se熬tRptCod爸e(Strin爱g rptCo盎de) 版碍斑this.rp懊tCode =拔 rptCod肮e;板扳public 邦String拔 getRpt按TitName阿() 拔扮皑return 版rptTitN百ame;敖哀public 唉voi

19、d se哎tRptTit板Name(St爱ring rp矮tTitNam蔼e) 艾奥拌this.rp翱tTitNam跋e = rpt翱TitName捌;唉爸public 巴String 搬getRptU唉nit() 巴癌霸return 吧rptUnit罢;按癌public 袄void se啊tRptUni碍t(Strin奥g rptUn半it) 佰百扳this.rp按tUnit =皑 rptUni胺t;奥扒public 白List get吧RptList按() 班爸巴return 罢rptList颁;案哎public 扒void se把tRptLis伴t(List r肮ptList)拌 胺唉敖

20、this.rp瓣tList =坝 rptLis蔼t;肮爱public 搬String 癌getJsTa凹g() 爱昂唉return 凹jsTag;岸百public 白void se爱tJsTag(搬String 俺jsTag) 百班扒氨this.js捌Tag = j板sTag;凹坝public 隘String 澳getColN般ame() 奥板蔼return 懊colName霸;翱颁public 败void se哀tColNam鞍e(Strin把g colNa唉me) 癌俺邦this.co般lName =澳 colNam敖e;澳拜public 颁ZbdmGlk跋jsjServ熬ice get昂

21、ZbdmGlk斑jsjServ爸ice() 耙霸吧return 捌zbdmGlk跋jsjServ艾ice;绊靶public 绊void se氨tZbdmGl碍kjsjSer案vice(Zb案dmGlkjs氨jServic耙e zbdmG柏lkjsjSe绊rvice) 八叭凹靶this.zb搬dmGlkjs霸jServic败e = zbd癌mGlkjsj扒Service傲;岸颁public 胺String 阿getBdwm颁c() 埃伴邦return 癌bdwmc;败袄public 颁void se俺tBdwmc(皑String 拔bdwmc) 百吧搬半this.bd稗wmc = b氨dwmc;

22、澳把public 拜String 敖getSxgs跋mc() 半袄盎return 胺sxgsmc;奥半public 白void se矮tSxgsmc肮(String拌 sxgsmc罢) 按昂鞍this.sx瓣gsmc = 稗sxgsmc;隘板public 埃String 按getZjmc隘() 懊背百return 坝zjmc;罢暗public 邦void se笆tZjmc(S罢tring z埃jmc) 坝搬搬this.zj俺mc = zj吧mc;癌斑public 罢String 哎getZjcb哀zxdm() 笆般奥盎return 澳zjcbzxd爱m;败佰public 癌void se傲tZ

23、jcbzx岸dm(Stri叭ng zjcb佰zxdm) 坝叭袄this.zj把cbzxdm 霸= zjcbz岸xdm;八拌public 岸static 奥long ge艾tSerial斑Version按UID() 鞍皑摆return 爸serialV熬ersionU蔼ID;岸捌public 哀String 哀getSsds熬() 伴隘阿return 罢ssds;扒稗public 巴void se颁tSsds(S百tring s阿sds) 拔蔼阿this.ss爱ds = ss疤ds;佰办public 啊String 傲getCbzx奥dm() 摆扮奥return 爱cbzxdm;罢敖public

24、 伴void se肮tCbzxdm疤(String扳 cbzxdm敖) 扒佰凹this.cb爱zxdm = 鞍cbzxdm;拔懊public 拜String 昂getZfjm澳c() 巴哎矮return 百zfjmc;哀办public 稗void se吧tZfjmc(靶String 霸zfjmc) 氨蔼俺皑this.zf摆jmc = z蔼fjmc;八碍public 鞍String 巴getTag(澳) 敖搬傲return 坝tag;哀绊public 皑void se翱tTag(St爸ring ta背g) 案芭爱this.ta笆g = tag俺;半爱public 碍String 爱getId()

25、扳 跋袄艾return 班id;背敖public 叭void se按tId(Str澳ing id)唉 埃岸巴this.id拜 = id;邦氨public 鞍MapBean按 getYwl摆Bean() 唉般板班return 奥ywlBean安;袄胺public 案void se半tYwlBea坝n(MapBe巴an ywlB跋ean) 安啊叭this.yw佰lBean =安 ywlBea阿n;摆版public 奥String 疤getTime胺() 暗爸昂return 绊time;办绊public 跋void se拔tTime(S翱tring t矮ime) 八盎熬this.ti摆me = ti

26、鞍me;唉巴public 把File ge扮tImpExc捌elFile(败) 案哎八return 熬impExce百lFile;白凹public 疤void se罢tImpExc拌elFile(阿File im百pExcelF拔ile) 熬按奥this.im盎pExcelF爱ile = i疤mpExcel般File;扒扳public 澳String 肮getFxlx柏() 捌捌碍return 敖fxlx;按罢public 肮void se班tFxlx(S罢tring f搬xlx) 搬扳氨this.fx矮lx = fx半lx;叭白public 翱String 坝list() 胺throws 哎

27、AppBase拔Excepti颁on 俺傲半List obj伴s = get傲RptInfo敖Service鞍().quer敖yPageGl芭kjRptIn艾fo(getP跋age();邦 埃靶跋this.ge埃tReques埃t().set败Attribu背te(rpt皑s, obj八s);罢扮叭this.ge霸tReques罢t().set癌Attribu隘te(log碍inzhang按id,thi矮s.getLo吧ginUser懊().getC靶hengbzx矮Id();熬拌霸this.ge凹tReques扮t().set胺Attribu绊te(zha埃ngtaose把lect,s袄ys

28、Compa版nyServi坝ce.getC奥ompanyS阿electSS扳C(getUs案erToken蔼().getU懊serCode鞍();爸瓣颁return 啊SUCCESS疤;澳笆public 拜String 爱getSjct俺() 败佰伴String 肮type = 班this.ge奥tReques霸t().get佰Paramet败er(sjc岸t);板胺癌if(!Str扮ingUtil挨.isNull百(type) 扒& 1.把equals(拔type)罢哎懊吧getPage凹().getM罢ap().pu盎t(zrdy蔼, type败);阿败案八熬版getPage坝().get

29、M靶ap().pu鞍t(rptt扮ype,8)暗;扮矮斑List obj笆s = get半RptInfo班Service碍().quer伴yPageGl懊kjRptIn跋fo(getP扒age();澳拜肮this.ge耙tReques啊t().set暗Attribu柏te(rpt俺s, obj扮s);傲癌案this.ge百tReques昂t().set皑Attribu爸te(log捌inzhang斑id,袄昂跋皑肮this.ge柏tLoginU熬ser().g佰etCheng摆bzxId()阿);捌哎this.ge按tReques绊t().set斑Attribu埃te(zha拜ngtaose唉

30、lect,s按ysCompa耙nyServi凹ce.getC叭ompanyS罢electSS敖C(getUs稗erToken瓣().getU霸serCode坝();鞍艾拜捌埃return 安SUCCESS俺;/*笆艾 * 内部公式傲计算 * */肮傲public 爱String 翱calnbgs笆() 拜班挨rptInfo绊Service昂.calnbg佰s(this.扳getRequ碍est(), 暗this.ge耙tLoginU拌ser();try 般八般凹this.ge拌tRespon盎se().ge绊tWriter霸().writ拜e(reco稗rdok);笆版碍 catch爱 (IO

31、Exc伴eption 爱e) 氨爱蔼艾e.print般StackTr耙ace();稗艾碍return 半null;吧佰public 叭String 矮into() 坝白岸奥/ 进入新增隘页面版昂埃if (FOR把WARD_AD隘D.equal隘s(getFu败nType()啊) 办背哀柏return 佰FORWARD芭_ADD;巴扳叭 else 扳if (FOR巴WARD_ED跋IT.equa白ls(getF拌unType(矮) /柏/ 进入修改页安面版芭拌叭rpt = g背etRptIn盎foServi斑ce().qu凹eryGlkj安RptInfo岸ByKey(奥捌昂颁哀笆Long.pa霸

32、rseLong澳(getId(拜);翱挨岸隘return 坝FORWARD白_ED懊IT;蔼爸摆return 岸ERROR;哀绊public 搬String 凹submit(耙) throw凹s AppBa暗seExcep爱tion 捌暗芭if (FOR哀WARD_AD笆D.equal隘s(getFu氨nType()败) /矮 新增页面提交耙板翱唉getRptI敖nfoServ俺ice().i佰nsert(g靶etRpt()翱);拜百半败return 唉FORWARD埃_ADD;盎按版 else 岸if (FOR爱WARD_ED埃IT.equa皑ls(getF叭unType(百) /盎/ 修改

33、页面提安交扮拌斑搬getRptI癌nfoServ蔼ice().u吧pdateD(安getRpt(罢);绊隘班扮return 半FORWARD矮_EDIT;隘办澳 else 埃if (FOR隘WARD_DE盎L.equal扮s(getFu稗nType()摆) /拜 删除提交碍袄埃背getRptI颁nfoServ昂ice().d氨elete(L澳ong.par爱seLong(办getId()熬);埃绊暗瓣return 吧FORWARD凹_DEL;澳胺耙return 搬ERROR;艾拌public 邦String 叭formula澳Calcula岸te() 蔼throws 肮IOExcep拌tion

34、 佰瓣疤String 稗msg = 坝;哀班白/ 更新公式芭数据formu耙laCalcu颁late班稗稗int rt 扮= -1;碍熬坝boolean颁 bl=fal氨se,bl2=傲false;try扳败隘 if(!St挨ringUti霸l.isNul芭l(jsTag佰) & js爸Tag.equ扳als(1安) 隘拔班翱 MapBea拜n param版=new Ma皑pBean()版;昂八矮巴 param.鞍put(rp搬tId, L矮ong.par拔seLong(凹getId(傲);版办奥背 param.八put(rp凹tDwdm,霸this.ge俺tDwdm()颁);坝靶傲阿 Lis

35、t班 tempDw氨bmList=邦getRptI瓣nfoServ胺ice().g拔etDynCo氨lDwbmLi胺st(para鞍m);癌昂爱捌 if(nul啊l!=temp哀DwbmLis跋t & te阿mpDwbmL安ist.siz罢e()0)瓣懊凹扮疤 for(in笆t i=0;i隘tempDw吧bmList.昂size();摆i+) 按拜背般鞍胺 MapBea拜n obj=t氨empDwbm拌List.ge翱t(i);爸邦罢背按爸 rt = g班etRptIn奥foServi绊ce().up颁dateRpt皑DataByR办ptID(Lo阿ng.pars袄eLong(g半etId()

36、盎, getLo傲ginUser吧(), get矮RptDate邦(),obj.靶getStri按ng(RPT拌_DWDM)吧);唉搬跋哀傲捌 bl=sjc爱tJstbDa版taByPar案am(obj.暗getStri啊ng(RPT败_DWDM)按);昂伴蔼办敖笆 bl2=sj扒ctTsclD啊ataByPa扒ram(obj埃.getStr袄ing(RP鞍T_DWDM拌); 肮埃稗 else靶吧扮埃 rt = g叭etRptIn板foServi把ce().up伴dateRpt稗DataByR芭ptID(Lo癌ng.pars暗eLong(g蔼etId()俺, getLo凹ginUser拔(),

37、 get瓣RptDate颁(),this按.getDwd笆m();扮斑扮碍 bl=sjc扒tJstbDa霸taByPar吧am(this氨.getDwd胺m();扮佰般扮 bl2=sj爱ctTsclD矮ataByPa皑ram(thi邦s.getDw盎dm(); 疤翱稗 catch胺 (Numbe绊rFormat疤Excepti叭on e) 版耙皑佰e.print靶StackTr百ace();摆肮埃奥msg = e岸.getMes奥sage(); 俺懊芭catch (傲AppBase懊Excepti鞍on e) 摆败霸敖e.print蔼StackTr伴ace();坝办袄矮msg = e败.get

38、Mes阿sage();癌矮懊if (rt 啊= 0)澳岸柏艾msg = 疤公式计算成功！稗;艾柏扳if (!bl巴)皑哀澳八msg = 癌同比计算失败！拔;暗颁哎if (!bl笆2)板唉阿颁msg = 唉特殊处理失败！鞍;埃稗肮SysLog.阿log(msg败);罢皑靶/ 设置页面版不缓存把半笆getRequ巴est().s捌etAttri绊bute(d摆ecorato昂r, no板ne);板拔办getResp癌onse().板setHead肮er(Cac爸he-Cont安rol, 拌no-cach碍e);伴笆八getResp柏onse().袄setHead耙er(Pra蔼gma, 柏n柏o-

39、cache拌);班拜氨getResp斑onse().懊setDate吧Header(白Expire癌s, 0);柏唉霸getResp碍onse().板setCont俺entType蔼(text/罢html; c柏harset=翱utf-8)哀;爱办隘getResp摆onse().案getWrit唉er().wr爸ite(msg懊);阿背阿getResp拜onse().巴getWrit癌er().fl鞍ush();皑癌扮getResp稗onse().袄getWrit芭er().cl叭ose();爱鞍板return 肮NONE;/*跋俺 * 计算同比芭暗 * par芭am dwbm扳坝 * ret

40、佰urn */挨扳public 暗boolean稗 sjctJs袄tbDataB挨yParam(按String 哀dwbm)拜傲佰 Simple癌DateFor爸mat sdf爸1=new S把impleDa笆teForma柏t(yyyy拔);熬办巴 Simple皑DateFor氨mat sdf敖2=new S凹impleDa靶teForma爱t(MM)版;坝瓣柏 /计算同比扒跋盎 GlkjRp把tInfo r笆pt = ge哎tRptInf唉oServic笆e().que耙ryGlkjR哎ptInfoB芭yKey(Lo拜ng.pars伴eLong(g鞍etId()矮);/获取报搬表信息芭板柏

41、 String颁 rpttyp摆e=rpt.g捌etRptCl巴ass();案氨案 MapBea扳n rptM扮ap=new 佰MapBean安();盎拜扒 rptMap扒.put(r柏pt_id,哎Long.pa坝rseLong凹(getId(澳);邦扮翱 List吧 rptObj板List= g败etRptIn扳foServi疤ce().se皑lectSrf敖tRptInf矮oIsHave凹(rptMap岸);耙安傲 i拜f(null!坝=rptObj版List &爱 rptObj绊List!=n罢ull & 办rptObjL瓣ist.siz哀e()0)澳艾班背 if(yu皑suan.e坝

42、quals(r疤pttype)版) / 预百算执行报表熬疤伴矮稗 HashMa办p par爸amap=ne敖w HashM叭ap();捌艾百拔坝 parama澳p.put(跋cur_yea吧r,sdf1搬.format败(getRpt矮Date()巴);澳敖巴笆败 parama跋p.put(哀cur_mo傲nth,sd俺f2.form鞍at(getR办ptDate(般);唉案胺邦爸 parama败p.put(岸rptid,案getId()案);搬柏氨扒胺 if(Str扮ingUtil傲.isNull昂(dwbm)凹敖摆半办扳扮 parama敖p.put(颁ssdw,瓣A32);背般班盎挨 el

43、se奥靶绊柏昂安 parama吧p.put(案ssdw,d稗wbm); 叭坝百挨熬 return靶 getRpt矮InfoSer盎vice().稗sjctJst耙bDataBy叭Param(p袄aramap)般;绊俺把半 else 班if(zhi肮jubb.e芭quals(r傲pttype)哀)笆奥盎般啊 HashMa扮p par跋amap=ne坝w HashM昂ap();胺敖矮败办 parama澳p.put(俺cur_yea翱r,sdf1碍.format昂(getRpt盎Date()扒);肮背矮板鞍 parama邦p.put(阿cur_mon扮th,sdf啊2.forma败t(getRp癌t

44、Date()氨);唉案板挨捌 if(Str盎ingUtil敖.isNull败(dwbm)艾吧啊斑翱疤坝 pa邦ramap.p矮ut(ssd瓣w,A32巴);罢熬敖绊敖 else盎凹霸俺敖扳 parama癌p.put(版ssdw,d吧wbm); 把爱坝氨哎 return岸 getRpt百InfoSer扒vice().蔼sjctZjJ板stbData坝ByParam阿(parama阿p); 跋捌暗return 埃true;/*坝耙 * 四级穿透板报表特殊行列处袄理熬稗 * par盎am dwbm跋搬 * ret柏urn */把办public 斑boolean拔 sjctTs伴clDataB般yPa

45、半ram(Str挨ing dwb半m)扒摆碍 Simple拌DateFor皑mat sdf班1=new S笆impleDa爸teForma笆t(yyyy伴);白柏摆 Simple稗DateFor扳mat sdf拜2=new S凹impleDa颁teForma颁t(MM)扮;靶摆敖 HashMa蔼p par扮amap=ne案w HashM爱ap();奥疤搬 parama盎p.put(摆cur_yea唉r,sdf1疤.format坝(getRpt唉Date()搬);矮啊爱 parama白p.put(皑cur_mon佰th,sdf伴2.forma氨t(getRp坝tDate()耙);熬敖霸 para

46、ma熬p.put(岸rptid,皑getId()般);扮啊斑 if(Str斑ingUtil颁.isNull埃(dwbm)耙懊皑柏班 parama安p.put(斑ssdw,哀A32);暗碍拌 else疤爸碍熬 parama办p.put(把ssdw,d把wbm); 百敖百 return扮 getRpt暗InfoSer班vice().摆sjctTsc败lDataBy跋Param(p敖aramap)办;/*坝白 * 进入报表斑导出页面 * 昂坝 * ret般urn */拌芭public 版String 板intoToE半xcel() 般般肮凹/getRe芭quest()背.setAtt袄ribute(

47、挨ztList拜, getU啊serToke半n().get瓣Zhangts柏();耙芭蔼List 佰zts =ne邦w Array拌List(邦);/ ge凹tUserTo矮ken().g奥etCheng懊bzxs();搬扮澳for(int扒 i=0;i罢getUser班Token()氨.getChe笆ngb坝zxs().s邦ize();i稗+)鞍氨袄斑if(getU翱serToke澳n().get按Chengbz敖xs().ge肮t(i).ge颁tCbzxCo扒de().le斑ngth()斑=5)邦熬捌搬绊zts.add碍(getUse扒rToken(邦).getCh伴engbzxs绊()

48、.get(叭i);背凹坝getRequ八est().s暗etAttri捌bute(z拜tList,哎 zts);熬般哀getRequ罢est().s捌etAttri翱bute(r爸ptList哎, getUs芭erToken鞍().getR巴pts();肮/ ToEx八cel扮按埃return 澳SUCCESS拜;肮背public 伴String 胺cbzxToE啊xcelSel白ect() 瓣澳getRequ拜est().s瓣etAttri版bute(z爸tList,傲sysZhan澳gtServi佰ce.getT拌MSZhang背TaoSele扮ct2(get疤UserTok斑en().g

49、e叭tZhangt奥s();懊昂胺List rpt翱list = 碍getUser叭Token()稗.getRpt班s();暗办稗List rpt把listfil柏t = new凹 ArrayL办ist();皑绊翱for (in凹t i = 0拜; i r扒ptlist.叭size();矮 i+) 版瓣般奥if (rpt叭list.ge鞍t(i).ge败tRptCla澳ss().eq捌uals(c癌bzxbb)巴) 柏皑稗暗背rptlist澳filt.ad安d(rptli叭st.get(扮i);埃翱阿getRequ胺est().s爸etAttri爸bute(r扒ptList背, rptli爸s

50、tfilt)巴;/ ToE哎xcel盎拜鞍return 坝SUCCESS艾;拌败public 哎String 扮cbzxToE昂xcel() 芭throws 鞍RowsExc鞍eededEx碍ception氨, Write鞍Excepti笆on 挨暗案if (Str拔ingUtil叭.isNull扒(getZti挨ds()吧哀办扒return 奥NONE; /背/ 未选择帐套拔唉芭String 癌months 芭= DateT肮imeUtil暗.getMon佰thStr(g扮etRptDa芭te(), 0傲).trim(安);扮笆俺String稗 query伴Ztids =奥 getZti癌d

51、s().re敖placeAl癌l( , 颁).spl叭it(,)半;挨伴拜if (Str艾ingUtil熬.isNull般(getRpt芭Ids()啊斑邦坝return 蔼NONE; /俺/ 未选择报表奥阿瓣String懊 ids =懊 getRpt班Ids().s碍plit(奥,);熬哎扮long cu隘rrttime败 = Syst敖em.nano啊Time();扳奥鞍String 柏xlsPath碍0 = get版RealPat扮h(form奥templat巴es + F扮ile.sep邦arator+佰 excel爱)+ /八;版绊耙String 扒xlsPath芭 = getR芭ea

52、lPath叭(formt案emplate盎s + Fi扒le.sepa耙rator +办 excel瓣)+ /皑 + curr唉ttime +笆 /; /案/ Excel澳模板根路径佰岸伴String 暗datastr啊 = 懊DateFor扮mat.get背DateIns扮tance()办.format柏(getRpt罢Date()颁;癌俺哎File fi疤le = ne靶w File(靶xlsPath佰);拌奥矮file.mk斑dirs();鞍暗袄for (in绊t u = 0癌; u q翱ueryZti白ds.leng袄th; u+白) 罢爱八袄String 叭queryZt矮 = qu

53、er拜yZtids盎u.trim搬();摆哀颁翱new one懊ZtExpor伴tTread(板months,拌 ids, x巴lsPath0跋, xlsPa氨th, dat柏astr,qu白eryZt).瓣run();板埃盎zipExce叭l(month肮s, quer叭yZtids,岸 xlsPat斑h, data俺str);瓣柏霸getRequ挨est().s芭etAttri扳bute(c袄urrttim伴e, cur哀rttime)罢;俺扒蔼getRequ搬est().s捌etAttri氨bute(m摆onthDat鞍e, dat矮astr);佰盎板return 绊SUCCESS哎;昂

54、爸class o安neZtExp拌ortTrea俺d imple盎ments R笆unnable靶 蔼埃扳String 扮months;袄唉碍String罢 ids;办瓣白String 斑xlsPath板0;爸斑拔String 叭xlsPath八;扮邦癌String 阿datastr隘;肮斑隘String 佰queryZt班;敖隘拌public 肮oneZtEx班portTre暗ad(Stri捌ng mont佰hss, St搬ring 矮idss,败阿唉稗傲String 爱xlsPath隘0s, Str隘ing xls般Paths, 奥String 办datastr艾s,瓣拌安霸挨String

55、 俺queryZt懊s) 岸败熬扒months 熬= month俺ss;艾罢安挨ids = i挨dss;安八懊袄xlsPath靶0 = xls安Path0s;盎耙百班xlsPath暗 = xlsP跋aths;吧熬熬胺datastr百 = data傲strs;半绊袄跋queryZt靶 = quer奥yZts;巴罢跋public 罢void ru邦n() 败办矮矮try 搬白啊敖奥String 般prefix 耙= ;罢扮捌霸唉if (que挨ryZt !=把null &安 !query癌Zt.cont办ains(3唉2) 澳澳坝扳疤哎prefix 斑= hz_八;案坝八靶搬Writabl熬eWo

56、rkb阿ook wwb板 = Work板book.cr稗eateWor跋kbook(n爸ew File跋(xlsPat罢h+ pref白ix + qu瓣eryZt +坝 .xls版);碍靶芭爸鞍for (in瓣t i = 0跋; i i半ds.leng盎th; i+败) 懊暗艾隘搬巴Long rI拌d = Lon稗g.parse阿Long(id哀si.tr白im();八伴吧鞍百案String 版fname =把 rpt_稗 + rId 案+ .xls澳;/ Ex瓣cel模板文件耙名蔼哀颁柏扮吧GlkjRpt邦Info rp鞍t = get阿Rpt摆InfoSer柏vice().胺queryGl

57、叭kjRptIn蔼foByKey扮(rId);艾胺扒袄蔼颁String 熬sname =袄 rpt.ge奥tRptNam啊e();/ 搬报表中文名碍爱绊版爱斑/ 处理报表拔年月日时间疤傲霸按俺傲String 捌rptType笆 = rpt.哎getRptD斑ateType扮();/ 报捌表类型盎鞍熬八摆疤MapBean癌 mb = n埃ew MapB安ean(rp碍tid, r疤Id, zh背angtaoi阿d,quer百yZt.tri拜m(), y白ear, D八ateTime蔼Util.ge拜tYe百arStr(g扒etRptDa拜te(), 0笆).trim(瓣), mon靶th,碍白埃

58、哎安白瓣邦DateTim捌eUtil.g靶etMonth艾Str(get背RptDate半(), 0).捌trim()拜;八安阿暗瓣笆if (Con挨stant.R唉EPORT_D蔼ATE_TYP斑E_Y.equ耙als(rpt哎Type) 鞍 / 年报盎肮哀摆案哀袄mb.put(矮year,扳 DateTi按meUtil.百getYear懊Str(get盎RptDate巴(), -1)哎, mont扳h, nul板l);蔼佰阿半摆暗List唉 伴dtList 爸= getRp凹tInfoSe半rvice()盎.queryR隘ptDatas皑(mb);百安伴熬伴绊Workboo靶k wb =

59、摆ExcelUt罢il.getE坝xcelFor癌R(new F蔼ile(xls瓣Path0+f翱name);艾碍吧靶版扳wwb = E碍xcelUti跋l.addWB安FirstSh绊eet(wwb凹, wb, s扳name);绊把熬白岸袄Writabl搬eSheet 案ws = Ex背celUtil爱.getXls暗Sheet(w邦wb);邦阿熬跋熬爸wb.clos爸e();拜伴按板白败/ 插入数据半靶昂吧案拔int sta奥rtCol =百 0;疤把邦懊芭白/ 表头增加扒成本中心编号稗拌疤背佰澳Cell cl阿l = ws.办getCell笆(0, 0);拔俺暗阿癌澳CellFor傲ma

60、t cf 笆= cll.g拔etCellF吧ormat()按;隘阿啊挨爱绊Label n搬cf = nu翱ll;佰安懊袄袄艾if (cf 伴= null背) 八哀败啊哎班笆ncf = n爱ew Labe拜l(0, 0,隘 cll.ge斑tConten般ts();爱挨佰爱懊拔 else 挨隘皑爱癌皑板伴ncf = n熬ew Labe绊l(摆0, 0, c傲ll.getC般ontents邦(), cf)柏;阿板傲芭哀安ws.addC暗ell(ncf柏);绊捌奥矮捌瓣cll = w案s.getCe爱ll(0, 2伴);班澳翱背拜笆cf = cl暗l.getCe敖llForma霸t();敖邦拔扮办瓣i