/// <summary>
/// 获取菜单列表分页
/// </summary>
/// <param name="pager"></param>
/// <returns></returns>
public async Task <Pager <Menu> > GetPageListAsync(PagerParam pager)
{
var data = await _clientMenusRep.GetMenuPageListAsync($" and c.ClientType={(int)ClientTypeEnum.PC}", pager.PageIndex, pager.PageSize, null, " c.SortId,c.ID asc");
if (data.DataList != null && data.DataList.Count > 0)
{
var imgDir = BaseCore.Configuration["ImgPath:savePath"];
data.DataList.ForEach(a =>
{
if (!a.IconPath.IsNullOrWhiteSpace())
{
a.IconPath = $"/{imgDir}/{a.IconPath}";
}
});
}
return(data);
}
/// <summary>
/// 根据页面Id获取该页面的所有评论（分页）
/// 查询条件：{ desc:"倒序（布尔）" }
/// </summary>
/// <param name="param">分页参数</param>
/// <param name="pageId">页面Id</param>
/// <returns></returns>
public static PagerResult GetCommentByPageId(PagerParam param, long pageId)
{
var result = param.GetPagerResult();
bool isDescent;
param.TryGetQueryOptions("desc", out isDescent);
XwgWebDBEntities entities = new XwgWebDBEntities();
var query = entities.tbl_CommentRecord.Where(r => r.PageId == pageId);
if (isDescent)
{
query = query.OrderByDescending(r => r.CommentTime);
}
else
{
query = query.OrderBy(r => r.CommentTime);
}
result.Total = query.Count();
param.CheckLastPage(result.Total);
result.Items = query.Skip(param.SkipCount).Take(param.RowCount)
.Select(r => new CommentRecord()
{
RecordId = r.RecordId,
Comment = r.Comment,
CommentTime = r.CommentTime,
VisitorId = r.VisitorId,
IP = r.tbl_VisitRecord.VisitorIP,
Nickname = r.NickName
})
.ToArray();
return result;
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("siteId", "channelId");
var channelId = AuthRequest.GetQueryInt("channelId");
_relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(SiteId, channelId);
_channelInfo = ChannelManager.GetChannelInfo(SiteId, channelId);
_tableName = ChannelManager.GetTableName(SiteInfo, _channelInfo);
_styleInfoList = TableStyleManager.GetTableStyleInfoList(_tableName, _relatedIdentities);
_attributesOfDisplay = TranslateUtils.StringCollectionToStringCollection(ChannelManager.GetContentAttributesOfDisplay(SiteId, channelId));
_allStyleInfoList = ContentUtility.GetAllTableStyleInfoList(_styleInfoList);
_pluginLinks = PluginContentManager.GetContentLinks(_channelInfo);
_isEdit = TextUtility.IsEdit(SiteInfo, channelId, AuthRequest.AdminPermissions);
if (_channelInfo.Additional.IsPreviewContents)
{
new Action(() =>
{
DataProvider.ContentDao.DeletePreviewContents(SiteId, _tableName, _channelInfo);
}).BeginInvoke(null, null);
}
if (!HasChannelPermissions(channelId, ConfigManager.ChannelPermissions.ContentView, ConfigManager.ChannelPermissions.ContentAdd, ConfigManager.ChannelPermissions.ContentEdit, ConfigManager.ChannelPermissions.ContentDelete, ConfigManager.ChannelPermissions.ContentTranslate))
{
if (!AuthRequest.IsAdminLoggin)
{
PageUtils.RedirectToLoginPage();
return;
}
PageUtils.RedirectToErrorPage("您无此栏目的操作权限！");
return;
}
RptContents.ItemDataBound += RptContents_ItemDataBound;
var allLowerAttributeNameList = TableMetadataManager.GetAllLowerAttributeNameListExcludeText(_tableName);
var pagerParam = new PagerParam
{
ControlToPaginate = RptContents,
TableName = _tableName,
PageSize = SiteInfo.Additional.PageSize,
Page = AuthRequest.GetQueryInt(Pager.QueryNamePage, 1),
OrderSqlString = DataProvider.ContentDao.GetPagerOrderSqlString(_channelInfo),
ReturnColumnNames = TranslateUtils.ObjectCollectionToString(allLowerAttributeNameList)
};
var administratorName = AuthRequest.AdminPermissions.IsViewContentOnlySelf(SiteId, channelId) ? AuthRequest.AdminName : string.Empty;
if (AuthRequest.IsQueryExists("searchType"))
{
pagerParam.WhereSqlString = DataProvider.ContentDao.GetPagerWhereSqlString(allLowerAttributeNameList,
SiteId, channelId, AuthRequest.AdminPermissions.IsSystemAdministrator, new List <int>
{
channelId
}, AuthRequest.GetQueryString("searchType"), AuthRequest.GetQueryString("keyword"),
AuthRequest.GetQueryString("dateFrom"), string.Empty, false, ETriState.All, false, false,
administratorName);
pagerParam.TotalCount =
DataProvider.DatabaseDao.GetPageTotalCount(_tableName, pagerParam.WhereSqlString);
}
else
{
pagerParam.WhereSqlString = DataProvider.ContentDao.GetPagerWhereSqlString(channelId, ETriState.All, administratorName);
pagerParam.TotalCount = _channelInfo.ContentNum;
}
PgContents.Param = pagerParam;
if (IsPostBack)
{
return;
}
LtlButtons.Text = WebUtils.GetContentCommands(AuthRequest.AdminPermissions, SiteInfo, _channelInfo, PageUrl);
LtlMoreButtons.Text = WebUtils.GetContentMoreCommands(AuthRequest.AdminPermissions, SiteInfo, _channelInfo, PageUrl);
PgContents.DataBind();
foreach (var styleInfo in _allStyleInfoList)
{
if (styleInfo.InputType == InputType.TextEditor)
{
continue;
}
var listitem = new ListItem(styleInfo.DisplayName, styleInfo.AttributeName);
DdlSearchType.Items.Add(listitem);
}
if (AuthRequest.IsQueryExists("searchType"))
{
TbDateFrom.Text = AuthRequest.GetQueryString("dateFrom");
ControlUtils.SelectSingleItem(DdlSearchType, AuthRequest.GetQueryString("searchType"));
TbKeyword.Text = AuthRequest.GetQueryString("keyword");
if (!string.IsNullOrEmpty(AuthRequest.GetQueryString("searchType")) || !string.IsNullOrEmpty(TbDateFrom.Text) ||
!string.IsNullOrEmpty(TbKeyword.Text))
{
LtlButtons.Text += @"
<script>
$(document).ready(function() {
$('#contentSearch').show();
});
</script>
";
}
}
else
{
ControlUtils.SelectSingleItem(DdlSearchType, ContentAttribute.Title);
}
LtlColumnsHead.Text = TextUtility.GetColumnsHeadHtml(_styleInfoList, _attributesOfDisplay, SiteInfo);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("SiteId");
_channelId = AuthRequest.IsQueryExists("ChannelId") ? AuthRequest.GetQueryInt("ChannelId") : SiteId;
_isWritingOnly = AuthRequest.GetQueryBool("isWritingOnly");
var administratorName = string.Empty;
_isSelfOnly = AuthRequest.GetQueryBool("isSelfOnly");
if (!_isSelfOnly)
{
administratorName = AuthRequest.AdminPermissions.IsViewContentOnlySelf(SiteId, _channelId) ? AuthRequest.AdminName : string.Empty;
}
_channelInfo = ChannelManager.GetChannelInfo(SiteId, _channelId);
var tableName = ChannelManager.GetTableName(SiteInfo, _channelInfo);
_relatedIdentities = RelatedIdentities.GetChannelRelatedIdentities(SiteId, _channelId);
_styleInfoList = TableStyleManager.GetTableStyleInfoList(tableName, _relatedIdentities);
_attributesOfDisplay = TranslateUtils.StringCollectionToStringCollection(ChannelManager.GetContentAttributesOfDisplay(SiteId, _channelId));
_allStyleInfoList = ContentUtility.GetAllTableStyleInfoList(_styleInfoList);
_pluginLinks = PluginContentManager.GetContentLinks(_channelInfo);
_isEdit = TextUtility.IsEdit(SiteInfo, _channelId, AuthRequest.AdminPermissions);
var stateType = AuthRequest.IsQueryExists("state") ? ETriStateUtils.GetEnumType(AuthRequest.GetQueryString("state")) : ETriState.All;
var searchType = AuthRequest.IsQueryExists("searchType") ? AuthRequest.GetQueryString("searchType") : ContentAttribute.Title;
var dateFrom = AuthRequest.IsQueryExists("dateFrom") ? AuthRequest.GetQueryString("dateFrom") : string.Empty;
var dateTo = AuthRequest.IsQueryExists("dateTo") ? AuthRequest.GetQueryString("dateTo") : string.Empty;
var keyword = AuthRequest.IsQueryExists("keyword") ? AuthRequest.GetQueryString("keyword") : string.Empty;
RptContents.ItemDataBound += RptContents_ItemDataBound;
var allLowerAttributeNameList = TableMetadataManager.GetAllLowerAttributeNameListExcludeText(tableName);
var pagerParam = new PagerParam
{
ControlToPaginate = RptContents,
TableName = tableName,
PageSize = SiteInfo.Additional.PageSize,
Page = AuthRequest.GetQueryInt(Pager.QueryNamePage, 1),
OrderSqlString = ETaxisTypeUtils.GetContentOrderByString(ETaxisType.OrderByIdDesc),
ReturnColumnNames = TranslateUtils.ObjectCollectionToString(allLowerAttributeNameList)
};
var channelIdList = ChannelManager.GetChannelIdList(_channelInfo, EScopeType.All, string.Empty, string.Empty, _channelInfo.ContentModelPluginId);
var searchChannelIdList = new List <int>();
if (AuthRequest.AdminPermissions.IsSystemAdministrator)
{
searchChannelIdList = channelIdList;
}
else
{
foreach (var theChannelId in channelIdList)
{
if (AuthRequest.AdminPermissions.OwningChannelIdList.Contains(theChannelId))
{
searchChannelIdList.Add(theChannelId);
}
}
}
pagerParam.WhereSqlString = DataProvider.ContentDao.GetPagerWhereSqlString(allLowerAttributeNameList,
SiteId, _channelInfo, AuthRequest.AdminPermissions.IsSystemAdministrator, searchChannelIdList, searchType, keyword,
dateFrom, dateTo, true, stateType, false, _isWritingOnly, administratorName);
pagerParam.TotalCount =
DataProvider.DatabaseDao.GetPageTotalCount(tableName, pagerParam.WhereSqlString);
PgContents.Param = pagerParam;
if (!IsPostBack)
{
ChannelManager.AddListItems(DdlChannelId.Items, SiteInfo, true, true, AuthRequest.AdminPermissions);
foreach (var styleInfo in _allStyleInfoList)
{
if (styleInfo.InputType == InputType.TextEditor)
{
continue;
}
var listitem = new ListItem(styleInfo.DisplayName, styleInfo.AttributeName);
DdlSearchType.Items.Add(listitem);
}
ETriStateUtils.AddListItems(DdlState, "全部", "已审核", "待审核");
if (SiteId != _channelId)
{
ControlUtils.SelectSingleItem(DdlChannelId, _channelId.ToString());
}
ControlUtils.SelectSingleItem(DdlState, AuthRequest.GetQueryString("State"));
ControlUtils.SelectSingleItem(DdlSearchType, searchType);
TbKeyword.Text = keyword;
TbDateFrom.Text = dateFrom;
TbDateTo.Text = dateTo;
PgContents.DataBind();
var showPopWinString = ModalAddToGroup.GetOpenWindowStringToContentForMultiChannels(SiteId);
BtnAddToGroup.Attributes.Add("onclick", showPopWinString);
showPopWinString = ModalSelectColumns.GetOpenWindowString(SiteId, _channelId, true);
BtnSelect.Attributes.Add("onclick", showPopWinString);
if (HasChannelPermissions(SiteId, ConfigManager.ChannelPermissions.ContentCheck))
{
showPopWinString = ModalContentCheck.GetOpenWindowStringForMultiChannels(SiteId, PageUrl);
BtnCheck.Attributes.Add("onclick", showPopWinString);
}
else
{
PhCheck.Visible = false;
}
LtlColumnsHead.Text = TextUtility.GetColumnsHeadHtml(_styleInfoList, _attributesOfDisplay, SiteInfo);
}
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentAdd))
{
BtnAddContent.Visible = false;
}
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentTranslate))
{
BtnTranslate.Visible = false;
}
else
{
BtnTranslate.Attributes.Add("onclick", PageContentTranslate.GetRedirectClickStringForMultiChannels(SiteId, PageUrl));
}
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentDelete))
{
BtnDelete.Visible = false;
}
else
{
BtnDelete.Attributes.Add("onclick", PageContentDelete.GetRedirectClickStringForMultiChannels(SiteId, false, PageUrl));
}
}
public async Task <IActionResult> GetMenusPager(PagerParam pager)
{
var data = await _clientMenusService.GetPageListAsync(pager);
return(Json(data));
}
public async Task <Pager <Slide> > GetPageListAsync(PagerParam pager)
{
var data = await _staticFilesRep.GetPageListAsync($" and Type={(int)FileType.Slide} ", pager.PageIndex, pager.PageSize, null, "sortID ,Title");
return(Mapper.Map <Pager <Slide> >(data));
}
public async Task <IActionResult> GetSlidesPager(PagerParam pager)
{
var data = await _staticFilesService.GetPageListAsync(pager);
return(Json(data));
}
