/// <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();
}
}
