restaurant.UI/restaurant.DAL/DishInfoDal.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using restaurant.Model;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace restaurant.DAL
{
    public class DishInfoDal
    {
        DbContext dbContext = new MyDbContext();

        public List<DishInfo> GetList(DishInfo entity)
        {
            if (entity == null)
            {
                return dbContext.Set<DishInfo>().Where(u => u.DIsDelete == false).ToList();
            }
            else
            {
                if (entity.DType == "全部")
                {
                    return dbContext.Set<DishInfo>().Where(u => u.DIsDelete == false).Where(u => u.DTitle.Contains(entity.DTitle)).ToList();
                }
                else
                {
                    return dbContext.Set<DishInfo>().Where(u => u.DIsDelete == false).Where(u => u.DTitle.Contains(entity.DTitle) && u.DType == entity.DType).ToList();
                }
            }
        }

        public DishInfo GetById(int id)
        {
            return dbContext.Set<DishInfo>().Where(u => u.DIsDelete == false && u.DId == id).FirstOrDefault();
        }

        public int Add(DishInfo entity)
        {
            dbContext.Set<DishInfo>().Add(entity);
            return dbContext.SaveChanges();
        }

        public int Update(DishInfo entity)
        {
            dbContext.Set<DishInfo>().AddOrUpdate(entity);
            return dbContext.SaveChanges();
        }

        public int DeleteById(int id)
        {
            DishInfo entity = dbContext.Set<DishInfo>().Where(u => u.DId == id).FirstOrDefault();
            entity.DIsDelete = true;
            return dbContext.SaveChanges();
        }
    }
}