public static void AddPosition(Location location)
{
string sql = @"
INSERT INTO [{0}]
([IDCode]
,[GpsTime]
,[SatelliteNum]
,[GpsLongitude]
,[GpsLatitude]
,[BaiduLongitude]
,[BaiduLatitude]
,[Direction]
,[GpsSpeed]
,[ObdSpeed]
,[EngineTemperature]
,[CoordinateTypeID])
VALUES
(@IDCode ,@GpsTime ,@SatelliteNum ,@GpsLongitude ,@GpsLatitude ,@BaiduLongitude ,@BaiduLatitude ,
@Direction ,@GpsSpeed ,@ObdSpeed ,@EngineTemperature ,@CoordinateTypeID)";
sql = string.Format(sql, GetTableName());
List<SqlParameter> commandParameters = new List<SqlParameter>();
commandParameters.Add(new SqlParameter("@IDCode",location.IDCode));
commandParameters.Add(new SqlParameter("@GpsTime", location.GpsTime));
commandParameters.Add(new SqlParameter("@SatelliteNum", location.SatelliteNum));
commandParameters.Add(new SqlParameter("@GpsLongitude", location.Longitude));
commandParameters.Add(new SqlParameter("@GpsLatitude", location.Latitude));
BaiduCoordinate baiduCoord = ConvertCoordinate(new GpsCoordinate { Latitude = location.Latitude, Longitude = location.Longitude });
commandParameters.Add(new SqlParameter("@BaiduLongitude", baiduCoord.Longitude));
commandParameters.Add(new SqlParameter("@BaiduLatitude", baiduCoord.Latitude));
commandParameters.Add(new SqlParameter("@Direction", location.Direction));
commandParameters.Add(new SqlParameter("@GpsSpeed", location.GpsSpeed));
commandParameters.Add(new SqlParameter("@ObdSpeed", location.ObdSpeed));
commandParameters.Add(new SqlParameter("@EngineTemperature", location.EngineTemperature));
commandParameters.Add(new SqlParameter("@CoordinateTypeID", location.CoordinateType.GetHashCode()));
SQLHelper.ExecuteNonQuery(GetEntConnectionString(location.IDCode), CommandType.Text, sql, commandParameters.ToArray());
UpdateCurrentPosition(commandParameters.ToArray());
}
private void ProcessOneMessage(object tcp)
{
TcpClient tcpClient = tcp as TcpClient;
NetworkStream ns = tcpClient.GetStream();
byte[] receiveBuffer = new byte[10 * 1024];
byte[] decodedBuffer = null;
//bool normalExit = false;
bool exitWhile = false;
while (!exitWhile)
{
int receivedBufferSize = 0;
try
{
receivedBufferSize = ns.Read(receiveBuffer, 0, receiveBuffer.Length);
if (receivedBufferSize <= 0)
{
RemoveUnconnectedDevices();
break;
}
}
catch (IOException iEx)
{
log.Error("IOException", iEx);
RemoveUnconnectedDevices();
break;
}
catch (ObjectDisposedException odEx)
{
log.Error("ObjectDisposedException", odEx);
RemoveUnconnectedDevices();
break;
}
catch (Exception ex)
{
log.Error("Exception", ex);
RemoveUnconnectedDevices();
break;
}
log.Debug("[Start] - Process one message from remote");
decodedBuffer = ByteHelper.DecodeBytes(receiveBuffer, receivedBufferSize);
log.Debug(string.Format("-> The size of message : [{0}]", decodedBuffer.Length));
MessageHandler messageHandler = new MessageHandler(ns);
List<Message> messageList = messageHandler.SplitMessages(decodedBuffer);
foreach (Message message in messageList)
{
if (message.MessageType == DeviceMessageType.MessageError) continue;
messageHandler.SendServerACK(message.MessageBuffer);
string idcode = message.MessageHexEncoded.Substring(3, 29).Replace(" ", "");
DeviceHelper dHelper = DeviceHelper.Instance();
if (!dHelper.DeviceList.ContainsKey(idcode))
{
lock (obj)
{
if (!dHelper.DeviceList.ContainsKey(idcode))
{
JBODevice jboDevice = new JBODevice(tcpClient);
jboDevice.IDCode = idcode;
dHelper.DeviceList[idcode] = jboDevice;
}
}
}
switch (message.MessageType)
{
//case DeviceCommandType.Beat:
// SendServerACK(receiveBuffer, ns);
// break;
case DeviceMessageType.DeviceAgpsTime:
//SendServerACK(receiveBuffer, ns);
messageHandler.SendAgpsCheckResult(message.MessageBuffer, message.MessageBuffer.Length);
break;
case DeviceMessageType.UpdateAgpsRequest:
//SendServerACK(receiveBuffer, ns);
messageHandler.SendAgpsData(message.MessageBuffer);
break;
case DeviceMessageType.UpdateAgpsResponse:
//SendServerACK(receiveBuffer, ns);
//fsEphemeris.Close();
break;
case DeviceMessageType.ComfirmTime:
messageHandler.SendServerTime(message.MessageBuffer);
break;
case DeviceMessageType.UploadObdStatus:
//170,18,52,86,120,144,0,0,0,0,1,16,0,56,0,8,19,17,16,18,39,84,0,151,1,0,0,39,0,60,0,0,32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,103,170,170,18,52,86,120,144,0,0,0,0,1,17,0,17,0,3,1,25,12,0,0,1,99,0,0,19,136,0,0,39,16,64,170,
//AA 12 34 56 78 90 00 00 00 00 01 10 00 38 00 08 13 11 10 12 27 54 00 97 01 00 00 27 00 3C 00 00 20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 67 AA AA 12 34 56 78 90 00 00 00 00 01 11 00 11 00 03 01 19 0C 00 00 01 63 00 00 13 88 00 00 27 10 40 AA
//SendServerACK(receiveBuffer, ns);
break;
case DeviceMessageType.UploadJourneyRecord:
//170,18,52,86,120,144,0,0,0,0,1,14,0,38,0,7,19,17,16,18,39,80,19,17,16,18,36,54,0,0,50,0,0,0,0,0,0,0,0,0,0,25,66,7,173,151,0,9,4,70,0,6,202,170,170,18,52,86,120,144,0,0,0,0,1,15,0,26,0,4,19,17,16,18,39,84,8,0,78,7,16,64,52,2,48,41,134,101,62,0,0,0,0,0,24,170,
//AA 12 34 56 78 90 00 00 00 00 01 0E 00 26 00 07 13 11 10 12 27 50 13 11 10 12 24 36 00 00 32 00 00 00 00 00 00 00 00 00 00 19 42 07 AD 97 00 09 04 46 00 06 CA AA AA 12 34 56 78 90 00 00 00 00 01 0F 00 1A 00 04 13 11 10 12 27 54 08 00 4E 07 10 40 34 02 30 29 86 65 3E 00 00 00 00 00 18 AA
//SendServerACK(receiveBuffer, ns);
break;
case DeviceMessageType.UploadFaultCode:
//170,18,52,86,120,144,0,0,0,0,1,6,0,8,0,5,1,80,49,51,51,54,196,170,
//AA 12 34 56 78 90 00 00 00 00 01 06 00 08 00 05 01 50 31 33 33 36 C4 AA
//SendServerACK(receiveBuffer, ns);
break;
case DeviceMessageType.LocationInfo:
//AA 12 34 56 78 90 00 00 00 00 01 0D 00 22 00 04 13 11 22 22 22 45 08 00 0F 07 10 40 33 01 30 30 39 50 3D 13 19 47 00 06 05 3A 00 01 00 00 00 01 95 AA
Location location = new Location(message.MessageBuffer);
if (location.IsGpsLocation && location.CoordinateType == LocationCoordinateType.GPS)
{
try
{
LocationDAL.AddPosition(location);
}
catch (Exception ex)
{
log.Error("Exception", ex);
}
}
break;
default:
break;
}
}
log.Debug("[End] - Process one message from remote");
}
}
