.net mvc 与easyui datagrid 数据交互

最新推荐文章于 2020-02-27 14:45:49 发布

fantasykakaxi

最新推荐文章于 2020-02-27 14:45:49 发布

阅读量623

点赞数

本文链接：https://blog.csdn.net/fantasykakaxi/article/details/102779981

版权

controller层后台代码

  public JsonResult GetList()
        {

            CTGMESDBEntities zmde = new CTGMESDBEntities();

            List<tbZJS> list = zmde.Database.SqlQuery<tbZJS>("exec pro_KB_ZJSEntryNo").ToList();
            var json = new
            {
                total = list.Count,
                rows = (from r in list
                        select new tbZJS()
                        {
                            EntryNo = r.EntryNo,
                            MATNR = r.MATNR,
                            CPXNT = r.CPXNT,
                            QGRAD = r.QGRAD,
                            PlantAmount = r.PlantAmount,
                            NTGEW = r.NTGEW,
                            YNTGEW = r.YNTGEW,
                            Status = r.Status,

                        }).ToArray()
            };
            return Json(json, JsonRequestBehavior.AllowGet);


        }

cshtml前台代码

<script type="text/javascript">
    $(function () {
        $('#tbZJS').datagrid({
            title: '当天工单产出情况',
            url: '../../ZJS/GetList',
            method: 'get', //默认是post,不允许对静态文件访问
            width: '700',
            dataType: "json",
            fitColumns: true,
            singleSelect: true,
            rownumbers: true, //是否加行号
            pagination: false, //是否显式分页
            pageSize: 20, //页容量，必须和pageList对应起来，否则会报错
            pageNumber: 1, //默认显示第几页
            columns: [[
                { field: 'EntryNo', title: '工单号' },
                { field: 'PlantAmount', title: '计划量' },
                { field: 'GEW', title: '当日累计产出' },
                { field: 'TGEW', title: '累计产出' },
                { field: 'Status', title: '状态' }
            ]],
            rowStyler: function (index, row) {
                if (row.Status == '已超产') {
                    return 'background-color:red;';
                }
            },
        });
    });
</script>