@wendal 嗯嗯

<%
layout("/layouts/private.html"){
%>
<section class="content-wrap bg-white">
    <header class="header navbar bg-white shadow">
        <div class="btn-group tool-button">
            <a id="add" class="btn btn-primary navbar-btn" href="${base}/private/business/bus_orders/add" data-pjax><i class="ti-plus"></i> 新建 busOrder</a>
            <button class="btn btn-danger navbar-btn" onclick="delCheck()"><i class="ti-close"></i> 删除选中</button>
        </div>
    </header>
    <div class=panel-body style="padding-top: 50px;">
        <div class="table-responsive no-border">
            <input id="unitid" type="hidden">
            <table class="table table-bordered table-striped mg-t datatable">
                <thead>
                    <tr>
                            <th>商品主图</th>
                            <th>营销单号</th>
                            <th>商品名称</th>
                            <th>商品Id</th>
                            <th>商品链接</th>
                            <th>优惠券链接</th>
                            <th>渠道</th>
                            <th>业务员</th>
                            <th>订单状态</th>
                            <th>订单状态</th>
                            <th>订单状态</th>
                            <th>订单状态</th>
                            <th>订单状态</th>
                            <th>订单状态</th>
                            <th>操作</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</section>
<div id="dialogDelete" class="modal fade bs-modal-sm" tabindex="-2" role="dialog" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                <h4 class="modal-title">删除busOrder</h4>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col-xs-12">
                        busOrder删除后无法恢复。<br/>
                        <br/>确定删除吗？
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">取  消</button>
                <button id="okDel" type="button" class="btn btn-primary" data-loading-text="正在删除...">确  定</button>
            </div>
        </div>
    </div>
</div>
<div id="dialogDetail" class="modal fade bs-modal-sm" tabindex="-3" role="dialog" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
        </div>
    </div>
</div>
<script language="JavaScript">
    var datatable;
    function initDatatable() {
        datatable = $('.datatable').DataTable({
            "dom": '<"toolbar">frtip',
            "searching":false,
            "processing": false,
            "serverSide": true,
            "select": true,
            "ordering": true,
            "language": {
                "url": "${base}/assets/plugins/datatables/cn.json"
            },
            "preDrawCallback": function () {
                sublime.showLoadingbar($(".main-content"));
            },
            "drawCallback": function () {
                sublime.closeLoadingbar($(".main-content"));
            },
            "ajax": {
                "url": "${base}/private/business/bus_orders/data",
                "type": "post",
                "data": function (d) {
                    d.unitid = $('#unitid').val();
                }
            },
//            "order": [[0, "desc"]],
            "columns": [
                    {"data": "goodsPicMain", "bSortable": true},
                    {"data": "marketingNum", "bSortable": true},
                    {"data": "goodsName", "bSortable": true},
                    {"data": "goodsId", "bSortable": true},
                    {"data": "goodsUrl", "bSortable": true},
                    {"data": "couponUrl", "bSortable": true},
                    {"data": "channel", "bSortable": true},
                    {"data": "salesman", "bSortable": true},
                    {"data": "busOrderStatus", "bSortable": true},
                    {"data": "busOrderStatus_1", "bSortable": true},
                    {"data": "busOrderStatus_2", "bSortable": true},
                    {"data": "busOrderStatus_3", "bSortable": true},
                    {"data": "busOrderStatus_4", "bSortable": true},
                    {"data": "busOrderStatus_5", "bSortable": true},
            ],
            "columnDefs": [
                {
                    "render": function (data, type, row) {
                        return '<div class="btn-group"><button type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown">' +
                                ' <i class="ti-settings"></i> <span class="ti-angle-down"></span></button><ul class="dropdown-menu" role="menu">' +
                                '<li><a href="${base}/private/business/bus_orders/detail/' + row.id + '" data-toggle="modal" data-target="#dialogDetail">查看信息</a></li>' +
                                '<li><a href="${base}/private/business/bus_orders/edit/' + row.id + '" data-pjax>修改信息</a></li>' +
                                '<li class="divider"></li>' +
                                '<li><a href="javascript:;" onclick="del(\'' + row.id + '\')">删除</a></li>' +
                                '</ul></div>';
                    },
                    "targets": 14
                }
            ]
        });
        datatable.on('click', 'tr', function () {
            $(this).toggleClass('selected');
        });
        $("#searchBtn").on('click', function () {
            datatable.ajax.reload();
        });
    }
    function del(id) {
        var dialog = $("#dialogDelete");
        dialog.modal("show");
        dialog.find("#okDel").unbind("click");
        dialog.find("#okDel").bind("click", function (event) {
            var btn = $(this);
            btn.button("loading");
            $.post("${base}/private/business/bus_orders/delete/" + id, {}, function (data) {
                if (data.code == 0) {
                    datatable.ajax.reload(null,false);
                } else {
                    Toast.error(data.msg);
                }
                //重置按钮状态，关闭提示框
                btn.button("reset");
                dialog.modal("hide");
            }, "json");
        });
    }
    function delCheck() {
        var chks = datatable.rows('.selected').data();
        if (chks.length > 0) {
            var ids = [];
            $.each(datatable.rows('.selected').data(), function (i, n) {
                ids.push(n.id);
            });
            var dialog = $("#dialogDelete");
            dialog.modal("show");
            dialog.find("#okDel").unbind("click");
            dialog.find("#okDel").bind("click", function (event) {
                var btn = $(this);
                btn.button("loading");
                $.post("${base}/private/business/bus_orders/delete", {ids: ids.toString()}, function (data) {
                    if (data.code == 0) {
                        datatable.ajax.reload(null,false);
                    } else {
                        Toast.error(data.msg);
                    }
                    btn.button("reset");
                    dialog.modal("hide");
                }, "json");
            });
        } else {
            Toast.warning("请先选择要删除的busOrder！");
        }
    }
    $(function () {
        initDatatable();
    });
</script>

<%}%>

