//建立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); } } }