//删除道菜
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;
}
