| | |
| | | sql += $" and a.permission = 1 "; |
| | | } |
| | | int offset = (PageNum - 1) * PageSize; |
| | | sql += $" ORDER BY a.modificationtime DESC LIMIT {PageSize} OFFSET {offset}"; |
| | | sql += $" ORDER BY a.userno DESC LIMIT {PageSize} OFFSET {offset}"; |
| | | |
| | | return connection.Query<AgentDataPage>(sql).ToList(); |
| | | } |
| | |
| | | } |
| | | |
| | | int offset = (PageNum - 1) * PageSize; |
| | | sql += $" ORDER BY a.modificationtime DESC LIMIT {PageSize} OFFSET {offset}"; |
| | | sql += $" ORDER BY a.userno DESC LIMIT {PageSize} OFFSET {offset}"; |
| | | |
| | | return connection.Query<AgentDataPage>(sql).ToList(); |
| | | } |