/// <summary>
/// 刪除組合商品的父商品和子商品價格數據
/// </summary>
/// <param name="delTemp"></param>
/// <returns></returns>
public bool comboPriceDeleteByVendor(ProductComboTemp delTemp)
{
ArrayList sqls = new ArrayList();
try
{
//刪除item_price_temp子商品的數據中的數據
ItemPriceTempMgr itemPriceMgr = new ItemPriceTempMgr("");
sqls.Add(itemPriceMgr.DeleteByVendor(delTemp.Parent_Id, delTemp.Combo_Type, delTemp.Writer_Id));
//刪除price_master_temp中的數據
PriceMasterTempMgr priceMasterTempMgr = new PriceMasterTempMgr("");
sqls.Add(priceMasterTempMgr.DeleteByVendor(new PriceMasterTemp { writer_Id = delTemp.Writer_Id, product_id = delTemp.Parent_Id, combo_type = delTemp.Combo_Type }));
return _mySql.ExcuteSqls(sqls);
}
catch (Exception ex)
{
throw new Exception("ProductComboTempMgr.comboPriceDeleteByVendor-->" + ex.Message + sqls.ToString(), 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);
}
}