private byte[] getExportXlsData(ExportXlsStruct EXPostValues)
{
/*ExportXlsPostString postdata = new ExportXlsPostString("14",
* "select count (*) from (select a.*,rownum from (select a.*,b.spfry,b.dpfsj,b.dyyddsj,b.dxysj,b.dddsj,b.dwwcsj,b.dxcwcsj,b.ddallsj,b.dgbsj, to_char(a.dbxsj,'yyyy-mm-dd hh24:mi') bxsj,round((b.dxcwcsj-b.dddsj)*24*60,0) costtime, to_char(b.dpfsj,'yyyy-mm-dd hh24:mi') pfsj,to_char(b.dxysj,'yyyy-mm-dd hh24:mi') xysj,to_char(b.dddsj,'yyyy-mm-dd hh24:mi') ddsj,to_char(b.DXCWCSJ,'yyyy-mm-dd hh24:mi') XCWCSJ,to_char(b.DWWCSJ,'yyyy-mm-dd hh24:mi') DWCSJ,to_char(b.DDALLSJ,'yyyy-mm-dd hh24:mi') DALLSJ,decode(b.shfbz,'0','未回访','1','已回访') hfbzmc,c.szzbh,decode(a.ssjzt,'8',a.sfzpmx,c.sxcgzms) sxcgzms,c.scljg,c.nwxsl,decode(c.sfffs,'1','现场服务','2','电话服务') fffsmc,decode(c.skhpj,'1','满意','2','一般','不满意') khpjmc, (select sname from f_code t where (t.scatid='15') and (t.sid=a.ssjlb) ) sjlbmc,(select sname from f_code t where (t.scatid='10') and (t.sid=a.ssbmclb) ) sbmclbmc,(select spad from f_code t where (t.scatid='3') and (t.sid=a.syhdq)) yhdqmc ,(select sbankname from f_bank t where (t.sbankid=a.sbankid)) bankmc ,(select sbankname from f_bank t where t.slevel='1' and (t.sbankid=substr(a.sbankid,1,3)||'000000')) yhhymc, (select decode(slevel,'1','总行','2','分行','3','支行','4','网点') from f_bank where sbankid=a.sbankid) levelmc, (select sgzmc from f_bugtype t where (t.sgzlb=a.sgzdl))||'-'||(select sgzmc from f_bugtype t where (t.sgzlb=a.sgzxl)) gzlbmc,(select sname from f_code t where (t.scatid='7') and (t.sid=a.ssjzt)) sjztmc,(select sname from f_branch t where t.sid=a.syhjg) yhjgmc,(select syhxm from f_oper t where t.syhdm=a.sffry) ffrymc from z_event a,z_event_do b,z_repaire c where a.seventbh=b.seventbh and a.seventbh=c.seventbh(+) and a.ssjzt in ('7','0','8') and a.syhdq like '45%' and to_char(a.dbxsj,'yyyymmdd')>='20151001' and to_char(a.dbxsj,'yyyymmdd')<='20151115' and a.syhjg='0206000000' and a.sffry='nn0034' order by a.dczrq) a)"
* , "select a.*,rownum from (select a.*,b.spfry,b.dpfsj,b.dyyddsj,b.dxysj,b.dddsj,b.dwwcsj,b.dxcwcsj,b.ddallsj,b.dgbsj, to_char(a.dbxsj,'yyyy-mm-dd hh24:mi') bxsj,round((b.dxcwcsj-b.dddsj)*24*60,0) costtime, to_char(b.dpfsj,'yyyy-mm-dd hh24:mi') pfsj,to_char(b.dxysj,'yyyy-mm-dd hh24:mi') xysj,to_char(b.dddsj,'yyyy-mm-dd hh24:mi') ddsj,to_char(b.DXCWCSJ,'yyyy-mm-dd hh24:mi') XCWCSJ,to_char(b.DWWCSJ,'yyyy-mm-dd hh24:mi') DWCSJ,to_char(b.DDALLSJ,'yyyy-mm-dd hh24:mi') DALLSJ,decode(b.shfbz,'0','未回访','1','已回访') hfbzmc,c.szzbh,decode(a.ssjzt,'8',a.sfzpmx,c.sxcgzms) sxcgzms,c.scljg,c.nwxsl,decode(c.sfffs,'1','现场服务','2','电话服务') fffsmc,decode(c.skhpj,'1','满意','2','一般','不满意') khpjmc, (select sname from f_code t where (t.scatid='15') and (t.sid=a.ssjlb) ) sjlbmc,(select sname from f_code t where (t.scatid='10') and (t.sid=a.ssbmclb) ) sbmclbmc,(select spad from f_code t where (t.scatid='3') and (t.sid=a.syhdq)) yhdqmc ,(select sbankname from f_bank t where (t.sbankid=a.sbankid)) bankmc ,(select sbankname from f_bank t where t.slevel='1' and (t.sbankid=substr(a.sbankid,1,3)||'000000')) yhhymc, (select decode(slevel,'1','总行','2','分行','3','支行','4','网点') from f_bank where sbankid=a.sbankid) levelmc, (select sgzmc from f_bugtype t where (t.sgzlb=a.sgzdl))||'-'||(select sgzmc from f_bugtype t where (t.sgzlb=a.sgzxl)) gzlbmc,(select sname from f_code t where (t.scatid='7') and (t.sid=a.ssjzt)) sjztmc,(select sname from f_branch t where t.sid=a.syhjg) yhjgmc,(select syhxm from f_oper t where t.syhdm=a.sffry) ffrymc from z_event a,z_event_do b,z_repaire c where a.seventbh=b.seventbh and a.seventbh=c.seventbh(+) and a.ssjzt in ('7','0','8') and a.syhdq like '45%' and to_char(a.dbxsj,'yyyymmdd')>='20151001' and to_char(a.dbxsj,'yyyymmdd')<='20151115' and a.syhjg='0206000000' and a.sffry='nn0034' order by a.dczrq) a");
*/
ExportXlsPostString postdata = new ExportXlsPostString(EXPostValues.datacount, EXPostValues.sqlForCount, EXPostValues.sqlForList);
return(doPost(postdata.url, postdata.PostString, postdata.Referer));
}
public ExportXlsPostString(ExportXlsStruct Postvalues)
{
postvalues = Postvalues;
}
