Esempio n. 1
0
        public string getMainFunction()
        {
            sqlParameter = new SQLParameter();
            sqlParameter.OrderByValue = "MainFunctionID";
            DataTable dt = mainfunctionDB.getData(sqlParameter);

            if (CheckDataTableExist(dt) == false)
            {
                return("查無資料!");
            }
            MainFunctionList = (DataTableConvertToList.ToList <MainFunctionModel>(dt));
            sqlParameter     = null;
            return(null);
        }
        public string getCalendar()
        {
            sqlParameter = new SQLParameter();
            sqlParameter.OrderByValue = "EventTime Desc";
            calendarDB = new TB_Calendar_DB();
            DataTable dt = calendarDB.getData(sqlParameter);

            if (CheckDataTableExist(dt) == false)
            {
                return("查無資料!");
            }
            CalendarList = new List <CalendarModel>();
            CalendarList = (DataTableConvertToList.ToList <CalendarModel>(dt));
            sqlParameter = null;
            return(null);
        }