DAO/SqlBase.cs

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

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

using System;
using System.Data;
using System.Data .SqlClient ;
using System.Configuration ;
using System.Diagnostics ;
using System.Xml;
using System.IO;

namespace LaboratoryOrder.DataBase
{
	/// <summary>
	/// Author	: GuoGuo
	/// Data	: 2006-07
	/// Description	: database operate class
	/// </summary>
	public sealed class SqlBase
	{
		/// <summary>
		/// <param name="connectionString"></param>
		/// </summary>
        private static string connectionString = null;
        // 下载于www.51aspx.com
		public static string ConnectionString
		{
			get
			{
                if (connectionString == null)
                {
                    string connString = System.Configuration.ConfigurationManager.AppSettings["ConnString"];

                    return connString;
                }
                else
                {
                    return SqlBase.connectionString;
                }
			}
			set
            {
                SqlBase.connectionString = value;
            }
		}

		/// <summary>
		/// get the connect object
		/// </summary>
		/// <returns></returns>
		public static SqlConnection GetConnection()
		{
			return new SqlConnection(ConnectionString);
		}


		#region SqlDataReader Method
		/// <summary>
		/// use datareader to get the data from database
		/// </summary>
		/// <param name="con">database connection object</param>
		/// <param name="sql">procedure name or sql expression</param>
		/// <returns>DataReader object</returns>