1.前台 <%-- builed by manage.aspx.cmt [ver:2018.25.11] at 2018/4/11 15:25:43 --%> <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TranProfitLossImpactManage.aspx.cs" Inherits="HraWeb.TranProfitLossImpactManage" %> <%@ Register Assembly="Trirand.Web" TagPrefix="asp" Namespace="Trirand.Web.UI.WebControls" %> <%@ Register Src="~/Contols/Manage.ascx" TagName="Manage" TagPrefix="uc1" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div id="toolbar" class="datagrid-toolbar"> <div class="panel-body" style="border: none; background: none; padding: 5px 20px;"> <div class="pull-right"> <div class="btn-group btn-group-sm"> <div class="input-group input-group-sm" style=" 300px"> <div class="input-group-addon">名称</div> <input type="text" id="txt_Name_LK_" name="txt_Name_LK_" class="datacontrol form-control" style="border-radius: 0px" /> <span class="input-group-btn"> <button class="btn btn-default " id="btn_search" type="button"><i class="fa fa-search"></i>查询</button> </span> </div> </div> </div> </div> </div> <div class='jdataGrid'> <table id="jq"> </table> <div id="jq_pager"> </div> <%-- <table id="jq_t"> </table> <div id="jq_pgr"> </div>--%> </div> </form> <script type="text/javascript"> function bindSubGrid(subgrid_id, asofdate) { var subgrid_table_id; subgrid_table_id = subgrid_id + "_t"; // (3)根据subgrid_id定义对应的子表格的table的id var subgrid_pager_id; subgrid_pager_id = subgrid_id + "_pgr" // (4)根据subgrid_id定义对应的子表格的pager的id // (5)动态添加子报表的table和pager $("#" + subgrid_id) .html( "<table id='" + subgrid_table_id + "' class='scroll'></table><div id='" + subgrid_pager_id + "' class='scroll'></div>"); // (6)创建jqGrid对象 $("#" + subgrid_table_id) .jqGrid( { url: 'TranProfitLossImpactManage.aspx?_method=loadbydate&asofdate=' + asofdate, // (7)子表格数据对应的url，注意传入的contact.id参数 datatype: "json", page: 1, colNames: [ "合约号码", "合约名称", "计算方法", "计价货币", "上一日盯市价值", "当日盯市价值", "交易损益", "损益解释水平", "损益解释百分比", "总方差水平", "总方差百分比", "价格重估值", "利率重估值", "汇率重估值", "时间重估值", "关联度重估值", "价格归因", "利率归因", "汇率归因", "时间归因", "价格差值", "波动率差值", "利率差值", "汇率差值", "VEGAGAMMA归因", "交叉GAMMA归因", "交叉VEGAGAMMA归因", "DELTAVEGA归因", "波动率重估值", "波动率偏差重估值", "价格波动率重估值", "波动率归因", "波动率偏差归因", "价格波动率归因", "关联度归因", "价格方差", "波动率方差", "波动率偏差方差", "价格波动率方差", "利率方差", "汇率方差", "关联度方差", "时间方差", "新交易归因", "交易结算归因", "交易撤销归因", "交易修订归因", "价格重置归因", "期权执行归因", "DELTA归因", "GAMMA归因", "VEGA归因", "THETA归因", "RHO归因", "ETA归因", "Id"], colModel: [ { "name": "TransactionId", "superFilterColumn": "TransactionId", "searchoptions": { }, "index": "TransactionId" }, { "name": "TransactionName", "superFilterColumn": "TransactionName", "searchoptions": { }, "index": "TransactionName" }, { "name": "ComputeMethodId", "superFilterColumn": "ComputeMethodId", "searchoptions": { }, "index": "ComputeMethodId" }, { "name": "ValueCurrencyName", "superFilterColumn": "ValueCurrencyName", "searchoptions": { }, "index": "ValueCurrencyName" }, { "name": "PriorMtmValue", "superFilterColumn": "PriorMtmValue", "searchoptions": { }, "index": "PriorMtmValue" }, { "name": "CurrMtmValue", "superFilterColumn": "CurrMtmValue", "searchoptions": { }, "index": "CurrMtmValue" }, { "name": "ProfitLossValue", "superFilterColumn": "ProfitLossValue", "searchoptions": { }, "index": "ProfitLossValue" }, { "name": "PnlExplainedLevel", "superFilterColumn": "PnlExplainedLevel", "searchoptions": { }, "index": "PnlExplainedLevel" }, { "name": "PnlExplainedPercent", "superFilterColumn": "PnlExplainedPercent", "searchoptions": { }, "index": "PnlExplainedPercent" }, { "name": "TotalVarianceLevel", "superFilterColumn": "TotalVarianceLevel", "searchoptions": { }, "index": "TotalVarianceLevel" }, { "name": "TotalVariancePercent", "superFilterColumn": "TotalVariancePercent", "searchoptions": { }, "index": "TotalVariancePercent" }, { "name": "PriceRevaluation", "superFilterColumn": "PriceRevaluation", "searchoptions": { }, "index": "PriceRevaluation" }, { "name": "IrRateRevaluation", "superFilterColumn": "IrRateRevaluation", "searchoptions": { }, "index": "IrRateRevaluation" }, { "name": "FxRateRevaluation", "superFilterColumn": "FxRateRevaluation", "searchoptions": { }, "index": "FxRateRevaluation" }, { "name": "TimeRevaluation", "superFilterColumn": "TimeRevaluation", "searchoptions": { }, "index": "TimeRevaluation" }, { "name": "CorrRevaluation", "superFilterColumn": "CorrRevaluation", "searchoptions": { }, "index": "CorrRevaluation" }, { "name": "PriceImpact", "superFilterColumn": "PriceImpact", "searchoptions": { }, "index": "PriceImpact" }, { "name": "IrRateImpact", "superFilterColumn": "IrRateImpact", "searchoptions": { }, "index": "IrRateImpact" }, { "name": "FxRateImpact", "superFilterColumn": "FxRateImpact", "searchoptions": { }, "index": "FxRateImpact" }, { "name": "TimeImpact", "superFilterColumn": "TimeImpact", "searchoptions": { }, "index": "TimeImpact" }, { "name": "PriceDifferential", "superFilterColumn": "PriceDifferential", "searchoptions": { }, "index": "PriceDifferential" }, { "name": "VolatilityDifferential", "superFilterColumn": "VolatilityDifferential", "searchoptions": { }, "index": "VolatilityDifferential" }, { "name": "IrRateDifferential", "superFilterColumn": "IrRateDifferential", "searchoptions": { }, "index": "IrRateDifferential" }, { "name": "FxRateDifferential", "superFilterColumn": "FxRateDifferential", "searchoptions": { }, "index": "FxRateDifferential" }, { "name": "VegaGammaImpact", "superFilterColumn": "VegaGammaImpact", "searchoptions": { }, "index": "VegaGammaImpact" }, { "name": "CrossGammaImpact", "superFilterColumn": "CrossGammaImpact", "searchoptions": { }, "index": "CrossGammaImpact" }, { "name": "CrossVegaGammaImpact", "superFilterColumn": "CrossVegaGammaImpact", "searchoptions": { }, "index": "CrossVegaGammaImpact" }, { "name": "DeltaVegaImpact", "superFilterColumn": "DeltaVegaImpact", "searchoptions": { }, "index": "DeltaVegaImpact" }, { "name": "VolatilityRevaluation", "superFilterColumn": "VolatilityRevaluation", "searchoptions": { }, "index": "VolatilityRevaluation" }, { "name": "VolSkewRevaluation", "superFilterColumn": "VolSkewRevaluation", "searchoptions": { }, "index": "VolSkewRevaluation" }, { "name": "PriceVolRevaluation", "superFilterColumn": "PriceVolRevaluation", "searchoptions": { }, "index": "PriceVolRevaluation" }, { "name": "VolatilityImpact", "superFilterColumn": "VolatilityImpact", "searchoptions": { }, "index": "VolatilityImpact" }, { "name": "VolSkewImpact", "superFilterColumn": "VolSkewImpact", "searchoptions": { }, "index": "VolSkewImpact" }, { "name": "PriceVolImpact", "superFilterColumn": "PriceVolImpact", "searchoptions": { }, "index": "PriceVolImpact" }, { "name": "CorrImpact", "superFilterColumn": "CorrImpact", "searchoptions": { }, "index": "CorrImpact" }, { "name": "PriceVariance", "superFilterColumn": "PriceVariance", "searchoptions": { }, "index": "PriceVariance" }, { "name": "VolatilityVariance", "superFilterColumn": "VolatilityVariance", "searchoptions": { }, "index": "VolatilityVariance" }, { "name": "VolSkewVariance", "superFilterColumn": "VolSkewVariance", "searchoptions": { }, "index": "VolSkewVariance" }, { "name": "PriceVolVariance", "superFilterColumn": "PriceVolVariance", "searchoptions": { }, "index": "PriceVolVariance" }, { "name": "IrRateVariance", "superFilterColumn": "IrRateVariance", "searchoptions": { }, "index": "IrRateVariance" }, { "name": "FxRateVariance", "superFilterColumn": "FxRateVariance", "searchoptions": { }, "index": "FxRateVariance" }, { "name": "CorrVariance", "superFilterColumn": "CorrVariance", "searchoptions": { }, "index": "CorrVariance" }, { "name": "TimeVariance", "superFilterColumn": "TimeVariance", "searchoptions": { }, "index": "TimeVariance" }, { "name": "NewTranImpact", "superFilterColumn": "NewTranImpact", "searchoptions": { }, "index": "NewTranImpact" }, { "name": "SettledTranImpact", "superFilterColumn": "SettledTranImpact", "searchoptions": { }, "index": "SettledTranImpact" }, { "name": "CancelledTranImpact", "superFilterColumn": "CancelledTranImpact", "searchoptions": { }, "index": "CancelledTranImpact" }, { "name": "AmendedtranImpact", "superFilterColumn": "AmendedtranImpact", "searchoptions": { }, "index": "AmendedtranImpact" }, { "name": "PriceResetImpact", "superFilterColumn": "PriceResetImpact", "searchoptions": { }, "index": "PriceResetImpact" }, { "name": "OptionExerciseImpact", "superFilterColumn": "OptionExerciseImpact", "searchoptions": { }, "index": "OptionExerciseImpact" }, { "name": "DeltaImpact", "superFilterColumn": "DeltaImpact", "searchoptions": { }, "index": "DeltaImpact" }, { "name": "GammaImpact", "superFilterColumn": "GammaImpact", "searchoptions": { }, "index": "GammaImpact" }, { "name": "VegaImpact", "superFilterColumn": "VegaImpact", "searchoptions": { }, "index": "VegaImpact" }, { "name": "ThetaImpact", "superFilterColumn": "ThetaImpact", "searchoptions": { }, "index": "ThetaImpact" }, { "name": "RhoImpact", "superFilterColumn": "RhoImpact", "searchoptions": { }, "index": "RhoImpact" }, { "name": "EtaImpact", "superFilterColumn": "EtaImpact", "searchoptions": { }, "index": "EtaImpact" }, { "superFilterColumn": "Id", "name": "Id", "searchoptions": { "searchhidden": true }, "hidden": true, "key": true, "index": "Id" } ], viewrecords: true, scrollrows: false, styleUI: 'Bootstrap', jsonReader: { id: "Id" }, rowList : [ 10, 20, 30 ], rowNum: 10, sortorder: 'asc', hidegrid: false, height: ComputGridHeight(320), auto true, headertitles: true, rownumbers: true, shrinkToFit: false, pager: jQuery('#' + subgrid_pager_id), viewsortcols: [false, 'vertical', true] }); $("#"+subgrid_id).setGridWidth($(window).width() - 1); } function PageOnLoad() { jQuery('#jq').jqGrid({ url: '/Tran/TranProfitLossImpactManage.aspx?_method=loadDate', editurl: '/Tran/TranProfitLossImpactManage.aspx?_menuId=17264&jqGridID=jq&editMode=1', datatype: 'json', page: 1, colNames: ["运行日期"], pageSize: 20000, colModel: [ { $(window).width() *0.9, "name": "AsOfDate", "formatter": getDate, "index": "AsOfDate", } ], viewrecords: true, scrollrows: false, styleUI: 'Bootstrap', jsonReader: { id: "Id" }, rowNum: 20000, sortorder: 'asc', hidegrid: false, 800, height: ComputGridHeight(180), auto true, headertitles: true, rownumbers: true, shrinkToFit: false, //pager: jQuery('#jq_pager'), viewsortcols: [false, 'vertical', true], loadComplete: JDataGrid.loadComplete, subGrid: true,//开启子表格支持 //子表格的id；当子表格展开的时候，在主表格中会创建一个div元素用来容纳子表格，subgrid_id就是这个div的id subGridRowExpanded: function (subgrid_id, row_id) {//子表格容器的id和需要展开子表格的行id var obj = $("#jq").jqGrid('getRowData', row_id); bindSubGrid(subgrid_id, obj.AsOfDate); } //,ondblClickRow: JDataGrid.rowDoubleClick }); $("#jq").setGridWidth($(window).width() - 1); //控件按钮设置 $(".button").linkbutton({ plain: true }); //参数说明：控件Id,查询地址，编辑页面的宽度，高度,编辑页面标题,新增按钮,编辑按钮，删除按钮，查询按钮，查询回调函数 JDataGrid.InitGrid("jq", "/TranProfitLossImpact/TranProfitLossImpactEdit.aspx", 600, 400, "交易合约损益归因分析菜单管理", $("#btn_add"), $("#btn_edit"), $("#btn_del"), $("#btn_search")); } </script> </body> </html> 2.后台 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using HraWeb.Common; using WebApp.Common; using Contract.Domain; using System.Collections; using Framework; using NHibernate.Linq; namespace HraWeb { public partial class TranProfitLossImpactManage : JQEntityManage<Contract.Domain.TranProfitLossImpact> { protected override void Page_Load(object sender, EventArgs e) { //给基类服务接口复制，可不付 //base.svc = Psvc; if (!IsPostBack) { } switch (Request["_method"]) { case "loadDate": var mRows = Dao.GetCurrentSession().QueryOver<TranProfitLossImpact>().List().Distinct(new TranProfitLossImpactDateDistinct()).ToList(); int count = mRows.Count; JGridJson d = new JGridJson(1, mRows, 1, count); var json= Newtonsoft.Json.JsonConvert.SerializeObject(d); Response.Write(json); Response.End(); break; case "loadbydate": DateTime asofDate = DateTime.Parse(Request["asofdate"]); int pageIndex = int.Parse(Request["page"]); int pageSize = int.Parse(Request["rows"]); var totalInfo = new QueryInfo(); totalInfo.CustomSQL = "select count(1) from tran_profit_loss_impact t where t.as_of_date=:as_of_date"; totalInfo.Parameters.Add("as_of_date", asofDate); int totalRecordCount = 0; int.TryParse(Dao.ExecuteScare(totalInfo).ToString(), out totalRecordCount); var mchildRows = Dao.GetCurrentSession().Query<TranProfitLossImpact>() .Where(x=>x.AsOfDate==asofDate) .Skip((pageIndex-1)*pageSize) .Take(pageSize) .ToList(); int totalPage = ((totalRecordCount - 1) / pageSize) + 1; int mchildcount = mchildRows.Count; JGridJson cd = new JGridJson(totalPage, mchildRows, pageIndex, totalRecordCount); var cjson = Newtonsoft.Json.JsonConvert.SerializeObject(cd); Response.Write(cjson); Response.End(); break; default: break; } base.Page_Load(sender, e); } } }