예제 #1
0
        public static IEnumerable <MapLogData> LoadDataByDate(DateTime from, DateTime to)
        {
            string query = "Select um.IdUserMeal, um.idcategory,  m.name as MealName from usermeal as um inner join mealunit as mu on um.IDMealUnit=mu.IDMealUnit inner join meal m on mu.idmeal=m.idmeal where um.iduser="******" and um.mealdate BETWEEN ? and ?";

            return(db.Query <MapLogData>(query, from, to));
        }
예제 #2
0
 public ConnectionInfo()
 {
     conn         = StorageManager.GetConnection();
     isTrialShown = false;
 }