public IHttpActionResult Delete(int siteId, int channelId, int id)
{
try
{
var request = new AuthenticatedRequest();
var sourceId = request.GetPostInt(ContentAttribute.SourceId.ToCamelCase());
bool isAuth;
if (sourceId == SourceManager.User)
{
isAuth = request.IsUserLoggin && request.UserPermissions.HasChannelPermissions(siteId, channelId, ConfigManager.ChannelPermissions.ContentDelete);
}
else
{
isAuth = request.IsApiAuthenticated &&
AccessTokenManager.IsScope(request.ApiToken, AccessTokenManager.ScopeContents) ||
request.IsUserLoggin &&
request.UserPermissions.HasChannelPermissions(siteId, channelId,
ConfigManager.ChannelPermissions.ContentDelete) ||
request.IsAdminLoggin &&
request.AdminPermissions.HasChannelPermissions(siteId, channelId,
ConfigManager.ChannelPermissions.ContentDelete);
}
if (!isAuth)
{
return(Unauthorized());
}
var siteInfo = SiteManager.GetSiteInfo(siteId);
if (siteInfo == null)
{
return(BadRequest("无法确定内容对应的站点"));
}
var channelInfo = ChannelManager.GetChannelInfo(siteId, channelId);
if (channelInfo == null)
{
return(BadRequest("无法确定内容对应的栏目"));
}
if (!request.AdminPermissionsImpl.HasChannelPermissions(siteId, channelId,
ConfigManager.ChannelPermissions.ContentDelete))
{
return(Unauthorized());
}
var tableName = ChannelManager.GetTableName(siteInfo, channelInfo);
var contentInfo = ContentManager.GetContentInfo(siteInfo, channelInfo, id);
if (contentInfo == null)
{
return(NotFound());
}
ContentUtility.Delete(tableName, siteInfo, channelId, id);
//DataProvider.ContentDao.DeleteContent(tableName, siteInfo, channelId, id);
return(Ok(new
{
Value = contentInfo.ToDictionary()
}));
}
catch (Exception ex)
{
LogUtils.AddErrorLog(ex);
return(InternalServerError(ex));
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("siteId");
_channelId = AuthRequest.IsQueryExists("channelId") ? AuthRequest.GetQueryInt("channelId") : SiteId;
_isCheckOnly = AuthRequest.GetQueryBool("isCheckOnly");
_isTrashOnly = AuthRequest.GetQueryBool("isTrashOnly");
_isWritingOnly = AuthRequest.GetQueryBool("isWritingOnly");
_isAdminOnly = AuthRequest.GetQueryBool("isAdminOnly");
_channelInfo = ChannelManager.GetChannelInfo(SiteId, _channelId);
var tableName = ChannelManager.GetTableName(SiteInfo, _channelInfo);
_styleInfoList = TableStyleManager.GetContentStyleInfoList(SiteInfo, _channelInfo);
_attributesOfDisplay = TranslateUtils.StringCollectionToStringCollection(ChannelManager.GetContentAttributesOfDisplay(SiteId, _channelId));
_allStyleInfoList = ContentUtility.GetAllTableStyleInfoList(_styleInfoList);
_pluginIds = PluginContentManager.GetContentPluginIds(_channelInfo);
_pluginColumns = PluginContentManager.GetContentColumns(_pluginIds);
_isEdit = TextUtility.IsEdit(SiteInfo, _channelId, AuthRequest.AdminPermissionsImpl);
var state = AuthRequest.IsQueryExists("state") ? AuthRequest.GetQueryInt("state") : CheckManager.LevelInt.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;
var checkedLevel = 5;
var isChecked = true;
foreach (var owningChannelId in AuthRequest.AdminPermissionsImpl.ChannelIdList)
{
int checkedLevelByChannelId;
var isCheckedByChannelId = CheckManager.GetUserCheckLevel(AuthRequest.AdminPermissionsImpl, SiteInfo, owningChannelId, out checkedLevelByChannelId);
if (checkedLevel > checkedLevelByChannelId)
{
checkedLevel = checkedLevelByChannelId;
}
if (!isCheckedByChannelId)
{
isChecked = false;
}
}
RptContents.ItemDataBound += RptContents_ItemDataBound;
var allAttributeNameList = TableColumnManager.GetTableColumnNameList(tableName, DataType.Text);
var adminId = _isAdminOnly
? AuthRequest.AdminId
: AuthRequest.AdminPermissionsImpl.GetAdminId(SiteInfo.Id, _channelInfo.Id);
var whereString = DataProvider.ContentDao.GetPagerWhereSqlString(SiteInfo, _channelInfo,
searchType, keyword,
dateFrom, dateTo, state, _isCheckOnly, false, _isTrashOnly, _isWritingOnly, adminId,
AuthRequest.AdminPermissionsImpl,
allAttributeNameList);
PgContents.Param = new PagerParam
{
ControlToPaginate = RptContents,
TableName = tableName,
PageSize = SiteInfo.Additional.PageSize,
Page = AuthRequest.GetQueryInt(Pager.QueryNamePage, 1),
OrderSqlString = ETaxisTypeUtils.GetContentOrderByString(ETaxisType.OrderByIdDesc),
ReturnColumnNames = TranslateUtils.ObjectCollectionToString(allAttributeNameList),
WhereSqlString = whereString,
TotalCount = DataProvider.DatabaseDao.GetPageTotalCount(tableName, whereString)
};
if (IsPostBack)
{
return;
}
if (_isTrashOnly)
{
if (AuthRequest.IsQueryExists("IsDeleteAll"))
{
//DataProvider.ContentDao.DeleteContentsByTrash(SiteId, _channelId, tableName);
var list = DataProvider.ContentDao.GetContentIdListByTrash(SiteId, tableName);
foreach (var(contentChannelId, contentId) in list)
{
ContentUtility.Delete(tableName, SiteInfo, contentChannelId, contentId);
}
AuthRequest.AddSiteLog(SiteId, "清空回收站");
SuccessMessage("成功清空回收站!");
}
else if (AuthRequest.IsQueryExists("IsRestore"))
{
var idsDictionary = ContentUtility.GetIDsDictionary(Request.QueryString);
foreach (var channelId in idsDictionary.Keys)
{
var contentIdList = idsDictionary[channelId];
DataProvider.ContentDao.UpdateTrashContents(SiteId, channelId, ChannelManager.GetTableName(SiteInfo, channelId), contentIdList);
}
AuthRequest.AddSiteLog(SiteId, "从回收站还原内容");
SuccessMessage("成功还原内容!");
}
else if (AuthRequest.IsQueryExists("IsRestoreAll"))
{
DataProvider.ContentDao.UpdateRestoreContentsByTrash(SiteId, _channelId, tableName);
AuthRequest.AddSiteLog(SiteId, "从回收站还原所有内容");
SuccessMessage("成功还原所有内容!");
}
}
ChannelManager.AddListItems(DdlChannelId.Items, SiteInfo, true, true, AuthRequest.AdminPermissionsImpl);
if (_isCheckOnly)
{
CheckManager.LoadContentLevelToCheck(DdlState, SiteInfo, isChecked, checkedLevel);
}
else
{
CheckManager.LoadContentLevelToList(DdlState, SiteInfo, _isCheckOnly, isChecked, checkedLevel);
}
ControlUtils.SelectSingleItem(DdlState, state.ToString());
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();
LtlColumnsHead.Text += TextUtility.GetColumnsHeadHtml(_styleInfoList, _pluginColumns, _attributesOfDisplay);
BtnSelect.Attributes.Add("onclick", ModalSelectColumns.GetOpenWindowString(SiteId, _channelId));
if (_isTrashOnly)
{
LtlColumnsHead.Text += @"<th class=""text-center text-nowrap"" width=""150"">删除时间</th>";
BtnAddToGroup.Visible = BtnTranslate.Visible = BtnCheck.Visible = false;
PhTrash.Visible = true;
if (!HasChannelPermissions(_channelId, ConfigManager.ChannelPermissions.ContentDelete))
{
BtnDelete.Visible = false;
BtnDeleteAll.Visible = false;
}
else
{
BtnDelete.Attributes.Add("onclick", PageContentDelete.GetRedirectClickStringForMultiChannels(SiteId, true, PageUrl));
BtnDeleteAll.Attributes.Add("onclick", PageUtils.GetRedirectStringWithConfirm(PageUtils.AddQueryString(PageUrl, "IsDeleteAll", "True"), "确实要清空回收站吗?"));
}
BtnRestore.Attributes.Add("onclick", PageUtils.GetRedirectStringWithCheckBoxValue(PageUtils.AddQueryString(PageUrl, "IsRestore", "True"), "IDsCollection", "IDsCollection", "请选择需要还原的内容！"));
BtnRestoreAll.Attributes.Add("onclick", PageUtils.GetRedirectStringWithConfirm(PageUtils.AddQueryString(PageUrl, "IsRestoreAll", "True"), "确实要还原所有内容吗?"));
}
else
{
LtlColumnsHead.Text += @"<th class=""text-center text-nowrap"" width=""100"">操作</th>";
BtnAddToGroup.Attributes.Add("onclick", ModalAddToGroup.GetOpenWindowStringToContentForMultiChannels(SiteId));
if (HasChannelPermissions(SiteId, ConfigManager.ChannelPermissions.ContentCheck))
{
BtnCheck.Attributes.Add("onclick", ModalContentCheck.GetOpenWindowStringForMultiChannels(SiteId, PageUrl));
if (_isCheckOnly)
{
BtnCheck.CssClass = "btn m-r-5 btn-success";
}
}
else
{
PhCheck.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 override void Submit_OnClick(object sender, EventArgs e)
{
if (!Page.IsPostBack || !Page.IsValid)
{
return;
}
try
{
foreach (var channelId in _idsDictionary.Keys)
{
var tableName = ChannelManager.GetTableName(SiteInfo, channelId);
var contentIdList = _idsDictionary[channelId];
if (!_isDeleteFromTrash)
{
if (bool.Parse(RblRetainFiles.SelectedValue) == false)
{
DeleteManager.DeleteContents(SiteInfo, channelId, contentIdList);
SuccessMessage("成功删除内容以及生成页面！");
}
else
{
SuccessMessage("成功删除内容，生成页面未被删除！");
}
if (contentIdList.Count == 1)
{
var contentId = contentIdList[0];
var contentTitle = DataProvider.ContentDao.GetValue(tableName, contentId, ContentAttribute.Title);
AuthRequest.AddSiteLog(SiteId, channelId, contentId, "删除内容",
$"栏目:{ChannelManager.GetChannelNameNavigation(SiteId, channelId)},内容标题:{contentTitle}");
}
else
{
AuthRequest.AddSiteLog(SiteId, "批量删除内容",
$"栏目:{ChannelManager.GetChannelNameNavigation(SiteId, channelId)},内容条数:{contentIdList.Count}");
}
DataProvider.ContentDao.UpdateTrashContents(SiteId, channelId, tableName, contentIdList);
//引用内容，需要删除
//var siteTableNameList = SiteManager.GetTableNameList();
//foreach (var siteTableName in siteTableNameList)
//{
// var targetContentIdList = DataProvider.ContentDao.GetReferenceIdList(siteTableName, contentIdList);
// if (targetContentIdList.Count > 0)
// {
// var targetContentInfo = ContentManager.GetContentInfo(siteTableName, TranslateUtils.ToInt(targetContentIdList[0].ToString()));
// DataProvider.ContentDao.DeleteContents(targetContentInfo.SiteId, siteTableName, targetContentIdList, targetContentInfo.ChannelId);
// }
//}
CreateManager.TriggerContentChangedEvent(SiteId, channelId);
}
else
{
SuccessMessage("成功从回收站清空内容！");
//DataProvider.ContentDao.DeleteContents(SiteId, tableName, contentIdList, channelId);
foreach (var contentId in contentIdList)
{
ContentUtility.Delete(tableName, SiteInfo, channelId, contentId);
}
AuthRequest.AddSiteLog(SiteId, "从回收站清空内容", $"内容条数:{contentIdList.Count}");
}
}
AddWaitAndRedirectScript(_returnUrl);
}
catch (Exception ex)
{
LogUtils.AddErrorLog(ex);
FailMessage(ex, "删除内容失败！");
}
}