public static void SaveopcXML() { try { DateTime dt_value = DateTime.Now; string sCreateTime = dt_value.Year.ToString("000#") + dt_value.Month.ToString("0#") + dt_value.Day.ToString("0#") + dt_value.Hour.ToString("0#") + dt_value.Minute.ToString("0#") + dt_value.Second.ToString("0#"); int itemID = 167; string[] aTestData = ReadFiles.ReadInTestData(); string[] aTestType = ReadFiles.ReadInTestType(); string[] aTestStep = ReadFiles.ReadInTestStep(); string[] aTestOper = ReadFiles.ReadInTestOper(); string sAcType = " "; //for (int i = 0; i < aTestData.Length; i++) //{ // if(aTestType[i]!="Q"&& aTestType[i] != "5S"&& aTestType[i] != "E") // { // sAcType = "P"; // } // else // { // sAcType = aTestType[i]; // } // OdbcHelper.SQLExeQuery("INSERT INTO U_WIPPROCCONFITEM (FACTORY,ITEM_ID,ITEM_DESC,ACTIVITY_DESC,ACTIVITY_TYPE,USER_QUALIFICATION, CREATE_TIME,CREATE_USER_ID,UPDATE_TIME,UPDATE_USER_ID) " + // " VALUES ('CWEC','" + itemID + "',' ','" + aTestData[i].Trim() + "','" + sAcType.Trim() + "',' ','" + sCreateTime + "','ADMIN','" + sCreateTime + "','ADMIN')"); // itemID++; //} string sStep = " "; string sOper = " "; int index = -1; for (int i = 0; i < aTestType.Length; i++) { if (aTestType[i] == "1") { index++; } OdbcHelper.SQLExeQuery("INSERT INTO U_WIPPROCCONFSETITEMREL (FACTORY,SET_ID,ITEM_ID,OPER,STEP,SEQ_NUM,CRITICAL_FLAG, CREATE_TIME,CREATE_USER_ID,UPDATE_TIME,UPDATE_USER_ID) " + " VALUES ('CWEC','W6L34DFB','" + itemID + "',' ','" + aTestStep[index].Trim() + "'," + Convert.ToInt32(itemID) + ",'N','" + sCreateTime + "','ADMIN',' ',' ')"); itemID++; } //rawtohex() } catch (Exception e) { Console.WriteLine(e.Message); return; } }