private string buildSubString(int parentId, FuncMenuCollection _menu)
{
StringBuilder _sbSubString = new StringBuilder();
foreach (var subMenu in _menu.Where(x=>x.ParentID==parentId))
{
_sbSubString.AppendFormat("<li ><a id='{0}?menuid={1}' onclick='changePage(this.id);' href='#'><span>{2}</span></a></li>", subMenu.Path,subMenu.ItemID, subMenu.Text);
}
return _sbSubString.ToString();
}
private void menuFunc( int userID)
{
StringBuilder _sbMenu = new StringBuilder();
MenuServiceClient _msc = new MenuServiceClient();
FuncMenuCollection _menuList = new FuncMenuCollection(_msc.QueryUserMenu(userID).GroupBy(x => x.Text).Select(x => x.First()));
var _menuParentList = _menuList.Where(x => x.ParentID == 0).ToList();
_sbMenu.Append("<div id='divFuncMenu'>");
_sbMenu.Append("<ul>");
for (int i = 0; i < _menuParentList.Count; i++)
{
var _menu = _menuParentList[i];
_sbMenu.Append(buildString(_menuList.Any(x => x.ParentID == _menu.ItemID), i == _menuParentList.Count, _menu, _menuList));
}
_sbMenu.Append("</ul></div>");
ltrFuncMenu.Text = _sbMenu.ToString();
}
private string buildString(bool hasChildren, bool lastMenu, FuncMenu _menu, FuncMenuCollection _menuCollection)
{
string _class = "";
StringBuilder _sbString = new StringBuilder();
if (lastMenu)
_class = "last";
if (hasChildren)
{
_sbString.AppendFormat("<li class='has-sub {0}'><a href='#'><span>{1}</span></a><ul>", _class,
_menu.Text);
_sbString.Append(buildSubString(_menu.ItemID, _menuCollection));
_sbString.Append("</ul></li>");
}
else
{
_sbString.AppendFormat(
"<li ><a id='{0}?menuid={1}' onclick='changePage(this.id);' href='#' ><span>{2}</span></a></li>",_menu.Path,_menu.ItemID,_menu.Text);
}
return _sbString.ToString();
}
public FuncMenuCollection GetMenuByUserID(string UserID)
{
FuncMenuCollection collection = new FuncMenuCollection();
string connectionString = ConfigurationManager.ConnectionStrings["AccountDataBase"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_SEL_Users_Menu";
SqlParameter _param = command.Parameters.Add("@User_ID", System.Data.SqlDbType.Int);
_param.Value = UserID;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
FuncMenu menu = new FuncMenu();
menu.ItemID = int.Parse(reader["ID"].ToString());
menu.Text = reader["Text"].ToString();
menu.Sort = int.Parse(reader["Sort"].ToString());
menu.ParentID = int.Parse(reader["ParentID"].ToString());
menu.Path = reader["Path"].ToString();
collection.Add(menu);
}
}
reader.Close();
}
return collection;
}
public FuncMenuCollection GetMenu(User user)
{
FuncMenuCollection collection = new FuncMenuCollection();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_Frank_TEST";
SqlParameter ColumnParam = command.Parameters.Add("@User_ID", System.Data.SqlDbType.Int);
ColumnParam.Value = user.UserID;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
FuncMenu menu = new FuncMenu();
menu.ItemID = Convert.ToInt32(reader["Menu_ID"]);
menu.Text = reader["Text"].ToString();
menu.Path = reader["Path"].ToString();
menu.ParentID = Convert.ToInt32(reader["ParentID"]);
menu.Sort = Convert.ToInt32(reader["Sort"]);
collection.Add(menu);
}
}
return collection;
}
}
