public int GetStatMetaDataCount(Query query)
{
using (var conn = Database.OpenMonitorDatabase())
{
var tuple = Sql.SelectMetaDataCount(query);
var result =conn.ExecuteScalar<int>(tuple.Item1, (object)tuple.Item2);
return result;
}
}
public IEnumerable<Model.StatMetaData.StatMetaData> SelectBy(Query query, out int totalRows)
{
if (query.PageIndex <= 0)
{
query.PageIndex = 1;
}
if (query.PageSize <= 0)
{
query.PageSize = 100;
}
using (var conn = Database.OpenMonitorDatabase())
{
var tuple = Sql.SelectMetaDataCount(query);
totalRows = conn.ExecuteScalar<int>(tuple.Item1, (object)tuple.Item2);
return conn.Query<Model.StatMetaData.StatMetaData>(Sql.SelectByQuery(query), query);
}
}