/// <summary> /// 通过ID获取作品文件 /// </summary> /// <param name="fileID">文件ID</param> /// <returns></returns> public WorksFile GetWorksFileByID(string fileID) { long lfileID = long.Parse(fileID); WorksFile file = db.WorksFile.FirstOrDefault(w => w.WorksFileID == lfileID); return(file); }
/// <summary> /// 添加作品文件 /// </summary> /// <param name="worksFile"></param> /// <returns></returns> public long Create(WorksFile worksFile) { db.WorksFile.Add(worksFile); db.SaveChanges(); long fileID = worksFile.WorksFileID; return(fileID); }
/// <summary> /// 更新作品文件 /// </summary> /// <param name="worksFile"></param> public void Update(WorksFile worksFile) { WorksFile file1 = db.WorksFile.FirstOrDefault(w => w.WorksFileID == worksFile.WorksFileID); file1.FileName = worksFile.FileName; file1.FilePath = worksFile.FilePath; file1.FileSize = worksFile.FileSize; db.SaveChanges(); }
/// <summary> /// 多媒体文件(包括音视频)的显示:播放窗口 /// </summary> /// <param name="serviceWorks">数据服务层接口</param> /// <param name="worksId">作品ID</param> /// <param name="typeId"></param> /// <returns></returns> private void ShowMedias(IServiceWorks serviceWorks, long worksId, int typeId) { StringBuilder htmlContent = new StringBuilder(); List <VAWcfService.WorksFile> mediaFiles = serviceWorks.GetWorksFile(worksId.ToString(), typeId.ToString()); if (mediaFiles.Count > 0) { VAWcfService.WorksFile mediaFile = mediaFiles.OrderByDescending(wf => wf.WorksFileID).FirstOrDefault();//因为可能有多个文档重复上传,所以此处先处理成该作品最后一次上传的文档为作品文档。 VAWcfService.Works works = serviceWorks.GetWorksSubmitById(worksId.ToString()); string periodId = works.PeriodID.ToString(); Periods period = serviceWorks.GetPeriodsById(periodId).FirstOrDefault(); string siteUrl = "http://va.neu.edu.cn"; if (period != null) { string courseId = period.CourseID.ToString(); Course course = serviceWorks.GetCourseById(courseId).FirstOrDefault(); if (course != null) { siteUrl += course.Url; } } if (mediaFile != null) { MediaDiv.Visible = true; //string mediaHtml = "<iframe type='text/html' width='640' height='360'"; //mediaHtml += "src='"+ siteUrl + "/_layouts/15/videoembedplayer.aspx?site=" + mediaFile.FilePath + "title=1'></iframe>"; htmlContent.AppendLine("<div class='plist'>"); htmlContent.AppendLine("<a href='" + siteUrl + mediaFile.FilePath + "' name='" + mediaFile.FileName + "'"); htmlContent.AppendLine("<img class='listpic' src='images/start.jpg' alt='" + mediaFile.FileName + "' width='200' height='150'>"); string txtExtend = mediaFile.FileName.Substring(mediaFile.FileName.LastIndexOf(".", StringComparison.Ordinal) + 1).ToLower(); if (txtExtend == "mp3") { htmlContent.AppendLine("<span class='v_bq_hong'>讲解音频</span><span class='v_bg'></span>"); } else { htmlContent.AppendLine("<span class='v_bq_lan'>讲解视频</span><span class='v_bg'></span>"); } htmlContent.AppendLine("<span class='v_bq_vico'></span></a>"); htmlContent.AppendLine("<h2><a href='" + siteUrl + mediaFile.FilePath + "' name='" + mediaFile.FileName + "'>" + mediaFile.FileName + "</a></h2><p>" + mediaFile.Created + "</p>"); htmlContent.AppendLine("</div>"); } //} MediaList.InnerHtml = htmlContent.ToString(); } else { MediaDiv.Visible = false; } //return htmlContent; }