C# OracleParameter类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中OracleParameter类的典型用法代码示例。如果您正苦于以下问题：C# OracleParameter类的具体用法？C# OracleParameter怎么用？C# OracleParameter使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

OracleParameter类属于命名空间，在下文中一共展示了OracleParameter类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: InsertNewProduct

        public int InsertNewProduct(string commandString, string name, decimal price, int vendor, int measure, int category)
        {
            int result = -1;

            OracleParameter parameterName = new OracleParameter(":name", name);
            OracleParameter parameterPrice = new OracleParameter(":price", price);
            OracleParameter parameterVendor = new OracleParameter(":vendor", vendor);
            OracleParameter parameterMeasure = new OracleParameter(":measure", measure);
            OracleParameter parameterCategory = new OracleParameter(":category", category);

            OracleNotSelectConnection notSelectConnection = null;

            try
            {
                using (notSelectConnection = new OracleNotSelectConnection())
                {
                    result = notSelectConnection.UpdateDatabase(commandString,
                        new OracleParameter[] { parameterName, parameterPrice, parameterVendor, parameterMeasure, parameterCategory });
                }
            }
            catch (Exception ex)
            {
                if (notSelectConnection != null)
                {
                    notSelectConnection.Dispose();
                    notSelectConnection = null;
                }

                throw ex;
            }

            return result;
        }

开发者ID:TeamDarkLiverHorses，项目名称:DBAppsTeamProject，代码行数:33，代码来源:OracleDBAction.cs

示例2: ConvertToNativeParameter

        private static IDbDataParameter ConvertToNativeParameter(DbParameter dbParameter, CommandType cmdType)
        {
            IDbDataParameter clone = new OracleParameter() { IsNullable = dbParameter.IsNullable };

            // Remove leading ':' character for stored procedures.
            if (cmdType == CommandType.StoredProcedure)
            {
                string name = parameterRenderer.RenderParameterName(dbParameter);
                if (name.StartsWith(":", StringComparison.Ordinal))
                    name = name.Substring(1, name.Length - 1);

                clone.ParameterName = name;
            }
            else
            {
                clone.ParameterName = parameterRenderer.RenderParameterName(dbParameter);
            }

            if (dbParameter.PassMode == SpArgumentPassMode.DataTableFilledByAdapter)
                ((OracleParameter)clone).OracleDbType = OracleDbType.RefCursor;
            else
                clone.DbType = dbParameter.DbType;

            clone.Direction = dbParameter.Direction;
            clone.Precision = dbParameter.Precision;
            clone.Scale = dbParameter.Scale;
            clone.Size = dbParameter.Size;
            clone.SourceColumn = dbParameter.SourceColumn;
            clone.SourceVersion = dbParameter.SourceVersion;
            clone.Value = dbParameter.Value;

            return clone;
        }

开发者ID:lordfist，项目名称:FistCore.Lib，代码行数:33，代码来源:OracleCommandBuilder.cs

示例3: updatePlayer

        //TEMPORAIRE VERIFIER Si jid ou USERNAME
        public static bool updatePlayer(int jid, string username, string email, string password)
        {
            OracleConnection conn = Connection.getInstance().conn;

            string sqlupdate = "update joueurs set email=:EMAIL,Hash_KEY=:Hash_KEY where jid=:jid";

            try
            {

                OracleCommand oraUpdate = new OracleCommand(sqlupdate, conn);

                OracleParameter OraParamEmail = new OracleParameter(":EMAIL", OracleDbType.Varchar2, 40);
                OracleParameter OraParamHashKey = new OracleParameter(":Hash_KEY", OracleDbType.Char, 75);  //Ajout
                OracleParameter OraParamJid = new OracleParameter(":jid", OracleDbType.Int32);

                OraParamEmail.Value = email;
                OraParamHashKey.Value = Controle.hashPassword(password, null, System.Security.Cryptography.SHA256.Create());
                OraParamJid.Value = jid;


                oraUpdate.Parameters.Add(OraParamEmail);
                oraUpdate.Parameters.Add(OraParamHashKey);
                oraUpdate.Parameters.Add(OraParamJid);

                oraUpdate.ExecuteNonQuery();

                return true;
            }
            catch (OracleException ex)
            {
                Erreur.ErrorMessage(ex);
                return false;
            }
        }

