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)); } }