Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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)));
        }
Esempio n. 3
0
        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());
        }
Esempio n. 4
0
        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);
        }