数据库访问类(使用存储过程的)
来源:互联网 发布:迅捷网络哪里能下载 编辑:程序博客网 时间:2024/05/19 02:20
- using System;
- using System.Data;
- using System.Configuration;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.SqlClient;
- public class DataBase
- {
-
- private static DataBase _instance;
- public DataBase()
- {
- }
- public static DataBase GetInstance()
- {
- if(_instance==null)
- {
- _instance = new DataBase();
- }
- return _instance;
- }
-
- public static SqlConnection ReturnConn()
- {
- string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
- SqlConnection Conn = new SqlConnection(strConn);
- if (Conn.State.Equals(ConnectionState.Closed))
- {
- Conn.Open();
- }
- return Conn;
- }
-
- public static SqlCommand CreateCmd(string procName, SqlParameter[] prams, SqlConnection Conn)
- {
- SqlConnection SqlConn = Conn;
- if (SqlConn.State.Equals(ConnectionState.Closed))
- {
- SqlConn.Open();
- }
- SqlCommand Cmd = new SqlCommand();
- Cmd.CommandType = CommandType.StoredProcedure;
- Cmd.Connection = SqlConn;
- Cmd.CommandText = procName;
- if (prams != null)
- {
- foreach (SqlParameter parameter in prams)
- {
- if (parameter != null)
- {
- Cmd.Parameters.Add(parameter);
- }
- }
- }
- return Cmd;
- }
-
- public static SqlCommand CreateCmd(string procName, SqlParameter[] prams)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = new SqlCommand();
- Cmd.CommandType = CommandType.StoredProcedure;
- Cmd.Connection = Conn;
- Cmd.CommandText = procName;
- if (prams != null)
- {
- foreach (SqlParameter parameter in prams)
- {
- if (parameter != null)
- {
- Cmd.Parameters.Add(parameter);
- }
- }
- }
- return Cmd;
- }
-
- public static SqlCommand CreateCmd(string procName,SqlConnection Conn)
- {
- SqlConnection SqlConn = Conn;
- if (SqlConn.State.Equals(ConnectionState.Closed))
- {
- SqlConn.Open();
- }
- SqlCommand Cmd = new SqlCommand();
- Cmd.CommandType = CommandType.StoredProcedure;
- Cmd.Connection = SqlConn;
- Cmd.CommandText = procName;
- return Cmd;
- }
-
- public static SqlCommand CreateCmd(string procName)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = new SqlCommand();
- Cmd.CommandType = CommandType.StoredProcedure;
- Cmd.Connection = Conn;
- Cmd.CommandText = procName;
- return Cmd;
- }
-
- public static SqlDataReader RunProcGetReader(string procName, SqlParameter[] prams)
- {
- SqlCommand Cmd = CreateCmd(procName, prams);
- SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
- return Dr;
- }
-
- public static SqlDataReader RunProcGetReader(string procName, SqlParameter[] prams, SqlConnection Conn)
- {
- SqlCommand Cmd = CreateCmd(procName, prams,Conn);
- SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
- return Dr;
- }
-
- public static SqlDataReader RunProcGetReader(string procName, SqlConnection Conn)
- {
- SqlCommand Cmd = CreateCmd(procName,Conn);
- SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
- return Dr;
- }
-
- public static SqlDataReader RunProcGetReader(string procName)
- {
- SqlCommand Cmd = CreateCmd(procName);
- SqlDataReader Dr = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
- return Dr;
- }
-
- public static DataTable RunProcGetTable(string procName, SqlParameter[] prams, SqlConnection Conn)
- {
- SqlCommand Cmd = CreateCmd(procName, prams, Conn);
- SqlDataAdapter Dtr = new SqlDataAdapter();
- DataSet Ds = new DataSet();
- Dtr.SelectCommand = Cmd;
- Dtr.Fill(Ds);
- DataTable Dt = Ds.Tables[0];
- Conn.Close();
- return Dt;
- }
-
- public static int RunExecute(string procName)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = CreateCmd(procName,Conn);
- int intResult = Cmd.ExecuteNonQuery();
- Conn.Close();
- return intResult;
- }
-
- public static int RunExecute(string procName,SqlParameter[] prams)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = CreateCmd(procName,prams,Conn);
- int intResult = Cmd.ExecuteNonQuery();
- Conn.Close();
- return intResult;
- }
- public static int RunExecuteScalar(string procName)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = CreateCmd(procName, Conn);
- int intResult = Convert.ToInt32(Cmd.ExecuteScalar());
- Conn.Close();
- return intResult;
- }
- public static int RunExecuteScalar(string procName, SqlParameter[] prams)
- {
- SqlConnection Conn = ReturnConn();
- SqlCommand Cmd = CreateCmd(procName, prams, Conn);
- int intResult =Convert.ToInt32(Cmd.ExecuteScalar());
- Conn.Close();
- return intResult;
- }
- }