📄 catalogmanager.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 Commerce.Providers;
/// <summary>
/// Summary description for CatalogManager
/// </summary>
public static class CatalogManager {
/// <summary>
/// Gets all the products in the database
/// </summary>
/// <returns>Reader</returns>
public static IDataReader GetProducts() {
//return Commerce.Providers.
//Commerce.Providers.CatalogProvider.g
return Commerce.Providers.CatalogProvider.Instance.GetProducts();
}
/// <summary>
/// Gets products by product category
/// </summary>
/// <param name="categoryID"></param>
/// <returns>Reader</returns>
public static IDataReader GetProductsByCategory(int categoryID) {
return Commerce.Providers.CatalogProvider.Instance.GetProductsByCategory(categoryID);
}
public static bool IsActive(int productID) {
return CatalogProvider.Instance.ProductIsActive(productID);
}
/// <summary>
/// Gets a specific product
/// </summary>
/// <param name="productID"></param>
/// <returns></returns>
public static IDataReader GetProduct(int productID) {
return Commerce.Providers.CatalogProvider.Instance.GetProduct(productID);
}
/// <summary>
/// Gets product information and fills a dataset
/// </summary>
/// <param name="productID"></param>
/// <param name="ds">The dataset to fill</param>
public static void FillProductDataSet(int productID, DataSet ds) {
Commerce.Providers.CatalogProvider.Instance.FillProductDataSet(productID, ds);
}
/// <summary>
/// Gets all category records in the database
/// </summary>
/// <returns>Reader</returns>
public static IDataReader GetCategories() {
return Commerce.Providers.CatalogProvider.Instance.GetCategories();
}
/// <summary>
/// Debits the inventory by the supplied amount. Note that if you enter "5", 5 will be deducted from AmountOnHand
/// </summary>
/// <param name="productID"></param>
/// <param name="adjustment">The amount to debit</param>
/// <param name="comment"></param>
public static void AdjustInventory(int productID, int adjustment,string comment){
Commerce.Providers.CatalogProvider.Instance.ProductsAdjustInventory(productID, adjustment, comment);
}
public static IDataReader GetInventoryHistory(int productID) {
return Commerce.Providers.CatalogProvider.Instance.ProductsInventoryHistory(productID);
}
public static void InactivateProduct(int productID) {
Commerce.Providers.CatalogProvider.Instance.ProductInactivate(productID);
//remove the products from open baskets
ShoppingCartManager.RemoveAllProducts(productID);
}
public static int AddProduct(Product product) {
return Commerce.Providers.CatalogProvider.Instance.ProductInsert(product.CategoryID,
product.ModelNumber, product.ModelName, product.ProductImage,
product.UnitCost, product.Description, product.AmountOnHand,
product.SKU,product.Weight);
}
public static double GetDiscountedPrice(double originalPrice, int discountPercent) {
double dOut = 0;
double discount = 0;
if (discountPercent > 0) {
discount = Convert.ToDouble(discountPercent) / 100;
}
double discountAmount = originalPrice * discount;
return originalPrice - discountAmount;
}
public static void UpdateProduct(Product product) {
Commerce.Providers.CatalogProvider.Instance.ProductUpdate(product.ProductID,product.CategoryID,
product.ModelNumber, product.ModelName, product.ProductImage,
product.UnitCost, product.Description,
product.SKU,product.IsActive,product.Weight,product.DiscountPercent);
//apply any newly added discounts
//this will carry through to the basket updates
if (product.DiscountPercent > 0)
product.UnitCost = GetDiscountedPrice(product.UnitCost,product.DiscountPercent);
//update any items currently in the shopping carts (active carts only)
ShoppingCartManager.UpdateCartProducts(product.ProductID, product.UnitCost, product.Weight, product.ModelName,
product.ModelNumber,product.SKU);
//if this product has been inactivated, don't allow
//anyone to buy it.
if (!product.IsActive) {
ShoppingCartManager.RemoveAllProducts(product.ProductID);
}
}
public static void PermanentDelete(int productID) {
CatalogProvider.Instance.ProductDeletePermanent(productID);
//remove them from the carts
ShoppingCartManager.RemoveAllProducts(productID);
}
public static IDataReader Search(string query) {
return CatalogProvider.Instance.ProductsSearch(query);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -