tasksqlbuilder.java

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

package com.redmoon.oa.task;

import cn.js.fan.util.*;


public class TaskSQLBuilder {
    public TaskSQLBuilder() {
    }

    public static String getUserJoinTask(String userName) {
        String sql = "select distinct rootid from task where person = " +
                     StrUtil.sqlstr(userName) + " and type<" + TaskDb.TYPE_RESULT + " order by rootid desc";
        return sql;
    }

    public static String getUserJoinFinishedTask(String userName) {
        String sql =
                "select DISTINCT rootid from task where status=" +
                TaskDb.STATUS_FINISHED +
                " and person = " +StrUtil.sqlstr(userName)+ " and type<" + TaskDb.TYPE_RESULT + " order by rootid desc";
        return sql;
    }

    public static String getUserJoinNotFinishedTask(String userName) {
        String sql =
                "select DISTINCT rootid from task where status=" +
                TaskDb.STATUS_NOTFINISHED +
                " and person = " +StrUtil.sqlstr(userName)+ " and type<" + TaskDb.TYPE_RESULT + " order by rootid desc";
        return sql;
    }

    public static String getUserJoinDiscardTask(String userName) {
        String sql =
                "select DISTINCT rootid from task where status=" +
                TaskDb.STATUS_DISCARD +
                " and person = " +StrUtil.sqlstr(userName)+ " and type<" + TaskDb.TYPE_RESULT + " order by rootid desc";
        return sql;
    }


}