/*public override IEnumerable<IDictionary<string, object>> GetList(int pageIndex, int pageSize, out int recordCount)
* {
* string queryString = GetQueryString();
* return Dao.Get().PageQueryDictionariesByPage(queryString, pageIndex, pageSize, SortExpression, out recordCount, Parameter);
* }*/
private string GetQueryString()
{
string sql = "SELECT * FROM {0}".FormatTo(TableName);
if (!SortExpression.IsNullOrEmpty())
{
if (SortExpression.IndexOf("ORDER BY", StringComparison.OrdinalIgnoreCase) < 0)
{
sql += " ORDER BY {0}".FormatTo(SortExpression);
}
else
{
sql += SortExpression;
}
}
return(sql);
}
public override IEnumerable <IDictionary <string, object> > GetList()
{
string sql = Entity.SelectSQL;
if (sql.IndexOf("ORDER BY", StringComparison.OrdinalIgnoreCase) < 0)
{
if (SortExpression.IsNullOrEmpty())
{
SortExpression = Entity.DefaultSortExpression;
}
if (SortExpression.IndexOf("ORDER BY", StringComparison.OrdinalIgnoreCase) < 0)
{
SortExpression = " ORDER BY {0}".FormatTo(SortExpression);
}
sql = sql + SortExpression;
}
return(dao.QueryDictionaries(sql, Parameter));
}
