• grid实例(Asp.net)


     <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;  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[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",  '195' },
               { name: 'rnum', index: 'R_Num', align: "left",  '80' },
               { name: 'rstatus', index: 'R_Enable', align: "center",  '50' },
               { name: 'Published', index: 'R_Published', align: "center",  '50' },
               { name: 'uname', index: 'UName', align: "center",  '60' },
               { name: 'order', index: 'R_DisplayOrder', align: "center",  '30' },
               { name: 'ctime', index: 'ctime', align: "center",  '60' },
               { name: 'id', index: 'id', align: "center",  '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',
                     '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 _XXXXXRoomMgr_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;
        }
    
    }
    //效果:

  • 相关阅读:
    Sql中CHARINDEX用法
    Ubuntu 18.04 配置ibus中文拼音输入法(超简单)
    win10使用教程(电脑windows系统基础使用教程快速入门手册图文详解)
    angularjs中$scope是什么意思
    angularjs中$scope是什么意思?
    005列表标签
    Evanyou Blog 彩带
    Evanyou Blog 彩带
    Evanyou Blog 彩带
    Evanyou Blog 彩带
  • 原文地址:https://www.cnblogs.com/vanteking/p/3849197.html
Copyright © 2020-2023  润新知