accessdb.cs

酒店管理系统

using System;
using System.Data ;
using System.Data .SqlClient;
using System.Collections ;

namespace DataAccessMethod
{
	
	public class DB
	{
		public DB()
		{

		}
		public  static SqlConnection CreateCon()
		{
			return new SqlConnection("Persist Security Info=False;User ID=sa;Initial Catalog=Hotel");
		}
        
		public static void Factparas(SqlCommand cmd,params SqlParameter[] paras)//参数设置
		{
			cmd.CommandType=CommandType.StoredProcedure;
			for(int i=0;i<paras.Length;i++)
			{
				cmd.Parameters.Add(paras[i]);
			}
		
		}	


		#region 不带参数的存储过程的调用
		public static DataSet ExequlReader(string storeName)//不带参数的存储过程的调用
		{
			DataSet sdr=new DataSet ();
			SqlConnection  con=DB.CreateCon();
			SqlCommand cmd=new SqlCommand(storeName,con);
			cmd.Connection =con;
		   
			try
			{
				con.Open();
				SqlDataAdapter adapter = new SqlDataAdapter(cmd);
				adapter.Fill(sdr); 				
			}
			catch{}

			return sdr;
		}
		#endregion


		#region  带参数的存储过程的调用
		public  static DataSet ExequlReader(string storeName,params SqlParameter[] paras)//带参数的存储过程的调用
		{

			DataSet sdr=new DataSet ();
			SqlConnection  con=DB.CreateCon();
			SqlCommand cmd = new SqlCommand(storeName, con);			
			DB.Factparas(cmd,paras);
			try
			{
				con.Open();
				SqlDataAdapter adapter = new SqlDataAdapter(cmd);
				adapter.Fill(sdr); 
			}
			catch{}
			return sdr;

		}
		#endregion



		#region  不带参数的存储过程的调用
		public  static ArrayList ExequlReaderNoneParas(string storeName)//不带参数的存储过程的调用
		{

			DataSet sdr=new DataSet ();
			SqlConnection  con=DB.CreateCon();
			SqlCommand cmd = new SqlCommand(storeName, con);			
		    ArrayList al=new ArrayList();
			try
			{
				con.Open();	
			}
			catch{}
			SqlDataReader dr=cmd.ExecuteReader();
			while(dr.Read())
			{
				al.Add(dr[0]);
			}
			return al;


		}
		#endregion



		
		#region　对数据库的增删改
		public static bool ExequlNon(string storeName, params SqlParameter[] paras)//update delete add 不需要返回数据集
		{
			bool result = false;
			SqlConnection con = DB.CreateCon();
			SqlCommand cmd = new SqlCommand(storeName, con);
			DB.Factparas(cmd, paras);
			try
			{
				con.Open();
				int count = (int)(cmd.ExecuteNonQuery());//返回受影响的行数
				if (count > 0)
				{
					result = true;
				}
                
			}
			catch { }
			finally
			{
				con.Close();
			}
			return result;
           
		}
        
		#endregion


	}
}