using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using SqlSugar;
|
|
namespace IStation.DAL
|
{
|
/// <summary>
|
/// 信号单元
|
/// </summary>
|
public partial class SignalUnit : CorpDAL_Sorter<Entity.SignalUnit>
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.DefaultConnectionConfig; }
|
|
}
|
|
/// <summary>
|
/// 通过 MonitorUnitID 获取
|
/// </summary>
|
public List<Entity.SignalUnit> GetByMonitorUnitID(long CorpID, long MonitorUnitID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.SignalUnit>()
|
.Where(x => x.CorpID == CorpID && x.MonitorUnitID == MonitorUnitID).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 MonitorUnitIds 获取
|
/// </summary>
|
public List<Entity.SignalUnit> GetByMonitorUnitIds(long CorpID, List<long> MonitorUnitIds)
|
{
|
if (MonitorUnitIds == null || MonitorUnitIds.Count() < 1)
|
return default;
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.SignalUnit>()
|
.Where(x => x.CorpID == CorpID && MonitorUnitIds.Contains(x.MonitorUnitID)).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 MonitorUnitID 删除
|
/// </summary>
|
public bool DeleteByMonitorUnitID(long CorpID, long MonitorUnitID)
|
{
|
using (SqlSugarClient db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Deleteable<Entity.SignalUnit>()
|
.Where(x => x.CorpID == CorpID && x.MonitorUnitID == MonitorUnitID)
|
.ExecuteCommand() > 0;
|
}
|
}
|
|
|
|
}
|
}
|
