retrievetodayplandbbean.java

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

            statementmetadata.addParameter("plantype1", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("startdate1", Date.valueOf(getStartdate()));
            selectStatement01.setParameter("plantype1", getPlantype());
            break;

        case 4: // '\004'
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("startdate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            statementmetadata.addParameter("plandate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("startdate1", Date.valueOf(getStartdate()));
            selectStatement01.setParameter("plandate1", Date.valueOf(getPlandate()));
            break;

        default:
            statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
            statementmetadata.addParameter("startdate1", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
            selectStatement01.setParameter("delflag", getDelFlag());
            selectStatement01.setParameter("startdate1", Date.valueOf(getStartdate()));
            break;
        }
    }

    public void selectSQL01()
        throws Exception
    {
        try
        {
            initSelectSQL011();
            selectStatement01.execute();
            result = selectStatement01.getResult();
            setStatusCode(0x66c89);
            setStatusMessage("查询所有文章失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x66c8a);
            setStatusMessage("查询所有文章的SQL语句初始化失败");
            switch(dataexception.getErrorCode())
            {
            case 214: 
                setStatusCode(0x66c8b);
                setStatusMessage("查询所有文章的SQL语句执行失败");
                break;

            default:
                throw dataexception;
            }
        }
    }

    public void setAllSqlStatement()
    {
        allSqlStatement.addElement(new String("SELECT NUMBER,planname,plandept,plantype,plandate FROM planinfo  WHERE ((DELFLAG=?)and (startdate=?)) ORDER BY number DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,planname,plandept,plantype,plandate FROM planinfo  WHERE ((DELFLAG=?)and (startdate=?) AND (planname =?)) ORDER BY number DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,planname,plandept,plantype,plandate FROM planinfo  WHERE ((DELFLAG=?)and (startdate=?) AND (plandept= ?)) ORDER BY  number  DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,planname,plandept,plantype,plandate FROM planinfo  WHERE ((DELFLAG=?)and (startdate=?) AND (plantype= ?)) ORDER  BY  number DESC"));
        allSqlStatement.addElement(new String("SELECT NUMBER,planname,plandept,plantype,plandate FROM planinfo  WHERE ((DELFLAG=?)and (startdate=?) AND (plandate=? )) ORDER BY  number DESC"));
    }

    public void setAllcheck(String s)
    {
        allcheck = s;
    }

    public void setAuditcontent(String s)
    {
        auditcontent = s;
    }

    public void setAuditdate(String s)
    {
        auditdate = s;
    }

    public void setAuditman(String s)
    {
        auditman = s;
    }

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

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

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

    public void setPageindex(int i)
    {
        pageindex = i;
    }

    public void setPlancontent(String s)
    {
        plancontent = s;
    }

    public void setPlandate(String s)
    {
        plandate = s;
    }

    public void setPlandept(String s)
    {
        plandept = s;
    }

    public void setPlanman(String s)
    {
        planman = s;
    }

    public void setPlanname(String s)
    {
        planname = s;
    }

    public void setPlantype(String s)
    {
        plantype = s;
    }

    public void setResultall()
        throws Exception
    {
        try
        {
            if(result.getNumRowsInCache() != 0)
            {
                setAllcheck(String.valueOf(result.getNumRowsInCache()));
                if(result.getNumRowsInCache() % 5 != 0)
                {
                    if(result.getNumRowsInCache() > 5)
                        pagecount = result.getNumRowsInCache() / 5;
                    else
                        pagecount = 0;
                } else
                if(result.getNumRowsInCache() > 5)
                    pagecount = result.getNumRowsInCache() / 5 - 1;
                else
                    pagecount = 0;
                for(int i = 5 * pageindex; i < 5 * (pageindex + 1); i++)
                {
                    if(i == result.getNumRowsInCache())
                        break;
                    result.setCurrentRow(i + 1);
                    numbervec.addElement(result.getColumnValueToString("number"));
                    plannamevec.addElement(result.getColumnValueToString("planname"));
                    plandeptvec.addElement(result.getColumnValueToString("plandept"));
                    plantypevec.addElement(result.getColumnValueToString("plantype"));
                    plandatevec.addElement(result.getColumnValueToString("plandate"));
                }

                setStatusCode(0x66c8c);
                setStatusMessage("查询主题下所有文章成功");
            } else
            {
                setStatusCode(0x66c8d);
                setStatusMessage("对不起，没有符合条件的文章");
            }
        }
        catch(Exception exception1)
        {
            setStatusCode(0x66c8e);
            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 setSelectSQL01(String s)
    {
        selectSQL01 = s;
    }

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

    public void setTheSqlStatement()
    {
        switch(Integer.parseInt(getRetrieveindex()))
        {
        case 0: // '\0'
            setSelectSQL01((String)allSqlStatement.elementAt(0));
            break;

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

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

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

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

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

    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";
    }
}