/// <summary>
/// 更新权重值
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateGuidePara(BaoYangPriceWeight model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
return(dbHelper.ExecuteNonQuery(@"UPDATE Tuhu_productcatalog.dbo.tbl_BaoYangPriceWeight SET WeightValue=@Value,UpdateTime=GETDATE() WHERE PKID=@PKID", CommandType.Text, new SqlParameter[] { new SqlParameter("@Value", model.WeightValue), new SqlParameter("@PKID", model.PKID) }));
}
}
public int SavePriceWeight(BaoYangPriceWeight model)
{
if (model.PKID.GetValueOrDefault(0) > 0)
{
if (model.WeightValue.GetValueOrDefault(0) == 0 && model.WeightType != "Base")
{
return(DalBaoYangPriceGuide.DeleteGuidePara(model.PKID.Value));
}
else
{
return(DalBaoYangPriceGuide.UpdateGuidePara(model));
}
}
else
{
if (model.WeightValue.GetValueOrDefault(0) != 0)
{
return(DalBaoYangPriceGuide.InsertGuidePara(model));
}
else
{
return(99);
}
}
}
/// <summary>
/// 插入权重配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertGuidePara(BaoYangPriceWeight model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
return(dbHelper.ExecuteNonQuery(@"INSERT INTO Tuhu_productcatalog.dbo.tbl_BaoYangPriceWeight
( WeightType, WeightName, WeightValue, CategoryName )
VALUES ( @Type, @Item, @Value, @CategoryName )" , CommandType.Text, new SqlParameter[] {
new SqlParameter("@Value", model.WeightValue),
new SqlParameter("@Type", model.WeightType),
new SqlParameter("@Item", model.WeightName),
new SqlParameter("@CategoryName", model.CategoryName)
}));
}
}
public JsonResult SaveGuidePara(BaoYangPriceWeight model, string prevValue)
{
var manager = new BaoYangPriceGuideManager();
var result = manager.SavePriceWeight(model);
if (result > 0 && result != 99)
{
string operation;
if (model.WeightType.Equals("Brand"))
{
operation = model.WeightType + "|" + model.CategoryName + "|" +
HttpUtility.UrlDecode(model.WeightName);
}
else
{
operation = model.WeightType + "|" + HttpUtility.UrlDecode(model.WeightName);
}
AddOprLog(prevValue, model.WeightValue.GetValueOrDefault(0).ToString(), "ByWeight", operation);
}
return(Json(result));
}
