Пример #1
0
        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);
        }
Пример #2
0
        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);
        }