//辅助数据库更新线程
private void UpdateDB()
{
while (active)
{
try
{
//写入操作记录到数据库
List <String> list = GetPosition();
list.AddRange(GetOrder());
list.AddRange(GetOperation());
//写入记录到数据库
if (list.Count > 0)
{
DBManager dbm = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
foreach (String s in list)
{
dbm.ExecuteUpdate(s);
}
dbm.Close();
}
}
catch { }
try
{
System.Threading.Thread.Sleep(SLEEP_TIME);
}
catch { }
}
thread = null;
}
void udpConnection_OnReceive(MoonStudio.Udp.UDPConnection uc, string remote, int rPort, string msg)
{
try
{
//logger.AddMsg("udp终端信息(ascii):" + msg);
//logger.AddMsg("udp终端信息(hex):" + Pub.RealHexToStr(msg));
// MessageBox.Show(msg);
// MessageBox.Show(msg.Substring(5, 4));
if (msg.Substring(1, 5) == "SJHXL")
{
String str, str1 = "";
str = msg.Substring(6, 8);
str = str.Substring(6, 2) + str.Substring(4, 2) + str.Substring(2, 2) + str.Substring(0, 2);
DBManager dbms = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
// DataTable dt = dbms.ExecuteQuery("select * from Terminal where machineNO="+str+";"); //目前不使用该语句。使用下面的存储过程语句来判断是否存在记录
DataTable dt = dbms.ExecuteQuery("select_Terminal " + "'" + str + "'");
foreach (DataRow dr in dt.Rows)
{
str1 = dr[0].ToString();
}
if (str1 == "")
{
// MessageBox.Show("a");
dbms.ExecuteUpdate("insert_Terminal " + "'" + str + "'" + "," + "'" + remote + "'" + "," + rPort);
string order = Protocol_XunLuoShu.AutoOrder(false, str);
udpConnection.Send(remote, rPort, order);
dbms.ExecuteUpdate("insert_Terminal " + "'" + str + "'" + "," + "'" + remote + "'" + "," + rPort);
order = Protocol_XunLuoShu.AutoOrder(false, str);
udpConnection.Send(remote, rPort, order);
dbms.ExecuteUpdate("insert_Terminal " + "'" + str + "'" + "," + "'" + remote + "'" + "," + rPort);
order = Protocol_XunLuoShu.AutoOrder(false, str);
udpConnection.Send(remote, rPort, order);
}
else
{
// MessageBox.Show("b");
dbms.ExecuteUpdate("update_Terminal " + "'" + str + "'" + "," + rPort + "," + "'" + remote + "'");
}
dbms.Close();
}
if (msg.Substring(5, 4) == "TEST")
{
udpConnection.Send(remote, rPort, msg);
}
/* 检测GPRS网络是否发生虚连接 巡逻鼠硬件
* E、判断车机与中心的连接情况
* 实例：设备定时向中心发送字符“$SJHXTEST,”中心收到后原样字符串“$SJHXTEST,”发送给此IP地址即可，而不用管是哪个设备ID号码发过来的。
* //*/
GPSInfo gi = new GPSInfo(msg, remote, rPort);
analyzer.AddInInfo(gi);
}
catch (Exception e)
{
if (FormMain.LOG_ERR)
{
logger.AddErr(e, "");
}
}
}