public void Update(CategoryClassInfo categoryClassInfo)
{
_repository.Update(categoryClassInfo);
// string sqlString = $@"UPDATE {TableName} SET
// {nameof(CategoryClassInfo.SiteId)} = @{nameof(CategoryClassInfo.SiteId)},
// {nameof(CategoryClassInfo.ClassCode)} = @{nameof(CategoryClassInfo.ClassCode)},
// {nameof(CategoryClassInfo.ClassName)} = @{nameof(CategoryClassInfo.ClassName)},
// {nameof(CategoryClassInfo.IsSystem)} = @{nameof(CategoryClassInfo.IsSystem)},
// {nameof(CategoryClassInfo.IsEnabled)} = @{nameof(CategoryClassInfo.IsEnabled)},
// {nameof(CategoryClassInfo.ContentAttributeName)} = @{nameof(CategoryClassInfo.ContentAttributeName)},
// {nameof(CategoryClassInfo.Taxis)} = @{nameof(CategoryClassInfo.Taxis)},
// {nameof(CategoryClassInfo.Description)} = @{nameof(CategoryClassInfo.Description)}
// WHERE {nameof(CategoryClassInfo.Id)} = @{nameof(CategoryClassInfo.Id)}";
// 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), categoryClassInfo.Taxis),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.Description), categoryClassInfo.Description),
// Context.DatabaseApi.GetParameter(nameof(CategoryClassInfo.Id), categoryClassInfo.Id)
// };
// Context.DatabaseApi.ExecuteNonQuery(Context.ConnectionString, sqlString, parameters);
}
public void Page_Load(object sender, EventArgs e)
{
var classCode = Request.QueryString["classCode"];
_categoryClassInfo = Main.CategoryClassRepository.GetCategoryClassInfo(SiteId, classCode);
if (Request.QueryString["Delete"] != null && Request.QueryString["CategoryIDCollection"] != null)
{
var categoryIdList = Request.QueryString["CategoryIDCollection"].Split(',');
foreach (var categoryId in categoryIdList)
{
Main.CategoryRepository.Delete(TranslateUtils.ToInt(categoryId));
}
LtlMessage.Text = Utils.GetMessageHtml("成功删除所选节点", true);
}
else if (Request.QueryString["categoryId"] != null && (Request.QueryString["subtract"] != null || Request.QueryString["add"] != null))
{
var categoryId = TranslateUtils.ToInt(Request.QueryString["categoryId"]);
var isSubtract = Request.QueryString["subtract"] != null;
Main.CategoryRepository.UpdateTaxis(SiteId, _categoryClassInfo.ClassCode, categoryId, isSubtract);
Response.Redirect(GetRedirectUrl(SiteId, _categoryClassInfo.ClassCode, categoryId));
return;
}
if (IsPostBack)
{
return;
}
LtlScripts.Text += CategoryTreeItem.GetScript(SiteId, _categoryClassInfo.ClassCode, ECategoryLoadingType.List);
if (Request.QueryString["CurrentCategoryID"] != null)
{
_currentCategoryId = TranslateUtils.ToInt(Request.QueryString["CurrentCategoryID"]);
var onLoadScript = GetScriptOnLoad(_currentCategoryId);
if (!string.IsNullOrEmpty(onLoadScript))
{
LtlScripts.Text += onLoadScript;
}
}
BtnAdd.Attributes.Add("onclick", ModalCategoryAdd.GetOpenWindowStringToAdd(SiteId, _categoryClassInfo.ClassCode));
//BtnDelete.Attributes.Add("onclick",
// PageUtils.GetRedirectStringWithCheckBoxValueAndAlert(
// PageUtils.GetWcmUrl(nameof(PageCategory), new NameValueCollection
// {
// {"SiteId", SiteId.ToString()},
// {"ClassCode", _categoryClassInfo.ClassCode},
// {"Delete", true.ToString()},
// }), "CategoryIDCollection", "CategoryIDCollection", "请选择需要删除的节点！", "此操作将删除对应节点以及所有下级节点，确认删除吗？"));
RptContents.DataSource = Main.CategoryRepository.GetCategoryIdListByParentId(SiteId, _categoryClassInfo.ClassCode, 0);
RptContents.ItemDataBound += RptContents_ItemDataBound;
RptContents.DataBind();
}
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);
}
public void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
CategoryClassInfo categoryClassInfo;
if (_classId > 0)
{
try
{
categoryClassInfo = Main.CategoryClassRepository.GetCategoryClassInfo(_classId);
if (categoryClassInfo != null)
{
categoryClassInfo.ClassName = TbClassName.Text;
categoryClassInfo.ClassCode = TbClassCode.Text;
categoryClassInfo.IsEnabled = Convert.ToBoolean(DdlIsEnabled.SelectedValue);
categoryClassInfo.Description = TbDescription.Text;
}
Main.CategoryClassRepository.Update(categoryClassInfo);
isChanged = true;
}
catch (Exception ex)
{
LtlMessage.Text = Utils.GetMessageHtml($"分类法修改失败：{ex.Message}！", false);
}
}
else
{
var classNameList = Main.CategoryClassRepository.GetClassNameList(SiteId);
var classCodeList = Main.CategoryClassRepository.GetClassCodeList(SiteId);
if (classNameList.IndexOf(TbClassName.Text) != -1)
{
LtlMessage.Text = Utils.GetMessageHtml("分类法添加失败，分类法名称已存在！", false);
}
else if (classCodeList.IndexOf(TbClassCode.Text) != -1)
{
LtlMessage.Text = Utils.GetMessageHtml("分类法添加失败，分类代码已存在！", false);
}
else
{
try
{
categoryClassInfo = new CategoryClassInfo
{
SiteId = SiteId,
ClassCode = TbClassCode.Text,
ClassName = TbClassName.Text,
IsSystem = false,
IsEnabled = Convert.ToBoolean(DdlIsEnabled.SelectedValue),
ContentAttributeName = string.Empty,
Taxis = 0,
Description = TbDescription.Text
};
Main.CategoryClassRepository.Insert(categoryClassInfo);
isChanged = true;
}
catch (Exception ex)
{
LtlMessage.Text = Utils.GetMessageHtml($"分类法添加失败：{ex.Message}！", false);
}
}
}
if (isChanged)
{
Utils.CloseModalPage(Page);
}
}
