private void sbtnSaveChild_Click(object sender, EventArgs e) { if (this.slueParentName.EditValue == null) { XtraMessageBox.Show("Parent name is null!", "提示", MessageBoxButtons.OK); return; } if (string.IsNullOrEmpty(this.teAddChildFormName.Text.Trim())) { XtraMessageBox.Show("Form Name is empty!", "提示", MessageBoxButtons.OK); return; } if (string.IsNullOrEmpty(this.teAddChildTabHeaderText.Text.Trim())) { XtraMessageBox.Show("Header Text is empty!", "提示", MessageBoxButtons.OK); return; } var check = this.ceChildStatus.Checked ? 1 : 0; FormRoleMenuAuthoritiesVM parents = this.slueParentName.EditValue as FormRoleMenuAuthoritiesVM; MenusVM vm = new MenusVM() { ParentID = parents.ID, FormName = this.teAddChildFormName.Text.Trim(), TabHeaderText = this.teAddChildTabHeaderText.Text.Trim(), Status = check }; SaveMenus(vm); }
public List <MenusVM> GetAllMenus(MenusVM vm) { try { StringBuilder selectDataCommand = new StringBuilder(@" SELECT [ID] ,[ParentID] ,[FormName] ,[TabHeaderText] ,[SortCode] ,[Remark] FROM [RABC].[dbo].[Menus] where [Status]=1 "); List <SqlParameter> parameters = new List <SqlParameter>(); if (!string.IsNullOrEmpty(vm.FormName)) { selectDataCommand.Append(" and [FormName] like @FormName"); parameters.Add(new SqlParameter("@FormName", string.Format("%{0}%", vm.FormName))); } if (!string.IsNullOrEmpty(vm.TabHeaderText)) { selectDataCommand.Append(" and [TabHeaderText] like @TabHeaderText"); parameters.Add(new SqlParameter("@TabHeaderText", string.Format("%{0}%", vm.TabHeaderText))); } return(DataTableToList.DataSetToList <MenusVM>(SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, selectDataCommand.ToString(), parameters.ToArray()))); } catch (Exception ex) { return(null); } }
public ActionResult Create(int?menuId) { try { var listTypes = _generalFunctions.GetListType("Menü Yeri"); var model = new MenusVM { Menus = new Menus(), MenuInfo = new MenuInfo(), ListType = listTypes }; if (menuId != null) { model.Menus.ParentID = Convert.ToInt32(menuId); } model.Menus.Active = true; model.Menus.Sort = 1; return(View(model)); } catch (Exception ex) { TempData.Add("message", "Menü ekleme sayfası yüklenirken hata ile karşılaştı. Hata: " + ex.Message); return(View()); } }
public ActionResult Edit(Menus menus, MenuInfo menuInfo, HttpPostedFile uploadfile) { try { if (!ModelState.IsValid) { var listTypes = _generalFunctions.GetListType("Menü Yeri"); var model = new MenusVM { Menus = new Menus(), MenuInfo = new MenuInfo(), ListType = listTypes }; model.Menus.Active = true; model.Menus.Sort = 1; } if (uploadfile != null) { menus.Image = uploadfile.FileName; } else { menus.Image = null; } _menusService.Update(menus); //Menüyü resmini kayıt edelim. if (menus.Image != null && uploadfile != null) { //Önceki resmi dosyadan silelim ki boşuna yer kaplamasın. string filePath = "/Uploads/Menus/" + menus.MenuID + "/" + menus.Image; if (System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath); } _generalFunctions.CreateDirectory(HttpContext.Server.MapPath("/Uploads/Menus/"), menus.MenuID.ToString()); uploadfile.SaveAs(HttpContext.Server.MapPath("/Uploads/Menus/" + menus.MenuID + "/" + uploadfile.FileName)); } //Menü bilgilerini güncelleyelim. _menuInfoService.Update(menuInfo); TempData.Add("message", "Menü başarıyla güncellendi."); return(RedirectToAction("index")); } catch (Exception ex) { TempData.Add("message", "Menü güncelleme yapılırken hata ile karşılaşıldı. Hata: " + ex.Message); return(View()); } }
public ActionResult Create(Menus menus, MenuInfo menuInfo, HttpPostedFileBase uploadfile) { try { if (!ModelState.IsValid) { var listTypes = _generalFunctions.GetListType("Menü Yeri"); var model = new MenusVM { Menus = new Menus(), MenuInfo = new MenuInfo(), ListType = listTypes }; model.Menus.Active = true; model.Menus.Sort = 1; } menus.CreationDate = DateTime.Now; if (uploadfile != null) { menus.Image = uploadfile.FileName; } else { menus.Image = null; } _menusService.Add(menus); int menuID = menus.MenuID; //Menüyü resmini kayıt edelim. if (menus.Image != null && uploadfile != null) { _generalFunctions.CreateDirectory(HttpContext.Server.MapPath("/Uploads/Menus/"), menuID.ToString()); uploadfile.SaveAs(HttpContext.Server.MapPath("/Uploads/Menus/" + menuID + "/" + uploadfile.FileName)); } //Menü bilgilerini kayıt edelim. menuInfo.MenuID = menuID; menuInfo.LanguageID = 1; _menuInfoService.Add(menuInfo); TempData.Add("message", "Menü başarıyla eklendi."); return(RedirectToAction("index")); } catch (Exception ex) { TempData.Add("message", "Menü kayıt işleminde hata ile karşılaştı. Hata: " + ex.Message); return(View()); } }
private void SaveMenus(MenusVM vm) { int res = _bll.AddMenus(vm); if (res > 0) { XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK); RequestGridData(); GetParentMenus(); } else { DevExpress.XtraEditors.XtraMessageBox.Show("保存失败!", "提示", MessageBoxButtons.OK); } }
public ActionResult Edit(int id) { try { var listTypes = _generalFunctions.GetListType("Menü Yeri"); var model = new MenusVM { Menus = _menusService.GetById(id), MenuInfo = _menuInfoService.Get(m => m.MenuID == id), ListType = listTypes }; return(View(model)); } catch (Exception ex) { TempData.Add("message", "Menü güncelleme sayfası yüklenirken hata ile karşılaşıldı. Hata: " + ex.Message); return(View()); } }
private void GetCheckedData(TreeListNode parentNode, List <MenusVM> lstCheckedKeyID, TreeList treeList) { if (parentNode.Nodes.Count == 0) { if (parentNode.CheckState == CheckState.Checked) { if (parentNode.ParentNode == null) { lstCheckedKeyID.Add(treeList.GetDataRecordByNode(parentNode) as MenusVM); } } return;//递归终止 } foreach (TreeListNode node in parentNode.Nodes) { if (node.CheckState == CheckState.Checked) { if (node.HasChildren) { GetCheckedData(node, lstCheckedKeyID, treeList); } else { //DataRowView drv = treeList.GetDataRecordByNode(node) as DataRowView; MenusVM menusVM = treeList.GetDataRecordByNode(node) as MenusVM; var parentData = treeList.GetDataRecordByNode(node.ParentNode) as MenusVM; if (menusVM != null) { //string KeyFieldName = (string)drv["KeyFieldName"]; lstCheckedKeyID.Add(menusVM); if (!lstCheckedKeyID.Any(p => p.ID == parentData.ID)) { lstCheckedKeyID.Add(parentData); } } } } //GetCheckedData(node, lstCheckedKeyID, treeList); } }
private void sbtnSaveParent_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.teAddFormName.Text.Trim())) { XtraMessageBox.Show("Form Name is empty!", "提示", MessageBoxButtons.OK); return; } if (string.IsNullOrEmpty(this.teAddTabHeaderText.Text.Trim())) { XtraMessageBox.Show("Header Text is empty!", "提示", MessageBoxButtons.OK); return; } var check = this.ceParentStatus.Checked ? 1 : 0; MenusVM parents = this.slueParentName.EditValue as MenusVM; MenusVM vm = new MenusVM() { ParentID = 0, FormName = this.teAddFormName.Text.Trim(), TabHeaderText = this.teAddTabHeaderText.Text.Trim(), Status = check }; SaveMenus(vm); }
/// <summary> /// 新增角色 /// </summary> /// <param name="UserVM"></param> /// <returns></returns> public int AddMenus(MenusVM vm) { StringBuilder sb = new StringBuilder(); try { string sql = ""; int maxSortCode = 0; if (vm.ParentID != 0)//插入的是子菜单 { sql = @" begin try begin tran tr declare @maxSortCode int =0; select @maxSortCode=MAX([SortCode]) from [dbo].[Menus] where [ParentID]=@ParentID set @maxSortCode+=1; select @maxSortCode; INSERT INTO [dbo].[Menus] ([ParentID] ,[FormName] ,[TabHeaderText],[SortCode],[Status]) VALUES (@ParentID,@FormName,@TabHeaderText,@maxSortCode,@Status) commit tran tr end try begin catch ROLLBACK TRAN tr end catch "; } else//插入的是父节点 { sql = @" begin try begin tran tr declare @currentInsertID int =0; INSERT INTO [dbo].[Menus] ([ParentID] ,[FormName] ,[TabHeaderText],[SortCode],[Status]) VALUES (@ParentID,@FormName,@TabHeaderText,0,@Status) select @currentInsertID= ident_current('[RABC].[dbo].[Menus]'); update [dbo].[Menus] set [SortCode]=@currentInsertID*100 where ID=@currentInsertID; commit tran tr end try begin catch ROLLBACK TRAN tr end catch "; } List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ParentID", vm.ParentID)); parameters.Add(new SqlParameter("@FormName", vm.FormName)); parameters.Add(new SqlParameter("@TabHeaderText", vm.TabHeaderText)); parameters.Add(new SqlParameter("@Status", vm.Status)); return(SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql, parameters.ToArray())); } catch (Exception ex) { return(0); } }
/// <summary> /// 新增角色 /// </summary> /// <param name="UserVM"></param> /// <returns></returns> public int AddMenus(MenusVM vm) { return(_dal.AddMenus(vm)); }
public List <MenusVM> GetAllMenus(MenusVM vm) { return(_dal.GetAllMenus(vm)); }