public QueryResult Excute(string sql, int cacheTimeout, params object[] parameters)
{
if (_SettingPath != null)
{
string currentDirectory = Environment.CurrentDirectory;
Environment.CurrentDirectory = _SettingPath;
try
{
using (Hubble.Core.Data.DBAccess dbAccess = new DBAccess())
{
return(dbAccess.Query(HubbleCommand.BuildSql(sql, parameters)));
}
}
finally
{
Environment.CurrentDirectory = currentDirectory;
}
}
else
{
HubbleCommand cmd = new HubbleCommand(sql, _Conn, parameters);
cmd.Query(cacheTimeout);
return(cmd.Result);
}
}
private void ListTable(Hubble.Core.BigTable.ServerInfo serverInfo)
{
Tables = new List <string>();
using (HubbleAsyncConnection conn = new HubbleAsyncConnection(serverInfo.ConnectionString))
{
conn.Open();
HubbleCommand command = new HubbleCommand("exec sp_tablelist", conn);
DataSet ds = command.Query();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!bool.Parse(row["IsBigTable"].ToString()))
{
string fullName = row["TableName"].ToString();
int index = fullName.IndexOf(conn.Database, 0, StringComparison.CurrentCultureIgnoreCase);
if (index == 0)
{
index += conn.Database.Length;
Tables.Add(fullName.Substring(index + 1, fullName.Length - index - 1));
}
}
}
}
}
private void GetAnalyzerName(HubbleConnection conn, string tableName)
{
if (titleAnalyzerName != null && descAnalyzerName != null)
{
return;
}
string sql = string.Format("exec SP_Columns '{0}'", tableName.Replace("'", "''"));
HubbleCommand cmd = new HubbleCommand(sql, conn);
foreach (System.Data.DataRow row in cmd.Query().Tables[0].Rows)
{
if (row["FieldName"].ToString().Equals("Title", StringComparison.CurrentCultureIgnoreCase))
{
titleAnalyzerName = row["Analyzer"].ToString();
}
if (row["FieldName"].ToString().Equals("Description", StringComparison.CurrentCultureIgnoreCase))
{
descAnalyzerName = row["Analyzer"].ToString();
}
}
}
private DataTable InnerExecute(string sqlFormat, object[] args)
{
using (HubbleCommand command = new HubbleCommand(sqlFormat, _Context.HBConnection,
args))
{
return(command.Query().Tables[0]);
}
}
/// <summary>
/// 执行查询语句，从索引库中查出数据，并封装为DataTable
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <param name="commandType"></param>
/// <returns></returns>
public DataTable ExecuteDataTable(string sql, Dictionary<string, object> parameters, CommandType commandType)
{
using (HubbleCommand command = CreateHubbleCommand(sql, parameters, commandType))
{
using (HubbleDataAdapter adapter = new HubbleDataAdapter())
{
DataSet ds = new DataSet();
adapter.SelectCommand = command;
ds = adapter.SelectCommand.Query(cacheTimeout);
return ds.Tables[0];
}
}
}
/// <summary>
/// 搜索可能喜欢的文档
/// </summary>
/// <param name="pageNo"></param>
/// <param name="pageLen"></param>
/// <returns></returns>
public ArrayList SearchMaybeLike(string title, int pageNo, int pageLen,int docId)
{
string connStr = Helper.ConfigHelper.HubbleConnStr;
DataSet ds;
ArrayList rList = new ArrayList();
using (HubbleConnection conn = new HubbleConnection(connStr))
{
#region hubble
conn.Open();
GetAnalyzerName(conn, TableName);
string wordssplitbyspace;
HubbleCommand matchCmd = new HubbleCommand(conn);
string matchString = matchCmd.GetKeywordAnalyzerStringFromServer(
TableName, "Title", title, int.MaxValue, out wordssplitbyspace);
HubbleDataAdapter da = new HubbleDataAdapter();
da.SelectCommand = new HubbleCommand(
string.Format(
"select between @begin to @end * from {0} where IsAudit=1 and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) "
+ " and DocumentId<>@docid order by score desc"
, TableName),
conn);
da.SelectCommand.Parameters.Add("@begin", pageNo * pageLen);
da.SelectCommand.Parameters.Add("@end", (pageNo + 1) * pageLen - 1);
da.SelectCommand.Parameters.Add("@matchString", matchString);
da.SelectCommand.Parameters.Add("@docid",docId);
da.SelectCommand.CacheTimeout = 0;
ds = new DataSet();
HubbleCommand cmd = da.SelectCommand;
ds = cmd.Query(0);
long[] docids = new long[ds.Tables[0].Rows.Count];
int i = 0;
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
docids[i++] = (long)row["DocId"];
}
rList.AddRange(DataToList(ds, title, false));
#endregion
}
return rList;
}
private string descAnalyzerName; //描述分析器名称
public ArrayList Search(string keyWords, int pageNo, int pageLen, out int recCount, out long elapsedMilliseconds)
{
string connStr = Helper.ConfigHelper.HubbleConnStr;
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();
DataSet ds;
using (HubbleConnection conn = new HubbleConnection(connStr))
{
#region hubble
conn.Open();
GetAnalyzerName(conn, TableName);
string wordssplitbyspace;
HubbleCommand matchCmd = new HubbleCommand(conn);
string matchString = matchCmd.GetKeywordAnalyzerStringFromServer(
TableName, "Title", keyWords, int.MaxValue, out wordssplitbyspace);
HubbleDataAdapter da = new HubbleDataAdapter();
string sqlTemplate = string.Empty;
if (string.IsNullOrEmpty(this.DocType))
sqlTemplate = "select between @begin to @end * from {0} where IsAudit=1 and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) order by score desc";
else
sqlTemplate = "select between @begin to @end * from {0} where IsAudit=1 and DocType='" + this.DocType + "' and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) order by score desc";
da.SelectCommand = new HubbleCommand( string.Format(sqlTemplate,TableName),conn);
da.SelectCommand.Parameters.Add("@begin",pageNo * pageLen);
da.SelectCommand.Parameters.Add("@end", (pageNo+1) * pageLen - 1);
da.SelectCommand.Parameters.Add("@matchString", matchString);
da.SelectCommand.CacheTimeout = 0;
ds = new DataSet();
HubbleCommand cmd = da.SelectCommand;
ds = cmd.Query(0);
long[] docids = new long[ds.Tables[0].Rows.Count];
int i = 0;
//foreach (System.Data.DataRow row in ds.Tables[0].Rows)
//{
// docids[i++] = (long)row["DocumentId"];
//}
#endregion
}
recCount = ds.Tables[0].MinimumCapacity;
ArrayList rList = DataToList(ds, keyWords,true);
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
return rList;
}
/// <summary>
/// 获取格式化后的关键字
/// eg. '要出发旅行网' --> '要出发^rank^0 旅行网^rank^1'
/// 其中，rank为分词后词性的等级，position为词的位置，为计分提供参数
/// </summary>
/// <param name="keyWords">搜索的关键字</param>
/// <param name="tableName">搜索Hubble中对应的表（索引）</param>
/// <param name="fieldName">被搜索的字段（如果是多字段搜索，只放其中一个字段）</param>
/// <returns></returns>
public string GetKeywordAnalyzerStringFromat(string keyWords, string tableName, string fieldName)
{
HubbleCommand matchCmd = CreateHubbleCommand();
string wordssplitbyspace;
string matchString;
try
{
matchString = matchCmd.GetKeywordAnalyzerStringFromServer(tableName,
fieldName, keyWords, int.MaxValue, out wordssplitbyspace);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return matchString;
}
/// <summary>获取数据
/// 全文搜索方法 获取数据
/// </summary>
/// <param name="conStr">hubble服务连接字符串</param>
/// <param name="sql">查询sql语句 注意这里是T-SFQL语句 不是T-SQL语句</param>
/// <param name="_paras">参数列表</param>
/// <returns>返回数据集</returns>
public DataTable GetDataTable(string conStr, string sql, params object[] _paras)
{
DataTable table = null;
DataSet set = null;
//获取使用分词的名称
using (HubbleConnection hubbleCon = getAsyncConnect(conStr))
{
hubbleCon.Open();
//打开链接
try
{
if (hubbleCon.State == ConnectionState.Closed)
{
hubbleCon.Open();
}
HubbleCommand hubbleCommand = new HubbleCommand(hubbleCon);
//适配器对象
HubbleDataAdapter adapter = new HubbleDataAdapter();
/*添加分页参数*/
adapter.SelectCommand = new HubbleCommand(sql, hubbleCon);
/*添加用户传递的参数*/
if (_paras != null)
{
for (int i = 0; i < _paras.Length; i += 2)
{
adapter.SelectCommand.Parameters.Add(_paras[i].ToString(), _paras[i + 1]);
}
}
hubbleCommand = adapter.SelectCommand;
set = hubbleCommand.Query(this._cacheTimeout);
}
catch (Exception e)
{
throw;
}
hubbleCon.Close();
}
if (set != null && set.Tables.Count == 1)
{
table = set.Tables[0];
}
return(table);
}
/// <summary>
/// 创建一个Hubble命令实例
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <param name="commandType"></param>
/// <returns></returns>
private HubbleCommand CreateHubbleCommand(string sql, Dictionary<string, object> parameters, CommandType commandType)
{
//HubbleAsyncConnection 为异步连接
//HubbleConnection 连接为同步连接
//HubbleAsyncConnection 的工作机制理论上比 HubbleConnection 快 10 倍
HubbleAsyncConnection connection = new HubbleAsyncConnection(ConnectionString);
HubbleCommand command = new HubbleCommand(sql, connection);
command.CommandType = commandType;
command.CacheTimeout = cacheTimeout;
if (!(parameters == null || parameters.Count == 0))
{
foreach (var parameter in parameters)
{
command.Parameters.Add(parameter.Key, parameter.Value);
}
}
return command;
}
/// <summary>
/// HubbleDotNet系统级别的存储过程SP_Columns，查询每个字段的分析器类型
/// 该方法封装SP_Columns，对参数中的clumns的分析器进行映射
/// </summary>
/// <param name="conn"></param>
/// <param name="clumns"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public string[] MapperAnalyzerNames(HubbleAsyncConnection conn, string[] clumns, string tableName)
{
string sql = string.Format("exec SP_Columns '{0}'", tableName.Replace("'", "''"));
string[] analyers = new string[clumns.Length];
HubbleCommand cmd = new HubbleCommand(sql, conn);
DataTable dt = cmd.Query().Tables[0];
for (var i = 0; i < clumns.Length; i++)
{
foreach (DataRow row in dt.Rows)
{
if (row["FieldName"].ToString().Equals(clumns[i], StringComparison.CurrentCultureIgnoreCase))
{
analyers[i] = row["Analyzer"].ToString();
}
}
}
return analyers;
}
private bool ListTable(Hubble.Core.BigTable.ServerInfo serverInfo)
{
try
{
listBoxTable.Items.Clear();
using (HubbleAsyncConnection conn = new HubbleAsyncConnection(serverInfo.ConnectionString))
{
conn.Open();
HubbleCommand command = new HubbleCommand("exec sp_tablelist", conn);
DataSet ds = command.Query();
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!bool.Parse(row["IsBigTable"].ToString()))
{
string fullName = row["TableName"].ToString();
int index = fullName.IndexOf(conn.Database, 0, StringComparison.CurrentCultureIgnoreCase);
if (index == 0)
{
index += conn.Database.Length;
listBoxTable.Items.Add(fullName.Substring(index + 1, fullName.Length - index - 1));
}
}
}
}
return(true);
}
catch (Exception e)
{
QAMessageBox.ShowErrorMessage(e);
return(false);
}
}
/// <summary>
/// 重载，创建一个Hubble命令实例
/// </summary>
/// <returns></returns>
private HubbleCommand CreateHubbleCommand()
{
HubbleConnection connection = new HubbleConnection(ConnectionString);
HubbleCommand command = new HubbleCommand(connection);
return command;
}
private void GetAnalyzerName(HubbleConnection conn, string tableName)
{
if (titleAnalyzerName != null && descAnalyzerName != null)
{
return;
}
string sql = string.Format("exec SP_Columns '{0}'", tableName.Replace("'", "''"));
HubbleCommand cmd = new HubbleCommand(sql, conn);
foreach (System.Data.DataRow row in cmd.Query().Tables[0].Rows)
{
if (row["FieldName"].ToString().Equals("Title", StringComparison.CurrentCultureIgnoreCase))
{
titleAnalyzerName = row["Analyzer"].ToString();
}
if (row["FieldName"].ToString().Equals("Description", StringComparison.CurrentCultureIgnoreCase))
{
descAnalyzerName = row["Analyzer"].ToString();
}
}
}
/// <summary>
/// 搜索可能喜欢的文档
/// </summary>
/// <param name="pageNo"></param>
/// <param name="pageLen"></param>
/// <returns></returns>
public ArrayList SearchMaybeLike(string title, int pageNo, int pageLen,int docId)
{
string connStr = Helper.ConfigHelper.HubbleConnStr;
DataSet ds;
ArrayList rList = new ArrayList();
using (HubbleConnection conn = new HubbleConnection(connStr))
{
#region hubble
conn.Open();
GetAnalyzerName(conn, TableName);
string wordssplitbyspace;
HubbleCommand matchCmd = new HubbleCommand(conn);
string matchString = matchCmd.GetKeywordAnalyzerStringFromServer(
TableName, "Title", title, int.MaxValue, out wordssplitbyspace);
HubbleDataAdapter da = new HubbleDataAdapter();
da.SelectCommand = new HubbleCommand(
string.Format(
"select between @begin to @end * from {0} where IsAudit=1 and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) "
+ " and DocumentId<>@docid order by score desc"
, TableName),
conn);
da.SelectCommand.Parameters.Add("@begin", pageNo * pageLen);
da.SelectCommand.Parameters.Add("@end", (pageNo + 1) * pageLen - 1);
da.SelectCommand.Parameters.Add("@matchString", matchString);
da.SelectCommand.Parameters.Add("@docid",docId);
da.SelectCommand.CacheTimeout = 0;
ds = new DataSet();
HubbleCommand cmd = da.SelectCommand;
ds = cmd.Query(0);
long[] docids = new long[ds.Tables[0].Rows.Count];
int i = 0;
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
docids[i++] = (long)row["DocId"];
}
rList.AddRange(DataToList(ds, title, false));
#endregion
}
return rList;
}
public ArrayList Search(string keyWords, int pageNo, int pageLen, out int recCount, out long elapsedMilliseconds)
{
string connStr = Helper.ConfigHelper.HubbleConnStr;
System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
watch.Start();
DataSet ds;
using (HubbleConnection conn = new HubbleConnection(connStr))
{
#region hubble
conn.Open();
GetAnalyzerName(conn, TableName);
string wordssplitbyspace;
HubbleCommand matchCmd = new HubbleCommand(conn);
string matchString = matchCmd.GetKeywordAnalyzerStringFromServer(
TableName, "Title", keyWords, int.MaxValue, out wordssplitbyspace);
HubbleDataAdapter da = new HubbleDataAdapter();
string sqlTemplate = string.Empty;
if (string.IsNullOrEmpty(this.DocType))
sqlTemplate = "select between @begin to @end * from {0} where IsAudit=1 and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) order by score desc";
else
sqlTemplate = "select between @begin to @end * from {0} where IsAudit=1 and DocType='" + this.DocType + "' and ( Description match @matchString or title^2 match @matchString or tags^2 match @matchString ) order by score desc";
da.SelectCommand = new HubbleCommand( string.Format(sqlTemplate,TableName),conn);
da.SelectCommand.Parameters.Add("@begin",pageNo * pageLen);
da.SelectCommand.Parameters.Add("@end", (pageNo+1) * pageLen - 1);
da.SelectCommand.Parameters.Add("@matchString", matchString);
da.SelectCommand.CacheTimeout = 0;
ds = new DataSet();
HubbleCommand cmd = da.SelectCommand;
ds = cmd.Query(0);
long[] docids = new long[ds.Tables[0].Rows.Count];
int i = 0;
//foreach (System.Data.DataRow row in ds.Tables[0].Rows)
//{
// docids[i++] = (long)row["DocumentId"];
//}
#endregion
}
recCount = ds.Tables[0].MinimumCapacity;
ArrayList rList = DataToList(ds, keyWords,true);
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
return rList;
}
public static List <TNews> Search(String indexDir, string searchType, String q, int pageLen, int pageNo, string sortBy,
out int recCount, out long elapsedMilliseconds, out string sql)
{
List <TNews> result = new List <TNews>();
string keywords = q;
//string matchString = GetKeyWordsSplit(q, new PanGuAnalyzer(), out wordssplitbyspace);
System.Configuration.ConnectionStringSettings connString =
System.Web.Configuration.WebConfigurationManager.ConnectionStrings["News"];
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
string connectString = connString.ConnectionString;
System.Data.DataSet ds;
//System.Data.DataTable titleWordsPositions;
//System.Data.DataTable contentWordsPositions;
sw.Start();
using (HubbleAsyncConnection conn = new HubbleAsyncConnection(connectString))
{
conn.Open();
GetAnalyzerName(conn, "News");
if (string.IsNullOrEmpty(sortBy))
{
sortBy = "score";
}
string wordssplitbyspace;
HubbleCommand matchCmd = new HubbleCommand(conn);
string matchString = matchCmd.GetKeywordAnalyzerStringFromServer("News",
"Content", keywords, int.MaxValue, out wordssplitbyspace);
//HubbleCommand cmd = new HubbleCommand("select between {0} to {1} * from News where content match {2} or title^2 match {2} order by " + sortBy,
// conn, (pageNo - 1) * pageLen, pageNo * pageLen - 1, matchString);
HubbleDataAdapter adapter = new HubbleDataAdapter();
if (searchType == "Precise")
{
adapter.SelectCommand = new HubbleCommand("select between @begin to @end * from News where content contains @matchString or title^2 contains @matchString order by " + sortBy,
conn);
}
else if (searchType == "Fuzzy")
{
adapter.SelectCommand = new HubbleCommand("select between @begin to @end * from News where content match @matchString or title^2 match @matchString order by " + sortBy,
conn);
}
else if (searchType == "Like")
{
adapter.SelectCommand = new HubbleCommand("select between @begin to @end * from News where content like @likeString or title^2 like @likeString order by " + sortBy,
conn);
}
else
{
throw new ArgumentException(string.Format("Invalid search type: {0}", searchType));
}
adapter.SelectCommand.Parameters.Add("@begin", (pageNo - 1) * pageLen);
adapter.SelectCommand.Parameters.Add("@end", pageNo * pageLen - 1);
adapter.SelectCommand.Parameters.Add("@matchString", matchString);
adapter.SelectCommand.Parameters.Add("@likeString", "*" + q.Trim() + "*");
adapter.SelectCommand.CacheTimeout = CacheTimeout;
sql = adapter.SelectCommand.Sql;
ds = new System.Data.DataSet();
//adapter.Fill(ds);
HubbleCommand cmd = adapter.SelectCommand;
ds = cmd.Query(CacheTimeout);
long[] docids = new long[ds.Tables[0].Rows.Count];
int i = 0;
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
docids[i++] = (long)row["DocId"];
}
//titleWordsPositions = cmd.GetWordsPositions(wordssplitbyspace, "News", "Title", docids, int.MaxValue);
//contentWordsPositions = cmd.GetWordsPositions(wordssplitbyspace, "News", "Content", docids, int.MaxValue);
}
recCount = ds.Tables[0].MinimumCapacity;
foreach (System.Data.DataRow row in ds.Tables[0].Rows)
{
TNews news = new TNews();
news.Title = row["Title"].ToString();
news.Content = row["Content"].ToString();
news.Url = row["Url"].ToString();
news.Time = (DateTime)row["Time"];
SimpleHTMLFormatter simpleHTMLFormatter =
new SimpleHTMLFormatter("<font color=\"red\">", "</font>");
Highlighter titleHighlighter;
Highlighter contentHighlighter;
if (_TitleAnalyzerName.Equals("PanGuSegment", StringComparison.CurrentCultureIgnoreCase))
{
titleHighlighter =
new Highlighter(simpleHTMLFormatter, new PanGuAnalyzer());
}
else if (_TitleAnalyzerName.Equals("EnglishAnalyzer", StringComparison.CurrentCultureIgnoreCase))
{
titleHighlighter = new Highlighter(simpleHTMLFormatter, new Hubble.Core.Analysis.EnglishAnalyzer());
}
else
{
titleHighlighter = new Highlighter(simpleHTMLFormatter, new Hubble.Core.Analysis.SimpleAnalyzer());
}
if (_ContentAnalyzerName.Equals("PanGuSegment", StringComparison.CurrentCultureIgnoreCase))
{
contentHighlighter =
new Highlighter(simpleHTMLFormatter, new PanGuAnalyzer());
}
else if (_ContentAnalyzerName.Equals("EnglishAnalyzer", StringComparison.CurrentCultureIgnoreCase))
{
contentHighlighter = new Highlighter(simpleHTMLFormatter, new Hubble.Core.Analysis.EnglishAnalyzer());
}
else
{
contentHighlighter = new Highlighter(simpleHTMLFormatter, new Hubble.Core.Analysis.SimpleAnalyzer());
}
titleHighlighter.FragmentSize = 50;
contentHighlighter.FragmentSize = 50;
//news.Abstract = highlighter.GetBestFragment(contentWordsPositions, news.Content, (long)row["DocId"]);
//news.TitleHighLighter = highlighter.GetBestFragment(titleWordsPositions, news.Title, (long)row["DocId"]);
news.Abstract = contentHighlighter.GetBestFragment(keywords, news.Content);
news.TitleHighLighter = titleHighlighter.GetBestFragment(keywords, news.Title);
if (string.IsNullOrEmpty(news.TitleHighLighter))
{
news.TitleHighLighter = news.Title;
}
result.Add(news);
}
sw.Stop();
elapsedMilliseconds = sw.ElapsedMilliseconds;
return(result);
//QueryParser queryParser = new QueryParser("contents", new PanGuAnalyzer(true));
//Query query = queryParser.Parse(q);
//QueryParser titleQueryParser = new QueryParser("title", new PanGuAnalyzer(true));
//Query titleQuery = titleQueryParser.Parse(q);
//BooleanQuery bq = new BooleanQuery();
//bq.Add(query, BooleanClause.Occur.SHOULD);
//bq.Add(titleQuery, BooleanClause.Occur.SHOULD);
//Hits hits = search.Search(bq);
//List<TNews> result = new List<TNews>();
//recCount = hits.Length();
//int i = (pageNo - 1) * pageLen;
//while (i < recCount && result.Count < pageLen)
//{
// TNews news = null;
// try
// {
// //// 高亮显示设置
// ////TermQuery tQuery = new TermQuery(new Term("contents", q));
// //SimpleHTMLFormatter simpleHTMLFormatter = new SimpleHTMLFormatter("<font color=\"red\">", "</font>");
// //Highlighter highlighter = new Highlighter(simpleHTMLFormatter, new QueryScorer(query));
// ////关键内容显示大小设置
// //highlighter.SetTextFragmenter(new SimpleFragmenter(50));
// ////取出高亮显示内容
// //Lucene.Net.Analysis.KTDictSeg.KTDictSegAnalyzer analyzer = new Lucene.Net.Analysis.KTDictSeg.KTDictSegAnalyzer();
// //TokenStream tokenStream = analyzer.TokenStream("contents", new StringReader(news.Content));
// //news.Abstract = highlighter.GetBestFragment(tokenStream, news.Content);
// }
// catch (Exception e)
// {
// Console.WriteLine(e.Message);
// }
// finally
// {
// result.Add(news);
// i++;
// }
//}
//search.Close();
//return result;
}