543

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