public static async Task <PageData <T> > QueryPageAsync(int page, int size, string where = null, string orderBy = null)
{
using (var conn = new MySqlConnection(ConnectionString4Slave))
{
string sql1 = MySqlDapper.GetSqlToQueryTotalRow(tableInfo, where);
int totalRow = await conn.ExecuteScalarAsync <int>(sql1);
int totalPage = (int)Math.Floor((decimal)(totalRow + size - 1) / size);
int offset = page * size;
string sql2 = MySqlDapper.GetSqlToQueryPage(tableInfo, offset, size, where, orderBy);
var list = await MySqlDapper.QueryAsync <T>(ConnectionString4Slave, sql2);
return(new PageData <T>()
{
TotalRow = totalRow,
TotalPage = totalPage,
List = list
});
}
}
public static async Task <List <T> > QueryAsync(string where = null, string orderBy = null)
{
string sql = MySqlDapper.GetSqlToQuery(tableInfo, where, orderBy);
return(await MySqlDapper.QueryAsync <T>(ConnectionString4Slave, sql));
}