예제 #1
0
        /// <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);
        }
예제 #2
0
        /// <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);
        }