public void TestXxMethod() { var helper = new MySqlDbHelper("mysqldb"); var query = new AAQueryModel(); query.PageIndex = 1; query.PageSize = 5; query.Group = ""; const string spName = "sp_common_pager"; const string tableName = @"car_info"; const string fields = " * "; var orderField = string.IsNullOrWhiteSpace(query.Order) ? "createdtime desc" : query.Order; //查询条件 var sqlWhere = "1=1"; var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere, query.PageSize, query.PageIndex); var list2 = helper.ExecutePaging<dynamic>(model, query.Echo); Assert.IsNotNull(list2); }
public void TestXxMethod() { var helper = new MySqlDbHelper("mysqldb"); var query = new AAQueryModel(); query.PageIndex = 1; query.PageSize = 5; query.Group = ""; const string spName = "sp_common_pager"; const string tableName = @"car_info"; const string fields = " * "; var orderField = string.IsNullOrWhiteSpace(query.Order) ? "createdtime desc" : query.Order; //查询条件 var sqlWhere = "1=1"; var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere, query.PageSize, query.PageIndex); var list2 = helper.ExecutePaging <dynamic>(model, query.Echo); Assert.IsNotNull(list2); }