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