App_Code/DAO/DbHelperSQL.cs

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

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

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
    /// <summary>
    /// 数据访问抽象基础类
    /// Copyright (C) 2004-2008 By LiTianPing 
    /// </summary>
    public abstract class DbHelperSQL
    {
        //数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库.		
        public static string connectionString = ConnectionString;
        public DbHelperSQL()
        {            
        }

        private static string _connectionString;

        public static string ConnectionString
        {
            get
            {
                if (!object.Equals(null, _connectionString) && !"".Equals(_connectionString))
                {
                    return _connectionString;

                }
                _connectionString = ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["dbType"]].ToString();
                _connectionString = _connectionString.Replace("[DATAPATH]", CSA.HC.Common.getPhyPath());
                return _connectionString;
            }
            set { _connectionString = value; }
        }



        #region 公用方法
        /// <summary>
        /// 判断是否存在某表的某个字段
        /// </summary>
        /// <param name="tableName">表名称</param>
        /// <param name="columnName">列名称</param>
        /// <returns>是否存在</returns>
        public static bool ColumnExists(string tableName, string columnName)
        {
            string sql = "select count(1) from syscolumns where [id]=object_id('" + tableName + "') and [name]='" + columnName + "'";
            object res = GetSingle(sql);
            if (res == null)
            {
                return false;
            }
            return Convert.ToInt32(res) > 0;
        }
        public static int GetMaxID(string FieldName, string TableName)
        {
            string strsql = "select max(" + FieldName + ")+1 from " + TableName;