开发者ID:daren511，项目名称:ThroneWarsServer，代码行数:35，代码来源:Controle.cs

示例4: insertPlayer

        //-------------------------------------INSERT / UPDATE / DELETE PLAYER-------------------------------------------

        /// <summary>
        /// Fonction qui sert à insérer un joueur dans la BD
        /// </summary>
        /// <param name="username"></param>
        /// <param name="email"></param>
        /// <param name="password"></param>
        /// <returns> true ou false si l'ajout marche ou pas</returns>
        public static bool insertPlayer(string username, string email, string password)
        {
            OracleConnection conn = Connection.getInstance().conn;

            string sqlAjout = "insert into joueurs (username,EMAIL,Hash_KEY)" +
                    " VALUES(:username,:EMAIL,:Hash_KEY)";
            try
            {

                OracleCommand oraAjout = new OracleCommand(sqlAjout, conn);

                OracleParameter OraParaUsername = new OracleParameter(":username", OracleDbType.Varchar2, 40);
                OracleParameter OraParamEmail = new OracleParameter(":EMAIL", OracleDbType.Varchar2, 40);
                OracleParameter OraParamHashKey = new OracleParameter(":Hash_KEY", OracleDbType.Char, 75);  //Ajout

                OraParaUsername.Value = username.ToLower();
                OraParamEmail.Value = email;
                OraParamHashKey.Value = Controle.hashPassword(password, null, System.Security.Cryptography.SHA256.Create());


                oraAjout.Parameters.Add(OraParaUsername);
                oraAjout.Parameters.Add(OraParamEmail);
                oraAjout.Parameters.Add(OraParamHashKey);

                oraAjout.ExecuteNonQuery();

                return true;
            }
            catch (OracleException ex)
            {
                Erreur.ErrorMessage(ex);
                return false;
            }
        }

开发者ID:daren511，项目名称:ThroneWarsServer，代码行数:43，代码来源:Controle.cs

示例5: InsertProductCategory

        public int InsertProductCategory(string commandString, string categoryName, string categoryValue, string parentName, string parentValue)
        {
            int result = -1;

            OracleNotSelectConnection notSelectConnection = null;

            OracleParameter insertParameter = new OracleParameter(categoryName, categoryValue);
            OracleParameter parentParameter = new OracleParameter(parentName,  parentValue);

            if (parentValue == string.Empty)
            {
                parentParameter.Value = System.DBNull.Value;
            }

            try
            {
                using (notSelectConnection = new OracleNotSelectConnection())
                {
                    result = notSelectConnection.UpdateDatabase(commandString, new OracleParameter[] { insertParameter, parentParameter });
                }
            }
            catch (Exception ex)
            {
                if (notSelectConnection != null)
                {
                    notSelectConnection.Dispose();
                    notSelectConnection = null;
                }

                throw ex;
            }

            return result;
        }

开发者ID:TeamDarkLiverHorses，项目名称:DBAppsTeamProject，代码行数:34，代码来源:OracleDBAction.cs

示例6: f_del_psst_person

    public static string f_del_psst_person(string strPersonID)
    {
        string ret = "";
        try
        {
            string cmd = "update psst_person set per_status='2',per_id_dpis=null where per_id_dpis=" + f_genField(strPersonID, "N");
            ret = OPMOracleDb.ExecuteNonQuery(cmd).ToString();
            if (ret.ToLower() == "true") {
                ret = OPMSqlDb.ExecuteNonQuery(cmd).ToString().ToLower();

                cmd = " select nvl(per_name,'') || ' ' || nvl(per_surname) person_name from per_personal where per_id=:PER_ID ";
                OracleParameter[] p = new OracleParameter[1];
                p[0] = DPISOracleDb.setNumber(":PER_ID", Convert.ToInt64(strPersonID));

                DataTable dt = DPISOracleDb.ExecuteTable(cmd, p);
                if (dt.Rows.Count > 0)
                {
                    DLLLogFile.AddInterfaceLog("DPIS", "OPM", "per_personal", dt.Rows[0]["person_name"].ToString() + "(per_id =" + strPersonID + ")", "Interface P0101 ข้อมูลข้าราชการ/ลูกจ้างประจำ/พนักงานราชการ > ลบข้อมูล to OPM");
                    DLLLogFile.AddInterfaceLog("DPIS", "OPM_BO", "per_personal", dt.Rows[0]["person_name"].ToString() + "(per_id =" + strPersonID + ")", "Interface P0101 ข้อมูลข้าราชการ/ลูกจ้างประจำ/พนักงานราชการ > ลบข้อมูล to OPM_BO");
                }
            }
        }
        catch (Exception ex) { }
        return ret;
    }