@enilu

package cn.wizzer.modules.back.business.models;

import cn.wizzer.common.base.Model;
import org.nutz.dao.entity.annotation.*;

import java.io.Serializable;

/**
 * 描述：
 * 作者：啊平
 * 版本：1.0
 * 时间：2016/8/3 0003
 */
@Table("bus_order")
public class busOrder extends Model implements Serializable {
    private static final long serialVersionUID = 1L;

    @Name
    @Column
    @Prev(els = {@EL("uuid()")})
    private String id;

    @Column
    @Comment("商品主图")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String goodsPicMain;
    @Column
    @Comment("营销单号")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String marketingNum;
    @Column
    @Comment("商品名称")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String goodsName;
    @Column
    @Comment("商品Id")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String goodsId;
    @Column
    @Comment("商品链接")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String goodsUrl;
    @Column
    @Comment("优惠券链接")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String couponUrl;
    @Column
    @Comment("渠道")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String channel;
    @Column
    @Comment("业务员")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String salesman;
    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus;

    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus_1;

    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus_2;

    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus_3;

    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus_4;

    @Column
    @Comment("订单状态")
    @ColDefine(type = ColType.VARCHAR, width = 100)
    private String busOrderStatus_5;

    public String getBusOrderStatus_3() {
        return busOrderStatus_3;
    }

    public void setBusOrderStatus_3(String busOrderStatus_3) {
        this.busOrderStatus_3 = busOrderStatus_3;
    }

    public String getBusOrderStatus_4() {
        return busOrderStatus_4;
    }

    public void setBusOrderStatus_4(String busOrderStatus_4) {
        this.busOrderStatus_4 = busOrderStatus_4;
    }

    public String getBusOrderStatus_5() {
        return busOrderStatus_5;
    }

    public void setBusOrderStatus_5(String busOrderStatus_5) {
        this.busOrderStatus_5 = busOrderStatus_5;
    }

    public String getBusOrderStatus_2() {
        return busOrderStatus_2;
    }

    public void setBusOrderStatus_2(String busOrderStatus_2) {
        this.busOrderStatus_2 = busOrderStatus_2;
    }

    public String getBusOrderStatus_1() {
        return busOrderStatus_1;
    }

