public static int Insert(ProductMappingModel model) { if (model == null) { return(-2); } using (var cmd = new SqlCommand()) { switch (model.ShopCode) { case "京东自营": cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..ProductPriceMapping AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.SkuID = @SkuID"; cmd.Parameters.AddWithValue("@SkuID", model.SkuID); break; case "养车无忧": case "康众官网": cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..ProductPriceMapping AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.ItemCode = @ItemCode"; cmd.Parameters.AddWithValue("@ItemCode", model.ItemCode); break; case "汽配龙": cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..ProductPriceMapping AS PPM WHERE ShopCode = @ShopCode AND PPM.Pid = @Pid"; cmd.Parameters.AddWithValue("@Pid", model.Pid); break; default: cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..ProductPriceMapping AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.ItemID = @ItemID"; cmd.Parameters.AddWithValue("@ItemID", model.ItemID); break; } cmd.Parameters.AddWithValue("@ShopCode", model.ShopCode); try { if (Tuhu.Component.Common.DbHelper.ExecuteScalar(cmd) != null) { return(-1); } } catch (Exception ex) { throw ex; } } var displayName = Tuhu.Component.Common.DbHelper.ExecuteScalar(@"SELECT C.DisplayName FROM Tuhu_productcatalog..CarPAR_CatalogProducts AS CP WITH(NOLOCK) JOIN Tuhu_productcatalog..[CarPAR_zh-CN_Catalog] AS C WITH(NOLOCK) ON C.#Catalog_Lang_Oid = CP.oid WHERE @Pid = CP.ProductID + '|' + CP.VariantID AND CP.i_ClassType IN (2, 4)" , CommandType.Text, new SqlParameter("Pid", model.Pid)); if (displayName == null) { return(-5); } model.DisplayName = displayName.ToString(); using (var cmd = new SqlCommand(@"INSERT INTO Tuhu_productcatalog..ProductPriceMapping (ShopCode, Pid, ItemID, SkuID, Price, Promotion, Title, ThirdParty, ItemCode) VALUES (@ShopCode, -- ShopCode - nvarchar(20) @Pid, -- Pid - nvarchar(200) @ItemID, -- ItemID - bigint @SkuID, -- SkuID - bigint @Price, -- Price - money 0, -- Promotion - bit @Title, -- Title - nvarchar(250) 1, @ItemCode)" )) { cmd.Parameters.AddWithValue("@ShopCode", model.ShopCode); cmd.Parameters.AddWithValue("@Pid", model.Pid.Trim()); if (model.ShopCode == "养车无忧" || model.ShopCode == "康众官网") { cmd.Parameters.AddWithValue("@ItemID", 0); cmd.Parameters.AddWithValue("@SkuID", 0); } else { cmd.Parameters.AddWithValue("@ItemID", model.ItemID); cmd.Parameters.AddWithValue("@SkuID", model.SkuID); } cmd.Parameters.AddWithValue("@Price", model.Price); cmd.Parameters.AddWithValue("@Title", model.Title); if (model.ShopCode == "养车无忧" || model.ShopCode == "康众官网") { cmd.Parameters.AddWithValue("@ItemCode", model.ItemCode); } else if (model.ShopCode == "汽配龙") { cmd.Parameters.AddWithValue("@ItemCode", model.Pid); } else { cmd.Parameters.AddWithValue("@ItemCode", ""); } try { return(Tuhu.Component.Common.DbHelper.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw ex; } } }
public ActionResult PriceMonitorConfig(ProductMappingModel model) { if (model == null) { return(Json(-2)); } if (ModelState.IsValid) { switch (model.ShopCode) { case "京东自营": { var price = GetItemPrice(model.ItemID.ToString(), client => client.GetJingdongPrice); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; model.SkuID = model.ItemID.GetValueOrDefault(); model.ItemID = 0; } break; case "养车无忧": { var price = GetItemPrice(model.ItemCode, client => client.GetYangche51Price); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; //清除ItemID model.ItemID = 0; model.SkuID = 0; } break; case "汽配龙": model.Price = 0; model.Title = ""; model.ItemID = 0; model.SkuID = 0; break; case "汽车超人零售": { var price = GetItemPrice(model.ItemID.ToString(), client => client.GetQccrRetailPrice); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; } break; case "汽车超人批发": { var price = GetItemPrice(model.ItemID.ToString(), client => client.GetQccrTradePrice); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; } break; case "康众官网": { var price = GetItemPrice(model.ItemCode.ToString(), client => client.GetCarzonePriceFromApp); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; } break; default: { var price = GetItemPrice(model.ItemID.ToString(), client => client.GetTaobaoPrice); if (price == null) { return(Json(-4)); } model.Price = price.Price; model.Title = price.Title; } break; } var result = ProductMappingManager.Insert(model); return(result > 0 ? Json(model) : Json(result)); } return(Json(-3)); }