countgasfeeservlet.java

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

                                                statwaterpaydbbean.setTableName("roomexam");
                                                statwaterpaydbbean.setSelectSQL07("select max(gasnumber) 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(countgasfeedbbean.vecM1.elementAt(0).toString());
                                                else
                                                    d1 = Double.parseDouble(countgasfeedbbean.vecM1.elementAt(0).toString()) - Double.parseDouble(statwaterpaydbbean.getMeterData());
                                                countgasfeedbbean.setStatusCode(8752);
                                            }
                                        } else
                                        if(countgasfeedbbean.vecC1.size() > 1)
                                        {
                                            countgasfeedbbean.setTableName("gasmeterinfo");
                                            countgasfeedbbean.setSelectSQL08(" SELECT  METERDATA FROM " + countgasfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE = ? AND  DELFLAG = '0')");
                                            try
                                            {
                                                countgasfeedbbean.select08();
                                                countgasfeedbbean.getDataFromResult08();
                                            }
                                            catch(Exception exception15)
                                            {
                                                throw exception15;
                                            }
                                            if(countgasfeedbbean.getStatusCode() == 8771)
                                            {
                                                d1 = 0.0D;
                                                countgasfeedbbean.setStatusCode(8752);
                                            } else
                                            if(countgasfeedbbean.vecM1.size() == 1)
                                            {
                                                double d4 = Double.parseDouble(countgasfeedbbean.vecM1.elementAt(0).toString());
                                                countgasfeedbbean.setTableName("gasmeterinfo");
                                                countgasfeedbbean.setSelectSQL09(" SELECT  MAX(METERDATA) FROM " + countgasfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE < ? AND  DELFLAG = '0') ");
                                                try
                                                {
                                                    countgasfeedbbean.select09();
                                                    countgasfeedbbean.getDataFromResult09();
                                                }
                                                catch(Exception exception18)
                                                {
                                                    throw exception18;
                                                }
                                                d1 = d4 - Double.parseDouble(countgasfeedbbean.vecZ1.elementAt(0).toString());
                                                countgasfeedbbean.setStatusCode(8752);
                                            }
                                        }
                                        countgasfeedbbean.setBasefee(formatbean.parseIndex(d1 * Double.parseDouble(countgasfeedbbean.vecQ1.elementAt(0).toString())));
                                        countgasfeedbbean.setMeterdata(String.valueOf(d1));
                                        countgasfeedbbean.setTableName("gasbasefeelog");
                                        countgasfeedbbean.setInsertSQL03(" INSERT INTO " + countgasfeedbbean.getTableName() + " ( NUMBER, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, METERNUM, CYCLENUM, METERDATA, BASEFEE,OTHERFEE, ALLFEE, FLAG, CASHFLAG, DELFLAG) VALUES (?,?,?,?,?,?,?,?,?,?,0,0,?,?,?) ");
                                        try
                                        {
                                            countgasfeedbbean.selectMaxnum();
                                            countgasfeedbbean.insert03();
                                        }
                                        catch(Exception exception16)
                                        {
                                            throw exception16;
                                        }
                                        double d5 = 0.0D;
                                        double d7 = 0.0D;
                                        countgasfeedbbean.setBasefeenum(countgasfeedbbean.getNumber());
                                        for(int l = 0; l < countgasfeedbbean.vecS1.size(); l++)
                                        {
                                            if(countgasfeedbbean.vecS2.elementAt(l).toString().equals("0"))
                                                d5 = d1 * Double.parseDouble(countgasfeedbbean.vecS3.elementAt(l).toString());
                                            else
                                            if(countgasfeedbbean.vecS2.elementAt(l).toString().equals("1"))
                                                d5 = Double.parseDouble(countgasfeedbbean.vecS3.elementAt(l).toString());
                                            d5 = Double.parseDouble(formatbean.fomatDouble(String.valueOf(d5)));
                                            d5 = Double.parseDouble(formatbean.parseIndex(d5));
                                            d7 += d5;
                                            countgasfeedbbean.setItemnum(countgasfeedbbean.vecS1.elementAt(l).toString());
                                            countgasfeedbbean.setItemfee(formatbean.parseIndex(d5));
                                            countgasfeedbbean.setTableName("gasotherfeelog");
                                            countgasfeedbbean.setInsertSQL02(" INSERT INTO " + countgasfeedbbean.getTableName() + " (NUMBER, BASEFEENUM, ITEMNUM, ITEMFEE, DELFLAG) VALUES (?,?,?,?,?) ");
                                            try
                                            {
                                                countgasfeedbbean.selectMaxnum();
                                                countgasfeedbbean.insert02();
                                            }
                                            catch(Exception exception20)
                                            {
                                                throw exception20;
                                            }
                                        }

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

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