    public void setBusOrderStatus_1(String busOrderStatus_1) {
        this.busOrderStatus_1 = busOrderStatus_1;
    }

//    public String getBusOrderStatus_2() {
//        return busOrderStatus_2;
//    }
//
//    public void setBusOrderStatus_2(String busOrderStatus_2) {
//        this.busOrderStatus_2 = busOrderStatus_2;
//    }
//
//    public String getBusOrderStatus_3() {
//        return busOrderStatus_3;
//    }
//
//    public void setBusOrderStatus_3(String busOrderStatus_3) {
//        this.busOrderStatus_3 = busOrderStatus_3;
//    }
//
//    public String getBusOrderStatus_4() {
//        return busOrderStatus_4;
//    }
//
//    public void setBusOrderStatus_4(String busOrderStatus_4) {
//        this.busOrderStatus_4 = busOrderStatus_4;
//    }
//
//    public String getBusOrderStatus_5() {
//        return busOrderStatus_5;
//    }
//
//    public void setBusOrderStatus_5(String busOrderStatus_5) {
//        this.busOrderStatus_5 = busOrderStatus_5;
//    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getGoodsPicMain() {
        return goodsPicMain;
    }

    public void setGoodsPicMain(String goodsPicMain) {
        this.goodsPicMain = goodsPicMain;
    }

    public String getMarketingNum() {
        return marketingNum;
    }

    public void setMarketingNum(String marketingNum) {
        this.marketingNum = marketingNum;
    }

    public String getGoodsName() {
        return goodsName;
    }

    public void setGoodsName(String goodsName) {
        this.goodsName = goodsName;
    }

    public String getGoodsId() {
        return goodsId;
    }

    public void setGoodsId(String goodsId) {
        this.goodsId = goodsId;
    }

    public String getGoodsUrl() {
        return goodsUrl;
    }

    public void setGoodsUrl(String goodsUrl) {
        this.goodsUrl = goodsUrl;
    }

    public String getCouponUrl() {
        return couponUrl;
    }

    public void setCouponUrl(String couponUrl) {
        this.couponUrl = couponUrl;
    }

    public String getChannel() {
        return channel;
    }

    public void setChannel(String channel) {
        this.channel = channel;
    }

    public String getSalesman() {
        return salesman;
    }

    public void setSalesman(String salesman) {
        this.salesman = salesman;
    }

    public String getBusOrderStatus() {
        return busOrderStatus;
    }

    public void setBusOrderStatus(String busOrderStatus) {
        this.busOrderStatus = busOrderStatus;
    }
}

@enilu 名字一样就不行? 名字不一样好像也不行啊

@enilu 比如我点了这个排序 后台打印的sql是 这个字段是不对的

@enilu 嗯嗯 能随便说下为啥是2

@enilu 那为啥字段多了 才会这样

@enilu 可能你误会我的意思了 order": [[2, "desc"]],这个应该是默认按照哪个字段排序 我描述的是字段多了 不管点哪个字段排序 传到后台都不是对应的字段 比如我点了商品主图 可以后台生成的sql确实按照订单状态排序

@enilu 这个我知道 但是这个不是问题 问题是你明明是按照商品名称排序 sql确是按照其他字段排序

@enilu 你可以用我的实体类生成代码尝试一下

@enilu 不是都以订单状态排序 是都不对应 比如你点图片主图 可能按订单状态 再点其他的是按其他字段排序 但不对应 debug过了 html传进来的值有问题

@enilu 往上拉有页面代码还有实体类

@wendal

