Skip to content

Commit b64e952

Browse files
anjoy8anjoy8
committed
Update IBaseRepository.cs
1 parent e33ef05 commit b64e952

1 file changed

Lines changed: 151 additions & 3 deletions

File tree

‎Blog.Core.Repository/BASE/IBaseRepository.cs‎

Lines changed: 151 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -10,31 +10,117 @@ namespace Blog.Core.IRepository.Base
1010
{
1111
public interface IBaseRepository<TEntity> where TEntity : class
1212
{
13-
13+
/// <summary>
14+
/// 根据Id查询实体
15+
/// </summary>
16+
/// <param name="objId"></param>
17+
/// <returns></returns>
1418
Task<TEntity> QueryById(object objId);
1519
Task<TEntity> QueryById(object objId, bool blnUseCache = false);
20+
/// <summary>
21+
/// 根据id数组查询实体list
22+
/// </summary>
23+
/// <param name="lstIds"></param>
24+
/// <returns></returns>
1625
Task<List<TEntity>> QueryByIDs(object[] lstIds);
17-
26+
27+
/// <summary>
28+
/// 添加
29+
/// </summary>
30+
/// <param name="model"></param>
31+
/// <returns></returns>
1832
Task<int> Add(TEntity model);
1933

34+
/// <summary>
35+
/// 批量添加
36+
/// </summary>
37+
/// <param name="listEntity"></param>
38+
/// <returns></returns>
2039
Task<int> Add(List<TEntity> listEntity);
2140

41+
/// <summary>
42+
/// 根据id 删除某一实体
43+
/// </summary>
44+
/// <param name="id"></param>
45+
/// <returns></returns>
2246
Task<bool> DeleteById(object id);
2347

48+
/// <summary>
49+
/// 根据对象，删除某一实体
50+
/// </summary>
51+
/// <param name="model"></param>
52+
/// <returns></returns>
2453
Task<bool> Delete(TEntity model);
2554

55+
/// <summary>
56+
/// 根据id数组，删除实体list
57+
/// </summary>
58+
/// <param name="ids"></param>
59+
/// <returns></returns>
2660
Task<bool> DeleteByIds(object[] ids);
2761

62+
/// <summary>
63+
/// 更新model
64+
/// </summary>
65+
/// <param name="model"></param>
66+
/// <returns></returns>
2867
Task<bool> Update(TEntity model);
68+
69+
/// <summary>
70+
/// 根据model，更新，带where条件
71+
/// </summary>
72+
/// <param name="entity"></param>
73+
/// <param name="strWhere"></param>
74+
/// <returns></returns>
2975
Task<bool> Update(TEntity entity, string strWhere);
3076
Task<bool> Update(object operateAnonymousObjects);
3177

78+
/// <summary>
79+
/// 根据model，更新，指定列
80+
/// </summary>
81+
/// <param name="entity"></param>
82+
/// <param name="lstColumns"></param>
83+
/// <param name="lstIgnoreColumns"></param>
84+
/// <param name="strWhere"></param>
85+
/// <returns></returns>
3286
Task<bool> Update(TEntity entity, List<string> lstColumns = null, List<string> lstIgnoreColumns = null, string strWhere = "");
3387

88+
/// <summary>
89+
/// 查询
90+
/// </summary>
91+
/// <returns></returns>
3492
Task<List<TEntity>> Query();
93+
94+
/// <summary>
95+
/// 带sql where查询
96+
/// </summary>
97+
/// <param name="strWhere"></param>
98+
/// <returns></returns>
3599
Task<List<TEntity>> Query(string strWhere);
100+
101+
/// <summary>
102+
/// 根据表达式查询
103+
/// </summary>
104+
/// <param name="whereExpression"></param>
105+
/// <returns></returns>
36106
Task<List<TEntity>> Query(Expression<Func<TEntity, bool>> whereExpression);
107+
108+
/// <summary>
109+
/// 根据表达式，指定返回对象模型，查询
110+
/// </summary>
111+
/// <typeparam name="TResult"></typeparam>
112+
/// <param name="expression"></param>
113+
/// <returns></returns>
37114
Task<List<TResult>> Query<TResult>(Expression<Func<TEntity, TResult>> expression);
115+
116+
/// <summary>
117+
/// 根据表达式，指定返回对象模型，排序，查询
118+
/// </summary>
119+
/// <typeparam name="TResult"></typeparam>
120+
/// <param name="expression"></param>
121+
/// <param name="whereExpression"></param>
122+
/// <param name="strOrderByFileds"></param>
123+
/// <returns></returns>
38124
Task<List<TResult>> Query<TResult>(Expression<Func<TEntity, TResult>> expression, Expression<Func<TEntity, bool>> whereExpression, string strOrderByFileds);
39125
Task<List<TEntity>> Query(Expression<Func<TEntity, bool>> whereExpression, string strOrderByFileds);
40126
Task<List<TEntity>> Query(Expression<Func<TEntity, bool>> whereExpression, Expression<Func<TEntity, object>> orderByExpression, bool isAsc = true);
@@ -49,12 +135,74 @@ Task<List<TEntity>> Query(
49135
Expression<Func<TEntity, bool>> whereExpression, int intPageIndex, int intPageSize, string strOrderByFileds);
50136
Task<List<TEntity>> Query(string strWhere, int intPageIndex, int intPageSize, string strOrderByFileds);
51137

52-
138+
/// <summary>
139+
/// 根据表达式，排序字段，分页查询
140+
/// </summary>
141+
/// <param name="whereExpression"></param>
142+
/// <param name="intPageIndex"></param>
143+
/// <param name="intPageSize"></param>
144+
/// <param name="strOrderByFileds"></param>
145+
/// <returns></returns>
53146
Task<PageModel<TEntity>> QueryPage(Expression<Func<TEntity, bool>> whereExpression, int intPageIndex = 1, int intPageSize = 20, string strOrderByFileds = null);
54147

148+
/// <summary>
149+
/// 三表联查
150+
/// </summary>
151+
/// <typeparam name="T"></typeparam>
152+
/// <typeparam name="T2"></typeparam>
153+
/// <typeparam name="T3"></typeparam>
154+
/// <typeparam name="TResult"></typeparam>
155+
/// <param name="joinExpression"></param>
156+
/// <param name="selectExpression"></param>
157+
/// <param name="whereLambda"></param>
158+
/// <returns></returns>
55159
Task<List<TResult>> QueryMuch<T, T2, T3, TResult>(
56160
Expression<Func<T, T2, T3, object[]>> joinExpression,
57161
Expression<Func<T, T2, T3, TResult>> selectExpression,
58162
Expression<Func<T, T2, T3, bool>> whereLambda = null) where T : class, new();
163+
164+
/// <summary>
165+
/// 两表联查-分页
166+
/// </summary>
167+
/// <typeparam name="T"></typeparam>
168+
/// <typeparam name="T2"></typeparam>
169+
/// <typeparam name="TResult"></typeparam>
170+
/// <param name="joinExpression"></param>
171+
/// <param name="selectExpression"></param>
172+
/// <param name="whereExpression"></param>
173+
/// <param name="intPageIndex"></param>
174+
/// <param name="intPageSize"></param>
175+
/// <param name="strOrderByFileds"></param>
176+
/// <returns></returns>
177+
Task<PageModel<TResult>> QueryTabsPage<T, T2, TResult>(
178+
Expression<Func<T, T2, object[]>> joinExpression,
179+
Expression<Func<T, T2, TResult>> selectExpression,
180+
Expression<Func<TResult, bool>> whereExpression,
181+
int intPageIndex = 1,
182+
int intPageSize = 20,
183+
string strOrderByFileds = null);
184+
185+
/// <summary>
186+
/// 两表联合查询-分页-分组
187+
/// </summary>
188+
/// <typeparam name="T"></typeparam>
189+
/// <typeparam name="T2"></typeparam>
190+
/// <typeparam name="TResult"></typeparam>
191+
/// <param name="joinExpression"></param>
192+
/// <param name="selectExpression"></param>
193+
/// <param name="whereExpression"></param>
194+
/// <param name="groupExpression"></param>
195+
/// <param name="intPageIndex"></param>
196+
/// <param name="intPageSize"></param>
197+
/// <param name="strOrderByFileds"></param>
198+
/// <returns></returns>
199+
Task<PageModel<TResult>> QueryTabsPage<T, T2, TResult>(
200+
Expression<Func<T, T2, object[]>> joinExpression,
201+
Expression<Func<T, T2, TResult>> selectExpression,
202+
Expression<Func<TResult, bool>> whereExpression,
203+
Expression<Func<T, object>> groupExpression,
204+
int intPageIndex = 1,
205+
int intPageSize = 20,
206+
string strOrderByFileds = null);
59207
}
60208
}

0 commit comments

Comments
 (0)