.net向layui表格传递model数据

最新推荐文章于 2023-09-25 08:00:38 发布

端阳月七

最新推荐文章于 2023-09-25 08:00:38 发布

阅读量508

点赞数 1

分类专栏： C# 之 MVC5 学习文章标签： layui c# asp.net

本文链接：https://blog.csdn.net/h6h26169i10l34fsgrh/article/details/125194131

版权

C# 之 MVC5 学习专栏收录该内容

14 篇文章 2 订阅

订阅专栏

前端界面

<head>
    <title>yy影视</title>
    <link rel="stylesheet" href="~/Content/LayUI/css/layui.css" media="all" />
    <script src="~/Scripts/jquery-3.4.1.min.js"></script>
    <script type="text/javascript" src="~/Content/LayUI/layui.js"></script>
</head>

<body>

    <div>
        <table class="layui-hide" id="spray2" lay-filter="test"></table>
    </div>
<script>

        layui.use('table', function () {
            var table = layui.table;
            table.render({
                elem: '#spray2'
                , method: "get"
                , url: '/Home/YoungToJson1/'
                , toolbar: '#toolbarDemo'
                , defaultToolbar: ['filter', 'exports', 'print', { 
                    title: '提示'
                    , layEvent: 'LAYTABLE_TIPS'
                    , icon: 'layui-icon-tips'
                }]
                , title: '杨洋影视表'
                , page: true
                , limits: [30, 50, 100, 200, 500]
                , limit: 30
                , even: true
                , size: 'lg'  
                , skin: 'row'
                , cols: [[
                    { type: 'checkbox', fixed: 'left' }
                    , { field: 'Time', title: '上映时间', templet: '#formatDate' }
                    , { field: 'Name', title: '剧名' }
                    , { field: 'Type', title: '影视类型' }
                    , { field: 'Area', title: '进组年龄' }
                    , { field: 'Role', title: '饰演角色', hide: true }
                   }
                ]]
                }
});
<script type="text/html" id="formatDate">
        {{formatDate(d.Date)}}
    </script>
    <script>
        function formatDate(str) {
            var now = new Date(parseInt(str.replace("/Date(", "").replace(")/", ""), 10));
            var year = now.getFullYear();
            var month = now.getMonth() + 1;
            var date = now.getDate();
            return year + "/" + month + "/" + date;
        }
    </script>

后端将model枚举类型的数据转化成layui table需要的json格式

先为layui table需要的json格式创建一个model

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace spray1.Models
{
    public class LayuiJsonL
    {
        public int code { get; set; }
        public string msg { get; set; }
        public int count { get; set; }
        public List<YoungModel> data { get; set; }
    }
}

后端控制器来转化

public ActionResult LogicsToJson1()
        {
            db.Configuration.ProxyCreationEnabled = false;
            int page = Convert.ToInt32(Request["page"]);
            int limit = Convert.ToInt32(Request["limit"]);
            LayuiJsonL lj = new LayuiJsonL();
            lj.code = 0;
            lj.msg = "";
            lj.count = db.Logics.Count();
            //lj.data = db.Logics.ToList();
            lj.data = db.Logics.ToList().Skip((page - 1) * limit).Take(limit).ToList();
            //return Json(lj, JsonRequestBehavior.AllowGet);
            return new ContentResult
            {
                Content = new JavaScriptSerializer { MaxJsonLength = Int32.MaxValue }.Serialize(lj),
                ContentType = "application/json"
            };