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