📄 countelectricfeeservlet.java
字号:
}
catch(Exception exception)
{
countelectricfeedbbean.setStatusCode(8999);
System.out.println(exception.getMessage());
return countelectricfeedbbean.getStatusCode();
}
return 8998;
}
public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
{
try
{
CountElectricFeeDBBean countelectricfeedbbean = new CountElectricFeeDBBean();
ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
DateTimeBean datetimebean1 = new DateTimeBean();
String s = httpservletrequest.getParameter("inputString");
Vector vector = parseinputstringbean.parseCommonFormatIS(s);
Vector vector1 = (Vector)getServletContext().getAttribute("Para");
countelectricfeedbbean.setUserID((String)vector1.elementAt(0));
countelectricfeedbbean.setPassword((String)vector1.elementAt(1));
countelectricfeedbbean.setURL((String)vector1.elementAt(2));
countelectricfeedbbean.setDriver((String)vector1.elementAt(3));
countelectricfeedbbean.setDataSourceName((String)vector1.elementAt(4));
countelectricfeedbbean.setFeecycle((String)vector.elementAt(0));
countelectricfeedbbean.setCashflag("0");
countelectricfeedbbean.setFlag1("1");
countelectricfeedbbean.setDelflag("0");
try
{
countelectricfeedbbean.initialize();
}
catch(Exception exception1)
{
throw exception1;
}
try
{
beanm.connBean = ((ParentDBBean) (countelectricfeedbbean)).connBean;
countelectricfeedbbean.setParaName("ElecCountBy");
countelectricfeedbbean.selectPara();
if(countelectricfeedbbean.getStatusCode() == 9013)
throw new Exception("在参数表中没有该参数" + countelectricfeedbbean.getParaName());
countelectricfeedbbean.setCountby(Integer.parseInt(countelectricfeedbbean.getParaValue()));
countelectricfeedbbean.setCountby(1);
countelectricfeedbbean.setTableName("electricbasefeelog");
countelectricfeedbbean.setFeename("电费");
countelectricfeedbbean.setSelectSQL15(" SELECT COUNT(NUMBER) FROM " + countelectricfeedbbean.getTableName() + " WHERE( CYCLENUM = ? AND DELFLAG = '0') ");
try
{
countelectricfeedbbean.select15();
countelectricfeedbbean.getDataFromResult15();
}
catch(Exception exception3)
{
throw exception3;
}
if(Integer.parseInt(countelectricfeedbbean.vecCount.elementAt(0).toString()) == 0)
{
countelectricfeedbbean.setTableName("feeitem");
countelectricfeedbbean.setFeename("电费");
countelectricfeedbbean.setSelectSQL01(" SELECT feestandard FROM " + countelectricfeedbbean.getTableName() + " WHERE( NUMBER = 2 AND FEENAME = ? AND DELFLAG = '0') ");
try
{
countelectricfeedbbean.select01();
countelectricfeedbbean.getDataFromResult01();
}
catch(Exception exception4)
{
throw exception4;
}
if(countelectricfeedbbean.getStatusCode() != 8814)
{
countelectricfeedbbean.setTableName("apportionitem");
countelectricfeedbbean.setSelectSQL10(" SELECT NUMBER, NAME, FLAG2, VALUE FROM " + countelectricfeedbbean.getTableName() + " WHERE( FLAG1= '1' AND FLAG3= '0' AND DELFLAG = '0')");
try
{
countelectricfeedbbean.select10();
countelectricfeedbbean.getDataFromResult10();
}
catch(Exception exception5)
{
throw exception5;
}
countelectricfeedbbean.setTableName("livein");
countelectricfeedbbean.setSelectSQL02(" SELECT SUBAREA, BUILDING, STAIR, FLOOR, CELL FROM " + countelectricfeedbbean.getTableName() + " WHERE( DELFLAG = '0')");
try
{
countelectricfeedbbean.select02();
countelectricfeedbbean.getDataFromResult02();
}
catch(Exception exception6)
{
throw exception6;
}
if(countelectricfeedbbean.getStatusCode() != 8819)
{
if(countelectricfeedbbean.getCountby() == 1)
{
for(int i = 0; i < countelectricfeedbbean.vecL1.size(); i++)
{
double d = 0.0D;
countelectricfeedbbean.setSubareanumb(countelectricfeedbbean.vecL1.elementAt(i).toString());
countelectricfeedbbean.setBuildingnumb(countelectricfeedbbean.vecL2.elementAt(i).toString());
countelectricfeedbbean.setDoornumb(countelectricfeedbbean.vecL3.elementAt(i).toString());
countelectricfeedbbean.setFloornumb(countelectricfeedbbean.vecL4.elementAt(i).toString());
countelectricfeedbbean.setCellnumb(countelectricfeedbbean.vecL5.elementAt(i).toString());
countelectricfeedbbean.setTableName("apparatusfit,apparatusinfo");
countelectricfeedbbean.setSelectSQL06(" SELECT apparatusfit.APPARATUS FROM " + countelectricfeedbbean.getTableName() + " WHERE( apparatusfit.SUBAREANUMB = ? AND apparatusfit.BUILDINGNUMB = ? AND apparatusfit.DOORNUMB = ? AND apparatusfit.FLOORNUMB = ? AND apparatusfit.CELLNUMB = ? AND apparatusfit.DELFLAG = '0' AND apparatusfit.APPARATUSNUMB = APPARATUSINFO.APPARATUSNUMB AND APPARATUSINFO.APPARATUSKIND = '电表' AND APPARATUSINFO.DELFLAG = '0')");
try
{
countelectricfeedbbean.select06();
countelectricfeedbbean.getDataFromResult06();
}
catch(Exception exception9)
{
throw exception9;
}
if(countelectricfeedbbean.getStatusCode() == 8841)
{
countelectricfeedbbean.vecTemp1.addElement(countelectricfeedbbean.vecL1.elementAt(i).toString());
countelectricfeedbbean.vecTemp2.addElement(countelectricfeedbbean.vecL2.elementAt(i).toString());
countelectricfeedbbean.vecTemp3.addElement(countelectricfeedbbean.vecL3.elementAt(i).toString());
countelectricfeedbbean.vecTemp4.addElement(countelectricfeedbbean.vecL4.elementAt(i).toString());
countelectricfeedbbean.vecTemp5.addElement(countelectricfeedbbean.vecL5.elementAt(i).toString());
} else
{
countelectricfeedbbean.setMeternum(countelectricfeedbbean.vecN1.elementAt(0).toString());
countelectricfeedbbean.setTableName("electricmeterinfo");
countelectricfeedbbean.setSelectSQL07(" SELECT METERDATA FROM " + countelectricfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE <= ? AND DELFLAG = '0')");
try
{
countelectricfeedbbean.select07();
countelectricfeedbbean.getDataFromResult07();
}
catch(Exception exception10)
{
throw exception10;
}
if(countelectricfeedbbean.vecC1.size() == 0)
{
d = 0.0D;
countelectricfeedbbean.setStatusCode(8832);
} else
if(countelectricfeedbbean.vecC1.size() == 1)
{
countelectricfeedbbean.setTableName("electricmeterinfo");
countelectricfeedbbean.setSelectSQL08(" SELECT METERDATA FROM " + countelectricfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE = ? AND DELFLAG = '0') ");
try
{
countelectricfeedbbean.select08();
countelectricfeedbbean.getDataFromResult08();
}
catch(Exception exception11)
{
throw exception11;
}
if(countelectricfeedbbean.getStatusCode() == 8851)
{
d = 0.0D;
countelectricfeedbbean.setStatusCode(8832);
} else
if(countelectricfeedbbean.vecM1.size() == 1)
{
beanm.setSubAreaNumb(countelectricfeedbbean.getSubareanumb());
beanm.setBuildingNumb(countelectricfeedbbean.getBuildingnumb());
beanm.setDoorNumb(countelectricfeedbbean.getDoornumb());
beanm.setFloorNumb(countelectricfeedbbean.getFloornumb());
beanm.setCellNumb(countelectricfeedbbean.getCellnumb());
beanm.setTableName("roomexam");
beanm.setSelectSQL07("select max(powernumber) from " + beanm.getTableName() + " where subarea = ? and building = ? and stair=? and floor=? and cell=? and delflag='0'");
beanm.select07();
beanm.getDataFromResult07();
if(beanm.getMeterData().equals(""))
d = Double.parseDouble(countelectricfeedbbean.vecM1.elementAt(0).toString());
else
d = Double.parseDouble(countelectricfeedbbean.vecM1.elementAt(0).toString()) - Double.parseDouble(beanm.getMeterData());
countelectricfeedbbean.setStatusCode(8832);
}
} else
if(countelectricfeedbbean.vecC1.size() > 1)
{
countelectricfeedbbean.setTableName("electricmeterinfo");
countelectricfeedbbean.setSelectSQL08(" SELECT METERDATA FROM " + countelectricfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE = ? AND DELFLAG = '0')");
try
{
countelectricfeedbbean.select08();
countelectricfeedbbean.getDataFromResult08();
}
catch(Exception exception12)
{
throw exception12;
}
if(countelectricfeedbbean.getStatusCode() == 8851)
{
d = 0.0D;
countelectricfeedbbean.setStatusCode(8832);
} else
if(countelectricfeedbbean.vecM1.size() == 1)
{
double d2 = Double.parseDouble(countelectricfeedbbean.vecM1.elementAt(0).toString());
countelectricfeedbbean.setTableName("electricmeterinfo");
countelectricfeedbbean.setSelectSQL09(" SELECT MAX(METERDATA) FROM " + countelectricfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE < ? AND DELFLAG = '0') ");
try
{
countelectricfeedbbean.select09();
countelectricfeedbbean.getDataFromResult09();
}
catch(Exception exception15)
{
throw exception15;
}
d = d2 - Double.parseDouble(countelectricfeedbbean.vecZ1.elementAt(0).toString());
countelectricfeedbbean.setStatusCode(8832);
}
}
countelectricfeedbbean.setBasefee(formatbean.parseIndex(d * Double.parseDouble(countelectricfeedbbean.vecQ1.elementAt(0).toString())));
countelectricfeedbbean.setMeterdata(String.valueOf(d));
countelectricfeedbbean.setTableName("electricbasefeelog");
countelectricfeedbbean.setInsertSQL03(" INSERT INTO " + countelectricfeedbbean.getTableName() + " ( NUMBER, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, METERNUM, CYCLENUM, METERDATA, BASEFEE,OTHERFEE, ALLFEE, FLAG, CASHFLAG, DELFLAG) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ");
countelectricfeedbbean.setOtherfee("0");
countelectricfeedbbean.setAllfee(countelectricfeedbbean.getBasefee());
try
{
countelectricfeedbbean.selectMaxnum();
countelectricfeedbbean.insert03();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -