示例#1
0
        public Models.JsonModels.DailyModel QueryDaily(int id)
        {
            var vDaily = new Models.JsonModels.DailyModel();

            var daily = DataBase.Table <DailyModel>().Where(d => d.Id == id).FirstOrDefault();

            if (daily != null)
            {
                vDaily = new Models.JsonModels.DailyModel()
                {
                    id           = daily.Id,
                    body         = daily.body,
                    ga_prefix    = daily.ga_prefix,
                    image        = daily.image,
                    image_source = daily.image_source,
                    share_url    = daily.share_url,
                    title        = daily.title,
                    type         = daily.type,
                    updatetime   = daily.updatetime,
                    css          = new List <string>(),
                    js           = new List <string>()
                };
                foreach (var item in DataBase.Table <DailyCssModel>().Where(d => d.DailyId == id).ToList())
                {
                    vDaily.css.Add(item.css);
                }
                foreach (var item in DataBase.Table <DailyJsModel>().Where(d => d.DailyId == id).ToList())
                {
                    vDaily.js.Add(item.js);
                }
            }
            return(vDaily);
        }
示例#2
0
 public void UpdateDaily(Models.JsonModels.DailyModel item)
 {
     DataBase.DeleteItem <DailyModel>(item.id);
     DataBase.InsertItem(new DailyModel
     {
         Id           = item.id,
         body         = item.body,
         ga_prefix    = item.ga_prefix,
         image        = item.image,
         image_source = item.image_source,
         share_url    = item.share_url,
         title        = item.title,
         type         = item.type,
         updatetime   = DateTime.Now
     });
     foreach (var js in DataBase.Table <DailyJsModel>().Where(d => d.DailyId == item.id).ToList())
     {
         DataBase.DeleteItem <DailyJsModel>(js.Id);
     }
     foreach (var js in item.js)
     {
         DataBase.InsertItem(new DailyJsModel
         {
             DailyId = item.id,
             js      = js
         });
     }
     foreach (var css in DataBase.Table <DailyCssModel>().Where(d => d.DailyId == item.id).ToList())
     {
         DataBase.DeleteItem <DailyCssModel>(css.Id);
     }
     foreach (var css in item.css)
     {
         DataBase.InsertItem(new DailyCssModel
         {
             DailyId = item.id,
             css     = css
         });
     }
 }