public LogInfo[] GetLog(string DianYuanID, int LuHoa, string LeiXing)
{
LogInfo[] vResult = new LogInfo[0];
PowerEventEFModel vModel = new PowerEventEFModel()
{
DianYuanID = DianYuanID,
LuHao = LuHoa,
ShiJianLX = LeiXing
};
PowerEventEFModel[] vSelectResult = m_BasicDBClassSelect.SelectRecordsEx(vModel);
if (vSelectResult != null)
{
vResult = new LogInfo[vSelectResult.Length];
for (int i = 0; i < vSelectResult.Length; i++)
{
vResult[i] = new LogInfo()
{
NeiRong = vSelectResult[i].NeiRong,
ShiJianLX = vSelectResult[i].ShiJianLX,
Time = vSelectResult[i].Time ?? DateTime.MinValue
};
}
}
return(vResult);
}
void processorData_Event(PowerDataPack_Receive_Event data, string IPAddress)
{
try
{
m_BasicDBClass_Receive.TransactionBegin();
PowerEventEFModel vPowerEventEFModel = new PowerEventEFModel()
{
DianYuanID = BitConverter.ToString(new byte[] { data.MAC1, data.MAC2, data.MAC3, data.MAC4, data.MAC5, data.MAC6 }),
LeiXi = convertSwitchLeiXing(data.LeiXing),
LuHao = data.LuHao,
ShiJianLX = convertShiJianLX(data.ShiJinLX),
NeiRong = convertShiJianNR(data.ShiJinLX, data.ShiJianBM),
Time = DateTime.Now,
};
m_BasicDBClass_Receive.InsertRecord(vPowerEventEFModel);
if (data.ShiJinLX == 0)
{
PowerSwithConfigEFModel vPowerSwithConfigEFModel = new PowerSwithConfigEFModel();
string vWhereSql = string.Format("DianYuanID='{0}' and LuHao={1}", vPowerEventEFModel.DianYuanID, vPowerEventEFModel.LuHao);
switch (data.ShiJianBM)
{
case 0x0D: //锁定
vPowerSwithConfigEFModel.ZhuangTai = "锁定";
m_BasicDBClass_Receive.UpdateRecord(vPowerSwithConfigEFModel, vWhereSql);
break;
case 0x0E: //正常
case 0x0C:
vPowerSwithConfigEFModel.ZhuangTai = "正常";
m_BasicDBClass_Receive.UpdateRecord(vPowerSwithConfigEFModel, vWhereSql);
break;
case 0x0F: //应急
vPowerSwithConfigEFModel.ZhuangTai = "应急";
m_BasicDBClass_Receive.UpdateRecord(vPowerSwithConfigEFModel, vWhereSql);
break;
}
}
//更新电源数据开关状态
switch (vPowerEventEFModel.NeiRong)
{
case "本地开":
case "远程开":
case "定时开":
case "短路跳闸":
case "过载跳闸":
case "超功率跳闸":
case "电能用完跳闸":
case "超温跳闸":
case "过压跳闸":
case "欠压跳闸":
case "打火跳闸":
case "漏电跳闸":
string vSql1 = string.Format("update `电源数据` set `ZhuanTai`='{0}' where `ID` in ( select a.MaxID from "
+ "(Select max(id) as MaxID From `电源数据` where DianYuanID = '{2}' and LuHao={1:D}) a )", "开", vPowerEventEFModel.LuHao, vPowerEventEFModel.DianYuanID);
m_BasicDBClass_Receive.UpdateRecord(vSql1);
break;
case "本地关":
case "远程关":
case "定时关":
string vSql2 = string.Format("update `电源数据` set `ZhuanTai`='{0}' where `ID` in ( select a.MaxID from "
+ "(Select max(id) as MaxID From `电源数据` where DianYuanID = '{2}' and LuHao={1:D}) a )", "关", vPowerEventEFModel.LuHao, vPowerEventEFModel.DianYuanID);
m_BasicDBClass_Receive.UpdateRecord(vSql2);
break;
}
m_BasicDBClass_Receive.TransactionCommit();
}
catch (Exception ex)
{
string vOutInfo = string.Format("插入数据至[电源事件表]中发生异常，异常信息为:{0}", ex.Message);
Console.WriteLine(vOutInfo);
LogHelper.WriteLog_Error(typeof(PowerControl), vOutInfo);
}
}
