public ActionResult AddAttribute(string productCateID, string productAttrName, string inputType, string dataType, int length)
{
try
{
if (string.IsNullOrEmpty(productCateID) || string.IsNullOrEmpty(productAttrName))
{
return Content("2");
}
var attr = new Product_Attribute
{
ProductCategoryID = Convert.ToInt32(productCateID),
AttributeName = productAttrName,
InputType = inputType,
DataType = dataType,
DataLength = length
};
this.ProductAttributeService.AddProductAttribute(attr);
return Content("1");
}
catch (Exception exception)
{
throw new Exception(exception.Message, exception);
}
}
/// <summary>
/// 添加商品属性.
/// </summary>
/// <param name="productAttribute">
/// 商品属性实体
/// </param>
/// <returns>
/// 添加记录的主键值.
/// </returns>
public int Insert(Product_Attribute productAttribute)
{
if (productAttribute == null)
{
throw new ArgumentNullException("productAttribute");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ProductCategoryID",
SqlDbType.NVarChar,
productAttribute.ProductCategoryID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"AttributeName",
SqlDbType.NVarChar,
productAttribute.AttributeName,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DataType",
SqlDbType.NVarChar,
productAttribute.DataType,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DataLength",
SqlDbType.Int,
productAttribute.DataLength,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"InputType",
SqlDbType.NVarChar,
productAttribute.InputType,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_Attribute_Insert", parameters, null);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
catch (Exception exception)
{
throw new Exception("Exception - ProductAttributeDA - Insert", exception);
}
}
/// <summary>
/// The modify product attribute.
/// </summary>
/// <param name="productAttribute">
/// The product attribute.
/// </param>
public void ModifyProductAttribute(Product_Attribute productAttribute)
{
this.productAttributeDA.Update(productAttribute);
}
/// <summary>
/// 修改图片信息.
/// </summary>
/// <param name="productAttribute">
/// 图片实体.
/// </param>
public void Update(Product_Attribute productAttribute)
{
if (productAttribute == null)
{
throw new ArgumentNullException("productAttribute");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
productAttribute.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"AttributeName",
SqlDbType.NVarChar,
productAttribute.AttributeName,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Sorting",
SqlDbType.Int,
productAttribute.Sorting,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"DataLength",
SqlDbType.Int,
productAttribute.DataLength,
ParameterDirection.Input),
this.sqlServer.CreateSqlParameter(
"InputType",
SqlDbType.NVarChar,
productAttribute.InputType,
ParameterDirection.Input
),
this.SqlServer.CreateSqlParameter(
"DataType",
SqlDbType.NVarChar,
productAttribute.DataType,
ParameterDirection.Input
)
};
try
{
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_Attribute_Update", parameters, null);
}
catch (Exception exception)
{
throw new Exception("Exception - ProductAttributeDA - Update", exception);
}
}
/// <summary>
/// The add product attribute.
/// </summary>
/// <param name="productAttribute">
/// The product attribute.
/// </param>
/// <returns>
/// The <see cref="int"/>.
/// </returns>
public int AddProductAttribute(Product_Attribute productAttribute)
{
return this.productAttributeDA.Insert(productAttribute);
}