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