.net+easyui系列--datagrid

2019-11-14 14:28:37

字體：大中小

供稿：網(wǎng)友

加載CSS

<link href="../../Public/easyui/SiteEasy.css" rel="stylesheet" type="text/css" /><link href="../../Public/easyui/default/easyui.css" rel="stylesheet" type="text/css" />

加載JS

<script src="../../Public/easyui/jquery-1.6.min.js" type="text/javascript"></script><script src="../../Public/easyui/jquery.easyui.min.js" type="text/Javascript"></script><script src="../../Public/easyui/easyui-lang-zh_CN.js" type="text/javascript"></script><script src="/Themes/Scripts/DatePicker/WdatePicker.js" type="text/javascript"></script>

JS加載顯示的數(shù)據(jù)

 $('#Grid').datagrid({                width: 'auto',                height: document.documentElement.offsetHeight - 60,                nowrap: true,                striped: true,                collapsible: true,                url: 'ShenHe_List.aspx',                queryParams: { key: escape($('#txtKey').val()), type: 'GetList', YLBXID: $("select[name$=fm_ylbxmc]").val(), BXZCBH: $("select[name$=fm_bxzcxx]").val() },                sortName: 'YLBXID',                sortOrder: 'desc',                remoteSort: false,                pageList: [20, 40, 80, 160],                columns: [[                 { field: 'ZLZMBH', title: '診療證書編號', width: 80, sortable: true, align: 'center' },                 { field: 'ZMLX', title: '證明類型', width: 80, sortable: true, align: 'center', formatter: function (value) {                     switch (value) {                         case "01":                             return "診斷證明";                             break;                         case "02":                             return "病假證明";                             break;                         case "03":                             return "護理證明";                             break;                         case "04":                             return "費用證明";                             break;                         case "05":                             return "返校證明";                             break;                     }                 }                 },                 { field: 'JLLY', title: '記錄來源', width: 60, sortable: true, align: 'center', formatter: function (value) {                     switch (value) {                         case "00":                             return "門診";                             break;                         case "01":                             return "急診";                             break;                         case "10":                             return "住院";                             break;                     }                 }                 },                 { field: 'BRXM', title: '病人姓名', width: 70, sortable: true, align: 'center' },                 { field: 'SFZHM', title: '身份證號', width: 150, sortable: true, align: 'center' },                 { field: 'BRXB', title: '性別', width: 50, sortable: true, align: 'center' },                 { field: 'BRNL', title: '病人年齡', width: 70, sortable: true, align: 'center' },                 { field: 'RYSJ', title: '就診時間', width: 110, sortable: true, align: 'center' },                 { field: 'CYSJ', title: '離診時間', width: 110, sortable: true, align: 'center' },                 { field: 'LCZD', title: '臨床診斷', width: 150, sortable: true, align: 'center' },                 { field: 'CLJY', title: '處理意見', width: 150, sortable: true, align: 'center' },                 { field: 'KSDM', title: '科室代碼', width: 70, sortable: true, align: 'center' },                 { field: 'KSMC', title: '科室名稱', width: 70, sortable: true, align: 'center' },                 { field: 'YSDM', title: '醫(yī)生代碼', width: 70, sortable: true, align: 'center' },                 { field: 'YSXM', title: '醫(yī)生姓名', width: 70, sortable: true, align: 'center' },                 { field: 'BJTS', title: '病假天數(shù)', width: 60, sortable: true, align: 'center' },                 { field: 'KDSJ', title: '開證明時間', width: 110, sortable: true, align: 'center' },                 { field: 'DWDZ', title: '單位地址', width: 150, sortable: true, align: 'center' },                 { field: 'SHJG', title: '審核結(jié)果', width: 60, sortable: true, align: 'center', formatter: function (value) {                     switch (value) {                         case "0":                             return "未審核";                             break;                         case "1":                             return "合格同意";                             break;                         case "9":                             return "不合格";                             break;                     }                 }                 }             ]],                pagination: true,                rownumbers: true,                singleSelect: true,                onDblClickRow: function () {                    update();                },                onLoadSuccess: function (data) {                    var bodyTds = $(".datagrid-body table tr");                    bodyTds.each(function () {                        $("td:eq(2) div", this).css("text-align", "left");                        $("td:eq(3) div", this).css("text-align", "left");                    })                }            }).datagrid('getPager').pagination({                showPageList: false,                showRefresh: false            });

URL 是調(diào)用數(shù)據(jù)的路徑

queryParams 是傳遞的參數(shù)

sortName 排序字段

columns：顯示的字段數(shù)據(jù)

{ field: 'JLLY', title: '記錄來源', width: 60, sortable: true, align: 'center', formatter: function (value) {                     switch (value) {                         case "00":                             return "門診";                             break;                         case "01":                             return "急診";                             break;                         case "10":                             return "住院";                             break;                     }                 } }

以上代碼

formatter: function (value){}格式是替換數(shù)據(jù)

onDblClickRow 雙擊的事件
onLoadSuccess 加載完成后的時間

加載datagrid

<td align="left" style="height: 100%;"><table id="Grid"></table></td>

后臺方法

