足力健后端,使用.netcore版本,合并1个项目使用

IRepository.cs 3.1KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq.Expressions;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace System.Common
  8. {
  9. public interface IRepository<T> where T : class
  10. {
  11. /// <summary>
  12. /// 获取数量
  13. /// </summary>
  14. /// <param name="whereExpression"></param>
  15. /// <returns></returns>
  16. Task<int> GetCount(Expression<Func<T, bool>> whereExpression = null);
  17. /// <summary>
  18. /// 获取所有
  19. /// </summary>
  20. /// <returns></returns>
  21. Task<List<T>> GetList();
  22. Task<List<T>> GetListALL(Expression<Func<T, bool>> whereExpression);
  23. Task<List<T>> GetListALL(List<IConditionalModel> conModels, string orderby);
  24. Task<List<T>> GetListALL(Expression<Func<T, bool>> whereExpression, Expression<Func<T, object>> orderExpression, OrderByType ordertype = OrderByType.Asc);
  25. /// <summary>
  26. /// 分页获取所有
  27. /// </summary>
  28. /// <returns></returns>
  29. Task<PageData<T>> GetListByPage(List<IConditionalModel> conModels, PageModel pagemodel);
  30. Task<PageData<T>> GetListByPage(List<IConditionalModel> conModels, PageModel pagemodel, string orderby);
  31. Task<PageData<T>> GetListByPage(Expression<Func<T, bool>> whereExpression, PageModel pagemodel);
  32. Task<PageData<T>> GetListByPage(Expression<Func<T, bool>> whereExpression, PageModel pagemodel, string orderby);
  33. Task<T> GetSingle(Expression<Func<T, bool>> whereExpression);
  34. /// <summary>
  35. /// 添加
  36. /// </summary>
  37. Task<int> Add(T obj);
  38. /// <summary>
  39. /// 添加排除某列
  40. /// </summary>
  41. /// <param name="obj"></param>
  42. /// <returns></returns>
  43. Task<int> AddIgnore(T obj, Expression<Func<T, object>> IgnoreColumns);
  44. /// <summary>
  45. /// 强势插入,插入自增值
  46. /// </summary>
  47. /// <param name="obj"></param>
  48. /// <param name="isStrong">是否强势</param>
  49. /// <returns></returns>
  50. Task<int> AddStrong(T obj, bool isStrong = false);
  51. /// <summary>
  52. /// 批量添加
  53. /// </summary>
  54. /// <param name="objlist"></param>
  55. /// <returns></returns>
  56. Task<bool> AddMany(List<T> objlist);
  57. /// <summary>
  58. /// 根据主键删除
  59. /// </summary>
  60. /// <param name="id"></param>
  61. /// <returns></returns>
  62. Task<bool> Delete(Expression<Func<T, bool>> whereExpression);
  63. /// <summary>
  64. /// 更新
  65. /// </summary>
  66. /// <param name="id"></param>
  67. /// <returns></returns>
  68. Task<bool> Update(T obj);
  69. /// <summary>
  70. /// 批量更新
  71. /// </summary>
  72. /// <param name="obj"></param>
  73. /// <returns></returns>
  74. Task<bool> UpdateList(List<T> obj);
  75. /// <summary>
  76. /// 批量指定字段更新
  77. /// </summary>
  78. /// <param name="objColumns">model => new { model.Name }</param>
  79. /// <returns></returns>
  80. Task<bool> UpdateListToColumns(List<T> obj, Expression<Func<T, object>> objColumns);
  81. }
  82. }