首页 > 代码库 > Bootstrap grid实例(Asp.net)

Bootstrap grid实例(Asp.net)

 <link href=http://www.mamicode.com/"../../js/jqGrid/css/ui.jqgrid.css" rel="stylesheet" type="text/css" /> <link href=http://www.mamicode.com/"../../css/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />    <script src=http://www.mamicode.com/"../../js/jquery.min.js" type="text/javascript"></script>    <script src=http://www.mamicode.com/"../../js/jqGrid/js/i18n/grid.locale-cn.js" type="text/javascript"></script>    <script src=http://www.mamicode.com/"../../js/jqGrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>    <script src=http://www.mamicode.com/"../../js/artDialog/artDialog.js" type="text/javascript"></script>    <script src=http://www.mamicode.com/"../../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="http://www.mamicode.com/showdetail.aspx?id= + cellvalue + " class="yes"><i class="icon-bookmark"></i>房间管理</a>&nbsp;<a style="color: #ff0000;" href="http://www.mamicode.com/editRoomInfo.aspx?id= + cellvalue + " data-name=" + rowObject[2] + " class="yes"><i class="icon-edit"></i>编辑</a>&nbsp;<a style="color: #ff0000;" href="javascript:;" class="rowDel" data-id=" + cellvalue + " data-name=" + rowObject[2] + " 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: 195 },           { name: rnum, index: R_Num, align: "left", width: 80 },           { name: rstatus, index: R_Enable, align: "center", width: 50 },           { name: Published, index: R_Published, align: "center", width: 50 },           { name: uname, index: UName, align: "center", width: 60 },           { name: order, index: R_DisplayOrder, align: "center", width: 30 },           { name: ctime, index: ctime, align: "center", width: 60 },           { name: id, index: id, align: "center", width: 160, formatter: operFmatter, sortable: false }       ],                rowNum: 20,                rowList: [10, 20, 30, 40, 50],                pager: #divNav,                mtype: post,                sortname: ctime,                sortorder: desc,                rowNum: 20,                height: 400,                width: 1015,                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 == 0) {                    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 == 0) {                                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 == 1 ? 隐藏 : 显示) +  [ + _rname + ] 这条数据吗?, function () {                    Operate(_rid, _rval == 1 ? 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"] == "0")                {                    return 1;                }                return Convert.ToInt32(Request["page"]);            }            catch            {                return 1;            }        }    }    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(0);            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 = 3;        mt.RecorderCount = 0;        int TotalPage = 1;        int TotalRecord = 0;        DataTable dt = SystemBLL.Pager.GetRecord(mt, ref TotalPage, ref TotalRecord);        if (dt == null || dt.Rows.Count == 0)        {            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") == 0 ? "实验室" : item.Field<int>("R_Type") == 1 ? "教室" : item.Field<int>("R_Type") == 2 ? "研讨室/会议室" :  "小剧场"),                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;    }}
//效果: