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