C# IServiceProvider.MaxInClauseElements方法代码示例

		private static void SetMsgGroupReadReplies(
			IServiceProvider provider,
			IEnumerable<int> mids,
			bool readReplies)
		{
			if (mids == null)
				throw new ArgumentNullException(nameof(mids));

			using (var db = provider.CreateDBContext())
			using (var tx = db.BeginTransaction())
			{
				foreach (var ids in mids.SplitToSeries(provider.MaxInClauseElements()))
				{
					var localIds = ids;
					db
						.Messages(m => localIds.Contains(m.ID))
						.Set(_ => _.ReadReplies, readReplies)
						.Update();
				}
				tx.Commit();
			}
		}

		public static void UpdateTopicInfoRange(
			IServiceProvider provider,
			IDataContext db,
			IEnumerable<int> tids)
		{
			if (db == null)
				throw new ArgumentNullException("db");
			if (tids == null)
				return;

			foreach (var series in
					tids
						.SplitToSeries(provider.MaxInClauseElements()))
			{
				var locSeries = series;
				UpdateTopicInfoByFilter(
					db,
					ti => locSeries.Contains(ti.MessageID),
					m => locSeries.Contains(m.ID));
			}
		}

		/// <summary>
		/// Поиск и выборка данных с использованием Lucene
		/// </summary>
		public static List<MsgBase> SearchMessagesByLucene(
			IServiceProvider provider,
			int forumId,
			string searchText,
			bool searchInText,
			bool searchInSubject,
			bool searchAuthor,
			bool searchInMarked,
			bool searchInMyMessages,
			bool searchAnyWords,
			bool searchInQuestions,
			DateTime from,
			DateTime to)
		{
			provider.LogInfo("Начат поиск...");
			var maxInClause = provider.MaxInClauseElements();

			provider.LogInfo("Используется lucene...");

			var mids =
				Search(
					forumId,
					searchText,
					searchInText,
					searchInSubject,
					searchAuthor,
					//searchInMarked,
					searchInMyMessages,
					searchAnyWords,
					//searchInQuestions,
					from,
					to);

			if (mids.Count == 0)
				return new List<MsgBase>(); // Ничего не нашли, вернём пустой список

			if (mids.Count > maxInClause)
				mids = Algorithms.GetFirstElements(mids, maxInClause);
			var intMids = mids.Select(int.Parse);

			using (var db = provider.CreateDBContext())
			{
				var q = db.Messages(m => intMids.Contains(m.ID));
				q = q.OrderByDescending(m => m.ID);

				// Обработка вопросов
				if (searchInQuestions)
					q = q.Where(m => m.TopicID == 0);

				// Обработка пометок пользователя
				if (searchInMarked)
					q = q.Where(m => m.IsMarked);

				var maxResults = Config.Instance.SearchConfig.MaxResultInSelect;
				if (maxResults > 0)
					q = q.Take(maxResults);

				var msgTable = db.Messages();
				var msgs =
					q
						.Select(
							m =>
								new LinearTreeMsg(provider)
								{
									ID = m.ID,
									ForumID = m.ForumID,
									TopicIDInternal = m.TopicID,
									ParentID = m.ParentID,
									Date = m.Date,
									UserID = m.UserID,
									UserNick = m.UserNick,
									UserClass = (short)m.UserClass,
									Subject = m.Subject,
									IsRead = m.IsRead,
									Rating = m.Rating(),
									Smiles = m.SmileCount(),
									Agrees = m.AgreeCount(),
									Disagrees = m.DisagreeCount(),
									RepliesCount = msgTable.Count(im => im.ParentID == m.ID),
								});
				var list =
					msgs
						.Cast<MsgBase>()
						.ToList();
				foreach (var msg in list)
					msg.EndMapping();
				return list;
			}
		}