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(); }
/// <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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); }