public ActionResult GetList(SiteResourceQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<SiteResourceEntity> list = service.GetSiteResourceList(query);
return Json(new { list });
}
public ExecResult Del(SiteResourceQuery query)
{
ExecResult execResult = new ExecResult();
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve<ISiteResourceService>();
Int64[] ResourceIDs = query.ResourceIDs;
if (ResourceIDs == null)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "没有删除任何数据！";
return execResult;
}
string msg = string.Empty;
bool result = service.BatchDeleteSiteResource(ResourceIDs);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "删除资源文件成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "删除资源文件失败！";
}
return execResult;
}
public ActionResult Delete(Int64[] ResourceIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteResourceQuery query = new SiteResourceQuery();
query.JournalID = CurAuthor.JournalID;
query.ResourceIDs = ResourceIDs;
ExecResult result = service.DelSiteResource(query);
return Json(new { result = result.result, msg = result.msg });
}
public ActionResult GetPageList(SiteResourceQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager<SiteResourceEntity> pager = service.GetSiteResourcePageList(query);
return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords });
}
/// <summary>
/// 下载日志
/// </summary>
/// <param name="CID"></param>
/// <returns></returns>
public ActionResult DownResource(long ID)
{
try
{
SiteResourceQuery resouceQuery = new SiteResourceQuery();
resouceQuery.ResourceID = ID;
resouceQuery.JournalID = JournalID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteResourceEntity resouceEntity = service.GetSiteResourceModel(resouceQuery);
if (TicketTool.IsLogin())
{
if (resouceEntity == null)
{
return Json(new { flag = "对不起，要下载的文档不存在" });
}
else
{
if (!string.IsNullOrEmpty(resouceEntity.FilePath))
{
string downPath = GetUploadPath(resouceEntity.FilePath);
if (!System.IO.File.Exists(downPath))
return Json(new { flag = "文件不存在！" });
string fileName = System.IO.Path.GetFileName(downPath);
HttpResponseBase response = this.HttpContext.Response;
HttpServerUtilityBase server = this.HttpContext.Server;
response.Clear();
response.Buffer = true;
response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
response.ContentType = "application/octet-stream";
response.TransmitFile(downPath);
Response.Flush();
Response.Close();
return Json(new { flag = "下载成功！" });
}
else
{
return Json(new { flag = "对不起，要下载的文件不存在！" });
}
}
}
else
{
return Json(new { flag = "error", URL = SiteConfig.RootPath + "/" });
}
}
catch (Exception ex)
{
WKT.Log.LogProvider.Instance.Error("记录下载资源日志出现异常：" + ex.Message);
return Json(new { flag = "记录下载日志出现异常：" + ex.Message });
}
}
private SiteResourceEntity GetModel(Int64 ResourceID)
{
SiteResourceEntity model = null;
if (ResourceID > 0)
{
SiteResourceQuery query = new SiteResourceQuery();
query.JournalID = CurAuthor.JournalID;
query.ResourceID = ResourceID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
model = service.GetSiteResourceModel(query);
}
if (model == null)
model = new SiteResourceEntity();
return model;
}
/// <summary>
/// 删除资源文件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelSiteResource(SiteResourceQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, SiteResourceQuery>(GetAPIUrl(APIConstant.SITERESOURCE_DEL), query);
return result;
}
/// <summary>
/// 获取资源数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
return SiteResourceBusProvider.GetSiteResourceList(query);
}
/// <summary>
/// 获取资源分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<SiteResourceEntity> GetSiteResourcePageList(SiteResourceQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY ResourceID DESC) AS ROW_ID FROM dbo.SiteResource with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.SiteResource with(nolock)";
string whereSQL = GetSiteResourceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<SiteResourceEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeSiteResourceList);
}
/// <summary>
/// 获取条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetSiteResourceFilter(SiteResourceQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID=" + query.JournalID);
if (query.ChannelID > 0)
strFilter.AppendFormat(" and ChannelID={0}", query.ChannelID);
return strFilter.ToString();
}
/// <summary>
/// 获取资源数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
string strSql = "SELECT * FROM dbo.SiteResource with(nolock)";
string whereSQL = GetSiteResourceFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by ResourceID";
return db.GetList<SiteResourceEntity>(strSql, MakeSiteResourceList);
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
SiteResourceEntity item = null;
string strSql = string.Format("SELECT TOP 1 * FROM dbo.SiteResource with(nolock) WHERE ResourceID=@ResourceID AND JournalID=@JournalID");
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
db.AddInParameter(cmd, "@ResourceID", DbType.Int64, query.ResourceID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
item = MakeSiteResourceModel(dr);
}
return item;
}
public SiteResourceEntity GetModel(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve<ISiteResourceService>();
SiteResourceEntity model = service.GetSiteResourceModel(query);
return model;
}
/// <summary>
/// 获取资源文件分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<SiteResourceEntity> GetSiteResourcePageList(SiteResourceQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<SiteResourceEntity> pager = clientHelper.Post<Pager<SiteResourceEntity>, SiteResourceQuery>(GetAPIUrl(APIConstant.SITERESOURCE_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 获取资源分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<SiteResourceEntity> GetSiteResourcePageList(SiteResourceQuery query)
{
return SiteResourceDataAccess.Instance.GetSiteResourcePageList(query);
}
public IList<SiteResourceEntity> GetList(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve<ISiteResourceService>();
IList<SiteResourceEntity> list = service.GetSiteResourceList(query);
return list;
}
public ActionResult spjz(long ChannelID, int page = 1)
{
ViewBag.ChannelName = "";
ViewBag.PagerInfo = "";
SiteModel siteModel = new SiteModel();
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteChannelQuery query = new SiteChannelQuery();
query.JournalID = JournalID;
query.ChannelID = ChannelID;
SiteChannelEntity channelEntity = service.GetSiteChannelModel(query);
if (channelEntity != null)
{
ViewBag.ChannelName = channelEntity.Keywords;
if (channelEntity.ContentType == (int)EnumContentType.Information)
{
SiteContentQuery contentQuery = new SiteContentQuery();
contentQuery.ChannelID = ChannelID;
contentQuery.JournalID = JournalID;
contentQuery.CurrentPage = page;
contentQuery.PageSize = PageSize;
Pager<SiteContentEntity> pagerContentEntity = service.GetSiteContentPageList(contentQuery);
if (pagerContentEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerContentEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteContentEntity item in pagerContentEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Title;
newsItem.Content = item.Content;
newsItem.ChannelID = ChannelID;
newsItem.PKID = item.ContentID;
newsItem.FJPath = item.FJPath;
newsItem.LinkUrl = item.Linkurl;
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
else if (channelEntity.ContentType == (int)EnumContentType.SiteDescribe)
{
SiteNoticeQuery noticeQuery = new SiteNoticeQuery();
noticeQuery.ChannelID = ChannelID;
noticeQuery.JournalID = JournalID;
noticeQuery.CurrentPage = page;
noticeQuery.PageSize = PageSize;
Pager<SiteNoticeEntity> pagerNoticeEntity = service.GetSiteNoticePageList(noticeQuery);
if (pagerNoticeEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerNoticeEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteNoticeEntity item in pagerNoticeEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Title;
newsItem.Content = item.Content;
newsItem.ChannelID = ChannelID;
newsItem.PKID = item.NoticeID;
newsItem.FJPath = item.FjPath;
newsItem.LinkUrl = string.Format("/show/{0}/?itemid={1}", item.ChannelID, item.NoticeID);
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
else if (channelEntity.ContentType == (int)EnumContentType.Resources)
{
SiteResourceQuery resourceQuery = new SiteResourceQuery();
resourceQuery.ChannelID = ChannelID;
resourceQuery.JournalID = JournalID;
resourceQuery.CurrentPage = page;
resourceQuery.PageSize = PageSize;
Pager<SiteResourceEntity> pagerResourceEntity = service.GetSiteResourcePageList(resourceQuery);
if (pagerResourceEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerResourceEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteResourceEntity item in pagerResourceEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Name;
newsItem.LinkUrl = string.Format("/resource/?id={0}", item.ResourceID);
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
}
return View(siteModel);
}
/// <summary>
/// 显示指定的频道页面
/// </summary>
/// <param name="ChannelID"></param>
/// <param name="NewsID"></param>
/// <returns></returns>
public ActionResult resource()
{
long ItemID = TypeParse.ToLong(Request.QueryString["id"]);
SiteResourceEntity contentEntity = new SiteResourceEntity();
if (ItemID > 0)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteResourceQuery resourceQuery = new SiteResourceQuery();
resourceQuery.JournalID = JournalID;
resourceQuery.ResourceID = ItemID;
contentEntity = service.GetSiteResourceModel(resourceQuery);
}
ViewBag.Title = Utils.ClearHtml(contentEntity.Name);
return View(contentEntity);
}
/// <summary>
/// 获取资源文件数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<SiteResourceEntity> GetSiteResourceList(SiteResourceQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<SiteResourceEntity> list = clientHelper.Post<IList<SiteResourceEntity>, SiteResourceQuery>(GetAPIUrl(APIConstant.SITERESOURCE_GETLIST), query);
return list;
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
return SiteResourceBusProvider.GetSiteResourceModel(query);
}
public Pager<SiteResourceEntity> GetPageList(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve<ISiteResourceService>();
Pager<SiteResourceEntity> pager = service.GetSiteResourcePageList(query);
return pager;
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
return SiteResourceDataAccess.Instance.GetSiteResourceModel(query);
}
/// <summary>
/// 获取资源文件实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
SiteResourceEntity model = clientHelper.Post<SiteResourceEntity, SiteResourceQuery>(GetAPIUrl(APIConstant.SITERESOURCE_GETMODEL), query);
return model;
}