oraprocedure.cs

网通网关Cngp

using System;
using System.Data;
using System.Data.OleDb;
using WriteLog;
namespace Cngp
{
	/// <summary>
	/// OraProcedure 的摘要说明。
	/// </summary>
	public class OraProcedure
	{
		private OleDbConnection Conn;
		public OraProcedure()
		{
			Conn=new OleDbConnection("Provider=OraOLEDB.Oracle.1;Password=sjc600;Persist Security Info=True;User ID=cnc" +
				";Data Source=ora2003;Extended Properties=\"\";Pooling=true");
		}
		public OleDbConnection OraCon
		{
			get{return Conn;}
		}
		public void InsertMORecord(string SmsCode,string Mobileid,string Content)
		{
			try
			{
				OleDbCommand Cmd=Conn.CreateCommand();
				Cmd.CommandType=CommandType.StoredProcedure;
				if(Conn.State==ConnectionState.Closed)
				{
					Conn.Open();
				}
				Cmd.CommandText="moprocess1.main";
				//parameter
				OleDbParameter paraSmsCode=new OleDbParameter("@smscode",OleDbType.VarChar,21);
				OleDbParameter paraMobileid=new OleDbParameter("@mobileid",OleDbType.VarChar,15);
				OleDbParameter paraContent=new OleDbParameter("@content",OleDbType.VarChar,800);
				//
				Cmd.Parameters.Add(paraSmsCode);
				Cmd.Parameters.Add(paraMobileid);
				Cmd.Parameters.Add(paraContent);
				//value
				Cmd.Parameters["@smscode"].Value=SmsCode;
				Cmd.Parameters["@mobileid"].Value=Mobileid;
				Cmd.Parameters["@content"].Value=Content;
				//
				Cmd.ExecuteNonQuery();
			}
			catch(Exception ex)
			{
				Logs.writeLog(ex.Message.ToString(),false);
			}
			finally
			{
				if(Conn.State==ConnectionState.Open)
				{
					Conn.Close();
				}
			}

		}
	}
}