Example #1
0
        public DataSet GetSysRoleList(Model_SysRoleParameter parameter, int PageIndex, int PageSize, out int rCount, out int pCount)
        {
            StringBuilder builder = new StringBuilder();
            string        str     = string.Empty;

            builder.Append("select row_number() over(order by SysRole_Name) AS r_n, * from SysRole where 1=1 ");
            if (parameter.MODEL_SysRole.SysRole_Name != "")
            {
                str = str + " and SysRole_Name like '%" + parameter.MODEL_SysRole.SysRole_Name + "%'";
            }
            builder.Append(str);
            return(sys.GetRecordByPage(builder.ToString(), PageIndex, PageSize, out rCount, out pCount));
        }
Example #2
0
        public List <Model_SysRole> GetSysRoleModelList(Model_SysRoleParameter parameter, int PageIndex, int PageSize, out int rCount, out int pCount)
        {
            DataSet set = this.dal.GetSysRoleList(parameter, PageIndex, PageSize, out rCount, out pCount);

            return(this.DataTableToList(set.Tables[0]));
        }