/// <summary>
/// 添加或更新蓄电池券后价展示配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpSertBatteryCouponPriceDisplay(BatteryCouponPriceDisplayModel model)
{
var result = false;
try
{
var oldValue = dbScopeManagerConfigurationRead.Execute(conn =>
_dal.GetBatteryCouponPriceDisplay(conn, model.Pid));
if (oldValue == null)
{
var pkid = dbScopeManagerConfiguration.Execute
(conn => _dal.AddBatteryCouponPriceDisplay(conn, model));
result = pkid > 0;
if (result)
{
model.PKID = pkid;
model.CreateDateTime = DateTime.Now;
model.LastUpdateDateTime = DateTime.Now;
var log = new BatteryOprLogModel
{
LogType = "BatteryCouponPriceDisplay",
IdentityId = model.Pid,
OperationType = "Add",
OldValue = null,
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"添加蓄电池：{model.Pid}的券后价展示配置",
Operator = _user,
};
LoggerManager.InsertLog("BatteryOprLog", log);
}
}
else
{
model.CreateDateTime = oldValue.CreateDateTime;
model.LastUpdateDateTime = DateTime.Now;
result = dbScopeManagerConfiguration.Execute(conn =>
_dal.UpdateBatteryCouponPriceDisplay(conn, model));
if (result)
{
var log = new BatteryOprLogModel
{
LogType = "BatteryCouponPriceDisplay",
IdentityId = model.Pid,
OperationType = "Update",
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(model),
Remarks = $"更新蓄电池：{model.Pid}的券后价展示配置",
Operator = _user,
};
LoggerManager.InsertLog("BatteryOprLog", log);
}
}
}
catch (Exception ex)
{
Logger.Error("UpSertBatteryCouponPriceDisplay", ex);
}
return(result);
}
/// <summary>
/// 更新蓄电池券后价展示配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBatteryCouponPriceDisplay(SqlConnection conn, BatteryCouponPriceDisplayModel model)
{
#region Sql
var sql = @"UPDATE Configuration.dbo.BatteryCouponPriceDisplay
SET IsShow = @IsShow ,
LastUpdateDateTime = GETDATE()
WHERE PKID = @PKID;";
#endregion
var parameters = new[]
{
new SqlParameter("@IsShow", model.IsShow),
new SqlParameter("@PKID", model.PKID)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
/// <summary>
/// 添加蓄电池券后价展示配置
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public int AddBatteryCouponPriceDisplay(SqlConnection conn, BatteryCouponPriceDisplayModel model)
{
#region SQL
var sql = @"INSERT INTO Configuration..BatteryCouponPriceDisplay
( Pid, IsShow )
OUTPUT inserted.PKID
VALUES ( @Pid, @IsShow );";
#endregion
var parameters = new[]
{
new SqlParameter("@Pid", model.Pid),
new SqlParameter("@IsShow", model.IsShow)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)));
}
/// <summary>
/// 蓄电池券后价展示配置是否重复
/// </summary>
/// <param name="conn"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool IsExistBatteryCouponPriceDisplay(SqlConnection conn, BatteryCouponPriceDisplayModel model)
{
#region Sql
var sql = @"SELECT COUNT(1)
FROM Configuration..BatteryCouponPriceDisplay AS s WITH ( NOLOCK )
WHERE s.Pid = @Pid
AND s.PKID <> @PKID;";
#endregion
var parameters = new[]
{
new SqlParameter("@Pid", model.Pid),
new SqlParameter("@PKID", model.PKID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)) > 0);
}
/// <summary>
/// 蓄电池券后价展示配置是否重复
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool IsExistBatteryCouponPriceDisplay(BatteryCouponPriceDisplayModel model)
{
var result = true;
try
{
result = dbScopeManagerConfigurationRead.Execute(conn =>
_dal.IsExistBatteryCouponPriceDisplay(conn, model));
}
catch (Exception ex)
{
Logger.Error("IsExistBatteryCouponPriceDisplay", ex);
}
return(result);
}
public ActionResult UpsertConfig(BatteryCouponPriceDisplayModel model)
{
if (string.IsNullOrWhiteSpace(model.Pid))
{
return(Json(new { Status = false, Msg = "请选择服务Pid" }, JsonRequestBehavior.AllowGet));
}
var manager = new BatteryCouponPriceDisplayManager(User.Identity.Name);
var isExist = manager.IsExistBatteryCouponPriceDisplay(model);
if (isExist)
{
return(Json(new { Status = false, Msg = "已存在重复的数据，不能重复添加" }, JsonRequestBehavior.AllowGet));
}
var result = manager.UpSertBatteryCouponPriceDisplay(model);
return(Json(new { Status = result, Msg = $"操作{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet));
}
