如何更新数据库中新数据的视图

How to Update View For new Data from Database

本文关键字:数据 视图 新数据 数据库 何更新 更新      更新时间:2023-09-26
<script type="text/javascript">
    $(document).ready(function () {
    function getPlanetFeeds() {
       $("#planetFeedsDiv").load('/PlanetFeed/GetPlanetFeeds', function (data) {
       });
    var refreshPartial = setInterval(function () { getPlanetFeeds() }, 3000);
    function myStopFunction() {
       clearInterval(refreshPartial);
    }
 <div id="planetFeedsDiv">
 </div>

我正在尝试在数据库中更新时从数据库中获取提要,但问题是,如果我上传视频,它会刷新并且无法连续观看视频如果我删除了时间间隔的此功能或增加时间间隔

var refreshPartial = setInterval(function () { getPlanetFeeds() }, 3000);
function myStopFunction() {
   clearInterval(refreshPartial);
}

比我无法定期获得更新的提要

我从控制器获取行星馈送如下

public ActionResult GetPlanetFeeds()
{
    var planetfeedsOrder = from a in db.PlanetFeeds
                            join c in db.Graphs
                            on a.PlanetFeedItemGraphId  equals c.GraphID
                            join u in db.UserInfos
                            on c.ItemUserID equals u.UserID
                            orderby a.PostDate descending
                           select new UserInfoViewModel
                           {
                               FirstName = u.FirstName,
                               LastName = u.LastName,
                               UserID = u.UserID,
                               AvatarURL = u.AvatarURL,
                               GraphItemDescription = c.GraphItemDescription,
                               GraphItemURL = c.GraphItemURL,
                               GraphID = c.GraphID,
                               ItemType = c.ItemType,
                               ItemUserID = c.ItemUserID,
                               GraphItemTitle = c.GraphItemTitle
                           } ;
    return PartialView("_PlanetFeeds", planetfeedsOrder.ToList());
}

通过在数据库中搜索来检查旧计数和更新值,并在 NewDataCount 大于旧数据时调用 getPartial 方法