systemaccess.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

///////////////////////////////////////////////////////////
//  SystemAccess.cs
//  Implementation of the Class SystemAccess
//  Generated by Enterprise Architect
//  Created on:      07-五月-2006 14:01:00
///////////////////////////////////////////////////////////




using BookShop.Entity;
using System.Data.SqlClient;
using System.Data;
using System;
namespace BookShop.DataAccess {
	/// <summary>
	/// 与系统设置有关的数据操作
	/// </summary>
	public class SystemAccess {

		public SystemAccess(){

		}

		~SystemAccess(){

		}

		public virtual void Dispose(){

		}

		/// <summary>
		/// 添加新的设置键值
		/// </summary>
		/// <param name="system"></param>
		public bool AddSetting(SystemEntity system){
   if (IsKeyExist(system.Key))
    return ModifySetting(system);
   else
   {
    SqlParameter[] parms = new SqlParameter[]{
     new SqlParameter("@Key",SqlDbType.NVarChar,50),
     new SqlParameter("@Value",SqlDbType.NText)
    };
    parms[0].Value = system.Key;
    parms[1].Value = system.Value;

    if (DbTools.ExectueNoQuery("AddSetting", parms) > 0)
     return true;
    else
     return false;
  }
		}

		/// <summary>
		/// 根据键值获取设置值
		/// </summary>
		/// <param name="key"></param>
		public string GetSettingByKey(string key){
   SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@Key",SqlDbType.NVarChar,50)
   };
   parms[0].Value = key;
   DataSet ds = DbTools.ExecuteQuery("GetSettingByKey", parms);
   if (ds.Tables[0].Rows.Count != 0)
    return Convert.ToString(ds.Tables[0].Rows[0]["SsValue"]);
   else
    return null;
		}

		/// <summary>
		/// 检查指定键值是否存在
		/// </summary>
		/// <param name="key"></param>
		public bool IsKeyExist(string key){
   SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@Key",SqlDbType.NVarChar,50)
   };
   parms[0].Value = key;
   DataSet ds = DbTools.ExecuteQuery("GetSettingByKey", parms);
   if (ds.Tables[0].Rows.Count != 0)
    return true;
   else
    return false;
		}

		/// <summary>
		/// 修改键值对
		/// </summary>
		/// <param name="system"></param>
		public bool ModifySetting(SystemEntity system){
   SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@Key",SqlDbType.NVarChar,50),
    new SqlParameter("@Value",SqlDbType.NText)
   };
   parms[0].Value = system.Key;
   parms[1].Value = system.Value;

   if (DbTools.ExectueNoQuery("ModifySetting", parms) > 0)
    return true;
   else
    return false;
		}

	}//end SystemAccess

}//end namespace DataAccess