Smokewinetea.DAL/DbHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;


namespace Smokewinetea.DAL
{
   public class DbHelper
    {
       private static readonly string SktDB = ConfigurationManager.ConnectionStrings["SkteaDB"].ToString();
       

       private static SqlConnection Conn = new SqlConnection(SktDB);

       public static void Conopen()
       {
           Conn.Open();
       }
       public static void ConClose()
       {
           Conn.Close();
       }

       public static int ExrcuteScalar(string strSql ,SqlParameter[] log)
       {
           SqlCommand comm = new SqlCommand(strSql,Conn);
           comm.Parameters.AddRange(log);
           Conn.Open();
           int var = Convert.ToInt32(comm.ExecuteScalar());
           Conn.Close();
           return var;
       }

       public static SqlDataReader ExecuteReader(string strSql)
       {
           SqlCommand comm = new SqlCommand(strSql, Conn);
           Conn.Open();
           SqlDataReader dr = comm.ExecuteReader();
           return dr;
       }

       public static SqlDataReader ExecuteReader(string strSql, SqlParameter[] log)
       {
           SqlCommand comm = new SqlCommand(strSql, Conn);
           comm.Parameters.AddRange(log);
           Conn.Open();
           SqlDataReader dr = comm.ExecuteReader();
           return dr;
       }
       public static int ExecuteNonQuery(string strSql,SqlParameter[] param)
       {
           SqlCommand comm = new SqlCommand(strSql,Conn);
           comm.Parameters.AddRange(param);
           Conn.Open();
           int val = comm.ExecuteNonQuery();
           Conn.Close();