📄 countwaterfeeservlet.java
字号:
countwaterfeedbbean.setStatusCode(8672);
}
} else
if(countwaterfeedbbean.vecC1.size() > 1)
{
countwaterfeedbbean.setTableName("watermeterinfo");
countwaterfeedbbean.setSelectSQL04(" SELECT METERDATA FROM " + countwaterfeedbbean.getTableName() + " WHERE( SUBAREANUMB = ? AND BUILDINGNUMB = ? AND DOORNUMB = ? AND FLOORNUMB = ? AND CELLNUMB = ? AND CYCLE = ? AND DELFLAG = '0')");
try
{
countwaterfeedbbean.select04();
countwaterfeedbbean.getDataFromResult04();
}
catch(Exception exception10)
{
throw exception10;
}
if(countwaterfeedbbean.getStatusCode() == 8671)
{
d = 0.0D;
countwaterfeedbbean.setStatusCode(8672);
} else
if(countwaterfeedbbean.vecM1.size() == 1)
{
double d2 = Double.parseDouble(countwaterfeedbbean.vecM1.elementAt(0).toString());
countwaterfeedbbean.setTableName("watermeterinfo");
countwaterfeedbbean.setSelectSQL05(" SELECT MAX(METERDATA) FROM " + countwaterfeedbbean.getTableName() + " WHERE( SUBAREANUMB = ? AND BUILDINGNUMB = ? AND DOORNUMB = ? AND FLOORNUMB = ? AND CELLNUMB = ? AND CYCLE < ? AND DELFLAG = '0')");
try
{
countwaterfeedbbean.select05();
countwaterfeedbbean.getDataFromResult05();
}
catch(Exception exception17)
{
throw exception17;
}
d = d2 - Double.parseDouble(countwaterfeedbbean.vecZ1.elementAt(0).toString());
countwaterfeedbbean.setStatusCode(8672);
}
}
countwaterfeedbbean.setBasefee(formatbean.parseIndex(d * Double.parseDouble(countwaterfeedbbean.vecQ1.elementAt(0).toString())));
countwaterfeedbbean.setMeterdata(String.valueOf(d));
countwaterfeedbbean.setTableName("waterbasefeelog");
countwaterfeedbbean.setInsertSQL01(" INSERT INTO " + countwaterfeedbbean.getTableName() + " ( NUMBER, SUBAREANUMB, BUILDINGNUMB, DOORNUMB, FLOORNUMB, CELLNUMB, CYCLENUM, METERDATA ,BASEFEE, OTHERFEE, ALLFEE, FLAG, CASHFLAG, DELFLAG) VALUES (?,?,?,?,?,?,?,?,?,0,0,?,?,?) ");
try
{
countwaterfeedbbean.selectMaxnum();
countwaterfeedbbean.insert01();
}
catch(Exception exception11)
{
throw exception11;
}
double d3 = 0.0D;
double d6 = 0.0D;
countwaterfeedbbean.setBasefeenum(countwaterfeedbbean.getNumber());
for(int k = 0; k < countwaterfeedbbean.vecS1.size(); k++)
{
if(countwaterfeedbbean.vecS2.elementAt(k).toString().equals("0"))
d3 = d * Double.parseDouble(countwaterfeedbbean.vecS3.elementAt(k).toString());
else
if(countwaterfeedbbean.vecS2.elementAt(k).toString().equals("1"))
d3 = Double.parseDouble(countwaterfeedbbean.vecS3.elementAt(k).toString());
d3 = Double.parseDouble(formatbean.fomatDouble(String.valueOf(d3)));
d3 = Double.parseDouble(formatbean.parseIndex(d3));
d6 += d3;
countwaterfeedbbean.setItemnum(countwaterfeedbbean.vecS1.elementAt(k).toString());
countwaterfeedbbean.setItemfee(formatbean.parseIndex(d3));
countwaterfeedbbean.setTableName("waterotherfeelog");
countwaterfeedbbean.setInsertSQL02(" INSERT INTO " + countwaterfeedbbean.getTableName() + " (NUMBER, BASEFEENUM,ITEMNUM, ITEMFEE, DELFLAG) VALUES (?,?,?,?,?) ");
try
{
countwaterfeedbbean.selectMaxnum();
countwaterfeedbbean.insert02();
}
catch(Exception exception19)
{
throw exception19;
}
}
countwaterfeedbbean.setTableName("waterbasefeelog");
countwaterfeedbbean.setOtherfee(formatbean.parseIndex(d6));
countwaterfeedbbean.setAllfee(formatbean.parseIndex(d6 + 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.setOpcontent("批量计算小区住户应缴纳水费费用");
HttpSession httpsession = httpservletrequest.getSession(false);
countwaterfeedbbean.setOperator((String)httpsession.getValue("persname"));
countwaterfeedbbean.setOpdate(datetimebean1.getDate());
countwaterfeedbbean.setOptime(datetimebean1.getTime());
countwaterfeedbbean.insertLog();
countwaterfeedbbean.commitToDB();
countwaterfeedbbean.setStatusCode(8710);
countwaterfeedbbean.setStatusMessage("成功计算水费收费信息及附加费信息！");
} else
if(countwaterfeedbbean.getCountby() == 1)
{
for(int j = 0; j < countwaterfeedbbean.vecL1.size(); j++)
{
double d1 = 0.0D;
countwaterfeedbbean.setSubareanumb(countwaterfeedbbean.vecL1.elementAt(j).toString());
countwaterfeedbbean.setBuildingnumb(countwaterfeedbbean.vecL2.elementAt(j).toString());
countwaterfeedbbean.setDoornumb(countwaterfeedbbean.vecL3.elementAt(j).toString());
countwaterfeedbbean.setFloornumb(countwaterfeedbbean.vecL4.elementAt(j).toString());
countwaterfeedbbean.setCellnumb(countwaterfeedbbean.vecL5.elementAt(j).toString());
countwaterfeedbbean.setTableName("apparatusfit,apparatusinfo");
countwaterfeedbbean.setSelectSQL06(" SELECT apparatusfit.APPARATUS FROM " + countwaterfeedbbean.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
{
countwaterfeedbbean.select06();
countwaterfeedbbean.getDataFromResult06();
}
catch(Exception exception12)
{
throw exception12;
}
if(countwaterfeedbbean.getStatusCode() == 8681)
{
countwaterfeedbbean.vecTemp1.addElement(countwaterfeedbbean.vecL1.elementAt(j).toString());
countwaterfeedbbean.vecTemp2.addElement(countwaterfeedbbean.vecL2.elementAt(j).toString());
countwaterfeedbbean.vecTemp3.addElement(countwaterfeedbbean.vecL3.elementAt(j).toString());
countwaterfeedbbean.vecTemp4.addElement(countwaterfeedbbean.vecL4.elementAt(j).toString());
countwaterfeedbbean.vecTemp5.addElement(countwaterfeedbbean.vecL5.elementAt(j).toString());
} else
{
countwaterfeedbbean.setMeternum(countwaterfeedbbean.vecN1.elementAt(0).toString());
countwaterfeedbbean.setTableName("watermeterinfo");
countwaterfeedbbean.setSelectSQL07(" SELECT METERDATA FROM " + countwaterfeedbbean.getTableName() + " WHERE( METERNUM = ? AND CYCLE <= ? AND DELFLAG = '0')");
try
{
countwaterfeedbbean.select07();
countwaterfeedbbean.getDataFromResult07();
}
catch(Exception exception13)
{
throw exception13;
}
if(countwaterfeedbbean.vecC1.size() == 0)
{
d1 = 0.0D;
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 exception14)
{
throw exception14;
}
if(countwaterfeedbbean.getStatusCode() == 8691)
{
d1 = 0.0D;
countwaterfeedbbean.setStatusCode(8672);
} else
if(countwaterfeedbbean.vecM1.size() == 1)
{
statwaterpaydbbean.setSubAreaNumb(countwaterfeedbbean.getSubareanumb());
statwaterpaydbbean.setBuildingNumb(countwaterfeedbbean.getBuildingnumb());
statwaterpaydbbean.setDoorNumb(countwaterfeedbbean.getDoornumb());
statwaterpaydbbean.setFloorNumb(countwaterfeedbbean.getFloornumb());
statwaterpaydbbean.setCellNumb(countwaterfeedbbean.getCellnumb());
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -