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;
}
