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

namespace WindowsApplication4
{
	/// <summary>
	/// Class1 的摘要說明。
	/// </summary>
	public class LonIn
	{
		private string _UserID;
		private string _PassWord;
		public static string Group;
		private DataRow userRow;
		public string UserID//ID屬性
		{
			get
			{
				return _UserID;
			}
			set
			{
				_UserID = value;
			}
		}
		public string PassWord//PassWord屬性
		{
			get
			{
				return _PassWord;
			}
			set
			{
				_PassWord = value;
			}
		}
		public LonIn(string UserID,string Password)
		{
		this.UserID = UserID;
		this.PassWord = PassWord;
			//
			// TODO: 在此處添加構造函數(shù)邏輯
			//
		}
		public LonIn()
		{
		}
		public int isUser()
		{
			SqlConnection SqlCon = new SqlConnection();
			SqlCommand LogInCommand= new SqlCommand();
			SqlDataAdapter userAdapter = new SqlDataAdapter();
			DataSet UserInfoSet = new DataSet();
			try
			{
				SqlCon.ConnectionString = "server=.;Trusted_Connection=yes;user=sa;pwd=1;database=storage";//連接字段
				LogInCommand.Connection = SqlCon;
				LogInCommand.CommandText = "SELECT UserID,Password,GroupID From LonInFrm" ;
				userAdapter.SelectCommand = LogInCommand;
				userAdapter.SelectCommand.Connection=SqlCon;
				SqlCon.Open();
				userAdapter.Fill(UserInfoSet,"UserInfo");//填充數(shù)據(jù)集
				for (int i=0;i<UserInfoSet.Tables["UserInfo"].Rows.Count;i++)
				{
					this.userRow=UserInfoSet.Tables["UserInfo"].Rows[i];
					//只有當輸入的用戶名和密碼同時對應上數(shù)據(jù)庫中記錄時，才能通過校驗
					if (userRow[0].ToString().Trim()==this.UserID.Trim() && userRow[1].ToString().Trim()==this.PassWord.Trim())
					{					
						Group=userRow[2].ToString().Trim();
						return 1;

					}
				}
				return 0;
				}
			
			catch(Exception ex)
			{
				throw new ApplicationException("SysTem Err");
			}
		}
	}
}