/// <summary> /// 创建查询语句 /// </summary> /// <param name="qp"></param> /// <param name="Context"></param> /// <returns></returns> public QueryParam CreateQueryParam(QueryParam qp, BasePage Context) { qp.Where.Add(new SearchParam("Status", (Int32)EnumStatus.Published, SearchType.Equal)); qp.Where.Add(new SearchParam("PortalId", Context.PortalId, SearchType.Equal)); qp.Where.Add(new SearchParam("IncludeRoadmap", 0, SearchType.Equal)); //开始时间 qp.Where.Add(new SearchParam("ReleaseDate", Context.ViewSettingT <DateTime>("Roadmap_StartTime", xUserTime.UtcTime().AddDays(-30)), SearchType.GtEqual)); //结束时间 qp.Where.Add(new SearchParam("ReleaseDate", Context.ViewSettingT <DateTime>("Roadmap_EndTime", xUserTime.UtcTime()).AddDays(30), SearchType.LtEqual)); //未到开始时间的不显示数据 qp.Where.Add(new SearchParam("StartTime", xUserTime.UtcTime(), SearchType.LtEqual)); return(qp); }
public void Execute(BasePage Context) { QueryParam qp = new QueryParam(); qp.Orderfld = WebHelper.GetStringParam(Context.Request, "Order", "ID"); qp.OrderType = WebHelper.GetIntParam(Context.Request, "OrderBy", 1); qp.PageIndex = WebHelper.GetIntParam(Context.Request, "PageIndex", 1); qp.PageSize = WebHelper.GetIntParam(Context.Request, "PageSize", Int32.MaxValue); qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.Status, (Int32)EnumFileStatus.Approved, SearchType.Equal)); qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.PortalId, Context.PortalId, SearchType.Equal)); String Search = WebHelper.GetStringParam(Context.Request, "Search", ""); if (!String.IsNullOrEmpty(Search)) { qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.FileName, Search, SearchType.Like)); } Int32 Visibility = WebHelper.GetIntParam(HttpContext.Current.Request, "Visibility", 0); if (Visibility >= 0) { qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.Extension1, Visibility, SearchType.Equal)); } if (Context.ViewSettingT <string>("General.MediaLibrary", "Public") == "Private") { qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.LastUser, Context.UserId, SearchType.Equal)); } int RecordCount = 0; List <Playngo_ClientZone_Files> fileList = Playngo_ClientZone_Files.FindAll(qp, out RecordCount); Dictionary <String, Object> jsonPictures = new Dictionary <string, Object>(); TemplateFormat xf = new TemplateFormat(); JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); foreach (var fileItem in fileList) { int index = fileList.IndexOf(fileItem); //index 为索引值 Dictionary <String, Object> jsonPicture = new Dictionary <String, Object>(); jsonPicture.Add("Pages", qp.Pages); jsonPicture.Add("ID", fileItem.ID); jsonPicture.Add("CreateTime", fileItem.LastTime); jsonPicture.Add("Name", WebHelper.leftx(fileItem.Name, 20, "...")); jsonPicture.Add("Extension", fileItem.FileExtension); String ThumbnailUrl = Context.ViewLinkUrl(String.Format("MediaID={0}", fileItem.ID)); jsonPicture.Add("ThumbnailUrl", ThumbnailUrl); jsonPicture.Add("FileUrl", Context.GetPhotoPath(fileItem.FilePath)); jsonPicture.Add("Thumbnail", String.Format("<img style=\"border-width:0px; max-height:60px;max-width:80px;\" src=\"{0}\" /> ", ThumbnailUrl)); //判断当前文件是否为图片 if (!String.IsNullOrEmpty(fileItem.FileExtension) && ("gif,jpg,jpeg,bmp,png").IndexOf(fileItem.FileExtension, StringComparison.CurrentCultureIgnoreCase) >= 0) { jsonPicture.Add("IsVideo", false); jsonPicture.Add("IsPicture", true); } else if (!String.IsNullOrEmpty(fileItem.FileExtension) && ("mp4,mkv,avi,ogv,webm,m4v").IndexOf(fileItem.FileExtension, StringComparison.CurrentCultureIgnoreCase) >= 0) { jsonPicture.Add("IsVideo", true); jsonPicture.Add("IsPicture", false); switch (fileItem.FileExtension) { case "mp4": jsonPicture.Add("IsMp4", true); break; case "m4v": jsonPicture.Add("IsM4v", true); break; case "ogv": jsonPicture.Add("IsOgv", true); break; case "webm": jsonPicture.Add("IsWebm", true); break; default: break; } } else if (!String.IsNullOrEmpty(fileItem.FileExtension) && ("flv,swf").IndexOf(fileItem.FileExtension, StringComparison.CurrentCultureIgnoreCase) >= 0) { jsonPicture.Add("IsFlash", true); jsonPicture.Add("IsPicture", false); jsonPicture.Add("Guid", Guid.NewGuid().ToString()); } else { jsonPicture.Add("IsVideo", false); jsonPicture.Add("IsPicture", false); } jsonPicture.Add("Json", jsSerializer.Serialize(jsonPicture)); jsonPictures.Add(index.ToString(), jsonPicture); } //转换数据为json ResponseString = jsSerializer.Serialize(jsonPictures); }