/// <summary> /// 插入多条dm /// </summary> /// <param name="listDm"></param> /// <returns></returns> public static int InsertDms(List <Dm> listDm) { using (var db = new SQLiteDb()) { db.Dms.AddRange(listDm); return(db.SaveChanges()); } }
/// <summary> /// 插入多条ad /// </summary> /// <param name="listAd"></param> /// <returns></returns> public static int InsertAds(List <Ad> listAd) { using (var db = new SQLiteDb()) { db.Ads.AddRange(listAd); int count = db.SaveChanges(); return(count); } }
/// <summary> /// 插入一条ad /// </summary> /// <param name="ad"></param> /// <returns></returns> public static int InsertAd(Ad ad) { using (var db = new SQLiteDb()) { db.Ads.Add(ad); int count = db.SaveChanges(); return(count); } }
/// <summary> /// 更新dm /// </summary> /// <param name="dm"></param> /// <returns></returns> public static int UpdateDm(Dm dm) { using (var db = new SQLiteDb()) { db.Dms.Add(dm); db.Entry <Dm>(dm).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 插入一条dm /// </summary> /// <param name="dm"></param> /// <returns></returns> public static int InsertDm(Dm dm) { using (var db = new SQLiteDb()) { db.Dms.Add(dm); int count = db.SaveChanges(); return(count); } }
/// <summary> /// 更新ad /// </summary> /// <param name="ad"></param> /// <returns></returns> public static int UpdateAd(Ad ad) { using (var db = new SQLiteDb()) { db.Ads.Add(ad); db.Entry <Ad>(ad).State = System.Data.Entity.EntityState.Modified; int count = db.SaveChanges(); return(count); } }
/// <summary> /// 插入一条Category /// </summary> /// <param name="category"></param> /// <returns></returns> public static int InsertCategory(Category category) { using (SQLiteDb db = new SQLiteDb()) { //db.Entry(category); db.Categories.Add(category); //db.Set<Category>().Add(category); int count = db.SaveChanges(); return(count); } }
//public static Dm DeleteDmById(long dmId) //{ // using (var db = new SQLiteDb()) // { // return db.Dms.Remove(db.Dms.FirstOrDefault(x => x.advertisement_id == dmId)); // } //} //public static Dm DeleteDmById(Dm dm) //{ // using (var db = new SQLiteDb()) // { // return db.Dms.Remove(dm); // } //} /// <summary> /// 删除过期的dm /// </summary> /// <returns></returns> public static void DeleteDmByOutDate() { using (var db = new SQLiteDb()) { List <Dm> list = GetDmsByOutDate(); foreach (Dm dm in list) { db.Dms.Attach(dm); db.Dms.Remove(dm); } db.SaveChanges(); } }
/// <summary> /// 删除过期的ad /// </summary> /// <returns></returns> public static void DeleteAdByOutDate() { using (var db = new SQLiteDb()) { List <Ad> list = GetAdsByOutDate(); foreach (Ad ad in list) { db.Ads.Attach(ad); db.Ads.Remove(ad); } //db.Ads.RemoveRange(list); db.SaveChanges(); } }