private void InsertAlarmInfo(DataRow dr, CmdParam.CarAlarmState carAlarmState, int AddMsgType) { try { int num = 0; string empty = string.Empty; int num1 = Convert.ToInt32(dr["carstatu"]); long num2 = Convert.ToInt64(dr["carstatuex"]); int num3 = 1154; int num4 = 65; string str = string.Empty; string str1 = dr["AddMsgTxt"].ToString(); str1 = (!string.IsNullOrEmpty(str1) ? string.Concat(str1, "/MEE0000000000000001") : "MEE0000000000000001"); string str2 = null; bool flag = false; string str3 = null; int num5 = 0; try { SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter("@wrkid", (object)num), new SqlParameter("@orderid", dr["OrderId"]), new SqlParameter("@userid", empty), new SqlParameter("@telephone", dr["telephone"]), new SqlParameter("@msgType", (object)num4), new SqlParameter("@recetime", dr["ReceTime"]), new SqlParameter("@gpstime", dr["GpsTime"]), new SqlParameter("@starCondition", dr["StarCondition"]), new SqlParameter("@starNum", dr["StarNum"]), new SqlParameter("@carStatu", (object)num1), new SqlParameter("@carStatuEx", (object)num2), new SqlParameter("@carCondition", dr["CarCondition"]), new SqlParameter("@Longitude", dr["Longitude"]), new SqlParameter("@Latitude", dr["Latitude"]), new SqlParameter("@direct", dr["Direct"]), new SqlParameter("@speed", dr["Speed"]), new SqlParameter("@Reserved", (object)num3), new SqlParameter("@TransportStatus", dr["TransportStatus"]), new SqlParameter("@Accelerration", dr["Accelerration"]), new SqlParameter("@Altitude", dr["Altitude"]), new SqlParameter("@DistanceDiff", dr["DistanceDiff"]), new SqlParameter("@commflag", dr["CommFlag"]), new SqlParameter("@addType", (object)AddMsgType), new SqlParameter("@addTxt", str1), new SqlParameter("@DutyStr", str2), new SqlParameter("@isPic", (object)flag), new SqlParameter("@pic", str3), new SqlParameter("@alarmInfo", str), new SqlParameter("@cameraID", (object)num5) }; string str4 = "GpsPicServer_Alarm_Insert"; string str5 = "GpsPicServer_RealTime_Insert"; if (AddMsgType != -99997) { int num6 = SqlDataAccess.insertBySp(str4, sqlParameter); if (num6 > 0) { LogMsg logMsg = new LogMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", ""); string[] strArrays = new string[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecebuffer" }; logMsg.Msg = string.Concat(strArrays); this.logHelper.WriteLog(logMsg); } else { ErrorMsg errorMsg = new ErrorMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", string.Concat("将平台检测", carAlarmState.ToString(), "报警报文插入gpsrecbuffer表错误,返回值!", num6.ToString())); this.logHelper.WriteError(errorMsg); } } int num7 = SqlDataAccess.insertBySp(str5, sqlParameter); if (num7 > 0) { string[] strArrays1 = new string[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecerealtime" }; LogMsg logMsg1 = new LogMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", string.Concat(strArrays1)); string[] strArrays2 = new string[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecerealtime" }; logMsg1.Msg = string.Concat(strArrays2); this.logHelper.WriteLog(logMsg1); } else { ErrorMsg errorMsg1 = new ErrorMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", string.Concat("将平台检测", carAlarmState.ToString(), "报警报文插入gpsrecerealtime_buffer表发生错误,返回值!", num7.ToString())); this.logHelper.WriteError(errorMsg1); } } catch (Exception exception1) { Exception exception = exception1; string[] strArrays3 = new string[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文插入数据库发生错误! 信息:", exception.Message }; ErrorMsg errorMsg2 = new ErrorMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", string.Concat(strArrays3)); this.logHelper.WriteError(errorMsg2); } } catch (Exception exception3) { Exception exception2 = exception3; LogHelper logHelper = new LogHelper(); ErrorMsg errorMsg3 = new ErrorMsg("PlatformAlarmPathSegmentAlarm", "InsertAlarmInfo", string.Concat("将平台检测", carAlarmState.ToString(), "报警报文插入gpsrecbuffer表 、gpsrecerealtime_buffer表发生错误!", exception2.Message)); logHelper.WriteError(errorMsg3); } }
private void InsertAlarmInfo(DataRow dr, CmdParam.CarAlarmState carAlarmState, int regionID) { try { int num = 0; string empty = string.Empty; int num1 = 1; long num2 = 4503599627370496L; int num3 = 1154; int num4 = 65; string str = string.Empty; string str1 = dr["AddMsgTxt"].ToString(); string str2 = null; bool flag = false; string str3 = null; int num5 = 0; try { SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter("@wrkid", (object)num), new SqlParameter("@orderid", dr["OrderId"]), new SqlParameter("@userid", empty), new SqlParameter("@telephone", dr["telephone"]), new SqlParameter("@msgType", (object)num4), new SqlParameter("@recetime", dr["ReceTime"]), new SqlParameter("@gpstime", dr["GpsTime"]), new SqlParameter("@starCondition", dr["StarCondition"]), new SqlParameter("@starNum", dr["StarNum"]), new SqlParameter("@carStatu", (object)num1), new SqlParameter("@carStatuEx", (object)num2), new SqlParameter("@carCondition", dr["CarCondition"]), new SqlParameter("@Longitude", dr["Longitude"]), new SqlParameter("@Latitude", dr["Latitude"]), new SqlParameter("@direct", dr["Direct"]), new SqlParameter("@speed", dr["Speed"]), new SqlParameter("@Reserved", (object)num3), new SqlParameter("@TransportStatus", dr["TransportStatus"]), new SqlParameter("@Accelerration", dr["Accelerration"]), new SqlParameter("@Altitude", dr["Altitude"]), new SqlParameter("@DistanceDiff", dr["DistanceDiff"]), new SqlParameter("@commflag", dr["CommFlag"]), new SqlParameter("@addType", dr["AddMsgType"]), new SqlParameter("@addTxt", str1), new SqlParameter("@DutyStr", str2), new SqlParameter("@isPic", (object)flag), new SqlParameter("@pic", str3), new SqlParameter("@alarmInfo", str), new SqlParameter("@cameraID", (object)num5) }; string str4 = "GpsPicServer_Alarm_Insert"; string str5 = "GpsPicServer_RealTime_Insert"; int num6 = SqlDataAccess.insertBySp(str4, sqlParameter); if (num6 > 0) { LogMsg logMsg = new LogMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", ""); object[] objArray = new object[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecebuffer,区域ID:", regionID }; logMsg.Msg = string.Concat(objArray); this.logHelper.WriteLog(logMsg); } else { object[] objArray1 = new object[] { "将平台检测", carAlarmState.ToString(), "报警报文插入gpsrecbuffer表错误,返回值!", num6.ToString(), ",区域ID:", regionID }; ErrorMsg errorMsg = new ErrorMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", string.Concat(objArray1)); this.logHelper.WriteError(errorMsg); } int num7 = SqlDataAccess.insertBySp(str5, sqlParameter); if (num7 > 0) { string[] strArrays = new string[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecerealtime" }; LogMsg logMsg1 = new LogMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", string.Concat(strArrays)); object[] objArray2 = new object[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), "报警报文已插入gpsrecerealtime,区域ID:", regionID }; logMsg1.Msg = string.Concat(objArray2); this.logHelper.WriteLog(logMsg1); } else { object[] objArray3 = new object[] { "将平台检测", carAlarmState.ToString(), "报警报文插入gpsrecerealtime_buffer表发生错误,返回值!", num7.ToString(), ",区域ID:", regionID }; ErrorMsg errorMsg1 = new ErrorMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", string.Concat(objArray3)); this.logHelper.WriteError(errorMsg1); } } catch (Exception exception1) { Exception exception = exception1; object[] objArray4 = new object[] { "车载电话为:", dr["telephone"].ToString(), "的平台检测", carAlarmState.ToString(), ",区域ID:", regionID, "报警报文插入数据库发生错误! 信息:", exception.Message }; ErrorMsg errorMsg2 = new ErrorMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", string.Concat(objArray4)); this.logHelper.WriteError(errorMsg2); } } catch (Exception exception3) { Exception exception2 = exception3; LogHelper logHelper = new LogHelper(); object[] objArray5 = new object[] { "将平台检测", carAlarmState.ToString(), ",区域ID:", regionID, "报警报文插入gpsrecbuffer表 、gpsrecerealtime_buffer表发生错误!", exception2.Message }; ErrorMsg errorMsg3 = new ErrorMsg("PlatformAlarmRegionAlarm", "InsertAlarmInfo", string.Concat(objArray5)); logHelper.WriteError(errorMsg3); } }