using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_ExamBiz
{
	/// <summary>
	/// ST_User 的摘要說明。
	/// </summary>
	public class ST_User
	{
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		public ST_User()
		{
			//
			// TODO: 在此處添加構(gòu)造函數(shù)邏輯
			//
		}

		/// <summary>
		/// 插入用戶基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertUserInfo(string ST_Name, string ST_Pass, out int ST_Userid)
		{
			string sqlString = "insert ST_Users(ST_Name,ST_Pass,ST_Type) values('"+ST_Name+"','"+ST_Pass+"','User');select scope_identity();";
			object obj = SqlHelper.ExecuteScalar(st_SqlString, CommandType.Text, sqlString);
			ST_Userid = int.Parse(obj.ToString());
		}

        /// <summary>
        /// 判斷用戶是否重復(fù)
        /// </summary>
        /// <param name="st_StuInfo"></param>
        public bool ST_IsUserExist(string ST_Name)
        {
            string sqlString = "select count(ST_Userid) from ST_Users where ST_Name='" + ST_Name + "'";
            object obj = SqlHelper.ExecuteScalar(st_SqlString, CommandType.Text, sqlString);
            if (obj != null && obj.ToString() != "0") 
            {
                return true;
            }
            else
            {
                return false;
            }
        }

		/// <summary>
		/// 修改用戶基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateUserInfo(string ST_Pass, int ST_UserID)
		{
			string sqlString = "update ST_Users set ST_Pass='"+ST_Pass+"' where ST_UserID="+ST_UserID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 取得用戶的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetUserInfo(int ST_UserID)
		{
			string sqlString = "select * from ST_Users where ST_UserID="+ST_UserID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
	}
}