App_Code/DBHelper.cs

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

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

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)

/// <summary>
/// Copyright (C) 2004-2008 LiTianPing 
/// 数据访问基础类(基于SQLServer)
/// 用户可以修改满足自己项目的需要。
/// </summary>
public abstract class DbHelperSQL
{
    //数据库连接字符串(web.config来配置)
    //<add key="ConnectionString" value="server=127.0.0.1;database=DATABASE;uid=sa;pwd=" />		
    //protected static string connectionString = ConfigurationSettings.AppSettings["ConnectionString"];
    protected static string connectionString = ConfigHelper.GetValueByKey("Mag_Role_ConnectionString");

    //protected static string connectionString = "Server=.;DataBase=51aspx;UID=sa;PWD=;";
    public DbHelperSQL()
    {
    }

    #region 公用方法

    public static int GetMaxID(string FieldName, string TableName)
    {
        string strsql = "select max(" + FieldName + ")+1 from " + TableName;
        object obj = GetSingle(strsql);
        if (obj == null)
        {
            return 1;
        }
        else
        {
            return int.Parse(obj.ToString());
        }
    }
    public static bool Exists(string strSql, params SqlParameter[] cmdParms)
    {
        object obj = GetSingle(strSql, cmdParms);
        int cmdresult;
        if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
        {
            cmdresult = 0;
        }
        else
        {
            cmdresult = int.Parse(obj.ToString());
        }
        if (cmdresult == 0)
        {
            return false;
        }
        else
        {
            return true;