public static void UpdateEntityByPropertySingle <T>(T obj, IEnumerable <string> fieldNames) where T : class { try { using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities()) { if (!fieldNames.Any()) { return; } context.Set <T>().Attach(obj); if (fieldNames != null) { foreach (var item in fieldNames) { context.Entry <T>(obj).Property(item).IsModified = true; } } else { context.Entry <T>(obj).State = System.Data.Entity.EntityState.Modified; } context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static List <T> AddEntities <T>(IList <T> objList) where T : class { InitalCreationTime <T>(objList); InitalLastUpdateTime <T>(objList); try { using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities()) { for (int i = 0; i < objList.Count; ++i) { context.Entry <T>(objList[i]).State = System.Data.Entity.EntityState.Added; } context.SaveChanges(); } return(objList.ToList()); } catch (Exception ex) { throw ex; } #region 查看 EntityValidationErrors 详细信息的解决方法 //catch (System.Data.Entity.Validation.DbEntityValidationException ex) //{ // var msg = string.Empty; // var errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList(); // foreach (var item in errors) // msg += item.FirstOrDefault().ErrorMessage; //} #endregion 查看 EntityValidationErrors 详细信息的解决方法 }
public static void DeleteEntities <T>(IList <T> objList) where T : class { InitalLastUpdateTime <T>(objList); try { using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities()) { for (int i = 0; i < objList.Count; ++i) { context.Entry <T>(objList[i]).State = System.Data.Entity.EntityState.Deleted; } context.SaveChanges(); } } catch (Exception ex) { throw ex; } }