Пример #1
0
        public DataTable TelefonosGetByCodigoRegistroDT(long CodigoRegistro, string TabCodigo, Enumeration.TelefonosTipos Tipo)
        {
            TelefonosImpl oTelefonosImpl = new TelefonosImpl();

            return(oTelefonosImpl.TelefonosGetByCodigoRegistroDT(CodigoRegistro, TabCodigo, Tipo));
        }
Пример #2
0
        public DataTable TelefonosGetByCodigoRegistroDT(long CodigoRegistro, string TabCodigo, Enumeration.TelefonosTipos Tipo)
        {
            try
            {
                DataSet          ds        = new DataSet();
                Conexion         oConexion = new Conexion();
                OracleConnection cn        = oConexion.getConexion();
                cn.Open();
                string sqlSelect = " SELECT * " +
                                   " FROM   telefonos " +
                                   " WHERE  TAB_CODIGO ='" + TabCodigo + "' " +
                                   " AND TEL_CODIGO_REGISTRO=" + CodigoRegistro + " ";
                if (Tipo == Enumeration.TelefonosTipos.Telefono)
                {
                    sqlSelect = sqlSelect + " AND  TEL_EMAIL IS NULL " +
                                " AND TEL_NUMERO IS NOT NULL ";
                }
                else
                {
                    sqlSelect = sqlSelect + " AND  TEL_EMAIL IS NOT NULL " +
                                " AND TEL_NUMERO IS NULL ";
                }

                cmd     = new OracleCommand(sqlSelect, cn);
                adapter = new OracleDataAdapter(cmd);
                cmd.ExecuteNonQuery();
                adapter.Fill(ds);
                DataTable dt;
                dt = ds.Tables[0];

                return(dt);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }