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