工作总结 2018-4-13 bootstrapTable 属性 queryParams: queryParams,//参数 get 中 %5B%5D 数组的意思...

<table id="dataTable" data-toggle="table" data-show-columns="true" data-mobile-responsive="true"></table>

function getTab() {
        $('#dataTable').bootstrapTable({
            method: 'get', //这里要设置为get，不知道为什么 设置post获取不了
            url: '/AtmAtm/GetCodeList',
            cache: false,
            striped: true,
            pagination: true,
            pageList: [10, 30, 50, 100],
            pageSize: 10,
            pageNumber: 1,
            search: true,
            sidePagination: 'server',//设置为服务器端分页
            queryParams: queryParams,//参数
            showColumns: true,
            showRefresh: true,
            minimumCountColumns: 2,
            clickToSelect: true,
            smartDisplay: true,
            columns: [{
                checkbox: 'true',
                title: '@LangResources.Resource.Info_SelectList'

            },
            {
                field: 'AtmCode',
                title: '@LangResources.Resource.BarCode',
                align: 'center',
                width: '120',
                valign: 'center',
                sortable: true
            }, {
                field: 'AtmNo',
                title: '@LangResources.Resource.AtmNo',
                align: 'center',
                width: '100',
                valign: 'center',
                sortable: true,
                //formatter: operateFormatter
            }
            , {
                field: 'TerminalNum',
                title: '@LangResources.Resource.TerminalNum',
                align: 'center',
                width: '100',
                valign: 'center',
                sortable: true,
                //formatter: operateFormatter
            }
            , {
                field: 'ManufacturerObj',
                title: '@LangResources.Resource.ProducerName',
                align: 'center',
                width: '100',
                valign: 'center',
                sortable: true,
                //formatter: operateFormatter
            }
            , {
                field: 'atmname',
                title: '@LangResources.Resource.Info_JiJuMingCheng',
                align: 'center',
                width: '100',
                valign: 'center',
                sortable: true,
            },
             {
                 field: 'AtmTypeName',
                 title: '@LangResources.Resource.AtmTypeName',
                 align: 'center',
                 width: '150',
                 valign: 'center',
                 sortable: true,
                 //formatter: operateFormatter
             },

                {
                    field: 'CustomerName',
                    title: '@LangResources.Resource.CustomerName',
                    align: 'center',
                    width: '40',
                    valign: 'center',
                    sortable: true,
                    //formatter: operateFormatter
                }, {
                    field: 'Menu_CityRegion',
                    title: '@LangResources.Resource.Menu_CityRegion',
                    align: 'center',
                    width: '100',
                    valign: 'center',
                    sortable: true,
                    //formatter: operateFormatter
                }, {
                    field: 'BlockName',
                    title: '@LangResources.Resource.BlockName',
                    align: 'center',
                    width: '100',
                    valign: 'center',
                    sortable: true,
                    //formatter: operateFormatter
                }, {
                    field: 'StreetName',
                    title: '@LangResources.Resource.StreetName',
                    align: 'center',
                    width: '40',
                    valign: 'center',
                    sortable: true,
                    //formatter: operateFormatter
                },
                @*{
                    field: 'AtmStatus',
                    title: '@LangResources.Resource.AtmStatus',
                    align: 'center',
                    width: '40',
                    valign: 'center',
                    sortable: true,
                    //formatter: operateFormatter
                },*@
                {
                    field: 'JobType',
                    title: '@LangResources.Resource.JobType',
                    align: 'center',
                    width: '60',
                    valign: 'center',
                    sortable: true,
                    formatter: CodeFormatter
                },
                {
                    field: 'RevertPosition',
                    title: '@LangResources.Resource.RevertPosition',
                    align: 'center',
                    width: '60',
                    valign: 'center',
                    sortable: true,
                },
                {
                    field: 'BillAddress',
                    title: '@LangResources.Resource.BillAddress',
                    align: 'center',
                    width: '60',
                    valign: 'center',
                    sortable: true,
                },
                 {
                     field: 'provinceobj',
                     title: '@LangResources.Resource.province',
                     align: 'center',
                     width: '60',
                     valign: 'center',
                     sortable: true,
                 },
                   {
                       field: 'Districtobj',
                       title: '@LangResources.Resource.District',
                       align: 'center',
                       width: '60',
                       valign: 'center',
                       sortable: true,
                   },
                    {
                        field: 'DPSBinobj',
                        title: '@LangResources.Resource.dpsbin',
                        align: 'center',
                        width: '60',
                        valign: 'center',
                        sortable: true,
                    },
                     {
                         field: 'PasswordLimit',
                         title: '@LangResources.Resource.PasswordLimit',
                         align: 'center',
                         width: '60',
                         valign: 'center',
                         sortable: true,
                     },
                {
                    field: 'Address',
                    title: '@LangResources.Resource.Address',
                    align: 'center',
                    width: '100',
                    valign: 'center',
                    sortable: true,
                },
            {
                field: 'IsAt',
                title: '@LangResources.Resource.IsAt',
                align: 'center',
                width: '100',
                valign: 'center',
                sortable: true,
            },
             {
                 field: 'EndMDate',
                 title: '@LangResources.Resource.EndMDate',
                 align: 'center',
                 width: '100',
                 valign: 'center',
                 sortable: true,
             },
              {
                  field: 'AtmSetupType',
                  title: '@LangResources.Resource.AtmSetupType',
                  align: 'center',
                  width: '100',
                  valign: 'center',
                  sortable: true,
              }, {
                  field: 'IsNon',
                  title: 'nodv',
                  align: 'center',
                  width: '100',
                  valign: 'center',
                  sortable: true,
              },
              {
                  field: 'Remark',
                  title: '@LangResources.Resource.Remark',
                  align: 'center',
                  width: '100',
                  valign: 'center',
                  sortable: true,
              }, {
                  field: 'StartMDates',
                  title: '@LangResources.Resource.StartMDates',
                  align: 'center',
                  width: '80',
                  valign: 'center',
                  sortable: true,
                  formatter: dateFormatter
              },
                {
                    field: 'Id',
                    title: '@LangResources.Resource.Operation',
                    align: 'center',
                    width: '250',
                    valign: 'top',
                    sortable: true,
                    formatter: EditeOpt
                }
            ], onLoadSuccess: function () {


            },
            onLoadError: function () {
                //mif.showErrorMessageBox("数据加载失败！");
            }
        });
        $('#dataTable').bootstrapTable('hideColumn', 'Address');
    }

