/// <summary>
/// Gets the element by id.
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
/// 创建者：叶烨星
/// 创建时间：2018/1/28 18:47
/// 修改者：
/// 修改时间：
public ServiceResult <T> GetElementById(int id)
{
if (id <= 0)
{
return(new ServiceResult <T>
{
State = false,
Message = "输入的id不合法"
});
}
T element = db.Set <T>().Find(id);
if (element == null)
{
return(new ServiceResult <T>
{
State = false,
Message = "该元素不存在"
});
}
return(new ServiceResult <T>
{
Result = element,
State = true
});
}
public static List <Clients> GetAllClients()
{
using (var context = new DataModelContainer())
{
List <Clients> clients = new List <Clients>();
return(context.Set <Clients>().ToList());
}
}
//实现对数据库的修改功能
public bool UpdateEntity(T entity)
{
//EF4.0的写法
//db.CreateObjectSet<T>().Addach(entity);
//db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
//EF5.0的写法
db.Set <T>().Attach(entity);
db.Entry <T>(entity).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
public virtual async Task <CommandResult <UserProfileData> > Create(UserProfileData data)
{
var entity = data.ToEntity();
_context.Set(entity.GetType()).Attach(entity);
_context.Entry(entity).State = System.Data.Entity.EntityState.Added;
await _context.SaveChangesAsync();
return(new CommandResult <UserProfileData>(data, new UserProfileData(entity)));
}
public virtual async Task <CommandResult <UserData> > Update(UserData data)
{
var entity = data.ToEntity();
_context.Set(entity.GetType()).Attach(entity);
_context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
var rows = await _context.SaveChangesAsync();
return(new CommandResult <UserData>(data, new UserData(entity), rows > 0));
}
public virtual async Task <CommandResult <RoleData> > Delete(RoleData data)
{
var entity = data.ToEntity();
_context.Set(entity.GetType()).Attach(entity);
_context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
var rows = await _context.SaveChangesAsync();
return(new CommandResult <RoleData>(data, null, rows > 0));
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns>A saved entity, otherwise, same passed object.</returns>
public T Add(T item)
{
try
{
Context.Set <T>().Attach(item);
Context.Entry(item).State = EntityState.Added;
Context.SecureSaveChanges();
}
catch (Exception ex)
{
var dataException = DataLayerExceptionFactory.Create(ex, item);
throw dataException;
}
return(item);
}
//查询 whereLambda u=>u.id>0 条件
public IQueryable <T> GetEntity(Expression <Func <T, bool> > whereLambda)
{
DataModelContainer db = new DataModelContainer();
return(db.Set <T>().Where(whereLambda).AsQueryable());
}