cscomponent.cs

ASP.net动画教程

using System;
using System.Data;
using System.Data.OleDb;
namespace AspcnValidate
{
	public class Validate
	{
		private string _Step,_Email,_Age,_HomePage;
		//定义类的属性
		public string Step
		{
			get{return _Step;}
		}
		public string Email
		{
			get{return _Email;}
		}
		public string Age
		{
			get{return _Age;}
		}
		public string HomePage
		{
			get{return _HomePage;}
		}
		//定义验证函数
		public string ValidateUser(params string[] UserInfo)
		{
			//传递参数个数少于2，则返回错误
			if(UserInfo.Length<2) return "Error:Needs More Parameters";
			string strProvider = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\清华大学出版社\\Samples\\DataBase\\db1.mdb;";
			string UserName = UserInfo[0];
			string Password = UserInfo[1];
			//访问数据库首先验证密码的正确性
			OleDbConnection MyConn = new OleDbConnection(strProvider);
			string strSelect = "select * from UserValidate where UserName='"+UserName+"'";
			OleDbCommand MyComm = new OleDbCommand(strSelect,MyConn);
			MyComm.Connection.Open();
			OleDbDataReader MyDataReader = MyComm.ExecuteReader();
			if(MyDataReader.Read())
			{
				//验证密码
				if((string)MyDataReader["Password"]!=Password)
				{
					return "错误：密码不正确";
				}
				//接下来验证是否为第一次使用，如果是则需要输入验证号
				if((int)MyDataReader["Step"]<1)
				{
					try
					{
						int ValidateCode = Int32.Parse(UserInfo[2]);
						if((int)MyDataReader["ValidateCode"]!=ValidateCode)
						{
							//验证号不正确
							return "错误：验证号不正确";
						}
					}
					catch(Exception e)
					{
						return "错误：您为第一次登陆需要验证号";
					}
				}
				//所有的都正确
				_Step		= ((int)MyDataReader["Step"]+1).ToString();
				_Email		= MyDataReader["Email"].ToString();
				_Age		= MyDataReader["Age"].ToString();
				_HomePage	= MyDataReader["HomePage"].ToString();
				MyComm.Connection.Close();
				//更新Step字段值
				string strUpdate = "Update UserValidate Set Step=Step+1 Where UserName='"+UserName+"'";
				OleDbCommand UpdateComm = new OleDbCommand(strUpdate,MyConn);
				UpdateComm.Connection.Open();
				UpdateComm.ExecuteNonQuery();
				UpdateComm.Connection.Close();
				return "Succeed";
			}
			else
			{
				//不成功
				return "错误：用户名不存在";
			}
		}
	}
}