private void DisPatchEpdu()
{//根据APID分配EPDU
while (Data.AllThreadTag)
{
if (Data.EpduBuf_List.Count > 6)
{
int epdu_len = Data.EpduBuf_List[4] * 256 + Data.EpduBuf_List[5];
if (epdu_len < 1024)//避免出现异常情况时，由于epdu_len长度太长一直不处理
{
int epdu_apid = (int)((Data.EpduBuf_List[0] & 0x07) << 8) + (int)Data.EpduBuf_List[1];
string epdu_APID = "0x" + epdu_apid.ToString("x3");
bool NeedClearTag = true;//若List头位置不是合理的APID，则清空List
foreach (DataRow dr in Data.dtAPID.Rows)
{
if ((string)dr["APID"] == epdu_APID)
{
NeedClearTag = false;
break;
}
}
if (NeedClearTag)
{
MyLog.Error("不连续EPDU检测到，清空缓存");
lock (Data.EpduBuf_List)
{
Data.EpduBuf_List.Clear();
}
}
//////alter by cz
lock (Data.EpduBuf_List)
{
if (Data.EpduBuf_List.Count >= epdu_len + 7)
{
byte[] Epdu_Frame = new byte[epdu_len + 7];
Data.EpduBuf_List.CopyTo(0, Epdu_Frame, 0, epdu_len + 7);
Data.EpduBuf_List.RemoveRange(0, epdu_len + 7);
#region 处理EPDU
string Version = Convert.ToString(Epdu_Frame[0], 2).PadLeft(8, '0').Substring(0, 3);
string Type = Convert.ToString(Epdu_Frame[0], 2).PadLeft(8, '0').Substring(3, 1);
string DataTag = Convert.ToString(Epdu_Frame[0], 2).PadLeft(8, '0').Substring(4, 1);
int apid = (int)((Epdu_Frame[0] & 0x07) << 8) + (int)Epdu_Frame[1];
string APID = "0x" + apid.ToString("x3");
string DivTag = Convert.ToString(Epdu_Frame[2], 2).PadLeft(8, '0').Substring(0, 2);
int bagcount = (int)((Epdu_Frame[2] & 0x3f) << 8) + (int)Epdu_Frame[3];
string BagCount = "0x" + apid.ToString("x3");
string BagLen = "0x" + Epdu_Frame[4].ToString("x2") + Epdu_Frame[5].ToString("x2");
String DataStr = "";
for (int i = 6; i < epdu_len + 1; i++)
{
DataStr += Epdu_Frame[i].ToString("x2");
}
string timestr = string.Format("{0}-{1:D2}-{2:D2} {3:D2}:{4:D2}:{5:D2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
Data.sql.InsertValues("table_Epdu",
new string[] { "EPDU", timestr, Version, Type, DataTag, APID, DivTag, BagCount, BagLen, DataStr });
Trace.WriteLine("DealEpdu---APID-------" + APID);
foreach (DataRow dr in Data.dtAPID.Rows)///
{
if ((string)dr["APID"] == APID)
{
dr["数量"] = (int)dr["数量"] + 1;
foreach (Data.APID_Struct item in Data.ApidList)
{
if (item.apidName == (string)dr["名称"])
{
item.apidForm.DataQueue.Enqueue(Epdu_Frame);
}
}
}
}
#endregion 处理EPDU
}
}
Thread.Sleep(1);
}
else
{
lock (Data.EpduBuf_List)
{
Data.EpduBuf_List.Clear();
}
}
}
else
{
Thread.Sleep(1);
}
}
}
/// <summary>
/// 接受USRP的遥测数据
/// </summary>
/// <param name="ClientSocket"></param>
private void RecvFromClientUSRP(object ClientSocket)
{
Trace.WriteLine("RecvFromUSRP_telemetry!!");
Socket myClientSocket = (Socket)ClientSocket;
while (ServerOn_YC && myClientSocket.Connected)
{
try
{
byte[] RecvBufZK1 = new byte[2048];
int RecvNum = myClientSocket.Receive(RecvBufZK1);
if (RecvNum > 0)
{
String tempstr = "";
byte[] RecvBufToFile = new byte[RecvNum];
for (int i = 0; i < RecvNum; i++)
{
RecvBufToFile[i] = RecvBufZK1[i];
tempstr += RecvBufZK1[i].ToString("x2");
}
Trace.WriteLine(tempstr);
string timestr = string.Format("{0}-{1:D2}-{2:D2} {3:D2}:{4:D2}:{5:D2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
Data.TelemetryRealShowBox.BeginInvoke(
new Action(() => { Data.TelemetryRealShowBox.AppendText(timestr + "\n" + tempstr + "\n"); }));
//存储从USRP发来的遥测数据
SaveFile.DataQueue_out1.Enqueue(RecvBufToFile);
//数据库存储
IPEndPoint tmppoint = (IPEndPoint)myClientSocket.RemoteEndPoint;
String RemoteIpStr = tmppoint.Address.ToString();
if (RecvNum > 22)
{
MyLog.Info("收到遥测数据量：" + RecvNum.ToString());
try
{
deal_zk_data(RecvBufZK1, RecvNum, timestr, RemoteIpStr);
}
catch (Exception e)
{
Trace.WriteLine("RecvFromClientZK_YC--deal_zk_data Exception:" + e.Message);
}
Data.dtUSRP.Rows[0][1] = (int)Data.dtUSRP.Rows[0][1] + 1;
}
else
{
MyLog.Error("收到遥测数据帧长度异常：" + RecvNum.ToString());
}
}
else
{
Trace.WriteLine("收到数据少于等于0！");
break;
}
}
catch (Exception e)
{
Trace.WriteLine("RecvFromClientZK_YC Exception:" + e.Message);
if (myClientSocket.Connected)
{
myClientSocket.Shutdown(SocketShutdown.Both);
myClientSocket.Close();
}
ClientAPP.ClientUSRP_Telemetry.IsConnected = false;
break;
}
}
if (myClientSocket.Connected)
{
Trace.WriteLine("服务器主动关闭socket!");
myClientSocket.Shutdown(SocketShutdown.Both);
myClientSocket.Close();
}
ClientAPP.ClientUSRP_Telemetry.IsConnected = false;
Trace.WriteLine("leave Server YC!!");
Data.ServerConnectEvent2.Set();
}
void DealCRT_Off(ref Data.CRT_STRUCT myCRT)
{
myCRT.LedOff();
MyLog.Error("无法连接--" + myCRT.CRTName);
}
private void Fun_RecvFromCRT_Return(ref Data.CRT_STRUCT myCRT, ref ClientAPP.TCP_STRUCT Server_CRT)
{
Trace.WriteLine("++++++++++Entering" + myCRT.CRTName + "Fun_RecvFromCRT_Return!!");
while (Server_CRT.IsConnected)
{
try
{
byte[] RecvBufCRTa = new byte[1092];
int RecvNum = Server_CRT.sck.Receive(RecvBufCRTa);
if (RecvNum > 0)
{
//TempRecvBuf 本次收到的数据
byte[] TempRecvBuf = new byte[RecvNum];
Array.Copy(RecvBufCRTa, TempRecvBuf, RecvNum);
SaveFile.Lock_Dat3.EnterWriteLock();
SaveFile.DataQueue_out3.Enqueue(TempRecvBuf);
SaveFile.Lock_Dat3.ExitWriteLock();
String tempstr = "";
for (int i = 0; i < TempRecvBuf.Length; i++)
{
tempstr += TempRecvBuf[i].ToString("x2");
}
//Trace.WriteLine("Recvd:" + RecvNum.ToString() + ":" + tempstr);
//this.textBox_SCShow.BeginInvoke(
// new Action(() =>
// {
// if (textBox_SCShow.Lines.Count() > 10)
// textBox_SCShow.Clear();
// textBox_SCShow.AppendText(tempstr + "\n");
// }
// )
// );
try
{
Data.dtYC.Rows[0]["数量"] = (int)Data.dtYC.Rows[0]["数量"] + 1; //收到总数
}
catch (Exception ex)
{
MyLog.Error(ex.Message);
}
if (RecvNum > 68)
{
//YCBuf 本次收到的实际遥测数据
byte[] YCBuf = new byte[RecvNum - 68];
Array.Copy(RecvBufCRTa, 64, YCBuf, 0, RecvNum - 68);
SaveFile.Lock_Dat4.EnterWriteLock();
SaveFile.DataQueue_out4.Enqueue(YCBuf);
SaveFile.Lock_Dat4.ExitWriteLock();
String tempstr2 = "";
for (int i = 0; i < YCBuf.Length; i++)
{
tempstr2 += YCBuf[i].ToString("x2");
}
// Trace.WriteLine(tempstr2);
//ushort CRC = 0xffff;
//ushort genpoly = 0x1021;
//for (int i = 0; i < YCBuf.Length-2; i = i + 1)
//{
// CRC = Function.CRChware(YCBuf[i], genpoly, CRC);
//}
//// MyLog.Info("Calc 通道1 CRC = " + CRC.ToString("x4"));
//Trace.WriteLine("Calc 通道1 CRC = " + CRC.ToString("x4"));
}
}
else
{
Trace.WriteLine("收到数据少于等于0！");
break;
}
}
catch (Exception e)
{
Trace.WriteLine(e.Message);
break;
}
}
Trace.WriteLine("----------Leaving" + myCRT.CRTName + "Fun_RecvFromCRT_Return!!");
}
void DealCRT_On(ref Data.CRT_STRUCT myCRT)
{
myCRT.LedOn();
MyLog.Info("连接成功--" + myCRT.CRTName);
}
private void DealWithEPDU()
{
while (Data.AllThreadTag)
{
if (DataQueue.Count > 0)
{
byte[] Epdu = DataQueue.Dequeue();
//string timestr = string.Format("{0}-{1:D2}-{2:D2} {3:D2}:{4:D2}:{5:D2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
//string epdustr = null;
//for (int i = 0; i < Epdu.Length; i++)
//{
// epdustr += Epdu[i].ToString("x2");
//}
if ((Epdu.Length - 6) < TotalLen)
{
//MessageBox.Show(CurrentApidName + "收到EPDU长度错误，无法解析!!");
MyLog.Error("收到EPDU长度错误，无法解析!!");
}
else
{
string tempstr = "";//将EPDU转化为二进制string
for (int i = 6; i < Epdu.Length; i++)
{
tempstr += Convert.ToString(Epdu[i], 2).PadLeft(8, '0');
}
Trace.WriteLine(tempstr.Length);
string[] TempStringList = new string[dtAPid.Rows.Count + 1];
string timestr = string.Format("{0}-{1:D2}-{2:D2} {3:D2}:{4:D2}:{5:D2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TempStringList[0] = timestr;
string[] TempStringList2 = new string[dtAPid.Rows.Count + 1];
TempStringList2[0] = timestr;
for (int j = 0; j < dtAPid.Rows.Count; j++)
{
int len = int.Parse((string)dtAPid.Rows[j]["占位"]);
long t = Convert.ToInt64(tempstr.Substring(0, len), 2);
int padleft = int.Parse((string)dtAPid.Rows[j]["占位"]);
if (padleft == 8 || padleft == 16 || padleft == 32 || padleft == 48)
{
padleft = 2 * (padleft / 8);
}
else
{
padleft = 2 * (padleft / 8) + 2;
}
string initialvalue = "0x" + t.ToString("x").PadLeft(padleft, '0');
dtAPid.Rows[j]["值"] = initialvalue;
/////////////////////////////////////////////////////
string typestr = Data.GetConfigStr(Data.APIDconfigPath, CurrentApidName, (string)dtAPid.Rows[j]["名称"], "fmul");
string analystr = Data.GetAnalystr(typestr, initialvalue);
//////////////////////////////////////////////////////////////////
dtAPid.Rows[j]["解析值"] = analystr;
tempstr = tempstr.Substring(len, tempstr.Length - len);
TempStringList[j + 1] = (string)dtAPid.Rows[j]["值"];
TempStringList2[j + 1] = (string)dtAPid.Rows[j]["解析值"];
}
Data.sql.InsertValues("table_" + CurrentApidName + "_源码", TempStringList);
Data.sql.InsertValues("table_" + CurrentApidName + "_解析值", TempStringList2);
}
//int index = this.dataGridView_EPDU.Rows.Add();
//this.dataGridView_EPDU.Rows[index].Cells[0].Value = timestr;
//this.dataGridView_EPDU.Rows[index].Cells[1].Value = epdustr;
}
else
{
Thread.Sleep(500);
}
}
}
private void DealWithEPDU()
{
while (Data.AllThreadTag)
{
if (DataQueue.Count > 0)
{
byte[] Epdu = DataQueue.Dequeue();
try
{
if ((Epdu.Length - 6) < TotalLen)
{
MessageBox.Show(CurrentApidName + "收到EPDU长度错误，无法解析!!");
}
else
{
string tempstr = "";//将EPDU转化为二进制string
for (int i = 6; i < Epdu.Length; i++)
{
tempstr += Convert.ToString(Epdu[i], 2).PadLeft(8, '0');
}
Trace.WriteLine(tempstr.Length);
string[] TempStringList = new string[dtAPid.Rows.Count + 1];
string timestr = string.Format("{0}-{1:D2}-{2:D2} {3:D2}:{4:D2}:{5:D2}", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second);
TempStringList[0] = timestr;
for (int j = 0; j < dtAPid.Rows.Count; j++)
{
int len = int.Parse((string)dtAPid.Rows[j]["占位"]);
long t = Convert.ToInt64(tempstr.Substring(0, len), 2);
int padleft = int.Parse((string)dtAPid.Rows[j]["占位"]);
if (padleft == 8 || padleft == 16 || padleft == 32 || padleft == 48)
{
padleft = 2 * (padleft / 8);
}
else
{
padleft = 2 * (padleft / 8) + 2;
}
dtAPid.Rows[j]["值"] = "0x" + t.ToString("x").PadLeft(padleft, '0');
dtAPid.Rows[j]["解析值"] = "0x" + t.ToString("x").PadLeft(padleft, '0');
tempstr = tempstr.Substring(len, tempstr.Length - len);
TempStringList[j + 1] = (string)dtAPid.Rows[j]["值"];
}
Data.sql.InsertValues("table_" + CurrentApidName, TempStringList);
}
}
catch (Exception ex)
{
MyLog.Error("DealWithEPDU:" + ex.Message);
}
}
else
{
Thread.Sleep(100);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string TableName = "table_Telemetry";
switch (comboBox1.Text)
{
case "接收遥测VCDU":
TableName = "table_Telemetry";
break;
case "解析EPDU":
TableName = "table_Epdu";
break;
case "发送遥控":
TableName = "table_Telecmd";
break;
default:
TableName = comboBox1.Text;
break;
}
//select * from table_All where CreateTime >= '2018-03-23 17:07:19' and CreateTime < '2019-08-02 00:00:00'
string Str_Condition_time = "CreateTime >= '" + dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'"
+ "and CreateTime <= '" + dateTimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
string Str_Conditon1 = "";
if (textBox2.Text != null && textBox2.Text.Length >= 4)
{
string TypedStr = textBox2.Text;
string[] list = TypedStr.Split('=');
Str_Conditon1 = "and " + list[0] + " = " + "'" + list[1] + "'";
}
string Str_Conditon2 = "";
if (textBox3.Text != null && textBox3.Text.Length >= 4)
{
string TypedStr = textBox3.Text;
string[] list = TypedStr.Split('=');
Str_Conditon2 = "and " + list[0] + " = " + "'" + list[1] + "'";
}
try
{
SQLiteConnection dbConnection = new SQLiteConnection("data source=mydb.db");
string cmd = "Select * From " + TableName + " where "
+ Str_Condition_time + Str_Conditon1 + Str_Conditon2;
Trace.WriteLine(cmd);
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter(cmd, dbConnection);
DataTable mTable = new DataTable(); // Don't forget initialize!
mAdapter.Fill(mTable);
// 绑定数据到DataGridView
dataGridView1.DataSource = mTable;
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[dataGridView1.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[1].Width = 150;
}
catch (Exception ex)
{
//MessageBox.Show("输入的条件不符合格式，请重新输入！");
MyLog.Error("输入的条件不符合格式，请重新输入！");
MyLog.Error(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
string fileName = "";
string saveFileName = "";
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xlsx";
saveDialog.Filter = "Excel文件|*.xlsx";
saveDialog.FileName = fileName;
String Path = Program.GetStartupPath() + @"数据库导出\";
if (!Directory.Exists(Path))
{
Directory.CreateDirectory(Path);
}
saveDialog.InitialDirectory = Path;
saveDialog.ShowDialog();
saveFileName = saveDialog.FileName;
if (saveFileName.IndexOf(":") < 0)
{
return; //被点了取消
}
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
//MessageBox.Show("无法创建Excel对象，您的电脑可能未安装Excel");
MyLog.Error("无法创建Excel对象，您的电脑可能未安装Excel");
return;
}
Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook =
workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Worksheet worksheet =
(Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1]; //取得sheet1
//写入标题
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
worksheet.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;
}
//写入数值
for (int r = 0; r < dataGridView1.Rows.Count; r++)
{
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
worksheet.Cells[r + 2, i + 1] = dataGridView1.Rows[r].Cells[i].Value;
}
System.Windows.Forms.Application.DoEvents();
}
worksheet.Columns.EntireColumn.AutoFit();//列宽自适应
//MessageBox.Show(fileName + "资料保存成功", "提示", MessageBoxButtons.OK);
MyLog.Info(fileName + "资料保存成功");
if (saveFileName != "")
{
try
{
workbook.Saved = true;
workbook.SaveCopyAs(saveFileName); //fileSaved = true;
}
catch (Exception ex)
{//fileSaved = false;
//MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
MyLog.Error("导出文件时出错,文件可能正被打开！\n" + ex.Message);
}
}
xlApp.Quit();
GC.Collect();//强行销毁
}