homeadmintask.cs

来自「该项目中对 SQLHelper 类进行了简单封装」· CS 代码 · 共 45 行

/* 
 * HomeAdminTask.cs @Microsoft Visual Studio 2008 <.NET Framework 3.5>
 * AfritXia
 * 2007-12-13
 * 
 * Copyright(c) http://www.AfritXia.NET/
 * 
 */

using System;
using System.Data.OleDb;

using NET.AfritXia.MyHome.DBTask.Definition;

namespace NET.AfritXia.MyHome.DBTask.Access2000
{
	/// <summary>
	/// 网站管理员任务实现类
	/// </summary>
	public partial class HomeAdminTask : DBTaskBase, IHomeAdminTask
	{
		#region IHomeAdminTask 成员
		public bool LoginValidate(string nickName, string md5pwd)
		{
			string nickNameInDB = null;
			string md5pwdInDB = null;

			using (OleDbDataReader dr = CustomSQLHelper.ExecuteReader(SQL_Login))
			{
				while (dr.Read())
				{
					string dataName = Convert.ToString(dr["DataName"]);

					if (dataName == "AdminName")
						nickNameInDB = Convert.ToString(dr["DataValue"]);
					else if (dataName == "AdminPassWord")
						md5pwdInDB = Convert.ToString(dr["DataValue"]);
				}
			}

			return (nickName == nickNameInDB) && (md5pwd == md5pwdInDB);
		}
		#endregion
	}
}