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));
}
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]));
}