App_Code/DB.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.Sql;
//using System.Data.SqlClient;

using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{//下载于51aspx.com
    #region 公共成员
    //public static SqlConnection sqlconnection;//定义公共成员
    public static readonly string GetStrConn = "DataAccess";//数据库连接字符串
    #endregion

    public DB()
	{
		//下载于51aspx.com
		// TODO: 在此处添加构造函数逻辑
		//下载于51aspx.com
    }
    

    #region 关闭数据库
    /// <summary>
    /// 关闭数据库
    /// </summary>
    /// <param name="_odbCommand">原数据源</param>
    public static void CloseDataBase(DbCommand _odbCommand)
    {
        _odbCommand.Connection.Close();
        _odbCommand.Connection.Dispose();
        _odbCommand.Dispose();
    }
    #endregion

    #region 执行Sql查询语句
    ///<summary>
    /// 执行Sql查询语句 执行成功返回受影响的行数，执行失败返回-1；
    /// </summary>
    /// <param name="strSQL">传入的Sql语句</param>
    /// <returns>返回受影响的行数</returns>
    public static int ExecuteSql(string strSQL)
    {
        Database odbDataBase = DatabaseFactory.CreateDatabase(GetStrConn);
        DbCommand odbCommand = odbDataBase.GetSqlStringCommand(strSQL.ToString());
        
        int result = -1;
        try