Пример #1
0
        public static DataTable LoadUpcoming()
        {
            string sql = "SELECT s.KeyName, ser.ServiceTime"
                         + " FROM Services ser"
                         + " INNER JOIN Sites s ON s.id = ser.SiteId"
                         + " WHERE ServiceTime> now() and ProviderKey<>'zFOfmAHFKNw'"
                         + " order by ServiceTime Limit 15";

            return(DbHelper.FillDt(sql));
        }