public static T getById <T>(int id) where T : BaseEntity
{
using (EFMySqlDbContext context = new Db.EFMySqlDbContext())
{
return(context.getDbSet <T>().FirstOrDefault(i => i.id == id));
}
}
public static void save <T>(T t) where T : BaseEntity
{
using (EFMySqlDbContext context = new Db.EFMySqlDbContext())
{
try
{
context.getDbSet <T>().Add(t);
context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("保存失败：" + ex.Message);
}
}
}
public static IList <T> getAll <T>() where T : BaseEntity
{
try
{
using (EFMySqlDbContext context = new Db.EFMySqlDbContext())
{
return(context.getDbSet <T>().ToList());
}
}
catch (Exception ex)
{
MessageBox.Show("无法从数据库获取数据，原因是：" + ex.Message);
return(new List <T>());
}
}
public static void edit <T>(T entity) where T : BaseEntity
{
using (EFMySqlDbContext context = new Db.EFMySqlDbContext())
{
try
{
var foundIndicator = context.getDbSet <T>().FirstOrDefault(i => i.id == entity.id);
PropertyInfo[] properties = typeof(T).GetProperties();
foreach (var property in properties)
{
string text = property.Name;
property.SetValue(foundIndicator, property.GetValue(entity));
}
context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("修改失败：" + ex.Message);
}
}
}
