addfitapplydbbean.java

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

        statementmetadata = insertSql01.getMetaData();
        statementmetadata.setSQL(getInsert01());
        statementmetadata.addTable(getTableName());
        statementmetadata.addParameter("number", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("subarea", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("building", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("stair", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("floor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("cell", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("name", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("touchway", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("applydate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("apply", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("team", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("teamno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("teamgrantno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("teamlevel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("owneridno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("ownertel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("headidno", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("headtel", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("startdate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("enddate", class$java$sql$Date == null ? (class$java$sql$Date = class$("java.sql.Date")) : class$java$sql$Date, 91);
        statementmetadata.addParameter("noses", class$java$lang$Integer == null ? (class$java$lang$Integer = class$("java.lang.Integer")) : class$java$lang$Integer, 4);
        statementmetadata.addParameter("transactor", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("acceptsign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("sign", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("remark", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 12);
        statementmetadata.addParameter("delflag", class$java$lang$String == null ? (class$java$lang$String = class$("java.lang.String")) : class$java$lang$String, 1);
        insertSql01.setParameter("number", new Integer(getNumber()));
        insertSql01.setParameter("subarea", getSubarea());
        insertSql01.setParameter("building", getBuilding());
        insertSql01.setParameter("stair", getStair());
        insertSql01.setParameter("floor", getFloor());
        insertSql01.setParameter("cell", getCell());
        insertSql01.setParameter("name", getName());
        insertSql01.setParameter("touchway", getTouchway());
        insertSql01.setParameter("applydate", Date.valueOf(getApplydate()));
        insertSql01.setParameter("apply", getApply());
        insertSql01.setParameter("team", getTeam());
        insertSql01.setParameter("teamno", getTeamno());
        insertSql01.setParameter("teamgrantno", getTeamgrantno());
        insertSql01.setParameter("teamlevel", getTeamlevel());
        insertSql01.setParameter("owneridno", getOwneridno());
        insertSql01.setParameter("ownertel", getOwnertel());
        insertSql01.setParameter("headidno", getHeadidno());
        insertSql01.setParameter("headtel", getHeadtel());
        insertSql01.setParameter("startdate", getStartdate());
        insertSql01.setParameter("enddate", getEnddate());
        insertSql01.setParameter("noses", getNoses());
        insertSql01.setParameter("transactor", getTransactor());
        insertSql01.setParameter("acceptsign", getAcceptsign());
        insertSql01.setParameter("sign", getSign());
        insertSql01.setParameter("remark", getRemark());
        insertSql01.setParameter("delflag", getDelflag());
    }

    public void insert01()
        throws Exception
    {
        try
        {
            initInsert01();
            insertSql01.execute();
            setStatusCode(0x6b725);
            setStatusMessage("增加装修申请记录失败");
        }
        catch(DataException dataexception)
        {
            setStatusCode(0x6b726);
            setStatusMessage("增加装修申请记录的SQL语句初始化失败");
            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)
    {
        if(s.length() != 10)
            enddate = null;
        else
            enddate = Date.valueOf(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 setInsert01(String s)
    {
        insert01 = s;
    }

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

    public void setNoses(String s)
    {
        if(s.equals(""))
            noses = null;
        else
            noses = new Integer(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 setPaperdate(String s)
    {
        paperdate = s;
    }

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

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

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

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

    public void setStartdate(String s)
    {
        if(s.length() != 10)
            startdate = null;
        else
            startdate = Date.valueOf(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;
    }
}