Backup/DAL/RoleInfoDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;


namespace DAL
{
    public class RoleInfoDAO
    {
        private DataSet ds;
        SQLHelper sqlhelper = new SQLHelper();

        //查询总记录数
        public int GetRoleInfoCount()
        {
            try
            {
                int count = sqlhelper.ReturnSQL("select count(*) from roleinfo");
                return count;
            }
            catch (Exception)
            {
                
                throw;
            }
        }

        //查询角色信息分页

        public DataSet GetRoleInfo(int start, int limit)
        {
            try
            {
                ds = sqlhelper.GetDataSet("select top "+limit+" * from roleinfo where roleid not in(select top "+start+" roleid from roleinfo order by roleid desc) order by roleid desc");
                return ds;
            }
            catch (Exception)
            {
                
                throw;
            }
        }

        //查询所有角色信息
        public DataSet GetRoleInfos()
        {
            try
            {
                ds = sqlhelper.GetDataSet("select * from roleinfo");
                return ds;

            }
            catch (Exception)
            {
                
                throw;
            }
        }