<link href="../../js/jqGrid/css/ui.jqgrid.css" rel="stylesheet" type="text/css" />

 <link href="../../css/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />

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

    <script src="../../js/jqGrid/js/i18n/grid.locale-cn.js" type="text/javascript"></script>

    <script src="../../js/jqGrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>

    <script src="../../js/artDialog/artDialog.js" type="text/javascript"></script>

    <script src="../../js/artDialog/plugins/iframeTools.js" type="text/javascript"></script>

     <div class="row" id="cnt" style="margin: 0 auto; width: 1020px;">

            <div>

                <table id="tbView">

                </table>

                <div id="divNav">

                </div>

                <div style="height: 10px; display: block;">

                    &nbsp;

                </div>

            </div>

        </div>

<script type="text/javascript">

        //格式化操作

        function operFmatter(cellvalue, options, rowObject) {

            return '<a href="showdetail.aspx?id=' + cellvalue + '" class="yes"><i class="icon-bookmark"></i>房间管理</a>&nbsp;<a style="color: #ff0000;" href="editRoomInfo.aspx?id=' + cellvalue + '" data-name="' + rowObject[] + '" class="yes"><i class="icon-edit"></i>编辑</a>&nbsp;<a style="color: #ff0000;" href="javascript:;" class="rowDel" data-id="' + cellvalue + '" data-name="' + rowObject[] + '" class="no"><i class="icon-remove-sign"></i>删除</a>';

        }

        $(function () {

            jQuery("#tbView").jqGrid({

                url: 'services.aspx',

                postData: {

                    t: 'getlist'/*,

                    cid: function () { return $('#info_lb').find('option:selected').val(); },

                    zid: function () { return $('#hidCid').val() },

                    mid: function () { return $('#hidMid').val() },

                    key: function () { return $('#txtKey').val(); }*/

                },

                datatype: "json",

                colNames: ['ID', '房间类型', '房间号', '房间状态', '发布状态', '添加人员', '排序', '添加时间', '操作'],

                colModel: [

           { name: 'id', index: 'id', hidden: true },

           { name: 'rtype', index: 'R_Type', align: "left", width: '' },

           { name: 'rnum', index: 'R_Num', align: "left", width: '' },

           { name: 'rstatus', index: 'R_Enable', align: "center", width: '' },

           { name: 'Published', index: 'R_Published', align: "center", width: '' },

           { name: 'uname', index: 'UName', align: "center", width: '' },

           { name: 'order', index: 'R_DisplayOrder', align: "center", width: '' },

           { name: 'ctime', index: 'ctime', align: "center", width: '' },

           { name: 'id', index: 'id', align: "center", width: '', formatter: operFmatter, sortable: false }

       ],

                rowNum: ,

                rowList: [, , , , ],

                pager: '#divNav',

                mtype: 'post',

                sortname: 'ctime',

                sortorder: 'desc',

                rowNum: ,

                height: '',

                width: '',

                multiselect: true,

                viewrecords: true,

                caption: '房间信息列表',

                jsonReader: {

                    root: "rows",

                    page: "currpage",

                    total: "totalpages",

                    records: "totalrecords",

                    repeatitems: false,

                    id: "id"

                }

            });

            jQuery("#tbView").jqGrid('navGrid', "#divNav", { edit: false, add: false, del: false, search: false });

            //删除所选

            $('#btnDel').click(function () {

                var tmpID = jQuery("#tbView").jqGrid('getGridParam', 'selarrrow');

                if (tmpID.length == ) {

                    art.dialog({

                        content: '请选择一条数据!',

                        ok: true

                    });

                    return false;

                }

                var _ids = [];

                for (var i in tmpID) {

                    var ret = jQuery("#tbView").jqGrid('getRowData', tmpID[i]);

                    _ids.push(ret.infoid);

                }

                art.dialog.confirm('确定要删除所选数据吗?删除后不可恢复!', function () {

                    Operate(_ids.join(','), 'delinfo');

                });

            });

            //删除单个

            $(document).delegate('.rowDel', 'click', function () {

                var _id = $(this).attr('data-id');

                var _rname = $(this).attr('data-name');

                art.dialog.confirm('确定要删除这条数据吗?删除后不可恢复!', function () {

                    //  Operate(_id, 'delinfo');

                    $.ajax({

                        type: 'post',

                        data: {

                            t: 'del',

                            id: _id

                        },

                        url: "services.aspx",

                        success: function (resp) {

                            if (resp == ) {

                                art.dialog({

                                    content: '数据删除成功!'

                                });

                                window.location.href = "Default.aspx";

                                return false;

                            }

                        }

                    });

                    //end

                });

            });

            //显示或者隐藏

            $(document).delegate('.rowView', 'click', function () {

                var _rval = $(this).attr('rval');

                var _rid = $(this).attr('rid');

                var _rname = $(this).attr('rname');

                art.dialog.confirm('确定要 ' + (_rval == '' ? '隐藏' : '显示') + ' [' + _rname + '] 这条数据吗?', function () {

                    Operate(_rid, _rval == '' ? 'disinfo' : 'eninfo');

                });

            });

        });

    </script>

