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;
}
}