コード例 #1
0
    private DataTable GetResultsData()
    {
        USTTISessionCollection SessionList = SessionManager.getSessionList();

        String sql = "select * from ad_hoc_default ";

        sql = sql + " where 1 = 1 ";

        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Applicant ID"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Country"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Start Date"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Orientation Start"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Gender"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Participat"));

        sql = sql + GetSortExpression();

        USTTIDataAccess data = new USTTIDataAccess();

        DataTable dt = data.Fill(sql);

        return(dt);
    }
コード例 #2
0
    private DataTable GetResultsData()
    {
        USTTISessionCollection SessionList = SessionManager.getSessionList();

        String sql = "select * from ad_hoc_student_extended ";

        sql = sql + " where 1 = 1 ";

        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Applicant ID"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Country"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Gender"));
        sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));

        sql = sql + GetSortExpression();

        USTTIDataAccess data = new USTTIDataAccess();

        DataTable dt = data.Fill(sql);

        return(dt);
    }
コード例 #3
0
    private DataTable GetResultsData()
    {
        USTTISessionCollection SessionList = SessionManager.getSessionList();

        String sql = "select * from ad_hoc_sponsors ";

        sql = sql + " where 1 = 1 ";

        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Course Num"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Sponsor"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Year"));
        sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));

        sql = sql + GetSortExpression();

        USTTIDataAccess data = new USTTIDataAccess();

        DataTable dt = data.Fill(sql);

        return(dt);
    }
コード例 #4
0
    private DataTable GetResultsData()
    {
        USTTISessionCollection SessionList = SessionManager.getSessionList();

        String sql = "select * from ad_hoc_funders ";

        sql = sql + " where 1 = 1 ";


        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Title"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Name"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Type"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("First"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Last"));

        sql = sql + GetSortExpression();

        USTTIDataAccess data = new USTTIDataAccess();

        DataTable dt = data.Fill(sql);

        return(dt);
    }