public int Insert(Product_AttributeValue productAttributeValue) { if (productAttributeValue == null) { throw new ArgumentNullException("productAttributeValue"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "AttributeID", SqlDbType.NVarChar, productAttributeValue.AttributeID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "AttributeValue", SqlDbType.NVarChar, productAttributeValue.AttributeValue, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, productAttributeValue.Sorting, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "IsDefault", SqlDbType.Int, productAttributeValue.IsDefault, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_AttributeValue_Insert", parameters, null); return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; }
/// <summary> /// The modify product attribute value. /// </summary> /// <param name="productAttributeValue"> /// The product attribute value. /// </param> public void ModifyProductAttributeValue(Product_AttributeValue productAttributeValue) { this.productAttributeValueDA.Update(productAttributeValue); }
/// <summary> /// The add product attribute value. /// </summary> /// <param name="productAttributeValue"> /// The product attribute value. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int AddProductAttributeValue(Product_AttributeValue productAttributeValue) { return this.productAttributeValueDA.Insert(productAttributeValue); }
public ActionResult AddAttributeValue(string attributeValue, int Sorting, int isDefault, string productAttrID) { try { var productAttrValue = new Product_AttributeValue { AttributeValue = attributeValue, AttributeID = Convert.ToInt32(productAttrID), Sorting = Sorting, IsDefault = isDefault, }; //if (productAttributeValueModel != null) //{ // var productAttrValue = DataTransfer.Transfer<Product_AttributeValue>( // productAttributeValueModel, // typeof(ProductAttributeValueModel)); // productAttrValue.AttributeID = Convert.ToInt32(productAttrID); // productAttributeValueModel.ID = this.ProductAttributeValueService.AddProductAttributeValue(productAttrValue); // } return Json(""); } catch (Exception exception) { throw new Exception(exception.Message, exception); } }
public ActionResult ModifyAttributeValue(string attributeValue, int Sorting, int isDefault, int attributeID, int id) { try { var productAttrValue = new Product_AttributeValue { AttributeID = attributeID, AttributeValue = attributeValue, CreateTime = DateTime.Now, ID = id, IsDefault = isDefault, Sorting = Sorting }; this.ProductAttributeValueService.ModifyProductAttributeValue(productAttrValue); } catch (Exception exception) { throw new Exception(exception.Message, exception); } return Json(new AjaxResponse { Data = 1, Message = "修改成功" }); }
public void Update(Product_AttributeValue productAttributeValue) { if (productAttributeValue == null) { throw new ArgumentNullException("productAttributeValue"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "ID", SqlDbType.Int, productAttributeValue.ID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "AttributeValue", SqlDbType.NVarChar, productAttributeValue.AttributeValue, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, productAttributeValue.Sorting, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "IsDefault", SqlDbType.Int, productAttributeValue.IsDefault, ParameterDirection.Input ), this.SqlServer.CreateSqlParameter( "AttributeID", SqlDbType.Int, productAttributeValue.AttributeID, ParameterDirection.Input ) }; try { this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_AttributeValue_Update", parameters, null); } catch (Exception exception) { throw new Exception("Exception - ProductAttributeValueDA - Update", exception); } }