//根据ID查询大类 public DishType LoadParentId(int? id) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { DishType type = new DishType(); ; if (id != null) { type = (DishType)entities.DishType.Where(info => info.DishTypeId == id && info.Deleted == 0 && info.Status == 0).Single(); if (type == null) { type = new DishType(); } } return type; }; } catch (Exception e) { throw e; } }
/// <summary> /// 根据菜品单位和菜品类别对象加载菜品基本数据 /// </summary> /// <param name="dus"></param> /// <param name="sub"></param> private void LoadDishBaseData(List<DishUnit> dus, DishType sub) { if (dus == null||sub==null) { return; } ICollection<Dish> dishes = sub.Dish; LoadDishData(dus, dishes); }
/// <summary> /// 批量保存 /// </summary> /// <param name="child"></param> private void SaveBatch(DishType child) { ICollection<Dish> dishes = child.Dish; if (dishes != null && dishes.Count > 0) { foreach (var dish in dishes) { //获取菜品下说有的做法 List<DischesWayRef> dwrs = _DataService.QueryAllByDishesId(dish.DishId); foreach (var selectedItem in DishesWaySelectedItems) { //根据小类id查找所有的菜品 //插入到做法关联表中 bool flag = true; foreach (var dwr in dwrs) { //判断是否已然存在 if (selectedItem.DischesWayId == dwr.DischesWayId) { flag = false; break; } } if(flag) _DataService.Add(dish.DishId, selectedItem.DischesWayId); } } } }
public bool DeleteType(int typeId) { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { DishType type = new DishType(); type.DishTypeId = typeId; type.Deleted = 1; DbEntityEntry<DishType> entry = entities.Entry<DishType>(type); entry.State = System.Data.Entity.EntityState.Unchanged;//Modified entry.Property("Deleted").IsModified = true; entry.Property("DishTypeId").IsModified = false; entities.Configuration.ValidateOnSaveEnabled = false; var result = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; if (result == 1) { return true; } else { return false; } } }
public bool UpdateType(DishType type) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { DbEntityEntry<DishType> entry = entities.Entry<DishType>(type); entry.State = System.Data.Entity.EntityState.Unchanged;//Modified entry.Property("Name").IsModified = true; entry.Property("DishTypeId").IsModified = false; //TODO 如果更新状态为“删除”则要检查是否关联了菜品 try { entities.Configuration.ValidateOnSaveEnabled = false; int result = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; if (result == 1) { return true; } else { return false; } } catch (Exception e) { Console.WriteLine(e.ToString()); return false; } } } catch (Exception e) { throw e; } }
public Hashtable SaveType(DishType type) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { try { Hashtable hash = new Hashtable();//返回结果 List<DishType> types; //检查类型编号或者类型名称是否重复 types = entities.DishType.Where(info => info.Deleted == 0 && (info.Name == type.Name || info.Code == type.Code)).ToList(); if (types != null && types.Count > 0) { hash.Add("code", 1); if (types[0].Name == type.Name) { hash.Add("message", "类型名称已经存在,请重新命名!"); } else if (types[0].Code == type.Code) { hash.Add("message", "类型编号已经存在!"); } return hash; } entities.DishType.Add(type); int result = entities.SaveChanges(); if (result == 1) { hash.Add("code", 0); hash.Add("message", "新增成功!"); } else { hash.Add("code", 2); hash.Add("message", "新增失败,请稍后再试!"); } return hash; } catch (Exception e) { throw e; } }; } catch (Exception e) { throw e; } }
public DishType LoadTypeById(int id) { try { DishType type; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { type = (DishType)entities.DishType.Include("Dish").Where(info => info.DishTypeId == id); if (type == null) { type = new DishType(); } return type; }; } catch (Exception e) { throw e; } }
public DishType LoadFatherTypeById(int Id) { try { using (ChooseDishesEntities entities = new ChooseDishesEntities()) { DishType fatherType; DishType type; type = (DishType)entities.DishType.Include("Dish").Where(info => info.DishTypeId == Id); if (type == null) { fatherType = new DishType(); return fatherType; } fatherType = (DishType)entities.DishType.Include("Dish").Where(info => info.DishTypeId == type.ParentId); if (fatherType == null) { fatherType = new DishType(); } return fatherType; }; } catch (Exception e) { throw e; } }