DBHelp数据处理类_.NET_编程开发_程序员俱乐部

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using MyShoolModels;
namespace MyShoolDAL
{
    public class DBhelper
    {
        string conn = "Data Source=.;Initial Catalog=MySchool;User ID=sa";
        SqlConnection sc;

        public SqlConnection Sc//连接
        {
            get {
                if(sc==null)
                {
                    sc = new SqlConnection(conn);
                }
                
                return sc;
               
            }
           
    
        }
        public void OpenSc() //打开
        {
            if(sc.State==System.Data.ConnectionState.Broken || sc.State==System.Data.ConnectionState.Closed)
            {
                sc.Close();
                sc.Open();
            }
        }
        public void CloseSc()//关闭
        {
            if (sc.State == System.Data.ConnectionState.Broken || sc.State == System.Data.ConnectionState.Open)
            {
                sc.Close();
            }
        }
        public int ExecuteQue(string sql,SqlParameter[] paras)
        {
            SqlCommand cmd = new SqlCommand(sql,Sc);
            cmd.Parameters.AddRange(paras);
            int resul = cmd.ExecuteNonQuery();
            return resul;
        }
    }
}