public void Execute(BasePage Context)
{
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
Dictionary <String, Object> jsonPictures = new Dictionary <string, Object>();
TemplateFormat xf = new TemplateFormat();
QueryParam qp = new QueryParam();
qp.PageIndex = WebHelper.GetIntParam(Context.Request, "PageIndex", 1);
qp.PageSize = WebHelper.GetIntParam(Context.Request, "PageSize", xf.ViewSettingT <Int32>("General.GameSheets.Pagings", 12));
//排序的规则
Int32 Sort = WebHelper.GetIntParam(Context.Request, "Sort", 0);
if (Sort == (Int32)EnumSortQueryByGame.GameName_DESC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.Title;
qp.OrderType = 1;
}
else if (Sort == (Int32)EnumSortQueryByGame.GameName_ASC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.Title;
qp.OrderType = 0;
}
else if (Sort == (Int32)EnumSortQueryByGame.GameID_DESC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.GameID;
qp.OrderType = 1;
}
else if (Sort == (Int32)EnumSortQueryByGame.GameID_ASC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.GameID;
qp.OrderType = 0;
}
else if (Sort == (Int32)EnumSortQueryByGame.ReleaseDate_DESC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.ReleaseDate;
qp.OrderType = 1;
}
else if (Sort == (Int32)EnumSortQueryByGame.ReleaseDate_ASC)
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.ReleaseDate;
qp.OrderType = 0;
}
else
{
qp.Orderfld = Playngo_ClientZone_GameSheet._.ID;
qp.OrderType = 1;
}
//查询语句
qp = CreateQueryParam(qp, Context);
//权限筛选
qp = CreateQueryByRoles(qp, Context);
//区域筛选
qp = CreateQueryByJurisdictions(qp, Context);
//游戏分类筛选
qp = CreateQueryByGameGategorys(qp, Context);
int RecordCount = 0;
List <Playngo_ClientZone_GameSheet> GameSheetList = Playngo_ClientZone_GameSheet.FindAll(qp, out RecordCount);
//配置值
XmlFormat xmlFormat = new XmlFormat(Context.Server.MapPath(String.Format("{0}Resource/xml/Config.Setting.GameSheets.xml", Context.ModulePath)));
var XmlItemSetting = xmlFormat.ToList <SettingEntity>();
List <Dictionary <String, Object> > DictFiles = new List <Dictionary <string, object> >();
foreach (var GameSheetItem in GameSheetList)
{
int index = GameSheetList.IndexOf(GameSheetItem); //index 为索引值
Dictionary <String, Object> jsonDict = new Dictionary <String, Object>();
//循环输出所有的固定项
foreach (var Field in Playngo_ClientZone_GameSheet.Meta.Fields)
{
jsonDict.Add(Field.ColumnName, GameSheetItem[Field.ColumnName]);
}
if (XmlItemSetting != null && XmlItemSetting.Count > 0)
{
var ItemSettings = ConvertTo.Deserialize <List <KeyValueEntity> >(GameSheetItem.Options);
foreach (var ItemSetting in XmlItemSetting)
{
jsonDict = Common.UpdateDictionary(jsonDict, ItemSetting.Name, xf.ViewItemSetting(GameSheetItem, ItemSetting.Name, ItemSetting.DefaultValue));
}
}
jsonDict = Common.UpdateDictionary(jsonDict, "ReleaseDateString", GameSheetItem.ReleaseDate.ToShortDateString());
jsonDict = Common.UpdateDictionary(jsonDict, "Image", xf.ViewLinkUrl(xf.ViewItemSettingT <string>(GameSheetItem, "Image", ""), "", Context));
jsonDict = Common.UpdateDictionary(jsonDict, "Url", xf.GoUrl(GameSheetItem));
//未来日期出现Coming Soon
jsonDict = Common.UpdateDictionary(jsonDict, "ComingSoonDisplay", GameSheetItem.ReleaseDate > xUserTime.LocalTime());
Int32 NotifyStatus = (Int32)EnumNotificationStatus.None;
if (GameSheetItem.NotifyInclude == 1) //&& GameSheetItem.StartTime >= xUserTime.LocalTime().AddDays(-xf.ViewSettingT<Int32>("General.ExpiryTimeNotification", 7)))
{
NotifyStatus = GameSheetItem.NotifyStatus;
}
jsonDict = Common.UpdateDictionary(jsonDict, "NotificationStatus", EnumHelper.GetEnumTextVal(NotifyStatus, typeof(EnumNotificationStatus)));
jsonDict = Common.UpdateDictionary(jsonDict, "NotificationStatusClass", EnumHelper.GetEnumTextVal(NotifyStatus, typeof(EnumNotificationStatus)).ToLower());
DictFiles.Add(jsonDict);
}
jsonPictures.Add("data", DictFiles);
jsonPictures.Add("Pages", qp.Pages);
jsonPictures.Add("RecordCount", RecordCount);
//转换数据为json
ResponseString = jsSerializer.Serialize(jsonPictures);
}
public void Execute(BasePage Context)
{
Dictionary <String, Object> jsonDatas = new Dictionary <string, Object>();
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
TemplateFormat xf = new TemplateFormat(Context);
QueryParam qp = new QueryParam();
qp.Orderfld = WebHelper.GetStringParam(Context.Request, "Orderfld", "ID");
qp.OrderType = WebHelper.GetIntParam(Context.Request, "OrderType", 1);
qp.PageIndex = WebHelper.GetIntParam(Context.Request, "PageIndex", 1);
qp.PageSize = WebHelper.GetIntParam(Context.Request, "PageSize", xf.ViewSettingT <Int32>("General.Downloads.Pagings", 10));
//查询语句
qp = CreateQueryParam(qp, Context);
//权限筛选
qp = CreateQueryByRoles(qp, Context);
//区域筛选
qp = CreateQueryByJurisdictions(qp, Context);
//文件类型筛选
qp = CreateQueryByFileTypes(qp, Context);
//游戏分类筛选
qp = CreateQueryByGameGategorys(qp, Context);
int RecordCount = 0;
List <Playngo_ClientZone_DownloadFile> fileList = Playngo_ClientZone_DownloadFile.FindAll(qp, out RecordCount);
//配置值
XmlFormat xmlFormat = new XmlFormat(Context.Server.MapPath(String.Format("{0}Resource/xml/Config.Setting.Downloads.xml", Context.ModulePath)));
var XmlItemSetting = xmlFormat.ToList <SettingEntity>();
List <Dictionary <String, Object> > DictFiles = new List <Dictionary <string, object> >();
foreach (var fileItem in fileList)
{
int index = fileList.IndexOf(fileItem); //index 为索引值
Dictionary <String, Object> jsonDict = new Dictionary <String, Object>();
//循环输出所有的固定项
foreach (var Field in Playngo_ClientZone_DownloadFile.Meta.Fields)
{
jsonDict.Add(Field.ColumnName, fileItem[Field.ColumnName]);
}
if (XmlItemSetting != null && XmlItemSetting.Count > 0)
{
var ItemSettings = ConvertTo.Deserialize <List <KeyValueEntity> >(fileItem.Options);
foreach (var ItemSetting in XmlItemSetting)
{
jsonDict = Common.UpdateDictionary(jsonDict, ItemSetting.Name, xf.ViewItemSetting(fileItem, ItemSetting.Name, ItemSetting.DefaultValue));
}
}
//下载地址
String DownloadUrl = String.Format("{0}Resource_Service.aspx?ModuleId={1}&Token={2}&TabId={3}&PortalId={4}&language={5}&FileId={6}",
Context.ModulePath,
Context.Settings_ModuleID,
"DownloadFile",
Context.Settings_TabID,
Context.PortalId,
Context.language,
fileItem.ID);
jsonDict = Common.UpdateDictionary(jsonDict, "DownloadUrl", DownloadUrl);
jsonDict = Common.UpdateDictionary(jsonDict, "ReleaseDateString", fileItem.ReleaseDate.ToShortDateString());
//文件类型转换
jsonDict = Common.UpdateDictionary(jsonDict, "FileTypesString", Playngo_ClientZone_FileType.ConvertFileTypes(fileItem.FileTypes));
//订阅状态等
Int32 NotifyStatus = (Int32)EnumNotificationStatus.None;
if (fileItem.NotifyInclude == 1) //&& fileItem.StartTime >= xUserTime.LocalTime().AddDays(-xf.ViewSettingT<Int32>("General.ExpiryTimeNotification", 7)))
{
NotifyStatus = fileItem.NotifyStatus;
}
jsonDict = Common.UpdateDictionary(jsonDict, "NotificationStatus", EnumHelper.GetEnumTextVal(NotifyStatus, typeof(EnumNotificationStatus)));
jsonDict = Common.UpdateDictionary(jsonDict, "NotificationStatusClass", EnumHelper.GetEnumTextVal(NotifyStatus, typeof(EnumNotificationStatus)).ToLower());
//未来日期出现Coming Soon
jsonDict = Common.UpdateDictionary(jsonDict, "ComingSoonDisplay", fileItem.ReleaseDate > xUserTime.LocalTime());
DictFiles.Add(jsonDict);
}
jsonDatas.Add("data", DictFiles);
jsonDatas.Add("Pages", qp.Pages);
jsonDatas.Add("RecordCount", RecordCount);
//转换数据为json
ResponseString = jsSerializer.Serialize(jsonDatas);
}