/// <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);
}
/// <summary>
/// 创建查询语句(权限)
/// </summary>
/// <param name="qp"></param>
/// <returns></returns>
public static QueryParam CreateQueryByRoles(QueryParam qp, BaseModule Context)
{
if (Context.UserId > 0)
{
if (!Context.UserInfo.IsSuperUser)//超级管理员不限制
{
qp.WhereSql.Append(" ( ");
//公开的
qp.WhereSql.Append(new SearchParam(_.Per_AllUsers, 0, SearchType.Equal).ToSql());
//有角色的
if (Context.UserInfo.Roles != null && Context.UserInfo.Roles.Length > 0)
{
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(" ( ");
Int32 RoleIndex = 0;
foreach (var r in Context.UserInfo.Roles)
{
if (RoleIndex > 0)
{
qp.WhereSql.Append(" OR ");
}
qp.WhereSql.Append(new SearchParam(_.Per_Roles, String.Format(",{0},", r), SearchType.Like).ToSql());
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(new SearchParam(_.Per_Roles, r, SearchType.Like).ToSql());
RoleIndex++;
}
qp.WhereSql.Append(" ) ");
}
qp.WhereSql.Append(" ) ");
}
}
else
{
qp.Where.Add(new SearchParam(_.Per_AllUsers, 0, SearchType.Equal));
}
return(qp);
}
/// <summary>
/// 查找标题和URL是否存在
/// </summary>
/// <param name="CampaignItem"></param>
/// <returns></returns>
public static Boolean FindExists(Playngo_ClientZone_Campaign CampaignItem)
{
QueryParam qp = new QueryParam();
qp.WhereSql.Append(new SearchParam(_.UrlSlug, CampaignItem.UrlSlug, SearchType.Equal).ToSql());
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(new SearchParam(_.Title, CampaignItem.Title, SearchType.Equal).ToSql());
return(FindCount(qp) > 0);
}
/// <summary>
/// 查找关联项的编号集合
/// </summary>
/// <param name="ItemID"></param>
/// <param name="PageType"></param>
/// <returns></returns>
public static List <String> FindFileIds(Int32 ItemID, Int32 PageType)
{
var Ids = new List <String>();
QueryParam qp = new QueryParam();
qp.ReturnFields = String.Format("{0},{1}", _.DownloadID, _.Sort);
var Relations = FindListByItem(ItemID, PageType, qp);
if (Relations != null && Relations.Count > 0)
{
foreach (var Relation in Relations)
{
Ids.Add(Relation.DownloadID.ToString());
}
}
return(Ids);
}
/// <summary>
/// 根据状态统计数量
/// </summary>
/// <param name="ModuleId"></param>
/// <param name="Status"></param>
/// <returns></returns>
public static Int32 FindCountByStatus(Int32 ModuleId, Int32 Status, Boolean IsAdmin, Int32 UserId)
{
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(_.ModuleId, ModuleId, SearchType.Equal));
if (Status >= 0)
{
qp.Where.Add(new SearchParam(_.Status, Status, SearchType.Equal));
}
//不是超级管理员也不是普通管理员时，只能看到自己发布的文章
if (IsAdmin)
{
qp.Where.Add(new SearchParam(_.CreateUser, UserId, SearchType.Equal));
}
return(FindCount(qp));
}
/// <summary>
/// 获取模板信息
/// </summary>
/// <param name="__ModuleId">模块编号</param>
/// <param name="__Name">模板名称</param>
/// <param name="__language">模板语言</param>
/// <returns></returns>
public static Playngo_ClientZone_MailSetting FindByModuleId(Int32 __ModuleId, String __Name, String __language = "en-US")
{
Int32 RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(_.ModuleId, __ModuleId, SearchType.Equal));
qp.Where.Add(new SearchParam(_.Name, __Name, SearchType.Equal));
qp.Where.Add(new SearchParam(_.language, __language, SearchType.Equal));
Playngo_ClientZone_MailSetting entity = FindItem(qp, out RecordCount);
if (entity == null)
{
entity = new Playngo_ClientZone_MailSetting();
}
return(entity);
}
/// <summary>
/// 查找最大排序
/// </summary>
/// <param name="DownloadRelation"></param>
/// <returns></returns>
public static Int32 FindMaxSrot(Int32 DownloadID, Int32 PageType)
{
Int32 Sort = 1;
QueryParam qp = new QueryParam();
qp.ReturnFields = qp.Orderfld = _.Sort;
qp.OrderType = 1;
qp.Where.Add(new SearchParam(_.DownloadID, DownloadID, SearchType.Equal));
qp.Where.Add(new SearchParam(_.PageType, PageType, SearchType.Equal));
var Scalar = FindScalar(qp);
int.TryParse(Convert.ToString(Scalar), out Sort);
return(Sort);
}
/// <summary>
/// 批量改名
/// 由于之前导入文件会把多加一个.zip的名称
/// 暂时不删除
/// </summary>
public void BatchReNames()
{
Int32 ReName = WebHelper.GetIntParam(Request, "rename", 0);
if (ReName > 0)
{
Int32 RecordCount = 0;
QueryParam qp = new QueryParam();
if (Visibility >= 0)
{
qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.Extension1, Visibility, SearchType.Equal));
}
qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.FileName, ".zip.zip", SearchType.Like));
List <Playngo_ClientZone_Files> Files = Playngo_ClientZone_Files.FindAll(qp, out RecordCount);
if (Files != null && Files.Count > 0)
{
foreach (var file in Files)
{
//得到新的文件名称和路径
String NewFileName = Common.ReplaceNoCase(file.FileName, ".zip.zip", ".zip");
String NewFilePath = Common.ReplaceNoCase(file.FilePath, ".zip.zip", ".zip");
var NewFileInfo = new FileInfo(MapPath(String.Format("{0}{1}", PortalSettings.HomeDirectory, NewFilePath)));
//得到老的文件路径
var OldFileInfo = new FileInfo(MapPath(String.Format("{0}{1}", PortalSettings.HomeDirectory, file.FilePath)));
//需要将存储的文件更名
OldFileInfo.MoveTo(NewFileInfo.FullName);
//需要移除掉重复的文件名
file.FileName = NewFileName;
//需要移除掉路径中重复的文件名
file.FilePath = NewFilePath;
//保存当前的修改
file.Update();
}
}
}
}
/// <summary>
/// 创建查询语句
/// </summary>
/// <param name="qp"></param>
/// <param name="Context"></param>
/// <returns></returns>
public QueryParam CreateQueryParam(QueryParam qp, BasePage Context)
{
qp.Where.Add(new SearchParam(Playngo_ClientZone_GameSheet._.Status, (Int32)EnumStatus.Published, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_GameSheet._.PortalId, Context.PortalId, SearchType.Equal));
//未到开始时间的不显示数据
qp.Where.Add(new SearchParam(Playngo_ClientZone_GameSheet._.StartTime, xUserTime.UtcTime(), SearchType.LtEqual));
//搜索标题
String Search = WebHelper.GetStringParam(Context.Request, "Search", "");
if (!String.IsNullOrEmpty(Search))
{
qp.Where.Add(new SearchParam("Title", Common.ReplaceEscape(Search), SearchType.Like));
}
return(qp);
}
public QueryParam SqlQueryTable(TemplateFormat xf, BasePage Context)
{
//4组数据的角标(根据Cookie传过来的时间计算)
QueryParam qp = new QueryParam();
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("NotifyInclude", 1, SearchType.Equal));
//qp.Where.Add(new SearchParam("StartTime", xUserTime.UtcTime().AddDays(-xf.ViewSettingT<Int32>("General.ExpiryTimeNotification", 7)), SearchType.GtEqual));
//未到开始时间的不显示数据
qp.Where.Add(new SearchParam("StartTime", xUserTime.UtcTime(), SearchType.LtEqual));
//权限筛选
qp = CreateQueryByRoles(qp, Context);
return(qp);
}
/// <summary>
/// 创建查询语句(区域)
/// </summary>
/// <param name="qp"></param>
/// <param name="Context"></param>
/// <returns></returns>
public QueryParam CreateQueryByJurisdictions(QueryParam qp, BasePage Context)
{
String Jurisdictions = WebHelper.GetStringParam(Context.Request, "Jurisdictions", "");
if (!String.IsNullOrEmpty(Jurisdictions))
{
if (qp.WhereSql.Length > 0)
{
qp.WhereSql.Append(" AND ");
}
qp.WhereSql.Append(" ( ");
qp.WhereSql.Append(new SearchParam("Per_AllJurisdictions", 0, SearchType.Equal).ToSql());
var RegionIds = Common.GetList(Jurisdictions);
if (RegionIds != null && RegionIds.Count > 0)
{
foreach (var RegionId in RegionIds)
{
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(new SearchParam("Per_Jurisdictions", String.Format(",{0},", RegionId), SearchType.Like).ToSql());
}
}
qp.WhereSql.Append(" ) ");
}
else
{
//所有区域可见
//qp.Where.Add(new SearchParam("Per_AllJurisdictions", 0, SearchType.Equal));
//没有勾选分类时，不能显示任何数据
qp.Where.Add(new SearchParam("Per_AllJurisdictions", -1, SearchType.Equal));
}
return(qp);
}
/// <summary>
/// 根据状态统计数量
/// </summary>
/// <param name="PortalId"></param>
/// <param name="Status"></param>
/// <returns></returns>
public static Int32 FindCountByType(Int32 PortalId, Int32 Visibility, Int32 type, Boolean IsAdmin, Int32 UserId)
{
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(_.PortalId, PortalId, SearchType.Equal));
qp.Where = ByType(qp.Where, type);
//不是超级管理员也不是普通管理员时，只能看到自己发布的文章
if (IsAdmin)
{
qp.Where.Add(new SearchParam(_.LastUser, UserId, SearchType.Equal));
}
if (Visibility >= 0)
{
qp.Where.Add(new SearchParam(_.Extension1, Visibility, SearchType.Equal));
}
return(FindCount(qp));
}
/// <summary>
/// 创建查询语句(文件类型)
/// </summary>
/// <param name="qp"></param>
/// <param name="Context"></param>
/// <returns></returns>
public QueryParam CreateQueryByFileTypes(QueryParam qp, BasePage Context)
{
String FileTypes = WebHelper.GetStringParam(Context.Request, "FileTypes", "");
if (!String.IsNullOrEmpty(FileTypes))
{
var FileTypeList = Common.GetList(FileTypes);
if (FileTypeList != null && FileTypeList.Count > 0)
{
if (!FileTypeList.Exists(r => r == "0"))
{
System.Text.StringBuilder WhereSql = new System.Text.StringBuilder();
foreach (var FileTypeItem in FileTypeList)
{
if (!String.IsNullOrEmpty(FileTypeItem))
{
if (WhereSql.Length > 0)
{
WhereSql.Append(" OR ");
}
WhereSql.Append(new SearchParam(Playngo_ClientZone_DownloadFile._.FileTypes, String.Format(",{0},", FileTypeItem), SearchType.Like).ToSql());
}
}
if (WhereSql.Length > 0)
{
qp.WhereSql.AppendFormat(" {0} ( {1} )", qp.WhereSql.Length > 0 ? "AND" : "", WhereSql);
}
}
}
}
else
{
//不勾选的时候不出现任何数据
qp.Where.Add(new SearchParam("FileTypes", "0", SearchType.Equal));
}
return(qp);
}
/// <summary>
/// 创建查询语句(游戏分类)
/// </summary>
/// <param name="qp"></param>
/// <param name="Context"></param>
/// <returns></returns>
public QueryParam CreateQueryByGameGategorys(QueryParam qp, BasePage Context)
{
String GameGategorys = WebHelper.GetStringParam(Context.Request, "GameGategorys", "");
if (!String.IsNullOrEmpty(GameGategorys))
{
var GameGategoryList = Common.GetList(GameGategorys);
if (GameGategoryList != null && GameGategoryList.Count > 0)
{
if (!GameGategoryList.Exists(r => r == "0"))
{
System.Text.StringBuilder WhereSql = new System.Text.StringBuilder();
foreach (var GameGategoryItem in GameGategoryList)
{
if (!String.IsNullOrEmpty(GameGategoryItem))
{
if (WhereSql.Length > 0)
{
WhereSql.Append(" OR ");
}
WhereSql.Append(new SearchParam("GameCategories", String.Format(",{0},", GameGategoryItem), SearchType.Like).ToSql());
}
}
if (WhereSql.Length > 0)
{
qp.WhereSql.AppendFormat(" {0} ( {1} )", qp.WhereSql.Length > 0 ? "AND" : "", WhereSql);
}
}
}
}
else
{
//不勾选的时候不出现任何数据
qp.Where.Add(new SearchParam("GameCategories", "-1", SearchType.Equal));
}
return(qp);
}
public void Execute(BasePage Context)
{
Dictionary <String, Object> jsonDicts = new Dictionary <String, Object>();
Int32 RelationId = WebHelper.GetIntParam(Context.Request, "ID", 0);
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(Playngo_ClientZone_DownloadRelation._.ID, RelationId, SearchType.Equal));
Int32 DeleteCount = Playngo_ClientZone_DownloadRelation.Delete(qp);
jsonDicts.Add("DeleteCount", DeleteCount);
//转换数据为json
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
ResponseString = jsSerializer.Serialize(jsonDicts);
}
/// <summary>
/// 单表联表查询
/// </summary>
/// <param name="Name">表名的别名</param>
/// <param name="TableName">表名</param>
/// <param name="IsGameGategorys">是否开启分类筛选</param>
/// <param name="Context"></param>
/// <returns></returns>
public String SqlQueryTable(String Name, String TableName, Boolean IsGameGategorys, BasePage Context)
{
QueryParam qp = new QueryParam();
//普通查询语句
qp = CreateQueryParam(qp, Context);
//权限筛选
qp = CreateQueryByRoles(qp, Context);
//区域筛选
qp = CreateQueryByJurisdictions(qp, Context);
if (IsGameGategorys)
{
//游戏分类筛选
qp = CreateQueryByGameGategorys(qp, Context);
}
return(String.Format(" ( Select ID,ReleaseDate,StartTime,('{0}') as [TableName] From {1} Where {2} )", Name, TableName, qp.ToSql()));
}
/// <summary>
/// 删除数据所关联的所有动态模块项
/// </summary>
/// <param name="LinkID"></param>
/// <param name="ModuleId"></param>
/// <param name="DynamicType"></param>
/// <returns></returns>
public static Int32 DeleteAll(Int32 LinkID, Int32 ModuleId, Int32 DynamicType)
{
int RecordCount = 0;
var DynamicModules = FindListByFilter(LinkID, DynamicType, ModuleId);
if (DynamicModules != null && DynamicModules.Count > 0)
{
foreach (var DynamicModule in DynamicModules)
{
if (DynamicModule.Delete() > 0)
{
RecordCount++;
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(Playngo_ClientZone_DynamicItem._.DynamicID, DynamicModule.ID, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_DynamicItem._.ModuleId, ModuleId, SearchType.Equal));
RecordCount += Playngo_ClientZone_DynamicItem.Delete(qp);
}
}
}
return(RecordCount);
}
private void BindDataListByEvents()
{
QueryParam qp = new QueryParam();
qp.OrderType = OrderType;
if (!String.IsNullOrEmpty(Orderfld))
{
qp.Orderfld = Orderfld;
}
else
{
qp.Orderfld = Playngo_ClientZone_Event._.ID;
}
#region "分页的一系列代码"
int RecordCount = 0;
int pagesize = qp.PageSize = 10;
qp.PageIndex = PageIndex;
#endregion
//查询的方法
qp.Where = BindSearch();
List <Playngo_ClientZone_Event> Events = Playngo_ClientZone_Event.FindAll(qp, out RecordCount);
qp.RecordCount = RecordCount;
RecordPages = qp.Pages;
lblRecordCount.Text = String.Format("{0} {2} / {1} {3}", RecordCount, RecordPages, ViewResourceText("Title_Items", "Items"), ViewResourceText("Title_Pages", "Pages"));
gvList.DataSource = Events;
gvList.DataBind();
BindGridViewEmpty <Playngo_ClientZone_Event>(gvList, new Playngo_ClientZone_Event());
}
/// <summary>
/// 绑定区域数据
/// </summary>
private void BindNavJurisdictions()
{
var XMLDB = GetTemplateDB("NavJurisdictions");
TemplateFormat xf = new TemplateFormat(this);
Hashtable Puts = new Hashtable();
Int32 RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Orderfld = Playngo_ClientZone_Jurisdiction._.Sort;
qp.OrderType = 0;
qp.Where.Add(new SearchParam(Playngo_ClientZone_Jurisdiction._.PortalId, PortalId, SearchType.Equal));
//权限筛选
qp = CreateQueryByRoles(qp);
var Jurisdictions = new List <Playngo_ClientZone_Jurisdiction>();
Jurisdictions.Add(new Playngo_ClientZone_Jurisdiction()
{
ID = 0, Name = "All"
});
var items = Playngo_ClientZone_Jurisdiction.FindAll(qp, out RecordCount);
if (items != null && items.Count > 0)
{
Jurisdictions.AddRange(items);
}
Puts.Add("Jurisdictions", Jurisdictions);
liNavJurisdictions.Text = ViewTemplate(XMLDB, "View_Template.html", Puts, xf);
}
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);
}
// Upload entire file
private void UploadWholeFile(HttpContext context, List <Resource_FilesStatus> statuses)
{
for (int i = 0; i < context.Request.Files.Count; i++)
{
var file = context.Request.Files[i];
if (file != null && !String.IsNullOrEmpty(file.FileName) && file.ContentLength > 0)
{
//To verify that if the suffix name of the uploaded files meets the DNN HOST requirements
Boolean retValue = FileSystemUtils.CheckValidFileName(file.FileName);
if (retValue)
{
Playngo_ClientZone_Files PhotoItem = new Playngo_ClientZone_Files();
PhotoItem.ModuleId = WebHelper.GetIntParam(context.Request, "ModuleId", 0);
PhotoItem.PortalId = WebHelper.GetIntParam(context.Request, "PortalId", 0);
PhotoItem.FileName = file.FileName;
PhotoItem.FileSize = file.ContentLength / 1024;
PhotoItem.FileMate = WebHelper.leftx(FileSystemUtils.GetContentType(Path.GetExtension(PhotoItem.FileName).Replace(".", "")), 30);
PhotoItem.FileExtension = System.IO.Path.GetExtension(PhotoItem.FileName).Replace(".", "");
PhotoItem.Name = System.IO.Path.GetFileName(file.FileName).Replace(Path.GetExtension(PhotoItem.FileName), "");
PhotoItem.Status = (Int32)EnumFileStatus.Approved;
try
{
if (("png,gif,jpg,jpeg,bmp").IndexOf(PhotoItem.FileExtension) >= 0)
{
//图片的流
Image image = Image.FromStream(file.InputStream);
PhotoItem.ImageWidth = image.Width;
PhotoItem.ImageHeight = image.Height;
PhotoItem.Exif = Common.Serialize <EXIFMetaData.Metadata>(new EXIFMetaData().GetEXIFMetaData(image));
}
}
catch
{
}
PhotoItem.LastTime = xUserTime.UtcTime();
PhotoItem.LastIP = WebHelper.UserHost;
PhotoItem.LastUser = UserInfo.UserID;
PhotoItem.Extension1 = Visibility;
String SaveDirPath = "uploads";
if (Visibility == 1)
{
SaveDirPath = "downloads";
}
//将文件存储的路径整理好
String fileName = System.IO.Path.GetFileName(file.FileName).Replace("." + PhotoItem.FileExtension, ""); //文件名称
String WebPath = String.Format("ClientZone/{0}/{1}/{2}/{3}/", SaveDirPath, DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day);
//检测文件存储路径是否有相关的文件
FileInfo fInfo = new FileInfo(HttpContext.Current.Server.MapPath(String.Format("{0}{1}{2}.{3}", PortalSettings.HomeDirectory, WebPath, fileName, PhotoItem.FileExtension)));
//检测文件夹是否存在
if (!System.IO.Directory.Exists(fInfo.Directory.FullName))
{
System.IO.Directory.CreateDirectory(fInfo.Directory.FullName);
}
else
{
Int32 j = 1;
while (fInfo.Exists)
{
//文件已经存在了
fileName = String.Format("{0}_{1}", PhotoItem.Name, j);
fInfo = new FileInfo(HttpContext.Current.Server.MapPath(String.Format("{0}{1}{2}.{3}", PortalSettings.HomeDirectory, WebPath, fileName, PhotoItem.FileExtension)));
j++;
}
}
PhotoItem.FilePath = String.Format("{0}{1}.{2}", WebPath, fileName, PhotoItem.FileExtension);
PhotoItem.FileName = String.Format("{0}.{1}", fileName, PhotoItem.FileExtension);
try
{
if (!fInfo.Directory.Exists)
{
fInfo.Directory.Create();
// FileSystemUtils.AddFolder(PortalSettings, String.Format("{0}Playngo_PhotoAlbums/{0}/{1}/"), String.Format("{0}Playngo_PhotoAlbums/{0}/{1}/"), (int)DotNetNuke.Services.FileSystem.FolderController.StorageLocationTypes.InsecureFileSystem);
}
//构造指定存储路径
file.SaveAs(fInfo.FullName);
//FileSystemUtils.AddFile(PhotoItem.FileName, PhotoItem.PortalId, String.Format("Playngo_PhotoAlbums\\{0}\\{1}\\", PhotoItem.ModuleId, PhotoItem.AlbumID), PortalSettings.HomeDirectoryMapPath, PhotoItem.FileMeta);
}
catch (Exception ex)
{
}
//给上传的相片设置初始的顺序
QueryParam qp = new QueryParam();
qp.ReturnFields = qp.Orderfld = Playngo_ClientZone_Files._.Sort;
qp.OrderType = 1;
qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.PortalId, PhotoItem.PortalId, SearchType.Equal));
PhotoItem.Sort = Convert.ToInt32(Playngo_ClientZone_Files.FindScalar(qp)) + 2;
Int32 PhotoId = PhotoItem.Insert();
statuses.Add(new Resource_FilesStatus(PhotoItem, PortalSettings, ModulePath));
}
}
}
}
public Int32 SynchronizeAllFiles(FileInfo SynchronizeFile)
{
Int32 SynchronizeFileCount = 0;
Playngo_ClientZone_Files PhotoItem = new Playngo_ClientZone_Files();
PhotoItem.ModuleId = ModuleId;
PhotoItem.PortalId = PortalId;
PhotoItem.FileName = SynchronizeFile.Name;
PhotoItem.FileSize = Convert.ToInt32(SynchronizeFile.Length / 1024);
PhotoItem.FileMate = WebHelper.leftx(FileSystemUtils.GetContentType(Path.GetExtension(PhotoItem.FileName).Replace(".", "")), 30);
PhotoItem.FileExtension = System.IO.Path.GetExtension(PhotoItem.FileName).Replace(".", "");
PhotoItem.Name = System.IO.Path.GetFileName(PhotoItem.FileName).Replace(Path.GetExtension(PhotoItem.FileName), "");
PhotoItem.Status = (Int32)EnumFileStatus.Approved;
try
{
if (("png,gif,jpg,jpeg,bmp").IndexOf(PhotoItem.FileExtension) >= 0)
{
//图片的流
System.Drawing.Image image = System.Drawing.Image.FromFile(SynchronizeFile.FullName);
PhotoItem.ImageWidth = image.Width;
PhotoItem.ImageHeight = image.Height;
PhotoItem.Exif = Common.Serialize <EXIFMetaData.Metadata>(new EXIFMetaData().GetEXIFMetaData(image));
}
}
catch
{
}
PhotoItem.LastTime = xUserTime.UtcTime();
PhotoItem.LastIP = WebHelper.UserHost;
PhotoItem.LastUser = UserInfo.UserID;
PhotoItem.Extension1 = Visibility;
//根据菜单来选择导入的文件夹
String SaveDirPath = "uploads";
if (Visibility == 1)
{
SaveDirPath = "downloads";
}
//将文件存储的路径整理好
String fileName = PhotoItem.Name; //文件名称
String WebPath = String.Format("ClientZone/{0}/{1}/{2}/{3}/", SaveDirPath, PhotoItem.LastTime.Year, PhotoItem.LastTime.Month, PhotoItem.LastTime.Day);
//检测文件存储路径是否有相关的文件
FileInfo fInfo = new FileInfo(HttpContext.Current.Server.MapPath(String.Format("{0}{1}{2}.{3}", PortalSettings.HomeDirectory, WebPath, fileName, PhotoItem.FileExtension)));
//检测文件夹是否存在
if (!System.IO.Directory.Exists(fInfo.Directory.FullName))
{
System.IO.Directory.CreateDirectory(fInfo.Directory.FullName);
}
else
{
Int32 j = 1;
while (fInfo.Exists)
{
//文件已经存在了
fileName = String.Format("{0}_{1}", PhotoItem.Name, j);
fInfo = new FileInfo(HttpContext.Current.Server.MapPath(String.Format("{0}{1}{2}.{3}", PortalSettings.HomeDirectory, WebPath, fileName, PhotoItem.FileExtension)));
j++;
}
}
PhotoItem.FilePath = String.Format("{0}{1}.{2}", WebPath, fileName, PhotoItem.FileExtension);
PhotoItem.FileName = String.Format("{0}.{1}", fileName, PhotoItem.FileExtension);
try
{
if (!fInfo.Directory.Exists)
{
fInfo.Directory.Create();
}
//异步移动文件到文件夹中
List <String> SynchronizeFileQueue = new List <string>();
SynchronizeFileQueue.Add(SynchronizeFile.FullName);
SynchronizeFileQueue.Add(fInfo.FullName);
ManagedThreadPool.QueueUserWorkItem(new WaitCallback(ThreadMoveTo), SynchronizeFileQueue);
}
catch (Exception ex)
{
}
//给上传的相片设置初始的顺序
QueryParam qp = new QueryParam();
qp.ReturnFields = qp.Orderfld = Playngo_ClientZone_Files._.Sort;
qp.OrderType = 1;
qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.PortalId, PhotoItem.PortalId, SearchType.Equal));
PhotoItem.Sort = Convert.ToInt32(Playngo_ClientZone_Files.FindScalar(qp)) + 2;
Int32 PhotoId = PhotoItem.Insert();
if (PhotoId > 0)
{
SynchronizeFileCount++;
}
return(SynchronizeFileCount);
}
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 static List <Playngo_ClientZone_DownloadRelation> FindListByItem(Int32 ItemID, Int32 PageType, QueryParam qp)
{
qp.OrderType = 0;
qp.Orderfld = _.Sort;
Int32 RecordCount = 0;
qp.Where.Add(new SearchParam(_.ItemID, ItemID, SearchType.Equal));
qp.Where.Add(new SearchParam(_.PageType, PageType, SearchType.Equal));
return(FindAll(qp, out RecordCount));
}
/// <summary>
/// 绑定查询的方法
/// </summary>
private QueryParam BindSearch(QueryParam qp)
{
List <SearchParam> Where = qp.Where;
//文章所属模块
Where.Add(new SearchParam(Playngo_ClientZone_Event._.ModuleId, Settings_ModuleID, SearchType.Equal));
//文章状态
Where.Add(new SearchParam(Playngo_ClientZone_Event._.Status, (Int32)EnumStatus.Published, SearchType.Equal));
qp.Where = Where;
//根据权限来筛选数据
#region "根据权限来筛选数据"
if (UserId > 0)
{
if (!UserInfo.IsSuperUser)//超级管理员不限制
{
if (!String.IsNullOrEmpty(qp.WhereSql.ToString()))
{
qp.WhereSql.Append(" AND ");
}
qp.WhereSql.Append(" ( ");
//公开的
qp.WhereSql.Append(new SearchParam(Playngo_ClientZone_Event._.Per_AllUsers, 0, SearchType.Equal).ToSql());
//有角色的
if (UserInfo.Roles != null && UserInfo.Roles.Length > 0)
{
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(" ( ");
Int32 RoleIndex = 0;
foreach (var r in UserInfo.Roles)
{
if (RoleIndex > 0)
{
qp.WhereSql.Append(" OR ");
}
qp.WhereSql.Append(new SearchParam(Playngo_ClientZone_Event._.Per_Roles, String.Format(",{0},", r), SearchType.Like).ToSql());
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(new SearchParam(Playngo_ClientZone_Event._.Per_Roles, r, SearchType.Like).ToSql());
RoleIndex++;
}
qp.WhereSql.Append(" ) ");
}
qp.WhereSql.Append(" ) ");
}
}
else
{
qp.Where.Add(new SearchParam(Playngo_ClientZone_Event._.Per_AllUsers, 0, SearchType.Equal));
}
#endregion
return(qp);
}
/// <summary>
/// 获取当前需要显示的动态模块
/// </summary>
/// <param name="LinkID"></param>
/// <param name="DynamicType"></param>
/// <param name="ModuleId"></param>
/// <returns></returns>
public static List <Playngo_ClientZone_DynamicModule> FindViewAllByFilter(Int32 LinkID, Int32 DynamicType, Int32 ModuleId, BaseModule mo)
{
int RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Orderfld = _.Sort;
qp.OrderType = 0;
qp.Where.Add(new SearchParam(_.LinkID, LinkID, SearchType.Equal));
qp.Where.Add(new SearchParam(_.Type, DynamicType, SearchType.Equal));
qp.Where.Add(new SearchParam(_.ModuleId, ModuleId, SearchType.Equal));
qp.Where.Add(new SearchParam(_.IncludeTabLink, 1, SearchType.Equal));
#region "根据权限来筛选数据"
if (mo.UserId > 0)
{
if (!mo.UserInfo.IsSuperUser)//超级管理员不限制
{
if (qp.WhereSql.Length > 0)
{
qp.WhereSql.Append(" AND ");
}
qp.WhereSql.Append(" ( ");
//公开的
qp.WhereSql.Append(new SearchParam(_.Per_AllUsers, 0, SearchType.Equal).ToSql());
//有角色的
if (mo.UserInfo.Roles != null && mo.UserInfo.Roles.Length > 0)
{
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(" ( ");
Int32 RoleIndex = 0;
foreach (var r in mo.UserInfo.Roles)
{
if (RoleIndex > 0)
{
qp.WhereSql.Append(" OR ");
}
qp.WhereSql.Append(new SearchParam(_.Per_Roles, String.Format(",{0},", r), SearchType.Like).ToSql());
qp.WhereSql.Append(" OR ");
qp.WhereSql.Append(new SearchParam(_.Per_Roles, r, SearchType.Like).ToSql());
RoleIndex++;
}
qp.WhereSql.Append(" ) ");
}
qp.WhereSql.Append(" ) ");
}
}
else
{
qp.Where.Add(new SearchParam(_.Per_AllUsers, 0, SearchType.Equal));
}
#endregion
return(FindAll(qp, out RecordCount));
}
/// <summary>
/// 更新绑定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void cmdUpdate_Click(object sender, EventArgs e)
{
try
{
Dictionary <String, Object> DynamicModuleJsons = new Dictionary <String, Object>();
Playngo_ClientZone_DynamicModule Dynamic = DynamicModule;
Dynamic.Title = txtTitle.Text;
Dynamic.IncludeTabLink = cbIncludeTabLink.Checked ? 1 : 0;
Dynamic.PDFGenerator = cbPDFGenerator.Checked ? 1 : 0;
//权限
Dynamic.Per_AllUsers = cbPermissionsAllUsers.Checked ? 0 : 1;
String textStr, idStr = String.Empty;
WebHelper.GetSelected(cblPermissionsRoles, out textStr, out idStr);
Dynamic.Per_Roles = idStr;
//更新项
Dynamic.LastIP = WebHelper.UserHost;
Dynamic.LastTime = xUserTime.UtcTime();
Dynamic.LastUser = UserId;
if (Dynamic.ID > 0)
{
//更新
}
else
{
//新增
Dynamic.ModuleId = ModuleId;
Dynamic.PortalId = PortalId;
Dynamic.LinkID = LinkID;
Dynamic.Type = DynamicType;
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(Playngo_ClientZone_DynamicModule._.ModuleId, ModuleId, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_DynamicModule._.LinkID, LinkID, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_DynamicModule._.Type, DynamicType, SearchType.Equal));
Dynamic.Sort = Playngo_ClientZone_DynamicModule.FindCount(qp) + 10;
}
int ResultEvent = 0;
if (Dynamic.ID > 0)
{
ResultEvent = Dynamic.Update();
DynamicModuleJsons.Add("Action", "Update");
}
else
{
ResultEvent = Dynamic.ID = Dynamic.Insert();
DynamicModuleJsons.Add("Action", "Insert");
}
foreach (var Field in Playngo_ClientZone_DynamicModule.Meta.Fields)
{
DynamicModuleJsons.Add(Field.ColumnName, Dynamic[Field.ColumnName]);
}
//DynamicItemJsons.Add("TypeText", EnumHelper.GetEnumTextVal(Dynamic.Type, typeof(EnumDynamicItemType)));
DynamicModuleJsons.Add("EditUrl", DynamicModule_IframeUrl(Dynamic.ID));
DynamicModuleJsons.Add("AddUrlText", DynamicItem_IframeUrl(0, Dynamic.ID, "Text"));
DynamicModuleJsons.Add("AddUrlImage", DynamicItem_IframeUrl(0, Dynamic.ID, "Image"));
DynamicModuleJsons.Add("AddUrlImageText", DynamicItem_IframeUrl(0, Dynamic.ID, "ImageText"));
DynamicModuleJsons.Add("AddUrlVideo", DynamicItem_IframeUrl(0, Dynamic.ID, "Video"));
DynamicModuleJsons.Add("AddUrliFrame", DynamicItem_IframeUrl(0, Dynamic.ID, "xFrame"));
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
jsSerializer.MaxJsonLength = Int32.MaxValue;
String JsonString = jsSerializer.Serialize(DynamicModuleJsons);
Response.Write(String.Format("<script>window.parent.EditDynamicModules({0});</script>", JsonString));
}
catch (Exception ex)
{
ProcessModuleLoadException(ex);
}
}
public void Execute(BasePage Context)
{
TemplateFormat xf = new TemplateFormat(Context);
QueryParam qp = new QueryParam();
qp.ReturnFields = "ID,Title";
qp.PageIndex = WebHelper.GetIntParam(Context.Request, "PageIndex", 1);
qp.PageSize = WebHelper.GetIntParam(Context.Request, "PageSize", xf.ViewSettingT <Int32>("General.Search.Size", 10));
//排序的规则
qp.OrderType = WebHelper.GetIntParam(Context.Request, "OrderType", 1);
qp.Orderfld = "ID"; //WebHelper.GetStringParam(Context.Request, "Orderfld", "ID");
//查询语句
qp = CreateQueryParam(qp, Context);
//权限筛选
qp = CreateQueryByRoles(qp, Context);
//区域筛选
qp = CreateQueryByJurisdictions(qp, Context);
int RecordCount = 0;
var UserList = new List <UserInfo>();
String SearchText = WebHelper.GetStringParam(Context.Request, "search", "");
if (!String.IsNullOrEmpty(SearchText))
{
//UserList = UserController.Instance.GetUsersAdvancedSearch(Context.PortalId, 0, -1, -1, -1, false, 0, 10, "USERID", false, "Username,DisplayName", "%" + SearchText ).ToList<UserInfo>();
UserList = Common.Split <UserInfo>(UserController.GetUsersByUserName(Context.PortalId, "%" + SearchText + "%", 0, 10, ref RecordCount, false, false), 1, 100); // "USERID", false, "Username", ).ToList<UserInfo>();
}
else
{
UserList = Common.Split <UserInfo>(UserController.GetUsers(Context.PortalId, 0, 10, ref RecordCount), 1, 100); //.GetUsersBasicSearch(Context.PortalId, 1, 10, "USERID", false, "", "").ToList<UserInfo>();
}
Dictionary <String, Object> jsonPictures = new Dictionary <string, Object>();
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
List <Dictionary <String, Object> > DictItems = new List <Dictionary <string, object> >();
foreach (var UserItem in UserList)
{
int index = UserList.IndexOf(UserItem); //index 为索引值
Dictionary <String, Object> jsonDict = new Dictionary <String, Object>();
jsonDict.Add("id", UserItem.UserID);
jsonDict.Add("text", String.Format("{0} - {1}", UserItem.Username, UserItem.DisplayName));
jsonDict.Add("roles", Common.GetStringByList(UserItem.Roles));
DictItems.Add(jsonDict);
}
jsonPictures.Add("Items", DictItems);
jsonPictures.Add("Pages", qp.Pages);
jsonPictures.Add("RecordCount", RecordCount);
//转换数据为json
ResponseString = jsSerializer.Serialize(jsonPictures);
}
public void Execute(BasePage Context)
{
Dictionary <String, Object> jsonDicts = new Dictionary <String, Object>();
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
Common.UpdateDictionary(jsonDicts, "Message", "");
Common.UpdateDictionary(jsonDicts, "Result", "false");
Int32 DownloadID = WebHelper.GetIntParam(Context.Request, "DownloadID", 0);
Int32 ItemID = WebHelper.GetIntParam(Context.Request, "ItemID", 0);
if (DownloadID > 0 && ItemID > 0)
{
var DownloadRelation = new Playngo_ClientZone_DownloadRelation();
Int32 PageType = WebHelper.GetIntParam(Context.Request, "PageType", 0);
Int32 RecordCount = 0;
QueryParam qp = new QueryParam();
qp.Where.Add(new SearchParam(Playngo_ClientZone_DownloadRelation._.DownloadID, DownloadID, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_DownloadRelation._.PageType, PageType, SearchType.Equal));
qp.Where.Add(new SearchParam(Playngo_ClientZone_DownloadRelation._.ItemID, ItemID, SearchType.Equal));
if (Playngo_ClientZone_DownloadRelation.FindCount(qp) == 0)
{
DownloadRelation.PageType = PageType;
DownloadRelation.DownloadID = DownloadID;
DownloadRelation.ItemID = ItemID;
DownloadRelation.Sort = Playngo_ClientZone_DownloadRelation.FindMaxSrot(DownloadID, PageType) + 1;
DownloadRelation.ModuleId = Context.ModuleId;
DownloadRelation.PortalId = Context.PortalId;
DownloadRelation.CreateTime = xUserTime.LocalTime();
DownloadRelation.CreateUser = Context.UserId;
DownloadRelation.ID = DownloadRelation.Insert();
if (DownloadRelation.ID > 0)
{
foreach (var Field in Playngo_ClientZone_DownloadRelation.Meta.Fields)
{
jsonDicts.Add(Field.ColumnName, DownloadRelation[Field.ColumnName]);
}
Common.UpdateDictionary(jsonDicts, "PageTypeText", EnumHelper.GetEnumTextVal(DownloadRelation.PageType, typeof(EnumDisplayModuleType)));
Common.UpdateDictionary(jsonDicts, "Title", WebHelper.GetStringParam(Context.Request, "Title", ""));
Common.UpdateDictionary(jsonDicts, "Result", "true");
}
else
{
Common.UpdateDictionary(jsonDicts, "Message", "添加数据不成功");
}
}
else
{
//DownloadRelation = Playngo_ClientZone_DownloadRelation.FindItem(qp, out RecordCount);
Common.UpdateDictionary(jsonDicts, "Message", "数据已经存在忽略");
}
}
else
{
//出入的ID数据不对
Common.UpdateDictionary(jsonDicts, "Message", "出入的ID数据不对");
}
//转换数据为json
ResponseString = jsSerializer.Serialize(jsonDicts);
}
public void Execute(BasePage Context)
{
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
Dictionary <String, Object> jsonPictures = new Dictionary <string, Object>();
String ImageIds = WebHelper.GetStringParam(Context.Request, "Images", "");
if (!String.IsNullOrEmpty(ImageIds))
{
QueryParam qp = new QueryParam();
qp.Orderfld = Playngo_ClientZone_Files._.ID;
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));
qp.Where.Add(new SearchParam(Playngo_ClientZone_Files._.ID, ImageIds.Trim(','), SearchType.In));
int RecordCount = 0;
List <Playngo_ClientZone_Files> fileList = Playngo_ClientZone_Files.FindAll(qp, out RecordCount);
TemplateFormat xf = new TemplateFormat();
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);
}
jsonPictures.Add("ResultCount", jsonPictures.Count);
jsonPictures.Add("Result", "success");
}
else
{
jsonPictures.Add("ResultCount", 0);
jsonPictures.Add("Result", "error");
}
//转换数据为json
ResponseString = jsSerializer.Serialize(jsonPictures);
}
