protected void LoadSubTreeView(TreeNode currentRootNode,Menuitem currentRootMenuItem,List<Menuitem> menuItems)
{
var subMenuItems = menuItems.Where(p => p.Parentmenuid == currentRootMenuItem.Menuid).ToList();
if(subMenuItems.Count==0){return;}
foreach (var subMenuItem in subMenuItems)
{
var currentNode = new TreeNode(subMenuItem.Menuname, subMenuItem.Menuid);
currentNode.ShowCheckBox = true;
currentNode.Checked = !string.IsNullOrEmpty(subMenuItem.Roleid);
LoadSubTreeView(currentNode, subMenuItem, menuItems);
currentRootNode.ChildNodes.Add(currentNode);
}
}
public Menuitem CreateMenuitem(Menuitem info)
{
try
{
Management.BeginTransaction();
Management.CreateMenuitem(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Menuitem CreateMenuitem(Menuitem info)
{
try
{
string sqlCommand = @"INSERT INTO ""MENUITEM"" (""MENUID"",""MENUNAME"",""PARENTMENUID"",""MENUADDRESS"",""ORDERBY"",""FUNCTIONID"",""BUTTONID"") VALUES (:Menuid,:Menuname,:Parentmenuid,:Menuaddress,:Orderby,:Functionid,:Buttonid)";
this.Database.AddInParameter(":Menuid", info.Menuid);//DBType:VARCHAR2
this.Database.AddInParameter(":Menuname", info.Menuname);//DBType:NVARCHAR2
this.Database.AddInParameter(":Parentmenuid", info.Parentmenuid);//DBType:VARCHAR2
this.Database.AddInParameter(":Menuaddress", info.Menuaddress);//DBType:VARCHAR2
this.Database.AddInParameter(":Orderby", info.Orderby);//DBType:NUMBER
this.Database.AddInParameter(":Functionid", info.Functionid);//DBType:VARCHAR2
this.Database.AddInParameter(":Buttonid", info.Buttonid);//DBType:VARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
public Menuitem UpdateMenuitemByMenuid(Menuitem info)
{
try
{
this.Database.AddInParameter(":Menuid", info.Menuid);//DBType:VARCHAR2
this.Database.AddInParameter(":Menuname", info.Menuname);//DBType:NVARCHAR2
this.Database.AddInParameter(":Parentmenuid", info.Parentmenuid);//DBType:VARCHAR2
this.Database.AddInParameter(":Menuaddress", info.Menuaddress);//DBType:VARCHAR2
this.Database.AddInParameter(":Orderby", info.Orderby);//DBType:NUMBER
this.Database.AddInParameter(":Functionid", info.Functionid);//DBType:VARCHAR2
this.Database.AddInParameter(":Buttonid", info.Buttonid);//DBType:VARCHAR2
string sqlCommand = @"UPDATE ""MENUITEM"" SET ""MENUNAME""=:Menuname , ""PARENTMENUID""=:Parentmenuid , ""MENUADDRESS""=:Menuaddress , ""ORDERBY""=:Orderby , ""FUNCTIONID""=:Functionid , ""BUTTONID""=:Buttonid WHERE ""MENUID""=:Menuid";
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
