public override IEnumerable <ThresholdValue_SteelArchStrainThresholdValueTable> FindAll()
{
using (var ctx = new BHMSContext())
{
return(ctx.Set <ThresholdValue_SteelArchStrainThresholdValueTable>().Include("PointsNumber").ToList());
}
}
/// <summary>
/// 预先初始化数据库，防止无数据库的错误
/// </summary>
void ToPreventDBDoesNotExist()
{
using (BHMSContext ctx = new BHMSContext())
{
ctx.Users.Count();
}
}
public override IEnumerable <SafetyPreWarning_DisplacementTable> FindBy(IList <Func <SafetyPreWarning_DisplacementTable, bool> > ps, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.Set <SafetyPreWarning_DisplacementTable>()); //处理导航属性
var result = DealWithConditions(ps.ToArray(), source); //处理条件筛选
return(result
.OrderBy(m => m.Id)
.ToList()); //排序、分页
}
}
public override IEnumerable <FirstAssessment_FirstLevelSafetyAssessmentReportTable> FindBy(IList <Func <FirstAssessment_FirstLevelSafetyAssessmentReportTable, bool> > ps, int currentPageIndex, int pageSize, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.Set <FirstAssessment_FirstLevelSafetyAssessmentReportTable>()); //处理导航属性
var result = DealWithConditions(ps.ToArray(), source); //处理条件筛选
return(result
.OrderByDescending(m => m.ReportTime)
.Skip((currentPageIndex - 1) * pageSize)
.Take(pageSize)
.ToList()); //排序、分页
}
}
public override IEnumerable <AnomalousEvent_AnomalousEventTable> FindBy(IList <Func <AnomalousEvent_AnomalousEventTable, bool> > ps, int currentPageIndex, int pageSize, params string[] navigationProperties)
{
using (var ctx = new BHMSContext())
{
var source = DealWithNavigationPropertys(navigationProperties, ctx.AnomalousEvent); //处理导航属性
var result = DealWithConditions(ps.ToArray(), source); //处理条件筛选
return(result
.OrderByDescending(m => m.Id)
.Skip((currentPageIndex - 1) * pageSize)
.Take(pageSize)
.ToList()); //排序、分页
}
}
