public string sfc_getInsertSQLSTR(int t, _SQL_DATA d)
{
List <string> arr1 = new List <string>();
List <string> arr2 = new List <string>();
sfc_getSQLSTR(t, d, ref arr1, ref arr2);
return(OraDB.getInsertString(arrTableName[t], arr1.ToArray(), arr2.ToArray()));
}
public string sfc_getInsertSQLSTR(string strTable, _SQL_DATA d)
{
int i = 0;
for (; i < arrTableName.Length; i++)
{
if (strTable.ToUpper().Trim() == arrTableName[i].ToUpper().Trim())
{
break;
}
}
return(sfc_getInsertSQLSTR(i, d));
}
public void sfc_getSQLSTR(int t, _SQL_DATA d, ref List <string> arrField, ref List <string> arrValue)
{
string strIP = sfc_getLocalIP();
/*strTable=arrTableName[t];*/
//长字符串换行前需加上@,但是会影响插入
switch (t)
{
case 0:
arrField.AddRange(new string[] { "ICTNO", "PARTNUM", "WORKNO", "LINEID", "OPERTOR", "BARCODE", "TRESULT",
"TESTDATE", "TESTTIME", "ICT01", "ICT02", "ICT03", "ICT04", "ICT05", "ICT06",
"ICT07", "ICT08", "ICT09", "ICT10", "SDATE", "STIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strFix, 19),
getSubStr(d.strPart, 19),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 19),
getSubStr(d.strWork, 19),
getSubStr(d.strBarcode, 49),
getSubStr(d.strResult, 19),
d.strDate,
d.strTime,
getSubStr(d.strInfo, 199),
getSubStr(d.strVal01, 199),
getSubStr(d.strVal02, 19),
getSubStr(d.strVal03, 19),
getSubStr(d.strVal04, 19),
getSubStr(d.strVal05, 19),
getSubStr(d.strVal06, 19),
strIP,
getSubStr(d.strVal07, 19),
getSubStr(d.strVal08, 19),
d.strDate,
d.strTime,
"" });
/*strTable = "ICT_DATA";*/
break;
case 1:
arrField.AddRange(new string[] { "MACID", "PARTNUM", "WORKNO", "LINEID", "OPERTOR", "BARCODE", "TRESULT",
"TESTDATE", "TESTTIME", "UT01", "UT02", "UT03", "UT04", "UT05", "UT06", "UT07",
"UT08", "UT09", "UT10", "SDATE", "STIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strFix, 19),
getSubStr(d.strPart, 19),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 19),
getSubStr(d.strWork, 19),
getSubStr(d.strBarcode, 49),
d.strResult,
d.strDate,
d.strTime,
getSubStr(d.strInfo, 199),
getSubStr(d.strVal01, 199),
getSubStr(d.strVal02, 19),
getSubStr(d.strVal03, 19),
getSubStr(d.strVal04, 19),
getSubStr(d.strVal05, 19),
getSubStr(d.strVal06, 19),
strIP,
getSubStr(d.strVal07, 19),
getSubStr(d.strVal08, 19),
d.strDate,
d.strTime,
"" });
/*strTable = "UT_DATA";*/
break;
case 2:
arrField.AddRange(new string[] { "MACID", "PARTNUM", "WORKNO", "LINEID", "OPERTOR", "BARCODE", "TRESULT",
"TESTDATE", "TESTTIME", "FL01", "FL02", "FL03", "FL04", "FL05", "FL06", "FL07",
"FL08", "FL09", "FL10", "SDATE", "STIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strFix, 19),
getSubStr(d.strPart, 19),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 19),
getSubStr(d.strWork, 19),
getSubStr(d.strBarcode, 49),
d.strResult,
d.strDate,
d.strTime,
getSubStr(d.strInfo, 199),
getSubStr(d.strVal01, 199),
getSubStr(d.strVal02, 19),
getSubStr(d.strVal03, 19),
getSubStr(d.strVal04, 19),
getSubStr(d.strVal05, 19),
getSubStr(d.strVal06, 19),
strIP,
getSubStr(d.strVal07, 19),
getSubStr(d.strVal08, 19),
d.strDate,
d.strTime,
"" });
/*strTable = "FLUKE_DATA";*/
break;
case 3:
arrField.AddRange(new string[] { "ICT_NO", "BOARD_NAME", "BAR_CODE", "DDATE", "TTIME", "RESULT",
"OP_ID", "SDATE", "STIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strFix, 19),
getSubStr(d.strPart, 19),
getSubStr(d.strBarcode, 24),
d.strDate,
d.strTime,
getSubStr(d.strResult, 1),
getSubStr(d.strWork, 19),
d.strDate,
d.strTime,
"" });
/*strTable = "ICT_TAB";*/
break;
case 4:
arrField.AddRange(new string[] { "PARTNUM", "REVISION", "WORK_ORDER", "LINE_ID", "OPERATOR,FIXTURE",
"INSTRUMENT", "BARCODE", "RESULT", "TESTDATE", "TESTTIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strPart, 19),
getSubStr(d.strInfo, 19),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 19),
getSubStr(d.strWork, 19),
getSubStr(d.strFix, 19),
getSubStr(d.strFix, 19),
getSubStr(d.strBarcode, 39),
d.strResult,
d.strDate,
d.strTime,
"" });
/*strTable = "UT_TABLE";*/
break;
case 5:
arrField.AddRange(new string[] { "PARTNUM", "REVISION", "WORK_ORDER", "LINE_ID", "OPERATOR", "NO", "FIXTURE",
"INSTRUMENT", "BARCODE", "RESULT", "TESTDATE", "TESTTIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strPart, 19),
getSubStr(d.strInfo, 9),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 19),
getSubStr(d.strWork, 14),
getSubStr(d.strWork, 14),
getSubStr(d.strFix, 19),
getSubStr(d.strFix, 19),
getSubStr(d.strBarcode, 39),
d.strResult,
d.strDate,
d.strTime,
"" });
/*strTable = "FLUKE_TABLE";*/
break;
case 6:
arrField.AddRange(new string[] { "PARTNUM", "REVISION", "WORK_ORDER", "LINE_ID", "NO",
"FIXTURE", "BARCODE", "RESULT", "TESTDATE", "TESTTIME", "FPATH" });
arrValue.AddRange(new string[] { getSubStr(d.strPart, 19),
getSubStr(d.strInfo, 9),
getSubStr(d.strOrder, 19),
getSubStr(d.strLine, 9),
getSubStr(d.strWork, 19),
getSubStr(d.strFix, 19),
getSubStr(d.strBarcode, 29),
d.strResult,
d.strDate,
d.strTime,
"" });
/*strTable="FAP207FCT_TABLE";*/
break;
case 9:
arrField.AddRange(new string[] { "PARTNUM", "REVISION", "SITEM", "BARCODE", "NGITEM",
"SLINE", "SNUM", "STNUM", "UNUM", "TIMEINT", "ACTDATE", "MNO", "CDATE", "CTIME", "CUID",
"ISACT", "S01", "S02", "S03", "S04", "S05" });
arrValue.AddRange(new string[] { getSubStr(d.strPart, 19),
"",
getSubStr(d.strSitem, 19),
getSubStr(d.strBarcode, 29),
"",
"",
"",
d.Stnum.ToString(),
d.Unum.ToString(),
"",
"",
"",
d.strDate,
d.strTime,
"",
"",
"",
"",
"",
d.S04,
"" });
/*strTable="BARSAMINFO_TABLE";*/
break;
case 10:
arrField.AddRange(new string[] { "PARTNUM", "REVISION", "SITEM", "BARCODE", "NGITEM",
"TRES", "MNO", "CDATE", "CTIME", "CLINE", "CUID",
"SR01", "SR02", "SR03", "SR04", "SR05" });
arrValue.AddRange(new string[] { getSubStr(d.strPart, 19),
"",
getSubStr(d.strSitem, 19),
getSubStr(d.strBarcode, 29),
"",
d.strResult,
getSubStr(d.strFix, 19),
d.strDate,
d.strTime,
"",
"",
"",
"",
"",
d.S04,
"" });
/*strTable="BARSAMINFO_TABLE";*/
break;
default:
break;
}
}
