jqgrid分页后，自定义查询数据怎么得到所有页的某列值的合计

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="In.aspx.cs" Inherits="test.WebForm1" %><!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>
    <title>收入合同自定义查询（单位：万元）</title>
    <link id="uiThemes" rel="stylesheet" type="text/css" media="screen" href="css/themes/base/jquery-ui.css" />
    <link rel="stylesheet" type="text/css" media="screen" href="css/themes/base/ui.jqgrid.css" />    <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script>
    <script src="js/jquery-ui.min.js" type="text/javascript"></script>
    <script src="js/grid.locale-cn.js" type="text/javascript"></script>
    <script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="js/keyan.js" type="text/javascript"></script>
    <script src="js/expExcel.js" type="text/javascript"></script>    <%--最近的Jqgrid--%>
   <%-- <link rel="stylesheet" type="text/css" media="screen" href="New/css/ui.jqgrid.css" />
    <script src="New/js/jquery-1.7.2.min.js" type="text/javascript"></script>
    <script src="New/js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="New/js/jquery.jqGrid.src.js" type="text/javascript"></script>--%>
    <%--最近的Jqgrid--%>
    <script type="text/javascript">
        $(document).ready(function () {
            // 获取iframe父级页面project_id
            //var scriptValue = window.parent.document.getElementById("hdglbprojectid").value;
            var scriptValue = "A300001000000";
            //获取iframe父级页面project_id
            $(window).bind("resize", function () { $("#list").setGridWidth($(window).width()); }).trigger("resize");
            //JqGrid定义开始
            $("#list").jqGrid({
                //地址指向传参
                url: "Handler1.ashx?project_id=" + scriptValue,
                datatype: "json",
                colModel: [
                       { name: "Ma_sid", hidden: true, hidedlg: true, sortable: false, search: false },
                        { name: "name", label: "合同名称", index: "name", align: "left", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        { name: "former_code", label: "内部合同号", index: "former_code", align: "left", formatter: "showlink", formatoptions: { baseLinkUrl: 'http://10.177.10.14/NewPlant/ParsePBPForm.aspx', target: '_blank', idName: 'recordid', addParam: '&pbpformsid=800&actname=modify&envkey=W10=&title=CNT_收入合同档案' }, searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text"},
                        { name: "amount", label: "合同金额（万元）", index: "amount", align: "left", width: "120px !important", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"], search: true, searchtype: "number" }, formatter: "number", sorttype: "number", stype: "number" },                        { name: "ask_moneys", label: "累计应收金额（万元）", index: "ask_moneys", align: "center", width: "120px !important", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"] }, formatter: "number", sorttype: "number", stype: "number" },
                        { name: "amount_summary", label: "累计发票（万元）", index: "amount_summary", align: "center", width: "120px !important", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"] }, formatter: "number", sorttype: "number", stype: "number" },
                        { name: "act_recieved_money", label: "累积实收金额（万元）", index: "act_recieved_money", align: "center", width: "120px !important", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"] }, formatter: "number", sorttype: "number", stype: "number" },

                        { name: "isXT", label: "是否关联合同", index: "isXT", align: "center", width: "100px !important", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        { name: "jiafang", label: "甲方", index: "jiafang", align: "left", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        //{ name: "yifang", label: "乙方", index: "name", align: "left", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },                        {name: "account_name", label: "帐套名称", index: "account_name", align: "center", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },                        { name: "signing_date", label: "签订日期", index: "signing_date", sorttype: "date", width: "120px !important", align: "left", formatter: "date", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"], search: true, searchtype: "date", dataInit: function (el) { keyan.datesearch(el); } } },
                        { name: "star_date", label: "开工日期", index: "star_date", sorttype: "date", width: "120px !important", align: "left", formatter: "date", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"], search: true, searchtype: "date", dataInit: function (el) { keyan.datesearch(el); } } },
                        { name: "report_date", label: "上报日期", index: "report_date", sorttype: "date", width: "120px !important", align: "left", formatter: "date", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"], search: true, searchtype: "date", dataInit: function (el) { keyan.datesearch(el); } } },
                        { name: "sxecution_state", label: "执行状态", index: "sxecution_state", width: "120px !important", align: "left", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                         { name: "category", label: "合同类型", index: "category", align: "center", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        { name: "zihangye", label: "子行业", index: "zihangye", align: "center", width: "120px !important", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        //{ name: "area", label: "地域", index: "area", align: "center", width: "120px !important", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                    //{ name: "contry", label: "国家", index: "contry", align: "center", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" },
                        {name: "period", label: "工期（月）", index: "period", align: "center", width: "120px !important", searchoptions: { sopt: ["eq", "lt", "le", "gt", "ge"], search: true, searchtype: "number" }, formatter: "number", sorttype: "number", stype: "number" },
                        { name: "registerhuman", label: "录入人", index: "registerhuman", align: "center", formatter: "text", searchoptions: { sopt: ["cn", "eq"] }, search: true, searchtype: "text" }
                ],
                height: "400",
                autowidth: true,
                rowNum: -1,
                rownumbers: true,
                loadonce: true,                pager: 'pager', //分页工具栏
                rowNum: 16, //每页显示记录数
                viewrecords: true, //是否显示行数
                pagerpos: "center",
                pgbuttons: true,
                viewrecords: true,
                autoScroll: true,
                shrinkToFit: false,
                multiselect: false,
                footerrow: true,
                gridComplete: function () {
                    var rowNum = parseInt($(this).getGridParam("records"), 20);
                    if (rowNum > 0) {
                        $(".ui-jqgrid-sdiv").show();
                        //var amount = jQuery(this).getCol("amount", true, "sum");
                        var amount = jQuery(this).getCol("amount", true, "sum");
                        $(this).footerData("set", {
                        project_name: "本页小计", amount: amount
                    });
                }
                else {
                    $(".ui-jqgrid-sdiv").hide();
                }
            } //底部合计
        })
        //JqGrid定义结束
        //底部面板定义开始
              .navGrid("#pager", { add: false, edit: false, del: false, refresh: false, search: false })
             .navButtonAdd("#pager", {
                 caption: "<b style='font-family:宋体;font-size :14px;color:blue'>自定义显示列</b>",
                 onClickButton: function () {
                     $("#list").setColumns({ colnameview: false });
                 },
                 title: "自定义显示列",
                 position: "next"
             })              .navButtonAdd("#pager", {
                  caption: "<b style='font-family:宋体;font-size :14px;color:blue'>自定义查询</b>",
                  title: "自定义查询",
                  buttonicon: "ui-icon-search",
                  onClickButton: function () {
                      $("#list").jqGrid("searchGrid",
                          { caption: "自定义查询", multipleSearch: true }
                      );
                  },
                  position: "last"
              })
              .navButtonAdd("#pager", {
                  caption: "<b style='font-family:宋体;font-size :14px;color:blue'>导出预览</b>",
                  buttonicon: "ui-icon-extlink",
                  onClickButton: function () {
                      //var list = document.getElementById("list");
                      //expExcel.method2("list");
                      showModalDialog('../excel.aspx?p=', scriptValue, 'dialogWidth:1000px;dialogHeight800px;dialogLeft:200px;dialogTop:150px;center: yes;help:yes;resizable:yes;status:yes')
                  },
                  title: "导出Excel",                  position: "next"
              });
        //底部面板定义结束
    });
</script>
   
</head>
<body>
    <form id="form1" runat="server">
        <table id="list" ></table>
    <div id="pager" ></div>
    </form>
</body>
</html>代码是这样的
这个是加了自定义查询条件之后的值的合计，我后台没法循环累加你前台 js  啊。
我前台JS只能循环累加当前页的数据，大侠
我前几天也碰到这个问题，今天刚整出来，我用的的java语言，看看能不能帮到你1.在后台通过sql将总合计(total_money)算出；2.重写JqGrid.class中的listJson方法，将total_money传入该方法，放入到JsonObject中3. 在jquery.jqGrid.src.js的addJSONData方法中，在
ts.p.records = $.jgrid.getAccessor(data,dReader.records) || 0;(这是总记录数)
                        之后添加
ts.p.total_money = $.jgrid.getAccessor(data,dReader.total_money) || 0;4.还是在jquery.jqGrid.src.js中，将total_money 加入到下面代码中
ts.p.jsonReader = $.extend(true,{
root: "rows",
page: "page",
total: "total",
// add total_money
total_money: "total_money",
records: "records",
repeatitems: true,
cell: "cell",
id: "id",
userdata: "userdata",
subgrid: {root:"rows", repeatitems: true, cell:"cell"}
},ts.p.jsonReader);
ts.p.localReader = $.extend(true,{
root: "rows",
page: "page",
total: "total",
// add total_money
total_money: "total_money",
records: "records",
repeatitems: false,
cell: "cell",
id: "id",
userdata: "userdata",
subgrid: {root:"rows", repeatitems: true, cell:"cell"}
},ts.p.localReader);5.在页面显示：
$(function($) {
       var url = '/pay?task=listTB_CWGL_Pay&'+$("#form1").serialize();
var settings = ${JqGrid};
var settings2 = {
    url:url,
    footerrow:true, //求合计
    gridComplete:function(){
    var rowNum = parseInt($(this).getGridParam('records'),15);
    // 总合计
    var total_money = $(this).getGridParam('total_money');
    if(rowNum > 0){
      $(".ui-jqgrid-sdiv").show();
         var id = jQuery(this).getCol('id',false);
         var fund_yjje_sum  = jQuery(this).getCol('fund_yjje',false,'sum');
         var tf_je_sum  = jQuery(this).getCol('tf_je',false,'sum');
         var fund_sj_sum  = jQuery(this).getCol('fund_sj',false,'sum');
         $(this).footerData("set",{start_date:"总合计",end_date:total_money,pay_date:"本页合计：",fund_yjje:fund_yjje_sum,
             tf_je:tf_je_sum,fund_sj:fund_sj_sum});
     }else{
        $(".ui-jqgrid-sdiv").hide();
     }
    }
};
jQuery.extend(settings,settings2);
setJqGrid(settings);
   });

调试易

jqgrid分页后，自定义查询数据怎么得到所有页的某列值的合计

解决方案 »