private void button1_Click(object sender, EventArgs e)
{
byte[] buf = { 0X68, 0, 0, 0, 1, 0, 0, 0, 1, 0 };
//获得要发送文件的路径
string path = @"D:\HS\18032801\lasttime.xml";
using (FileStream fsRead = new FileStream(path, FileMode.Open, FileAccess.Read))
{
byte[] buffer = new byte[1024 * 1024 * 5];
int r = fsRead.Read(buffer, 0, buffer.Length);
byte[] copy = new byte[r];
List <byte> listSend = new List <byte>();
listSend.AddRange(buf);
listSend.Add((byte)(r & 0x00FF)); //低字节
listSend.Add((byte)(r >> 8)); //高字节
Array.Copy(buffer, copy, r);
listSend.AddRange(copy);
byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验
listSend.AddRange(CRC);
listSend.Add(0x16);
//将泛型集合转换为数组
byte[] newBuffer = listSend.ToArray();
//获得用户在下拉框中选中的IP地址
string ip = cboUser.SelectedItem.ToString();
lock (AsyncSocketSvr.AsyncSocketUserTokenList.UserEndPoint(ip))
{
AsyncSocketSvr.AsyncSocketUserTokenList.UserEndPoint(ip).Send(newBuffer, 0, newBuffer.Length, SocketFlags.None);
}
}
}
public override bool ProcessReceive(byte[] buffer, int offset, int count) //接收异步事件返回的数据，用于对数据进行缓存和分包
{
m_activeDT = DateTime.UtcNow;
List <byte> DataList = new List <byte>();
DataList.AddRange(buffer.Take(count));
bool result = true;
try
{
while (DataList.Count > 6)//(DataCount > sizeof(int))
{
if (DataList[0] == 0x68)
{
//按照长度分包
int packetLength = (DataList[10] + DataList[11] * 256); // AuxiliaryMethod.byte2ToInt(DataList.ToArray(), 10); //获取包长度
if (DataList.Count > packetLength + 14)
{
if (DataList[packetLength + 14] == 0x16)
{
byte[] CRC = AuxiliaryMethod.crc16(DataList.ToArray(), packetLength + 12); //CRC校验
if ((CRC[0] == DataList[packetLength + 12]) && (CRC[1] == DataList[packetLength + 13])) //如果CRC16校验正确，数据接收成功
{
result = ProcessPacket(DataList.Take(packetLength + 15).ToArray());
DataList.RemoveRange(0, packetLength + 15); //从缓存中清理
}
else
{
DataList.RemoveRange(0, packetLength + 15); //数据出错从缓存中清理
}
}
else
{
DataList.RemoveAt(0);
}
}
else
{
return(true);
}
}
else
{
DataList.RemoveAt(0);
}
}//while结束点
} //TRY
catch (Exception e)
{
//以后要注释掉
MessageBox.Show(e.ToString());
}
finally
{
GC.Collect();
}
return(true);
}
private void btnSend_Click(object sender, EventArgs e)
{
//string str = txtInput.Text;
// byte[] buffer = System.Text.Encoding.UTF8.GetBytes(str);
List <byte> listSend = new List <byte>();
byte[] buffer = { 0X68, 0, 0, 0, 1, 0, 0, 0, 1, 90, 3, 0, 1, 1, 1 };
//list.Add(0);
listSend.AddRange(buffer);
byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验
listSend.AddRange(CRC);
listSend.Add(0x16);
//将泛型集合转换为数组
byte[] newBuffer = listSend.ToArray();
//获得用户在下拉框中选中的IP地址
string ip = cboUser.SelectedItem.ToString();
lock (AsyncSocketSvr.AsyncSocketUserTokenList.UserEndPoint(ip))
{
AsyncSocketSvr.AsyncSocketUserTokenList.UserEndPoint(ip).Send(newBuffer);
}
}
public override bool ProcessPacket(byte[] buffer) //处理分完包后的数据，把命令和数据分开，并对命令进行解析
{
int deviceID = AuxiliaryMethod.byte4ToInt(buffer, 1);
//string gateWay = gate.ToString("d8");
//设备连入
if (buffer[9] == 0xFF)
{
m_asyncSocketUserToken.GateWayId = deviceID;
m_asyncSocketUserToken.EndPoints = m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint;
string sql = "UPDATE DeviceInfo SET connectDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "',ip='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
//sql = "UPDATE DeviceInfo SET ip='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
//DbHelperSQL.ExecuteSql(sql);
sql = "select * from DevicePing where DeviceID = " + deviceID.ToString();
//在DevicePing表中添加连接
if (DbHelperSQL.Execute(sql) == "")
{
sql = "INSERT INTO DevicePing VALUES ('" + deviceID.ToString() + "','" + m_asyncSocketUserToken.EndPoints.ToString() + "','" + DateTime.Now.ToString("yyyy -MM-dd HH:mm:ss.fff") + "') ";
// sql = "insert into DevicePing(DeviceID, ip, activeDT) select " + deviceID.ToString() + "," + m_asyncSocketUserToken.EndPoints.ToString() + ",(" + DateTime.Now.ToString("yyyy -MM-dd HH:mm:ss.fff") + ") from DevicePing where not exists(select * from DevicePing where DeviceID = "+ deviceID.ToString() + ")";
DbHelperSQL.ExecuteSql(sql);
}
return(true);
}
//设备心跳包
if (buffer[9] == 0xF0)
{
m_asyncSocketUserToken.EndPoints = m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint;
string sql = "UPDATE DevicePing SET activeDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "',ip='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
//sql = "UPDATE DevicePing SET ip='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
//DbHelperSQL.ExecuteSql(sql);
return(true);
}
//发送消息成功回执信息
if (buffer[9] == 0x0F)
{
int sendDate = (buffer[10] + buffer[11] * 256);
string sendtime = Encoding.Default.GetString(buffer, 12, sendDate);
string sql = "UPDATE HistSendTable SET SendResult='Send Success!' WHERE SendTime = '" + sendtime.Trim() + "' ";
DbHelperSQL.ExecuteSql(sql);
return(true);
}
//数据上传操作
else
{
// 创建目录时如果目录已存在，则不会重新创建目录，且不会报错。创建目录时会自动创建路径中各级不存在的目录。
//通过Path类的Combine方法可以合并路径
string activeDir = @"D:\HS";
string newPath = Path.Combine(activeDir, deviceID.ToString());
Directory.CreateDirectory(newPath);
#region 数据
string sql = "UPDATE DeviceInfo SET activeDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
//string cmd = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
//string path = DbHelperSQL.Execute(cmd).Trim();
//switch (buffer[9])
//{
// case 0x5A:
// newPath = Path.Combine(newPath, "name.xml");
// break;
// case 0:
newPath = Path.Combine(newPath, "lasttime.xml");
// break;
// case 1:
// newPath = Path.Combine(newPath, "mode1.xml");
// break;
// case 2:
// newPath = Path.Combine(newPath, "mode2.xml");
// break;
// case 3:
// newPath = Path.Combine(newPath, "mode3.xml");
// break;
// case 4:
// newPath = Path.Combine(newPath, "mode4.xml");
// break;
// case 5:
// newPath = Path.Combine(newPath, "mode5.xml");
// break;
// case 6:
// newPath = Path.Combine(newPath, "mode6.xml");
// break;
// case 7:
// newPath = Path.Combine(newPath, "mode7.xml");
// break;
// case 8:
// newPath = Path.Combine(newPath, "mode8.xml");
// break;
// case 9:
// newPath = Path.Combine(newPath, "mode9.xml");
// break;
// case 10:
// newPath = Path.Combine(newPath, "mode10.xml");
// break;
// case 11:
// newPath = Path.Combine(newPath, "mode11.xml");
// break;
// case 12:
// newPath = Path.Combine(newPath, "mode12.xml");
// break;
// case 13:
// newPath = Path.Combine(newPath, "mode13.xml");
// break;
// case 14:
// newPath = Path.Combine(newPath, "mode14.xml");
// break;
// case 15:
// newPath = Path.Combine(newPath, "mode15.xml");
// break;
// case 16:
// newPath = Path.Combine(newPath, "mode16.xml");
// break;
// case 17:
// newPath = Path.Combine(newPath, "mode17.xml");
// break;
// case 18:
// newPath = Path.Combine(newPath, "mode18.xml");
// break;
// case 19:
// newPath = Path.Combine(newPath, "mode19.xml");
// break;
// case 20:
// newPath = Path.Combine(newPath, "mode20.xml");
// break;
// case 21:
// newPath = Path.Combine(newPath, "mode21.xml");
// break;
// case 22:
// newPath = Path.Combine(newPath, "mode22.xml");
// break;
// case 23:
// newPath = Path.Combine(newPath, "mode23.xml");
// break;
// case 24:
// newPath = Path.Combine(newPath, "mode24.xml");
// break;
// default:
// break;
//}
using (FileStream fsWrite = new FileStream(newPath, FileMode.OpenOrCreate, FileAccess.Write))
{
fsWrite.Write(buffer, 12, buffer.Length - 15); //需要修改
}
return(true);
#endregion
}
}
//需要用redis存储网关编号和对应的IP地址，由于没有心跳包注册信息实时数据之分，所以在数据帧中直接解析出来的网管编号和对应的IP地址直接写入
public virtual bool ProcessPacket(byte[] buffer) //处理分完包后的数据，把命令和数据分开，并对命令进行解析
{
int deviceID = AuxiliaryMethod.byte4ToInt(buffer, 1);
//string gateWay = gate.ToString("d8");
if (buffer[9] == 0xFF)
{
m_asyncSocketUserToken.GateWayId = deviceID;
m_asyncSocketUserToken.EndPoints = m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint;
string sql = "UPDATE DeviceInfo SET connectDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
sql = "UPDATE DeviceInfo SET [ip]='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
sql = "select * from DevicePing where DeviceID = " + deviceID.ToString();
//在DevicePing表中添加连接
if (DbHelperSQL.Execute(sql) == "")
{
sql = "INSERT INTO DevicePing VALUES ('" + deviceID.ToString() + "','" + m_asyncSocketUserToken.EndPoints.ToString() + "','" + DateTime.Now.ToString("yyyy -MM-dd HH:mm:ss.fff") + "') ";
// sql = "insert into DevicePing(DeviceID, ip, activeDT) select " + deviceID.ToString() + "," + m_asyncSocketUserToken.EndPoints.ToString() + ",(" + DateTime.Now.ToString("yyyy -MM-dd HH:mm:ss.fff") + ") from DevicePing where not exists(select * from DevicePing where DeviceID = "+ deviceID.ToString() + ")";
DbHelperSQL.ExecuteSql(sql);
}
return(true);
}
if (buffer[9] == 0xF0)
{
m_asyncSocketUserToken.EndPoints = m_asyncSocketUserToken.ConnectSocket.RemoteEndPoint;
string sql = "UPDATE DevicePing SET activeDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
sql = "UPDATE DevicePing SET ip='" + m_asyncSocketUserToken.EndPoints.ToString() + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
return(true);
}
else
{
// 创建目录时如果目录已存在，则不会重新创建目录，且不会报错。创建目录时会自动创建路径中各级不存在的目录。
//通过Path类的Combine方法可以合并路径
string activeDir = @"D:\HS";
string newPath = Path.Combine(activeDir, deviceID.ToString());
Directory.CreateDirectory(newPath);
#region 数据
string sql = "UPDATE DeviceInfo SET activeDT='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' WHERE DeviceID = '" + deviceID + "' ";
DbHelperSQL.ExecuteSql(sql);
//string cmd = "select pathName from DeviceInfo where DeviceID='" + deviceID + "'";
//string path = DbHelperSQL.Execute(cmd).Trim();
switch (buffer[9])
{
case 0x5A:
newPath = Path.Combine(newPath, "name.xml");
break;
case 0:
newPath = Path.Combine(newPath, "lasttime.xml");
break;
case 1:
newPath = Path.Combine(newPath, "mode1.xml");
break;
case 2:
newPath = Path.Combine(newPath, "mode2.xml");
break;
case 3:
newPath = Path.Combine(newPath, "mode3.xml");
break;
case 4:
newPath = Path.Combine(newPath, "mode4.xml");
break;
case 5:
newPath = Path.Combine(newPath, "mode5.xml");
break;
case 6:
newPath = Path.Combine(newPath, "mode6.xml");
break;
case 7:
newPath = Path.Combine(newPath, "mode7.xml");
break;
case 8:
newPath = Path.Combine(newPath, "mode8.xml");
break;
case 9:
newPath = Path.Combine(newPath, "mode9.xml");
break;
case 10:
newPath = Path.Combine(newPath, "mode10.xml");
break;
case 11:
newPath = Path.Combine(newPath, "mode11.xml");
break;
case 12:
newPath = Path.Combine(newPath, "mode12.xml");
break;
case 13:
newPath = Path.Combine(newPath, "mode13.xml");
break;
case 14:
newPath = Path.Combine(newPath, "mode14.xml");
break;
case 15:
newPath = Path.Combine(newPath, "mode15.xml");
break;
case 16:
newPath = Path.Combine(newPath, "mode16.xml");
break;
case 17:
newPath = Path.Combine(newPath, "mode17.xml");
break;
case 18:
newPath = Path.Combine(newPath, "mode18.xml");
break;
case 19:
newPath = Path.Combine(newPath, "mode19.xml");
break;
case 20:
newPath = Path.Combine(newPath, "mode20.xml");
break;
case 21:
newPath = Path.Combine(newPath, "mode21.xml");
break;
case 22:
newPath = Path.Combine(newPath, "mode22.xml");
break;
case 23:
newPath = Path.Combine(newPath, "mode23.xml");
break;
case 24:
newPath = Path.Combine(newPath, "mode24.xml");
break;
default:
break;
}
using (FileStream fsWrite = new FileStream(newPath, FileMode.OpenOrCreate, FileAccess.Write))
{
fsWrite.Write(buffer, 12, buffer.Length - 15); //需要修改
}
return(true);
#endregion
}
//if (buffer[9] == 0x5A)
//{
// #region 接收lasttime.xml文件
// int gatewayId = AuxiliaryMethod.byte4ToInt(buffer, 1);
// //m_asyncSocketServer.Redis.HashSet<string>(gatewayId.ToString(), "lasttime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //当前心跳时间
// //m_asyncSocketServer.Redis.HashIncrement(gatewayId.ToString(), "heartbeat", 1);
// //lock (m_asyncSocketUserToken)
// //{
// // m_asyncSocketUserToken.ConnectSocket.Send(buffer);
// //}
// path = @"C:\Users\LKY\Desktop\lasttime.xml";
// using (FileStream fsWrite = new FileStream(path, FileMode.OpenOrCreate, FileAccess.Write))
// {
// fsWrite.Write(buffer, 12, buffer.Length-15); //需要修改
// }
// return true;
// #endregion
//}
//else if (buffer[9] == 0xF0)
//{
// #region //注册信息
// return true;
// #endregion
//}
//else if (buffer[9] == 0x50)
//{
// #region //实时数据
// int[] data = new int[10000];
// int[,] allData = new int[21, 200];
// for (int i = 0; i < 3250; i++)
// {
// data[i] = BitConverter.ToInt16(buffer, 2 * i + 12);
// }
// for (int i = 0; i < 50; i++)
// {
// allData[0, i] = data[i];
// }
// string sql = "UPDATE zhuban SET [dz1]= " + allData[0, 0] + " ,[dz2]=" + allData[0, 1] + " ,[dz3]=" + allData[0, 2] + " ,[dz4]=" + allData[0, 3] + " ,[dz5]= " + allData[0, 4] + " ,[dz6]= " + allData[0, 5] + " ,[dz7]= " + allData[0, 6] + " ,[dz8]= " + allData[0, 7] + " ,[dz9]= "
// + allData[0, 8] + ",[dz10]= " + allData[0, 9] + " ,[dz11] = " + allData[0, 10] + ",[dz12] = " + allData[0, 11] + ",[dz13] = " + allData[0, 12] + ",[dz14] = " + allData[0, 13] + ",[dz15] = " + allData[0, 14] + ",[dz16] = " + allData[0, 15] + ",[dz17] = "
// + allData[0, 16] + ",[dz18] = " + allData[0, 17] + " ,[dz19] = " + allData[0, 18] + ",[dz20] = " + allData[0, 19] + ",[dz21] = " + allData[0, 20] + ",[dz22] = " + allData[0, 21] + ",[dz23] = " + allData[0, 22] + ",[dz24] = " + allData[0, 23] + ",[dz25] = "
// + allData[0, 24] + ",[dz26] = " + allData[0, 25] + " ,[dz27] = " + allData[0, 26] + ",[dz28] = " + allData[0, 27] + ",[dz29] = " + allData[0, 28] + ",[dz30] = " + allData[0, 29] + ",[dz31] = " + allData[0, 30] + ",[dz32] = " + allData[0, 31] + ",[dz33] = "
// + allData[0, 32] + ",[dz34] = " + allData[0, 33] + " ,[dz35] = " + allData[0, 34] + ",[dz36] = " + allData[0, 35] + ",[dz37] = " + allData[0, 36] + ",[dz38] = " + allData[0, 37] + ",[dz39] = " + allData[0, 38] + ",[dz40] = " + allData[0, 39] + ",[dz41] = "
// + allData[0, 40] + ",[dz42] = " + allData[0, 41] + ",[dz43] = " + allData[0, 42] + ",[dz44] = " + allData[0, 43] + ",[dz45] = " + allData[0, 44] + ",[dz46] = " + allData[0, 45] + ",[dz47] = " + allData[0, 46] + ",[dz48] = " + allData[0, 47] + ",[dz49] = " + allData[0, 48] + ",[dz50] = " + allData[0, 49] + " WHERE wgbh =" + gateWay + " ";
// DbHelperSQL.ExecuteSql(sql);
// for (int i = 0; i < 20; i++)
// {
// for (int j = 0; j < 160; j++)
// {
// allData[i + 1, j] = data[50 + i * 160 + j]; //allData[1,0]-allData[1,149]对应的是1-150地址位
// }
// string xg = "xiangji" + (i + 1);
// string up_sql = "UPDATE " + xg + " SET [dz1]= " + allData[i + 1, 0] + " ,[dz4]=" + allData[i + 1, 3] + " ,[dz5]=" + allData[i + 1, 4] + " ,[dz8]=" + allData[i + 1, 7] + " ,[dz9]= " + allData[i + 1, 8] + " ,[dz10]= " + allData[i + 1, 9] + " ,[dz11]= " + allData[i + 1, 10] + " ,[dz12]= " + allData[i + 1, 11] + " ,[dz13]= "
// + allData[i + 1, 12] + ",[dz19]= " + allData[i + 1, 18] + " ,[dz20] = " + allData[i + 1, 19] + ",[dz21] = " + allData[i + 1, 20] + ",[dz22] = " + allData[i + 1, 21] + ",[dz23] = " + allData[i + 1, 22] + ",[dz25] = " + allData[i + 1, 24] + ",[dz26] = " + allData[i + 1, 25] + ",[dz27] = "
// + allData[i + 1, 26] + ",[dz28] = " + allData[i + 1, 27] + " ,[dz29] = " + allData[i + 1, 28] + ",[dz30] = " + allData[i + 1, 29] + ",[dz31] = " + allData[i + 1, 30] + ",[dz32] = " + allData[i + 1, 31] + ",[dz33] = " + allData[i + 1, 32] + ",[dz34] = " + allData[i + 1, 33] + ",[dz35] = "
// + allData[i + 1, 34] + ",[dz36] = " + allData[i + 1, 35] + " ,[dz37] = " + allData[i + 1, 36] + ",[dz38] = " + allData[i + 1, 37] + ",[dz39] = " + allData[i + 1, 38] + ",[dz40] = " + allData[i + 1, 39] + ",[dz41] = " + allData[i + 1, 40] + ",[dz42] = " + allData[i + 1, 41] + ",[dz43] = "
// + allData[i + 1, 42] + ",[dz44] = " + allData[i + 1, 43] + " ,[dz45] = " + allData[i + 1, 44] + ",[dz46] = " + allData[i + 1, 45] + ",[dz47] = " + allData[i + 1, 46] + ",[dz48] = " + allData[i + 1, 47] + ",[dz49] = " + allData[i + 1, 48] + ",[dz50] = " + allData[i + 1, 49] + ",[dz51] = "
// + allData[i + 1, 50] + ",[dz52] = " + allData[i + 1, 51] + " ,[dz53] = " + allData[i + 1, 52] + ",[dz54] = " + allData[i + 1, 53] + ",[dz55] = " + allData[i + 1, 54] + ",[dz56] = " + allData[i + 1, 55] + ",[dz57] = " + allData[i + 1, 56] + ",[dz58] = " + allData[i + 1, 57] + ",[dz59] = "
// + allData[i + 1, 58] + ",[dz60] = " + allData[i + 1, 59] + " ,[dz61] = " + allData[i + 1, 60] + ",[dz62] = " + allData[i + 1, 61] + ",[dz63] = " + allData[i + 1, 62] + ",[dz64] = " + allData[i + 1, 63] + ",[dz65] = " + allData[i + 1, 64] + ",[dz66] = " + allData[i + 1, 65] + ",[dz67] = "
// + allData[i + 1, 66] + ",[dz68] = " + allData[i + 1, 67] + " ,[dz69] = " + allData[i + 1, 68] + ",[dz70] = " + allData[i + 1, 69] + ",[dz71] = " + allData[i + 1, 70] + ",[dz72] = " + allData[i + 1, 71] + ",[dz73] = " + allData[i + 1, 72] + ",[dz74] = " + allData[i + 1, 73] + ",[dz75] = "
// + allData[i + 1, 74] + ",[dz77] = " + allData[i + 1, 76] + " ,[dz78] = " + allData[i + 1, 77] + ",[dz79] = " + allData[i + 1, 78] + ",[dz81] = " + allData[i + 1, 80] + ",[dz82] = " + allData[i + 1, 81] + ",[dz83] = " + allData[i + 1, 82] + ",[dz84] = " + allData[i + 1, 83] + ",[dz85] = "
// + allData[i + 1, 84] + ",[dz86] = " + allData[i + 1, 85] + " ,[dz87] = " + allData[i + 1, 86] + ",[dz88] = " + allData[i + 1, 87] + ",[dz89] = " + allData[i + 1, 88] + ",[dz90] = " + allData[i + 1, 89] + ",[dz91] = " + allData[i + 1, 90] + ",[dz92] = " + allData[i + 1, 91] + " ,[dz93] = "
// + allData[i + 1, 92] + ",[dz94] = " + allData[i + 1, 93] + " ,[dz95] = " + allData[i + 1, 94] + ",[dz96] = " + allData[i + 1, 95] + ",[dz97] = " + allData[i + 1, 96] + ",[dz98] = " + allData[i + 1, 97] + ",[dz99] = " + allData[i + 1, 98] + ",[dz100] = " + allData[i + 1, 99] + ",[dz102] = "
// + allData[i + 1, 101] + ",[dz103] = " + allData[i + 1, 102] + ",[dz104] = " + allData[i + 1, 103] + ",[dz105] = " + allData[i + 1, 104] + ",[dz106] = " + allData[i + 1, 105] + ",[dz113] = " + allData[i + 1, 112] + ",[dz114] = " + allData[i + 1, 113] + ",[dz115] = " + allData[i + 1, 114] + ",[dz121] = "
// + allData[i + 1, 120] + ",[dz350] = " + allData[i + 1, 150] + ",[dz351] = " + allData[i + 1, 151] + ",[dz352] = " + allData[i + 1, 152] + ",[dz353] = " + allData[i + 1, 153] + ",[dz354] = " + allData[i + 1, 154] + ",[dz355] = " + allData[i + 1, 155] + ",[dz356] = " + allData[i + 1, 156] + ",[dz357] = "
// + allData[i + 1, 157] + ",[dz358] = " + allData[i + 1, 158] + " WHERE wgbh =" + gateWay + " ";
// DbHelperSQL.ExecuteSql(up_sql);
// }
// return true;
// #endregion
//}
}
public bool SendPacket(string str)
{
#region 发送函数
//Web发送的命令格式为deviceID-文件编号
string[] sArray = str.Split('-');
int device_ID = int.Parse(sArray[0]);
int fileCode = int.Parse(sArray[1]);
string cmd = "select pathName from DeviceInfo where DeviceID='" + device_ID + "'";//这一步可以不用，直接用变量加路径
string path = DbHelperSQL.Execute(cmd).Trim();
//for (int i = 99; i <= 115; i++)
//{
string newPath = "";
//switch (fileCode)
//{
// case 0x5A:
// newPath = Path.Combine(path, "name.xml");
// break;
// case 0:
newPath = Path.Combine(path, "tmp.xml");
// break;
// case 1:
// newPath = Path.Combine(path, "mode1.xml");
// break;
// case 2:
// newPath = Path.Combine(path, "mode2.xml");
// break;
// case 3:
// newPath = Path.Combine(path, "mode3.xml");
// break;
// case 4:
// newPath = Path.Combine(path, "mode4.xml");
// break;
// case 5:
// newPath = Path.Combine(path, "mode5.xml");
// break;
// case 6:
// newPath = Path.Combine(path, "mode6.xml");
// break;
// case 7:
// newPath = Path.Combine(path, "mode7.xml");
// break;
// case 8:
// newPath = Path.Combine(path, "mode8.xml");
// break;
// case 9:
// newPath = Path.Combine(path, "mode9.xml");
// break;
// case 10:
// newPath = Path.Combine(path, "mode10.xml");
// break;
// case 11:
// newPath = Path.Combine(path, "mode11.xml");
// break;
// case 12:
// newPath = Path.Combine(path, "mode12.xml");
// break;
// case 13:
// newPath = Path.Combine(path, "mode13.xml");
// break;
// case 14:
// newPath = Path.Combine(path, "mode14.xml");
// break;
// case 15:
// newPath = Path.Combine(path, "mode15.xml");
// break;
// case 16:
// newPath = Path.Combine(path, "mode16.xml");
// break;
// case 17:
// newPath = Path.Combine(path, "mode17.xml");
// break;
// case 18:
// newPath = Path.Combine(path, "mode18.xml");
// break;
// case 19:
// newPath = Path.Combine(path, "mode19.xml");
// break;
// case 20:
// newPath = Path.Combine(path, "mode20.xml");
// break;
// case 21:
// newPath = Path.Combine(path, "mode21.xml");
// break;
// case 22:
// newPath = Path.Combine(path, "mode22.xml");
// break;
// case 23:
// newPath = Path.Combine(path, "mode23.xml");
// break;
// case 24:
// newPath = Path.Combine(path, "mode24.xml");
// break;
// default:
// break;
//}
byte[] buf = { 0X68, 0, 0, 0, 0, 0, 0, 0, 0, (byte)fileCode };
using (FileStream fsRead = new FileStream(newPath, FileMode.Open, FileAccess.Read))
{
byte[] bf = new byte[1024 * 100];
int r = fsRead.Read(bf, 0, bf.Length);
byte[] copy = new byte[r];
List <byte> listSend = new List <byte>();
listSend.AddRange(buf);
listSend.Add((byte)(r & 0x00FF)); //低字节
listSend.Add((byte)(r >> 8)); //高字节
Array.Copy(bf, copy, r);
listSend.AddRange(copy);
byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验
listSend.AddRange(CRC);
listSend.Add(0x16);
AsyncSocketUserToken UserToken = m_asyncSocketServer.AsyncSocketUserTokenList.UseKey(device_ID);
lock (UserToken)
{
UserToken.ConnectSocket.Send(listSend.ToArray());
// UserToken.SendEventArgs.ConnectSocket.Send(listSend.ToArray());
}
listSend.Clear();
}
//}
string m_message = "send Success";
m_asyncSocketUserToken.ConnectSocket.Send(PackData(m_message).ToArray());
Thread.Sleep(20);
return(true);
#endregion
}
public void SendThreadStart()
{
DataTable dt = new DataTable();
string hs_sql, cmd, path, newPath;
int device_ID;
byte[] buf = { 0X68, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
while (true)
{
#region
//if (m_asyncSocketServer.Redis.ListLength("commands") > 0)
//{
// #region
// try
// {
// string commandStr = m_asyncSocketServer.Redis.ListRightPop<string>("commands");
// SendOption sendOption = JsonConvert.DeserializeObject<SendOption>(commandStr);
// int gateWay = Convert.ToInt32(sendOption.Gateway);
// if (m_asyncSocketServer.AsyncSocketUserTokenList.ContainKey(gateWay))
// {
// byte[] gateway_number = AuxiliaryMethod.intTo4Bytes(gateWay);
// byte[] devices_number = AuxiliaryMethod.intTo4Bytes(Convert.ToInt32(sendOption.Devices));
// byte[] commandType = AuxiliaryMethod.StringToBytes(sendOption.Order);
// //string str = sendOption.Command;
// byte[] commandvalues = AuxiliaryMethod.StringToBytes(sendOption.Command);
// if (commandvalues.Length < 9)
// {
// byte[] dataLength = { 0, 8 };
// byte startFrame = 0x68; //拼凑帧头
// byte endFrame = 0x16; //帧尾
// listSend.Add(startFrame); //全部添加listSend
// listSend.AddRange(gateway_number);
// listSend.AddRange(devices_number);
// listSend.AddRange(commandType);
// listSend.AddRange(dataLength);
// listSend.AddRange(commandvalues);
// byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验,
// listSend.AddRange(CRC); //将校验数据添加listSend
// listSend.Add(endFrame);
// }
// else
// {
// byte[] dataLength = { 0, 0x0A };
// byte startFrame = 0x68; //拼凑帧头
// byte endFrame = 0x16; //帧尾
// listSend.Add(startFrame); //全部添加listSend
// listSend.AddRange(gateway_number);
// listSend.AddRange(devices_number);
// listSend.AddRange(commandType);
// listSend.AddRange(dataLength);
// listSend.AddRange(commandvalues);
// byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验,
// listSend.AddRange(CRC); //将校验数据添加listSend
// listSend.Add(endFrame);
// }
// #endregion
// AsyncSocketUserToken UserToken = m_asyncSocketServer.AsyncSocketUserTokenList.UseKey(gateWay);
// lock (UserToken)
// {
// UserToken.ConnectSocket.Send(listSend.ToArray());
// }
// listSend.Clear();
// Thread.Sleep(50);
// }
// }
// catch
// {
// }
//}
//else
//{
// Thread.Sleep(50);
//}
#endregion
hs_sql = "select * from SendTable";
dt = DbHelperSQL.OpenTable(hs_sql);
if (dt.Rows.Count > 0)
{
#region
hs_sql = "Truncate table SendTable";//清除表中所有行，保留表结构、与delete类似比delete速度快,而且效率高，使用的系统和事务日志资源少
DbHelperSQL.ExecuteSql(hs_sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
device_ID = Convert.ToInt32(dt.Rows[i][2]);
cmd = "select pathName from DeviceInfo where DeviceID='" + device_ID + "'";//这一步可以不用，直接用变量加路径
path = DbHelperSQL.Execute(cmd).Trim();
newPath = Path.Combine(path, "tmp.xml");
using (FileStream fsRead = new FileStream(newPath, FileMode.Open, FileAccess.Read))
{
byte[] bf = new byte[1024 * 200];//声明一个数组存储xml文件数据最大200k
int r = fsRead.Read(bf, 0, bf.Length);
byte[] copy = new byte[r];
List <byte> listSend = new List <byte>();
listSend.AddRange(buf);
listSend.Add((byte)(r & 0x00FF)); //低字节
listSend.Add((byte)(r >> 8)); //高字节
Array.Copy(bf, copy, r);
listSend.AddRange(copy);
byte[] CRC = AuxiliaryMethod.crc16(listSend.ToArray(), listSend.Count);//调用校验
listSend.AddRange(CRC);
listSend.Add(0x16);
AsyncSocketUserToken UserToken = m_asyncSocketServer.AsyncSocketUserTokenList.UseKey(device_ID);
lock (UserToken)
{
UserToken.ConnectSocket.Send(listSend.ToArray());
}
listSend.Clear();
//hs_sql = "UPDATE HistSendTable SET SendResult='Send Success!' WHERE SendTime = '" + dt.Rows[i][3].ToString().Trim() + "' ";
//DbHelperSQL.ExecuteSql(hs_sql);
}
}
catch (Exception e)
{
hs_sql = "UPDATE HistSendTable SET SendResult='" + e.ToString() + "' WHERE SendTime = '" + dt.Rows[i][3].ToString().Trim() + "' ";
DbHelperSQL.ExecuteSql(hs_sql);
}
#endregion
}
}
else
{
Thread.Sleep(50);
}
}
}
