App_Code/CMMgr.cs

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

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

using System;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Data.SqlClient;
using System.IO;
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>
/// 此类包含一些操作数据库的方法
/// </summary>
public class CMMgr
{
    
	#region 定义CMMgr类的私有变量
	private SqlCommand m_Cmd = null;
	private SqlConnection m_Conn = null;
	private SqlDataAdapter m_daTer = null;
	private SqlTransaction m_Trans = null;
	#endregion

	#region CMMgr类的静态函数
	/// <summary>
	/// 返回数据库连接字符串
	/// </summary>
	static public string GetConnectionString()
	{
        string LinkString = "";        
        LinkString = WebConfigReader.GetDatabaseString();
        return LinkString;
	}

    /// <summary>
    /// 返回数据库连接字符串
    /// </summary>
    /// <param name="strLinkString">数据库连接字符串</param>
    /// <returns>数据库连接字符串</returns>
    static public string GetConnectionString(string LinkString)
    {
        return LinkString;
    }

	/// <summary>
	/// 返回某一数据库中的编号
	/// </summary>
	/// <param name="sysid">主键编号</param>
	/// <returns></returns>
	static public int GetNextIDValue(string sysid)
	{
		int intPrimary = (int)CMMgr.GetDataTable("SELECT " + sysid + " FROM Sys_FieldID").Rows[0][sysid];
		ExecuteNonQuery("UPDATE Sys_FieldID SET " + sysid + "=" + sysid + "+1");
		return intPrimary;
	}

	/// <summary>