admincenteraccess.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.Common;

/// <summary>
/// AdminCenterAccess 的摘要说明
/// </summary>
public class AdminCenterAccess
{
    public AdminCenterAccess()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }

    public static bool IsAdminExsist(string adminName, string password)
    //判断管理员是否存在
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsAdminExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@AdminName";
        param.DbType = DbType.String;
        param.Value = adminName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Password";
        param.DbType = DbType.String;
        param.Value = password;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public static string GetAdminTypeByAdminName(string adminName)
    //取得某个管理员的管理权限
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetAdminTypeByAdminName";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@AdminName";
        param.DbType = DbType.String;
        param.Value = adminName;
        cmd.Parameters.Add(param);

        return CmdPart.ExecuteScalar(cmd);
    }

    public static DataTable GetAdminType()
    //取得管理员类型
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetAdminType";

        return CmdPart.ExcuteSelectCommand(cmd);

    }

    public static DataTable GetAllAdminInfo()
    //取得所有管理员信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetAllAdminInfo";
        return CmdPart.ExcuteSelectCommand(cmd);
    }

    public static bool IsAdminNameExsist(string adminName)
    //判断管理员登录名是否被用过
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsAdminNameExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@AdminName";
        param.DbType = DbType.String;
        param.Value = adminName;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public static bool CreateNewAdmin(string adminName, string password, string adminType)
    //添加新的管理员
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "CreateNewAdmin";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@AdminName";
        param.DbType = DbType.String;
        param.Value = adminName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Password";
        param.DbType = DbType.String;
        param.Value = password;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@AdminType";
        param.DbType = DbType.Int32;
        param.Value = adminType;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);

    }

    public static bool ModifyAdminInfo(string adminName, string realName, string adminType)
    //修改某个管理员信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyAdminInfo";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@AdminName";
        param.Value = adminName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@RealName";
        param.Value = realName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@AdminType";
        param.Value = adminType;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool DeleteAdmin(string adminName)
    //删除某个管理员
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteAdmin";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@AdminName";
        param.Value = adminName;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }
    public static bool IsDepartmentNameExsist(string name)
    //判断门类名是否已存在
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsDepartmentNameExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@Name";
        param.DbType = DbType.String;
        param.Value = name;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }


    public static bool CreateNewDepartment(string name, string content)
    //插入新的门类
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "CreateNewDepartment";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Name";
        param.Value = name;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Content";
        param.Value = content;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool ModifyDepartment(string departmentID, string content)
    //修改门类列表信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyDepartment";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@DepartmentID";
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Content";
        param.Value = content;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool DeleteDepartment(string departmentID, out bool IsSuccess)
    //删除门类信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteDepartment";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@DepartmentID";
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsSuccess";
        param.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(param);

        bool result = CmdPart.ExcuteNonSelectCommand(cmd);
        Boolean.TryParse(cmd.Parameters["@IsSuccess"].Value.ToString(), out IsSuccess);
        return result;
    }

    public static bool CreateNewCategory(string name, string departmentID, string content)
    //插入新的分类
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "CreateNewCategory";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Name";
        param.Value = name;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@DepartmentID";
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Content";
        param.Value = content;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool IsCategoryNameExsist(string name)
    //判断分类名是否已存在
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsCategoryNameExsist";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@Name";
        param.DbType = DbType.String;
        param.Value = name;
        cmd.Parameters.Add(param);

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public static bool DeleteCategory(string categoryID, out bool IsSuccess)
    //删除一个分类
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteCategory";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@CategoryID";
        param.Value = categoryID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsSuccess";
        param.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(param);

        bool result = CmdPart.ExcuteNonSelectCommand(cmd);
        Boolean.TryParse(cmd.Parameters["@IsSuccess"].Value.ToString(), out IsSuccess);
        return result;
    }

    public static bool ModifyCategory(string categoryID, string departmentID, string content)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyCategory";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@DepartmentID";
        param.Value = departmentID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Content";
        param.Value = content;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@CategoryID";
        param.Value = categoryID;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool InsertNewBookInfo(string bookName, string imageFileName1, string imageFileName2,
        string author, string publisher, string bookNo, string content, string price,