st_auth.cs

来自「学生选棵系统」· CS 代码 · 共 64 行

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

namespace STGROUP.ST_CourseBiz
{
	/// <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)
		{
			string sqlString  = "select count(*) 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()!="0")
				return true;
			else
				return false;
		}
		/// <summary>
		/// 判断登录类型，1为学生，2为老师，3为管理员
		/// </summary>
		/// <param name="st_name"></param>
		/// <returns></returns>
		public int ST_LoginType(string st_name)
		{
			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")
				return int.Parse(obj.ToString());
			else
				return -1;
		}
		/// <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;
		}
	}
}