bislogin.cs

一个网页的系统例子

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

namespace DataAccessLibrary
{
	/// <summary>
	/// BisLogin 的摘要说明。
	/// </summary>
	public class BisLogin:BisBase
	{
		public DataTblUser objTblUser = null;

		public BisLogin()
		{
		
		}

		/// <summary>
		/// 验证登陆
		/// </summary>
		/// <param name="objTblUser"></param>
		/// <returns></returns>
		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;
			}
		}

		/// <summary>
		/// 将数据模型对象映射到Command命令所用的SqlParameter对象
		/// </summary>
		/// <returns></returns>
		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;
		}

		
	}
}