<%
layout("/layouts/private.html"){
%>
<section class="content-wrap bg-white">
    <header class="header navbar bg-white shadow">
        <div class="btn-group tool-button">
            <a id="add" class="btn btn-primary navbar-btn" href="${base}/private/business/bus_orders/add" data-pjax><i class="ti-plus"></i> 新建 busOrder</a>
            <button class="btn btn-danger navbar-btn" onclick="delCheck()"><i class="ti-close"></i> 删除选中</button>
        </div>
    </header>
    <div class=panel-body style="padding-top: 50px;">
        <div class="table-responsive no-border">
            <input id="unitid" type="hidden">
            <table class="table table-bordered table-striped mg-t datatable">
                <thead>
                    <tr>
                            <th>商品主图</th>
                            <th>营销单号</th>
                            <th>商品名称</th>
                            <th>商品Id</th>
                            <th>商品链接</th>
                            <th>优惠券链接</th>
                            <th>渠道</th>
                            <th>业务员</th>
                            <th>ffffff</th>
                            <th>eeeee</th>
                            <th>ddddd</th>
                            <th>ccccc</th>
                            <th>bbbbb</th>
                            <th>aaaaaa</th>
                            <th>操作</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</section>
<div id="dialogDelete" class="modal fade bs-modal-sm" tabindex="-2" role="dialog" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                <h4 class="modal-title">删除busOrder</h4>
            </div>
            <div class="modal-body">
                <div class="row">
                    <div class="col-xs-12">
                        busOrder删除后无法恢复。<br/>
                        <br/>确定删除吗？
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">取  消</button>
                <button id="okDel" type="button" class="btn btn-primary" data-loading-text="正在删除...">确  定</button>
            </div>
        </div>
    </div>
</div>
<div id="dialogDetail" class="modal fade bs-modal-sm" tabindex="-3" role="dialog" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
        </div>
    </div>
</div>
<script language="JavaScript">
    var datatable;
    function initDatatable() {
        datatable = $('.datatable').DataTable({
            "dom": '<"toolbar">frtip',
            "searching":false,
            "processing": false,
            "serverSide": true,
            "select": true,
            "ordering": true,
            "language": {
                "url": "${base}/assets/plugins/datatables/cn.json"
            },
            "preDrawCallback": function () {
                sublime.showLoadingbar($(".main-content"));
            },
            "drawCallback": function () {
                sublime.closeLoadingbar($(".main-content"));
            },
            "ajax": {
                "url": "${base}/private/business/bus_orders/data",
                "type": "post",
                "data": function (d) {
                    d.unitid = $('#unitid').val();
                }
            },
//            "order": [[0, "desc"]],
            "columns": [
                    {"data": "goodsPicMain", "bSortable": true},
                    {"data": "marketingNum", "bSortable": true},
                    {"data": "goodsName", "bSortable": true},
                    {"data": "goodsId", "bSortable": true},
                    {"data": "goodsUrl", "bSortable": true},
                    {"data": "couponUrl", "bSortable": true},
                    {"data": "channel", "bSortable": true},
                    {"data": "salesman", "bSortable": true},
                    {"data": "ffffff", "bSortable": true},
                    {"data": "eeeee", "bSortable": true},
                    {"data": "ddddd", "bSortable": true},
                    {"data": "ccccc", "bSortable": true},
                    {"data": "bbbbb", "bSortable": true},
                    {"data": "aaaaaa", "bSortable": true},
            ],
            "columnDefs": [
                {
                    "render": function (data, type, row) {
                        return '<div class="btn-group"><button type="button" class="btn btn-default btn-xs dropdown-toggle" data-toggle="dropdown">' +
                                ' <i class="ti-settings"></i> <span class="ti-angle-down"></span></button><ul class="dropdown-menu" role="menu">' +
                                '<li><a href="${base}/private/business/bus_orders/detail/' + row.id + '" data-toggle="modal" data-target="#dialogDetail">查看信息</a></li>' +
                                '<li><a href="${base}/private/business/bus_orders/edit/' + row.id + '" data-pjax>修改信息</a></li>' +
                                '<li class="divider"></li>' +
                                '<li><a href="javascript:;" onclick="del(\'' + row.id + '\')">删除</a></li>' +
                                '</ul></div>';
                    },
                    "targets": 14
                }
            ]
        });
        datatable.on('click', 'tr', function () {
            $(this).toggleClass('selected');
        });
        $("#searchBtn").on('click', function () {
            datatable.ajax.reload();
        });
    }
    function del(id) {
        var dialog = $("#dialogDelete");
        dialog.modal("show");
        dialog.find("#okDel").unbind("click");
        dialog.find("#okDel").bind("click", function (event) {
            var btn = $(this);
            btn.button("loading");
            $.post("${base}/private/business/bus_orders/delete/" + id, {}, function (data) {
                if (data.code == 0) {
                    datatable.ajax.reload(null,false);
                } else {
                    Toast.error(data.msg);
                }
                //重置按钮状态，关闭提示框
                btn.button("reset");
                dialog.modal("hide");
            }, "json");
        });
    }
    function delCheck() {
        var chks = datatable.rows('.selected').data();
        if (chks.length > 0) {
            var ids = [];
            $.each(datatable.rows('.selected').data(), function (i, n) {
                ids.push(n.id);
            });
            var dialog = $("#dialogDelete");
            dialog.modal("show");
            dialog.find("#okDel").unbind("click");
            dialog.find("#okDel").bind("click", function (event) {
                var btn = $(this);
                btn.button("loading");
                $.post("${base}/private/business/bus_orders/delete", {ids: ids.toString()}, function (data) {
                    if (data.code == 0) {
                        datatable.ajax.reload(null,false);
                    } else {
                        Toast.error(data.msg);
                    }
                    btn.button("reset");
                    dialog.modal("hide");
                }, "json");
            });
        } else {
            Toast.warning("请先选择要删除的busOrder！");
        }
    }
    $(function () {
        initDatatable();
    });
</script>

<%}%>

@wendal 要字段多才会出现这种情况