user.cs

来自「ThreeLayer有关详细信息」· CS 代码 · 共 124 行

using System;
using System.Collections;
using ThreeLayer.Model.Sys;

namespace ThreeLayer.DAL.Sys
{
	/// <summary>
	/// User 的摘要说明。
	/// </summary>
	public class User
	{
		private const string Model_ClassName="ThreeLayer.Model.Sys.UserInfo"; // 用户维护实体类名

		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝==  
		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝列表函数＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝== 

		/// <summary>
		/// 获得用户维护单页列表
		/// </summary>
		/// <param name="int_PageSize">一页显示的记录数</param>
		/// <param name="int_CurrentPageIndex">当前页码</param>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public IList GetUsers(int int_PageSize,int int_CurrentPageIndex,Hashtable ht) 
		{
			return Data.GetPageList(Data.conn_Default,int_PageSize,int_CurrentPageIndex,"[User]",null,null,ht,Model_ClassName);
		}
		/// <summary>
		/// 获得用户维护总记录数
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public int GetUsersCount(Hashtable ht) 
		{
			return Data.GetRsCount(Data.conn_Default,"[User]",null,ht);
		}

		/// <summary>
		/// 获得用户维护全部列表
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public IList GetUsers(Hashtable ht) 
		{
			return Data.GetPageList(Data.conn_Default,0,0,"[User]",null,null,ht,Model_ClassName);
		}
		
		/// <summary>
		/// 获得一个用户维护详细信息
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public UserInfo GetUserDetail(Hashtable ht) 
		{
			return (UserInfo)Data.GetDetail(Data.conn_Default,"[User]","id=@Id",ht,Model_ClassName);
		}

		/// <summary>
		/// 通过帐号获得一个用户维护详细信息
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public UserInfo GetUserDetailByUserId(Hashtable ht) 
		{
			return (UserInfo)Data.GetDetail(Data.conn_Default,"[User]","User_Id=@User_Id",ht,Model_ClassName);
		}

		
		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝==  
		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝数据操作函数＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
		//　＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝==
		
		/// <summary>
		/// 增加记录时判断帐号是否重复
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public int GetAddUsersCount(Hashtable ht)
		{
			return Data.GetRsCount(Data.conn_Default,"[User]","User_Id=@User_Id",ht);
		}
		/// <summary>
		/// 修改记录时判断帐号是否重复
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		/// <returns></returns>
		public int GetEditUsersCount(Hashtable ht)
		{
			return Data.GetRsCount(Data.conn_Default,"[User]","User_Id=@User_Id and Id<>@Id",ht);
		}

		/// <summary>
		/// 增加记录
		/// </summary>
		/// <param name="ht">字段,字段值参数</param>
		public void Insert(Hashtable ht) 
		{
			// ＝＝＝获得最大Id值并修改哈希表Id键值＝＝＝
			ht["Id"]=Data.GetMaxId(Data.conn_Default,"Id","[User]")+1;
			// ＝＝＝插入操作＝＝＝
			Data.Insert(Data.conn_Default,"[User]",ht); 
		}

        /// <summary>
		///  修改记录
		/// </summary>
		/// <param name="User">字段,字段值参数</param>
		public void Update(Hashtable ht) 
		{
			Data.Update(Data.conn_Default,"[User]","Id=@Id",ht); 
		}
		/// <summary>
		///  用户验证
		/// </summary>
		/// <param name="User">字段,字段值参数</param>
		public int UserValidate(Hashtable ht) 
		{
			return Data.GetRsCount(Data.conn_Default,"[User]","User_Id=@User_Id and Password=@Password",ht);
		}
		 
	}
}