Пример #1
0
        /// <summary>Obtains the last autonumeric that has the attribute id_Aeronave</summary>
        public ONInt GetAutonumericid_Aeronave()
        {
            ONSqlMax lOnSql = new ONSqlMax();
            string   lAlias = lOnSql.CreateAlias(CtesBD.TBL_AERONAVE, null, "Aeronave");

            lOnSql.AddSelect(lAlias, CtesBD.FLD_AERONAVE_ID_AERONAVE);

            object lRet = Execute(lOnSql);

            if (lRet is DBNull)
            {
                return(new ONInt(1));
            }
            else
            {
                return(new ONInt(Convert.ToInt32(lRet) + 1));
            }
        }
Пример #2
0
        /// <summary>Obtains the last autonumeric that has the attribute id_NaveNodriza</summary>
        public ONInt GetAutonumericid_NaveNodriza()
        {
            ONSqlMax lOnSql = new ONSqlMax();
            string   lAlias = lOnSql.CreateAlias(CtesBD.TBL_NAVENODRIZA, null, "NaveNodriza");

            lOnSql.AddSelect(lAlias, CtesBD.FLD_NAVENODRIZA_ID_NAVENODRIZA);

            object lRet = Execute(lOnSql);

            if (lRet is DBNull)
            {
                return(new ONInt(1));
            }
            else
            {
                return(new ONInt(Convert.ToInt32(lRet) + 1));
            }
        }
Пример #3
0
        /// <summary>Obtains the last autonumeric that has the attribute id_Administrador</summary>
        public ONInt GetAutonumericid_Administrador()
        {
            ONSqlMax lOnSql = new ONSqlMax();
            string   lAlias = lOnSql.CreateAlias(CtesBD.TBL_ADMINISTRADOR, null, "Administrador");

            lOnSql.AddSelect(lAlias, CtesBD.FLD_ADMINISTRADOR_ID_ADMINISTRADOR);

            object lRet = Execute(lOnSql);

            if (lRet is DBNull)
            {
                return(new ONInt(1));
            }
            else
            {
                return(new ONInt(Convert.ToInt32(lRet) + 1));
            }
        }
Пример #4
0
        /// <summary>Obtains the last autonumeric that has the attribute id_Pasajero</summary>
        public ONInt GetAutonumericid_Pasajero()
        {
            ONSqlMax lOnSql = new ONSqlMax();
            string   lAlias = lOnSql.CreateAlias(CtesBD.TBL_PASAJERO, null, "Pasajero");

            lOnSql.AddSelect(lAlias, CtesBD.FLD_PASAJERO_ID_PASAJERO);

            object lRet = Execute(lOnSql);

            if (lRet is DBNull)
            {
                return(new ONInt(1));
            }
            else
            {
                return(new ONInt(Convert.ToInt32(lRet) + 1));
            }
        }