services.aspx.cs 页面

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

public partial class _51eweb_sysadmin_XRoomMgr_services : System.Web.UI.Page

{

    //当前页

    public int PageIndex

    {

        get

        {

            try

            {

                if (Request["page"] == null || Request["page"] == "")

                {

                    return ;

                }

                return Convert.ToInt32(Request["page"]);

            }

            catch

            {

                return ;

            }

        }

    }

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected override void OnInit(EventArgs e)

    {

        string t = Request.Form["t"];

        switch (t)

        {

            case "getlist":

                getlist();

                break;

         case "del":

                setDel();

                break;

            default:

                break;

        }

        base.OnInit(e);

    }

    public void setDel()

    {

        int _id = int.Parse(Request["id"]);

        //{

        if (EF.Query.QXRoomInfo.DelByID(_id))

        {

            Response.Write();

            Response.End();

        }

    }

    //房间信息

    private void getlist()

    {

        string _rows = Request["rows"];//pagesize

        string _sidx = Request["sidx"];//排序ID

        string _sord = Request["sord"];//排序

        SystemModel.Pager mt = new SystemModel.Pager();

        mt.PageIndex = PageIndex;

        mt.PageSize = int.Parse(_rows);

        mt.TableName = "XRoomInfo";

        mt.FiledList = "[ID],[R_Type],[R_Name],[R_Num],[R_DisplayOrder],[R_Published],[R_Enable],[UID],[UName],[CTime]";

        mt.PrimaryKey = "ID";

        System.Collections.Generic.List<SystemModel.admin_info> mylist = (System.Collections.Generic.List<SystemModel.admin_info>)HttpContext.Current.Session["adminuser"];

        if (mylist == null) { return; }

        mt.Order = string.Format(" {0} {1},id desc ", CommonLib.StringHelper.SqlSafeString(_sidx, true), CommonLib.StringHelper.SqlSafeString(_sord, true));

        mt.SortType = ;

        mt.RecorderCount = ;

        int TotalPage = ;

        int TotalRecord = ;

        DataTable dt = SystemBLL.Pager.GetRecord(mt, ref TotalPage, ref TotalRecord);

        if (dt == null || dt.Rows.Count == )

        {

            Response.Write("{\"currpage\":\"" + PageIndex + "\",\"totalpages\":0,\"totalrecords\":0,\"rows\":[],\"msg\":\"暂无数据\"}");

            return;

        }

        Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(new

        {

            currpage = PageIndex,

            totalpages = TotalPage,

            totalrecords = TotalRecord,

            rows = ConvertListByDt(dt)

        }));

    }

    //转换房间信息为list object

    private List<object> ConvertListByDt(DataTable dt)

    {

        List<object> _list = new List<object>();

        foreach (var item in dt.AsEnumerable())

        {

            _list.Add(new

            {

                id = item.Field<int>("id"),

                rtype = (item.Field<int>("R_Type") ==  ? "实验室" : item.Field<int>("R_Type") ==  ? "教室" : item.Field<int>("R_Type") ==  ? "研讨室/会议室" :  "小剧场"),

                rnum = item.Field<string>("R_Num"),

                Published = (item.Field<bool>("R_Published") ? "发布" : "未发布"),

                rstatus = (item.Field<bool>("R_Enable") ? "开启" : "关闭"),

                uname = item.Field<string>("UName"),

                order = item.Field<int>("R_DisplayOrder"),

                ctime = item.Field<DateTime>("CTime").ToString("yyyy-MM-dd HH:mm")

            });

        }

        return _list;

    }

}
//效果：