项目图片
DAL
增
using EF.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace EF.DAL
{
public class AddBaseDal<T> where T:class
{
BaseDbContext db = new BaseDbContext();
public void Add(T t)
{
db.Set<T>().Add(t);
db.SaveChanges();
}
}
public class AddTA_Bll : AddBaseDal<TA>
{
}
public class AddTB_Bll : AddBaseDal<TB>
{
}
}
查
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace EF.DAL
{
using EF.Entity;
using System.Linq.Expressions;
//写一个父类,公用的用于查询的方法
public class QueryBaseDal<T> where T : class
{
BaseDbContext db = new BaseDbContext();
public List<T> QueryWhere(Expression<Func<T,bool>> where)
{
return db.Set<T>().Where(where).ToList();
}
}
public class QueryTA_Dal : QueryBaseDal<TA>
{
}
public class QueryTB_DaL : QueryBaseDal<TB>
{
}
}
BLL层
增
using EF.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace EF.BLL
{
using EF.DAL;
public class AddBaseBll<T> where T:class
{
public void Add(T t)
{
AddBaseDal<T> dal = new AddBaseDal<T>();
dal.Add(t);
}
}
public class AddTA_Bll : AddBaseBll<TA>
{
}
public class AddTB_Bll : AddBaseBll<TB>
{
}
}
查
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace EF.BLL
{
using EF.DAL;
using EF.Entity;
using System.Linq.Expressions;
public class QueryBaseBll<T>where T:class
{
public List<T> QueryWhere(Expression<Func<T,bool>> where)
{
QueryBaseDal<T> dal = new QueryBaseDal<T>();
return dal.QueryWhere(where);
}
}
public class QueryTA_Bll : QueryBaseBll<TA>
{
}
public class TB_Bll : QueryBaseBll<TB>
{
}
}