public JsonResult AddVip(PromoteVipModel promoteVipModel, int[] scopes) { try { var sb = new StringBuilder(); this.promoteVipService = new PromoteVipService(); promoteVipModel.EmployeeID = this.SystemUserSession.EmployeeID; promoteVipModel.Status = 1; var promoteVip = DataTransfer.Transfer<Promote_Vip>(promoteVipModel, typeof(PromoteVipModel)); var promoteVipScopeList = new List<Promote_Vip_Scope>(); foreach (var scope in scopes) { var promoteVipScope = new Promote_Vip_Scope { ProductID = scope }; promoteVipScopeList.Add(promoteVipScope); sb.Append(scope + ","); } // 验证相同商品是否参与其他促销 var products = this.VerifyPromote(0, sb.ToString()); if (!string.IsNullOrEmpty(products)) { return this.Json(new AjaxResponse(0, "以下商品已参加其他促销活动:" + products)); } promoteVip.Scopes = promoteVipScopeList; this.promoteVipService.Add(promoteVip); } catch (Exception exception) { return this.Json(new AjaxResponse(0, "添加失败!" + exception.Message)); } return this.Json(new AjaxResponse(1, "添加成功!")); }
/// <summary> /// 添加活动商品. /// </summary> /// <param name="promoteVipScope"> /// 活动商品实体. /// </param> /// <param name="transaction"> /// 数据事务. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int Insert(Promote_Vip_Scope promoteVipScope, SqlTransaction transaction) { if (promoteVipScope == null) { throw new ArgumentNullException("promoteVipScope"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "PromoteVipID", SqlDbType.Int, promoteVipScope.PromoteVipID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ProductID", SqlDbType.NVarChar, promoteVipScope.ProductID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, promoteVipScope.ID, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery( CommandType.StoredProcedure, "sp_Promote_Vip_Scope_Insert", parameters, transaction); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }
/// <summary> /// 修改活动商品. /// </summary> /// <param name="promoteVipScope"> /// 活动商品实体. /// </param> /// <param name="transaction"> /// 数据事务. /// </param> public void Update(Promote_Vip_Scope promoteVipScope, SqlTransaction transaction) { if (promoteVipScope == null) { throw new ArgumentNullException("promoteVipScope"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "PromoteVipID", SqlDbType.Int, promoteVipScope.PromoteVipID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ProductID", SqlDbType.NVarChar, promoteVipScope.ProductID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, promoteVipScope.ID, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_Vip_Scope_Update", parameters, transaction); }