user.cs

很不错的学生管理系统

using System;
using System.Data;
using System.Collections;
using System.Data.SqlClient;
using es_data = com.egt.data;

namespace com.egt.business
{
	/// <summary>
	/// 用户信息
	/// </summary>
	public class User
	{
        /*
    * 编码人员：胡鹏飞
    * 
    * 编码时间：2007-9-27
    * 
    * 内容：登陆类
    */
        private Hashtable htrole;
        private DataSet ds;
		private SqlParameter[] para;
        private int _id;
        private string _landnames = string.Empty;
        private string _password = string.Empty;
        private int _classid;
        private string _classname = string.Empty;
        private string _names = string.Empty;
        private string _sex = string.Empty;
        private string _address = string.Empty;
        private string _phone = string.Empty;
        private string _schoolname = string.Empty;
        private string _state = string.Empty;
        private string _rolenames = string.Empty;
        private int _roleid;


		/// <summary>
		/// 登陆判断,添加权限
		/// </summary>
		/// <param name="yhm"></param>
		/// <param name="mm"></param>
		public User(string yhm,string mm)
		{
			htrole = new Hashtable();
            para = new SqlParameter[2];
            para[0] = es_data.DataBaseAdmin.MakeInParam("@varlandname", SqlDbType.VarChar, 30, yhm);
            para[1] = es_data.DataBaseAdmin.MakeInParam("@varpassword", SqlDbType.VarChar, 30, mm);
            ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_users_select", para);
			if (ds.Tables[0].DefaultView.Count!=0)
			{
                #region 获取学员信息
                this.id = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
                this.classid = Convert.ToInt32(ds.Tables[0].Rows[0]["classid"].ToString());
                this._classname = ds.Tables[0].Rows[0]["classnames"].ToString();
                this.names = ds.Tables[0].Rows[0]["names"].ToString();
                this.sex = ds.Tables[0].Rows[0]["sex"].ToString();
                this.address = ds.Tables[0].Rows[0]["address"].ToString();
                this.phone = ds.Tables[0].Rows[0]["phone"].ToString();
                this.schoolname = ds.Tables[0].Rows[0]["schoolname"].ToString();
                this.state = ds.Tables[0].Rows[0]["state"].ToString();
                #endregion

                //获取角色
                para = new SqlParameter[1];
                para[0] = es_data.DataBaseAdmin.MakeInParam("@intid", SqlDbType.VarChar, 30, this.id);
                ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_role_select", para);
                if (ds != null)
                {
                    this.roleid = Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString());
                    this.rolenames = ds.Tables[0].Rows[0]["names"].ToString();
                    //获取权限
                    para = new SqlParameter[1];
                    para[0] = es_data.DataBaseAdmin.MakeInParam("@introleid", SqlDbType.VarChar, 30, this.roleid);
                    ds = es_data.DataBaseAdmin.ExecuteDataSet("sp_popedom_select", para);
                    if (ds != null)
                    {
                        htrole.Add(this.roleid, ds);
                    }
                }
			}
			
		}
		/// <summary>
		/// 返回权限信息
		/// </summary>
		/// <returns></returns>
		public Hashtable addpop()
		{
			return htrole;
		}

		/// <summary>
		/// 判断是否成功登陆
		/// </summary>
		/// <returns></returns>
		public int passdeng()
		{
			if(ds.Tables[0].Rows.Count!=0)
			{
				return 1;
			}
			else
				return 0;
		}
		/// <summary>
        /// <summary>
        /// 标识
        /// </summary>
        public int id
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 登陆名
        /// </summary>
        public string landnames
        {
            set { _landnames = value; }
            get { return _landnames; }
        }
        /// <summary>
        /// 密码
        /// </summary>
        public string password
        {
            set { _password = value; }
            get { return _password; }
        }
        /// <summary>
        /// 班级编号
        /// </summary>
        public int classid
        {
            set { _classid = value; }
            get { return _classid; }
        }
        /// <summary>
        /// 姓名
        /// </summary>
        public string names
        {
            set { _names = value; }
            get { return _names; }
        }
        /// <summary>
        /// 性别
        /// </summary>
        public string sex
        {
            set { _sex = value; }
            get { return _sex; }
        }
        /// <summary>
        /// 地址
        /// </summary>
        public string address
        {
            set { _address = value; }
            get { return _address; }
        }
        /// <summary>
        /// 电话
        /// </summary>
        public string phone
        {
            set { _phone = value; }
            get { return _phone; }
        }
        /// <summary>
        /// 学历
        /// </summary>
        public string schoolname
        {
            set { _schoolname = value; }
            get { return _schoolname; }
        }
        /// <summary>
        /// 状态
        /// </summary>
        public string state
        {
            set { _state = value; }
            get { return _state; }
        }

        /// <summary>
        /// 班级名称
        /// </summary>
        public string classname
        {
            set { _classname = value; }
            get { return _classname; }
        }
        
            /// <summary>
        /// 班级名称
        /// </summary>
        public string rolenames
        {
            set { _rolenames = value; }
            get { return _rolenames; }
        }

        /// <summary>
        /// <summary>
        /// 标识
        /// </summary>
        public int roleid
        {
            set { _roleid = value; }
            get { return _roleid; }
        }
	}
}