/// <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);
}