开发者ID:TIT-tech，项目名称:OPM_BO，代码行数:25，代码来源:DPISGlobalFunction.cs

示例7: ADO_NET_Example

        static void ADO_NET_Example()
        {
            var cs = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=www.machinejar.com)(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=devorc02)));User Id=hr;Password=hr;";

            OracleConnection con = new OracleConnection();
            con.ConnectionString = cs;
            con.Open();

            OracleCommand cmd = con.CreateCommand();
            cmd.CommandText = "HR_DEPTPERCOUNTRY";
            cmd.CommandType = System.Data.CommandType.StoredProcedure;

            OracleParameter orcParam = new OracleParameter("CNTR_CD", OracleDbType.Varchar2);
            orcParam.Size = 50;
            orcParam.Value = "UK";
            orcParam.Direction = System.Data.ParameterDirection.Input;
            cmd.Parameters.Add(orcParam);

            OracleParameter orcOutParam = new OracleParameter("RS_CURSOR", OracleDbType.RefCursor);
            orcOutParam.Size = 50;
            orcOutParam.Direction = System.Data.ParameterDirection.Output;
            cmd.Parameters.Add(orcOutParam);

            cmd.ExecuteNonQuery();

            OracleDataReader reader = ((OracleRefCursor)cmd.Parameters["RS_CURSOR"].Value).GetDataReader();

            while (reader.Read())
            {
                Console.WriteLine("Dept Name: {0} | Address: {1}, | Country: {2}", reader.GetString(0), reader.GetString(1), reader.GetString(2));
            }
        }

开发者ID:devworker55，项目名称:SourceLab，代码行数:32，代码来源:Program.cs

