/// <summary>
/// 删除功能菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool delete(SeatManage.ClassModel.SysMenuInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete SysMenu ");
strSql.Append(" where MenuID=@MenuID");
SqlParameter[] parameters =
{
new SqlParameter("@MenuID", SqlDbType.Int)
};
parameters[0].Value = model.MenuID;
try
{
int row = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
//删除菜单按钮点击事件
protected void btnDel_Click(object sender, EventArgs e)
{
FineUI.CheckBoxField chkFild = (FineUI.CheckBoxField)GridSysMenu.FindColumn("CheckBoxField1");
SeatManage.ClassModel.SysMenuInfo modelSysMenuInfo = new SeatManage.ClassModel.SysMenuInfo();
int selectCount = GridSysMenu.SelectedRowIndexArray.Length;
if (selectCount > 0)
{
for (int i = 0; i < selectCount; i++)
{
int rowIndex = GridSysMenu.SelectedRowIndexArray[i];
FineUI.GridRow row = GridSysMenu.Rows[rowIndex] as FineUI.GridRow;
modelSysMenuInfo.MenuID = int.Parse(row.DataKeys[0].ToString());
if (row.DataKeys[1].ToString() == "一级菜单")
{
List <SeatManage.ClassModel.SysMenuInfo> listSysMenu = SeatManage.Bll.SysMenu.GetMenusList();
foreach (SeatManage.ClassModel.SysMenuInfo selectmenu in listSysMenu)
{
if (selectmenu.MenuID == modelSysMenuInfo.MenuID)
{
modelSysMenuInfo = selectmenu;
break;
}
}
foreach (SeatManage.ClassModel.SysMenuInfo childmenu in modelSysMenuInfo.ChildMenu)
{
if (!SeatManage.Bll.SysMenu.DeleteMenus(childmenu))
{
FineUI.Alert.ShowInTop("删除子菜单失败！");
BindSysMenu();
return;
}
}
if (SeatManage.Bll.SysMenu.DeleteMenus(modelSysMenuInfo))
{
FineUI.Alert.ShowInTop("删除成功！");
BindSysMenu();
}
else
{
FineUI.Alert.ShowInTop("删除失败！");
BindSysMenu();
}
}
else
{
if (SeatManage.Bll.SysMenu.DeleteMenus(modelSysMenuInfo))
{
FineUI.Alert.ShowInTop("删除成功！");
}
else
{
FineUI.Alert.ShowInTop("删除失败！");
}
}
}
BindSysMenu();
}
}
protected void GridSysMenu_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "ActionDelete")
{
SeatManage.ClassModel.SysMenuInfo modelSysMenuInfo = new SeatManage.ClassModel.SysMenuInfo();
modelSysMenuInfo.MenuID = Convert.ToInt32(GridSysMenu.Rows[e.RowIndex].DataKeys[0]);
if (GridSysMenu.Rows[e.RowIndex].DataKeys[1].ToString() == "一级菜单")
{
List <SeatManage.ClassModel.SysMenuInfo> listSysMenu = SeatManage.Bll.SysMenu.GetMenusList();
foreach (SeatManage.ClassModel.SysMenuInfo selectmenu in listSysMenu)
{
if (selectmenu.MenuID == modelSysMenuInfo.MenuID)
{
modelSysMenuInfo = selectmenu;
break;
}
}
foreach (SeatManage.ClassModel.SysMenuInfo childmenu in modelSysMenuInfo.ChildMenu)
{
if (!SeatManage.Bll.SysMenu.DeleteMenus(childmenu))
{
FineUI.Alert.ShowInTop("删除子菜单失败！");
BindSysMenu();
return;
}
}
if (SeatManage.Bll.SysMenu.DeleteMenus(modelSysMenuInfo))
{
FineUI.Alert.ShowInTop("删除成功！");
BindSysMenu();
}
else
{
FineUI.Alert.ShowInTop("删除失败！");
BindSysMenu();
}
}
else
{
if (SeatManage.Bll.SysMenu.DeleteMenus(modelSysMenuInfo))
{
FineUI.Alert.ShowInTop("删除成功！");
BindSysMenu();
}
else
{
FineUI.Alert.ShowInTop("删除失败！");
BindSysMenu();
}
}
}
}
/// <summary>
/// 更新功能菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SeatManage.ClassModel.SysMenuInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysMenu ");
strSql.Append(" set Mainnum=@Mainnum, ModSeq=@ModSeq, ItemSeq=@ItemSeq, MCaption=@MCaption, MenuImagePath=@MenuImagePath, MenuLv=@MenuLv");
strSql.Append(" where MenuID=@MenuID");
SqlParameter[] parameters =
{
new SqlParameter("@Mainnum", SqlDbType.NVarChar, 50),
new SqlParameter("@ModSeq", SqlDbType.NVarChar, 50),
new SqlParameter("@ItemSeq", SqlDbType.NVarChar, 50),
new SqlParameter("@MCaption", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuImagePath", SqlDbType.NVarChar, 50),
new SqlParameter("@MenuLv", SqlDbType.Int),
new SqlParameter("@MenuID", SqlDbType.Int)
};
parameters[0].Value = model.MainNum;
parameters[1].Value = model.FuncPageNum;
parameters[2].Value = model.Index;
parameters[3].Value = model.MenuName;
parameters[4].Value = model.ImageUrl;
parameters[5].Value = model.MenuLv;
parameters[6].Value = model.MenuID;
try
{
int row = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 加载菜单编辑数据
/// </summary>
protected void EditMenuShow()
{
string menuId = Request.QueryString["MenuID"];
List <SeatManage.ClassModel.SysMenuInfo> listSysMenuInfo = SeatManage.Bll.SysMenu.GetMenusList(menuId);
SeatManage.ClassModel.SysMenuInfo modelSysMenuInfo = new SeatManage.ClassModel.SysMenuInfo();
if (listSysMenuInfo != null && listSysMenuInfo.Count > 0)
{
txtMenuName.Text = listSysMenuInfo[0].MenuName;
NumberBoxSort.Text = listSysMenuInfo[0].Index.ToString();
txtMenuNum.Text = listSysMenuInfo[0].MainNum;
if (listSysMenuInfo[0].FuncPageNum == "0000")
{
ddlMainNum.Hidden = true;
ddlFunciPage.Hidden = true;
txtMenuNum.Hidden = false;
ddlMenuLv.SelectedValue = "first";
}
else
{
BindDdlMainNum();
BindDdlFuncDicpage();
txtMenuNum.Hidden = true;
txtMenuNum.Required = false;
ddlMainNum.Hidden = false;
ddlMainNum.SelectedValue = listSysMenuInfo[0].MainNum;
ddlFunciPage.Hidden = false;
ddlFunciPage.SelectedValue = listSysMenuInfo[0].FuncPageNum;
ddlMenuLv.SelectedValue = "second";
}
ddlMenuLv.Enabled = false;
}
else
{
FineUI.Alert.Show("菜单已删除");
btnSubmit.Enabled = false;
}
}
/// <summary>
/// 获取选中菜单list
/// </summary>
/// <returns></returns>
protected List <SeatManage.ClassModel.SysMenuInfo> GetCheckedMenu()
{
List <SeatManage.ClassModel.SysMenuInfo> listMenu = new List <SeatManage.ClassModel.SysMenuInfo>();
foreach (FineUI.TreeNode node in treeMenu.Nodes)
{
if (node.Checked == true)
{
SeatManage.ClassModel.SysMenuInfo modelSysMenu = new SeatManage.ClassModel.SysMenuInfo();
modelSysMenu.MenuID = Convert.ToInt32(node.NodeID);
listMenu.Add(modelSysMenu);
foreach (FineUI.TreeNode nodeChild in node.Nodes)
{
if (nodeChild.Checked == true)
{
SeatManage.ClassModel.SysMenuInfo modelSysMenuChild = new SeatManage.ClassModel.SysMenuInfo();
modelSysMenuChild.MenuID = Convert.ToInt32(nodeChild.NodeID);
listMenu.Add(modelSysMenuChild);
}
}
}
}
return(listMenu);
}
//提交按钮点击事件
protected void btnSubmit_OnClick(object sender, EventArgs e)
{
string flag = Request.QueryString["flag"];
string modSeq = "";
string menuName = txtMenuName.Text;
int index = Convert.ToInt32(NumberBoxSort.Text);
string mainNum = "";
int menuLv = 0;
if (ddlMenuLv.SelectedValue == "first")
{
mainNum = txtMenuNum.Text;
menuLv = 1;
modSeq = "0000";
}
else
{
mainNum = ddlMainNum.SelectedValue;
menuLv = 2;
modSeq = ddlFunciPage.SelectedValue;
}
SeatManage.ClassModel.SysMenuInfo modelSysMenu = new SeatManage.ClassModel.SysMenuInfo();
modelSysMenu.MainNum = mainNum;
modelSysMenu.MenuName = menuName;
modelSysMenu.MenuLv = menuLv;
modelSysMenu.Index = index;
modelSysMenu.FuncPageNum = modSeq;
switch (flag)
{
//新增菜单
case "add":
if (SeatManage.Bll.SysMenu.AddMenus(modelSysMenu))
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
FineUI.Alert.ShowInTop("添加成功！");
}
else
{
FineUI.Alert.ShowInTop("添加失败！");
}
break;
//修改菜单
case "edit":
modelSysMenu.ImageUrl = DBNull.Value.ToString();
modelSysMenu.MenuID = Convert.ToInt32(Request.QueryString["MenuID"]);
if (SeatManage.Bll.SysMenu.UpdateMenus(modelSysMenu))
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
FineUI.Alert.ShowInTop("修改成功！");
}
else
{
FineUI.Alert.ShowInTop("修改失败！");
}
break;
default:
FineUI.Alert.ShowInTop("未执行任何操作");
break;
}
}
