admincenteraccess.cs

网上书店

        string isRecommand, string isSpecialPrice, string count)
    //添加图书
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "InsertNewBookInfo";

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

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

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

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

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

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@BookNo";
        param.Value = bookNo;
        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.Decimal;
        param.ParameterName = "@Price";
        param.Value = price;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsRecommand";
        param.Value = isRecommand;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsSpecialPrice";
        param.Value = isSpecialPrice;
        cmd.Parameters.Add(param);

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool InsertBook_BookCategory(string bookID, string categoryID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "InsertBook_BookCategory";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@BookID";
        param.Value = bookID;
        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 string GetBookInfoByBookNo(string bookNo)
    //通过图书编号取得图书信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBookInfoByBookNo";

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

        return CmdPart.ExecuteScalar(cmd);

    }

    public static bool DeleteBookInfo(string bookID, out bool isSuccess)
    //删除图书信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteBookInfo";

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

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

        bool result = CmdPart.ExcuteNonSelectCommand(cmd);
        isSuccess = bool.Parse(cmd.Parameters["@IsSuccess"].Value.ToString());
        return result;
    }

    public static bool ModifyBookInfo(string bookID, string bookName, string imageFileName1, string imageFileName2,string author, string publisher, string content, string price,string isRecommand, string isSpecialPrice, string amount, string leftNumber)
    //修改图书
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyBookInfo";

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

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

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

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

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

        param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@Publisher";
        param.Value = publisher;
        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.Decimal;
        param.ParameterName = "@Price";
        param.Value = price;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsRecommand";
        param.Value = isRecommand;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.DbType = DbType.Boolean;
        param.ParameterName = "@IsSpecialPrice";
        param.Value = isSpecialPrice;
        cmd.Parameters.Add(param);

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

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool IsTypeNameExsist(string typeName)
    //判断管理员类型名是否已存在
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "IsTypeNameExsist";

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

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

    public static bool CreateNewType(string typeName, string content)
    {//创建管理员类型
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "CreateNewType";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@TypeName";
        param.Value = typeName;
        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 DataTable GetOrdersByStatus(string status, string pageNumber, out int howManyPages)
    {

        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetOrdersByStatus";

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

        param = cmd.CreateParameter();
        param.ParameterName = "@OrdersPerPage";
        param.DbType = DbType.Int32;
        param.Value = DatabaseConfiguration.OrdersPerPage.ToString();
        cmd.Parameters.Add(param);

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

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

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        int howManyOrders = Int32.Parse(cmd.Parameters["@HowManyOrders"].Value.ToString());
        howManyPages = howManyOrders > 0 ? (howManyOrders - 1) / DatabaseConfiguration.OrdersPerPage + 1 : 0;
        return dt;

    }

    public static DataTable GetStatus()
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetStatus";
        return CmdPart.ExcuteSelectCommand(cmd);
    }

    public static bool ModifyOrderStatus(string orderID, string status)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyOrderStatus";

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

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    public static bool ModifyAdminType(string typeID, string content)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyAdminType";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@TypeID";
        param.Value = typeID;
        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 DeleteAdminType(string typeID, out bool IsSuccess)
    //删除某个管理员类型
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DeleteAdminType";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.Int32;
        param.ParameterName = "@TypeID";
        param.Value = typeID;
        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;
    }
}