using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
|
namespace TProduct.DAL
|
{
|
public class TestProjectItemView
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public ISqlSugarClient Connection
|
{
|
get { return TProduct.DAL.SQLite.ConfigHelper.MainConn; }
|
}
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByProjectID(long ProjectID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().Where(x => x.ProjectID == ProjectID)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByProjectID(IEnumerable<long> ProjectID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().Where(x => ProjectID.Contains(x.ProjectID))?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通过时间获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByCreateTime(DateTime StartTime, DateTime EndTime)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().Where(x =>
|
x.ProjectCreateTime >= StartTime
|
&& x.ProjectCreateTime <= EndTime)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过时间获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetAll( )
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>()?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通过时间获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByCreateTime(
|
int TestType,
|
DateTime StartTime,
|
DateTime EndTime)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().Where(x =>
|
x.TestType == TestType &&
|
x.ProjectCreateTime >= StartTime
|
&& x.ProjectCreateTime <= EndTime)?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通过时间获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByCreateTimePointNumber(
|
int TestType,
|
int PointNumber,
|
DateTime StartTime,
|
DateTime EndTime)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().Where(x =>
|
x.TestType == TestType &&
|
x.PointNumber > PointNumber &&
|
x.ProjectCreateTime >= StartTime
|
&& x.ProjectCreateTime <= EndTime)?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByProductType(int ProductType, List<long> ProductID, DateTime StartTime, DateTime EndTime)
|
{
|
if (ProductID == null || ProductID.Count() == 0)
|
{
|
return GetByProductType(ProductType, StartTime, EndTime);
|
}
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x =>
|
x.ProductType == ProductType
|
&& ProductID.Contains(x.ProductID)
|
&& x.ProjectCreateTime >= StartTime
|
&& x.ProjectCreateTime <= EndTime)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByProductType(int ProductType, DateTime StartTime, DateTime EndTime)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x =>
|
x.ProductType == ProductType
|
&& x.ProjectCreateTime >= StartTime
|
&& x.ProjectCreateTime <= EndTime)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetBySeriesID(long SeriesID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.SeriesID == SeriesID)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByProductID(long ProductID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.ProductID == ProductID)?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByPartID(long PartID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.PartID == PartID)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByPartID(long PartID,
|
DateTime StartTime,
|
int MinPtCount)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => x.PartID == PartID && x.ProjectCreateTime > StartTime && x.PointNumber > MinPtCount)?.ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByPartID(List<long> PartID,
|
DateTime StartTime,
|
int MinPtCount)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => PartID.Contains(x.PartID) && x.ProjectCreateTime > StartTime && x.PointNumber > MinPtCount)?.ToList();
|
}
|
}
|
/// <summary>
|
/// 通拓id列表获取
|
/// </summary>
|
/// <returns></returns>
|
public List<Entity.TestProjectItemView> GetByPartID(IEnumerable<long> PartID)
|
{
|
using (ISqlSugarClient db = Connection)
|
{
|
return db.Queryable<Entity.TestProjectItemView>().OrderBy(x => x.ProjectCreateTime, OrderByType.Desc).Where(x => PartID.Contains(x.PartID))?.ToList();
|
}
|
}
|
}
|
}
|
