/// <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 find_product_data() { //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='叶片回潮段' AND PLAN_DATE='" + pro_time_str + "' //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='叶片切丝段' AND PLAN_DATE='" + pro_time_str + "' //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='烘叶丝处理段(薄板)' AND PLAN_DATE='" + pro_time_str + "' //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='加香储丝段' AND PLAN_DATE='" + pro_time_str + "' //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE (TECH_NM='梗处理段' or TECH_NM='梗预处理段') AND PLAN_DATE='" + pro_time_str + "' //SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE (TECH_NM='切梗丝加料段' or TECH_NM='烘梗丝加香段') AND PLAN_DATE='" + pro_time_str + "' // SqlAccess.ExecuteQuery("delete from product_info"); ///get now time DateTime pro_time = new DateTime(); pro_time = DateTime.Now; string pro_time_str = pro_time.ToString("yyyy-MM-dd"); ///get data string[] product_result = new string[25]; List <string[]> product_result_array = new List <string[]>(); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='叶片回潮段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='叶片切丝段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='烘叶丝处理段(薄板)' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='加香储丝段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); ///product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE (TECH_NM='梗处理段' or TECH_NM='梗预处理段') AND PLAN_DATE='" + pro_time_str + "'");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='梗处理段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='梗预处理段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); //product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT * FROM [nymes].[VIEW_CUT_PLANS] WHERE (TECH_NM='切梗丝加料段' or TECH_NM='烘梗丝加香段') AND PLAN_DATE='" + pro_time_str + "'");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='切梗丝加料段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); product_result = Mes_Product_SqlAccess.ExecuteQuery("SELECT TOP 1 * FROM [nymes].[VIEW_CUT_PLANS] WHERE TECH_NM='烘梗丝加香段' AND PLAN_DATE='" + pro_time_str + "' order by ACT_ENDTIME desc");///nInvalid object name 'nymes.VIEW_CUT_PLANS' product_result_array.Add(product_result); string startTimeNode1 = ""; string endTimeNode1 = ""; ////set data int product_info_id = 0; foreach (String[] items in product_result_array) { for (int k = 0; k < 20; k++) { product_info[k] = " "; } product_info[0] = product_info_id.ToString(); product_info[1] = product_info_id++.ToString(); //Console.WriteLine(product_result.Count()); //Console.WriteLine(items.Length);//25 // Console.WriteLine(""); for (int i = 0; i < 25; i++) { // Console.Write(items[i]); switch (i) { case 0: //WO product_info[4] = items[i]; break; case 1: //LOT product_info[3] = items[i]; break; case 2: //PLAN_DATE break; case 3: //SHIFT_ID product_info[6] = items[i]; break; case 4: //TEAM_ID product_info[5] = items[i]; break; case 5: //MAT_ID interval_brand = items[i]; product_info[19] = items[i]; break; case 6: //MAT_NM InsertBrand(items[i]); product_info[2] = items[i]; break; case 7: //ROUTING_ID break; case 8: //ROUTING_NM break; case 9: //TECH_ID break; case 10: //TECH_NM'叶片回潮段 叶片切丝段 烘叶丝处理段(薄板) 加香储丝段 梗处理段 梗预处理段 切梗丝加料段 烘梗丝加香段 switch (items[i]) { case "真空回潮段": product_info[18] = "1"; break; case "叶片回潮段": product_info[18] = "2"; ///松散回潮机 jialiao yepian_huichao_realtime_string = interval_brand; yepian_jialiao_realtime_string = interval_brand; break; case "叶片切丝段": product_info[18] = "3"; /// jiaxiang break; case "烘叶丝处理段(薄板)": ///baoban qiliu chaoji product_info[18] = "4"; yeshi_baoban_realtime_string = interval_brand; yeshi_qiliu_realtime_string = interval_brand; yeshi_qiliucaoqihuicao_realtime_string = interval_brand; break; case "加香储丝段": /// product_info[18] = "5"; hunshi_jiaxiang_realtime_string = interval_brand; break; case "梗处理段": //// geng hui chao product_info[18] = "6"; //66 yangeng_huicao_realtime_string = interval_brand; break; case "梗预处理段": //// geng hui chao product_info[18] = "6"; yangeng_huicao_realtime_string = interval_brand; break; case "切梗丝加料段": ///gengsijialiaoji gengsi_jialiao_realtime_string = interval_brand; product_info[18] = "7"; break; case "烘梗丝加香段": ///hong gengsiji zheng ya geng product_info[18] = "7"; //77 honggengsi_realtime_string = interval_brand; gengsi_zhengyageng_realtime_string = interval_brand; break; } break; case 11: //QTY break; case 12: //SEQ break; case 13: //TEC_SEQ break; case 14: //STATE_ID break; case 15: //STATE_TIME break; case 16: //END_TIME break; case 17: //ACT_STARTIME product_info[7] = items[i]; if (items[i].IndexOf(":") == 12) { startTimeNode1 = items[i].Substring(items[i].IndexOf(" ") + 1, 1); } else { startTimeNode1 = items[i].Substring(items[i].IndexOf(" ") + 1, 2); } break; case 18: //ACT_ENDTIME product_info[8] = items[i]; //Console.WriteLine(items[i]); //Console.WriteLine(items[i].IndexOf(":")); if (items[i].IndexOf(":") == 12) { endTimeNode1 = items[i].Substring(items[i].IndexOf(" ") + 1, 1); } else { endTimeNode1 = items[i].Substring(items[i].IndexOf(" ") + 1, 2); } break; case 19: //IN_SILOS break; case 20: //INSLOS_NM product_info[13] = items[i]; break; case 21: //OUT_SILOS break; case 22: //OUT_SILOS_NM product_info[12] = items[i]; break; case 23: //IN_QTY product_info[14] = items[i]; break; case 24: //OUT_QTY product_info[11] = items[i]; break; } } product_info[10] = "小时"; product_info[15] = "公斤"; product_info[17] = "小时"; //Console.WriteLine(startTimeNode1); //Console.WriteLine(endTimeNode1); product_info[9] = (int.Parse(endTimeNode1) - int.Parse(startTimeNode1)).ToString(); product_info[16] = product_info[9]; ///因为局部变量的原因,提前写入数据库 setProductData(); } }