using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using SqlSugar;
|
|
namespace IStation.DAL
|
{
|
/// <summary>
|
/// Dma点位映射
|
/// </summary>
|
public partial class DmaSiteBinding : CorpDAL<Entity.DmaSiteBinding>
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.DefaultConnectionConfig; }
|
|
}
|
|
/// <summary>
|
/// 通过 DmaSiteID 获取
|
/// </summary>
|
public List<Entity.DmaSiteBinding> GetByDmaSiteID(long CorpID, long DmaSiteID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.DmaSiteBinding>()
|
.Where(x=>x.CorpID==CorpID&&x.DmaSiteID==DmaSiteID).ToList();
|
}
|
}
|
|
/// <summary>
|
/// 通过 FlowMeterID 获取
|
/// </summary>
|
public List<Entity.DmaSiteBinding> GetByFlowMeterID(long CorpID, long FlowMeterID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
return db.Queryable<Entity.DmaSiteBinding>()
|
.Where(x => x.CorpID == CorpID && x.FlowMeterID == FlowMeterID).ToList();
|
}
|
}
|
|
|
|
}
|
}
|