userinfo.cs

网开商城系统网开商城系统网开商城系统网开商城系统

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.Data.SqlClient;

/// <summary>
/// UserInfo 的摘要说明
/// </summary>
public class UserInfo
{
    
    #region 私有字段和属性
    private int _id;

    public int ID
    {
        get { return _id; }
        set { _id = value; }
    }
    private string _people;

    public string People
    {
        get { return _people; }
        set { _people = value; }
    }
    private string _pwd;

    public string Pwd
    {
        get { return _pwd; }
        set { _pwd = value; }
    }
    private string _email;

    public string Email
    {
        get { return _email; }
        set { _email = value; }
    }
	
    private string _name;

    public string Name
    {
        get { return _name; }
        set { _name = value; }
    }
    private string _address;

    public string Address
    {
        get { return _address; }
        set { _address = value; }
    }
    private string _phone;

    public string Phone
    {
        get { return _phone; }
        set { _phone = value; }
    }
    private DateTime _regtime;

    public DateTime Regtime
    {
        get { return _regtime; }
        set { _regtime = value; }
    }
	
#endregion 
    #region 构造器
    public UserInfo(SqlDataReader dr)
    {
        this._id = Convert.ToInt32(dr["id"]);
        this._people = Convert.ToString(dr["people"]);
        this._pwd = Convert.ToString(dr["pwd"]);
        this._email = Convert.ToString(dr["email"]);
        this._name = Convert.ToString(dr["name"]);
        this._address = Convert.ToString(dr["address"]);
        this._phone = Convert.ToString(dr["phone"]);
        this._regtime = Convert.ToDateTime(dr["regtime"]);
       
    }	
	public UserInfo()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
    }
    #endregion
    #region 判断添加的用户是否存在
    /// <summary>
    ///  判断添加的用户是否存在
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public bool ExistsAddUser(string people)
    {
        string proanme = "CheckUser";
        Database exeScalar = new Database();
        bool end = false;
        SqlParameter[] param ={ Database.CreateInParam("@people", SqlDbType.NVarChar, 80, people)};
        try
        {
            int result = exeScalar.GetScalar(proanme, param, 1);
            if (result > 0)
                end = true;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
       
        return end;
    }
    #endregion
    #region 显示全部用户
    public DataTable getall()
    {
        Database gettable = new Database();
        try
        {
            return (gettable.GetTable("GetAllUser", null, "Manager", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }

      #endregion
    #region 增加用户
    /// <summary>
    /// 增加用户
    /// </summary>
    /// <param name="UserInfo">UserInfo实例</param>
    /// <returns></returns>
    public int adduserionfo(UserInfo userinfo)
    {
        string proanme = "AddUser";
        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@people", SqlDbType.NVarChar, 50, userinfo.People),
                               Database.CreateInParam("@pwd",SqlDbType.NVarChar,50,userinfo.Pwd),
                               Database.CreateInParam("@email",SqlDbType.NVarChar,50,userinfo.Email),
                               Database.CreateInParam("@name",SqlDbType.NVarChar,50,userinfo.Name),
                               Database.CreateInParam("@address",SqlDbType.NVarChar,50,userinfo.Address),
                               Database.CreateInParam("@phone",SqlDbType.NVarChar,50,userinfo.Phone) };
        try
        {
            return (exe.execute(proanme, param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 判断用户登陆
    /// <summary>
    /// 判断用户是否存在
    /// </summary>
    /// <param name="UserInfo">UserInfo实例</param>
    /// <returns></returns>
    public bool ExistUser(UserInfo userinfo)
    {
        string proanme = "CheckUserLogin";
        Database exeScalar = new Database();
        bool end = false;
        SqlParameter[] param ={Database.CreateInParam("@people",SqlDbType.NVarChar,80,userinfo.People),
                               Database.CreateInParam("@pwd",SqlDbType.NVarChar,80,userinfo.Pwd)};

        try
        {
            int result = exeScalar.GetScalar(proanme, param, 1);
            if (result > 0)
                end = true;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

        return end;
    }
        #endregion   
    #region 根据名称返回用户信息
    public static UserInfo GetUserByName(string name)
    {
        Database getone = new Database();
        UserInfo Single = new UserInfo();
        SqlParameter[] prams ={ Database.CreateInParam("@people",SqlDbType.NVarChar,50,name) };
        SqlDataReader Dr = getone.GetReader("getoneuser", prams, 1);
        while (Dr.Read())
        {
            Single = new UserInfo(Dr);
        }
        Dr.Close();
        return Single;
    }


    #endregion
    #region 编辑用户资料
    /// <summary>
    /// 修改用户
    /// </summary>
    /// <param name="UserInfo">UserInfo实例</param>
    /// <returns></returns>
    public int editUser(UserInfo ManUser)
    {
        string proanme = "EditUser";
        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@email",SqlDbType.NVarChar,50,ManUser.Email),
                               Database.CreateInParam("@address",SqlDbType.NVarChar,50,ManUser.Address),
                               Database.CreateInParam("@phone",SqlDbType.VarChar,50,ManUser.Phone),
                                Database.CreateInParam("@people",SqlDbType.VarChar,50,ManUser.People)};
        try
        {
            return (exe.execute(proanme,param,1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
      
    }
    #endregion
    #region 修改密码
    /// <summary>
    /// 修改密码
    /// </summary>

    public int ChangePassword(string pwd, string people)
    {
        string proanme = "ChangePassword";
        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@pwd",SqlDbType.NVarChar,50,pwd),
                               Database.CreateInParam("@people",SqlDbType.VarChar,50,people)};
        try
        {
            return (exe.execute(proanme, param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
    #endregion
    #region 删除用户
    /// <summary>
    /// 修改用户
    /// </summary>
    /// <param name="UserInfo">UserInfo实例</param>
    /// <returns></returns>
    public int DelUser(UserInfo ManUser)
    {
        string proanme = "DelUser";
        Database exe = new Database();
        SqlParameter[] param ={ Database.CreateInParam("@id", SqlDbType.Int, 4, ManUser.ID) };
        try
        {
            return (exe.execute(proanme, param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

    }
      #endregion


}