public void Insert(GovPublicCategoryClassInfo categoryClassInfo)
{
if (categoryClassInfo.IsSystem)
{
if (EGovPublicCategoryClassTypeUtils.Equals(EGovPublicCategoryClassType.Channel, categoryClassInfo.ClassCode))
{
categoryClassInfo.ContentAttributeName = ContentAttribute.NodeId;
}
else if (EGovPublicCategoryClassTypeUtils.Equals(EGovPublicCategoryClassType.Department, categoryClassInfo.ClassCode))
{
categoryClassInfo.ContentAttributeName = GovPublicContentAttribute.DepartmentId;
}
}
else
{
categoryClassInfo.ContentAttributeName = GetContentAttributeNameNotUsed(categoryClassInfo.PublishmentSystemID);
}
var taxis = GetMaxTaxis(categoryClassInfo.PublishmentSystemID) + 1;
var parms = new IDataParameter[]
{
GetParameter(ParmClassCode, EDataType.NVarChar, 50, categoryClassInfo.ClassCode),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, categoryClassInfo.PublishmentSystemID),
GetParameter(ParmClassName, EDataType.NVarChar, 255, categoryClassInfo.ClassName),
GetParameter(ParmIsSystem, EDataType.VarChar, 18, categoryClassInfo.IsSystem.ToString()),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, categoryClassInfo.IsEnabled.ToString()),
GetParameter(ParmContentAttributeName, EDataType.VarChar, 50, categoryClassInfo.ContentAttributeName),
GetParameter(ParmTaxis, EDataType.Integer, taxis),
GetParameter(ParmDescription, EDataType.NVarChar, 255, categoryClassInfo.Description)
};
ExecuteNonQuery(SqlInsert, parms);
}
public void Page_Load(object sender, EventArgs e)
{
var classCode = Body.GetQueryString("ClassCode");
_categoryClassInfo = DataProvider.GovPublicCategoryClassDao.GetCategoryClassInfo(classCode, PublishmentSystemId);
if (Body.IsQueryExists("Delete") && Body.IsQueryExists("CategoryIDCollection"))
{
var categoryIdList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("CategoryIDCollection"));
foreach (var categoryId in categoryIdList)
{
DataProvider.GovPublicCategoryDao.Delete(categoryId);
}
SuccessMessage("成功删除所选节点");
}
else if (Body.IsQueryExists("CategoryID") && (Body.IsQueryExists("Subtract") || Body.IsQueryExists("Add")))
{
var categoryId = Body.GetQueryInt("CategoryID");
var isSubtract = Body.IsQueryExists("Subtract");
DataProvider.GovPublicCategoryDao.UpdateTaxis(_categoryClassInfo.ClassCode, PublishmentSystemId, categoryId, isSubtract);
PageUtils.Redirect(GetRedirectUrl(PublishmentSystemId, _categoryClassInfo.ClassCode, categoryId));
return;
}
if (!IsPostBack)
{
BreadCrumbWithItemTitle(AppManager.Wcm.LeftMenu.IdGovPublic, AppManager.Wcm.LeftMenu.GovPublic.IdGovPublicContentConfiguration, "分类法管理", ClassName + "分类", AppManager.Wcm.Permission.WebSite.GovPublicContentConfiguration);
ClientScriptRegisterClientScriptBlock("NodeTreeScript", GovPublicCategoryTreeItem.GetScript(_categoryClassInfo.ClassCode, PublishmentSystemId, EGovPublicCategoryLoadingType.List, null));
if (Body.IsQueryExists("CurrentCategoryID"))
{
_currentCategoryId = TranslateUtils.ToInt(Request.QueryString["CurrentCategoryID"]);
var onLoadScript = GetScriptOnLoad(_currentCategoryId);
if (!string.IsNullOrEmpty(onLoadScript))
{
ClientScriptRegisterClientScriptBlock("NodeTreeScriptOnLoad", onLoadScript);
}
}
BtnAddChannel.Attributes.Add("onclick", ModalGovPublicCategoryAdd.GetOpenWindowStringToAdd(_categoryClassInfo.ClassCode, PublishmentSystemId, GetRedirectUrl(PublishmentSystemId, _categoryClassInfo.ClassCode, 0)));
BtnDelete.Attributes.Add("onclick",
PageUtils.GetRedirectStringWithCheckBoxValueAndAlert(
PageUtils.GetWcmUrl(nameof(PageGovPublicCategory), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "ClassCode", _categoryClassInfo.ClassCode },
{ "Delete", true.ToString() },
}), "CategoryIDCollection", "CategoryIDCollection", "请选择需要删除的节点！", "此操作将删除对应节点以及所有下级节点，确认删除吗？"));
BindGrid();
}
}
public void Update(GovPublicCategoryClassInfo categoryClassInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmClassName, EDataType.NVarChar, 255, categoryClassInfo.ClassName),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, categoryClassInfo.IsEnabled.ToString()),
GetParameter(ParmDescription, EDataType.NVarChar, 255, categoryClassInfo.Description),
GetParameter(ParmClassCode, EDataType.NVarChar, 50, categoryClassInfo.ClassCode),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, categoryClassInfo.PublishmentSystemID),
};
ExecuteNonQuery(SqlUpdate, parms);
}
public ArrayList GetCategoryClassInfoArrayList(int publishmentSystemId, ETriState isSystem, ETriState isEnabled)
{
var arraylist = new ArrayList();
var selectParms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(SqlSelectAll, selectParms))
{
while (rdr.Read())
{
var i = 0;
var categoryClassInfo = new GovPublicCategoryClassInfo(GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
if (isSystem == ETriState.False)
{
if (categoryClassInfo.IsSystem)
{
continue;
}
}
else if (isSystem == ETriState.True)
{
if (!categoryClassInfo.IsSystem)
{
continue;
}
}
if (isEnabled == ETriState.False)
{
if (categoryClassInfo.IsEnabled)
{
continue;
}
}
else if (isEnabled == ETriState.True)
{
if (!categoryClassInfo.IsEnabled)
{
continue;
}
}
arraylist.Add(categoryClassInfo);
}
rdr.Close();
}
return(arraylist);
}
public GovPublicCategoryClassInfo GetCategoryClassInfo(string classCode, int publishmentSystemId)
{
GovPublicCategoryClassInfo categoryClassInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmClassCode, EDataType.NVarChar, 50, classCode),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
var i = 0;
categoryClassInfo = new GovPublicCategoryClassInfo(GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(categoryClassInfo);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
GovPublicCategoryClassInfo categoryClassInfo = null;
if (!string.IsNullOrEmpty(_classCode))
{
try
{
categoryClassInfo = DataProvider.GovPublicCategoryClassDao.GetCategoryClassInfo(_classCode, PublishmentSystemId);
if (categoryClassInfo != null)
{
categoryClassInfo.ClassName = tbClassName.Text;
categoryClassInfo.ClassCode = tbClassCode.Text;
categoryClassInfo.IsEnabled = TranslateUtils.ToBool(rblIsEnabled.SelectedValue);
categoryClassInfo.Description = tbDescription.Text;
}
DataProvider.GovPublicCategoryClassDao.Update(categoryClassInfo);
Body.AddSiteLog(PublishmentSystemId, "修改分类法", $"分类法:{categoryClassInfo.ClassName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "分类法修改失败！");
}
}
else
{
var classNameArrayList = DataProvider.GovPublicCategoryClassDao.GetClassNameArrayList(PublishmentSystemId);
var classCodeArrayList = DataProvider.GovPublicCategoryClassDao.GetClassCodeArrayList(PublishmentSystemId);
if (classNameArrayList.IndexOf(tbClassName.Text) != -1)
{
FailMessage("分类法添加失败，分类法名称已存在！");
}
else if (classCodeArrayList.IndexOf(tbClassCode.Text) != -1)
{
FailMessage("分类法添加失败，分类代码已存在！");
}
else
{
try
{
categoryClassInfo = new GovPublicCategoryClassInfo(tbClassCode.Text, PublishmentSystemId, tbClassName.Text, false, TranslateUtils.ToBool(rblIsEnabled.SelectedValue), string.Empty, 0, tbDescription.Text);
DataProvider.GovPublicCategoryClassDao.Insert(categoryClassInfo);
Body.AddSiteLog(PublishmentSystemId, "添加分类法", $"分类法:{categoryClassInfo.ClassName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "分类法添加失败！");
}
}
}
if (isChanged)
{
PageUtils.CloseModalPageAndRedirect(Page, PageGovPublicCategoryClass.GetRedirectUrl(PublishmentSystemId));
}
}
