www.pudn.com > FerrariSystem.rar > BisLogin.cs

using System; 
using System.Data; 
using System.Data.SqlClient; 
using System.Text; 
 
namespace DataAccessLibrary 
{ 
	/// 
 
	/// BisLogin 的摘要说明。 
	/// 
 
	public class BisLogin:BisBase 
	{ 
		public DataTblUser objTblUser = null; 
 
		public BisLogin() 
		{ 
		 
		} 
 
		/// 
 
		/// 验证登陆 
		/// 
 
		///  
		///  
		public bool DoLogin() 
		{ 
			StringBuilder strBuilder = new StringBuilder(); 
			strBuilder.Append(" select 1 from TBL_User"); 
			strBuilder.Append(" where UserID = @UserID and Password = @Password and UserType = @UserType"); 
			string strSql = strBuilder.ToString(); 
 
			SqlParameter[] param = this.getSqlParameter(); 
			SqlDataReader sqlReader = SqlHelper.ExecuteReader(this.strConnString,CommandType.Text,strSql,param); 
			if (sqlReader.HasRows) 
			{ 
				return true; 
			} 
			else 
			{ 
				return false; 
			} 
		} 
 
		/// 
 
		/// 将数据模型对象映射到Command命令所用的SqlParameter对象 
		/// 
 
		///  
		private SqlParameter[] getSqlParameter() 
		{ 
			SqlParameter[] param = new SqlParameter[3]; 
			param[0] = new SqlParameter("@UserID",SqlDbType.VarChar); 
			param[1] = new SqlParameter("@Password",SqlDbType.VarChar); 
			param[2] = new SqlParameter("@UserType",SqlDbType.Char); 
 
			param[0].Value = objTblUser.UserID; 
			param[1].Value = objTblUser.Password; 
			param[2].Value = objTblUser.UserType; 
 
			return param; 
		} 
 
		 
	} 
}