Ejemplo n.º 1
0
        public void UpdateProductCommonInfoIsVirtualPic(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoIsVirtualPic");

            dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            dc.SetParameterValue("@IsVirtualPic", productCommonInfo.ProductBasicInfo.IsVirtualPic);
            dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            dc.ExecuteNonQuery();
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 修改商品描述
        /// </summary>
        /// <param name="productCommonInfo"></param>
        /// <param name="operationUser"></param>
        public void UpdateProductCommonInfoDesc(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductCommonInfoDesc");

            cmd.SetParameterValue("@Description", productCommonInfo.ProductBasicInfo.ShortDescription.Content);
            cmd.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            cmd.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            cmd.ExecuteNonQuery();
        }
Ejemplo n.º 3
0
        public void UpdateProductCommonInfoGroupSysNo(int productGroupSysNo, ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductCommonInfoGroupSysNo");

            cmd.SetParameterValue("@ProductGroupSysNo", productGroupSysNo);
            cmd.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            cmd.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            cmd.ExecuteNonQuery();
        }
Ejemplo n.º 4
0
        private void InsertProductCommonInfoEx(ProductCommonInfo productCommonInfo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductCommonInfoEx");

            cmd.SetParameterValue("@SysNo", productCommonInfo.ProductCommonInfoSysNo);
            cmd.SetParameterValue("@Performance", productCommonInfo.ProductBasicInfo.Performance);
            cmd.SetParameterValue("@ProductDescLong", productCommonInfo.ProductBasicInfo.LongDescription.Content);
            cmd.SetParameterValue("@ProductPhotoDesc", productCommonInfo.ProductBasicInfo.PhotoDescription.Content);
            cmd.ExecuteNonQuery();
        }
Ejemplo n.º 5
0
        public void UpdateProductCommonInfoDescription(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoDescription");

            dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            dc.SetParameterValue("@ProductDescLong", productCommonInfo.ProductBasicInfo.LongDescription.Content);
            dc.SetParameterValue("@ProductPhotoDesc", productCommonInfo.ProductBasicInfo.PhotoDescription.Content);
            dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            dc.ExecuteNonQuery();
        }
Ejemplo n.º 6
0
        public void UpdateProductCommonInfoDimensionInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoDimensionInfo");

            dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            dc.SetParameterValue("@Weight", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Weight);
            dc.SetParameterValue("@IsLarge", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.LargeFlag);
            dc.SetParameterValue("@Length", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Length);
            dc.SetParameterValue("@Width", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Width);
            dc.SetParameterValue("@Height", productCommonInfo.ProductBasicInfo.ProductDimensionInfo.Height);
            dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            dc.ExecuteNonQuery();
        }
Ejemplo n.º 7
0
        public void UpdateProductCommonInfoWarrantyInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoWarrantyInfo");

            dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            dc.SetParameterValue("@HostWarrantyDay", productCommonInfo.ProductWarrantyInfo.HostWarrantyDay);
            dc.SetParameterValue("@PartWarrantyDay", productCommonInfo.ProductWarrantyInfo.PartWarrantyDay);
            dc.SetParameterValue("@Warranty", productCommonInfo.ProductWarrantyInfo.Warranty.Content);
            dc.SetParameterValue("@ServicePhone", productCommonInfo.ProductWarrantyInfo.ServicePhone);
            dc.SetParameterValue("@ServiceInfo", productCommonInfo.ProductWarrantyInfo.ServiceInfo);
            dc.SetParameterValue("@IsOfferInvoice", productCommonInfo.ProductWarrantyInfo.OfferVATInvoice);
            dc.SetParameterValue("@IsWarrantyShow", productCommonInfo.ProductWarrantyInfo.WarrantyShow);
            dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            dc.SetParameterValue("@EditId", operationUser.SysNo);
            dc.ExecuteNonQuery();
        }
Ejemplo n.º 8
0
        private void InsertProductCommonInfoStatus(ProductCommonInfo productCommonInfo)
        {
            DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductCommonInfoStatus");

            cmd.SetParameterValue("@CommonSKUNumber", productCommonInfo.ProductBasicInfo.CommonSkuNumber);
            cmd.SetParameterValue("@IsChangeStyleWithTemplate", "Y");
            cmd.SetParameterValue("@IsExtendWarrantyDisuse", "N");
            cmd.SetParameterValue("@IsBasicInformationCorrect", "Y");
            cmd.SetParameterValue("@IsAccessoriesShow", productCommonInfo.ProductBasicInfo.IsAccessoryShow);
            cmd.SetParameterValue("@IsAccessoriesCorrect", "Y");
            cmd.SetParameterValue("@IsVirtualPic", productCommonInfo.ProductBasicInfo.IsVirtualPic);
            cmd.SetParameterValue("@IsPictureCorrect", "Y");
            cmd.SetParameterValue("@IsWarrantyCorrect", "Y");
            cmd.SetParameterValue("@IsWarrantyShow", productCommonInfo.ProductWarrantyInfo.WarrantyShow);
            cmd.SetParameterValue("@IsWeightCorrect", "Y");
            cmd.ExecuteNonQuery();
        }
Ejemplo n.º 9
0
        public void UpdateProductCommonInfoBasicInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser)
        {
            DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoBasicInfo");

            dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo);
            dc.SetParameterValue("@ProductTitle", productCommonInfo.ProductBasicInfo.ProductTitle.Content);
            dc.SetParameterValue("@ProductBriefName", productCommonInfo.ProductBasicInfo.ProductBriefName);
            dc.SetParameterValue("@Keywords", productCommonInfo.ProductBasicInfo.Keywords.Content);
            dc.SetParameterValue("@ProductModel", productCommonInfo.ProductBasicInfo.ProductModel.Content);
            dc.SetParameterValue("@ProductType", productCommonInfo.ProductBasicInfo.ProductType);
            dc.SetParameterValue("@PMUserSysNo", productCommonInfo.ProductBasicInfo.ProductManager.SysNo);
            dc.SetParameterValue("@ProductDescription", productCommonInfo.ProductBasicInfo.ShortDescription.Content);
            dc.SetParameterValue("@PackageList", productCommonInfo.ProductBasicInfo.PackageList.Content);
            dc.SetParameterValue("@ProductLink", productCommonInfo.ProductBasicInfo.ProductLink);
            dc.SetParameterValue("@Attention", productCommonInfo.ProductBasicInfo.Attention.Content);
            dc.SetParameterValue("@IsTakePicture", productCommonInfo.ProductBasicInfo.IsTakePicture);
            dc.SetParameterValue("@UPCCode", productCommonInfo.ProductBasicInfo.UPCCode);
            dc.SetParameterValue("@BMCode", productCommonInfo.ProductBasicInfo.BMCode);
            dc.SetParameterValue("@EditUser", operationUser.UserDisplayName);
            dc.SetParameterValue("@EditUserSysNo", operationUser.SysNo);
            dc.ExecuteNonQuery();
        }