public WeProduct(string productId, WeProductBase productBase, DeliveryInfo deliveryInfo, ProductStatusType status, params SkuListElement[] skuList) : this(productId, productBase, deliveryInfo, status) { TkDebug.AssertArgumentNull(skuList, "skuList", null); SkuList.AddRange(skuList); }
public WeProduct(string productId, WeProductBase productBase, SkuListElement sku, DeliveryInfo deliveryInfo, ProductStatusType status) : this(productId, productBase, deliveryInfo, status) { TkDebug.AssertArgumentNull(sku, "sku", null); SkuList.Add(sku); }
private WeProduct(string productId, WeProductBase productBase, DeliveryInfo deliveryInfo, ProductStatusType status) { TkDebug.AssertArgumentNullOrEmpty(productId, "productId", null); TkDebug.AssertArgumentNull(ProductBase, "ProductBase", null); TkDebug.AssertArgumentNull(deliveryInfo, "deliveryInfo", null); ProductId = productId; SkuList = new List<SkuListElement>(); ProductBase = productBase; DeliveryInfo = deliveryInfo; Status = status; }
/// <summary> /// 修改产品状态值 /// </summary> /// <param name="statusType">状态名称</param> /// <param name="id">ID</param> /// <param name="status">状态值</param> public void ChangeProductStatus(int id, int status, ProductStatusType statusType) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@status", SqlDbType.Int), new SqlParameter("@statusType", SqlDbType.NVarChar) }; parameters[0].Value = id; parameters[1].Value = status; parameters[2].Value = statusType; ProductInfo tempPro = Read(id); switch (statusType) { case ProductStatusType.IsSpecial: tempPro.IsSpecial = status; break; case ProductStatusType.IsNew: tempPro.IsNew = status; break; case ProductStatusType.IsHot: tempPro.IsHot = status; break; case ProductStatusType.IsSale: tempPro.IsSale = status; break; case ProductStatusType.IsTop: tempPro.IsTop = status; break; case ProductStatusType.AllowComment: tempPro.AllowComment = status; break; default: break; } Update(tempPro); }
public static string ProductStatusToString(ProductStatusType productStatusType) { ProductStatusType type = productStatusType; switch (type) { case ProductStatusType.PendingApproval: return(SueetieLocalizer.GetMarketplaceString("statustype_pending")); case ProductStatusType.Expired: return(SueetieLocalizer.GetMarketplaceString("statustype_expired")); case ProductStatusType.SoldOut: return(SueetieLocalizer.GetMarketplaceString("statustype_soldout")); } if (type != ProductStatusType.Active) { return(SueetieLocalizer.GetMarketplaceString("statustype_other")); } return(SueetieLocalizer.GetMarketplaceString("statustype_active")); }
public WeProductModStatus(ProductStatusType status, string productId) { Status = status; }
protected override void Seed(StoreDataContext context) { ProductStatusType[] statusTypes = new ProductStatusType[] { new ProductStatusType { StatusCode = 1, Description = "Available", AuditTime = Convert.ToDateTime("2013-08-26") }, new ProductStatusType { StatusCode = 2, Description = "Out of Stock", AuditTime = Convert.ToDateTime("2013-09-26") }, new ProductStatusType { StatusCode = 3, Description = "Back Ordered", AuditTime = Convert.ToDateTime("2013-09-26") }, new ProductStatusType { StatusCode = 4, Description = "Discontinued", AuditTime = Convert.ToDateTime("2013-10-26") }, new ProductStatusType { StatusCode = 5, Description = "Undefined", AuditTime = Convert.ToDateTime("2013-10-26") } }; context.ProductStatusTypes.AddRange(statusTypes); Category[] categories = new Category[] { new Category { CategoryID = 1, CategoryName = "Bath", AuditTime = DateTime.Now, Products = new Product[] { new Product { ProductID = 1, ProductName = "Bath Rug", UnitPrice = 24.5m, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-07-10"), AuditTime = DateTime.Now }, new Product { ProductID = 2, ProductName = "Shower Curtain", UnitPrice = 30.99m, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-07-13"), AuditTime = DateTime.Now }, new Product { ProductID = 3, ProductName = "Soap Dispenser", UnitPrice = 12.4m, StatusCode = 2, AvailableSince = Convert.ToDateTime("2013-08-05"), AuditTime = DateTime.Now }, new Product { ProductID = 4, ProductName = "Toilet Tissue", UnitPrice = 15, StatusCode = 3, AvailableSince = Convert.ToDateTime("2013-05-16"), AuditTime = DateTime.Now }, }.ToList() }, new Category { CategoryID = 2, CategoryName = "Bedding", AuditTime = DateTime.Now, Products = new Product[] { new Product { ProductID = 5, ProductName = "Branket", UnitPrice = 60, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-08-22"), AuditTime = DateTime.Now }, new Product { ProductID = 6, ProductName = "Mattress Protector", UnitPrice = 30.4m, StatusCode = 2, AvailableSince = Convert.ToDateTime("2013-08-22"), AuditTime = DateTime.Now }, new Product { ProductID = 7, ProductName = "Sheet Set", UnitPrice = 40.69m, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-07-26"), AuditTime = DateTime.Now }, new Product { ProductID = 8, ProductName = "Pillow", UnitPrice = 10.2m, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-10-04"), AuditTime = DateTime.Now }, }.ToList() }, new Category { CategoryID = 3, CategoryName = "kitchen", AuditTime = DateTime.Now, Products = new Product[] { new Product { ProductID = 9, ProductName = "Baking Pan", UnitPrice = 10.99m, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-10-26"), AuditTime = DateTime.Now }, new Product { ProductID = 10, ProductName = "Can Opener", UnitPrice = 7.99m, StatusCode = 5, AvailableSince = Convert.ToDateTime("2013-09-18"), AuditTime = DateTime.Now }, new Product { ProductID = 11, ProductName = "Coffee Maker", UnitPrice = 49.39m, StatusCode = 4, AvailableSince = null, AuditTime = DateTime.Now }, new Product { ProductID = 12, ProductName = "Knife Set", UnitPrice = 70, StatusCode = 1, AvailableSince = Convert.ToDateTime("2013-10-10"), AuditTime = DateTime.Now }, new Product { ProductID = 13, ProductName = "Pressure Cooker", UnitPrice = 90.5m, StatusCode = 2, AvailableSince = Convert.ToDateTime("2013-10-26"), AuditTime = DateTime.Now }, new Product { ProductID = 14, ProductName = "Water Pitcher", UnitPrice = 29.99m, StatusCode = 3, AvailableSince = null, AuditTime = DateTime.Now }, }.ToList() }, new Category { CategoryID = 4, CategoryName = "Undefined", AuditTime = DateTime.Now }, }; context.Categories.AddRange(categories); context.SaveChanges(); //context.Database.ExecuteSqlCommand( // @"IF OBJECT_ID ( 'dbo.GetAllCategorisAndProducts', 'P' ) IS NOT NULL // DROP PROCEDURE dbo.GetAllCategorisAndProducts " // ); context.Database.ExecuteSqlCommand( @"CREATE PROCEDURE dbo.GetAllCategorisAndProducts AS BEGIN SET NOCOUNT ON SELECT c.CategoryID, c.CategoryName, p.ProductCount FROM dbo.Category c JOIN (SELECT count(ProductID) AS ProductCount, CategoryID FROM Product GROUP BY CategoryID) p ON p.CategoryID = c.CategoryID SELECT p.ProductID, p.ProductName, p.CategoryID, c.CategoryName, p.StatusCode, s.Description AS StatusDescription, p.UnitPrice, p.AvailableSince FROM dbo.Product p join dbo.Category c on c.CategoryID = p.CategoryID join dbo.ProductStatusType s on s.StatusCode = p.StatusCode END " ); context.Database.ExecuteSqlCommand( @"CREATE PROCEDURE dbo.GetProductCM AS BEGIN SET NOCOUNT ON SELECT p.ProductID, p.ProductName, p.CategoryID, c.CategoryName, p.StatusCode, s.Description AS StatusDescription, p.UnitPrice, p.AvailableSince FROM dbo.Product p join dbo.Category c on c.CategoryID = p.CategoryID join dbo.ProductStatusType s on s.StatusCode = p.StatusCode END " ); }
/// <summary> /// 修改产品状态值 /// </summary> /// <param name="statusType">状态名称</param> /// <param name="id">ID</param> /// <param name="status">状态值</param> public static void ChangeProductStatus(int id, int status, ProductStatusType statusType) { dal.ChangeProductStatus(id, status, statusType); }
public static IEnumerable<WeProduct> QueryByStatus(ProductStatusType status) { string url = WeUtil.GetUrl(WeShopConst.PRODUCT_STATUS_URL); WeProductStatus request = new WeProductStatus(status); var result = WeUtil.PostToUri(url, request.WriteJson(), new WeProductsInfo()); return result.ProductsInfo; }
public static WeixinResult ModProductStatus(string productId, ProductStatusType status) { TkDebug.AssertArgumentNullOrEmpty(productId, "productId", null); string url = WeUtil.GetUrl(WeShopConst.PRODUCT_SHELF_URL); WeProductModStatus request = new WeProductModStatus(status, productId); var result = WeUtil.PostToUri(url, request.WriteJson(), new WeixinResult()); return result; }
public WeProductStatus(ProductStatusType status) { Status = status; }