/// <summary>
/// 插入乳化沥青采集记录
/// </summary>
/// <param name="entity"></param>
public void InsertEmulGatherProduceLog(EmulsificationGatherProduceLog entity)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
//entity.inputDate = DateTime.Now;
oContext.EmulsificationGatherProduceLog.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 插入执油炉能源消耗日报明细
/// </summary>
/// <param name="entity"></param>
public void InsertDeepFatDetail(DeepFatConsumeDailyStatisticsDetail entity)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
entity.inputDate = DateTime.Now;
entity.inputMan = "services";
oContext.DeepFatConsumeDailyStatisticsDetail.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 插入生产计量监控
/// </summary>
/// <param name="entity"></param>
public void InsertProduceMeasure(ProduceMeasureMonitor entity)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
//entity.inputDate = DateTime.Now;
entity.inputMan = "services";
oContext.ProduceMeasureMonitor.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 查询流量计标识
/// </summary>
/// <param name="strNo">流量计编号</param>
/// <returns></returns>
public long QueryFlowmeterIDByNo(string strNo)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
var result = (from item in oContext.FlowmeterNo
where item.no == strNo
select item.id).FirstOrDefault();
return(result);
}
}
/// <summary>
/// 查询温度计信息
/// </summary>
/// <param name="strNo">温度计编号</param>
/// <returns></returns>
public TemperatureNo QueryTemperatureIDByNo(string strNo)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
var result = (from item in oContext.TemperatureNo
where item.no == strNo
select item).FirstOrDefault();
return(result);
}
}
/// <summary>
/// 查询设备信息
/// </summary>
/// <param name="strNo">设备编号</param>
/// <returns></returns>
public EquipmentInformation QueryEquipmentIDByNo(string strNo)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
var result = (from item in oContext.EquipmentInformation
where item.mark == strNo
select item).FirstOrDefault();
return(result);
}
}
/// <summary>
/// 插入流量计历史记录
/// </summary>
/// <param name="entity"></param>
public void InsertFlowmeterHistory(FlowmeterHistory entity)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
entity.date = DateTime.Now;
entity.inputDate = DateTime.Now;
entity.inputMan = "services";
oContext.FlowmeterHistory.InsertOnSubmit(entity);
oContext.SubmitChanges();
}
}
/// <summary>
/// 获取最后的流量历史值
/// </summary>
/// <param name="fnid">流量计标识</param>
/// <returns></returns>
public decimal QueryLastFlowmeterHistoryValue(long fnid)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
var result = (from item in oContext.FlowmeterHistory
where item.fnId == fnid && item.inputDate == ((from _item in oContext.FlowmeterHistory
where _item.fnId == fnid
select _item).Max(p => p.inputDate))
select item);
return(result.FirstOrDefault().value.Value);
}
}
/// <summary>
/// 获取最后的燃油炉重量值
/// </summary>
/// <param name="eiid">设备标识</param>
/// <returns></returns>
public decimal QueryLastDeepFat(long eiid)
{
using (ProcessingTableDataContext oContext = new ProcessingTableDataContext(this._strConn))
{
var result = (from item in oContext.DeepFatConsumeDailyStatisticsDetail
where item.eiId == eiid && item.inputDate == ((from _item in oContext.DeepFatConsumeDailyStatisticsDetail
where _item.eiId == eiid
select _item).Max(p => p.inputDate))
select item);
//var r = from item in oContext.DeepFatConsumeDailyStatisticsDetail
// group item by item.eiId into g1
// select g1.Where(p => p.eiId == eiid && p.inputDate == g1.Max(q=>q.inputDate)).Single();
return(result.FirstOrDefault().fuelWastage.Value);
}
}
