namespace Yw.DAL.PostgreSql
|
{
|
/// <summary>
|
/// RepairTaskLog
|
/// </summary>
|
public partial class RepairTaskLog : BaseDAL<Entity.RepairTaskLog>, IRepairTaskLog
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get
|
{
|
return ConfigHelper.PostgreSqlConnectionConfig;
|
}
|
}
|
|
/// <summary>
|
/// 通过 FormID 获取
|
/// </summary>
|
public List<Entity.RepairTaskLog> GetByFormID(long FormID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLog>()
|
.Where(x => x.FormID == FormID).OrderBy(x => x.OperateTime).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 FormID 获取最后一条
|
/// </summary>
|
public Entity.RepairTaskLog GetLastByFormID(long FormID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLog>()
|
.Where(x => x.FormID == FormID).OrderBy(x => x.OperateTime, OrderByType.Desc).First();
|
}
|
}
|
|
/// <summary>
|
/// 通过 FormIds 获取
|
/// </summary>
|
public List<Entity.RepairTaskLog> GetByFormIds(List<long> FormIds)
|
{
|
if (FormIds == null || FormIds.Count < 1)
|
return default;
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLog>()
|
.Where(x => FormIds.Contains(x.FormID)).OrderBy(x => x.OperateTime).ToList();
|
}
|
}
|
|
|
}
|
}
|
