public ActionResult DeleteSecondCategory([FromBody] SecondCategory secondCategory) { try { if (secondCategory == null || secondCategory.SecondCategoryId <= 0) { return(Ok(new { mark = "2", msg = "请求数据为空!" })); } secondCategory.Status = 3; // 改变状态 if (_secondCategoryService.ChangeSecondCategoryStatus(secondCategory)) { return(Ok(new { mark = "1", msg = "成功!" })); } return(Ok()); } catch (Exception ex) { Console.WriteLine(ex); return(Ok(new { mark = "2", msg = ex.Message })); } }
/// <summary> /// 二级分类变更 /// </summary> /// <param name="secondCategory"></param> /// <returns></returns> public bool ChangeSecondCategory(SecondCategory secondCategory) { try { if (secondCategory == null || secondCategory.SecondCategoryId <= 0 || secondCategory.FirstCategory == null || secondCategory.FirstCategory.FirstCategoryId <= 0) { return(false); } var sc = _dataContext.SecondCategories.FirstOrDefault(f => f.SecondCategoryId == secondCategory.SecondCategoryId); if (sc == null) { return(false); } sc.SecondCategoryName = secondCategory.SecondCategoryName; // 更新名称 sc.FirstCategory = new FirstCategory { FirstCategoryId = secondCategory.FirstCategory.FirstCategoryId }; sc.UpdateDate = DateTime.Now; // 更新时间 _dataContext.Entry(sc.FirstCategory).State = EntityState.Unchanged; // 大分类不修改 _dataContext.Update(sc); return(_dataContext.SaveChanges() > 0 ? true : false); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加二级分类 /// </summary> /// <param name="secondCategory"></param> /// <returns></returns> public int AddSecondCategory(SecondCategory secondCategory) { try { _dataContext.Entry(secondCategory.FirstCategory).State = EntityState.Unchanged; //状态变更为 不更新 _dataContext.SecondCategories.Update(secondCategory); return(_dataContext.SaveChanges() > 0 ? secondCategory.SecondCategoryId : 0); } catch (Exception ex) { throw ex; } }
public ActionResult AddSecondCategory([FromBody] SecondCategory secondCategory) { try { if (secondCategory == null || secondCategory.FirstCategory == null || secondCategory.FirstCategory.FirstCategoryId <= 0) { return(Ok(new { mark = "2", msg = "请求数据为空" })); } secondCategory.CreateDate = DateTime.Now; secondCategory.UpdateDate = DateTime.Now; secondCategory.Status = 1; var result = _secondCategoryService.AddSecondCategory(secondCategory); if (result > 0) { return(Ok(new { mark = "1", msg = "成功" })); } return(Ok(new { mark = "2", msg = "失败" })); } catch (Exception ex) { Console.WriteLine(ex); return(Ok(new { mark = "2", msg = ex.Message })); } }
public ActionResult ChangeSecondCategory([FromBody] SecondCategory secondCategory) { try { if (secondCategory == null || secondCategory.SecondCategoryId <= 0 || string.IsNullOrEmpty(secondCategory.SecondCategoryName)) { return(Ok(new { mark = "2", msg = "请求数据为空!" })); } if (_secondCategoryService.ChangeSecondCategory(secondCategory)) { return(Ok(new { mark = "1", msg = "成功!" })); } return(Ok(new { mark = "2", msg = "失败!" })); } catch (Exception ex) { Console.WriteLine(ex); return(Ok(new { mark = "2", msg = ex.Message })); } }
/// <summary> /// 获取二级分类总数 /// </summary> /// <param name="secondCategory"></param> /// <returns></returns> public int GetTotalCountOfSecondCategories(SecondCategory secondCategory) { try { var query = _dataContext.SecondCategories.Where(sc => 1 == 1); if (secondCategory != null) { if (secondCategory.Status > 0) { query = query.Where(sc => sc.Status == secondCategory.Status); } if (!string.IsNullOrEmpty(secondCategory.SecondCategoryName)) { query = query.Where(sc => sc.SecondCategoryName.Contains(secondCategory.SecondCategoryName)); } } return(query.Count()); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取小分类 /// </summary> /// <param name="secondCategory"></param> /// <returns></returns> public IEnumerable <SecondCategory> GetSecondCategories(SecondCategory secondCategory) { try { var result = from sc in _dataContext.SecondCategories join fc in _dataContext.FirstCategories on sc.FirstCategory.FirstCategoryId equals fc.FirstCategoryId select new SecondCategory { SecondCategoryId = sc.SecondCategoryId, SecondCategoryName = sc.SecondCategoryName, FirstCategory = fc }; if (secondCategory?.FirstCategory != null && secondCategory.FirstCategory.FirstCategoryId > 0) { result = result.Where(sc => sc.FirstCategory.FirstCategoryId == secondCategory.FirstCategory.FirstCategoryId); } return(result.ToList()); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取小分类 /// </summary> /// <returns></returns> public object GetSecondCategories(SecondCategory secondCategory, int currentPage = 1, int pageSize = 10) { try { var query = (from sc in _dataContext.SecondCategories select new { sc.SecondCategoryId, sc.SecondCategoryName, sc.Status, sc.CreateDate, FirstCategory = _dataContext.FirstCategories.FirstOrDefault(x => x.FirstCategoryId == sc.FirstCategory.FirstCategoryId), PostCount = _dataContext.PostInfos.Count(x => x.SecondCategory.SecondCategoryId == sc.SecondCategoryId) }) .Skip((currentPage - 1) * pageSize) .Take(pageSize); if (secondCategory != null) { if (secondCategory.Status > 0) { query = query.Where(sc => sc.Status == secondCategory.Status); } if (!string.IsNullOrEmpty(secondCategory.SecondCategoryName)) { query = query.Where(sc => sc.SecondCategoryName.Contains(secondCategory.SecondCategoryName)); } } return(query); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改二级分类状态 /// </summary> /// <returns></returns> public bool ChangeSecondCategoryStatus(SecondCategory secondCategory) { try { if (secondCategory == null || secondCategory.SecondCategoryId <= 0) { return(false); } var sc = _dataContext.SecondCategories.FirstOrDefault(s => s.SecondCategoryId == secondCategory.SecondCategoryId); if (sc == null) { return(false); } sc.Status = secondCategory.Status; sc.UpdateDate = DateTime.Now; _dataContext.Update(sc); return(_dataContext.SaveChanges() > 0 ? true : false); } catch (Exception ex) { Console.WriteLine(ex); throw ex; } }