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