homeadmintask.cs

该项目中对 SQLHelper 类进行了简单封装

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

using System;
using System.Collections.Generic;
using System.Data.Linq;
using System.Linq;

using NET.AfritXia.MyHome.DBTask.Definition;
using NET.AfritXia.MyHome.DBTask.SQLServer2005.Entity;

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

			// 创建数据上下文
			DataContext dataCtx = new DataContext(ConnectionFactory.CreateConnection());

			// 获取数据表
			var genericDataTable = dataCtx.GetTable<GenericDataEntity>();

			// 创建查询
			var query = (from genData in genericDataTable 
				where genData.DataName == "AdminName" || genData.DataName == "AdminPassWord" select genData);

			// 获取数据实体集合
			IList<GenericDataEntity> genDataEntities = query.ToList();

			foreach (GenericDataEntity gde in genDataEntities)
			{
				if (gde.DataName == "AdminName")
					nickNameInDB = gde.DataValue;
				else if (gde.DataName == "AdminPassWord")
					md5pwdInDB = gde.DataValue;
			}

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