retrievefitapplydbbean.java

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

    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 setDate(String s)
    {
        date = 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 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 setPageindex(int i)
    {
        pageindex = i;
    }

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

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

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

    public void setResult02()
        throws Exception
    {
        try
        {
            int i = result.getNumRowsInCache();
            if(i != 0)
            {
                if(i % 5 != 0)
                {
                    if(i > 5)
                        pagecount = i / 5;
                    else
                        pagecount = 0;
                } else
                if(i > 5)
                    pagecount = i / 5 - 1;
                else
                    pagecount = 0;
                for(int j = 5 * pageindex; j < 5 * (pageindex + 1); j++)
                {
                    if(j == i)
                        break;
                    result.setCurrentRow(j + 1);
                    numbervec.addElement(result.getColumnValueToString("number"));
                    subareavec.addElement(result.getColumnValueToString("subarea"));
                    buildingvec.addElement(result.getColumnValueToString("building"));
                    stairvec.addElement(result.getColumnValueToString("stair"));
                    floorvec.addElement(result.getColumnValueToString("floor"));
                    cellvec.addElement(result.getColumnValueToString("cell"));
                    namevec.addElement(result.getColumnValueToString("name"));
                    touchwayvec.addElement(result.getColumnValueToString("touchway"));
                    applydatevec.addElement(result.getColumnValueToString("applydate"));
                    if(result.getColumnValueToString("acceptsign").equals("0"))
                        acceptsignvec.addElement("未验收");
                    else
                        acceptsignvec.addElement("已验收");
                    if(result.getColumnValueToString("sign").equals("0"))
                        signvec.addElement("未批准");
                    else
                        signvec.addElement("已批准");
                }

                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 setSelect02(String s)
    {
        select02 = 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 setTheSqlStatement()
    {
        switch(Integer.parseInt(getRetrieveindex()))
        {
        case 0: // '\0'
            setSelect02((String)allSqlStatement.elementAt(0));
            break;

        case 1: // '\001'
            setSelect02((String)allSqlStatement.elementAt(1));
            break;

        case 2: // '\002'
            setSelect02((String)allSqlStatement.elementAt(2));
            break;

        case 3: // '\003'
            setSelect02((String)allSqlStatement.elementAt(3));
            break;

        case 4: // '\004'
            setSelect02((String)allSqlStatement.elementAt(4));
            break;

        case 5: // '\005'
            setSelect02((String)allSqlStatement.elementAt(5));
            break;

        case 6: // '\006'
            setSelect02((String)allSqlStatement.elementAt(6));
            break;

        case 7: // '\007'
            setSelect02((String)allSqlStatement.elementAt(7));
            break;

        case 8: // '\b'
            setSelect02((String)allSqlStatement.elementAt(8));
            break;

        case 9: // '\t'
            setSelect02((String)allSqlStatement.elementAt(9));
            break;

        case 10: // '\n'
            setSelect02((String)allSqlStatement.elementAt(10));
            break;

        default:
            setSelect02((String)allSqlStatement.elementAt(0));
            break;
        }
    }

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

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

    public void setUpdownindex()
    {
        int i = getPageindex();
        int j = getPagecount();
        if((i == 0) & (j != 0))
            updownindex = "1";
        if((i == j) & (j != 0))
            updownindex = "2";
        if((i > 0) & (i < j))
            updownindex = "3";
    }
}