/// <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(); }