public PageApiResult <VVideolist> GetVideo(PageQuery query) { var result = new PageApiResult <VVideolist>(); try { var count = _videoContext.VVideolist.Count(); var list = _videoContext.VVideolist.AsNoTracking(); if (!string.IsNullOrEmpty(query.Name)) { list = list.Where(x => x.Name.Contains(query.Name)); } if (query.Cid.HasValue) { list = list.Where(x => x.Cid == query.Cid); } if (query.TypeId.HasValue) { list = list.Where(x => x.TypeId == query.TypeId); } list = list.OrderBy(x => x.CreateTime); var lists = list.PageByIndex(query.page, query.limit).ToList(); result.count = count; result.data = lists; } catch (Exception ex) { result.code = "1"; LoggerHelper.ErrorToFile("获取视频列表出现异常,异常原因:" + ex.Message); } return(result); }
/// <summary> /// 添加视频信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result AddVideo(VideoModel model) { Result result = new Result(); try { VVideos videos = new VVideos(); videos.Cid = model.Cid; videos.ImgUrl = model.ImgUrl; videos.TypeId = model.TypeId; videos.Remarks = model.Remarks; videos.Name = model.Name; videos.CreateTime = DateTime.Now; videos.Type = "1"; var res = _videoContext.VVideos.Add(videos); _videoContext.SaveChanges(); if (res != null) { result.code = "0"; result.msg = "新增成功"; } else { result.code = "1"; result.msg = "新增失败"; } return(result); } catch (Exception ex) { LoggerHelper.ErrorToFile("视频新增失败,失败原因:" + ex.Message); result.code = "1"; return(result); } }
/// <summary> /// 修改视频信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result EditVideo(VideoModel model) { Result result = new Result(); try { var video = _videoContext.VVideos.Where(x => x.Id == model.Vid).FirstOrDefault(); if (video == null) { result.code = "1"; result.msg = "视频信息查找失败!"; return(result); } video.Name = model.Name; video.Cid = model.Cid; video.TypeId = model.TypeId; video.ModifyTime = DateTime.Now; video.ImgUrl = model.ImgUrl; video.Remarks = model.Remarks; _videoContext.VVideos.Update(video); _videoContext.SaveChanges(); result.msg = "新增成功"; return(result); } catch (Exception ex) { LoggerHelper.ErrorToFile("视频修改失败,失败原因:" + ex.Message); result.code = "1"; return(result); } }