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[,] 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))); }