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

        String sql = "select * from ad_hoc_status ";

        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("Year"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Gender"));
        sql = sql + UtilManager.addStmtToWhereClause(SessionList.Get("Participat"));
        sql = sql + UtilManager.addMultipleStmtToWhereClause(SessionList.Get("Years"));


        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_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);
    }