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