//设置传入参数
    function queryParams(params) {
        debugger
        console.info(params);
        var CustomerType = $("#CustomerType").val();
        var ATMModelType = $("#ATMModelType").val();
        var mxdrq = $("#mxdrq").val();
        var startdate = $("#startdate").val();
        var enddate = $("#enddate").val();
        
       
        return {
            "offset": params.offset,
            "limit": params.limit,
            "CustomerType": CustomerType,
            "ATMModelType": ATMModelType,
            "mxdrq": mxdrq,
            "startdate": startdate,
            "enddate": enddate,
            "sort": params.sort,
            "search": params.search,
            "order": params.order
        }

        return params;
    }

 

get请求 的参数   全部 保存在 

queryParams: queryParams,//参数  里面(bootstrap 封装好的)

 

 

 

 

http://localhost:8003/AtmAtm/GetCodeList?offset=0&limit=10&CustomerType%5B%5D=9e6f6cff-6e64-41f1-a7be-c07335764423&CustomerType%5B%5D=58194020-9eaf-4a6c-a5cc-b8fa6f628ba9&CustomerType%5B%5D=045426c5-9fd9-4c26-b4f0-dc0015ee96b8&CustomerType%5B%5D=ea0087c9-4172-4c03-92c5-4cc0cd9ac62d&CustomerType%5B%5D=40bde8fc-8a97-45e7-9907-524167975791&ATMModelType%5B%5D=a73a5fb1-bd7f-4088-9a33-3cb539e02f89&ATMModelType%5B%5D=b6cc57f2-d067-462c-9cc7-4f892932d0d5&ATMModelType%5B%5D=82e91205-1a16-11e7-b428-00163e003600&ATMModelType%5B%5D=83d5a7cc-4955-445a-b4b6-c881c4dcfcec&ATMModelType%5B%5D=1b673892-b161-4968-9066-3c3ca72bac37&ATMModelType%5B%5D=82e91099-1a16-11e7-b428-00163e003600&mxdrq=2&startdate=2014-06-29&enddate=2018-04-13&search=&order=asc&_=1523614816387

 

 

%5B%5D  数组 的 意思 

 

在后台 

 //查询
            //string[] CustomerType = (Request["CustomerType[]"] + "").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            //string[] ATMModelType = (Request["ATMModelType[]"] + "").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            string CustomerType = (Request["CustomerType[]"] + "");
            string ATMModelType = (Request["ATMModelType[]"] + "");

get请求  Request 的话  这样 

Request["CustomerType[]"]

 获取 数组

post请求   的话  这样 

public string GetCodeList(List<string> arr)  或者 对象中某属性 

 获取 数组

 

转载于:https://www.cnblogs.com/cjm123/p/8822723.html