/// <summary>
/// 获取指定标识的液位仪信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public LiquidPositionNo QueryByID(long id)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
return((from item in oContext.LiquidPositionNo where item.id == id select item).FirstOrDefault());
}
}
/// <summary>
/// 获取全部液位仪信息
/// </summary>
/// <returns></returns>
public List <LiquidPositionNo> QueryAll()
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var result = from item in oContext.LiquidPositionNo
select item;
return(result.ToList());
}
}
/// <summary>
/// 查询温度计数据集
/// </summary>
/// <returns></returns>
public List <TemperatureNo> QueryAll()
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var result = from item in oContext.TemperatureNo
select item;
return(result.ToList());
}
}
/// <summary>
/// 插入液位仪信息
/// </summary>
/// <param name="entity"></param>
public void Insert(LiquidPositionNo entity)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
entity.inputDate = DateTime.Now;
oContext.LiquidPositionNo.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 插入温度计信息
/// </summary>
/// <param name="entity"></param>
public void Insert(TemperatureNo entity)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
entity.inputDate = DateTime.Now;
oContext.TemperatureNo.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 获取指定标识的温度计信息
/// </summary>
/// <param name="id">标识</param>
/// <returns></returns>
public TemperatureNo QueryByID(long id)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var result = from item in oContext.TemperatureNo
where item.id == id
select item;
return(result.FirstOrDefault());
}
}
/// <summary>
/// 获取指定标识的流量计信息
/// </summary>
/// <param name="id">标识</param>
/// <returns></returns>
public FlowmeterNo QueryByID(long id)
{
using (MonitorDataContext oContext = new MonitorDataContext(new DasherStation.common.SqlHelper().SqlConn))
{
var result = from item in oContext.FlowmeterNo
where item.id == id
select item;
return(result.FirstOrDefault());
}
}
/// <summary>
/// 更新流量计设置
/// </summary>
/// <param name="entity"></param>
public void Update(FlowmeterNo entity)
{
using (MonitorDataContext oContext = new MonitorDataContext(new DasherStation.common.SqlHelper().SqlConn))
{
var _entity = (from item in oContext.FlowmeterNo
where entity.id == item.id
select item).FirstOrDefault();
_entity.name = entity.name;
_entity.position = entity.position;
_entity.remark = entity.remark;
oContext.SubmitChanges();
}
}
/// <summary>
/// 更新液位仪信息
/// </summary>
/// <param name="entity"></param>
public void Update(LiquidPositionNo entity)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var _entity = (from item in oContext.LiquidPositionNo
where entity.id == item.id
select item).FirstOrDefault();
_entity.name = entity.name;
_entity.minValue = entity.minValue;
_entity.maxValue = entity.maxValue;
_entity.position = entity.position;
_entity.remark = entity.remark;
oContext.SubmitChanges();
}
}
/// <summary>
/// 判断指定名称是否存在
/// </summary>
/// <param name="strName">液位仪名称</param>
/// <returns></returns>
public bool IsExistByName(string strName)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var result = (from item in oContext.LiquidPositionNo
where item.name.Trim() == strName.Trim()
select item.id).Count();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 判断指定编号是否存在
/// </summary>
/// <param name="strNo">温度计编号</param>
/// <returns></returns>
public bool IsExistByNo(string strNo)
{
using (MonitorDataContext oContext = new MonitorDataContext(this._strConn))
{
var result = (from item in oContext.TemperatureNo
where item.no.Trim() == strNo.Trim()
select item.id).Count();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="id"></param>
public void Delete(int[] id)
{
MonitorDataContext oHumanContext = new MonitorDataContext(this._strConn);
var deleting =
from item in oHumanContext.LiquidPositionNo
where id.Contains((int)item.id)
select item;
foreach (var item in deleting)
{
try
{
oHumanContext.LiquidPositionNo.DeleteOnSubmit(item);
oHumanContext.SubmitChanges();
}
catch
{
}
}
}