App_Code/DataConn.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 TravelWeb
{
    public class DataConn
    {
        public static string ConnStr = @"Data Source=.\SQL2008;database=travel;uid=sa;pwd=sa";                                              
        public static SqlConnection mySqlConnection;

        public DataConn()
        {

        }

        /// <summary>
        /// 建立连接对象，打开连接
        /// </summary>
        /// <returns></returns>
        public static SqlConnection getSqlConnection()
        {
            mySqlConnection = new SqlConnection(ConnStr);
            mySqlConnection.Open();
            return mySqlConnection;
        }

        /// <summary>
        /// 建立数据命令对象，设定数据命令类型为存储过程
        /// </summary>
        /// <param name="procName">存储过程名</param>
        /// <param name="conn">连接名</param>
        /// <returns></returns>
        public static SqlCommand getSqlCommand(string procName, SqlConnection conn)
        {
            if (conn.State.ToString() == "Closed")//conn.State.Equals(ConnectionState.Closed)
            {
                conn.Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = conn;
            cmd.CommandText = procName;
            return cmd;
        }

        public static SqlCommand getSqlCommand(string procName, SqlParameter[] prams, SqlConnection conn)
        {
            if (conn.State.ToString() == "Closed")
            {