private void GetPowerDataFromOracle()
{
JLog.Instance.AppInfo("开始获取电流数据.....");
if (_MaxPowerDataID > 0)
{
var objs = BDLSMARTPOWER.Instance.GetIncrementData(_MaxPowerDataID);
JLog.Instance.AppInfo(string.Format("获取电流记录数{0}条", objs.Count));
List<EtTBLRecordBQPower> _AirRows = new List<EtTBLRecordBQPower>();
List<EtTBLRecordTSPower> _TSRows = new List<EtTBLRecordTSPower>();
List<EtTBLRecordQSPower> _WaterRows = new List<EtTBLRecordQSPower>();//潜水泵数据
foreach (var obj in objs)
{
var _Farmers = BDLTBLFarmerInfo.GetTblFarmerInfoByNO(obj.SITEID);
var _Devices = BDLTBLDevice.GetTBLDeviceByNO(obj.DEVICEID);
if (_Farmers != null && _Farmers.Count >= 1 && _Devices != null && _Devices.Count >= 1)
{
if (_Farmers.ToList().First().GovernmentType ==(int) EnumGovernmentType.MANUFACTURE)//工业治理
{
#region 工业治理数据
EtTBLRecordBQPower _AirRecord = new EtTBLRecordBQPower();
//_AirRecord.RecordID = BDLTBLRecordAirElec.GetNewID();
_AirRecord.FarmerID = _Farmers.ToList().First().FarmerID;
_AirRecord.ChannelNo = (int)obj.CHANNEL;
_AirRecord.DeviceID = _Devices.ToList().First().DeviceID;
_AirRecord.ElectricityValue = obj.CURRENTVALUE;
_AirRecord.RecordTime = obj.RECVDATE;
_AirRecord.SwitchStatus = (int)obj.SWITCHSTATE;
_AirRows.Add(_AirRecord);
#endregion
if (obj.CHANNEL == 2)//曝气通道号//曝气泵电流值
{
EtTBLRecordBQPower newObj = new EtTBLRecordBQPower()
{
FarmerID = _Farmers.ToList().First().FarmerID,
DeviceID = _Devices.ToList().First().DeviceID,
ChannelNo = (int)obj.CHANNEL,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE,
};
_AirRows.Add(newObj);
}
else//提升泵电流值
{
EtTBLRecordTSPower newObj = new EtTBLRecordTSPower()
{
FarmerID = _Farmers.ToList().First().FarmerID,
DeviceID = _Devices.ToList().First().DeviceID,
ChannelNo = (int)obj.CHANNEL,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE,
};
_TSRows.Add(newObj);
}
}
else
{
#region 生态治理数据
EtTBLRecordQSPower _waterRecord = new EtTBLRecordQSPower()
{
//RecordID = BDLTBLRecordWaterElec.GetNewID(),
FarmerID = _Farmers.ToList().First().FarmerID,
ChannelNo = (int)obj.CHANNEL,
DeviceID = _Devices.ToList().First().DeviceID,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE
};
_WaterRows.Add(_waterRecord);
#endregion
}
}
if (_WaterRows != null && _WaterRows.Count > 0)
{
DALTBLRecordQSPower.BulkToDB(_WaterRows);
}
if (_AirRows != null && _AirRows.Count > 0)
{
DALTBLRecordBQPower.BulkToDB(_AirRows);
}
if (_TSRows != null && _TSRows.Count > 0)
{
DALTBLRecordTSPower.BulkToDB(_TSRows);
}
{
JLog.Instance.AppInfo("开始获取电流数据.....");
if (_MaxPowerDataID > 0)
{
var objs = BDLSMARTPOWER.Instance.GetIncrementData(_MaxPowerDataID);
JLog.Instance.AppInfo(string.Format("获取电流记录数{0}条", objs.Count));
List<EtTBLRecordBQPower> _AirRows = new List<EtTBLRecordBQPower>();
List<EtTBLRecordTSPower> _TSRows = new List<EtTBLRecordTSPower>();
List<EtTBLRecordQSPower> _WaterRows = new List<EtTBLRecordQSPower>();//潜水泵数据
foreach (var obj in objs)
{
var _Farmers = BDLTBLFarmerInfo.GetTblFarmerInfoByNO(obj.SITEID);
var _Devices = BDLTBLDevice.GetTBLDeviceByNO(obj.DEVICEID);
if (_Farmers != null && _Farmers.Count >= 1 && _Devices != null && _Devices.Count >= 1)
{
if (_Farmers.ToList().First().GovernmentType ==(int) EnumGovernmentType.MANUFACTURE)//工业治理
{
#region 工业治理数据
EtTBLRecordBQPower _AirRecord = new EtTBLRecordBQPower();
//_AirRecord.RecordID = BDLTBLRecordAirElec.GetNewID();
_AirRecord.FarmerID = _Farmers.ToList().First().FarmerID;
_AirRecord.ChannelNo = (int)obj.CHANNEL;
_AirRecord.DeviceID = _Devices.ToList().First().DeviceID;
_AirRecord.ElectricityValue = obj.CURRENTVALUE;
_AirRecord.RecordTime = obj.RECVDATE;
_AirRecord.SwitchStatus = (int)obj.SWITCHSTATE;
_AirRows.Add(_AirRecord);
#endregion
if (obj.CHANNEL == 2)//曝气通道号//曝气泵电流值
{
EtTBLRecordBQPower newObj = new EtTBLRecordBQPower()
{
FarmerID = _Farmers.ToList().First().FarmerID,
DeviceID = _Devices.ToList().First().DeviceID,
ChannelNo = (int)obj.CHANNEL,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE,
};
_AirRows.Add(newObj);
}
else//提升泵电流值
{
EtTBLRecordTSPower newObj = new EtTBLRecordTSPower()
{
FarmerID = _Farmers.ToList().First().FarmerID,
DeviceID = _Devices.ToList().First().DeviceID,
ChannelNo = (int)obj.CHANNEL,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE,
};
_TSRows.Add(newObj);
}
}
else
{
#region 生态治理数据
EtTBLRecordQSPower _waterRecord = new EtTBLRecordQSPower()
{
//RecordID = BDLTBLRecordWaterElec.GetNewID(),
FarmerID = _Farmers.ToList().First().FarmerID,
ChannelNo = (int)obj.CHANNEL,
DeviceID = _Devices.ToList().First().DeviceID,
ElectricityValue = obj.CURRENTVALUE,
RecordTime = obj.RECVDATE,
SwitchStatus = (int)obj.SWITCHSTATE
};
_WaterRows.Add(_waterRecord);
#endregion
}
}
if (_WaterRows != null && _WaterRows.Count > 0)
{
DALTBLRecordQSPower.BulkToDB(_WaterRows);
}
if (_AirRows != null && _AirRows.Count > 0)
{
DALTBLRecordBQPower.BulkToDB(_AirRows);
}
if (_TSRows != null && _TSRows.Count > 0)
{
DALTBLRecordTSPower.BulkToDB(_TSRows);
}