当前位置: 代码迷 >> 综合 >> easyui+asp.net MVC,用table标签显示数据库中的值 2
  详细解决方案

easyui+asp.net MVC,用table标签显示数据库中的值 2

热度:97   发布时间:2023-10-27 01:43:59.0

之前的一篇文章中介绍的是easyui页面获取c#后台代码的数据,也可以用另一种方式来获取:

html:

<table id="pressure"></table>

js:

function loadMessage() {$('#pressure').datagrid({height: 500,url: '/Home/RealtimeData',method: 'POST',idField: 'ElementId',striped: true,fitColumns: true,singleSelect: false,rownumbers: true,pagination: false,nowrap: false,pageSize: 10,pageList: [10, 20, 50, 100, 150, 200],showFooter: true,columns: [[{ field: 'ck', checkbox: true },{ field: 'ElementId', title: '序号',  align: 'left' },{ field: 'Label', title: '标识',  align: 'left' },{ field: 'Meter_Name', title: '名称',  align: 'left' },{ field: 'Station_Un', title: '营销公司',  align: 'left' },{ field: 'MeasureAre', title: '计量区',  align: 'left' },{ field: 'DistrictAr', title: '行政区',  align: 'left' },{ field: 'Explain', title: '监测点类型',  align: 'left' }]],onBeforeLoad: function (param) {},onLoadSuccess: function (data) {if (data) {$.each(data.rows, function (index, item) {if (item.Display == 1) {$('#pressure').datagrid('checkRow', index);}});}},onLoadError: function () {},onClickCell: function (rowIndex, field, value) {}});
}

c#:

public ActionResult RealtimeData(){var workers = from w in db.METERselect w;workers = workers.Where(w => w.Meter_Type == 2 || w.Meter_Type == 4);workers = workers.OrderBy(w => w.ElementId);var result = from worker in workersselect new{worker.ElementId,worker.Label,worker.Meter_Name,worker.Station_Un,worker.MeasureAre,worker.DistrictAr,worker.Explain,worker.Display};var jsonResult = new { total = workers.Count(), rows = result };string str = JsonSerializeHelper.SerializeToJson(jsonResult, "yyyy'-'MM'-'dd' 'HH':'mm':'ss");return Content(str);}

  相关解决方案