/// <summary>
/// 更新预警线信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int UpdateWarningLine(BaoYangWarningLine model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir")))
{
return(dbHelper.ExecuteNonQuery(@"UPDATE Configuration..tbl_BaoYang_WarningLine SET LowerLimit=@LowerLimit,UpperLimit=@UpperLimit WHERE PKID=@PKID", CommandType.Text, new SqlParameter[] {
new SqlParameter("@LowerLimit", model.LowerLimit),
new SqlParameter("@UpperLimit", model.UpperLimit),
new SqlParameter("@PKID", model.PKID)
}));
}
}
public JsonResult SaveWarningLine(BaoYangWarningLine model)
{
if (model.PKID > 0 && model.UpperLimit > 0 && model.LowerLimit > 0)
{
var manager = new BaoYangPriceGuideManager();
var result = manager.UpdateWarningLine(model);
if (result > 0)
{
AddOprLog(model.LowerLimit + "|" + model.UpperLimit, model.PKID.ToString(), "ByWarn", "修改");
}
return(Json(result));
}
else
{
return(Json(-1));
}
}
public int UpdateWarningLine(BaoYangWarningLine model) => DalBaoYangPriceGuide.UpdateWarningLine(model);
