/// <summary> /// (分页查询)从数据库中获取角色列表 /// </summary> /// <param name="queryModel">查询条件</param> /// <returns>返回角色列表</returns> public DataTable GetRoleList(Entity.System.view.QueryModel queryModel) { try { var roleName = queryModel.roleName ?? ""; var pageNumber = queryModel.offset / queryModel.limit + 1; var pageSize = queryModel.limit; var strSql = new StringBuilder(); strSql.Append("select t.*,COUNT(*) OVER () RESULT_COUNT from ROLEINFO t where t.f_name like '%'||:roleName||'%'"); OracleParameter[] parameters = { new OracleParameter(":roleName", roleName) }; var dbapi = new DbAPI(); dbapi.OpenConn(""); var rst = dbapi.GetDataTable(DbAPI.GeneratePagingSql(strSql.ToString(), pageNumber, pageSize), parameters); dbapi.CloseConn(); return(rst); } catch (Exception ex) { LogBN.WriteLog(typeof(USERROLE_BN), "(分页查询)从数据库中获取角色列表GetRoleList 程序段的异常" + ex); return(null); } }
public Entity.MonitorLog.BootstrapTableDataModel GetRoleList([FromUri] Entity.System.view.QueryModel queryModel) { var bn = new USERROLE_BN(); var rows = bn.GetRoleList(queryModel); var rst = new Entity.MonitorLog.BootstrapTableDataModel { rows = rows, total = rows.Rows.Count > 0 ? Convert.ToInt32(rows.Rows[0]["RESULT_COUNT"]) : 0 }; return(rst); }
/// <summary> /// 导出角色列表到Excel /// </summary> /// <param name="queryModel">查询参数</param> public DataTable GetExcelList(Entity.System.view.QueryModel queryModel) { try { var roleName = string.IsNullOrWhiteSpace(queryModel.roleName) ? "" : queryModel.roleName; var strSql = "select f_rolecode \"编号\",f_name \"名称\",f_description \"备注\" from ROLEINFO where f_name like '%' || :roleName || '%'"; OracleParameter[] parameters = { new OracleParameter(":roleName", roleName) }; var dbapi = new DbAPI(); dbapi.OpenConn(""); var rst = dbapi.GetDataTable(strSql, parameters); dbapi.CloseConn(); return(rst); } catch (Exception ex) { LogBN.WriteLog(typeof(MonitorLog), "导出角色列表到Excel方法GetExcelList 程序段的异常" + ex); return(null); } }