siretrievefitapplydbbean.java

华磊物业管理系统源码 (仅供参考)

        statementmetadata.addColumn("approve", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("approveman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("approvedate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("deposit", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("inoutpaper", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("paperman", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("paperdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("accept1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptman1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptdate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("accept2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptman2", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("acceptdate2", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addColumn("overduedays", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addColumn("overduefee", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("forfeit", class$java$lang$Double == null ? (class$java$lang$Double = class$("java.lang.Double")) : class$java$lang$Double, 8);
        statementmetadata.addColumn("acceptsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("sign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addColumn("returnsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        selectSql01.setParameter("number", new Integer(getNumber()));
    }

    public void select01()
        throws Exception
    {
        try
        {
            initSelect01();
            selectSql01.execute();
            result = selectSql01.getResult();
            setStatusCode(2052);
            setStatusMessage("查询指定装修申请记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(2053);
            setStatusMessage("查询指定装修申请记录的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(2054);
                setStatusMessage("查询指定装修申请记录的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAccept1(String s)
    {
        accept1 = s;
    }

    public void setAccept2(String s)
    {
        accept2 = s;
    }

    public void setAcceptdate1(String s)
    {
        acceptdate1 = s;
    }

    public void setAcceptdate2(String s)
    {
        acceptdate2 = s;
    }

    public void setAcceptman1(String s)
    {
        acceptman1 = s;
    }

    public void setAcceptman2(String s)
    {
        acceptman2 = s;
    }

    public void setAcceptsign(String s)
    {
        acceptsign = s;
    }

    public void setApply(String s)
    {
        apply = s;
    }

    public void setApplydate(String s)
    {
        applydate = s;
    }

    public void setApprove(String s)
    {
        approve = s;
    }

    public void setApprovedate(String s)
    {
        approvedate = s;
    }

    public void setApproveman(String s)
    {
        approveman = s;
    }

    public void setBuilding(String s)
    {
        building = s;
    }

    public void setCell(String s)
    {
        cell = s;
    }

    public void setDelflag(String s)
    {
        delflag = s;
    }

    public void setDeposit(String s)
    {
        deposit = s;
    }

    public void setEnddate(String s)
    {
        enddate = s;
    }

    public void setFloor(String s)
    {
        floor = s;
    }

    public void setForfeit(String s)
    {
        forfeit = s;
    }

    public void setHeadidno(String s)
    {
        headidno = s;
    }

    public void setHeadtel(String s)
    {
        headtel = s;
    }

    public void setInoutpaper(String s)
    {
        inoutpaper = s;
    }

    public void setMagicindex(String s)
    {
        magicindex = s;
    }

    public void setName(String s)
    {
        name = s;
    }

    public void setNoses(String s)
    {
        noses = s;
    }

    public void setNumber(String s)
    {
        number = s;
    }

    public void setOverduedays(String s)
    {
        overduedays = s;
    }

    public void setOverduefee(String s)
    {
        overduefee = s;
    }

    public void setOwneridno(String s)
    {
        owneridno = s;
    }

    public void setOwnertel(String s)
    {
        ownertel = s;
    }

    public void setPagecount(String s)
    {
        pagecount = s;
    }

    public void setPageindex(String s)
    {
        pageindex = s;
    }

    public void setPaperdate(String s)
    {
        paperdate = s;
    }

    public void setPaperman(String s)
    {
        paperman = s;
    }

    public void setRemark(String s)
    {
        remark = s;
    }

    public void setResult01()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() != 0)
            {
                result.firstRow();
                setSubarea(result.getColumnValueToString("subarea"));
                setBuilding(result.getColumnValueToString("building"));
                setStair(result.getColumnValueToString("stair"));
                setFloor(result.getColumnValueToString("floor"));
                setCell(result.getColumnValueToString("cell"));
                setName(result.getColumnValueToString("name"));
                setTouchway(result.getColumnValueToString("touchway"));
                setApplydate(result.getColumnValueToString("applydate"));
                setApply(result.getColumnValueToString("apply"));
                if(result.getColumnValue("team") != null)
                    setTeam(result.getColumnValueToString("team"));
                if(result.getColumnValue("teamno") != null)
                    setTeamno(result.getColumnValueToString("teamno"));
                if(result.getColumnValue("teamgrantno") != null)
                    setTeamgrantno(result.getColumnValueToString("teamgrantno"));
                if(result.getColumnValue("teamlevel") != null)
                    setTeamlevel(result.getColumnValueToString("teamlevel"));
                if(result.getColumnValue("owneridno") != null)
                    setOwneridno(result.getColumnValueToString("owneridno"));
                if(result.getColumnValue("ownertel") != null)
                    setOwnertel(result.getColumnValueToString("ownertel"));
                if(result.getColumnValue("headidno") != null)
                    setHeadidno(result.getColumnValueToString("headidno"));
                if(result.getColumnValue("headtel") != null)
                    setHeadtel(result.getColumnValueToString("headtel"));
                if(result.getColumnValue("startdate") != null)
                    setStartdate(result.getColumnValueToString("startdate"));
                if(result.getColumnValue("enddate") != null)
                    setEnddate(result.getColumnValueToString("enddate"));
                if(result.getColumnValue("noses") != null)
                    setNoses(result.getColumnValueToString("noses"));
                if(result.getColumnValue("transactor") != null)
                    setTransactor(result.getColumnValueToString("transactor"));
                if(result.getColumnValue("approve") != null)
                    setApprove(result.getColumnValueToString("approve"));
                if(result.getColumnValue("approveman") != null)
                    setApproveman(result.getColumnValueToString("approveman"));
                if(result.getColumnValue("approvedate") != null)
                    setApprovedate(result.getColumnValueToString("approvedate"));
                if(result.getColumnValue("deposit") != null)
                    setDeposit(result.getColumnValueToString("deposit"));
                if(result.getColumnValue("inoutpaper") != null)
                    setInoutpaper(result.getColumnValueToString("inoutpaper"));
                if(result.getColumnValue("paperman") != null)
                    setPaperman(result.getColumnValueToString("paperman"));
                if(result.getColumnValue("paperdate") != null)
                    setPaperdate(result.getColumnValueToString("paperdate"));
                if(result.getColumnValue("accept1") != null)
                    setAccept1(result.getColumnValueToString("accept1"));
                if(result.getColumnValue("acceptman1") != null)
                    setAcceptman1(result.getColumnValueToString("acceptman1"));
                if(result.getColumnValue("acceptdate1") != null)
                    setAcceptdate1(result.getColumnValueToString("acceptdate1"));
                if(result.getColumnValue("accept2") != null)
                    setAccept2(result.getColumnValueToString("accept2"));
                if(result.getColumnValue("acceptman2") != null)
                    setAcceptman2(result.getColumnValueToString("acceptman2"));
                if(result.getColumnValue("acceptdate2") != null)
                    setAcceptdate2(result.getColumnValueToString("acceptdate2"));
                if(result.getColumnValue("overduedays") != null)
                    setOverduedays(result.getColumnValueToString("overduedays"));
                if(result.getColumnValue("overduefee") != null)
                    setOverduefee(result.getColumnValueToString("overduefee"));
                if(result.getColumnValue("forfeit") != null)
                    setForfeit(result.getColumnValueToString("forfeit"));
                setAcceptsign(result.getColumnValueToString("acceptsign"));
                setSign(result.getColumnValueToString("sign"));
                if(result.getColumnValue("remark") != null)
                    setRemark(result.getColumnValueToString("remark"));
                if(result.getColumnValue("returnsign") != null)
                    setReturnsign(result.getColumnValueToString("returnsign"));
                setStatusCode(2055);
                setStatusMessage("查询指定装修申请记录成功");
            } else
            {
                setStatusCode(2056);
                setStatusMessage("对不起，没有符合条件的装修申请记录");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(2057);
            setStatusMessage("处理装修申请记录结果集出错");
            throw exception1;
        }
        finally
        {
            closeResultSet();
        }
    }

    public void setRetrievecom(String s)
    {
        retrievecom = s;
    }

    public void setRetrievecon(String s)
    {
        retrievecon = s;
    }

    public void setRetrieveindex(String s)
    {
        retrieveindex = s;
    }

    public void setReturnsign(String s)
    {
        returnsign = s;
    }

    public void setSelect01(String s)
    {
        select01 = s;
    }

    public void setSelectnum(String s)
    {
        selectnum = s;
    }

    public void setSign(String s)
    {
        sign = s;
    }

    public void setStair(String s)
    {
        stair = s;
    }

    public void setStartdate(String s)
    {
        startdate = s;
    }

    public void setSubarea(String s)
    {
        subarea = s;
    }

    public void setTeam(String s)
    {
        team = s;
    }

    public void setTeamgrantno(String s)
    {
        teamgrantno = s;
    }

    public void setTeamlevel(String s)
    {
        teamlevel = s;
    }

    public void setTeamno(String s)
    {
        teamno = s;
    }

    public void setTouchway(String s)
    {
        touchway = s;
    }

    public void setTransactor(String s)
    {
        transactor = s;
    }
}