/// <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);
}
/// <summary>
/// DownloadFiles
/// 将事件实体查询出来并填充到数据中
/// </summary>
/// <param name="DictDataItem"></param>
/// <param name="ItemId"></param>
/// <returns></returns>
public Dictionary <String, Object> GetDictDataItemsByDownloadFiles(Dictionary <String, Object> DictDataItem, Int32 ItemId, BasePage Context)
{
var DataItem = Playngo_ClientZone_DownloadFile.FindByKeyForEdit(ItemId);
if (DataItem != null && DataItem.ID > 0)
{
//循环输出所有的固定项
foreach (var Field in Playngo_ClientZone_DownloadFile.Meta.Fields)
{
DictDataItem.Add(Field.ColumnName, DataItem[Field.ColumnName]);
}
//移除累赘的字典项
DictDataItem = Common.RemoveDictionary(DictDataItem, "Options");
TemplateFormat xf = new TemplateFormat(Context);
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,
DataItem.ID);
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", Context.FullPortalUrl(DownloadUrl));
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);
}
/// <summary>
/// 列表行绑定
/// </summary>
protected void gvEventList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//还原出数据
Playngo_ClientZone_Jurisdiction Categorie = e.Row.DataItem as Playngo_ClientZone_Jurisdiction;
//移动分类按钮
LinkButton lbSortUp = e.Row.FindControl("lbSortUp") as LinkButton;
LinkButton lbSortDown = e.Row.FindControl("lbSortDown") as LinkButton;
LinkButton lbMobileSortUp = e.Row.FindControl("lbMobileSortUp") as LinkButton;
LinkButton lbMobileSortDown = e.Row.FindControl("lbMobileSortDown") as LinkButton;
lbSortUp.CommandArgument =
lbSortDown.CommandArgument =
lbMobileSortUp.CommandArgument =
lbMobileSortDown.CommandArgument = Categorie.ID.ToString();
//编辑按钮
HyperLink hlMobileEdit = e.Row.FindControl("hlMobileEdit") as HyperLink;
HyperLink hlEdit = e.Row.FindControl("hlEdit") as HyperLink;
hlMobileEdit.NavigateUrl = hlEdit.NavigateUrl = xUrl("CategoryID", Categorie.ID.ToString(), "Jurisdictions");
//删除按钮
LinkButton btnRemove = e.Row.FindControl("btnRemove") as LinkButton;
LinkButton btnMobileRemove = e.Row.FindControl("btnMobileRemove") as LinkButton;
btnRemove.CommandArgument = btnMobileRemove.CommandArgument = Categorie.ID.ToString();
btnRemove.Attributes.Add("onClick", "javascript:return confirm('" + Localization.GetString("DeleteItem") + "');");
btnMobileRemove.Attributes.Add("onClick", "javascript:return confirm('" + Localization.GetString("DeleteItem") + "');");
//分类名称
HyperLink hlCategorie = e.Row.FindControl("hlCategorie") as HyperLink;
hlCategorie.Text = Categorie.Name;
//hlCategorie.NavigateUrl = new TemplateFormat(this).GoUrl(Categorie);
if (!String.IsNullOrEmpty(Categorie.Picture))
{
TemplateFormat xf = new TemplateFormat(this);
HyperLink hlPicture = e.Row.FindControl("hlPicture") as HyperLink;
var PictureUrl = xf.ViewLinkUrl(Categorie.Picture);
hlPicture.NavigateUrl = PictureUrl;
String FileName = Path.GetFileName(HttpUtility.UrlDecode(PictureUrl));
String Extension = Path.GetExtension(FileName);
if ((".jpg,.gif,.jpeg,.png,.bmp").IndexOf(Extension, StringComparison.CurrentCultureIgnoreCase) >= 0)
{
hlPicture.ImageUrl = PictureUrl;
hlPicture.ImageHeight = 50;
}
else
{
hlPicture.Text = FileName;
}
}
}
}
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);
}