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