1.rptVideos 绑定页面 添加,查询组合,查询单个,删除 2. create database T go use T go --通用框架 Id主键 Deleted表示删除 create table tableA ( Id int primary key identity(1,1), Name varchar (10) not null, --伪删除 Deleted bit default(0) ) create table tableB ( Id int primary key identity(1,1), Name varchar (10) not null, rid int references tableA(Id) not null, --伪删除 Deleted bit default(0) ) 3. namespace Three.DAL { public class BaseDAL where T:BaseModel { protected TDbContext Model { get; set; } = new TDbContext(); //添加 public bool Insert(params T [] t) { var model = Model; model.Set().AddRange(t); return model.SaveChanges() > 0; } //查询组合 public List Select(Expression<Func<T,bool>> predicate) { var model = Model; return model.Set().Where(p=>p.Deleted!=true) .Where(predicate).ToList(); } //查询单个 public T Single(Expression<Func<T, bool>> predicate) { var model = Model; return model.Set().Where(p => p.Deleted != true).SingleOrDefault(predicate); } //删除 public bool Delete(T t) { var model = Model; var data= model.Set().SingleOrDefault(p=>p.Id==t.Id); data.Deleted = true; return model.SaveChanges() > 0; } } }
