user.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections .Generic ;
using System.Data .SqlClient ;

/// <summary>
/// Summary description for User
/// </summary>
namespace BLL {
    public class User
    {
        private static List<User> _userList = new List<User>();
        private int _userId;
        private string _userName;
        private string _password;
        private string _userRole;
        SqlDataReader dr;
        SQLHelper sqlHelper = new SQLHelper();
        public static List<User> UserList
        {
            get
            {
                return _userList;
            }
            set
            {
                _userList = value;
            }

        }

        public int UserId
        {
            get
            {
                return _userId;
            }
            set
            {
                _userId = value;
            }
        }

        public string UserName
        {
            get
            {
                return _userName;
            }
            set
            {
                _userName = value;
            }
        }

        public string Password
        {
            get
            {
                return _password;
            }
            set
            {
                _password = value;
            }
        }
        public string UserRole
        {
            get
            {
                return _userRole;
            }
            set
            {
                _userRole = value;
            }
        }

        public static List<User> GetAllUser()
        {
            _userList.Clear();
            string sql = "select * from Users where UserRole='Normal'";
            SQLHelper sqlHelper = new SQLHelper();
            SqlDataReader dr;
            sqlHelper.RunSQL(sql, out dr);

            while (dr.Read())
            {
                User u = new User();
                u._userId = Convert.ToInt32(dr["UserId"]);
                u._userName = dr["UserName"].ToString();
                u._password = dr["Password"].ToString();
                u._userRole = dr["UserRole"].ToString();
                _userList.Add(u);
            }
            dr.Close();
            return _userList;
        }

        public bool DeleteRelf()
        {
            bool Flag = false;
            string sql = "delete from Users where UserId=" + this._userId;
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;
        }

        public bool UpdateRelf()
        {
            bool Flag = false;
            string sql = string.Format("update Users set UserName='{0}',Password='{1}' where UserId='{2}'", this._userName, this._password, this._userId);
            sqlHelper.RunSQL(sql);
            Flag = true;
            return Flag;
        }

        public int InsertRelf()
        {
            int id = -1;
            SqlParameter[] ParaList ={ 
            sqlHelper .CreateInParam ("@UserName",SqlDbType.VarChar,50,this._userName  ),
            sqlHelper .CreateInParam ("@Password",SqlDbType.VarChar ,50,this._password ),
            sqlHelper .CreateInParam ("@UserRole",SqlDbType.VarChar ,50,this._userRole )
        };

            id = sqlHelper.RunProc("InsertUser", ParaList);
            return id;
        }
        public User()
        {
        }

        public bool IsValidUser() {
            string sql = string.Format("select RowCounts=count(*) from Users where UserName='{0}' and Password='{1}' and UserRole='{2}'", this._userName, this._password, this._userRole);
            sqlHelper.RunSQL(sql, out dr);
            if (dr.HasRows)
            {
                dr.Read();
                int RowCounts = Convert.ToInt32(dr["RowCounts"]);
                dr.Close();
                if (RowCounts >0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else {
                return false;
            }
        }


    }
}