WWW

using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using Microsoft.Practices.EnterpriseLibrary.Common;using Microsoft.Practices.EnterpriseLibrary.Data;using Microsoft.Practices.ObjectBuilder;using System.Data.Common;using System.Collections;public partial class FunctionModule_CatalogBrowse : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // 得到选中模组Code string ModuleCode = Request.QueryString["ModuleCode"].ToString(); //得到此模组Code在树状目录的第二级目录 string SecLayModuleCode = ""; if (ModuleCode.Length >= 2) { SecLayModuleCode = ModuleCode.Substring(0, 3); //取前面3位 } //根据第二级目录在左边展开目录树 LeftMenuCreateLay(ref MenuLeft, SecLayModuleCode); //在本网页显示选中模组的介绍信息 DataTable myDT = GetModuleContent(ModuleCode); if (myDT.Rows.Count > 0) { laHead.Text = myDT.Rows[0]["ModuleNameCN"].ToString(); laArticle.Text = myDT.Rows[0]["ModuleContent"].ToString(); } } } public void LeftMenuCreateLay(ref Menu MainMenu, string SecLayModuleCode) { MainMenu.Items.Clear(); MenuItem RootItem = new MenuItem(); //找出所有根目录 DataTable myDataTable = GetAllModuleByPModuleCode(SecLayModuleCode); for (int i = 0; i < myDataTable.Rows.Count; i++) { MenuItem myMenuItem = new MenuItem(); myMenuItem.Value = myDataTable.Rows[i]["ModuleCode"].ToString(); myMenuItem.Text = myDataTable.Rows[i]["ModuleNameCN"].ToString(); myMenuItem.NavigateUrl = myDataTable.Rows[i]["NavigateUrl"].ToString(); MainMenu.Items.Add(myMenuItem); LeftMenuCreateSubMenu(ref myMenuItem); } } public void LeftMenuCreateSubMenu(ref MenuItem parMenuItem) { //获取根目录的下级菜单 DataTable myDataTable = GetAllModuleByPModuleCode(parMenuItem.Value); for (int i = 0; i < myDataTable.Rows.Count; i++) { MenuItem myMenuItem = new MenuItem(); myMenuItem.Value = myDataTable.Rows[i]["ModuleCode"].ToString(); myMenuItem.Text = myDataTable.Rows[i]["ModuleNameCN"].ToString(); myMenuItem.NavigateUrl = myDataTable.Rows[i]["NavigateUrl"].ToString(); myMenuItem.Target = "MainDefault"; parMenuItem.ChildItems.Add(myMenuItem); //CreateSubMenu(myMenuItem); } } public DataTable GetAllModuleByPModuleCode(string PModuleCode) { Database db = DatabaseFactory.CreateDatabase(); string sql = "Select * from ModuleInfo where IsActive = 'True' and PModuleCode ='" + PModuleCode + "' "; DbCommand command = db.GetSqlStringCommand(sql); DataTable dt = db.ExecuteDataSet(command).Tables[0]; return dt; } public DataTable GetModuleContent(string ModuleCode) { Database db = DatabaseFactory.CreateDatabase(); string sql = " Select A.* , B.ModuleNameCN from ModuleContent as A " + " left join ModuleInfo as B on A.ModuleCode = B.ModuleCode " + " where A.IsValid = 'True' and A.ModuleCode ='" + ModuleCode + "' "; DbCommand command = db.GetSqlStringCommand(sql); DataTable dt = db.ExecuteDataSet(command).Tables[0]; return dt; } public DataTable GetModuleRightInfo(string ModuleCode) { Database db = DatabaseFactory.CreateDatabase(); string sql = " Select * from ModuleRightInfo " + " where ModuleCode ='" + ModuleCode + "' order by RightInfoOrder asc "; DbCommand command = db.GetSqlStringCommand(sql); DataTable dt = db.ExecuteDataSet(command).Tables[0]; return dt; } protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { }}<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CatalogBrowse.aspx.cs" Inherits="FunctionModule_CatalogBrowse" %><%@ Register src="FunctionModule/WebControls/FootBar.ascx" tagname="FootBar" tagprefix="uc1" %>

' /> ' /> ' Text='<%# Bind("RightInfoContent") %>' > " SelectCommand="SELECT [ModuleCode], [RightInfoOrder], [RightInfoContent], [NavigateUrl], [IsValid] FROM [ModuleRightInfo] WHERE (([IsValid] = @IsValid) AND ([ModuleCode] = @ModuleCode)) ORDER BY [RightInfoOrder]">