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