private bool execConnection() { Response response = RemotingClient.LoginSys_Login(false, true); if (response.ResultCode != (long)0) { Record.execFileRecord("用户登录", string.Format("{0}登录失败:{1}", Variable.sUserId, response.ErrorMsg)); return false; } LogHelper logHelper = new LogHelper(); LogMsg logMsg = new LogMsg() { Msg = string.Concat("用户登录", string.Format("{0}登录成功:{1}", Variable.sUserId, response.ErrorMsg)) }; logHelper.WriteLog(logMsg); return true; }
private void AdminRegionAlarmInsert(DataTable dt) { if (dt == null || dt.Rows.Count <= 0) { return; } try { LogHelper logHelper = new LogHelper(); int num = 0; string empty = string.Empty; int num1 = 1154; int num2 = 65; string str = string.Empty; string str1 = null; bool flag = false; string str2 = null; int num3 = 0; foreach (DataRow row in dt.Rows) { try { SqlParameter[] sqlParameter = new SqlParameter[] { new SqlParameter("@wrkid", (object)num), new SqlParameter("@orderid", row["OrderId"]), new SqlParameter("@userid", empty), new SqlParameter("@telephone", row["SimNum"]), new SqlParameter("@msgType", (object)num2), new SqlParameter("@recetime", row["ReceTime"]), new SqlParameter("@gpstime", row["GpsTime"]), new SqlParameter("@starCondition", row["StarCondition"]), new SqlParameter("@starNum", row["StarNum"]), new SqlParameter("@carStatu", row["carStatu"]), new SqlParameter("@carStatuEx", row["CarStatuEx"]), new SqlParameter("@carCondition", row["CarCondition"]), new SqlParameter("@Longitude", row["Longitude"]), new SqlParameter("@Latitude", row["Latitude"]), new SqlParameter("@direct", row["Direct"]), new SqlParameter("@speed", row["Speed"]), new SqlParameter("@Reserved", (object)num1), new SqlParameter("@TransportStatus", row["TransportStatus"]), new SqlParameter("@Accelerration", row["Accelerration"]), new SqlParameter("@Altitude", row["Altitude"]), new SqlParameter("@DistanceDiff", row["DistanceDiff"]), new SqlParameter("@commflag", row["CommFlag"]), new SqlParameter("@addType", row["AddMsgType"]), new SqlParameter("@addTxt", row["AddMsgTxt"]), new SqlParameter("@DutyStr", str1), new SqlParameter("@isPic", (object)flag), new SqlParameter("@pic", str2), new SqlParameter("@alarmInfo", row["AdminRegionName"].ToString()), new SqlParameter("@cameraID", (object)num3) }; string str3 = "GpsPicServer_Alarm_Insert"; string str4 = "GpsPicServer_RealTime_Insert"; int num4 = SqlDataAccess.insertBySp(str3, sqlParameter); if (num4 > 0) { LogMsg logMsg = new LogMsg("", "", string.Concat("车载电话为:", row["SimNum"].ToString(), "的出入行政区报警报文已插入gpsrecebuffer")); logHelper.WriteLog(logMsg); } else { ErrorMsg errorMsg = new ErrorMsg("ReadDataFromDB", "AdminRegionAlarmInsert", string.Concat("将出入行政区报警报文插入gpsrecbuffer表错误,返回值!", num4.ToString())); logHelper.WriteError(errorMsg); } int num5 = SqlDataAccess.insertBySp(str4, sqlParameter); if (num5 > 0) { LogMsg logMsg1 = new LogMsg("", "", string.Concat("车载电话为:", row["SimNum"].ToString(), "的出入行政区报警报文已插入gpsrecerealtime")); logHelper.WriteLog(logMsg1); } else { ErrorMsg errorMsg1 = new ErrorMsg("ReadDataFromDB", "AdminRegionAlarmInsert", string.Concat("将出入行政区报警报文插入gpsrecerealtime_buffer表发生错误,返回值!", num5.ToString())); logHelper.WriteError(errorMsg1); } } catch (Exception exception1) { Exception exception = exception1; ErrorMsg errorMsg2 = new ErrorMsg("IORegionTimer", "AdminRegionAlarmInsert", string.Concat("车载电话为:", row["SimNum"].ToString(), "的出入行政区报警报文插入数据库发生错误! 信息:", exception.Message)); logHelper.WriteError(errorMsg2); } } } catch (Exception exception3) { Exception exception2 = exception3; LogHelper logHelper1 = new LogHelper(); ErrorMsg errorMsg3 = new ErrorMsg("IORegionTimer", "AdminRegionAlarmInsert", string.Concat("将出入行政区报警报文插入gpsrecbuffer表 、gpsrecerealtime_buffer表发生错误!", exception2.Message)); logHelper1.WriteError(errorMsg3); } }
private static void GpsPicMain() { LogMsg logMsg = new LogMsg() { ClassName = "Service", FunctionName = "GpsPicMain", Msg = "启动定时服务器 成功" }; LogHelper logHelper = new LogHelper(); logHelper.WriteLog(logMsg); ReadDataFromXml.UpdateParameter(); logMsg.Msg = "未开启定时拍照功能"; if (ReadDataFromXml.IsPic) { logMsg.Msg = "开启定时拍照功能"; picTimer = new PicTimer(); picTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启掉线通知功能"; if (ReadDataFromXml.IsCuff) { logMsg.Msg = "开启掉线通知功能"; cuffTimer = new CuffTimer(); cuffTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启播报信息功能"; if (ReadDataFromXml.IsBroadCast) { logMsg.Msg = "开启播报信息功能"; broadCastTimer = new BroadCastTimer(); broadCastTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启LBS定位服务"; if (ReadDataFromXml.IsLBSPos) { logMsg.Msg = "开启LBS定位服务"; lBSTimer = new LBSTimer(); lBSTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启LCS定位服务"; if (ReadDataFromXml.IsLCSPos) { logMsg.Msg = "开启LCS定位服务"; lCSTimer = new LCSTimer(); lCSTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启订单状态解析"; if (ReadDataFromXml.IsBillPos) { logMsg.Msg = "开启订单状态解析"; addressResolution = new AddressResolution(); addressResolution.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启出入行政区报警"; if (ReadDataFromXml.IsAdminRegionAlarm) { logMsg.Msg = "开启出入行政区报警服务"; iORegionTimer = new IORegionTimer(); iORegionTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开故障检测功能"; if (ReadDataFromXml.IsChkError) { logMsg.Msg = "开启故障检测功能"; chkErrorTimer = new ChkErrorTimer(); chkErrorTimer.start(); logHelper.WriteLog(logMsg, logMsg.Msg); } logMsg.Msg = "未开启未按时归班报警"; if (ReadDataFromXml.IsBeBackOnTime) { logMsg.Msg = "开启未按时归班报警"; carBeBackOnTime = new CarBeBackOnTime(); carBeBackOnTime.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启DWLBS手机定位"; if (ReadDataFromXml.IsDWLBSPos) { logMsg.Msg = "开启DWLBS手机定位"; dWLBSPos = new DWLBSPos(); dWLBSPos.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启未按时进出站报警"; if (ReadDataFromXml.IsInOutOfRangeOnTime) { logMsg.Msg = "开启未按时进出站报警"; carInOutOfRangeOnTime = new CarInOutOfRangeOnTime(); carInOutOfRangeOnTime.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启平台报警-偏移路线报警"; if (ReadDataFromXml.IsPathAlarm) { logMsg.Msg = "开启平台报警-偏移路线报警"; platformAlarmPathAlarm = new PlatformAlarmPathAlarm(); platformAlarmPathAlarm.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启平台报警-分路段超速报警"; if (ReadDataFromXml.IsPathSegmentAlarm) { logMsg.Msg = "开启平台报警-分路段超速报警"; platformAlarmPathSegmentAlarm = new PlatformAlarmPathSegmentAlarm(); platformAlarmPathSegmentAlarm.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启平台报警-区域报警报警"; if (ReadDataFromXml.IsRegionAlarm) { logMsg.Msg = "开启平台报警-区域报警报警"; platformAlarmRegionAlarm = new PlatformAlarmRegionAlarm(); platformAlarmRegionAlarm.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启交通部上下线通知"; if (ReadDataFromXml.IsJTBOnOffNotice) { logMsg.Msg = "开启交通部上下线通知"; jTBOnOffLineNotice = new JTBOnOffLineNotice(); jTBOnOffLineNotice.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启定时下发终端点播"; if (ReadDataFromXml.IsTerminalDemand) { logMsg.Msg = "开启定时下发终端点播"; jTBTerminalDemand = new JTBTerminalDemand(); jTBTerminalDemand.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启聚集报警"; if (ReadDataFromXml.IsGatheredAlarm) { logMsg.Msg = "开启聚集报警"; platformGatheredAlarm = new PlatformGatheredAlarm(); platformGatheredAlarm.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启发送详细位置信息"; if (ReadDataFromXml.IsCurrentAddress) { logMsg.Msg = "开启发送详细位置信息"; inquiresCarCurrentAddress = new InquiresCarCurrentAddress(); inquiresCarCurrentAddress.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启脱车粘车报警"; if (ReadDataFromXml.IsSeparateAndSticky) { logMsg.Msg = "开启脱车粘车报警"; separateAndSticky = new SeparateAndSticky(); separateAndSticky.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启终端未上线短信提醒"; if (ReadDataFromXml.IsMsgRemind) { logMsg.Msg = "开启终端未上线短信提醒"; terminalOffLineMessageRemind = new TerminalOffLineMessageRemind(); terminalOffLineMessageRemind.start(); logHelper.WriteLog(logMsg); } logMsg.Msg = "未开启发送配置短信功能"; if (ReadDataFromXml.IsSendPZMsg) { logMsg.Msg = "开启发送配置短信功能"; sendPZMessage = new SendPZMessage(); sendPZMessage.start(); logHelper.WriteLog(logMsg); } if (ReadDataFromXml.IsForbidDriveAlarm) { logMsg.Msg = "开启平台禁驾报警功能"; platFormrForbidDriveAlarm = new PlatFormrForbidDriveAlarm(); platFormrForbidDriveAlarm.start(); logHelper.WriteLog(logMsg); } if (ReadDataFromXml.IsThreeLevelRoadAlarm) { logMsg.Msg = "开启平台三级路面报警"; platFormAlarmThreeLevelRoadAlarm = new PlatFormAlarmThreeLevelRoadAlarm(); platFormAlarmThreeLevelRoadAlarm.start(); logHelper.WriteLog(logMsg); } if (ReadDataFromXml.IschkRoadSpeedAndRank) { logMsg.Msg = "开启分道路等级超速报警"; platFormCheckRoadSpeedAndRank = new PlatFormCheckRoadSpeedAndRank(); platFormCheckRoadSpeedAndRank.start(); logHelper.WriteLog(logMsg); } try { tDeleteLogTimer = new System.Timers.Timer((double)1000); tDeleteLogTimer.Elapsed += new System.Timers.ElapsedEventHandler(onDeleteOldRecord); tDeleteLogTimer.Enabled = true; } catch (Exception exception) { logHelper.WriteError(new ErrorMsg("Service", "启动日志删除失败", exception.Message)); } }
private void UpdateRemedyBill(DataTable dtOrder) { LogHelper logHelper = new LogHelper(); LogMsg logMsg = new LogMsg(); try { string str = ""; string str1 = " update GpsShippingInfo set ActArrivalDate = {0},LastPosition = '{1}',Status = '{2}',ActShippingTime = {3},BeginMileage = {4},EndMileage = {5},IsNotRemedy = '{6}', RemedyTime = {7} where Id = {8};"; foreach (DataRow row in dtOrder.Rows) { string str2 = (row["ActArrivalDate"] == DBNull.Value ? "null" : string.Concat("'", row["ActArrivalDate"].ToString(), "'")); string str3 = row["LastPosition"].ToString(); string str4 = row["Status"].ToString(); string str5 = (row["ActShippingTime"] == DBNull.Value ? "null" : string.Concat("'", row["ActShippingTime"].ToString(), "'")); string str6 = (row["BeginMileage"] == DBNull.Value ? "null" : string.Concat("'", row["BeginMileage"].ToString(), "'")); string str7 = (row["EndMileage"] == DBNull.Value ? "null" : string.Concat("'", row["EndMileage"].ToString(), "'")); string str8 = row["IsNotRemedy"].ToString(); string str9 = (row["RemedyTime"] == DBNull.Value ? "null" : string.Concat("'", row["RemedyTime"].ToString(), "'")); string str10 = row["Id"].ToString(); object[] objArray = new object[] { str2, str3, str4, str5, str6, str7, str8, str9, str10 }; str = string.Concat(str, string.Format(str1, objArray)); if (str8 != "-1") { if (str8 != "1") { continue; } logMsg.ClassName = "ReadDataFromDB"; logMsg.FunctionName = "UpdateRemedyBill"; string[] strArrays = new string[] { "Id为", str10, ",订单号为", row["WaybillCode"].ToString(), "的订单已经到达" }; logMsg.Msg = string.Concat(strArrays); logHelper.WriteLog(logMsg); } else { logMsg.ClassName = "ReadDataFromDB"; logMsg.FunctionName = "UpdateRemedyBill"; string[] strArrays1 = new string[] { "Id为", str10, ",订单号为", row["WaybillCode"].ToString(), "的订单已经过期, IsNotRemedy为-1" }; logMsg.Msg = string.Concat(strArrays1); logHelper.WriteLog(logMsg); } } SqlDataAccess.insertBySql(str); } catch (Exception exception1) { Exception exception = exception1; ErrorMsg errorMsg = new ErrorMsg() { ClassName = "AddressResolution", FunctionName = "UpdateRemedyBill", ErrorText = string.Concat("更新订单状态发生错误!", exception.Message) }; logHelper.WriteError(errorMsg, exception); } }
private int InsertCarDayPos(string[] Locations, ref int count) { int num; try { if (Locations == null || (int)Locations.Length <= 0) { num = -1; } else { string str = " insert into DF_CarDayPos(Gpstime, SimNum, Longitude, Latitude, CarPos) select '{0}','{1}','{2}','{3}','{4}' "; string str1 = " UNION ALL SELECT '{0}','{1}','{2}','{3}','{4}' "; bool flag = true; string[] locations = Locations; for (int i = 0; i < (int)locations.Length; i++) { string str2 = locations[i]; char[] chrArray = new char[] { ':' }; string[] strArrays = str2.Split(chrArray, 2); string[] strArrays1 = strArrays[1].Split(new char[] { ',' }); if (strArrays1 != null && (int)strArrays1.Length > 0) { string[] strArrays2 = strArrays1; for (int j = 0; j < (int)strArrays2.Length; j++) { string str3 = strArrays2[j]; string[] strArrays3 = str3.Split(new char[] { '@' }); if ((int)strArrays3.Length < 4) { LogHelper logHelper = new LogHelper(); LogMsg logMsg = new LogMsg() { ClassName = "ReadDataFromDB", FunctionName = "InsertCarDayPos", Msg = string.Concat("组合车辆位置信息失败,", str3) }; logHelper.WriteLog(logMsg); } else if (!flag) { object[] objArray = new object[] { strArrays3[0], strArrays3[1], strArrays3[2], strArrays3[3], strArrays[0] }; str = string.Concat(str, string.Format(str1, objArray)); count = count + 1; } else { flag = false; object[] objArray1 = new object[] { strArrays3[0], strArrays3[1], strArrays3[2], strArrays3[3], strArrays[0] }; str = string.Format(str, objArray1); count = 1; } } } } num = SqlDataAccess.insertBySql(str); } } catch (Exception exception1) { Exception exception = exception1; LogHelper logHelper1 = new LogHelper(); ErrorMsg errorMsg = new ErrorMsg("AddressResolution", "InsertCarDayPos", string.Concat("插入车辆最接近12点详细位置信息发生错误!", exception.Message)); logHelper1.WriteError(errorMsg); num = -1; } return num; }
private void LBSMuliPos() { if (this.htLBSPos == null || this.htLBSPos.Count <= 0) { return; } LogHelper logHelper = new LogHelper(); string empty = string.Empty; long num = (long)0; try { empty = this.getSimNums().ToString(); string[] strArrays = empty.Split(new char[] { ';' }); for (int i = 0; i < (int)strArrays.Length; i++) { string str = strArrays[i]; char[] chrArray = new char[] { ',' }; ArrayList arrayLists = new ArrayList(str.Split(chrArray)); if (arrayLists[arrayLists.Count - 1].Equals("")) { arrayLists.RemoveAt(arrayLists.Count - 1); } string[] strArrays1 = arrayLists[0].ToString().Split(new char[] { '|' }); string str1 = strArrays1[0]; int num1 = Convert.ToInt32(strArrays1[1]); object phoneList = this.getPhoneList(arrayLists); if (this.myDownData.icar_SendRawPackage(str1, phoneList, num1) != (long)0) { int count = arrayLists.Count; logHelper.WriteLog(new LogMsg("Service", "LBSPos", string.Concat("指令下发: 串头: ", str1, " 失败 下发车数:", count.ToString()))); } else { int count1 = arrayLists.Count; logHelper.WriteLog(new LogMsg("Service", "LBSPos", string.Concat("指令下发: 串头: ", str1, " 成功 下发车数:", count1.ToString()))); } if (ReadDataFromXml.LBSPosSleepTime != 0) { Thread.Sleep(1000 * ReadDataFromXml.LBSPosSleepTime); } } } catch (Exception exception) { logHelper.WriteError(new ErrorMsg("LBSTimer", "LBSLBSMuliPos", exception.Message)); Thread.Sleep(60000); } }