public bool UpLoad(byte[] buffer, string deviceid)
{
DETECTION_INFO detInfo = new DETECTION_INFO();//共计866字节
object detinfoType = detInfo;
TastInfo Tinfo = new TastInfo();
Tinfo.ByteArrayToStructureEndian(buffer, ref detinfoType, 0);
detInfo = (DETECTION_INFO)detinfoType;
//写入数据库
string batch_id = System.Text.Encoding.UTF8.GetString(detInfo.batch_id, 0, GetLen(detInfo.batch_id)).Trim();
string task_id = System.Text.Encoding.UTF8.GetString(detInfo.task_id, 0, GetLen(detInfo.task_id)).Trim();
// UInt64 batch_id = detInfo.batch_id;
// UInt32 task_id = detInfo.task_id;
string p_name = System.Text.Encoding.UTF8.GetString(detInfo.p_name, 0, GetLen(detInfo.p_name)).Trim();
string type = System.Text.Encoding.UTF8.GetString(detInfo.type, 0, GetLen(detInfo.type));
int channel = (int)detInfo.channel;
string ftest_result = System.Text.Encoding.UTF8.GetString(detInfo.ftest_result, 0, GetLen(detInfo.ftest_result)).Trim();
string test_result = System.Text.Encoding.UTF8.GetString(detInfo.test_result, 0, GetLen(detInfo.test_result)).Trim();
string result_unit = System.Text.Encoding.UTF8.GetString(detInfo.result_unit, 0, GetLen(detInfo.result_unit)).Trim();
string standard = System.Text.Encoding.UTF8.GetString(detInfo.standard, 0, GetLen(detInfo.standard)).Trim();
string abs_result = System.Text.Encoding.UTF8.GetString(detInfo.abs_result, 0, GetLen(detInfo.abs_result)).Trim();
string sample_no = System.Text.Encoding.UTF8.GetString(detInfo.sample_no, 0, GetLen(detInfo.sample_no)).Trim();
string sample_name = System.Text.Encoding.UTF8.GetString(detInfo.sample_name, 0, GetLen(detInfo.sample_name)).Trim();
string sites = System.Text.Encoding.UTF8.GetString(detInfo.sites, 0, GetLen(detInfo.sites)).Trim();
string submission_unit = System.Text.Encoding.UTF8.GetString(detInfo.submission_unit, 0, GetLen(detInfo.submission_unit)).Trim();
string test_operator = System.Text.Encoding.UTF8.GetString(detInfo.test_operator, 0, GetLen(detInfo.test_operator)).Trim();
string test_unit = System.Text.Encoding.UTF8.GetString(detInfo.test_unit, 0, GetLen(detInfo.test_unit)).Trim();
string test_time = System.Text.Encoding.UTF8.GetString(detInfo.test_time, 0, GetLen(detInfo.test_time)).Trim();
// DateTime dt = DateTime.ParseExact(test_time, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
int User_Id = 1234;
if (deviceid != null)
{
User_Id = int.Parse(deviceid);
}
string strsql = "Insert Into " +
"detectioninfo(batch_id,task_id,p_name,type,channel,Juge_result,Detect_result,result_unit,standard,Absolut_result,sample_no,sample_name,sites,submission_unit,test_operator,test_unit,test_time,Device_ID)"
+ "values('" + batch_id + "','" + task_id + "','" + p_name + "','" + type + "'," + channel + ",'" + ftest_result + "','" + test_result + "','" + result_unit + "','" + standard + "','" + abs_result + "','" + sample_no + "','" + sample_name + "','" + sites + "','" + submission_unit + "','" + test_operator + "','" + test_unit + "','" + test_time + "'," + User_Id + ")";
try
{
dbMySql.Open(databasename);
dbMySql.ExcuteNonQuery(databasename, strsql);
dbMySql.Close(databasename);
return(true);
}
catch (System.Exception ex)
{
return(false);
}
}
void RecvData(object sender, NetEventArgs e)
{
// string info = string.Format("recv data:{0} from:{1}.", e.Client.Datagram, e.Client);
// Console.WriteLine(info);
TcpSvr svr = (TcpSvr)sender;
//测试把收到的数据返回给客户端
// svr.SendText(e.Client, e.Client.Datagram);
//svr.SendFile(this.textBox1.Text);
// Console.Write(">");
DETECTION_INFO ff = new DETECTION_INFO();
int si = Marshal.SizeOf(ff);
//获取接受到的消息,已经去头，但是包括尾
// byte[] recivebuffer = System.Text.Encoding.Default.GetBytes(e.Client.Datagram);
List <Byte> lbyte = new List <Byte>();
byte[] recivebuffer = e.Client.RvBufer;
for (int k = 0; k < e.Client.RvBufer.Length - 1; k++)
{
byte b = e.Client.RvBufer[k];
byte c = e.Client.RvBufer[k + 1];
if (b == 0x5a && c == 0x01)
{
lbyte.Add(0x5b);
}
else if (b == 0x5a && c == 0x02)
{
lbyte.Add(0x5a);
}
else if (b == 0x5e && c == 0x01)
{
lbyte.Add(0x5d);
}
else if (b == 0x5e && c == 0x02)
{
lbyte.Add(0x5e);
}
else
{
lbyte.Add(b);
}
}
for (int i = 0; i < lbyte.Count; i++)
{
recivebuffer[i] = lbyte[i];
}
string batch_id = null;
string task_id = null;
//解析消息头
MSGHEAD head = new MSGHEAD();
byte[] headbuffer = new byte[MsgHeadLength];
Array.Copy(recivebuffer, 1, headbuffer, 0, MsgHeadLength);
head = Get_MSGHeader(headbuffer);
// head = Get_MSGHeader(e.Client.Datagram.Substring(0, MsgHeadLength));
//消息体数据
int Meg_len = (int)head.Msg_Length - MsgTotalLen;
byte[] buffer = new byte[Meg_len];//
Array.Copy(recivebuffer, 15, buffer, 0, Meg_len);
// for (int i = 0; i < head.Msg_Length; ++i)
// {
// byte t = recivebuffer[i];
// Console.Write("{0:X}", t);//这个就是主要，填充
// Console.Write(" ");
//
// }
// Console.Write("?");
//接入码s
UInt32 centercode = head.Msg_GNSSCenter;
TastInfo Tinfo = new TastInfo();
byte[] MesBody = null;
//空数据
byte[] nu = new byte[0];
//判定是不是注册
REGISTER Is_re = new REGISTER();
//根据不同消息进行处理
Session sendDataSession = svr.FindSession(e.Client.ClientSocket);
ICloneable copySession = (ICloneable)sendDataSession;
Session clientSession = (Session)copySession.Clone();
// Console.Write("*"+head.Msg_ID);
switch (head.Msg_ID)
{
//中心站只发过一个空包，或者包括简单的配置要求，服务器端组帧。
//链路登陆请求消息
case 0x0001:
Is_re = IsRegest(head, buffer);
// object structType = Is_re;
byte[] btArray = new byte[1];
btArray[0] = Is_re.result;
//MesBody = BitConverter.GetBytes(Is_re.result);
svr.SendMessage(e.Client, btArray, 0x0002, centercode); //登录应答
if (Is_re.result == 0)
{
foreach (DictionaryEntry de in svr._sessionTable) //ht为一个Hashtable实例
{
if (de.Value.Equals(clientSession))
{
clientSession.DeviceId = Is_re.nameId;
SessionId id = clientSession.ID;
svr._sessionTable.Remove(clientSession.ID);
svr._sessionTable.Add(id, clientSession);
break;
}
}
//更新数据库状态
string sql = "UPDATE device SET Device_Status = 1,Sockets = '" + clientSession.ClientSocket.RemoteEndPoint + "' WHERE Device_ID = '" + clientSession.DeviceId + "'";
database.Open();
database.ExcuteNonQuery(sql);
database.Close();
}
else
{
//Session sendDataSession = svr.FindSession(e.Client.ClientSocket);
//更新数据库状态
string sql = "UPDATE device SET Device_Status = 0 WHERE Device_ID = '" + clientSession.DeviceId + "'";
database.Open();
database.ExcuteNonQuery(sql);
database.Close();
}
break;
//用于心跳监测
case 0x0003:
svr.SendMessage(clientSession, nu, 0x0004, centercode); //开启视频
// Console.Write("|" + buffer[1]);
break;
//批量任务下发（中心站往终端）
//TEST NUM 4 Unint32_t 结果个数
//TEST INFO 804 Octet_string 检测结果信息
case 0x0005:
//获取任务个数
byte[] numbuffer = new byte[4]; //
Array.Copy(recivebuffer, 14, numbuffer, 0, 4); //获取个数
// Array.Reverse(numbuffer);
// UInt32 num = BitConverter.ToUInt32(numbuffer,0);
//组帧
TASK_INFO taskinfo = new TASK_INFO();
object structT = taskinfo;
MesBody = Tinfo.StructureToByteArrayEndian(structT);
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.DeviceId == deviceid)
{
svr.SendMessage(cliSession, nu, 0x0005, centercode); //开启视频
break;
}
}
//发送
break;
//检测结果上传消息
//检测结果上传（终端往中心站）
case 0x0006:
sendDataSession = svr.FindSession(e.Client.ClientSocket);
deviceid = sendDataSession.DeviceId;
UpLoad(buffer, deviceid.ToString());
break;
//开启实时监控
case 07:
//获取发过来的设备id，根据id找到socket
deviceid = UInt32.Parse(System.Text.Encoding.UTF8.GetString(buffer)); //提取控制的deviceid
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.DeviceId == deviceid)
{
svr.SendMessage(cliSession, nu, 0x0007, centercode); //开启视频
break;
}
}
break;
//中心站往检测仪结束实时视频
case 08:
deviceid = UInt32.Parse(System.Text.Encoding.UTF8.GetString(buffer)); //提取控制的deviceid
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.DeviceId == deviceid)
{
svr.SendMessage(cliSession, nu, 0x0008, centercode); //开启视频
break;
}
}
break;
case 09:
//视频上传（检测仪主动请求，中心站返回消息）
UInt32 res = 0;
byte[] meg = BitConverter.GetBytes(res);
Array.Reverse(meg);
svr.SendMessage(e.Client, meg, 0x000a, centercode); //录制视频上传应答
svr.FileBegine = true;
svr.IsPic = false;
break;
//证件上传请求
case 0x0000b:
UInt32 resu = 0;
byte[] megs = BitConverter.GetBytes(resu);
Array.Reverse(megs);
svr.SendMessage(e.Client, nu, 0x000c, centercode); //上传应答
svr.FileBegine = true;
svr.IsPic = true;
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.ClientSocket == e.Client.ClientSocket)
{
svr.device_id = cliSession.DeviceId.ToString();
}
}
break;
//视频调阅请求
case 0x0000d:
byte[] dev = new byte[12];
deviceid = UInt32.Parse(System.Text.Encoding.UTF8.GetString(buffer, 0, 4)); //提取控制的deviceid
batch_id = System.Text.Encoding.UTF8.GetString(buffer, 4, 8); //提取控制的deviceid
task_id = System.Text.Encoding.UTF8.GetString(buffer, 12, 4); //提取控制的deviceid
Array.Copy(buffer, 4, dev, 0, 12);
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.DeviceId == deviceid)
{
svr.SendMessage(cliSession, nu, 0x0008, centercode); //开启视频
break;
}
}
break;
//视频调阅
case 0x000e:
//将文件存储路径插入数据库
string filepath = System.Text.Encoding.UTF8.GetString(buffer, 0, GetLen(buffer)).Trim();
//更新数据库状态
string sql2 = "UPDATE detectioninfo SET video_path = '" + filepath + "' WHERE batch_id = '" + batch_id + "' AND task_id = '" + task_id + "'";
database.Open();
database.ExcuteNonQuery(sql2);
database.Close();
break;
//工作参数
case 0x0000f:
break;
//状态和工作参数
case 0x0010:
break;
//参数配置
case 0x0011:
byte[] aa = new byte[4];
Array.Copy(buffer, 0, aa, 0, 4);
byte[] Msg = new byte[buffer.Length - 4];
Array.Copy(buffer, 4, Msg, 0, buffer.Length - 4);
deviceid = UInt32.Parse(System.Text.Encoding.UTF8.GetString(aa)); //提取控制的deviceid
foreach (Session cliSession in svr._sessionTable.Values)
{
if (cliSession.DeviceId == deviceid)
{
svr.SendMessage(cliSession, Msg, 0x0012, centercode); //开启视频
break;
}
}
break;
//数据管理
case 0x0012:
break;
//设备管理消息
case 0x0013:
break;
//远程版本升级
case 0x0014:
break;
//版本升级应答
case 0x0015:
break;
//通用消息
case 0xf000:
break;
default:
break;
}
}
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void RecvData(object sender, NetEventArgs e)
{
// string info = string.Format("recv data:{0} from:{1}.", e.Client.Datagram, e.Client);
TcpSvr svr = (TcpSvr)sender;
byte[] recivebuffer = System.Text.Encoding.UTF8.GetBytes(e.Client.Datagram);
byte[] buffer = new byte[MsgHeadLength];
Array.Copy(recivebuffer, 1, buffer, 0, MsgHeadLength);
TastInfo Info = new TastInfo();
MSGHEAD head = new MSGHEAD();
object headType = head;
Info.ByteArrayToStructureEndian(buffer, ref headType, 0);
head = (MSGHEAD)headType;
string centercode = head.Msg_GNSSCenter.ToString();
switch (head.Msg_ID)
{
//用于心跳监测
case 03:
svr.SendMessage(e.Client, "", 0x0004, centercode);
// svr.SendMessage(e.Client, "", 0x0003, centercode);
break;
//检测结果上传消息
//TEST NUM 4 Unint32_t 结果个数
//TEST INFO 804 Octet_string 检测结果信息
case 06:
byte[] test_num = new byte[4];
Array.Copy(recivebuffer, MsgHeadLength + 1, test_num, 0, 4);
Array.Reverse(test_num);
UInt32 num = (UInt32)BitConverter.ToInt32(test_num, 0);
byte[] buffer3 = new byte[head.Msg_Length - 18 - 4];
Array.Copy(recivebuffer, MsgHeadLength + 1 + 4, buffer3, 0, head.Msg_Length - 18 - 4);
DETECTION_INFO detInfo = new DETECTION_INFO();
object detInfoType = detInfo;
Info.ByteArrayToStructureEndian(buffer3, ref detInfoType, 0);
detInfo = (DETECTION_INFO)detInfoType;
// DataTable tbInfo = LoadDetectionInfo();
// DataSet ds = new DataSet();
//
// DataRow r = tbInfo.NewRow();
// r["p_name"] = System.Text.Encoding.UTF8.GetString(detInfo.p_name, 0, GetLen(detInfo.p_name)).Trim();
// r["sample_name"] = System.Text.Encoding.UTF8.GetString(detInfo.sample_name,0,GetLen(detInfo.sample_name)).Trim();
// r["channel"] = detInfo.channel;
// r["type"] = System.Text.Encoding.UTF8.GetString(detInfo.type, 0, GetLen(detInfo.type));
// r["standard"] = System.Text.Encoding.UTF8.GetString(detInfo.standard, 0, GetLen(detInfo.standard));
// r["sample_no"] = System.Text.Encoding.UTF8.GetString(detInfo.sample_no, 0, GetLen(detInfo.sample_no)).Trim();
// r["sites"] = System.Text.Encoding.UTF8.GetString(detInfo.sites, 0, GetLen(detInfo.sites)).Trim();
// r["submission_unit"] = System.Text.Encoding.UTF8.GetString(detInfo.submission_unit, 0, GetLen(detInfo.submission_unit));
// r["test_operator"] = System.Text.Encoding.UTF8.GetString(detInfo.test_operator, 0, GetLen(detInfo.test_operator));
//
// r["test_unit"] = System.Text.Encoding.UTF8.GetString(detInfo.test_unit, 0, GetLen(detInfo.test_unit));
// r["test_time"] = System.Text.Encoding.UTF8.GetString(detInfo.test_time, 0, GetLen(detInfo.test_time));
//
// r["User_Id"] = e.Client.UserId;
//
// //并将数据写入到数据库
// tbInfo.Rows.Add(r);
string p_name = System.Text.Encoding.UTF8.GetString(detInfo.p_name, 0, GetLen(detInfo.p_name)).Trim();
string sample_name = System.Text.Encoding.UTF8.GetString(detInfo.sample_name, 0, GetLen(detInfo.sample_name)).Trim();
int channel = (int)detInfo.channel;
string type = System.Text.Encoding.UTF8.GetString(detInfo.type, 0, GetLen(detInfo.type));
string standard = System.Text.Encoding.UTF8.GetString(detInfo.standard, 0, GetLen(detInfo.standard));
string sample_no = System.Text.Encoding.UTF8.GetString(detInfo.sample_no, 0, GetLen(detInfo.sample_no)).Trim();
string sites = System.Text.Encoding.UTF8.GetString(detInfo.sites, 0, GetLen(detInfo.sites)).Trim();
string submission_unit = System.Text.Encoding.UTF8.GetString(detInfo.submission_unit, 0, GetLen(detInfo.submission_unit));
string test_operator = System.Text.Encoding.UTF8.GetString(detInfo.test_operator, 0, GetLen(detInfo.test_operator));
string test_unit = System.Text.Encoding.UTF8.GetString(detInfo.test_unit, 0, GetLen(detInfo.test_unit));
string test_time = System.Text.Encoding.UTF8.GetString(detInfo.test_time, 0, GetLen(detInfo.test_time));
DateTime dt = DateTime.ParseExact(test_time, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
int User_Id = (int)e.Client.UserId;
string strsql = "Insert Into " +
"detectioninfo(p_name,sample_name,channel,type,standard,sample_no,sites,submission_unit,test_operator,test_unit,test_time,User_Id)"
+ "values('" + p_name + "','" + sample_name + "'," + channel + ",'" + type + "','" + standard + "','" + sample_no + "','" + sites + "','" + submission_unit + "','" + test_operator + "','" + test_unit + "','" + test_time + "'," + User_Id + ")";
dbMySql.Open(databaseName);
dbMySql.ExcuteNonQuery(databaseName, strsql);
dbMySql.Close(databaseName);
break;
case 09:
//视频上传
svr.SendMessage(e.Client, 0, 0x000a, centercode);
break;
case 0x000e:
//远程状态和工作参数查询应答消息
//具体参数不明确
break;
default:
break;
}
//测试把收到的数据返回给客户端
//svr.SendText(e.Client, e.Client.Datagram);
//MessageBox.Show(message.ToString());
//svr.SendFile(this.textBox1.Text);
}
