public int Insert(CategoryClassInfo categoryClassInfo)
{
if (categoryClassInfo.IsSystem)
{
if (ECategoryClassTypeUtils.Equals(ECategoryClassType.Channel, categoryClassInfo.ClassCode))
{
categoryClassInfo.ContentAttributeName = "ChannelId";
}
else if (ECategoryClassTypeUtils.Equals(ECategoryClassType.Department, categoryClassInfo.ClassCode))
{
categoryClassInfo.ContentAttributeName = ContentAttribute.DepartmentId;
}
}
else
{
categoryClassInfo.ContentAttributeName = GetContentAttributeNameNotUsed(categoryClassInfo.SiteId);
}
categoryClassInfo.Taxis = GetMaxTaxis(categoryClassInfo.SiteId) + 1;
return(_repository.Insert(categoryClassInfo));
// var sqlString = $@"INSERT INTO {TableName}
// (
// {nameof(CategoryClassInfo.SiteId)},
// {nameof(CategoryClassInfo.ClassCode)},
// {nameof(CategoryClassInfo.ClassName)},
// {nameof(CategoryClassInfo.IsSystem)},
// {nameof(CategoryClassInfo.IsEnabled)},
// {nameof(CategoryClassInfo.ContentAttributeName)},
// {nameof(CategoryClassInfo.Taxis)},
// {nameof(CategoryClassInfo.Description)}
// ) VALUES (
// @{nameof(CategoryClassInfo.SiteId)},
// @{nameof(CategoryClassInfo.ClassCode)},
// @{nameof(CategoryClassInfo.ClassName)},
// @{nameof(CategoryClassInfo.IsSystem)},
// @{nameof(CategoryClassInfo.IsEnabled)},
// @{nameof(CategoryClassInfo.ContentAttributeName)},
// @{nameof(CategoryClassInfo.Taxis)},
// @{nameof(CategoryClassInfo.Description)}
// )";
// var parameters = new[]
// {
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.SiteId), categoryClassInfo.SiteId),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.ClassCode), categoryClassInfo.ClassCode),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.ClassName), categoryClassInfo.ClassName),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.IsSystem), categoryClassInfo.IsSystem),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.IsEnabled), categoryClassInfo.IsEnabled),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.ContentAttributeName), categoryClassInfo.ContentAttributeName),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.Taxis), taxis),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.Description), categoryClassInfo.Description)
// };
// return Context.DatabaseApi.ExecuteNonQueryAndReturnId(TableName, nameof(CategoryClassInfo.Id), Context.ConnectionString, sqlString, parameters);
}
private void DgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem)
{
return;
}
var classInfo = (CategoryClassInfo)e.Item.DataItem;
var ltlClassName = (Literal)e.Item.FindControl("ltlClassName");
var ltlClassCode = (Literal)e.Item.FindControl("ltlClassCode");
var hlUpLinkButton = (HyperLink)e.Item.FindControl("hlUpLinkButton");
var hlDownLinkButton = (HyperLink)e.Item.FindControl("hlDownLinkButton");
var ltlIsEnabled = (Literal)e.Item.FindControl("ltlIsEnabled");
var ltlEditUrl = (Literal)e.Item.FindControl("ltlEditUrl");
var ltlDeleteUrl = (Literal)e.Item.FindControl("ltlDeleteUrl");
if (!classInfo.IsSystem)
{
ltlClassName.Text = $@"<a href=""{PageCategory.GetRedirectUrl(SiteId, classInfo.ClassCode)}"" target=""category"">{classInfo.ClassName}</a>";
}
else if (ECategoryClassTypeUtils.Equals(ECategoryClassType.Channel, classInfo.ClassCode))
{
ltlClassName.Text = $@"{classInfo.ClassName}";
}
else if (ECategoryClassTypeUtils.Equals(ECategoryClassType.Department, classInfo.ClassCode))
{
ltlClassName.Text = $@"{classInfo.ClassName}";
}
ltlClassCode.Text = classInfo.ClassCode;
ltlIsEnabled.Text = classInfo.IsEnabled ? "启用" : "禁用";
hlUpLinkButton.NavigateUrl = $"{GetRedirectUrl(SiteId)}&Up={true}&ClassCode={classInfo.ClassCode}";
hlDownLinkButton.NavigateUrl = $"{GetRedirectUrl(SiteId)}&Down={true}&ClassCode={classInfo.ClassCode}";
ltlEditUrl.Text =
$@"<a href='javascript:;' onclick=""{ModalCategoryClassAdd.GetOpenWindowStringToEdit(
SiteId, classInfo.Id)}"">编辑</a>";
if (classInfo.IsSystem)
{
return;
}
var urlDelete = $"{GetRedirectUrl(SiteId)}&Delete={true}&Id={classInfo.Id}";
ltlDeleteUrl.Text =
$@"<a href=""{urlDelete}"" onClick=""javascript:return confirm('此操作将删除分类法“{classInfo.ClassName}”及其分类项，确认吗？');"">删除</a>";
}
private CategoryClassInfo GetCategoryClassInfo(ECategoryClassType categoryType, int siteId)
{
var isSystem = categoryType == ECategoryClassType.Channel || categoryType == ECategoryClassType.Department;
return(new CategoryClassInfo
{
Id = 0,
SiteId = siteId,
ClassCode = ECategoryClassTypeUtils.GetValue(categoryType),
ClassName = ECategoryClassTypeUtils.GetText(categoryType),
IsSystem = isSystem,
IsEnabled = true,
ContentAttributeName = string.Empty,
Taxis = 0,
Description = string.Empty,
});
}
