//建立xd300数据缓存
public Tool.XDXGInfo[] Createxd300Datas()
{
try
{
string sql = "SELECT [XgID],[XgName], [deviceAddress], [DTUregister], [IPAddress], [Remark], [cycle], [timeout], [retrytimes] FROM [v_xgstation]";
DataTable dt = Tool.DB.getDt(sql);
Tool.XDXGInfo[] baseList = new Tool.XDXGInfo[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
baseList[i]._XGInfo._XgID = int.Parse(dt.Rows[i]["XgID"].ToString());
baseList[i]._XGInfo._XgName = dt.Rows[i]["XgName"].ToString();
baseList[i]._XGInfo._Remark = dt.Rows[i]["Remark"].ToString();
baseList[i]._XGInfo._DTUregister = dt.Rows[i]["DTUregister"].ToString();
baseList[i]._XGInfo._IPAddress = dt.Rows[i]["IPAddress"].ToString();
baseList[i]._XGInfo._cycle = int.Parse(dt.Rows[i]["cycle"].ToString());
baseList[i]._XGInfo._deviceAddress = int.Parse(dt.Rows[i]["deviceAddress"].ToString());
baseList[i]._XGInfo._timeout = int.Parse(dt.Rows[i]["timeout"].ToString());
baseList[i]._XGInfo._retrytimes = int.Parse(dt.Rows[i]["retrytimes"].ToString());
baseList[i].state = true;
Tool.xd300 x = new Tool.xd300(baseList[i]._XGInfo._deviceAddress);
string sql2 = "SELECT [xglastdata_id], [DT], [XgName], [person], [XgID] FROM [v_xgreallast] where [XgID]=" + baseList[i]._XGInfo._XgID.ToString();
DataTable dt1 = Tool.DB.getDt(sql2);
if (dt1.Rows.Count > 0)
{
baseList[i]._XGDataNow._DT = dt1.Rows[0]["DT"].ToString();
baseList[i]._XGDataNow._person = dt1.Rows[0]["person"].ToString(); ;
baseList[i]._refDisplay = true;
}
baseList[i]._command = new Tool.XGCommandcyc[1];
baseList[i]._command[0]._cmd = x.Get_record_count();
baseList[i]._command[0]._onoff = true;
baseList[i]._commandonce = new Tool.XGCommandonce[5];
baseList[i]._commandonce[0]._cmd = x.Get_record_n(0);
baseList[i]._commandonce[1]._cmd = x.Get_record_clean_now();
baseList[i]._commandonce[2]._cmd = x.Get_record_clean();
baseList[i]._commandonce[3]._cmd = x.Set_date();
baseList[i]._commandonce[4]._cmd = x.Set_time();
for (int k = 0; k < baseList[i]._commandonce.Length; k++)
{
baseList[i]._commandonce[k]._onoff = false;
}
}
return baseList;
}
catch (Exception ex)
{
MessageBox.Show("建立数据缓存失败！请检查数据库连接！" + ex, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return null;
}
}
//校时
private void toolStripButton4_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow == null)
{
return;
}
for (int i = 0; i < SocketServer.main._XDXGInfoList.Length; i++)
{
if (SocketServer.main._XDXGInfoList[i]._XGInfo._XgID == Convert.ToInt32(dataGridView1["XgID", dataGridView1.CurrentRow.Index].Value))
{
Tool.xd300 x = new Tool.xd300(SocketServer.main._XDXGInfoList[i]._XGInfo._deviceAddress);
SocketServer.main._XDXGInfoList[i]._commandonce[3]._cmd = x.Set_date();
SocketServer.main._XDXGInfoList[i]._commandonce[3]._onoff = true;
SocketServer.main._XDXGInfoList[i]._commandonce[3]._cmd = x.Set_time();
SocketServer.main._XDXGInfoList[i]._commandonce[4]._onoff = true;
MessageBox.Show("成功添加校时任务！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}