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