/// <summary>
/// 真正删除
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Remove(T model)
{
using (var db = new powerbjfEntities(conn))
{
db.Set <T>().Remove(model);
db.SaveChanges();
}
}
/// <summary>
/// 执行修改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public void Update(T model)
{
using (var db = new powerbjfEntities(conn))
{
db.Set <T>().AddOrUpdate(model);
db.SaveChanges();
}
}
public void ExcuteSql(string sql)
{
using (var db = new powerbjfEntities(conn))
{
db.Database.ExecuteSqlCommand(sql);
db.SaveChanges();
}
}
public void RemoveList(List <T> list)
{
using (var db = new powerbjfEntities(conn))
{
foreach (var model in list)
{
db.Set <T>().Remove(model);
}
db.SaveChanges();
}
}
/// <summary>
/// 批量添加
/// </summary>
/// <param name="listmodel"></param>
public void AddRange(List <T> listmodel)
{
using (var db = new powerbjfEntities(conn))
{
foreach (var model in listmodel)
{
db.Set <T>().Add(model);
}
db.SaveChanges();
}
}