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); } }