IList <UserState> IUser.GetAllUserStates()
{
using (var ctx = new BHMSContext())
{
return(ctx.UserStates.ToList());
}
}
int IUser.GetUserStateId(string name)
{
using (var ctx = new BHMSContext())
{
return(ctx.UserStates.SingleOrDefault(m => m.StateName == name).Id);
}
}
public T GetModel(TId id)
{
using (var ctx = new BHMSContext())
{
return(ctx.Set <T>().Find(id));
}
}
public virtual IEnumerable <T> FindAll()
{
using (var ctx = new BHMSContext())
{
return(ctx.Set <T>().ToList());
}
}
string IUser.GetLastUserName()
{
using (var ctx = new BHMSContext())
{
var id = ctx.Users.Max(m => m.Id);
return(ctx.Users.Find(id).UserName);
}
}
public void Remove(T entity)
{
using (var ctx = new BHMSContext())
{
ctx.Entry(entity).State = EntityState.Deleted;
ctx.SaveChanges();
}
}
public void Save(T model)
{
using (var ctx = new BHMSContext())
{
ctx.Entry(model).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void Add(T newOne)
{
using (var ctx = new BHMSContext())
{
ctx.Set <T>().Add(newOne);
ctx.SaveChanges();
}
}
public virtual IEnumerable <T> FindBy(Func <T, bool> p = null, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var result = DealWithNavigationPropertys(navigationProperties, ctx.Set <T>());
return(p == null?result.ToList() : result.Where(p).ToList());
}
}
public virtual int GetCountByContains(IList <Func <T, bool> > ps, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = ctx.Set <T>();
var query = DealWithNavigationPropertys(navigationProperties, source);
var result = DealWithConditions(ps, query);
return(result.Count());
}
}
public virtual IEnumerable <T> FindBy(params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.Set <T>());//处理导航属性
return(source
.OrderBy(m => m.Id)
.ToList()); //排序、分页
}
}
public virtual IEnumerable <T> FindBy(IList <Func <T, bool> > ps, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.Set <T>()); //处理导航属性
var result = DealWithConditions(ps.ToArray(), source); //处理条件筛选
return(result
.OrderBy(m => m.Id)
.ToList()); //排序、分页
}
}
public override IEnumerable <SafetyPreWarning_DisplacementTable> FindBy(IList <Func <SafetyPreWarning_DisplacementTable, bool> > ps, int currentPageIndex, int pageSize, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.SafetyPreWarning_Displacements); //处理导航属性
var result = DealWithConditions(ps.ToArray(), source); //处理条件筛选
return(result
.OrderByDescending(m => m.Id)
.Skip((currentPageIndex - 1) * pageSize)
.Take(pageSize)
.ToList()); //排序、分页
}
}
