javascript - 如何在 ASp.net 中使用 Java 脚本从数据库读取日期时间

Question

我正在尝试设置结束时间(已过期/倒计时)

       <p id="demo"></p>

<script>
    // Set the date we're counting down to
    var countDownDate = new Date("Jan 5, 2018 15:37:25").getTime();

    // Update the count down every 1 second
    var x = setInterval(function () {

        // Get todays date and time
        var now = new Date().getTime();

        // Find the distance between now an the count down date
        var distance = countDownDate - now;

        // Time calculations for days, hours, minutes and seconds
        var days = Math.floor(distance / (1000 * 60 * 60 * 24));
        var hours = Math.floor((distance % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));
        var minutes = Math.floor((distance % (1000 * 60 * 60)) / (1000 * 60));
        var seconds = Math.floor((distance % (1000 * 60)) / 1000);

        // Output the result in an element with id="demo"
        document.getElementById("demo").innerHTML = days + "d " + hours + "h "
        + minutes + "m " + seconds + "s ";

        // If the count down is over, write some text 
        if (distance < 0) {
            clearInterval(x);
            document.getElementById("demo").innerHTML = "EXPIRED";
        }
    }, 1000);
</script>

此代码有效，但日期是静态的我需要改变var countDownDate = new Date("Jan 5, 2018 15:37:25").getTime();从数据库中获取值怎么办？

in asp.net and entitiyframework

Answer 1

您可以创建一个 ApiController，使用从数据库获取数据并返回数据的方法，然后使用 ajax 请求在 JavaScript 中获取数据。这里有一个例子:

public class YourApiController : ApiController
{

    [HttpGet]
    [Route("api/getDateFromServer")]
    public DateTime GetDateFromServer()
    {
        //TODO retrieve data from where you want, by now we will return DateTime.Now
        return DateTime.Now;
    }
}

然后，在您的 JavaScript 中添加以下内容:

    $.ajax({
        type: 'GET',
        context: this, 
        url: '/api/getDateFromServer',
    }).done(function (data) {
       //Here you have your data from server in your javascript
       countDownDate = data;
    });