📄 retrievepayfeedbbean.java
字号:
{
return year;
}
public void initSelect01()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement01 = new SelectStatement();
selectStatement01.setConnection(connBean);
statementmetadata = selectStatement01.getMetaData();
statementmetadata.setSQL(getSelectSQL01());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("subareanumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("buildingnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("doornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("floornumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("cellnumb", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addParameter("feenum", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
if(!getStartDate().equals("") && ((String)vecQ17.elementAt(0)).trim().equals("1"))
statementmetadata.addParameter("date1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
if(!getEndDate().equals("") && ((String)vecQ17.elementAt(0)).trim().equals("1"))
statementmetadata.addParameter("date2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
selectStatement01.setParameter("subareanumb", getSubAreaNumb());
selectStatement01.setParameter("buildingnumb", getBuildingNumb());
selectStatement01.setParameter("doornumb", getDoorNumb());
selectStatement01.setParameter("floornumb", getFloorNumb());
selectStatement01.setParameter("cellnumb", getCellNumb());
selectStatement01.setParameter("feenum", getItemNum());
if(!getStartDate().equals("") && ((String)vecQ17.elementAt(0)).trim().equals("1"))
selectStatement01.setParameter("date1", Date.valueOf(getStartDate()));
if(!getEndDate().equals("") && ((String)vecQ17.elementAt(0)).trim().equals("1"))
selectStatement01.setParameter("date2", Date.valueOf(getEndDate()));
statementmetadata.addColumn("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("feenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("cyclenum", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("payname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("optionname", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
statementmetadata.addColumn("paydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("paytime", class$java$sql$Time == null ? (class$java$sql$Time = class$("java.sql.Time")) : class$java$sql$Time, 92);
statementmetadata.addColumn("basefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addColumn("otherfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addColumn("latefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addColumn("allfee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addColumn("salerate", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
statementmetadata.addColumn("salefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
if(((String)vecQ17.elementAt(0)).trim().equals("1"))
{
statementmetadata.addColumn("feecycle", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
statementmetadata.addColumn("startdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("enddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("paystartdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
statementmetadata.addColumn("payenddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
}
}
public void initSelect02()
throws DataException
{
StatementMetaData statementmetadata = null;
selectStatement02 = new SelectStatement();
selectStatement02.setConnection(connBean);
statementmetadata = selectStatement02.getMetaData();
statementmetadata.setSQL(getSelectSQL01());
statementmetadata.addTable(getTableName());
statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
selectStatement02.setParameter("number", new Integer(getItemNum()));
statementmetadata.addColumn("cycleflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
}
public void parseDate(String s)
{
int i = 0;
i = s.indexOf("-");
setYear(s.substring(0, i));
setMonth(s.substring(i + 1));
}
public void select01()
throws Exception
{
try
{
initSelect01();
selectStatement01.execute();
result = selectStatement01.getResult();
result.firstRow();
setPages(result.getNumRowsInCache(), getPageLength());
setStatusCode(7861);
setStatusMessage("查询付费记录表成功");
}
catch(DataException dataexception)
{
setStatusCode(7862);
setStatusMessage("查询付费记录表时发生错误--" + dataexception.getMessage());
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(7863);
setStatusMessage("查询付费记录表结果为空");
break;
default:
throw dataexception;
}
}
}
public void select02()
throws Exception
{
try
{
initSelect02();
selectStatement02.execute();
result = selectStatement02.getResult();
result.firstRow();
setStatusCode(7861);
setStatusMessage("检索是否是周期收费成功");
}
catch(DataException dataexception)
{
setStatusCode(7862);
setStatusMessage("检索是否是周期收费时发生错误--" + dataexception.getMessage());
switch(dataexception.getErrorCode())
{
case 214:
setStatusCode(7863);
setStatusMessage("检索是否是周期收费时结果为空");
break;
default:
throw dataexception;
}
}
}
public void setBuildingNumb(String s)
{
buildingNumb = s;
}
public void setCellNumb(String s)
{
cellNumb = s;
}
public void setDate1(String s)
{
date1 = s;
}
public void setDate2(String s)
{
date2 = s;
}
public void setDoorNumb(String s)
{
doorNumb = s;
}
public void setEndDate(String s)
{
endDate = s;
}
public void setFloorNumb(String s)
{
floorNumb = s;
}
public void setItemNum(String s)
{
itemNum = s;
}
public void setMonth(String s)
{
month = s;
}
public void setPage(int i)
{
page = i;
}
public void setPageLength(int i)
{
pageLength = i;
}
public void setPages(int i, int j)
{
int k = 0;
if(i % j != 0)
{
if(i > j)
k = i / j + 1;
else
k = 1;
} else
if(i > j)
k = i / j;
else
k = 1;
pages = k;
}
public void setSelectSQL01()
{
try
{
Calendar calendar = Calendar.getInstance();
String s = String.valueOf(calendar.get(1));
String s1 = " select payfeelog.number,payfeelog.feenum,payfeelog.cyclenum,payfeelog.payname,payfeelog.optionname,payfeelog.paydate,payfeelog.paytime,payfeelog.basefee,payfeelog.otherfee,payfeelog.latefee,payfeelog.allfee,payfeelog.salerate,payfeelog.salefee";
if(((String)vecQ17.elementAt(0)).trim().equals("1"))
{
s1 = s1 + ",feecycle.feecycle,feecycle.startdate,feecycle.enddate,feecycle.paystartdate,feecycle.payenddate from " + getTableName() + "," + getTableName1() + " where ( payfeelog.cyclenum = feecycle.number )and(payfeelog.delflag = '0')and (feecycle.delflag = '0') and (payfeelog.subareanumb = ?) and (payfeelog.buildingnumb = ?) and (payfeelog.doornumb = ?) and (payfeelog.floornumb = ?) and (payfeelog.cellnumb = ?) ";
if(getItemNum().equals("4"))
s1 = s1 + " and (payfeelog.feenum = ? or payfeelog.feenum = 5 or payfeelog.feenum = 6)";
else
s1 = s1 + " and (payfeelog.feenum = ?)";
} else
{
s1 = s1 + " from " + getTableName() + " where (payfeelog.delflag = '0')and (payfeelog.subareanumb = ?) and (payfeelog.buildingnumb = ?) and (payfeelog.doornumb = ?) and (payfeelog.floornumb = ?) and (payfeelog.cellnumb = ?) and (payfeelog.feenum = ?)";
}
String s2 = "order by paydate desc, paytime desc";
if(!getDate1().equals("-"))
{
parseDate(getDate1());
if(getYear().trim().equals(""))
setStartDate(s + "-" + getMonth() + "-01");
else
if(getMonth().trim().equals(""))
setStartDate(getYear() + "-01-01");
else
setStartDate(getYear() + "-" + getMonth() + "-01");
} else
{
setStartDate("");
}
if(!getDate2().equals("-"))
{
parseDate(getDate2());
if(getYear().trim().equals(""))
{
calendar.set(calendar.get(1), Integer.parseInt(getMonth()), 1);
calendar.add(2, 1);
setEndDate(calendar.get(1) + "-" + calendar.get(2) + "-01");
} else
if(getMonth().trim().equals(""))
{
setEndDate(String.valueOf(Integer.parseInt(getYear()) + 1) + "-01-01");
} else
{
calendar.set(Integer.parseInt(getYear()), Integer.parseInt(getMonth()), 1);
calendar.add(2, 1);
setEndDate(calendar.get(1) + "-" + calendar.get(2) + "-01");
}
} else
{
setEndDate("");
}
if(!getStartDate().equals(""))
s1 = s1 + " and (payfeelog.paydate>=?)";
if(!getEndDate().equals(""))
s1 = s1 + " and (payfeelog.paydate<?)";
s1 = s1 + s2;
selectSQL01 = s1;
setStatusCode(7861);
}
catch(Exception exception)
{
setStatusCode(7865);
setStatusMessage("组合sql语句时出错");
System.out.println("组合sql语句时出错" + exception);
}
}
public void setSelectSQL01(String s)
{
selectSQL01 = s;
}
public void setStartDate(String s)
{
startDate = s;
}
public void setSubAreaNumb(String s)
{
subAreaNumb = s;
}
public void setTableName1(String s)
{
tableName1 = s;
}
public void setYear(String s)
{
year = s;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -