Data/SqlHelper.cs

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

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

/**********************************************
 * 类作用：   MSSQL访问基础类
 * 建立人：   abaal
 * 建立时间： 2008-09-03 
 * Copyright (C) 2007-2008 abaal
 * All rights reserved
 * http://blog.csdn.net/abaal888
 ***********************************************/

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Collections.Specialized;
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;

/// <summary>
/// 数据访问基础类(基于SQLServer)
/// </summary>
public abstract class SqlHelper
{
    //数据库连接字符串(web.config来配置)
    //<add key="ConnectionString" value="Data Source=CHF;Initial Catalog=JGXT;User ID=sa" />  
    //public static readonly string connectionString = ConfigurationSettings.AppSettings["JGXTConnectionString"];
    public static readonly string connectionString = ConfigurationManager.ConnectionStrings["strProvider"].ConnectionString;
    public SqlHelper()
    {

    }

    /// <summary>
    /// 获取表某个字段的最大值(增加于2006年9月13日)
    /// </summary>
    /// <param name="FieldName"></param>
    /// <param name="TableName"></param>
    /// <returns></returns>
    public static int GetMaxID(string FieldName, string TableName)
    {
        //string strSql = "select count(" + FieldName + ") from " + TableName;
        string strSql = "select max(" + FieldName + ") from " + TableName;
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            using (SqlCommand cmd = new SqlCommand(strSql, connection))
            {
                try
                {
                    connection.Open();
                    object obj = cmd.ExecuteScalar();
                    if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
                    {

                        return 1;

                    }