Exemple #1
0
        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()));
        }
Exemple #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)));
        }