using System;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.SessionState;

namespace ST_GROUP
{
	/// <summary>
	/// ST_PageBase 的摘要說明。
	/// </summary>
	public class ST_PageBase:System.Web.UI.Page
	{   
		public ST_PageBase()
		{
			//
			// TODO: 在此處添加構造函數邏輯
			//
		}

		private static string UrlSuffix
		{
			get
			{
				return HttpContext.Current.Request.Url.Host + HttpContext.Current.Request.ApplicationPath;
			}
		}
		/// <value>
		///UrlBase is used to get the prefix for URLs
		/// </value>
		public static String UrlBase
		{
			get
			{  
				return @"http://" + UrlSuffix; 
			}
		}

	//	public static string UserType;
		
		public static bool CheckUser(string name,string pwd)
		{
			bool authenticated = false;
			//從文件Web.config中讀取連接字符串
			string ST_sqldb= ConfigurationSettings.AppSettings["ConnectionString"];
			//創建Command對象
			SqlCommand ST_mycommand = new SqlCommand();
			//連接ST_GinShopManage數據庫
			ST_mycommand.Connection=new SqlConnection(ST_sqldb);
			try
			{
				ST_mycommand.Connection.Open();
				//調用存儲過程ST_ValidateUser檢驗帳戶的有效性
				ST_mycommand.CommandText="ST_ValidateUser";
				ST_mycommand.CommandType=CommandType.StoredProcedure;
			   
				SqlParameter Name=new SqlParameter("@name",SqlDbType.NVarChar,20);
				Name.Value=name.Trim();
				ST_mycommand.Parameters.Add(Name);
				
				SqlParameter Password=new SqlParameter("@pwd",SqlDbType.NVarChar,15);
				Password.Value=pwd.Trim();
				ST_mycommand.Parameters.Add(Password);
                
				SqlParameter IsValid=new SqlParameter("@IsValid",SqlDbType.Int);
				IsValid.Direction=ParameterDirection.Output;
				ST_mycommand.Parameters.Add(IsValid);
           
				ST_mycommand.ExecuteNonQuery();
				if(((int)IsValid.Value)==1)
				{
					//帳戶有效
					authenticated=true;  
				}
			}
			catch(Exception exc)
			{
				throw(exc);
			}
			finally
			{
				ST_mycommand.Connection.Close();
			}
			//返回布爾值
			return authenticated;
		}

	}
}