countwaterfeeservlet.java

JSP物业管理系统 一份比较完整的物业管理系统源码。 对于初学者可以有一定的借鉴。

                                                statwaterpaydbbean.setTableName("roomexam");
                                                statwaterpaydbbean.setSelectSQL07("select max(waternumber) from " + statwaterpaydbbean.getTableName() + " where subarea = ? and building = ? and stair=? and floor=? and cell=? and delflag='0'");
                                                statwaterpaydbbean.select07();
                                                statwaterpaydbbean.getDataFromResult07();
                                                if(statwaterpaydbbean.getMeterData().equals(""))
                                                    d1 = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString());
                                                else
                                                    d1 = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString()) - Double.parseDouble(statwaterpaydbbean.getMeterData());
                                                countwaterfeedbbean.setStatusCode(8672);
                                            }
                                        } else
                                        if(countwaterfeedbbean.vecC1.size() > 1)
                                        {
                                            countwaterfeedbbean.setTableName("watermeterinfo");
                                            countwaterfeedbbean.setSelectSQL08(" SELECT  METERDATA FROM " + countwaterfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE = ? AND  DELFLAG = '0')");
                                            try
                                            {
                                                countwaterfeedbbean.select08();
                                                countwaterfeedbbean.getDataFromResult08();
                                            }
                                            catch(Exception exception15)
                                            {
                                                throw exception15;
                                            }
                                            if(countwaterfeedbbean.getStatusCode() == 8691)
                                            {
                                                d1 = 0.0D;
                                                countwaterfeedbbean.setStatusCode(8672);
                                            } else
                                            if(countwaterfeedbbean.vecM1.size() == 1)
                                            {
                                                double d4 = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString());
                                                countwaterfeedbbean.setTableName("watermeterinfo");
                                                countwaterfeedbbean.setSelectSQL09(" SELECT  MAX(METERDATA) FROM " + countwaterfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE < ? AND  DELFLAG = '0') ");
                                                try
                                                {
                                                    countwaterfeedbbean.select09();
                                                    countwaterfeedbbean.getDataFromResult09();
                                                }
                                                catch(Exception exception18)
                                                {
                                                    throw exception18;
                                                }
                                                d1 = d4 - Double.parseDouble(countwaterfeedbbean.vecZ1.elementAt(0).toString());
                                                countwaterfeedbbean.setStatusCode(8672);
                                            }
                                        }
                                        countwaterfeedbbean.setBasefee(formatbean.parseIndex(d1 * Double.parseDouble(countwaterfeedbbean.vecQ1.elementAt(0).toString())));
                                        countwaterfeedbbean.setMeterdata(String.valueOf(d1));
                                        countwaterfeedbbean.setTableName("waterbasefeelog");
                                        countwaterfeedbbean.setInsertSQL03(" INSERT INTO " + countwaterfeedbbean.getTableName() + " ( NUMBER, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, METERNUM, CYCLENUM, METERDATA, BASEFEE, OTHERFEE, ALLFEE, FLAG, CASHFLAG, DELFLAG) VALUES (?,?,?,?,?,?,?,?,?,?,0,0,?,?,?) ");
                                        try
                                        {
                                            countwaterfeedbbean.selectMaxnum();
                                            countwaterfeedbbean.insert03();
                                        }
                                        catch(Exception exception16)
                                        {
                                            throw exception16;
                                        }
                                        double d5 = 0.0D;
                                        double d7 = 0.0D;
                                        countwaterfeedbbean.setBasefeenum(countwaterfeedbbean.getNumber());
                                        for(int l = 0; l < countwaterfeedbbean.vecS1.size(); l++)
                                        {
                                            if(countwaterfeedbbean.vecS2.elementAt(l).toString().equals("0"))
                                                d5 = d1 * Double.parseDouble(countwaterfeedbbean.vecS3.elementAt(l).toString());
                                            else
                                            if(countwaterfeedbbean.vecS2.elementAt(l).toString().equals("1"))
                                                d5 = Double.parseDouble(countwaterfeedbbean.vecS3.elementAt(l).toString());
                                            d5 = Double.parseDouble(formatbean.fomatDouble(String.valueOf(d5)));
                                            d5 = Double.parseDouble(formatbean.parseIndex(d5));
                                            d7 += d5;
                                            countwaterfeedbbean.setItemnum(countwaterfeedbbean.vecS1.elementAt(l).toString());
                                            countwaterfeedbbean.setItemfee(formatbean.parseIndex(d5));
                                            countwaterfeedbbean.setTableName("waterotherfeelog");
                                            countwaterfeedbbean.setInsertSQL02(" INSERT INTO " + countwaterfeedbbean.getTableName() + " (NUMBER, BASEFEENUM, ITEMNUM, ITEMFEE, DELFLAG) VALUES (?,?,?,?,?) ");
                                            try
                                            {
                                                countwaterfeedbbean.selectMaxnum();
                                                countwaterfeedbbean.insert02();
                                            }
                                            catch(Exception exception20)
                                            {
                                                throw exception20;
                                            }
                                        }

                                        countwaterfeedbbean.setTableName("waterbasefeelog");
                                        countwaterfeedbbean.setOtherfee(formatbean.parseIndex(d7));
                                        countwaterfeedbbean.setAllfee(formatbean.parseIndex(d7 + Double.parseDouble(countwaterfeedbbean.getBasefee())));
                                        countwaterfeedbbean.setUpdate01("update " + countwaterfeedbbean.getTableName() + " set otherfee = ?, allfee = ? where number = ?");
                                        countwaterfeedbbean.update01();
                                        countwaterfeedbbean.vecC1.removeAllElements();
                                        countwaterfeedbbean.vecM1.removeAllElements();
                                        countwaterfeedbbean.vecZ1.removeAllElements();
                                        countwaterfeedbbean.vecN1.removeAllElements();
                                    }
                                }

                                if(countwaterfeedbbean.vecTemp1.size() == 0)
                                {
                                    countwaterfeedbbean.setOpcontent("批量计算小区住户应缴纳水费费用");
                                    HttpSession httpsession1 = httpservletrequest.getSession(false);
                                    countwaterfeedbbean.setOperator((String)httpsession1.getValue("persname"));
                                    countwaterfeedbbean.setOpdate(datetimebean1.getDate());
                                    countwaterfeedbbean.setOptime(datetimebean1.getTime());
                                    countwaterfeedbbean.insertLog();
                                    countwaterfeedbbean.commitToDB();
                                    countwaterfeedbbean.setStatusCode(8710);
                                    countwaterfeedbbean.setStatusMessage("成功计算水费收费信息及附加费信息！");
                                } else
                                {
                                    countwaterfeedbbean.setStatusCode(8709);
                                    countwaterfeedbbean.setStatusMessage("如下入住单元没有水表表编号，请核对后再做处理！");
                                    httpservletrequest.setAttribute("vecTmp1", countwaterfeedbbean.vecTemp1);
                                    httpservletrequest.setAttribute("vecTmp2", countwaterfeedbbean.vecTemp2);
                                    httpservletrequest.setAttribute("vecTmp3", countwaterfeedbbean.vecTemp3);
                                    httpservletrequest.setAttribute("vecTmp4", countwaterfeedbbean.vecTemp4);
                                    httpservletrequest.setAttribute("vecTmp5", countwaterfeedbbean.vecTemp5);
                                }
                            }
                        } else
                        {
                            countwaterfeedbbean.setStatusCode(8661);
                            countwaterfeedbbean.setStatusMessage("入住记录表中没有入住单元信息！");
                        }
                    } else
                    {
                        countwaterfeedbbean.setStatusCode(8655);
                        countwaterfeedbbean.setStatusMessage("请先设置水费每收费单位收取费用！");
                    }
                } else
                {
                    countwaterfeedbbean.setStatusCode(8715);
                    countwaterfeedbbean.setStatusMessage("本期水费已结算！");
                }
            }
            catch(Exception exception7)
            {
                countwaterfeedbbean.rollbackFromDB();
                throw exception7;
            }
            finally
            {
                countwaterfeedbbean.releaseConnection();
            }
            httpservletrequest.setAttribute("feecycle", countwaterfeedbbean.getFeecycle());
            httpservletrequest.setAttribute("flag", (new Integer(countwaterfeedbbean.getStatusCode())).toString());
            httpservletrequest.setAttribute("statusMessage", countwaterfeedbbean.getStatusMessage());
            RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/CountWaterFeeResult.jsp");
            requestdispatcher1.forward(httpservletrequest, httpservletresponse);
        }
        catch(Throwable throwable)
        {
            try
            {
                DateTimeBean datetimebean = new DateTimeBean();
                System.out.println("[CountWaterFeeServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "][" + throwable + "]");
                RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
                requestdispatcher.forward(httpservletrequest, httpservletresponse);
            }
            catch(Exception exception)
            {
                System.out.println(exception.getMessage());
            }
        }
    }
}