javascript - FullCalendar 从数据库填充事件

Question

我正在使用 FullCalendar，特别是 SmartAdmin 附带的那个。我需要从数据库中获取事件并将它们显示在日历上。

这是我需要更改为 Asp.Net C# 服务器端（带有 LINQ 的实体框架）的示例代码：

events: [
{
     title: 'Event Title',
     start: new Date(y, m, 10, 00, 30),
     description: 'Long Description',
     className: ["event", "bg-color-red"],
     icon: 'fa-clock-o'
}

更新：最新的努力包括使用 JSON，试图让 FullCalendar 读取并显示它。

    [System.Web.Services.WebMethod]
    private string LoadEventLog()
    {
        using (DBEntities context = new DBEntities())
        {
            var query = (from el in context.EventLog
                         join et in context.EventTypes on el.eventType_FK equals et.id
                         join usr in context.Users on el.users_FK equals usr.id
                         orderby el.rowCreatedDT descending

                         select new EventLogInfo2()
                         {
                             id = el.id,
                             eventType_FK = el.eventType_FK,
                             eventType = et.eventType,
                             rowCreatedDT = el.rowCreatedDT,
                             message = el.message,
                             userFullName = usr.name + " " + usr.lastName
                         });

            return (new JavaScriptSerializer()).Serialize(query.ToList());
        }
    }

回报：

[{"id":3,"eventType_FK":4,"eventType":"Calendar","rowCreatedDT":"/Date(1544997181613)/","message":"Description Test 3.","userFullName": "系统管理员"},{"id":2,"eventType_FK":1,"eventType":"Information","rowCreatedDT":"/Date(1544994918530)/","message":"描述测试 2。" ,"userFullName":"系统管理员"},{"id":1,"eventType_FK":1,"eventType":"Information","rowCreatedDT":"/Date(1544994006240)/","message":"描述测试 1。","userFullName":"系统管理员"}]

标签： javascriptc#asp.netwebformsfullcalendar