DBHelp数据处理类

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  {    get='_blank'>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;    }  }}

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：DBHelp数据处理类

关键词：