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