user.cs

VSharp学习软件源代码bid示例程序

using System;
using System.Data;
using System.Data.SqlClient;

using Microsoft.ApplicationBlocks.Data;

namespace bid.Entity
{
	/// <summary>
	/// User 的摘要说明。
	/// </summary>
	public class User
	{
		private int _Id;
		private string _Account;
		private string _Password;
		private string _Name;

		public int Id{
			get{
				return _Id;
			}
			set{
				_Id = value;
			}
		}

		public string Account
		{
			get{
				return _Account;
			}
			set{
				_Account = value;
			}
		}

		public string Password
		{
			get{
				return _Password;
			}
			set{
				_Password = value;
			}
		}

		public string Name
		{
			get{
				return _Name;
			}
			set{
				_Name = value;
			}
		}

		public User()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		 
		/// <summary>
		/// 构造函数重载，根据一个帐户名称和密码返回一个用户。
		/// </summary>
		/// <param name="account"></param>
		/// <param name="password"></param>
		public User( string account, string password )
		{
			string SqlString = " SELECT * FROM [User] WHERE account='{0}' AND password='{1}'";
			SqlString = string.Format( SqlString, account, password );
			DataTable tblTemp = SqlHelper.ExecuteDataset( DBUtil.ConnString, CommandType.Text, SqlString).Tables[0];
			if(tblTemp != null )
			{
				if( tblTemp.Rows.Count == 1)
				{
					this._Account	= tblTemp.Rows[0]["account"].ToString();
					this._Name		= tblTemp.Rows[0]["name"].ToString();
					this._Password	= tblTemp.Rows[0]["password"].ToString();
					this._Id		= Convert.ToInt32( tblTemp.Rows[0]["id"]);
				}
			}
		}

		public static User GetUser( int UserId )
		{
			string SqlString = " SELECT * FROM [User] WHERE id = {0}";
			SqlString = string.Format( SqlString, UserId );
			DataTable tblTemp = SqlHelper.ExecuteDataset( DBUtil.ConnString, CommandType.Text, SqlString).Tables[0];
			if(tblTemp != null )
			{
				if( tblTemp.Rows.Count == 1)
				{
					User usr = new User();
					usr.Account		= tblTemp.Rows[0]["account"].ToString();
					usr.Name		= tblTemp.Rows[0]["name"].ToString();
					usr.Password	= tblTemp.Rows[0]["password"].ToString();
					usr.Id			= Convert.ToInt32( tblTemp.Rows[0]["id"]);
					return usr;
				}
				return null;
			}
			return null;
		}

		/// <summary>
		/// 注册一个新的用户
		/// </summary>
		/// <param name="account">帐号</param>
		/// <param name="password">密码</param>
		/// <param name="Name">姓名</param>
		/// <returns></returns>
		public string RegUser( string account, string password, string name )
		{


			string SqlString = "User_Register";
			SqlCommand cmd = new SqlCommand();
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.CommandText = SqlString;
			SqlParameterCollection prms = cmd.Parameters;

			prms.Add("@account", SqlDbType.VarChar,50);
			prms.Add("@password", SqlDbType.VarChar,20);
			prms.Add("@name", SqlDbType.NVarChar,20);

			prms["@account"].Value = account;
			prms["@password"].Value = password;
			prms["@name"].Value = name;
			
			try
			{
				cmd.Connection = new SqlConnection( DBUtil.ConnString );
				cmd.Connection.Open();
				int result = cmd.ExecuteNonQuery();
				cmd.Connection.Close();

				return result.ToString();
			}
			catch( Exception ex )
			{
				return ex.Message;
			}
			finally
			{
				if( cmd.Connection.State !=  ConnectionState.Closed ) 
					cmd.Connection.Close();
			}
		}
	}
}