public static List <Model.mdlSubMenu> GetSubMenu(string type, string menuID, string roleID)
{
var listMenu = new List <Model.mdlSubMenu>();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@MenuID", SqlDbType = SqlDbType.NVarChar, Value = menuID
},
new SqlParameter()
{
ParameterName = "@Type", SqlDbType = SqlDbType.NVarChar, Value = type
},
new SqlParameter()
{
ParameterName = "@RoleID", SqlDbType = SqlDbType.NVarChar, Value = roleID
}
};
DataTable dtProduct = Manager.DataFacade.DTSQLCommand("select a.RoleID,a.MenuID,b.MenuName,b.MenuUrl,b.Type from AccessRole a inner join Menu b on a.MenuID = b.MenuID where a.RoleID = @RoleID AND b.MenuID LIKE 'S%' AND a.IsAccess = 1 AND Type = @Type AND MenuUrl != ''", sp);
foreach (DataRow row in dtProduct.Rows)
{
var mdlMenu = new Model.mdlSubMenu();
mdlMenu.menu = row["MenuID"].ToString();
mdlMenu.name = row["MenuName"].ToString();
mdlMenu.url = row["MenuUrl"].ToString();
mdlMenu.type = row["Type"].ToString();
listMenu.Add(mdlMenu);
}
return(listMenu);
}
public static List <Model.mdlSubMenu> GetEditableMenu(string lRoleID, string lIsModify)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@RoleID", SqlDbType = SqlDbType.NVarChar, Value = lRoleID
},
new SqlParameter()
{
ParameterName = "@IsModify", SqlDbType = SqlDbType.Bit, Value = lIsModify
},
};
DataTable dtMenu = DataFacade.DTSQLCommand(@"SELECT MenuID,MenuName FROM Menu where MenuID in (select menuid from accessrole where RoleID=@RoleID AND IsModify=@IsModify)", sp);
var mdlMenuList = new List <Model.mdlSubMenu>();
foreach (DataRow row in dtMenu.Rows)
{
var mdlMenu = new Model.mdlSubMenu();
mdlMenu.menu = row["MenuID"].ToString();
mdlMenu.name = row["MenuName"].ToString();
mdlMenuList.Add(mdlMenu);
}
return(mdlMenuList);
}
public static List <Model.mdlSubMenu> LoadSubMenu(string menuID, string menutype)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
};
var mdlSubMenuList = new List <Model.mdlSubMenu>();
if (menuID.StartsWith("M"))
{
DataTable dtSubMenu = Manager.DataFacade.DTSQLCommand(@"SELECT MenuName, MenuID
FROM Menu
WHERE MenuID='" + menuID + "' or Type='" + menutype + "'", sp);
foreach (DataRow row in dtSubMenu.Rows)
{
var mdlSubMenu = new Model.mdlSubMenu();
mdlSubMenu.name = row["MenuName"].ToString();
mdlSubMenu.menu = row["MenuID"].ToString();
if (mdlSubMenu.menu.StartsWith("M"))
{
mdlSubMenu.name = row["MenuName"].ToString();
}
else
{
mdlSubMenu.name = " - " + row["MenuName"].ToString();
}
mdlSubMenuList.Add(mdlSubMenu);
}
}
else
{
DataTable dtSubMenu = Manager.DataFacade.DTSQLCommand(@"SELECT MenuName, MenuID
FROM Menu
WHERE (MenuID='" + menuID + "' AND Type='" + menutype + "') OR (MenuID LIKE 'M%' AND Type='" + menutype + "')", sp);
foreach (DataRow row in dtSubMenu.Rows)
{
var mdlSubMenu = new Model.mdlSubMenu();
mdlSubMenu.name = row["MenuName"].ToString();
mdlSubMenu.menu = row["MenuID"].ToString();
if (mdlSubMenu.menu.StartsWith("M"))
{
mdlSubMenu.name = row["MenuName"].ToString();
}
else
{
mdlSubMenu.name = " - " + row["MenuName"].ToString();
}
mdlSubMenuList.Add(mdlSubMenu);
}
}
return(mdlSubMenuList);
}
public static List <Model.mdlSubMenu> GetSubMenu(string menuID)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
};
DataTable dtSubMenu = DataFacade.DTSQLCommand("SELECT MenuID,MenuName FROM Menu where Type in (select type from menu where menuid = '" + menuID + "') and MenuID <> '" + menuID + "' ", sp);
var mdlSubMenuList = new List <Model.mdlSubMenu>();
foreach (DataRow row in dtSubMenu.Rows)
{
var mdlSubMenu = new Model.mdlSubMenu();
mdlSubMenu.menu = row["MenuID"].ToString();
mdlSubMenu.name = " - " + row["MenuName"].ToString();
mdlSubMenuList.Add(mdlSubMenu);
}
return(mdlSubMenuList);
}
public static List <Model.mdlSubMenu> GetAccessSubMenu(string lRoleID, string menuID)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
};
DataTable dtSubMenu = DataFacade.DTSQLCommand(@"SELECT MenuID,MenuName FROM Menu where Type in (select Type from Menu where menuid = '" + menuID + "') and MenuID <> '" + menuID + @"' AND
MenuID IN (SELECT MenuID from AccessRole where IsAccess = 'true' and RoleID = '" + lRoleID + "')", sp);
var mdlSubMenuList = new List <Model.mdlSubMenu>();
foreach (DataRow row in dtSubMenu.Rows)
{
var mdlSubMenu = new Model.mdlSubMenu();
mdlSubMenu.menu = row["MenuID"].ToString();
mdlSubMenu.name = " - " + row["MenuName"].ToString();
mdlSubMenuList.Add(mdlSubMenu);
}
return(mdlSubMenuList);
}
