📄 countelectricfeedbbean.java
字号:
protected void initUpdate01()
throws DataException, IOException
{
StatementMetaData statementmetadata = null;
updateStatement01 = new SQLStatement();
updateStatement01.setConnection(connBean);
statementmetadata = updateStatement01.getMetaData();
statementmetadata.setSQL(getUpdate01());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("otherfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
updateStatement01.setParameter("otherfee", new Double(getItemfee()));
updateStatement01.setParameter("allfee", new Double(getItemfee()));
updateStatement01.setParameter("number", new Integer(getBasefeenum()));
}
public void insert01()
throws Exception
{
try
{
initInsert01();
insertStatement01.execute();
setStatusMessage("插入数据库electricbasefeelog成功");
setStatusCode(8862);
}
catch(Exception exception)
{
setStatusMessage("插入数据库electricbasefeelog时发生错误--" + exception.getMessage());
setStatusCode(8863);
throw exception;
}
}
public void insert02()
throws Exception
{
try
{
initInsert02();
insertStatement02.execute();
setStatusMessage("插入数据库electricotherfeelog成功");
setStatusCode(8864);
}
catch(Exception exception)
{
setStatusMessage("插入数据库electricotherfeelog时发生错误--" + exception.getMessage());
setStatusCode(8865);
throw exception;
}
}
public void insert03()
throws Exception
{
try
{
initInsert03();
insertStatement03.execute();
setStatusMessage("插入数据库electricbasefeelog成功");
setStatusCode(8866);
}
catch(Exception exception)
{
setStatusMessage("插入数据库electricbasefeelog时发生错误--" + exception.getMessage());
setStatusCode(8867);
throw exception;
}
}
public void select01()
throws Exception
{
try
{
initSelect01();
selectStatement01.execute();
result = selectStatement01.getResult();
result.firstRow();
setStatusMessage("检索收费项目表成功");
setStatusCode(8812);
}
catch(DataException dataexception)
{
setStatusMessage("检索收费项目表出错");
setStatusCode(8813);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有电费每收费单位收取费用");
setStatusCode(8814);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select02()
throws Exception
{
try
{
initSelect02();
selectStatement02.execute();
result = selectStatement02.getResult();
result.firstRow();
setStatusMessage("检索入住记录表成功");
setStatusCode(8817);
}
catch(DataException dataexception)
{
setStatusMessage("检索入住记录表出错");
setStatusCode(8818);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("入住记录表住户入住信息");
setStatusCode(8819);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select03()
throws Exception
{
try
{
initSelect03();
selectStatement03.execute();
result = selectStatement03.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本单元抄表记录成功");
setStatusCode(8823);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本单元抄表记录出错");
setStatusCode(8824);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有本单元电表抄表记录");
setStatusCode(8825);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select04()
throws Exception
{
try
{
initSelect04();
selectStatement04.execute();
result = selectStatement04.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本周期抄表读数成功");
setStatusCode(8828);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本周期抄表读数出错");
setStatusCode(8829);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有电表抄表记录本周期抄表读数");
setStatusCode(8831);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select05()
throws Exception
{
try
{
initSelect05();
selectStatement05.execute();
result = selectStatement05.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本周期前电表抄表读数最大数成功");
setStatusCode(8834);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本周期前电表抄表读数最大数出错");
setStatusCode(8835);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有电表抄表记录本周期前电表抄表读数最大数");
setStatusCode(8836);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select06()
throws Exception
{
try
{
initSelect06();
selectStatement06.execute();
result = selectStatement06.getResult();
result.firstRow();
setStatusMessage("检索本单元电表编号成功");
setStatusCode(8838);
}
catch(DataException dataexception)
{
setStatusMessage("检索本单元电表编号出错");
setStatusCode(8839);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有本单元电表编号");
setStatusCode(8841);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select07()
throws Exception
{
try
{
initSelect07();
selectStatement07.execute();
result = selectStatement07.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本单元抄表记录成功");
setStatusCode(8843);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本单元抄表记录出错");
setStatusCode(8844);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有本单元电表抄表记录");
setStatusCode(8845);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select08()
throws Exception
{
try
{
initSelect08();
selectStatement08.execute();
result = selectStatement08.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本周期抄表读数成功");
setStatusCode(8848);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本周期抄表读数出错");
setStatusCode(8849);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有电表抄表记录本周期抄表读数");
setStatusCode(8851);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select09()
throws Exception
{
try
{
initSelect09();
selectStatement09.execute();
result = selectStatement09.getResult();
result.firstRow();
setStatusMessage("检索电表抄表记录本周期前电表抄表读数最大数成功");
setStatusCode(8854);
}
catch(DataException dataexception)
{
setStatusMessage("检索电表抄表记录本周期前电表抄表读数最大数出错");
setStatusCode(8855);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("没有电表抄表记录本周期前电表抄表读数最大数");
setStatusCode(8856);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
}
}
public void select10()
throws Exception
{
try
{
initSelect10();
selectStatement10.execute();
result = selectStatement10.getResult();
result.firstRow();
setStatusMessage("检索分摊项目表成功");
setStatusCode(8858);
}
catch(DataException dataexception)
{
setStatusMessage("检索分摊项目表出错");
setStatusCode(8859);
switch(dataexception.getErrorCode())
{
case 214:
setStatusMessage("本期没有电费分摊项目信息");
setStatusCode(8861);
break;
default:
throw new Exception(getStatusMessage() + dataexception);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -