st_auth.cs

数据库：Microsoft SQL Server 2000。 技术平台：Microsoft .NET Framework 2.0.0.0版本。 IIS：Internet Informati

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

namespace STGROUP.ST_ExamBiz
{
	/// <summary>
	/// 身份验证。
	/// </summary>
	public class ST_Auth
	{
		public ST_Auth()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
		/// <summary>
		/// 判断用户名和密码是否正确
		/// </summary>
		/// <param name="st_name"></param>
		/// <param name="st_pass"></param>
		/// <returns></returns>
		public bool ST_Login(string st_name, string st_pass, out int userid)
		{
			userid = 0;
			string sqlString  = "select st_userid from sT_Users where st_name='"+st_name+"' and st_pass='"+st_pass+"'";
			object obj = SqlHelper.ExecuteScalar(st_SqlString,CommandType.Text, sqlString);
			if(obj!=null && obj.ToString()!="")
			{
				userid = int.Parse(obj.ToString());
				return true;
			}
			else
				return false;
		}
		/// <summary>
		/// 判断登录类型，Admin和User
		/// </summary>
		/// <param name="st_name"></param>
		/// <returns></returns>
		public string[] ST_LoginType(string st_name)
		{
			string[] str = new string[1];
			string sqlString  = "select st_type from ST_Users where st_name='"+st_name+"'";
			object obj = SqlHelper.ExecuteScalar(st_SqlString,CommandType.Text, sqlString);
			if(obj!=null && obj.ToString()!="0")
			{
				str[0] = obj.ToString();
			}
			return str;
		}
		/// <summary>
		/// 取得登录的ID
		/// </summary>
		/// <param name="st_name"></param>
		/// <returns></returns>
		public int ST_LoginID(string st_name)
		{
			string sqlString  = "select st_id from sT_Users where st_name='"+st_name+"'";
			object obj = SqlHelper.ExecuteScalar(st_SqlString,CommandType.Text, sqlString);
			if(obj!=null && obj.ToString()!="0")
				return int.Parse(obj.ToString());
			else
				return -1;
		}
	}
}