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