/// <summary> /// 新建商品属性 /// </summary> /// <param name="productSysNo">商品编号</param> /// <param name="productID">商品ID</param> /// <param name="property">属性</param> /// <returns></returns> public static bool CreateProductProperties(int productSysNo, string productID, ProductPropertyInfo property) { DataCommand cmd = DataCommandManager.GetDataCommand("CreateProductProperties"); cmd.SetParameterValue("@CommonSKUNumber", productID); cmd.SetParameterValue("@ProductSysNo", productSysNo); cmd.SetParameterValue("@PropertyGroupSysNo", property.PropertyGroupSysNo); cmd.SetParameterValue("@PropertySysNo", property.PropertySysNo); cmd.SetParameterValue("@PropertyValueSysNo", property.PropertyValueSysNo); cmd.SetParameterValue("@PropertyName", property.PropertyName); cmd.SetParameterValue("@PropertyGroupName", property.PropertyGroupName); cmd.SetParameterValue("@ValueDescription", property.ValueDescription); cmd.SetParameterValue("@InUserSysNo", property.InUserSysNo); cmd.SetParameterValue("@InUserName", property.InUserName); cmd.SetParameterValue("@CompanyCode", property.CompanyCode); cmd.SetParameterValue("@LanguageCode", property.LanguageCode); cmd.ExecuteNonQuery(); return(true); }
/// <summary> /// 创建商品组分组属性 /// </summary> /// <param name="productGroupSysNo">商品组编号</param> /// <param name="propertyInfo">分组属性</param> /// <returns></returns> public static bool CreateProductGroupInfoPropertySetting(int productGroupSysNo, ProductPropertyInfo propertyInfo) { DataCommand cmd = DataCommandManager.GetDataCommand("CreateProductGroupInfoPropertySetting"); cmd.SetParameterValue("@ProductGroupSysNo", productGroupSysNo); cmd.SetParameterValue("@PropertySysNo", propertyInfo.PropertySysNo); cmd.SetParameterValue("@PropertyName", propertyInfo.PropertyName); cmd.SetParameterValue("@InUserName", propertyInfo.InUserName); cmd.SetParameterValue("@CompanyCode", propertyInfo.CompanyCode); cmd.SetParameterValue("@LanguageCode", propertyInfo.LanguageCode); cmd.ExecuteNonQuery(); return(true); }