public bool VendorDescriptionInfoUpdate(ProductTemp proTemp, List<ProductTagSetTemp> tagTemps, List<ProductNoticeSetTemp> noticeTemps)
{
try
{
ArrayList sqls = new ArrayList();
sqls.Add(_pTempDao.VendorDescriptionInfoSave(proTemp));
if (tagTemps != null)
{
IProductTagSetTempImplMgr _productTagSetTempMgr = new ProductTagSetTempMgr(connStr);
sqls.Add(_productTagSetTempMgr.DeleteVendor(new ProductTagSetTemp { Writer_Id = proTemp.Writer_Id, Combo_Type = proTemp.Combo_Type, product_id = proTemp.Product_Id }));
foreach (var item in tagTemps)
{
sqls.Add(_productTagSetTempMgr.VendorTagSetTempSave(item));
}
}
if (noticeTemps != null)
{
IProductNoticeSetTempImplMgr _productNoticeSetTempMgr = new ProductNoticeSetTempMgr(connStr);
sqls.Add(_productNoticeSetTempMgr.DeleteVendor(new ProductNoticeSetTemp { Writer_Id = proTemp.Writer_Id, Combo_Type = proTemp.Combo_Type, product_id = proTemp.Product_Id }));
foreach (var item in noticeTemps)
{
sqls.Add(_productNoticeSetTempMgr.Save_Vendor(item));
}
}
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(sqls);
}
catch (Exception ex)
{
throw new Exception("ProductTempMgr.VendorDescriptionInfoSave-->" + ex.Message, ex);
}
}
/// <summary>
/// 刪除供應商商品數據
/// </summary>
/// <returns></returns>
public bool DeleteVendorProductTemp(int writerId, int combo_type, string product_Id)
{
try
{
ArrayList sqls = new ArrayList();
sqls.Add(DeleteProductTemp(new ProductTemp { Writer_Id = writerId, Combo_Type = combo_type, Product_Id = product_Id }));
ProductItemTempMgr proItemTempMgr = new ProductItemTempMgr("");
sqls.Add(proItemTempMgr.DeleteVendorSql(new ProductItemTemp { Writer_Id = writerId, Product_Id = product_Id }));
ProductNoticeSetTempMgr proNoticeSetTempMgr = new ProductNoticeSetTempMgr("");
sqls.Add(proNoticeSetTempMgr.DeleteVendor(new ProductNoticeSetTemp { Writer_Id = writerId, Combo_Type = combo_type, product_id = product_Id }));
ProductTagSetTempMgr proTagSetTempMgr = new ProductTagSetTempMgr("");
sqls.Add(proTagSetTempMgr.DeleteVendor(new ProductTagSetTemp { Writer_Id = writerId, Combo_Type = combo_type, product_id = product_Id }));
ProductSpecTempMgr proSpecTempMgr = new ProductSpecTempMgr("");
sqls.Add(proSpecTempMgr.TempDeleteByVendor(new ProductSpecTemp { Writer_Id = writerId, product_id = product_Id }));
ProductPictureTempImplMgr proPicTempMgr = new ProductPictureTempImplMgr("");
sqls.Add(proPicTempMgr.DeleteByVendor(new ProductPictureTemp { writer_Id = writerId, combo_type = combo_type, product_id = product_Id }));
ProductCategorySetTempMgr proCateSetTempMgr = new ProductCategorySetTempMgr("");
sqls.Add(proCateSetTempMgr.TempDeleteByVendor(new ProductCategorySetTemp { Writer_Id = writerId, Combo_Type = combo_type, Product_Id = product_Id }));
ItemPriceTempMgr itemPriceMgr = new ItemPriceTempMgr("");
sqls.Add(itemPriceMgr.DeleteByVendor(product_Id.ToString(), combo_type, writerId));
PriceMasterTempMgr priceMasterTempMgr = new PriceMasterTempMgr("");
sqls.Add(priceMasterTempMgr.DeleteByVendor(new PriceMasterTemp { writer_Id = writerId, product_id = product_Id, combo_type = combo_type }));
ProductComboTempMgr proComboTempMgr = new ProductComboTempMgr("");
sqls.Add(proComboTempMgr.TempDeleteByVendor(new ProductComboTemp { Writer_Id = writerId, Parent_Id = product_Id }));
MySqlDao mySqlDao = new MySqlDao(connStr);
return mySqlDao.ExcuteSqls(sqls);
}
catch (Exception ex)
{
throw new Exception("ProductTempMg.DeleteTemp-->" + ex.Message, ex);
}
}
