Html頁面：
<!DOCTYPE html>
<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title></title><meta charset="utf-8" /><!-- 引入相關CSS --><!-- BaseCss --><link rel='stylesheet' href='/Styles/base.css' /><link rel='stylesheet' href='/Styles/table.css' /><link rel='stylesheet' href='/Scripts/lib/loadmask/jquery.loadmask.css' /><!-- XUICss --><link rel='stylesheet' href='/Scripts/lib/easyUI/themes/gray/easyui.css' /><link rel='stylesheet' href='/Scripts/lib/easyUI/themes/icon.css' /><link rel='stylesheet' href='/Scripts/lib/easyUI/themes/xUI.css' /><!-- 引入相關JS --><!-- JQueryJs --><script src='/Scripts/lib/jquery/jquery.min.js'></script><script src='/Scripts/lib/jquery/jquery.json-2.3.min.js'></script><script src='/Scripts/lib/jquery/jquery.extend.js'></script><!-- JQueryJs --><script src="/Scripts/lib/jquery/jquery.json-2.3.min.js"></script><!-- BaseJs --><script src="/Scripts/base.js"></script><script src="/Scripts/lib/loadmask/jquery.loadmask.js"></script><!-- XUIJs --><script src="/Scripts/lib/easyUI/jquery.easyui.min.js"></script><script src="/Scripts/lib/artDialog/artDialog.source.js?skin=chrome"></script><script src="/Scripts/lib/artDialog/artDialog.iframe.source.js?skin=chrome"></script><script src="/Scripts/xUI/xui.all.js"></script><script type="text/javascript">(function () {var myModObj = {/*公共變量存儲*/dataStore: {ajaxUrl: "/Flow/Controls/Comm/VoteAjax.ashx"//ajax路徑},/*組件對象存儲*/uiStore: {gvVoteResultDetailList: null,},/*初始化*/init: function () {this.initUI(); //初始化組件this.initData(); //初始化數據this.initEvent(); //初始化事件},/*初始化組件*/initUI: function () {var that = this;var setList = {title: '投票明細', iconCls: 'icon-table',serverPaging: true,getServerData: this.loadVoteResultDetail,columns: [[{ field: 'USER_NO', title: '投票人', width: 200, align: 'center' },{ field: 'VOTE_RESULT_ZQ', title: '債券等級', width: 200, align: 'center' },{ field: 'VOTE_RESULT_ZT', title: '主體等級', width: 200, align: 'center' },{field: 'VOTE_RESULT_ZW', title: '展望', width: 200, align: 'center',formatter: function (value) {switch (value) {case "0":return "負面";case "1":return "穩定";case "2":return "正面";default:return "";}}},{ field: 'IMP_TIME', title: '投票時間', width: 200, align: 'center',align: "center" },{ field: 'NOTE_CONTENT', title: '投票意見', width: 200, align: 'left' }]],}//創建投票明細數據表格that.uiStore.gvVoteResultDetailList = $('#gvVoteResultDetailList').createDatagrid(setList);},/*初始化數據*/initData: function () {var that = modVoteResultCtrl;that.loadVoteResult();//獲取投票結果 that.loadVoteResultDetail();//獲取投票結果明細//顯示body$("body").css("visibility", "visible");},/*初始化事件*/initEvent: function () {},//獲取投票結果loadVoteResult: function () {var that = modVoteResultCtrl;var param = {reqType: "GetVoteResult",instID: "555",stepID: "555"};that.ajaxDeal(that.dataStore.ajaxUrl, param, loadDataSuc);//加載數據function loadDataSuc(result) {for (var i = 0; i < result.data.length; i++) { if(result.data[i].VOTE_TYPE == '債券等級'){$("#lblZQDJ").text(result.data[i].GRADE);}if (result.data[i].VOTE_TYPE == '主體等級'){$("#lblZTDJ").text(result.data[i].GRADE);}if(result.data[i].VOTE_TYPE == '展望'){var grade = result.data[i].GRADE; if ( grade == '0') {$("#lblZW").text("負面");}else if (grade == '1') {$("#lblZW").text("穩定");}else {$("#lblZW").text("正面");}}}}}, //獲取投票結果明細loadVoteResultDetail: function (pageNumber, pageSize) {var that = modVoteResultCtrl; //處理頁碼if (pageNumber == undefined || pageSize == undefined) {pageNumber = that.uiStore.gvVoteResultDetailList.getPageNumber();pageSize = that.uiStore.gvVoteResultDetailList.getPageSize();}var param = {reqType: "GetVoteResultDetail",instID: "555",stepID: "555",pageSize: pageSize,//每頁數據pageNum: pageNumber//頁數};that.ajaxDeal(that.dataStore.ajaxUrl, param, loadDataSuc);//加載數據function loadDataSuc(result) {var dataInfo = {//分頁信息total: result.data.length <= 0 ? 0 : result.data[0].TOTAL_COUNT,//與數據庫中總記錄數字段對應rows: result.data} that.uiStore.gvVoteResultDetailList.loadData(dataInfo);}}};//賦給公共的對象exp.modVoteResultCtrl = myModObj;})();/*** 引入公共工具集及其他模塊*/window.modVoteResultCtrl = imp(["baseHelper", "modVoteResultCtrl"]);/*** 頁面初始化*/$(function () {modVoteResultCtrl.init();});</script>
</head>
<body style="visibility:hidden"><div><div title="投票結果" class="easyui-panel" icon="icon-edit" collapsible="true" style="width: auto; height: auto; padding: 5px;"><table class="tableList"><tr><td class="title" align="center">債券等級：</td><td><label id="lblZQDJ" /></td><td class="title" align="center">主體等級：</td><td><label id="lblZTDJ" /></td><td class="title" align="center">展望:</td><td><label id="lblZW" /></td></tr></table></div><table id="gvVoteResultDetailList"></table></div>
</body>
</html>
?VoteAjax頁面：
?
private string GetVoteResultDetail(){var instID = GetQueryString("instID");var stepID = GetQueryString("stepID");var pageSize = GetQueryString("pageSize");var pageNum = GetQueryString("pageNum");var rownum = PageRowNum(pageSize, pageNum);var a = rownum[0].ToString();var b = rownum[1].ToString();Dictionary<string, string> param = new Dictionary<string, string>();param.Add("instID", instID);param.Add("stepID", stepID);param.Add("beginRowNum", rownum[0].ToString());param.Add("endRowNum", rownum[1].ToString());//執行 var data = FlowCtrlProjIndivService.GetService().GetVoteResultDetail(param);//返回結果return new{state = "ok",data = data}.ToJson();}
?
?
?
Dao層：
public DataTable GetVoteResultDetail(Dictionary<string, string> param){return BLLService.GetDataTable("PKG_TEST.VOTE_RESULT_DETAIL_LIST","P_INST_ID", param["instID"],"P_STEP_ID", param["stepID"],"P_BEG_ROW_NUM", param["beginRowNum"],"P_END_ROW_NUM", param["endRowNum"]);}
?
存儲過程：
PROCEDURE VOTE_RESULT_DETAIL_LIST(P_DATA_SET OUT REDATASET.DS,P_INST_ID IN TWF_D_VOTE.INST_ID%TYPE,P_STEP_ID IN TWF_D_VOTE.STEP_ID%TYPE,P_BEG_ROW_NUM IN INTEGER, --起始行數P_END_ROW_NUM IN INTEGER --終止行數) ASBEGINOPEN P_DATA_SET FORSELECT *FROM (SELECT ROWNUM RN, G.*FROM (SELECT COUNT(*) OVER() TOTAL_COUNT,A.USER_NO,VOTE_RESULT_ZQ,VOTE_RESULT_ZT,VOTE_RESULT_ZW,NOTE_CONTENT,IMP_TIMEFROM (SELECT INST_ID,STEP_ID,USER_NO,VOTE_RESULT VOTE_RESULT_ZQ,IMP_TIMEFROM TWF_D_VOTEWHERE VOTE_TYPE = '債券等級'AND INST_ID = P_INST_IDAND STEP_ID = P_STEP_IDORDER BY IMP_TIME DESC) AINNER JOIN (SELECT INST_ID,STEP_ID,USER_NO,VOTE_RESULT VOTE_RESULT_ZTFROM TWF_D_VOTEWHERE VOTE_TYPE = '主體等級') BON A.USER_NO = B.USER_NOAND A.STEP_ID = B.STEP_IDAND A.INST_ID = B.INST_IDINNER JOIN (SELECT INST_ID,STEP_ID,USER_NO,VOTE_RESULT VOTE_RESULT_ZWFROM TWF_D_VOTEWHERE VOTE_TYPE = '展望') DON A.USER_NO = D.USER_NOAND A.STEP_ID = D.STEP_IDAND A.INST_ID = D.INST_IDINNER JOIN (SELECT INST_ID, STEP_ID, USER_NO, NOTE_CONTENTFROM TWF_D_NOTEWHERE NOTE_TYPE = '投票意見') EON A.USER_NO = E.USER_NOAND A.STEP_ID = E.STEP_IDAND A.INST_ID = E.INST_ID) GWHERE ROWNUM <= P_END_ROW_NUM) HWHERE RN >= P_BEG_ROW_NUM;
END VOTE_RESULT_DETAIL_LIST;
?
![Luogu 3698 [CQOI2017]小Q的棋盤](http://pic.xiahunao.cn/Luogu 3698 [CQOI2017]小Q的棋盤)
)
)
