namespace Yw.DAL.SQLite
|
{
|
/// <summary>
|
/// RepairTaskLogFile
|
/// </summary>
|
public partial class RepairTaskLogFile : BaseDAL_Sorter<Entity.RepairTaskLogFile>, IRepairTaskLogFile
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get
|
{
|
return ConfigHelper.SQLiteConnectionConfig;
|
}
|
}
|
|
/// <summary>
|
/// 通过 FormID 获取
|
/// </summary>
|
public List<Entity.RepairTaskLogFile> GetByFormID(long FormID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLogFile>()
|
.Where(x => x.FormID == FormID)
|
.OrderBy(x => x.SortCode).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 LogID 获取
|
/// </summary>
|
public List<Entity.RepairTaskLogFile> GetByLogID(long FormID, long LogID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLogFile>()
|
.Where(x => x.FormID == FormID && x.LogID == LogID)
|
.OrderBy(x => x.SortCode).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 LogID 获取最大排序码
|
/// </summary>
|
public int GetMaxSortCodeByLogID(long FormID, long LogID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.RepairTaskLogFile>()
|
.Where(x => x.FormID == FormID && x.LogID == LogID)
|
.Max(x => x.SortCode);
|
}
|
}
|
|
|
}
|
}
|
