manager.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;
using System.Collections.Generic;

/// <summary>
/// Class1 的摘要说明
/// </summary>
public class Manager
{
    #region 私有变量和属性
    private int _id;//用户id
    private string _username;//用户姓名
    private string _password;//用户密码
    private int _super;//用户权限
    public int ID
    {
        get { return _id; }
        set { _id = value; }
    }
    public string Username
    {
        get { return _username; }
        set { _username = value; }
    }
    public string Password
    {
        get { return _password; }
        set { _password = value; }
    }
    public int Super
    {
        get { return _super; }
        set { _super = value; }
    }
    #endregion
    #region 构造器
    public Manager()

	{

    }
    #endregion
    #region 判断用户是否存在
    /// <summary>
    /// 判断用户是否存在
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public bool ExistsManger(Manager ManUser)
    {
        string proanme="CheckManager";
        Database exeScalar = new Database();
        bool end = false;
        SqlParameter[] param ={Database.CreateInParam("@username",SqlDbType.NVarChar,80,ManUser.Username),
                               Database.CreateInParam("@password",SqlDbType.NVarChar,80,ManUser.Password)};

        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 判断添加的用户是否存在
    /// <summary>
    ///  判断添加的用户是否存在
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public bool ExistsAddManger(string name)
    {
        string proanme = "CheckAddManager";
        Database exeScalar = new Database();
        bool end = false;
        SqlParameter[] param ={ Database.CreateInParam("@username", SqlDbType.NVarChar, 80, name)};
        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 增加用户
    /// <summary>
    /// 增加用户
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public int addManger(Manager ManUser)
    {
        string proanme = "AddManager";
        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@username", SqlDbType.NVarChar, 80, ManUser.Username),
                               Database.CreateInParam("@password",SqlDbType.NVarChar,80,ManUser.Password),
                               Database.CreateInParam("@super",SqlDbType.Bit,1,ManUser.Super), };
       
        try
        {
            return (exe.execute(proanme, param, 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        
    }
        #endregion
    #region 修改用户
    /// <summary>
    /// 修改用户
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public int editManger(Manager ManUser)
    {
        string proanme = "EditManager";
        Database exe = new Database();
        SqlParameter[] param ={Database.CreateInParam("@id",SqlDbType.Int,4,ManUser.ID),
                               Database.CreateInParam("@password",SqlDbType.NVarChar,80,ManUser.Password),
                               Database.CreateInParam("@super",SqlDbType.Bit,1,ManUser.Super) };
        try
        {
            return (exe.execute(proanme,param,1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
      
    }
        #endregion
    #region 显示全部用户
    public DataTable getall()
    {
        Database gettable=new Database();
        try
        {
       return (gettable.GetTable("GetAllMangers", null, "Manager", 1));
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        
    }

    #endregion
    #region 根据用户id返回用户的信息
    public DataSet getone(int id)
    {
        Database gettable=new Database();
        SqlParameter[] Param ={ Database.CreateInParam("@ID", SqlDbType.Int, 4, id) };
        DataSet ds = new DataSet();
        try
        {
            gettable.GetSet("GetoneManager", Param, ref ds,"Manager", 1);
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }

      
        return ds;
    }
    #endregion
    #region 删除用户
    /// <summary>
    /// 修改用户
    /// </summary>
    /// <param name="ManUser">Manager实例</param>
    /// <returns></returns>
    public int delManger(Manager ManUser)
    {
        string proanme = "DelManager";
        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


}