示例8: adicionarProfesional

 public void adicionarProfesional(string idProfesional,string passwordProfesional,string nombreProfesional,string apellidosProfesional,string cedulaProfesional ,string correoProfesional ,string areaProfesional)
 {
     base.abrirConexion();
     OracleCommand cmd = new OracleCommand();
     cmd.Connection = conexion;
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.CommandText = "profesionales_paquete.adicionarProfesional";
     OracleParameter idProfesionalP = new OracleParameter("idProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     idProfesionalP.Value = idProfesional;
     OracleParameter passwordProfesionalP = new OracleParameter("passwordProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     passwordProfesionalP.Value = passwordProfesional;
     OracleParameter nombreProfesionalP = new OracleParameter("nombreProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     nombreProfesionalP.Value = nombreProfesional;
     OracleParameter apellidosProfesionalP = new OracleParameter("apellidosProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     apellidosProfesionalP.Value = apellidosProfesional;
     OracleParameter cedulaProfesionalP = new OracleParameter("cedulaProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     cedulaProfesionalP.Value = cedulaProfesional;
     OracleParameter correoProfesionalP = new OracleParameter("correoProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     correoProfesionalP.Value = correoProfesional;
     OracleParameter areaProfesionalP = new OracleParameter("areaProfesional", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     areaProfesionalP.Value = areaProfesional;
     cmd.Parameters.AddRange(new OracleParameter[] { idProfesionalP, passwordProfesionalP, nombreProfesionalP, apellidosProfesionalP, cedulaProfesionalP, correoProfesionalP, areaProfesionalP });
     cmd.ExecuteNonQuery();
     cmd.Dispose();
     base.cerrarConexion();
 }

开发者ID:bgtyhn，项目名称:EPSWeb，代码行数:26，代码来源:CRUDProfesionales.cs

示例9: buscarProfesional

        public List<Profesional> buscarProfesional(string valorBusqueda)
        {
            base.abrirConexion();
            OracleCommand cmd = new OracleCommand();
            cmd.Connection = conexion;
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.CommandText = "profesionales_paquete.buscarProfesional";
            OracleParameter valorBusquedaP = new OracleParameter("valorBusqueda", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
            valorBusquedaP.Value = valorBusqueda;
            OracleParameter cursor_datos = new OracleParameter("cursor_datos", OracleDbType.RefCursor, System.Data.ParameterDirection.Output);
            cmd.Parameters.AddRange(new OracleParameter[] { valorBusquedaP, cursor_datos});
            List<Profesional> profesionalesConsulta = new List<Profesional>();
            OracleDataReader lectorDatos = cmd.ExecuteReader();
            if (lectorDatos.HasRows)
            {
                while (lectorDatos.Read())
                {
                    profesionalesConsulta.Add(new Profesional()
                    {
                        id = lectorDatos.GetString(0),
                        password = lectorDatos.GetString(1),
                        nombre = lectorDatos.GetString(2),
                        apellidos = lectorDatos.GetString(3),
                        cedula = lectorDatos.GetString(5),
                        correo = lectorDatos.GetString(6),
                        area = lectorDatos.GetString(7)
                    });
                }
                lectorDatos.Close();
                cmd.Dispose();
                base.cerrarConexion();

            }
            return profesionalesConsulta;
        }

开发者ID:bgtyhn，项目名称:EPSWeb，代码行数:35，代码来源:CRUDProfesionales.cs

示例10: AddParticipantToConversation

        public override void AddParticipantToConversation(User participant, Conversation conversation)
        {
            try
            {
                OracleCommand command = CreateCommand("insertar_Usuario_Grupo");

                OracleParameter[] parameters = new OracleParameter[]
                {
                    new OracleParameter("id_usuarioV", OracleDbType.Int32) { Value = participant.ID },
                    new OracleParameter("id_grupoV", OracleDbType.Int32) { Value = conversation.ID }
                };

                command.Parameters.Add(parameters);
                _connection.Open();
                command.ExecuteReader();
            }
            catch (Exception e)
            {
                throw e;
            }
            finally
            {
                _connection.Close();
            }
        }

开发者ID:jags9415，项目名称:chat，代码行数:25，代码来源:OracleDatabase.cs

示例11: UpdateDataBase

        private int UpdateDataBase(string commandString, OracleParameter[] parameters)
        {
            OracleNotSelectConnection notSelectConnection = null;

            int result = -1;

            try
            {
                using (notSelectConnection = new OracleNotSelectConnection())
                {
                    result = notSelectConnection.UpdateDataBase(commandString, parameters);
                }
            }
            catch (Exception ex)
            {
                if (notSelectConnection != null)
                {
                    notSelectConnection.Dispose();
                    notSelectConnection = null;
                }

                throw ex;
            }

            return result;
        }

开发者ID:TeamDarkLiverHorses，项目名称:DBAppsTeamProject，代码行数:26，代码来源:ProductsRepository.cs

示例12: agregarNoticia

        public void agregarNoticia(string fecha_expiracionN, string contenidoN,string encabezadoN,string tituloN)
        {
            base.abrirConexion();
            OracleCommand cmd = new OracleCommand();
            cmd.Connection = conexion;
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.CommandText = "noticias_paquete.agregarNoticia";

            OracleParameter fechaExpiracionP = new OracleParameter("fecha_expiracionN", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
            fechaExpiracionP.Value = fecha_expiracionN;

            OracleParameter contenidoP = new OracleParameter("contenidoN", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
            contenidoP.Value = contenidoN;

            OracleParameter encabezadoP = new OracleParameter("encabezadoN", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
            encabezadoP.Value = encabezadoN;

            OracleParameter tituloP = new OracleParameter("tituloN", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
            tituloP.Value = tituloN;

            cmd.Parameters.AddRange(new OracleParameter[] { fechaExpiracionP, contenidoP, encabezadoP, tituloP});

            cmd.ExecuteNonQuery();

            cmd.Dispose();
            base.cerrarConexion();
        }

开发者ID:bgtyhn，项目名称:EPSWeb，代码行数:27，代码来源:CRUDNoticias.cs

示例13: inicioSesion

 public SesionUsuario inicioSesion(string userCorreo, string userPassword, string tipoUsuario)
 {
     base.abrirConexion();
     OracleCommand cmd = new OracleCommand();
     cmd.Connection = conexion;
     cmd.CommandType = System.Data.CommandType.StoredProcedure;
     cmd.CommandText = "pk_usuarios.session_login";
     OracleParameter userCorreoP = new OracleParameter("correoLogin", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     userCorreoP.Value = userCorreo;
     OracleParameter userPasswordP = new OracleParameter("passwordLogin", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     userPasswordP.Value = userPassword;
     //cmd.Parameters.Add("co", OracleDbType.RefCursor).Direction = System.Data.ParameterDirection.Output;
     OracleParameter tipoUsuarioP = new OracleParameter("rol", OracleDbType.Varchar2, System.Data.ParameterDirection.Input);
     tipoUsuarioP.Value = tipoUsuario;
     OracleParameter resultado = new OracleParameter("resultado", OracleDbType.RefCursor, System.Data.ParameterDirection.Output);
     cmd.Parameters.AddRange(new OracleParameter[] { userCorreoP, userPasswordP, tipoUsuarioP, resultado });
     OracleDataReader lectorDatos = cmd.ExecuteReader();
     if (lectorDatos.HasRows)
     {
         lectorDatos.Read();
         return new SesionUsuario() { id = lectorDatos.GetString(0), operacionExitosa = true, rol = tipoUsuario };
     }
     else
         return new SesionUsuario() { id = string.Empty, operacionExitosa = false, rol = tipoUsuario };
 }

开发者ID:bgtyhn，项目名称:EPSWeb，代码行数:25，代码来源:CRUDUsuario.cs

示例14: Page_Load

		protected void Page_Load(object sender, EventArgs e)
		{
			var cookielist = sm.GetCartFromCookie();

			if(cookielist != null)
			{
				Cart.Text = "Cart: " + cookielist.Count().ToString() + " product(s)";
				if (cookielist.Count() > 0)
				{
					foreach (var product in cookielist)
					{

						OracleParameter[] parameterList = new OracleParameter[]
						{
						new OracleParameter("serienumber",product.ProductId)
						};
						DataTable DT = db.ExecuteReadQuery("SELECT * FROM PRODUCT WHERE SERIE_NUMBER = :serienumber", parameterList);

						foreach (DataRow DR in DT.Rows)
						{
							ProductListControl productListControl = LoadControl("~/controls/ProductListControl.ascx") as ProductListControl;
							productListControl.Name = DR["NAME"].ToString();
							productListControl.ItemNumber = DR["SERIE_NUMBER"].ToString();
							productListControl.Price = DR["PRICE"].ToString();
							productListControl.ImagePath = DR["IMAGE_PATH"].ToString();
							productListControl.Id = DR["ID"].ToString();

							products.Controls.Add(productListControl);
						}
					}
				}
			}
        }

开发者ID:pocketnl，项目名称:4launchASP，代码行数:33，代码来源:cart.aspx.cs

示例15: CreerCommandeCliente

        /// <summary>
        /// Créé la commande. Ne permet pas le remplissage des médicaments.
        /// </summary>
        /// <param name="oMsg"></param>
        /// <returns></returns>
        public STR_MSG CreerCommandeCliente(STR_MSG oMsg)
        {
            char status = '1'; // commande OK
            char prescription = '0'; // commande sans prescription
            char hasRead = '1'; //
            int prescription_id = 1;
            int patientID = (int)oMsg.Data[1];

            OracleCommand cmd = new OracleCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "PHARMAWEB.Create_Commande";

            OracleParameter RV = new OracleParameter();
            RV.Direction = ParameterDirection.ReturnValue; // indique si c'est un paramètre entrant, ou de retour
            RV.OracleDbType = OracleDbType.Int32;
            RV.ParameterName = "id";

            cmd.Parameters.Add(RV);

            cmd.Parameters.Add("statut", OracleDbType.Char).Value = status;
            cmd.Parameters.Add("prescription", OracleDbType.Char).Value = prescription;
            cmd.Parameters.Add("hasRead", OracleDbType.Char).Value = hasRead;
            cmd.Parameters.Add("prescription_id", OracleDbType.Int32, 255).Value = prescription_id;
            cmd.Parameters.Add("patientID", OracleDbType.Int32, 255).Value = patientID;

            this.oMsg = CL_MESSAGE_Factory.msg_factory("", new object[] { cmd }, "", "", "", true, "");

            return this.oMsg;
        }

开发者ID:khalifandiaye，项目名称:pharmac，代码行数:34，代码来源:CL_MAP.cs

示例16: RegisterUser

		public void RegisterUser(string username, string password, string email)// nieuwe gebruiker registreren 
		{
			OracleParameter[] parameterListUsername = new OracleParameter[]
			{
				new OracleParameter("username",username)
			};
			DataTable DT = db.ExecuteReadQuery("SELECT DISTINCT LOWER(USER_NAME) FROM CUSTOMER WHERE USER_NAME = :username", parameterListUsername);// check of gebruikersnaam voorkomt
			
			OracleParameter[] parameterListEmail = new OracleParameter[]
			{
				new OracleParameter("email",email)
			};
			DataTable DT2 = db.ExecuteReadQuery("SELECT DISTINCT LOWER(EMAIL) FROM CUSTOMER WHERE EMAIL = :email", parameterListEmail); // check of email voorkomt

			//check of de username en email al bestaan
			if (DT.Rows.Count == 0 && DT2.Rows.Count == 0)
			{
				OracleParameter[] parameterListRegister = new OracleParameter[]
				{
				new OracleParameter("email",email),
				new OracleParameter("username",username),
				new OracleParameter("password",HashPassword(password))
				};
				db.ExecuteInsertQuery("INSERT INTO \"CUSTOMER\" (EMAIL, USER_NAME, PASSWORD,  NEWSLETTER) VALUES (:email, :username, :password, '1')", parameterListRegister); // nieuwe customer inserten

				ScriptManager.RegisterClientScriptBlock(HttpContext.Current.CurrentHandler as Page, GetType(), "alertMessage", "alert('You have been successfully registered and logged in.')", true);// succesbericht

			}
			else
			{
				ScriptManager.RegisterClientScriptBlock(HttpContext.Current.CurrentHandler as Page, GetType(), "alertMessage", "alert('Username or email already in use!')", true); //foutmelding
			}
		}

开发者ID:pocketnl，项目名称:4launchASP，代码行数:33，代码来源:UserManager.cs

示例17: ExecuteReadQuery

            public static DataTable ExecuteReadQuery(string sqlquery, OracleParameter[] parameters)
            {
                try
                {
                    using (Connection)
                    using (var command = new OracleCommand(sqlquery, _connection))
                    {
                        if (parameters != null)
                        {
                            command.Parameters.AddRange(parameters);
                        }
                        var dt = new DataTable();
                        using (OracleDataReader reader = command.ExecuteReader())
                        {
                            dt.Load(reader);
                        }

                        return dt;
                    }
                }
                catch (OracleException oe)
                {
                    Debug.WriteLine(oe.Message);
                    return null;
                }
            }

开发者ID:PillowCrusher，项目名称:Live-performance，代码行数:26，代码来源:DatabaseManager.cs

示例18: IsExistsEmail

 public ChangeResultSettings IsExistsEmail(string email)
 {
     var result = new ChangeResultSettings();
     try
     {
         ConnectDB.CloseConnection(_connectGs);
         _connectGs = new OracleConnection();
         _connectGs = ConnectDB.GetOracleConnection(_connectGs);
         var cm = _connectGs.CreateCommand();
         cm.CommandText = "usp_check_exists_email";
         cm.CommandType = CommandType.StoredProcedure;
         cm.Parameters.Add(new OracleParameter("email_check", OracleDbType.Varchar2)).Value = email;
         var op = new OracleParameter("total_result", OracleDbType.Long, 15) { Direction = ParameterDirection.Output };
         cm.Parameters.Add(op);
         cm.ExecuteNonQuery();
         var total = Convert.ToInt32(cm.Parameters["total_result"].Value.ToString());
         switch (total)
         {
             case 0:
                 result.ChangeResult = ChangeResult.ThanhCong;
                 break;
             default:
                 result.ChangeResult = ChangeResult.ThatBai;
                 break;
         }
     }
     catch (Exception ex)
     {
         result.Message = "Có lỗi trong quá trình kiểm tra email. Vui lòng thử lại!";
         result.ChangeResult = ChangeResult.ThatBai;
     }
     return result;
 }

开发者ID:nstungxd，项目名称:ips-project-vdc，代码行数:33，代码来源:UserRepository.cs

示例19: CapNhatLoaiNguonVon

 public ChangeResultSettings CapNhatLoaiNguonVon(string mdv, string nsd, string pas, string maDonVi, long idDuAn, int loaiNguonVon)
 {
     var result = new ChangeResultSettings();
     try
     {
         ConnectDB.CloseConnection(_connectGs);
         _connectGs = new OracleConnection();
         _connectGs = ConnectDB.GetOracleConnection(_connectGs);
         var cm = _connectGs.CreateCommand();
         cm.CommandText = "usp_CapNhat_DuAn_LoaiNguonVon";
         cm.CommandType = CommandType.StoredProcedure;
         cm.Parameters.Add(new OracleParameter("ma_donvi", OracleDbType.Varchar2)).Value = "";
         cm.Parameters.Add(new OracleParameter("nsd", OracleDbType.Varchar2)).Value = "";
         cm.Parameters.Add(new OracleParameter("pas", OracleDbType.Varchar2)).Value = "";
         cm.Parameters.Add(new OracleParameter("id_duan", OracleDbType.Long)).Value = idDuAn;
         cm.Parameters.Add(new OracleParameter("ma_donvi_thuchien", OracleDbType.Varchar2)).Value = maDonVi;
         cm.Parameters.Add(new OracleParameter("loai_nguonvon", OracleDbType.Int32)).Value = loaiNguonVon;
         var op = new OracleParameter("row_updated", OracleDbType.Long, 15) { Direction = ParameterDirection.Output };
         cm.Parameters.Add(op);
         cm.ExecuteNonQuery();
         var rowUpdated = cm.Parameters["row_updated"].Value.ToString();
         if (rowUpdated == "0")
             result.ChangeResult = ChangeResult.ThatBai;
     }
     catch (Exception ex)
     {
         result.ChangeResult = ChangeResult.ThatBai;
         result.Message = ex.Message;
         throw;
     }
     return result;
 }

开发者ID:nstungxd，项目名称:ips-project-vdc，代码行数:32，代码来源:GiamSatRepository.cs

示例20: salva

        public void salva(MigrationModel m)
        {
            string sql = "INSERT INTO AMC_PERSONNEL_INTEGRATION(FILE_ID, DESCRIPTION, STATUS) VALUES(:FILE_ID, :DESCRIPTION, :STATUS);";

            OracleParameter FILE_ID = new OracleParameter();
            FILE_ID.Value = m.FileId;
            FILE_ID.ParameterName = "FILE_ID";

            OracleParameter DESCRIPTION = new OracleParameter();
            DESCRIPTION.Value = m.Description;
            DESCRIPTION.ParameterName = "DESCRIPTION";

            OracleParameter STATUS = new OracleParameter();
            STATUS.Value = m.status;
            STATUS.ParameterName = "STATUS";

            OracleCommand command = this.con.CreateCommand();
            command.CommandText = sql;

            try
            {
                command.ExecuteNonQuery();
            }
            catch (OracleException ex)
            {
                con.Close();
                throw ex;
            }
        }

开发者ID:danielAlbuquerque，项目名称:PersonnelXXIProtheusIntegrationCT2，代码行数:29，代码来源:MigrationRepository.cs

注：本文中的OracleParameter类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# OracleTransaction类代码示例发布时间：2022-05-24

C# OracleDataReader类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18126|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9627|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8159|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8536|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8438|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9354|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8405|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7839|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8392|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7385|2022-11-06

客服电话

电子邮件

C# OracleParameter类代码示例

示例1: InsertNewProduct

示例2: ConvertToNativeParameter

示例3: updatePlayer

示例4: insertPlayer

示例5: InsertProductCategory

示例6: f_del_psst_person

示例7: ADO_NET_Example

示例8: adicionarProfesional

示例9: buscarProfesional

示例10: AddParticipantToConversation

示例11: UpdateDataBase

示例12: agregarNoticia

示例13: inicioSesion

示例14: Page_Load

示例15: CreerCommandeCliente

示例16: RegisterUser

示例17: ExecuteReadQuery

示例18: IsExistsEmail

示例19: CapNhatLoaiNguonVon

示例20: salva

请发表评论

全部评论

上一篇：

下一篇：

GitbookIO/gitbook:

juleswhite/mobile-cloud-asgn1

kyamagu/matlab-json: Use official API: h

墙壁眼睛膝盖

CVE-2022-34169

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053