/// <summary>
/// Возвращает датасет актуальных новостей.
/// </summary>
public static DataSet GetActualNews(string[] offices)
{
var queryStatement = ObjectMapper.GetSelectQueryStatement(typeof(News));
queryStatement.Clauses.Add(new QueryStatementClause(string.Empty, ">")
{
FieldName = "ExpireTime",
Value = "@expTime"
});
var query = new Query(queryStatement.ToString());
query.Add("@expTime", DateTime.Now, DbType.Time);
query.Command.CommandText += " AND (OfficeID=" + String.Join(" OR OfficeID=", offices) + ")";
query.Command.CommandText += " ORDER BY CreateTime DESC";
return query.ExecDataSet();
}
/// <summary>
/// Возвращает датасет, содержащий все записи БД, соответствующие объектам заданного типа.
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
private static DataSet GetObjectsDataset(Type type, params object[] param)
{
Dictionary<string, object> prms;
var queryStatement = ObjectMapper.GetSelectQueryStatement(type);
queryStatement.ConcatClauses(GetObjectByFieldCondition(type, out prms, param));
BaseCommand command = new Query(queryStatement.ToString());
foreach (string key in prms.Keys)
{
command.Add(key, prms[key]);
}
return command.ExecDataSet();
}
