boardroomsqlbuilder.java

来自「一个用java编写的功能强大的OA系统」· Java 代码 · 共 62 行

package com.redmoon.oa.meeting;

import cn.js.fan.util.StrUtil;


public class BoardroomSQLBuilder {
    public static final String RESULT_APPLY = "";
    public static final String RESULT_AGREE = "是";
    public static final String RESULT_DISAGREE = "否";
    public static final String RESULT_USED = "使用";
    public static final String RESULT_END = "结束";

    public BoardroomSQLBuilder() {
    }

    public static String getBoardroomApplySearchSql() {
        String sql =
                "select flowId from form_table_hysqd where result = " +
                StrUtil.sqlstr(RESULT_APPLY) + " order by flowId desc";
        return sql;
    }

    public static String getBoardroomAgreeSearchSql() {
        String sql =
                "select flowId from form_table_hysqd where result = " +
                StrUtil.sqlstr(RESULT_AGREE) + " order by flowId desc";
        return sql;
    }

    public static String getBoardroomDisagreeSearchSql() {
        String sql =
                "select flowId from form_table_hysqd where result = " +
                StrUtil.sqlstr(RESULT_DISAGREE) + " order by flowId desc";
        return sql;
    }

    public static String getBoardroomUsedSearchSql() {
        String sql =
                "select flowId from form_table_hysqd where result = " +
                StrUtil.sqlstr(RESULT_AGREE) +
                " and start_date < now() and end_date > now() order by flowId desc";
        return sql;
    }

    public static String getBoardroomEndSearchSql() {
        String sql =
                "select flowId from form_table_hysqd where result = " +
                StrUtil.sqlstr(RESULT_AGREE) +
                " and end_date < now() order by flowId desc";
        return sql;
    }

    public static String getBoardroomSearchSql(String boardroomId) {
        String sql =
                "select flowId from form_table_hysqd where hyshi = " +
                StrUtil.sqlstr(boardroomId) +
                " order by flowId desc";
        return sql;
    }

}