MongoDbClient.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Linq.Expressions;
  5. using System.Threading.Tasks;
  6. using MongoDB.Bson;
  7. using MongoDB.Driver;
  8. namespace Masuit.Tools.NoSQL.MongoDBClient
  9. {
  10. public class MongoDbClient
  11. {
  12. public MongoClient Client { get; set; }
  13. public IMongoDatabase Database { get; set; }
  14. private static readonly object LockObj = new object();
  15. private static MongoDbClient Instance { get; set; }
  16. private MongoDbClient(string url, string database)
  17. {
  18. Client = new MongoClient(url);
  19. Database = Client.GetDatabase(database);
  20. }
  21. /// <summary>
  22. /// 获取mongo单例
  23. /// </summary>
  24. /// <param name="url">连接字符串</param>
  25. /// <param name="database">数据库</param>
  26. /// <returns></returns>
  27. public static MongoDbClient GetInstance(string url, string database)
  28. {
  29. if (Instance == null)
  30. {
  31. lock (LockObj)
  32. {
  33. if (Instance == null)
  34. {
  35. Instance = new MongoDbClient(url, database);
  36. }
  37. }
  38. }
  39. return Instance;
  40. }
  41. /// <summary>
  42. /// 获取表
  43. /// </summary>
  44. /// <typeparam name="T"></typeparam>
  45. /// <param name="collection">表名</param>
  46. /// <returns></returns>
  47. public IMongoCollection<T> GetCollection<T>(string collection)
  48. {
  49. return Database.GetCollection<T>(collection);
  50. }
  51. #region 插入
  52. /// <summary>
  53. /// 插入一条数据
  54. /// </summary>
  55. /// <typeparam name="T"></typeparam>
  56. /// <param name="collection">表名</param>
  57. /// <param name="t">数据</param>
  58. public void InsertOne<T>(string collection, T t)
  59. {
  60. Database.GetCollection<T>(collection).InsertOne(t);
  61. }
  62. /// <summary>
  63. /// 插入一条数据
  64. /// </summary>
  65. /// <param name="collection">表名</param>
  66. /// <param name="doc">文档</param>
  67. public void InsertOne(string collection, BsonDocument doc)
  68. {
  69. Database.GetCollection<BsonDocument>(collection).InsertOne(doc);
  70. }
  71. /// <summary>
  72. /// 插入一条数据
  73. /// </summary>
  74. /// <typeparam name="T"></typeparam>
  75. /// <param name="collection">表名</param>
  76. /// <param name="t">数据</param>
  77. public void InsertOneAsync<T>(string collection, T t)
  78. {
  79. Database.GetCollection<T>(collection).InsertOneAsync(t);
  80. }
  81. /// <summary>
  82. /// 插入一条数据
  83. /// </summary>
  84. /// <param name="collection">表名</param>
  85. /// <param name="doc">文档</param>
  86. public void InsertOneAsync(string collection, BsonDocument doc)
  87. {
  88. Database.GetCollection<BsonDocument>(collection).InsertOneAsync(doc);
  89. }
  90. /// <summary>
  91. /// 插入多条数据
  92. /// </summary>
  93. /// <typeparam name="T"></typeparam>
  94. /// <param name="collection">表名</param>
  95. /// <param name="list">集合</param>
  96. public void InsertMany<T>(string collection, IEnumerable<T> list)
  97. {
  98. Database.GetCollection<T>(collection).InsertMany(list);
  99. }
  100. /// <summary>
  101. /// 插入多条数据
  102. /// </summary>
  103. /// <param name="collection">表名</param>
  104. /// <param name="list">Bson集合</param>
  105. public void InsertMany(string collection, IEnumerable<BsonDocument> list)
  106. {
  107. Database.GetCollection<BsonDocument>(collection).InsertMany(list);
  108. }
  109. /// <summary>
  110. /// 插入多条数据
  111. /// </summary>
  112. /// <typeparam name="T"></typeparam>
  113. /// <param name="collection">表名</param>
  114. /// <param name="list">集合</param>
  115. public void InsertManyAsync<T>(string collection, IEnumerable<T> list)
  116. {
  117. Database.GetCollection<T>(collection).InsertManyAsync(list);
  118. }
  119. /// <summary>
  120. /// 插入多条数据
  121. /// </summary>
  122. /// <param name="collection">表名</param>
  123. /// <param name="list">Bson集合</param>
  124. public void InsertManyAsync(string collection, IEnumerable<BsonDocument> list)
  125. {
  126. Database.GetCollection<BsonDocument>(collection).InsertManyAsync(list);
  127. }
  128. /// <summary>
  129. /// 大批量插入数据
  130. /// </summary>
  131. /// <typeparam name="T"></typeparam>
  132. /// <param name="collection">表名</param>
  133. /// <param name="list">数据集合</param>
  134. /// <returns></returns>
  135. public List<WriteModel<T>> BulkInsert<T>(string collection, IEnumerable<WriteModel<T>> list)
  136. {
  137. BulkWriteResult<T> result = Database.GetCollection<T>(collection).BulkWrite(list);
  138. return result.ProcessedRequests.ToList();
  139. }
  140. /// <summary>
  141. /// 大批量插入数据
  142. /// </summary>
  143. /// <param name="collection">表名</param>
  144. /// <param name="list">Bson数据集合</param>
  145. /// <returns></returns>
  146. public List<WriteModel<BsonDocument>> BulkInsert(string collection, IEnumerable<WriteModel<BsonDocument>> list)
  147. {
  148. BulkWriteResult<BsonDocument> result = Database.GetCollection<BsonDocument>(collection).BulkWrite(list);
  149. return result.ProcessedRequests.ToList();
  150. }
  151. /// <summary>
  152. /// 大批量插入数据
  153. /// </summary>
  154. /// <typeparam name="T"></typeparam>
  155. /// <param name="collection">表名</param>
  156. /// <param name="list">数据集合</param>
  157. /// <returns></returns>
  158. public async Task<List<WriteModel<T>>> BulkInsertAsync<T>(string collection, IEnumerable<WriteModel<T>> list)
  159. {
  160. BulkWriteResult<T> result = await Database.GetCollection<T>(collection).BulkWriteAsync(list);
  161. return result.ProcessedRequests.ToList();
  162. }
  163. /// <summary>
  164. /// 大批量插入数据
  165. /// </summary>
  166. /// <param name="collection">表名</param>
  167. /// <param name="list">Bson数据集合</param>
  168. /// <returns></returns>
  169. public async Task<List<WriteModel<BsonDocument>>> BulkInsertAsync(string collection, IEnumerable<WriteModel<BsonDocument>> list)
  170. {
  171. BulkWriteResult<BsonDocument> result = await Database.GetCollection<BsonDocument>(collection).BulkWriteAsync(list);
  172. return result.ProcessedRequests.ToList();
  173. }
  174. #endregion
  175. #region 更新
  176. /// <summary>
  177. /// 修改一条数据
  178. /// </summary>
  179. /// <typeparam name="T"></typeparam>
  180. /// <param name="collection">表名</param>
  181. /// <param name="filter">条件</param>
  182. /// <param name="update">更新的数据</param>
  183. /// <param name="upsert">如果它不存在是否插入文档</param>
  184. /// <returns></returns>
  185. public string UpdateOne<T>(string collection, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update, bool upsert)
  186. {
  187. UpdateResult result = Database.GetCollection<T>(collection).UpdateOne(filter, update, new UpdateOptions() { IsUpsert = upsert });
  188. return result.ToJson();
  189. }
  190. /// <summary>
  191. /// 修改一条数据
  192. /// </summary>
  193. /// <param name="collection">表名</param>
  194. /// <param name="filter">条件</param>
  195. /// <param name="update">更新的数据</param>
  196. /// <param name="upsert">如果它不存在是否插入文档</param>
  197. /// <returns></returns>
  198. public string UpdateOne(string collection, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update, bool upsert)
  199. {
  200. UpdateResult result = Database.GetCollection<BsonDocument>(collection).UpdateOne(filter, update, new UpdateOptions() { IsUpsert = upsert });
  201. return result.ToJson();
  202. }
  203. /// <summary>
  204. /// 修改一条数据
  205. /// </summary>
  206. /// <typeparam name="T"></typeparam>
  207. /// <param name="collection">表名</param>
  208. /// <param name="filter">条件</param>
  209. /// <param name="update">更新的数据</param>
  210. /// <param name="upsert">如果它不存在是否插入文档</param>
  211. /// <returns></returns>
  212. public async Task<string> UpdateOneAsync<T>(string collection, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update, bool upsert)
  213. {
  214. UpdateResult result = await Database.GetCollection<T>(collection).UpdateOneAsync(filter, update, new UpdateOptions() { IsUpsert = upsert });
  215. return result.ToJson();
  216. }
  217. /// <summary>
  218. /// 修改一条数据
  219. /// </summary>
  220. /// <param name="collection">表名</param>
  221. /// <param name="filter">条件</param>
  222. /// <param name="update">更新的数据</param>
  223. /// <param name="upsert">如果它不存在是否插入文档</param>
  224. /// <returns></returns>
  225. public async Task<string> UpdateOneAsync(string collection, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update, bool upsert)
  226. {
  227. UpdateResult result = await Database.GetCollection<BsonDocument>(collection).UpdateOneAsync(filter, update, new UpdateOptions() { IsUpsert = upsert });
  228. return result.ToJson();
  229. }
  230. /// <summary>
  231. /// 修改文档
  232. /// </summary>
  233. /// <param name="collName">集合名称</param>
  234. /// <param name="filter">修改条件</param>
  235. /// <param name="update">修改结果</param>
  236. /// <param name="upsert">是否插入新文档(filter条件满足就更新,否则插入新文档)</param>
  237. /// <returns></returns>
  238. public Int64 UpdateMany<T>(String collName, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update, Boolean upsert = false)
  239. {
  240. UpdateResult result = Database.GetCollection<T>(collName).UpdateMany(filter, update, new UpdateOptions { IsUpsert = upsert });
  241. return result.ModifiedCount;
  242. }
  243. /// <summary>
  244. /// 修改文档
  245. /// </summary>
  246. /// <param name="collName">集合名称</param>
  247. /// <param name="filter">修改条件</param>
  248. /// <param name="update">修改结果</param>
  249. /// <param name="upsert">是否插入新文档(filter条件满足就更新,否则插入新文档)</param>
  250. /// <returns></returns>
  251. public Int64 UpdateMany(String collName, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update, Boolean upsert = false)
  252. {
  253. UpdateResult result = Database.GetCollection<BsonDocument>(collName).UpdateMany(filter, update, new UpdateOptions { IsUpsert = upsert });
  254. return result.ModifiedCount;
  255. }
  256. /// <summary>
  257. /// 修改多个文档
  258. /// </summary>
  259. /// <typeparam name="T"></typeparam>
  260. /// <param name="collName">集合名称</param>
  261. /// <param name="filter">修改条件</param>
  262. /// <param name="update">修改结果</param>
  263. /// <param name="upsert">是否插入新文档(filter条件满足就更新,否则插入新文档)</param>
  264. /// <returns></returns>
  265. public async Task<long> UpdateManyAsync<T>(String collName, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update, Boolean upsert = false)
  266. {
  267. UpdateResult result = await Database.GetCollection<T>(collName).UpdateManyAsync(filter, update, new UpdateOptions { IsUpsert = upsert });
  268. return result.ModifiedCount;
  269. }
  270. /// <summary>
  271. /// 修改多个文档
  272. /// </summary>
  273. /// <param name="collName">集合名称</param>
  274. /// <param name="filter">修改条件</param>
  275. /// <param name="update">修改结果</param>
  276. /// <param name="upsert">是否插入新文档(filter条件满足就更新,否则插入新文档)</param>
  277. /// <returns></returns>
  278. public async Task<long> UpdateManyAsync(String collName, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update, Boolean upsert = false)
  279. {
  280. UpdateResult result = await Database.GetCollection<BsonDocument>(collName).UpdateManyAsync(filter, update, new UpdateOptions { IsUpsert = upsert });
  281. return result.ModifiedCount;
  282. }
  283. /// <summary>
  284. /// 修改文档
  285. /// </summary>
  286. /// <typeparam name="T"></typeparam>
  287. /// <param name="collName">表名</param>
  288. /// <param name="filter">条件</param>
  289. /// <param name="update">更新后的数据</param>
  290. /// <returns></returns>
  291. public T UpdateOne<T>(String collName, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update)
  292. {
  293. T result = Database.GetCollection<T>(collName).FindOneAndUpdate(filter, update);
  294. return result;
  295. }
  296. /// <summary>
  297. /// 修改文档
  298. /// </summary>
  299. /// <param name="collName">表名</param>
  300. /// <param name="filter">条件</param>
  301. /// <param name="update">更新后的Bson数据</param>
  302. /// <returns></returns>
  303. public BsonDocument UpdateOne(String collName, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update)
  304. {
  305. BsonDocument result = Database.GetCollection<BsonDocument>(collName).FindOneAndUpdate(filter, update);
  306. return result;
  307. }
  308. /// <summary>
  309. /// 修改文档
  310. /// </summary>
  311. /// <typeparam name="T"></typeparam>
  312. /// <param name="collName">表名</param>
  313. /// <param name="filter">条件</param>
  314. /// <param name="update">更新后的数据</param>
  315. /// <returns></returns>
  316. public async Task<T> UpdateOneAsync<T>(String collName, Expression<Func<T, Boolean>> filter, UpdateDefinition<T> update)
  317. {
  318. T result = await Database.GetCollection<T>(collName).FindOneAndUpdateAsync(filter, update);
  319. return result;
  320. }
  321. /// <summary>
  322. /// 修改文档
  323. /// </summary>
  324. /// <param name="collName">表名</param>
  325. /// <param name="filter">条件</param>
  326. /// <param name="update">更新后的Bson数据</param>
  327. /// <returns></returns>
  328. public async Task<BsonDocument> UpdateOneAsync(String collName, Expression<Func<BsonDocument, Boolean>> filter, UpdateDefinition<BsonDocument> update)
  329. {
  330. BsonDocument result = await Database.GetCollection<BsonDocument>(collName).FindOneAndUpdateAsync(filter, update);
  331. return result;
  332. }
  333. #endregion
  334. #region 删除
  335. /// <summary>
  336. /// 按BsonDocument条件删除
  337. /// </summary>
  338. /// <param name="collection">集合名称</param>
  339. /// <param name="document">文档</param>
  340. /// <returns></returns>
  341. public Int64 Delete<T>(String collection, BsonDocument document)
  342. {
  343. DeleteResult result = Database.GetCollection<T>(collection).DeleteOne(document);
  344. return result.DeletedCount;
  345. }
  346. /// <summary>
  347. /// 按BsonDocument条件删除
  348. /// </summary>
  349. /// <param name="collection">集合名称</param>
  350. /// <param name="document">文档</param>
  351. /// <returns></returns>
  352. public Int64 Delete(String collection, BsonDocument document)
  353. {
  354. DeleteResult result = Database.GetCollection<BsonDocument>(collection).DeleteOne(document);
  355. return result.DeletedCount;
  356. }
  357. /// <summary>
  358. /// 按BsonDocument条件删除
  359. /// </summary>
  360. /// <param name="collection">集合名称</param>
  361. /// <param name="document">文档</param>
  362. /// <returns></returns>
  363. public async Task<long> DeleteAsync<T>(String collection, BsonDocument document)
  364. {
  365. DeleteResult result = await Database.GetCollection<T>(collection).DeleteOneAsync(document);
  366. return result.DeletedCount;
  367. }
  368. /// <summary>
  369. /// 按BsonDocument条件删除
  370. /// </summary>
  371. /// <param name="collection">集合名称</param>
  372. /// <param name="document">文档</param>
  373. /// <returns></returns>
  374. public async Task<long> DeleteAsync(String collection, BsonDocument document)
  375. {
  376. DeleteResult result = await Database.GetCollection<BsonDocument>(collection).DeleteOneAsync(document);
  377. return result.DeletedCount;
  378. }
  379. /// <summary>
  380. /// 按json字符串删除
  381. /// </summary>
  382. /// <param name="collName">集合名称</param>
  383. /// <param name="json">json字符串</param>
  384. /// <returns></returns>
  385. public Int64 Delete<T>(String collName, String json)
  386. {
  387. var result = Database.GetCollection<T>(collName).DeleteOne(json);
  388. return result.DeletedCount;
  389. }
  390. /// <summary>
  391. /// 按json字符串删除
  392. /// </summary>
  393. /// <param name="collName">集合名称</param>
  394. /// <param name="json">json字符串</param>
  395. /// <returns></returns>
  396. public Int64 Delete(String collName, String json)
  397. {
  398. var result = Database.GetCollection<BsonDocument>(collName).DeleteOne(json);
  399. return result.DeletedCount;
  400. }
  401. /// <summary>
  402. /// 按json字符串删除
  403. /// </summary>
  404. /// <param name="collName">集合名称</param>
  405. /// <param name="json">json字符串</param>
  406. /// <returns></returns>
  407. public async Task<long> DeleteAsync<T>(String collName, String json)
  408. {
  409. var result = await Database.GetCollection<T>(collName).DeleteOneAsync(json);
  410. return result.DeletedCount;
  411. }
  412. /// <summary>
  413. /// 按json字符串删除
  414. /// </summary>
  415. /// <param name="collName">集合名称</param>
  416. /// <param name="json">json字符串</param>
  417. /// <returns></returns>
  418. public async Task<long> DeleteAsync(String collName, String json)
  419. {
  420. var result = await Database.GetCollection<BsonDocument>(collName).DeleteOneAsync(json);
  421. return result.DeletedCount;
  422. }
  423. /// <summary>
  424. /// 按条件表达式删除
  425. /// </summary>
  426. /// <param name="collName">集合名称</param>
  427. /// <param name="predicate">条件表达式</param>
  428. /// <returns></returns>
  429. public Int64 Delete<T>(String collName, Expression<Func<T, Boolean>> predicate)
  430. {
  431. var result = Database.GetCollection<T>(collName).DeleteOne(predicate);
  432. return result.DeletedCount;
  433. }
  434. /// <summary>
  435. /// 按条件表达式删除
  436. /// </summary>
  437. /// <param name="collName">集合名称</param>
  438. /// <param name="predicate">条件表达式</param>
  439. /// <returns></returns>
  440. public Int64 Delete(String collName, Expression<Func<BsonDocument, Boolean>> predicate)
  441. {
  442. var result = Database.GetCollection<BsonDocument>(collName).DeleteOne(predicate);
  443. return result.DeletedCount;
  444. }
  445. /// <summary>
  446. /// 按条件表达式删除
  447. /// </summary>
  448. /// <param name="collName">集合名称</param>
  449. /// <param name="predicate">条件表达式</param>
  450. /// <returns></returns>
  451. public async Task<long> DeleteAsync<T>(String collName, Expression<Func<T, Boolean>> predicate)
  452. {
  453. var result = await Database.GetCollection<T>(collName).DeleteOneAsync(predicate);
  454. return result.DeletedCount;
  455. }
  456. /// <summary>
  457. /// 按条件表达式删除
  458. /// </summary>
  459. /// <param name="collName">集合名称</param>
  460. /// <param name="predicate">条件表达式</param>
  461. /// <returns></returns>
  462. public async Task<long> DeleteAsync(String collName, Expression<Func<BsonDocument, Boolean>> predicate)
  463. {
  464. var result = await Database.GetCollection<BsonDocument>(collName).DeleteOneAsync(predicate);
  465. return result.DeletedCount;
  466. }
  467. /// <summary>
  468. /// 按检索条件删除
  469. /// 建议用Builders&lt;T&gt;构建复杂的查询条件
  470. /// </summary>
  471. /// <param name="collName">集合名称</param>
  472. /// <param name="filter">条件</param>
  473. /// <returns></returns>
  474. public Int64 Delete<T>(String collName, FilterDefinition<T> filter)
  475. {
  476. var result = Database.GetCollection<T>(collName).DeleteOne(filter);
  477. return result.DeletedCount;
  478. }
  479. /// <summary>
  480. /// 按检索条件删除
  481. /// 建议用Builders&lt;T&gt;构建复杂的查询条件
  482. /// </summary>
  483. /// <param name="collName">集合名称</param>
  484. /// <param name="filter">条件</param>
  485. /// <returns></returns>
  486. public Int64 Delete(String collName, FilterDefinition<BsonDocument> filter)
  487. {
  488. var result = Database.GetCollection<BsonDocument>(collName).DeleteOne(filter);
  489. return result.DeletedCount;
  490. }
  491. /// <summary>
  492. /// 按检索条件删除
  493. /// 建议用Builders&lt;T&gt;构建复杂的查询条件
  494. /// </summary>
  495. /// <param name="collName">集合名称</param>
  496. /// <param name="filter">条件</param>
  497. /// <returns></returns>
  498. public async Task<long> DeleteAsync<T>(String collName, FilterDefinition<T> filter)
  499. {
  500. var result = await Database.GetCollection<T>(collName).DeleteOneAsync(filter);
  501. return result.DeletedCount;
  502. }
  503. /// <summary>
  504. /// 按检索条件删除
  505. /// 建议用Builders&lt;T&gt;构建复杂的查询条件
  506. /// </summary>
  507. /// <param name="collName">集合名称</param>
  508. /// <param name="filter">条件</param>
  509. /// <returns></returns>
  510. public async Task<long> DeleteAsync(String collName, FilterDefinition<BsonDocument> filter)
  511. {
  512. var result = await Database.GetCollection<BsonDocument>(collName).DeleteOneAsync(filter);
  513. return result.DeletedCount;
  514. }
  515. /// <summary>
  516. /// 删除一条记录
  517. /// </summary>
  518. /// <typeparam name="T"></typeparam>
  519. /// <param name="collName">表名</param>
  520. /// <param name="filter">条件</param>
  521. /// <returns></returns>
  522. public T DeleteOne<T>(String collName, Expression<Func<T, Boolean>> filter)
  523. {
  524. T result = Database.GetCollection<T>(collName).FindOneAndDelete(filter);
  525. return result;
  526. }
  527. /// <summary>
  528. /// 删除一条记录
  529. /// </summary>
  530. /// <param name="collName">表名</param>
  531. /// <param name="filter">条件</param>
  532. /// <returns></returns>
  533. public BsonDocument DeleteOne(String collName, Expression<Func<BsonDocument, Boolean>> filter)
  534. {
  535. BsonDocument result = Database.GetCollection<BsonDocument>(collName).FindOneAndDelete(filter);
  536. return result;
  537. }
  538. /// <summary>
  539. /// 删除一条记录
  540. /// </summary>
  541. /// <typeparam name="T"></typeparam>
  542. /// <param name="collName">表名</param>
  543. /// <param name="filter">条件</param>
  544. /// <returns></returns>
  545. public async Task<T> DeleteOneAsync<T>(String collName, Expression<Func<T, Boolean>> filter)
  546. {
  547. T result = await Database.GetCollection<T>(collName).FindOneAndDeleteAsync(filter);
  548. return result;
  549. }
  550. /// <summary>
  551. /// 删除一条记录
  552. /// </summary>
  553. /// <param name="collName">表名</param>
  554. /// <param name="filter">条件</param>
  555. /// <returns></returns>
  556. public async Task<BsonDocument> DeleteOneAsync(String collName, Expression<Func<BsonDocument, Boolean>> filter)
  557. {
  558. BsonDocument result = await Database.GetCollection<BsonDocument>(collName).FindOneAndDeleteAsync(filter);
  559. return result;
  560. }
  561. #endregion
  562. #region 查询
  563. /// <summary>
  564. /// 查询,复杂查询直接用Linq处理
  565. /// </summary>
  566. /// <param name="collName">集合名称</param>
  567. /// <returns>要查询的对象</returns>
  568. public IQueryable<T> GetQueryable<T>(String collName)
  569. {
  570. return Database.GetCollection<T>(collName).AsQueryable();
  571. }
  572. /// <summary>
  573. /// 查询,复杂查询直接用Linq处理
  574. /// </summary>
  575. /// <param name="collName">集合名称</param>
  576. /// <returns>要查询的对象</returns>
  577. public IQueryable<BsonDocument> GetQueryable(String collName)
  578. {
  579. return Database.GetCollection<BsonDocument>(collName).AsQueryable();
  580. }
  581. /// <summary>
  582. /// 获取一条数据
  583. /// </summary>
  584. /// <typeparam name="T"></typeparam>
  585. /// <param name="collName">表名</param>
  586. /// <param name="filter">条件</param>
  587. /// <returns></returns>
  588. public T Get<T>(String collName, FilterDefinition<T> filter)
  589. {
  590. IFindFluent<T, T> find = Database.GetCollection<T>(collName).Find(filter);
  591. return find.FirstOrDefault();
  592. }
  593. /// <summary>
  594. /// 获取一条数据
  595. /// </summary>
  596. /// <param name="collName">表名</param>
  597. /// <param name="filter">条件</param>
  598. /// <returns></returns>
  599. public BsonDocument Get(String collName, FilterDefinition<BsonDocument> filter)
  600. {
  601. IFindFluent<BsonDocument, BsonDocument> find = Database.GetCollection<BsonDocument>(collName).Find(filter);
  602. return find.FirstOrDefault();
  603. }
  604. /// <summary>
  605. /// 获取一条数据
  606. /// </summary>
  607. /// <typeparam name="T"></typeparam>
  608. /// <param name="collName">表名</param>
  609. /// <param name="filter">条件</param>
  610. /// <returns></returns>
  611. public async Task<T> GetAsync<T>(String collName, FilterDefinition<T> filter)
  612. {
  613. IAsyncCursor<T> find = await Database.GetCollection<T>(collName).FindAsync(filter);
  614. return await find.FirstOrDefaultAsync();
  615. }
  616. /// <summary>
  617. /// 获取一条数据
  618. /// </summary>
  619. /// <param name="collName">表名</param>
  620. /// <param name="filter">条件</param>
  621. /// <returns></returns>
  622. public async Task<BsonDocument> GetAsync(String collName, FilterDefinition<BsonDocument> filter)
  623. {
  624. IAsyncCursor<BsonDocument> find = await Database.GetCollection<BsonDocument>(collName).FindAsync(filter);
  625. return await find.FirstOrDefaultAsync();
  626. }
  627. /// <summary>
  628. /// 获取多条数据
  629. /// </summary>
  630. /// <typeparam name="T"></typeparam>
  631. /// <param name="collName">表名</param>
  632. /// <param name="filter">条件</param>
  633. /// <returns></returns>
  634. public IEnumerable<T> GetMany<T>(String collName, FilterDefinition<T> filter)
  635. {
  636. IFindFluent<T, T> find = Database.GetCollection<T>(collName).Find(filter);
  637. return find.ToEnumerable();
  638. }
  639. /// <summary>
  640. /// 获取多条数据
  641. /// </summary>
  642. /// <param name="collName">表名</param>
  643. /// <param name="filter">条件</param>
  644. /// <returns></returns>
  645. public IEnumerable<BsonDocument> GetMany(String collName, FilterDefinition<BsonDocument> filter)
  646. {
  647. IFindFluent<BsonDocument, BsonDocument> find = Database.GetCollection<BsonDocument>(collName).Find(filter);
  648. return find.ToEnumerable();
  649. }
  650. /// <summary>
  651. /// 获取多条数据
  652. /// </summary>
  653. /// <typeparam name="T"></typeparam>
  654. /// <param name="collName">表名</param>
  655. /// <param name="filter">条件</param>
  656. /// <returns></returns>
  657. public async Task<IEnumerable<T>> GetManyAsync<T>(String collName, FilterDefinition<T> filter)
  658. {
  659. IAsyncCursor<T> find = await Database.GetCollection<T>(collName).FindAsync(filter);
  660. return find.ToEnumerable();
  661. }
  662. /// <summary>
  663. /// 获取多条数据
  664. /// </summary>
  665. /// <param name="collName">表名</param>
  666. /// <param name="filter">条件</param>
  667. /// <returns></returns>
  668. public async Task<IEnumerable<BsonDocument>> GetManyAsync(String collName, FilterDefinition<BsonDocument> filter)
  669. {
  670. IAsyncCursor<BsonDocument> find = await Database.GetCollection<BsonDocument>(collName).FindAsync(filter);
  671. return find.ToEnumerable();
  672. }
  673. /// <summary>
  674. /// 判断是否存在符合条件的数据
  675. /// </summary>
  676. /// <typeparam name="T"></typeparam>
  677. /// <param name="collName">表名</param>
  678. /// <param name="filter">条件</param>
  679. /// <returns></returns>
  680. public bool Any<T>(String collName, FilterDefinition<T> filter)
  681. {
  682. IFindFluent<T, T> find = Database.GetCollection<T>(collName).Find(filter);
  683. return find.Any();
  684. }
  685. /// <summary>
  686. /// 判断是否存在符合条件的数据
  687. /// </summary>
  688. /// <param name="collName">表名</param>
  689. /// <param name="filter">条件</param>
  690. /// <returns></returns>
  691. public bool Any(String collName, FilterDefinition<BsonDocument> filter)
  692. {
  693. IFindFluent<BsonDocument, BsonDocument> find = Database.GetCollection<BsonDocument>(collName).Find(filter);
  694. return find.Any();
  695. }
  696. /// <summary>
  697. /// 判断是否存在符合条件的数据
  698. /// </summary>
  699. /// <param name="collName">表名</param>
  700. /// <param name="filter">条件</param>
  701. /// <returns></returns>
  702. public async Task<bool> AnyAsync<T>(String collName, FilterDefinition<T> filter)
  703. {
  704. IAsyncCursor<T> find = await Database.GetCollection<T>(collName).FindAsync(filter);
  705. return await find.AnyAsync();
  706. }
  707. /// <summary>
  708. /// 判断是否存在符合条件的数据
  709. /// </summary>
  710. /// <param name="collName">表名</param>
  711. /// <param name="filter">条件</param>
  712. /// <returns></returns>
  713. public async Task<bool> AnyAsync(String collName, FilterDefinition<BsonDocument> filter)
  714. {
  715. IAsyncCursor<BsonDocument> find = await Database.GetCollection<BsonDocument>(collName).FindAsync(filter);
  716. return await find.AnyAsync();
  717. }
  718. #endregion
  719. }
  720. }