database.cs

来自「c#做的WEB disk」· CS 代码 · 共 50 行

using System;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace ConfirmWebDisk.JLService
{
	/// <summary>
	/// DataBase 的摘要说明。
	/// </summary>
	public class DataBase
	{
		private string Conn ;
		public DataBase()
		{
			Conn = ConfigurationSettings.AppSettings["ConnectionString"];
		}
		public int ExecuteStoreProc( string StoreProcName , IDataParameter[] Parameters)
		{ 
			SqlConnection Connection = new SqlConnection( Conn );
			SqlCommand Command = new SqlCommand( StoreProcName,Connection);
			Command.CommandType = CommandType.StoredProcedure;
			Connection.Open();
			foreach( SqlParameter Parameter in Parameters)
			{
				Command.Parameters.Add( Parameter );
			}
			int Result = Command.ExecuteNonQuery();
			Connection.Close();
			
			return Result;
		}
		public string ExecuteStore( string StoreProcName , IDataParameter[] Parameters)
		{
			SqlConnection Connection = new SqlConnection( Conn );
			SqlCommand Command = new SqlCommand( StoreProcName,Connection);
			Command.CommandType = CommandType.StoredProcedure;
			Connection.Open();
			foreach( SqlParameter Parameter in Parameters)
			{
				Command.Parameters.Add( Parameter );
			}
			string Result = Command.ExecuteScalar().ToString();
			Connection.Close();
			
			return Result;
		}
	}
}