Beispiel #1
0
        /// <summary>
        /// 從TimeControl資料表取得資料
        /// </summary>
        /// <param name="cTimeControlName"></param>
        /// <param name="iClassGroupID"></param>
        /// <returns></returns>
        public static DataTable ORCS_TimeControl_SELECT_TimeConName_GroupID(object cTimeControlName, object iClassGroupID)
        {
            clsORCSDB ORCSDB = new clsORCSDB();
            string    strSQL = "SELECT * FROM ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "' AND iClassGroupID LIKE '" + iClassGroupID + "' ORDER BY iTimeControlID ASC ";

            return(ORCSDB.GetDataSet(strSQL).Tables[0]);
        }
Beispiel #2
0
        /// <summary>
        /// 從TimeControl資料表取得資料
        /// </summary>
        /// <param name="cTimeControlName"></param>
        /// <returns></returns>
        public static DataTable ORCS_TimeControl_SELECT(object cTimeControlName)
        {
            clsORCSDB ORCSDB = new clsORCSDB();
            string    strSQL = "SELECT * FROM ORCS_TimeControl WHERE cTimeControlName LIKE '" + cTimeControlName + "' ORDER BY iTimeControlID ASC ";

            return(ORCSDB.GetDataSet(strSQL).Tables[0]);
        }