/// <summary>
/// GameSheets
/// 将事件实体查询出来并填充到数据中
/// </summary>
/// <param name="DictDataItem"></param>
/// <param name="ItemId"></param>
/// <returns></returns>
public Dictionary <String, Object> GetDictDataItemsByGameSheets(Dictionary <String, Object> DictDataItem, Int32 ItemId, BasePage Context)
{
var DataItem = Playngo_ClientZone_GameSheet.FindByKeyForEdit(ItemId);
if (DataItem != null && DataItem.ID > 0)
{
//循环输出所有的固定项
foreach (var Field in Playngo_ClientZone_GameSheet.Meta.Fields)
{
DictDataItem.Add(Field.ColumnName, DataItem[Field.ColumnName]);
}
//移除累赘的字典项
DictDataItem = Common.RemoveDictionary(DictDataItem, "Options");
DictDataItem = Common.RemoveDictionary(DictDataItem, "Files");
TemplateFormat xf = new TemplateFormat(Context);
DictDataItem = Common.UpdateDictionary(DictDataItem, "Image", xf.ViewLinkUrl(xf.ViewItemSettingT <string>(DataItem, "Image", ""), "", Context));
DictDataItem = Common.UpdateDictionary(DictDataItem, "Summary", xf.ViewItemSettingT <string>(DataItem, "Summary", ""));
DictDataItem = Common.UpdateDictionary(DictDataItem, "Url", xf.GoUrl(DataItem));
DictDataItem = Common.UpdateDictionary(DictDataItem, "ReleaseDateStr", String.Format("{0} {1}{2},{3}", DataItem.ReleaseDate.ToString("MMM"), DataItem.ReleaseDate.Day, xf.GetDaySuffix(DataItem.ReleaseDate.Day), DataItem.ReleaseDate.ToString("yyyy")));
}
return(DictDataItem);
}
public void Execute(BasePage Context)
{
Int32 ItemId = WebHelper.GetIntParam(Context.Request, "ID", 0);
if (ItemId > 0)
{
Int32 ItemType = WebHelper.GetIntParam(Context.Request, "Type", (Int32)EnumDisplayModuleType.GameSheets);
TemplateFormat xf = new TemplateFormat(Context);
if (ItemType == (Int32)EnumDisplayModuleType.Events)
{
var Item = Playngo_ClientZone_Event.FindByKeyForEdit(ItemId);
Context.Response.Redirect(xf.GoUrl(Item));
}
else if (ItemType == (Int32)EnumDisplayModuleType.Campaigns)
{
var Item = Playngo_ClientZone_Campaign.FindByKeyForEdit(ItemId);
Context.Response.Redirect(xf.GoUrl(Item));
}
else if (ItemType == (Int32)EnumDisplayModuleType.Downloads)
{
Context.Response.Redirect(xf.GoUiUrl("Downloads"));
}
else
{
var Item = Playngo_ClientZone_GameSheet.FindByKeyForEdit(ItemId);
Context.Response.Redirect(xf.GoUrl(Item));
}
}
else
{
IsResponseWrite = true;
ResponseString = "传过来的文件编号都不对";
}
}
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);
}