ReportViewer2010冻结行列

时间：2022-04-17 16:37:45
 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="NewTrackingVer.aspx.cs"

     Inherits="GeoOilRes.RDLC.NewTrackingVer" %>

 <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

     Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

 <!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>

     <script src="../../Scripts/jquery-1.8.1.min.js" type="text/javascript"></script>

     <script src="../Scripts/rdlc-function.js" type="text/javascript"></script>

     <script type="text/javascript">

            $(function () {

             var ReportTable = $('#VisibleReportContentReportViewer1_ctl10');

             if (ReportTable.html().length > 0 ) {

                 var w = pageWidth();

                 var h = pageHeight();

                 var tableID = "RdlcTable";

                 $('#VisibleReportContentReportViewer1_ctl10 table table table table:last').attr("ID", tableID);

                 freezeTable(tableID, 5, 4, w, h);

                 var flag = false;

                 $(window).resize(function () {

                     if (flag)

                         return;

                     setTimeout(function () {

                         adjustTableSize(tableID, w, h);

                         flag = false;

                     }, 100);

                     flag = true;

                 });

             }

         });

 </script>

 </head>

 <body style="padding: 0; margin: 0; overflow: hidden; background-color: white;">

     <form id="form1" runat="server" style="text-align: left;">

     <asp:ScriptManager ID="ScriptManager1" runat="server">

     </asp:ScriptManager>           <asp:UpdatePanel ID="UpdatePanel1" runat="server" RenderMode="Inline">

         <ContentTemplate>

             <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

                 InteractiveDeviceInfos="(集合)" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt"

                 Width="100%" Height="100%" ShowToolBar="true" ShowBackButton="False" ShowFindControls="False"

                 ShowRefreshButton="False" HyperlinkTarget="_self">

             </rsweb:ReportViewer>

         </ContentTemplate>

         <Triggers>

             <asp:PostBackTrigger ControlID="ReportViewer1" />

         </Triggers>

     </asp:UpdatePanel>

     </form>

     </body>

 </html>
 /*

 * 锁定表头和列

 *

 * 参数定义

 *     table - 要锁定的表格元素或者表格ID

 *     freezeRowNum - 要锁定的前几行行数，如果行不锁定，则设置为0

 *     freezeColumnNum - 要锁定的前几列列数，如果列不锁定，则设置为0

 *     width - 表格的滚动区域宽度

 *     height - 表格的滚动区域高度

 */

 function freezeTable(table, freezeRowNum, freezeColumnNum, width, height) {

     freezeRowNum += 1;

     freezeColumnNum += 1;

     if (typeof (freezeRowNum) == 'string')

         freezeRowNum = parseInt(freezeRowNum)

     if (typeof (freezeColumnNum) == 'string')

         freezeColumnNum = parseInt(freezeColumnNum)

     var tableId;

     if (typeof (table) == 'string') {

         tableId = table;

         table = $('#' + tableId);

     } else

         tableId = table.attr('id');

     var divTableLayout = $("#" + tableId + "_tableLayout");

     if (divTableLayout.length != 0) {

         divTableLayout.before(table);

         divTableLayout.empty();

     } else {

         table.after("<div id='" + tableId + "_tableLayout' style='overflow:hidden;height:" + height + "px; width:" + width + "px;'></div>");

         divTableLayout = $("#" + tableId + "_tableLayout");

     }

     var html = '';

     if (freezeRowNum > 0 && freezeColumnNum > 0)

         html += '<div id="' + tableId + '_tableFix" style="padding: 0px;"></div>';

     if (freezeRowNum > 0)

         html += '<div id="' + tableId + '_tableHead" style="padding: 0px;"></div>';

     if (freezeColumnNum > 0)

         html += '<div id="' + tableId + '_tableColumn" style="padding: 0px;"></div>';

     html += '<div id="' + tableId + '_tableData" style="padding: 0px;"></div>';

     $(html).appendTo("#" + tableId + "_tableLayout");

     var divTableFix = freezeRowNum > 0 && freezeColumnNum > 0 ? $("#" + tableId + "_tableFix") : null;

     var divTableHead = freezeRowNum > 0 ? $("#" + tableId + "_tableHead") : null;

     var divTableColumn = freezeColumnNum > 0 ? $("#" + tableId + "_tableColumn") : null;

     var divTableData = $("#" + tableId + "_tableData");

     divTableData.append(table);

     if (divTableFix != null) {

         var tableFixClone = table.clone(true);

         tableFixClone.attr("id", tableId + "_tableFixClone");

         divTableFix.append(tableFixClone);

     }

     if (divTableHead != null) {

         var tableHeadClone = table.clone(true);

         tableHeadClone.attr("id", tableId + "_tableHeadClone");

         divTableHead.append(tableHeadClone);

     }

     if (divTableColumn != null) {

         var tableColumnClone = table.clone(true);

         tableColumnClone.attr("id", tableId + "_tableColumnClone");

         divTableColumn.append(tableColumnClone);

     }

     $("#" + tableId + "_tableLayout table").css("margin", "0");

     if (freezeRowNum > 0) {

         var HeadHeight = 0;

         var ignoreRowNum = 0;

         $("#" + tableId + "_tableHead tr:lt(" + freezeRowNum + ")").each(function () {

             if (ignoreRowNum > 0)

                 ignoreRowNum--;

             else {

                 var td = $(this).find('td:first, th:first');

                 HeadHeight += td.outerHeight(true);

                 ignoreRowNum = td.attr('rowSpan');

                 if (typeof (ignoreRowNum) == 'undefined')

                     ignoreRowNum = 0;

                 else

                     ignoreRowNum = parseInt(ignoreRowNum) - 1;

             }

         });

         HeadHeight += 2;

         divTableHead.css("height", HeadHeight);

         divTableFix != null && divTableFix.css("height", HeadHeight);

     }

     if (freezeColumnNum > 0) {

         var ColumnsWidth = 0;

         var ColumnsNumber = 0;

         $("#" + tableId + "_tableColumn tr:eq(" + freezeRowNum + ")").find("td:lt(" + freezeColumnNum + "), th:lt(" + freezeColumnNum + ")").each(function () {

             if (ColumnsNumber >= freezeColumnNum)

                 return;

             ColumnsWidth += $(this).outerWidth(true);

             ColumnsNumber += $(this).attr('colSpan') ? parseInt($(this).attr('colSpan')) : 1;

         });

         ColumnsWidth += 2;

         divTableColumn.css("width", ColumnsWidth);

         divTableFix != null && divTableFix.css("width", ColumnsWidth);

     }

     divTableData.scroll(function () {

         divTableHead != null && divTableHead.scrollLeft(divTableData.scrollLeft());

         divTableColumn != null && divTableColumn.scrollTop(divTableData.scrollTop());

     });

     divTableFix != null && divTableFix.css({ "overflow": "hidden", "background-color": "white", "position": "absolute", "z-index": "50" });

     divTableHead != null && divTableHead.css({ "overflow": "hidden", "background-color": "white", "width": width - 17, "position": "absolute", "z-index": "45" });

     divTableColumn != null && divTableColumn.css({ "overflow": "hidden", "background-color": "white", "height": height - 17, "position": "absolute", "z-index": "40" });

     divTableData.css({ "overflow": "scroll", "width": width, "height": height, "position": "absolute" });

     divTableFix != null && divTableFix.offset(divTableLayout.offset());

     divTableHead != null && divTableHead.offset(divTableLayout.offset());

     divTableColumn != null && divTableColumn.offset(divTableLayout.offset());

     divTableData.offset(divTableLayout.offset());

 }

 /*

 * 调整锁定表的宽度和高度，这个函数在resize事件中调用

 *

 * 参数定义

 *     table - 要锁定的表格元素或者表格ID

 *     width - 表格的滚动区域宽度

 *     height - 表格的滚动区域高度

 */

 function adjustTableSize(table, width, height) {

     var tableId;

     if (typeof (table) == 'string')

         tableId = table;

     else

         tableId = table.attr('id');

     $("#" + tableId + "_tableLayout").width(width).height(height);

     $("#" + tableId + "_tableHead").width(width - 17);

     $("#" + tableId + "_tableColumn").height(height - 17);

     $("#" + tableId + "_tableData").width(width).height(height);

 }

 function pageHeight() {

     if ($.browser.msie) {

         return document.compatMode == "CSS1Compat" ? document.documentElement.clientHeight : document.body.clientHeight;

     } else {

         return self.innerHeight;

     }

 };

 //返回当前页面宽度

 function pageWidth() {

     if ($.browser.msie) {

         return document.compatMode == "CSS1Compat" ? document.documentElement.clientWidth : document.body.clientWidth;

     } else {

         return self.innerWidth;

     }

 };

相关文章