源代码/App_Code/DBHelper.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

/// <summary>
/// DBHelper 的摘要说明
/// </summary>
public class  DBHelper
{
     
        public DBHelper()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
 
        public static int ExecuteSQL(string cmdText, CommandType cmdType, string[] names, object[] values)
        {
            SqlConnection myConn = new SqlConnection(GetConnStr());
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConn;
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            cmd.Parameters.Clear();
            if (names != null)
            {
                for (int i = 0; i < names.Length; i++)
                {
                    cmd.Parameters.AddWithValue(names[i], values[i]);
                }
            }
            if (myConn.State == ConnectionState.Closed)
            {
                myConn.Open();
            }
            int count = cmd.ExecuteNonQuery();
            myConn.Close();
            return count;
        }
        /// <summary>
        /// 获得数据库连接字符串
        /// </summary>
        /// <returns></returns>
        public static string GetConnStr()
        {
            return ConfigurationManager.ConnectionStrings["XuanKe"].ConnectionString;
        }



        /// <summary>