PRivate void GetList(){ string sql = string.Format("SELECT distinct * FROM zm_zlzm ");DataTable dt = DbHelperOra.QueryTable(sql);string strWhere = "";DataSet ds = GetList(int.Parse(Request["rows"]), int.Parse(Request["page"]), strWhere);//把DataTable轉(zhuǎn)化成jsonstring josn = JSONHelper.JSONDataTable(ds.Tables[0], Count(strWhere).ToString());Response.Clear();Response.Write(josn);Response.End();}

后臺返回的JASON數(shù)據(jù):

{ "total":11 ,"rows":[ { "ZLZMBH":"Z2","ZLZMDM":"2","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"1","BJTS":"100","ZMLX":"01","JBDM":"","JBMC":"","RN":"1"}, { "ZLZMBH":"B2","ZLZMDM":"2","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"1","BJTS":"100","ZMLX":"02","JBDM":"","JBMC":"","RN":"2"}, { "ZLZMBH":"Z4","ZLZMDM":"4","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"1","BJTS":"","ZMLX":"01","JBDM":"","JBMC":"","RN":"3"}, { "ZLZMBH":"","ZLZMDM":"","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"","BJTS":"","ZMLX":"01","JBDM":"","JBMC":"","RN":"4"}, { "ZLZMBH":"F00000001","ZLZMDM":"00000001","JLLY":"00","SFZHM":"3307811988","BRXM":"張三","BRXB":"男","BRNL":"14歲","DWDZ":"杭州市","RYSJ":"2015/2/10 0:00:00","CYSJ":"2015/2/10 0:00:00","LCZD":"臨床診斷000","CLJY":"無處理意見","KSDM":"0001","KSMC":"兒科","YSDM":"8292","YSXM":"李四","KDSJ":"2015/2/10 0:00:00","SHDM":"51","SHRXM":"胡謙","SHSJ":"0001/1/1 0:00:00","SHJG":"1","SHRDM":"123","ZC":"1","BJTS":"3","ZMLX":"05","JBDM":"","JBMC":"","RN":"5"}, { "ZLZMBH":"F2","ZLZMDM":"2","JLLY":"00","SFZHM":"3307811988","BRXM":"張三","BRXB":"男","BRNL":"14歲","DWDZ":"杭州市","RYSJ":"2015/2/10 0:00:00","CYSJ":"2015/2/10 0:00:00","LCZD":"","CLJY":"","KSDM":"0001","KSMC":"兒科","YSDM":"8292","YSXM":"李四","KDSJ":"2015/2/10 0:00:00","SHDM":"","SHRXM":"","SHSJ":"0001/1/1 0:00:00","SHJG":"","SHRDM":"","ZC":"1","BJTS":"3","ZMLX":"05","JBDM":"","JBMC":"","RN":"6"}, { "ZLZMBH":"Z0","ZLZMDM":"0","JLLY":"00","SFZHM":"3307811988","BRXM":"張三","BRXB":"男","BRNL":"14歲","DWDZ":"杭州市","RYSJ":"2015/2/10 0:00:00","CYSJ":"2015/2/10 0:00:00","LCZD":"","CLJY":"","KSDM":"0001","KSMC":"兒科","YSDM":"8292","YSXM":"李四","KDSJ":"2015/2/10 0:00:00","SHDM":"","SHRXM":"","SHSJ":"0001/1/1 0:00:00","SHJG":"","SHRDM":"","ZC":"1","BJTS":"3","ZMLX":"01","JBDM":"","JBMC":"","RN":"7"}, { "ZLZMBH":"Z1","ZLZMDM":"1","JLLY":"00","SFZHM":"3307811988","BRXM":"張三","BRXB":"男","BRNL":"14歲","DWDZ":"杭州市","RYSJ":"2015/2/10 0:00:00","CYSJ":"2015/2/10 0:00:00","LCZD":"","CLJY":"","KSDM":"0001","KSMC":"兒科","YSDM":"8292","YSXM":"李四","KDSJ":"2015/2/10 0:00:00","SHDM":"","SHRXM":"","SHSJ":"0001/1/1 0:00:00","SHJG":"","SHRDM":"","ZC":"1","BJTS":"3","ZMLX":"01","JBDM":"","JBMC":"","RN":"8"}, { "ZLZMBH":"Y00000001","ZLZMDM":"00000001","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"2","BJTS":"","ZMLX":"04","JBDM":"","JBMC":"","RN":"9"}, { "ZLZMBH":"Z3","ZLZMDM":"3","JLLY":"00","SFZHM":"","BRXM":"","BRXB":"男","BRNL":"","DWDZ":"","RYSJ":"","CYSJ":"","LCZD":"","CLJY":"","KSDM":"","KSMC":"","YSDM":"","YSXM":"","KDSJ":"","SHDM":"","SHRXM":"","SHSJ":"","SHJG":"0","SHRDM":"","ZC":"1","BJTS":"","ZMLX":"01","JBDM":"","JBMC":"","RN":"10"}, { "ZLZMBH":"B00000001","ZLZMDM":"00000001","JLLY":"01","SFZHM":"2342342782","BRXM":"李時珍","BRXB":"男","BRNL":"78歲","DWDZ":"杭州是","RYSJ":"2016/1/5 0:00:00","CYSJ":"2016/1/7 0:00:00","LCZD":"牙疼","CLJY":"拔牙","KSDM":"0192","KSMC":"口腔科","YSDM":"922","YSXM":"大洋","KDSJ":"2016/1/20 0:00:00","SHDM":"67","SHRXM":"","SHSJ":"","SHJG":"9","SHRDM":"","ZC":"","BJTS":"3","ZMLX":"02","JBDM":"","JBMC":"","RN":"11"} ]}