menus.ascx.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
    using System.Collections;
    using System.ComponentModel;
    using System.Web.SessionState;
    using System.Web.UI;
    using System.Configuration;
    using System.Data.SqlClient;
    using RWSB.DatabaseOper;


namespace RWSB
{
	/// <summary>
	///		Menus 的摘要说明。
	/// </summary>
	public partial class Menus : System.Web.UI.UserControl
	{

		//public string text;
		//DataTable BT,ST;

		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//text=MenuLoad();
            if (!this.IsPostBack)
            {
                
               this.Lbl_UserGrade.Text = "用户级别：" + Session["UserGrade"].ToString();

                if ((Session["UserName"] == null) || (Session["UserName"] == ""))
                {
                this.Lbl_UserName.Text = "当前用户：浏览用户";
                }
                else
                {
                 this.Lbl_UserName.Text = "当前用户：" + Session["UserName"];
                }

                 this.Lbl_UserBmName.Text = "所属部门：" + Session["userbmmc"];
            }
		}

		/*private string MenuLoad()
		{
			//填充树干的内容
			string trees="",bs="";
			int i=1;
			BT=DBOperate.SelectFormForum("SELECT bcid, bcname, Enable FROM BClass WHERE (Enable = 1)");
			ST=DBOperate.SelectFormForum("SELECT scid, bcid, scname, Enable FROM SClass WHERE (Enable = 1)");
			DataRow [] drs = BT.Select("");

			foreach( DataRow r in drs )
			{
				trees+="<TABLE border=0 cellPadding=0 cellSpacing=0><TR height=2><TD></TD></TR></TABLE><TABLE width=158 border=0 align='center' cellPadding=0 cellSpacing=0 bgcolor=#FFFFFF><TBODY>";
				bs="<A href="+"BigcalssList.aspx?BID="+r["bcid"].ToString()+" target='mainFrame'>"+r["bcname"].ToString()+"</A>";
				trees+="<TR><TD height=25 background='image/menudown.gif' id='imgmenu"+i+"' style='CURSOR: hand' onclick='showsubmenu("+i+")'>&nbsp;&nbsp;<SPAN>"+bs+"</SPAN></TD></TR>	<TR><TD id='submenu"+i+"' style='DISPLAY: none'><DIV align='center'><TABLE width='90%' cellPadding=0 cellSpacing=3><TBODY>";
				string parentid=r["bcid"].ToString();
				trees+=CreateNode(parentid)+"</TBODY></TABLE></DIV></TD></TR></TBODY></TABLE>";
				i++;
			}
			return trees;
		}	

		private string CreateNode(string parentid)
		{
			//填充树枝的内容
			string Nodes="";
			DataRow [] drsr = ST.Select("bcid = "+parentid);
			foreach( DataRow rw in drsr )
			{
				Nodes=Nodes+"<TR><TD><FONT color=#ff0000>·</FONT><A href="+"Mainlist.aspx"+"?solved=0&BID="+ rw["bcid"].ToString() +"&SID="+ rw["scid"].ToString()+"&Page=1 target='mainFrame'>"+rw["scname"].ToString()+"</A></TD></TR>";
			}			
			return Nodes;
		}*/
	#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		设计器支持所需的方法 - 不要使用代码编辑器
		///		修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{

		}
		#endregion
	}
}