commondataaccess.cs

网上书店

        {
            return false;
        }
    }

    //取得新书信息
    public static DataTable GetBooksNew(int pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksNew";

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

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

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

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

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

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProducts = Int32.Parse(cmd.Parameters["@HowManyProducts"].Value.ToString());
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;


    }

    //取得热卖图书信息
    public static DataTable GetBooksHot(int pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksHot";

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

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

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

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

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

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProducts = Int32.Parse(cmd.Parameters["@HowManyProducts"].Value.ToString());
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;
    }

    public static object Search(string searchString, string allWords, string pageNumber, out int howManyPages)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "Search";

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

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

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

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

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

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

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyResults"].Value.ToString();
        int howManyProducts = Int32.Parse(str);
        howManyPages = howManyProducts > 0 ? (howManyProducts - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;
    }

    //获得指定图书
    public static DataTable GetBooksInNO(int bookNO)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetBooksInNO";

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

        return CmdPart.ExcuteSelectCommand(cmd);

    }

    //图书点击加1
    public static void HotClick(int bookID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "HotClick";

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

        CmdPart.ExcuteNonSelectCommand(cmd);
    }

    //显示热门点击图书
    public static DataTable HotClickBook()
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "HotClickBook";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@hotClickBook";
        param.Value = DatabaseConfiguration.HotClickBook;
        param.DbType = DbType.Int32;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteSelectCommand(cmd);
    }

    //收藏图书
    public static bool AddShouCang(string CustomerName, int BookID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "AddShouCang";

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

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    //取消收藏
    public static bool DelShouCang(string CustomerName, string  BookID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "DelShouCang";

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

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

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }



    //获得收藏图书
    public static DataTable GetShouCang(string  CustomerName ,int pageNumber,out int howManyProducts)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText="GetShouCang";
         
        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.Value = CustomerName;
        param.DbType = DbType.String;
        cmd.Parameters.Add(param);

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

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

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

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

        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        string str = cmd.Parameters["@HowManyProducts"].Value.ToString();
        int howManyProduct = Int32.Parse(str);
        howManyProducts = howManyProduct > 0 ? (howManyProduct - 1) / DatabaseConfiguration.ProductsPerPage + 1 : 0;
        return dt;
    }

    public static DataTable GetCategories()
    //取得分类信息
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetCategories";
        return CmdPart.ExcuteSelectCommand(cmd);
    }
}