public ActionResult CourseDetailItemQuery(int productId = 0, bool detail = false)//edit by wwei0216w productId 一個初始值,防止報錯 { if (detail)//詳情頁查詢 { ICourseDetailItemImplMgr _courseDetailItemMgr = new CourseDetailItemMgr(connectionString); return Json(_courseDetailItemMgr.QueryName(productId)); } if (productId == 0)//查詢臨時表 { ICourseDetailItemTempImplMgr _courseDetailItemTempMgr = new CourseDetailItemTempMgr(connectionString); return Json(_courseDetailItemTempMgr.Query((Session["caller"] as Caller).user_id, productId)); } else//查詢正式表 { ICourseDetailItemImplMgr _courseDetailItemMgr = new CourseDetailItemMgr(connectionString); return Json(_courseDetailItemMgr.Query(productId)); } }
public ActionResult CourseDetailItemSave(string itemStr, string delItemStr, uint productId) { bool result = true; var courseDetailItems = JsonConvert.DeserializeObject<List<CourseDetailItemTemp>>(itemStr); var delList = JsonConvert.DeserializeObject<List<CourseDetailItemTemp>>(delItemStr); if (productId == 0)//操作臨時表 { courseDetailItems.ForEach(c => c.Writer_Id = (Session["caller"] as Caller).user_id); ICourseDetailItemTempImplMgr _courseDetailItemTempMgr = new CourseDetailItemTempMgr(connectionString); result = _courseDetailItemTempMgr.Save(courseDetailItems, delList); } else//正式表 { ICourseDetailItemImplMgr _courseDetailItemMgr = new CourseDetailItemMgr(connectionString); var list = courseDetailItems.Select(c => (CourseDetailItem)c).ToList(); var deleteList = delList.Select(c => (CourseDetailItem)c).ToList(); result = _courseDetailItemMgr.Save(list, deleteList); } return Json(new { success = result, Msg = "" }); }
/// <summary> /// 刪除商品 /// </summary> /// <returns></returns> public bool Delete(uint product_Id) { ArrayList delList = new ArrayList(); ProductComboMgr proComboMgr = new ProductComboMgr(""); delList.Add(proComboMgr.Delete(Convert.ToInt32(product_Id))); ItemPriceMgr itemPriceMgr = new ItemPriceMgr(""); delList.Add(itemPriceMgr.DeleteByProductId(Convert.ToInt32(product_Id))); PriceMasterMgr priceMaster = new PriceMasterMgr(""); delList.Add(priceMaster.DeleteByProductId(Convert.ToInt32(product_Id))); ProductTagSetMgr proTagSetMgr = new ProductTagSetMgr(""); delList.Add(proTagSetMgr.Delete(new ProductTagSet { product_id = product_Id })); ProductNoticeSetMgr proNoticeSetMgr = new ProductNoticeSetMgr(""); delList.Add(proNoticeSetMgr.Delete(new ProductNoticeSet { product_id = product_Id })); ProductPictureMgr proPicMgr = new ProductPictureMgr(""); delList.Add(proPicMgr.Delete(Convert.ToInt32(product_Id))); ProductSpecMgr proSpecMgr = new ProductSpecMgr(""); delList.Add(proSpecMgr.Delete(product_Id)); ProductCategorySetMgr proCategorySetMgr = new ProductCategorySetMgr(""); delList.Add(proCategorySetMgr.Delete(new ProductCategorySet { Product_Id = product_Id })); #region 課程相關 CourseProductMgr courProdMgr = new CourseProductMgr(""); delList.Add(courProdMgr.Delete(product_Id)); CourseDetailItemMgr courDetaItemMgr = new CourseDetailItemMgr(""); delList.Add(courDetaItemMgr.Delete(product_Id)); #endregion ProductItemMgr proItemMgr = new ProductItemMgr(""); delList.Add(proItemMgr.Delete(new ProductItem { Product_Id = product_Id })); ProductStatusHistoryMgr proStatusHistoryMgr = new ProductStatusHistoryMgr(""); delList.Add(proStatusHistoryMgr.Delete(new ProductStatusHistory { product_id = product_Id })); #region 推薦商品刪除 add by zhuoqin0830w 2015/10/08 RecommendedProductAttributeMgr recommendedProductAttributeMgr = new RecommendedProductAttributeMgr(""); delList.Add(recommendedProductAttributeMgr.DeleteProductAttribute(Convert.ToInt32(product_Id))); #endregion delList.Add(_productDao.Delete(product_Id)); MySqlDao mySqlDao = new MySqlDao(connectionStr); return mySqlDao.ExcuteSqls(delList); }