public System.Data.DataSet QuerySql(string sql)
{
using (SQLiteDataProvider sqlData = new SQLiteDataProvider())
{
string connectionString;
if (Table == null)
{
connectionString = this.ConnectionString;
}
else
{
connectionString = Table.ConnectionString;
}
sqlData.Connect(connectionString);
return(sqlData.ExecuteReader(sql));
}
}
public System.Data.DataTable Query(IList <Hubble.Core.Data.Field> selectFields, IList <Query.DocumentResultForSort> docs, int begin, int end)
{
StringBuilder sql = new StringBuilder();
sql.Append("select ");
int i = 0;
foreach (Hubble.Core.Data.Field field in selectFields)
{
if (DocIdReplaceField != null)
{
if (field.Name.Equals("DocId", StringComparison.CurrentCultureIgnoreCase))
{
continue;
}
}
if (i++ == 0)
{
sql.AppendFormat("[{0}]", field.Name);
}
else
{
sql.AppendFormat(",[{0}]", field.Name);
}
}
if (DocIdReplaceField != null)
{
sql.AppendFormat(",[{0}]", DocIdReplaceField);
}
if (DocIdReplaceField == null)
{
sql.AppendFormat(" from {0} where docId in (", Table.DBTableName);
}
else
{
sql.AppendFormat(" from {0} where {1} in (", Table.DBTableName, DocIdReplaceField);
}
i = 0;
Dictionary <long, int> replaceFieldValueToDocId = null;
if (DocIdReplaceField != null)
{
replaceFieldValueToDocId = new Dictionary <long, int>();
}
for (int j = begin; j <= end; j++)
{
if (j >= docs.Count)
{
break;
}
int docId = docs[j].DocId;
if (DocIdReplaceField == null)
{
if (i++ == 0)
{
sql.AppendFormat("{0}", docId);
}
else
{
sql.AppendFormat(",{0}", docId);
}
}
else
{
long replaceFieldValue = this.DBProvider.GetDocIdReplaceFieldValue(docId);
replaceFieldValueToDocId.Add(replaceFieldValue, docId);
if (i++ == 0)
{
sql.AppendFormat("{0}", replaceFieldValue);
}
else
{
sql.AppendFormat(",{0}", replaceFieldValue);
}
}
}
sql.Append(")");
using (SQLiteDataProvider sqlData = new SQLiteDataProvider())
{
sqlData.Connect(Table.ConnectionString);
System.Data.DataTable table = sqlData.ExecuteReader(sql.ToString()).Tables[0];
if (DocIdReplaceField != null)
{
table.Columns.Add(new System.Data.DataColumn("DocId", typeof(int)));
for (i = 0; i < table.Rows.Count; i++)
{
table.Rows[i]["DocId"] =
replaceFieldValueToDocId[long.Parse(table.Rows[i][DocIdReplaceField].ToString())];
}
}
return(table);
}
}