public bool checkCR(string strBarcode, bool bPASS = true)
{
int m = 0;
string[] arr1;
if (bPASS)
{
arr1 = new string[] { "P", "PASS", "Pass", "pass" };
}
else
{
arr1 = new string[] { "F", "FAIL", "Fail", "fail" };
}
for (int i = 0; i < arr1.Length; i++)
{
string str1 = OraDBBase.getSelectString("crdata",
new string[] { "barcode", "tres" },
new string[] { strBarcode, arr1[i] });
str1 += " order by sdate,stime desc";
m += base.checkSQL(str1) ? 1 : 0;
}
if (m > 0)
{
return(true);
}
return(false);
}
public string[,] auto_getSubBarcode(string strPNLBarcode)
{
string str1 = OraDBBase.getSelectString(/*"sfcdata.barautbind"*/ "barautbind",
new string[] { "scbarcode", "pcsser" },
new string[, ] {
{ "scpnlbar", strPNLBarcode }
});
str1 += " order by to_number(pcsser) asc";
return(OraDB.ConvertDataSet(base.selectSQL2(str1)));
}
public string auto_getPNLBarcode(string strBarcode)
{
string str1 = OraDBBase.getSelectString("sfcdata.barautbind",
new string[] { "scpnlbar" },
new string[, ] {
{ "scbarcode", strBarcode }
});
str1 += " order by scdate,sctime desc";
return(base.selectSQL2(str1).Tables[0].Rows[0][0].ToString());
}
public bool checkICTTAB(string strBarcode, bool bPASS = true)
{
int m = 0;
string[] arr1 = bPASS ? new string[] { "P", "PASS", "Pass", "pass" } :
new string[] { "F", "FAIL", "Fail", "fail" };
for (int i = 0; i < arr1.Length; i++)
{
string str1 = OraDBBase.getSelectString("ict_tab",
new string[] { "bar_code", "result" },
new string[] { strBarcode, arr1[i] });
str1 += " order by itsdate,itstime desc";
m += base.checkSQL(str1) ? 1 : 0;
}
if (m > 0)
{
return(true);
}
return(false);
}