public DataTable SqlQueryForDataTatable(string sql, SqlParameter[] parameters = null)
{
DBController db = new DBController();
DataTable dt = new DataTable();
using (SqlConnection connection = new SqlConnection(db.Database.Connection.ConnectionString))
{
connection.ConnectionString = db.Database.Connection.ConnectionString;
connection.Open();
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
if (null != parameters)
{
foreach (var item in parameters)
{
cmd.Parameters.Add(item);
}
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
connection.Close();
}
return(dt);
}
private int ResolveXmlNodeList(IList <TreeNode> nodes, List <Menus> menusChild, List <Menus> menus)
{
// nodes 中渲染到页面上的节点个数
int nodeVisibleCount = 0;
foreach (Menus xmlNode in menusChild)
{
TreeNode node = new TreeNode();
// 是否叶子节点
bool isLeaf = xmlNode.have_child == 0;
bool currentNodeIsVisible = true;
string nodeText = "";
nodeText = xmlNode.Name;
int childVisibleCount = 0;
if (isLeaf)
{
}
else
{
// 递归
DBController db = new DBController();
List <Menus> menu = menus.Where(x => x.ParentID == xmlNode.ID).ToList();
childVisibleCount = ResolveXmlNodeList(node.Nodes, menu, menus);
if (childVisibleCount == 0)
{
currentNodeIsVisible = false;
}
else
{
// 存在搜索文本
if (!String.IsNullOrEmpty(_cookieSearchText))
{
// 展开节点
node.Expanded = true;
}
}
}
if (currentNodeIsVisible)
{
string name = xmlNode.Name;
string value = xmlNode.ID.ToString();
node.Text = name;
node.SetPropertyValue(name, value);
node.NavigateUrl = string.IsNullOrWhiteSpace(xmlNode.NavigateUrl) ? "" : xmlNode.NavigateUrl;
//node.NavigateUrl = "http://fineui.com/version_mvc/index.html?from=demo";
node.IconUrl = xmlNode.ImageUrl;
node.ToolTip = xmlNode.Name;
nodes.Add(node);
// 本子节点显示
nodeVisibleCount++;
// 示例数只计算叶子节点
if (isLeaf)
{
_examplesCount++;
}
}
}
return(nodeVisibleCount);
}
