SqlServer.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace 网上订餐系统
{
    public class SqlServer
    {

        SqlConnection _con = new SqlConnection();
        SqlCommand _cmd = new SqlCommand();
        SqlDataAdapter _sda = new SqlDataAdapter();

        public SqlServer()
            : this(ConfigurationManager.ConnectionStrings["MSSQLConStr"].ConnectionString)
        {
        }

        public SqlServer(string connectionString)
        {
            this._con.ConnectionString = connectionString;
            this._cmd.Connection = this._con;
        }

        public void Reset()
        {
            this._cmd.Connection = this._con;
            this._cmd.CommandType = CommandType.Text;
            this.SQL = string.Empty;
            this.Parameters.Clear();
        }

        public void Open()
        {
            if (this._con.State == ConnectionState.Closed) this._con.Open();
        }

        public void Close()
        {
            if (this._con.State == ConnectionState.Open) this._con.Close();
        }

        public CommandType CommandType
        {
            get
            {
                return this._cmd.CommandType;
            }
            set
            {
                this._cmd.CommandType = value;