数据库操作类

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;

/// adminDataBase 的摘要说明
/// </summary>
public class adminDataBase
{
            AJAX的WEB_config
            //<configuration>
            //<connectionStrings>
     // <add name="ConnectionStr" connectionString="server=.;uid=sa;pwd=;database=数据库名"/>
     //</connectionStrings>
            //</configuration>
            正常
            //<configuration>
            //<connectionStrings>
  //<add name="adminConString" connectionString="server = (local); database= 'jinqi'; uid = 'jinqi_admin'; pwd = '77535'" providerName="System.Data.SqlClient"/>
  //<add name="usersConString" connectionString="server = (local); database= 'jinqi'; uid = 'jinqi_user'; pwd = '77535'" providerName="System.Data.SqlClient"/>
     //</connectionStrings>
            //</configuration>
    private readonly string ConnectionString = ConfigurationManager.ConnectionStrings["adminConString"].ToString();
    private SqlConnection sqlCon;
    private SqlCommand sqlComm;
    private SqlDataReader sqlDr;

    public adminDataBase()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
        sqlCon = new SqlConnection( ConnectionString );
       
 }

    public int adminLogin(string adminName, string adminPasswd)
    {
        //管理员登录存储过程
        int i = 0;
        try
        {
     sqlCon = new SqlConnection( ConnectionString );//获取连接字符传  在WEB_config中配置
            sqlCon.Open();//打开数据库连接
            sqlComm = sqlCon.CreateCommand();
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandText = "admin_login";
            sqlComm.Parameters.Add(new SqlParameter("@ad_name", SqlDbType.VarChar, 20));
            sqlComm.Parameters["@ad_name"].Value = adminName;
            sqlComm.Parameters.Add(new SqlParameter("@ad_passwd", SqlDbType.VarChar, 20));
            sqlComm.Parameters["@ad_passwd"].Value = adminPasswd;
            sqlComm.Parameters.Add(new SqlParameter("@ad_level", SqlDbType.Int, 4));
            sqlComm.Parameters["@ad_level"].Direction = ParameterDirection.Output;
            sqlComm.ExecuteNonQuery();
            i = Convert.ToInt32(sqlComm.Parameters["@ad_level"].Value.ToString());  
        }
        catch (Exception ex)
        {
            throw ex;
        }
 finally
 {
  SqlConnectionClose();
 }

        return i;
    }

    public int Log(string logname,string logevet)
    {
        //管理员登录存储过程 传参
        int l = 0;
        try
        {
     sqlCon = new SqlConnection( ConnectionString );//获取连接字符传  在WEB_config中配置
            sqlCon.Open();
            sqlComm = sqlCon.CreateCommand();
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandText = "logg";
            sqlComm.Parameters.Add(new SqlParameter("@logname", SqlDbType.VarChar, 20));
            sqlComm.Parameters["@logname"].Value = logname;
            sqlComm.Parameters.Add(new SqlParameter("@logevet", SqlDbType.VarChar, 20));
            sqlComm.Parameters["@logevet"].Value = logevet;
            l= Convert.ToInt32(sqlComm.ExecuteNonQuery());
            return l;
        }
        catch (Exception ex)
        {
            throw ex;
        }
 finally
 {
     SqlConnectionClose();
 }
    }

    public int operatorLogin(string adminName, string adminPasswd)
    {
        //操作员登录
        int i=0;
        try
        {
     sqlCon = new SqlConnection( ConnectionString );
            sqlCon.Open();
            string sql = "select * from jq_operator where operator_name='" + adminName + "' and operator_pwd='" + adminPasswd + "'";
            SqlCommand cmd = new SqlCommand(sql,sqlCon);
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                dr.Close();
                return i = 1;
            }
            else
            {
                dr.Close();
                return i = 0;
            }
          
        }
        catch (Exception ex)
        {
            throw ex;
        }
 finally
 {
  SqlConnectionClose();
 }

    }
   
     /// 执行SQL语句，并返回第一行第一列结果
    /// </summary>
    /// <param name="strSql">SQL语句</param>
    /// <returns></returns>
    public string RunSqlReturn(string strSql)
    {
        #region
        string strReturn = "";
        sqlCon = new SqlConnection( ConnectionString );
        sqlCon.Open();
        try
        {
            cmd = new SqlCommand(strSql, cn);
            strReturn = cmd.ExecuteScalar().ToString();
        }
        catch { }
        finally
 {
  SqlConnectionClose();
 }
        return strReturn;
        #endregion
    }

    //设置用户权限登陆
    public int ad_class(int i, string adminName)
    {
        int h = 0;
        try
        {
     sqlCon = new SqlConnection( ConnectionString );
            sqlCon.Open();
            string sql = "select ad_class from jq_admin where ad_level=3 and ad_name='" + adminName + "'";
            SqlCommand cmd = new SqlCommand(sql, sqlCon);
            SqlDataReader dr = cmd.ExecuteReader();
            dr.Read();
            if (dr.HasRows)
            {
  
                h = Convert.ToInt32(dr.GetValue(0).ToString());
            }
            return h;
        }
        catch (Exception ex)
        {
            throw ex;
        }
finally
 {
  SqlConnectionClose();
 }
    }

    public DataSet GetDS(string sqlString)
    {
        //数据查询，返回DataSet；
        try
        {
     sqlCon = new SqlConnection( ConnectionString );
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlString, sqlCon);
            DataSet sqlDataSet = new DataSet();
            sqlDataAdapter.Fill(sqlDataSet);
            return sqlDataSet;
        }
        catch(Exception ex)
        {
            throw ex;
        }
 finally
 {
  SqlConnectionClose();
 }
    }
    public DataSet GetDS(int selectID, string proc)
    {
        //数据查询存储过程，返回DataSet；
        try
        {
            sqlCon = new SqlConnection( ConnectionString );
            sqlCon.Open();
            sqlComm = sqlCon.CreateCommand();
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandText = proc;
            sqlComm.Parameters.Add(new SqlParameter("@selectID", SqlDbType.Int, 4));
            sqlComm.Parameters["@selectID"].Value = selectID;
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = sqlComm;
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
 {
  SqlConnectionClose();
 }
    }
 
    public int sqlCommamd(string sqlString)
    {
        //接受数据库操作，返回受影响行数；
        try
        {
            sqlCon = new SqlConnection( ConnectionString );
            sqlCon.Open();
            sqlComm = sqlCon.CreateCommand();
            sqlComm.CommandText = sqlString;
            return sqlComm.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            throw ex;
        }
 finally
 {
  SqlConnectionClose();
 }
    }

    public SqlDataReader sqlDataReader(string sqlString)
    {
        //数据查询，返回DataReader；
         try
        {
            sqlCon = new SqlConnection( ConnectionString ); 
            sqlCon.Open();
            sqlComm = sqlCon.CreateCommand();
            sqlComm.CommandText = sqlString;
            sqlDr = sqlComm.ExecuteReader();
            return sqlDr;
         //DataReaderClose();
        }
        catch(Exception ex)
        {
            throw ex;
        }
 finally
 {
  SqlConnectionClose();
 }

    }

    public void DataReaderClose()
    {
        sqlDr.Close();
    }

    public void SqlConnectionClose()
    {
        if (sqlCon != null)
        {
            sqlCon.Close();
     sqlCon.Dispose();
        }
    }

}