DBHelp数据处理类
时间：2021-07-01 10:21:17
帮助过：2人阅读
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;
}
}
}
DBHelp数据处理类
标签：
