public int LIZNI_SEQ(string sequence) { DBVal dbv = new DBVal(sesna); IDBValFactory idbv = dbv.CreateDBV(); int ID = 0; if (idbv.Database == typeof(MSSQL)) { if (sequence == "PRPL_ID") { sequence = "P_SEQUENCE_PRPL"; } if (sequence == "PLATBA_ID") { sequence = "P_SEQUENCE_PLATBA"; } DevExpress.Xpo.DB.SelectedData selData = sesna.ExecuteSproc("LIZNI_SEQ", new OperandValue(sequence)); ID = Convert.ToInt32(selData.ResultSet[0].Rows[0].Values[0]); } if (idbv.GetType() == typeof(ORACLE)) { if (sequence == "PRPL_ID") { sequence = "P_SEQ_PRPL_ID"; } if (sequence == "PLATBA_ID") { sequence = "P_SEQ_PLATBA_ID"; } object obj = sesna.ExecuteScalar("select " + sequence + ".Nextval ID from dual"); ID = Convert.ToInt32(obj); } if (ID == 0) { throw new Exception(String.Format("chyba při čtení hodnoty sequence {0}", sequence)); } return(ID); }