//删除道菜 public int delDishDao(DishDao dishDao) { int flag = 0; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { //直接修改的方式 DbEntityEntry<DishDao> entry = entities.Entry<DishDao>(dishDao); entry.State = System.Data.Entity.EntityState.Unchanged; //设置修改状态为ture 否则数据库不会更新 entry.Property("UpdateBy").IsModified = true; entry.Property("Deleted").IsModified = true; entry.Property("UpdateDatetime").IsModified = true; try { //关闭实体验证,不关闭验证需要整个对象全部传值 entities.Configuration.ValidateOnSaveEnabled = false; flag = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; } catch (Exception ex) { ex.ToString(); } } return flag; }
public int EditByDishDao(DishDao dish) { int flag = 0; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { //查询道菜是否存在 var type = entities.DishDao.SingleOrDefault(bt => bt.DishDaoId == dish.DishDaoId && bt.Deleted == 0); if (type != null) { //设置属性是否参与修改 ,设置为false则无法更新数据 type.Name = dish.Name; type.OptionalNumber = dish.OptionalNumber; type.UpdateDatetime = dish.UpdateDatetime; type.UpdateBy = dish.UpdateBy; try { //关闭实体验证,不关闭验证需要整个对象全部传值 entities.Configuration.ValidateOnSaveEnabled = false; //操作数据库 flag = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; } catch (Exception ex) { ex.ToString(); } } else { //实体绑定MODEL entities.DishDao.Add(dish); try { //操作数据库 entities.Configuration.ValidateOnSaveEnabled = false; flag = entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; } catch (Exception ex) { ex.ToString(); } } } return flag; }
public DishDao CreateDishDao(DishDaoBean bean) { DishDao beanBack = new DishDao(); beanBack.DishDaoId = bean.DishDaoId; beanBack.DishId = bean.DishId; beanBack.Name = bean.Name; beanBack.CreateDatetime = bean.CreateDatetime; beanBack.CreateBy = bean.CreateBy; beanBack.Deleted = bean.Deleted; beanBack.Status = bean.Status; beanBack.UpdateDatetime = bean.UpdateDatetime; beanBack.UpdateBy = bean.UpdateBy; beanBack.OptionalNumber = bean.OptionalNumber; return beanBack; }
public List<DishDao> queryByDishDaoID(DishDao dish) { List<DishDao> result; using (ChooseDishesEntities entities = new ChooseDishesEntities()) { //查询条件 Expression<Func<DishDao, bool>> checkCourse = DishDao => DishDao.DishId == dish.DishId && DishDao.Deleted == 0 && DishDao.Status == 0; result = entities.DishDao.Include(t =>t.Dish).Where(checkCourse).ToList(); } return result; }
public DishDaoBean CreateDishDaoBean(DishDao bean) { this.DishDaoId = bean.DishDaoId; this.DishId = bean.DishId; this.Name = bean.Name; this.CreateDatetime = bean.CreateDatetime; this.CreateBy = bean.CreateBy; this.Deleted = bean.Deleted; this.Status = bean.Status; this.UpdateDatetime = bean.UpdateDatetime; this.UpdateBy = bean.UpdateBy; this.OptionalNumber = bean.OptionalNumber; this.Change = false; return this; }