您好,登录后才能下订单哦!
实现代码
1、新建接口类:IRepository.cs,规范各个操作类的都有那些方法,方便管理。
using System;using System.Collections.Generic;using System.Linq;using System.Linq.Expressions;using System.Text;namespace CMS.Entity.Interfaces { public interface IRepository<T> where T:class { /// <summary> /// 添加 /// </summary> /// <param name="entity">实体对象</param> void Add(T entity); /// <summary> /// 更新 /// </summary> /// <param name="entity">实体对象</param> void Update(T entity); /// <summary> /// 删除 /// </summary> /// <param name="entity">实体对象</param> void Delete(T entity); /// <summary> /// 删除 /// </summary> /// <param name="where">条件(lambda表达式)</param> void Delete(Expression<Func<T, bool>> where); /// <summary> /// 根据ID获取一个对象 /// </summary> /// <param name="Id">主键ID</param> /// <returns>对象</returns> T GetById(long Id); /// <summary> /// 根据ID获取一个对象 /// </summary> /// <param name="Id">主键ID</param> /// <returns>对象</returns> T GetById(string Id); /// <summary> /// 根据条件获取一个对象 /// </summary> /// <param name="where">条件(lambda表达式)</param> /// <returns>对象</returns> T Get(Expression<Func<T, bool>> where); /// <summary> /// 获取所有数据 /// </summary> /// <returns>所有数据</returns> IQueryable<T> GetAll(); /// <summary> /// 根据条件获取数据 /// </summary> /// <param name="where">条件(lambda表达式)</param> /// <returns>数据</returns> IQueryable<T> GetMany(Expression<Func<T, bool>> where); /// <summary> /// 根据条件获取记录数 /// </summary> /// <param name="where">条件(lambda表达式)</param> /// <returns></returns> int GetCount(Expression<Func<T, bool>> where); /// <summary> /// 关闭代理 /// </summary> void CloseProxy(); /// <summary> /// 打开代理 /// </summary> void OpenProxy(); /// <summary> /// 是否有指定条件的元素 /// </summary> /// <param name="where">条件(lambda表达式)</param> /// <returns></returns> bool IsHasValue(Expression<Func<T, bool>> where); } }
2、新建仓储基础操作类RepositoryBase.cs,注意要一一对应实现IRepositroy接口的方法
using System;using System.Collections.Generic;using System.Text;using System.Linq;namespace CMS.Entity.Interfaces { public abstract class BaseRepository<T> where T: class { private BcmfDBContext db;//数据库上下文 public BaseRepository(BcmfDBContext _db) { db = _db; } public virtual void Save() { db.SaveChanges(); } public virtual void Add(T entity) { db.Set<T>().Add(entity); } public virtual void CloseProxy() { db.Database.CommitTransaction(); } public virtual void Delete(T entity) { db.Set<T>().Remove(entity); } public virtual void Delete(System.Linq.Expressions.Expression<Func<T, bool>> where) { var dataList = db.Set<T>().Where(where).AsEnumerable(); db.Set<T>().RemoveRange(dataList); } public virtual T Get(System.Linq.Expressions.Expression<Func<T, bool>> where) { return db.Set<T>().FirstOrDefault(where); } public virtual System.Linq.IQueryable<T> GetAll() { return db.Set<T>(); } public virtual T GetById(long Id) { return db.Set<T>().Find(Id); } public virtual T GetById(string Id) { return db.Set<T>().Find(Id); } public virtual int GetCount(System.Linq.Expressions.Expression<Func<T, bool>> where) { return db.Set<T>().Count(where); } public virtual System.Linq.IQueryable<T> GetMany(System.Linq.Expressions.Expression<Func<T, bool>> where) { return db.Set<T>().Where(where); } public virtual bool IsHasValue(System.Linq.Expressions.Expression<Func<T, bool>> where) { return db.Set<T>().Any(where); } public virtual void OpenProxy() { db.Database.BeginTransaction(); } public virtual void Update(T entity) { db.Set<T>().Attach(entity); db.Entry<T>(entity).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } } }
3、新建仓储类TUserRepository与TOperateLogRepository,TUserRepository用于操作用户表,TOperateLogRepository用于操作用户记录表,对应的User类与OperateLog类根据项目需求自行创建
using System;using System.Collections.Generic;using System.Text;using CMS.Entity.Repository;using CMS.Entity.Entity;using Microsoft.EntityFrameworkCore;using System.Linq;using CMS.Entity.Interfaces;namespace CMS.Entity.Repository { public class TUserRepository :BaseRepository<User>,IUserRepository { public TUserRepository(BcmfDBContext db) : base(db) { } } public interface IUserRepository : IRepository<User> { } }
using System;using System.Collections.Generic;using System.Text;using CMS.Entity.Repository;using CMS.Entity.Entity;using Microsoft.EntityFrameworkCore;using System.Linq;using CMS.Entity.Interfaces;namespace CMS.Entity.Repository { public class TOperateLogRepository : BaseRepository<OperateLog>, IOperateLogRepository { public TOperateLogRepository(BcmfDBContext db) : base(db) { } } public interface IOperateLogRepository : IRepository<OperateLog> { } }
4、分别在UserController与OperateLogController控制器中的构造函数注入仓储类
using System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks;using Microsoft.AspNetCore.Http;using Microsoft.AspNetCore.Mvc;using CMS.Entity;using CMS.Entity.Entity;using Newtonsoft.Json;using CMS.WebApi.Core;using Microsoft.EntityFrameworkCore.Query;using CMS.Entity.Repository;namespace CMS.WebApi.Controllers { /// <summary> /// 用户中心 /// </summary> //[Produces("application/json")] [Route("api/[controller]")] [ApiController] public class UsersController : ControllerBase { private readonly IUserRepository userRepository; public UsersController(IUserRepository _userRepository) { userRepository = _userRepository; } /// <summary> /// 获取用户列表 /// </summary> /// <returns></returns> [HttpGet] public string Get() { var userList= userRepository.GetAll().ToList(); return JsonConvert.SerializeObject(userList); } } }
using System;using System.Collections.Generic;using System.Linq;using System.Threading.Tasks;using Microsoft.AspNetCore.Http;using Microsoft.AspNetCore.Mvc;using CMS.Entity.Repository;using Newtonsoft.Json;namespace CMS.WebApi.Controllers { [Route("api/[controller]")] [ApiController] public class OperateLogController : ControllerBase { private readonly IOperateLogRepository operateLogRepository; public OperateLogController(IOperateLogRepository _operateLogRepository) { operateLogRepository = _operateLogRepository; } [HttpGet] public string Get() { var result = operateLogRepository.GetMany(m=>m.ActionLogId<100); return JsonConvert.SerializeObject(result); } } }
5、完成上述操作后,运行获取数据时会系统报错,那是由于还没将仓储类注入到服务中,接下来就实现用AutoFac注入仓储类到项目服务中
添加引用Autofac,Auto.Configuration,Autofac.Extensions.DependencyInjection到项目中
这里贴出Nuget程序控制台命令:
Install-Package Autofac -Version 4.9.2
Install-Package Autofac.Configuration -Version 4.1.0
Install-Package Autofac.Extensions.DependencyInjection -Version 4.4.0
6、打开项目Startup.cs,找到ConfigureServices方法,将void改为IServiceProvider返回值,如下
//先引用命名空间 using Autofac; using Autofac.Extensions.DependencyInjection; builder = builder.RegisterAssemblyTypes(=> t.Name.EndsWith( container =
7、重新生成发布项目,完成
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。