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;
}
}
public static void BulkInsertEntities <T>(IList <T> objList) where T : class
{
try
{
using (OperationSystem_HBMSEntities context = new OperationSystem_HBMSEntities())
{
if (!context.Database.Exists())
{
context.Database.Create();
}
context.BulkInsert <T>(objList);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}