statwaterunpayservlet.java

华磊物业管理系统源码 (仅供参考)

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   StatWaterUnPayServlet.java

package finance.statistic;

import common.*;
import finance.FormatBean;
import java.io.*;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

// Referenced classes of package finance.statistic:
//            StatWaterUnPayDBBean

public class StatWaterUnPayServlet extends ParentServlet
{

    public StatWaterUnPayServlet()
    {
    }

    public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
    {
        try
        {
            StatWaterUnPayDBBean statwaterunpaydbbean = new StatWaterUnPayDBBean();
            DateTimeBean datetimebean = new DateTimeBean();
            FormatBean formatbean = new FormatBean();
            ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
            String s = httpservletrequest.getParameter("inputString");
            Vector vector = parseinputstringbean.parseCommonFormatIS(s);
            Vector vector1 = (Vector)getServletContext().getAttribute("Para");
            statwaterunpaydbbean.setUserID((String)vector1.elementAt(0));
            statwaterunpaydbbean.setPassword((String)vector1.elementAt(1));
            statwaterunpaydbbean.setURL((String)vector1.elementAt(2));
            statwaterunpaydbbean.setDriver((String)vector1.elementAt(3));
            statwaterunpaydbbean.setDataSourceName((String)vector1.elementAt(4));
            statwaterunpaydbbean.setSubAreaNumb((String)vector.elementAt(0));
            statwaterunpaydbbean.setCycleNum((String)vector.elementAt(1));
            try
            {
                statwaterunpaydbbean.initialize();
            }
            catch(Exception exception1)
            {
                statwaterunpaydbbean.setStatusCode(7602);
                statwaterunpaydbbean.setStatusMessage("数据库连接错误");
                throw exception1;
            }
            try
            {
                statwaterunpaydbbean.setTableName("feecycle");
                statwaterunpaydbbean.setSelectSQL02("select feecycle,startdate,enddate,paystartdate,payenddate from " + statwaterunpaydbbean.getTableName() + " where  number = ? and delflag = '0'");
                statwaterunpaydbbean.select02();
                statwaterunpaydbbean.getDataFromResult02();
                statwaterunpaydbbean.setTableName("waterbasefeelog");
                statwaterunpaydbbean.setSelectSQL01("select distinct buildingnumb, doornumb, floornumb, cellnumb from " + statwaterunpaydbbean.getTableName() + " where   cyclenum <= ? and subareanumb = ? and delflag = '0' and flag='1' order by buildingnumb asc,doornumb asc,floornumb asc,cellnumb asc");
                statwaterunpaydbbean.select01();
                statwaterunpaydbbean.getDataFromResult01();
                statwaterunpaydbbean.setTableName1("feecycle");
                statwaterunpaydbbean.setSelectSQL04("select distinct waterbasefeelog.cyclenum, feecycle.startdate, feecycle.enddate from " + statwaterunpaydbbean.getTableName() + "," + statwaterunpaydbbean.getTableName1() + " where    waterbasefeelog.flag='1' and waterbasefeelog.cyclenum <= ? and waterbasefeelog.subareanumb = ? and waterbasefeelog.delflag = '0' and waterbasefeelog.cyclenum=feecycle.number order by feecycle.startdate asc");
                statwaterunpaydbbean.select04();
                statwaterunpaydbbean.getDataFromResult04();
                statwaterunpaydbbean.setTableName("feeitem");
                statwaterunpaydbbean.setSelectSQL06("select feestandard from " + statwaterunpaydbbean.getTableName() + " where number = 1 and delflag='0'");
                statwaterunpaydbbean.select06();
                statwaterunpaydbbean.getDataFromResult06();
                String as[][] = new String[statwaterunpaydbbean.vaddress.size() + 2][statwaterunpaydbbean.vcycle.size() + 9];
                for(int i = 1; i < statwaterunpaydbbean.vaddress.size() + 1; i++)
                {
                    as[i][0] = String.valueOf(i);
                    as[i][1] = (String)statwaterunpaydbbean.vaddress.elementAt(i - 1);
                    as[i][7] = statwaterunpaydbbean.getFeeStandard();
                }

                as[0][0] = "序号";
                as[0][1] = "单元号";
                as[0][2] = "户名";
                as[0][3] = "水表底数";
                as[0][4] = "上一次抄表读数";
                as[0][5] = "本次抄表读数";
                as[0][6] = "记费度数";
                as[0][7] = "单价";
                for(int j = 0; j < statwaterunpaydbbean.vcycle.size(); j++)
                    if(j == statwaterunpaydbbean.vcycle.size() - 1)
                        as[0][8] = String.valueOf(statwaterunpaydbbean.vcycle.elementAt(j)) + "月实收金额";
                    else
                        as[0][9 + j] = String.valueOf(statwaterunpaydbbean.vcycle.elementAt(j)) + "月欠费";

                as[0][8 + statwaterunpaydbbean.vcycle.size()] = "合计";
                if(!statwaterunpaydbbean.vaddress.isEmpty())
                {
                    as[statwaterunpaydbbean.vaddress.size() + 1][1] = "合计";
                    statwaterunpaydbbean.setTableName("waterbasefeelog");
                    statwaterunpaydbbean.setTableName1("feecycle");
                    statwaterunpaydbbean.setTableName2("livein");
                    String s1 = "select waterbasefeelog.buildingnumb, waterbasefeelog.doornumb, waterbasefeelog.floornumb, waterbasefeelog.cellnumb, waterbasefeelog.allfee,waterbasefeelog.cyclenum, livein.tenement ";
                    s1 = s1 + " from " + statwaterunpaydbbean.getTableName() + "," + statwaterunpaydbbean.getTableName1() + "," + statwaterunpaydbbean.getTableName2();
                    s1 = s1 + " where waterbasefeelog.cyclenum = feecycle.number and waterbasefeelog.subareanumb = livein.subarea and waterbasefeelog.buildingnumb = livein.building and waterbasefeelog.doornumb = livein.stair and waterbasefeelog.floornumb = livein.floor and waterbasefeelog.cellnumb = livein.cell and waterbasefeelog.delflag='0' and feecycle.delflag='0' and livein.delflag = '0' ";
                    s1 = s1 + " and  waterbasefeelog.flag='1' and waterbasefeelog.cyclenum <= ? and waterbasefeelog.subareanumb = ? ";
                    s1 = s1 + " order by waterbasefeelog.buildingnumb asc,waterbasefeelog.doornumb asc,waterbasefeelog.floornumb asc,waterbasefeelog.cellnumb asc,feecycle.startdate asc";
                    statwaterunpaydbbean.setSelectSQL03(s1);
                    statwaterunpaydbbean.select03();
                    statwaterunpaydbbean.getDataFromResult03();
                    for(int k = 0; k < statwaterunpaydbbean.vbuilding.size(); k++)
                    {
                        statwaterunpaydbbean.setBuildingNumb((String)statwaterunpaydbbean.vbuilding.elementAt(k));
                        statwaterunpaydbbean.setDoorNumb((String)statwaterunpaydbbean.vdoor.elementAt(k));
                        statwaterunpaydbbean.setFloorNumb((String)statwaterunpaydbbean.vfloor.elementAt(k));
                        statwaterunpaydbbean.setCellNumb((String)statwaterunpaydbbean.vcell.elementAt(k));
                        statwaterunpaydbbean.setTableName("watermeterinfo");
                        statwaterunpaydbbean.setSelectSQL05("select meterdata from " + statwaterunpaydbbean.getTableName() + " where cycle = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterunpaydbbean.select05();
                        statwaterunpaydbbean.getDataFromResult05();
                        as[k + 1][5] = statwaterunpaydbbean.getMeterData();
                        statwaterunpaydbbean.setMeterData("");
                        statwaterunpaydbbean.setSelectSQL05("select max(meterdata) from " + statwaterunpaydbbean.getTableName() + " where cycle < ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterunpaydbbean.select05();
                        statwaterunpaydbbean.getDataFromResult05();
                        as[k + 1][4] = statwaterunpaydbbean.getMeterData();
                        statwaterunpaydbbean.setMeterData("");
                        statwaterunpaydbbean.setTableName("waterbasefeelog");
                        statwaterunpaydbbean.setSelectSQL05("select meterdata from " + statwaterunpaydbbean.getTableName() + " where cyclenum = ? and subareanumb = ? and buildingnumb = ? and doornumb=? and floornumb=? and cellnumb=? and delflag='0'");
                        statwaterunpaydbbean.select05();
                        statwaterunpaydbbean.getDataFromResult05();
                        as[k + 1][6] = statwaterunpaydbbean.getMeterData();
                        statwaterunpaydbbean.setMeterData("");
                        if(as[k + 1][4] == null || as[k + 1][4].equals(""))
                        {
                            statwaterunpaydbbean.setTableName("roomexam");
                            statwaterunpaydbbean.setSelectSQL07("select max(waternumber) from " + statwaterunpaydbbean.getTableName() + " where subarea = ? and building = ? and stair=? and floor=? and cell=? and delflag='0'");
                            statwaterunpaydbbean.select07();
                            statwaterunpaydbbean.getDataFromResult07();
                            as[k + 1][3] = statwaterunpaydbbean.getMeterData();
                            statwaterunpaydbbean.setMeterData("");