/// <summary> /// start /// </summary> public Form1() { SqlAccess sql = new SqlAccess(); Mes_Device_SqlAccess MDsql = new Mes_Device_SqlAccess(); Mes_Product_SqlAccess MPsql = new Mes_Product_SqlAccess(); InitializeComponent(); init_stringArray_name(); //获取所有可检测项 GetAllCheckColumns(); System.Timers.Timer tmr = new System.Timers.Timer(5000); tmr.Elapsed += new ElapsedEventHandler(OtherTheard); tmr.AutoReset = true; tmr.Enabled = true; GC.KeepAlive(tmr);///定时执行 System.Timers.Timer Insert_Alarm_Log = new System.Timers.Timer(5000); Insert_Alarm_Log.Elapsed += new ElapsedEventHandler(Insert_Alarm_Log_Data); Insert_Alarm_Log.AutoReset = true; Insert_Alarm_Log.Enabled = true; GC.KeepAlive(Insert_Alarm_Log);///定时执行 ////MessageBox.Show("软件开启成功"); ////Mes_Device_SqlAccess MDsql = new Mes_Device_SqlAccess(); ////gengsi_jialiao_realtime[1] = MDsql.ExecuteQuery("SELECT * FROM DBO.Live WHERE TagName='" + gengsi_jialiao_realtime_datakey[0] + "'"); ////MDsql.close_sql(); ////Mes_Product_SqlAccess MPsql = new Mes_Product_SqlAccess(); ////Mes_Device_SqlAccess MDsql = new Mes_Device_SqlAccess(); ////SELECT * FROM DBO.Live WHERE TagName='JX_JXJD' ////SELECT * FROM spc.PPA_TAG_PARA ptp WHERE ptp.Para_NAME LIKE '%梗丝%' ////String[] MPds = MPsql.ExecuteQuery("SELECT * FROM [nymes].[VIEW_CUT_PLANS]"); ////DataTable MPdt = MPds.Tables[0]; ////DataRow MPdr = MPdt.Rows[0]; //// String result = MDsql.ExecuteQuery("SELECT * FROM DBO.Live WHERE TagName='GS_GZQSF'"); ////UpdateOldTime("201711091849"); ////UpdateOldTime("1"); label1.Text = "正在存储数据..."; //// label1.Text = result; }
/// <summary> /// 查询标准值 /// </summary> public void findStandardValue(string[] dataString, string[] keyString) { for (int i = 0; i < keyString.Length; i++) { dataString[i + 1] = ""; dataString[i + 1] = Mes_Device_SqlAccess.ExecuteQuery("SELECT * FROM DBO.Live WHERE TagName='" + keyString[i] + "_SET'"); if (dataString[i + 1].Length >= 20) { dataString[i + 1] = dataString[i + 1].Substring(0, 18); } } }