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