/// <summary>
/// 新增产品监控信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(CompetingProductsMonitorEntity model)
{
if (model == null)
{
return(-2);
}
#region 判断渠道的产品监控是否存在
using (var cmd = new SqlCommand())
{
switch (model.ShopCode)
{
case "京东自营":
cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..CompetingProductsMonitor AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.SkuID = @SkuID AND Is_Deleted=0";
cmd.Parameters.AddWithValue("@SkuID", model.SkuID);
break;
case "养车无忧":
case "康众官网":
cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..CompetingProductsMonitor AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.ItemCode = @ItemCode AND Is_Deleted=0";
cmd.Parameters.AddWithValue("@ItemCode", model.ItemCode);
break;
case "汽配龙":
cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..CompetingProductsMonitor AS PPM WHERE ShopCode = @ShopCode AND PPM.Pid = @Pid AND Is_Deleted=0";
cmd.Parameters.AddWithValue("@Pid", model.Pid);
break;
default:
cmd.CommandText = "SELECT 1 FROM Tuhu_productcatalog..CompetingProductsMonitor AS PPM WHERE PPM.ShopCode = @ShopCode AND PPM.ItemID = @ItemID AND Is_Deleted=0";
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;
}
}
#endregion
#region 判断PID是否存在
var displayName = 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 CP.Pid2=@Pid
AND CP.i_ClassType IN (2, 4)"
, CommandType.Text,
new SqlParameter("Pid", model.Pid));
if (displayName == null)
{
return(-5);
}
#endregion
#region 执行插入产品监控表
using (var cmd = new SqlCommand(@"
INSERT INTO [Tuhu_productcatalog]..[CompetingProductsMonitor]
([ShopCode]
,[Pid]
,[ItemID]
,[SkuID]
,[ItemCode]
,[Price]
,[Promotion]
,[Title]
,[ThirdParty])
VALUES
(@ShopCode
,@Pid
,@ItemID
,@SkuID
,@ItemCode
,@Price
,0
,@Title
,1)"))
{
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", "");
}
return(DbHelper.ExecuteNonQuery(cmd));
}
#endregion
}
/// <summary>
/// 新增产品监控信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(CompetingProductsMonitorEntity model)
{
return(dal.Insert(model));
}
public ActionResult PriceMonitorConfig(CompetingProductsMonitorEntity model)
{
if (model == null)
{
return(Json(-2));
}
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;
model.ItemID = 0;
}
break;
case "麦轮胎官网":
{
var price = GetItemPrice(model.ItemID.ToString(), client => client.GetMailuntaiPrice);
if (price == null)
{
return(Json(-4));
}
model.Price = price.Price;
model.Title = price.Title;
}
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 "汽配龙":
{
var qplProductInfo = QPLShopManage.GetQPLPrice(model.Pid);
model.Price = qplProductInfo.Item1;
model.Title = qplProductInfo.Item2;
model.ItemID = 0;
model.SkuID = 0;
model.ItemCode = string.Empty;
}
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 manager = new CompetingProductsMonitorManager();
var result = manager.Insert(model);
return(result > 0 ? Json(model) : Json(result));
}
