mainfrm.cs

自己参考开发的程序,用C#编写的,还有很的功能没有实现,数据库的安全性也没有很好的解决好.

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

namespace 教务管理系统
{
	/// <summary>
	/// Form1 的摘要说明。
	/// </summary>
	public class MainForm : System.Windows.Forms.Form
	{
		private DataSet ds= new DataSet();
	//	private string sendStrSQL;
		private LinkDataBase link = new LinkDataBase();
	//	private string sendTableName = "用户权限表";
		private System.Windows.Forms.MainMenu mainMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.MenuItem menuItem2;
		private System.Windows.Forms.MenuItem menuItem3;
		private System.Windows.Forms.MenuItem menuItem4;
		private System.Windows.Forms.MenuItem menuItem5;
		private System.Windows.Forms.MenuItem menuItem6;
		private System.Windows.Forms.MenuItem menuItem7;
		private System.Windows.Forms.MenuItem menuItem8;
		private System.Windows.Forms.MenuItem menuItem11;
		private System.Windows.Forms.StatusBar statusBar1;
		private System.Windows.Forms.StatusBarPanel statusBarPanel1;
		private System.Windows.Forms.StatusBarPanel statusBarPanel2;
		private System.Windows.Forms.MenuItem menuItem9;
		private System.Windows.Forms.MenuItem menuItem10;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public MainForm()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.mainMenu1 = new System.Windows.Forms.MainMenu();
			this.menuItem1 = new System.Windows.Forms.MenuItem();
			this.menuItem2 = new System.Windows.Forms.MenuItem();
			this.menuItem3 = new System.Windows.Forms.MenuItem();
			this.menuItem4 = new System.Windows.Forms.MenuItem();
			this.menuItem5 = new System.Windows.Forms.MenuItem();
			this.menuItem6 = new System.Windows.Forms.MenuItem();
			this.menuItem7 = new System.Windows.Forms.MenuItem();
			this.menuItem8 = new System.Windows.Forms.MenuItem();
			this.menuItem9 = new System.Windows.Forms.MenuItem();
			this.menuItem11 = new System.Windows.Forms.MenuItem();
			this.statusBar1 = new System.Windows.Forms.StatusBar();
			this.statusBarPanel1 = new System.Windows.Forms.StatusBarPanel();
			this.statusBarPanel2 = new System.Windows.Forms.StatusBarPanel();
			this.menuItem10 = new System.Windows.Forms.MenuItem();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).BeginInit();
			this.SuspendLayout();
			// 
			// mainMenu1
			// 
			this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
																					  this.menuItem1,
																					  this.menuItem5,
																					  this.menuItem11});
			// 
			// menuItem1
			// 
			this.menuItem1.Index = 0;
			this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
																					  this.menuItem2,
																					  this.menuItem3,
																					  this.menuItem4,
																					  this.menuItem10});
			this.menuItem1.Text = "基础维护";
			// 
			// menuItem2
			// 
			this.menuItem2.Enabled = false;
			this.menuItem2.Index = 0;
			this.menuItem2.Text = "班级信息维护";
			this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
			// 
			// menuItem3
			// 
			this.menuItem3.Enabled = false;
			this.menuItem3.Index = 1;
			this.menuItem3.Text = "学生信息维护";
			this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
			// 
			// menuItem4
			// 
			this.menuItem4.Enabled = false;
			this.menuItem4.Index = 2;
			this.menuItem4.Text = "课程信息维护";
			this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
			// 
			// menuItem5
			// 
			this.menuItem5.Index = 1;
			this.menuItem5.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
																					  this.menuItem6,
																					  this.menuItem7,
																					  this.menuItem8,
																					  this.menuItem9});
			this.menuItem5.Text = "教学管理";
			// 
			// menuItem6
			// 
			this.menuItem6.Enabled = false;
			this.menuItem6.Index = 0;
			this.menuItem6.Text = "学生选课";
			this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
			// 
			// menuItem7
			// 
			this.menuItem7.Enabled = false;
			this.menuItem7.Index = 1;
			this.menuItem7.Text = "课表查询";
			this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
			// 
			// menuItem8
			// 
			this.menuItem8.Enabled = false;
			this.menuItem8.Index = 2;
			this.menuItem8.Text = "成绩输入";
			this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
			// 
			// menuItem9
			// 
			this.menuItem9.Enabled = false;
			this.menuItem9.Index = 3;
			this.menuItem9.Text = "成绩查询";
			this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
			// 
			// menuItem11
			// 
			this.menuItem11.Index = 2;
			this.menuItem11.Text = "退出系统";
			this.menuItem11.Click += new System.EventHandler(this.menuItem11_Click);
			// 
			// statusBar1
			// 
			this.statusBar1.Location = new System.Drawing.Point(0, 551);
			this.statusBar1.Name = "statusBar1";
			this.statusBar1.Panels.AddRange(new System.Windows.Forms.StatusBarPanel[] {
																						  this.statusBarPanel1,
																						  this.statusBarPanel2});
			this.statusBar1.ShowPanels = true;
			this.statusBar1.Size = new System.Drawing.Size(792, 22);
			this.statusBar1.TabIndex = 4;
			// 
			// statusBarPanel1
			// 
			this.statusBarPanel1.MinWidth = 200;
			this.statusBarPanel1.Text = "数据库课程设计";
			this.statusBarPanel1.Width = 200;
			// 
			// statusBarPanel2
			// 
			this.statusBarPanel2.Width = 500;
			// 
			// menuItem10
			// 
			this.menuItem10.Index = 3;
			this.menuItem10.Text = "用户管理";
			this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
			// 
			// MainForm
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(792, 573);
			this.Controls.Add(this.statusBar1);
			this.IsMdiContainer = true;
			this.Menu = this.mainMenu1;
			this.Name = "MainForm";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "【教务管理系统】";
			this.Load += new System.EventHandler(this.MainFrm_Load);
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main() 
		{
			//整个程序启动的时候先显示登陆框后显示主界面
			LoginFrm login=new LoginFrm();
			login.ShowDialog();
			if(LoginFrm.blCanLogin==true)
			{
				Application.Run(new MainForm());
			}
		}

		//------------创建窗体时，通过登录用户的名称和权限，设置可以访问的功能--------------
		private void MainFrm_Load(object sender, System.EventArgs e)
		{
			this.statusBarPanel2.Text ="   当前用户编号:  "+LoginFrm.strID+ "    当前用户: " + LoginFrm.strUser +"    级别: " + LoginFrm.strDepartment;
			//通过用户编号查询权限清单控制主窗体菜单使能状态
//			this.sendStrSQL = "SELECT 权限名称 from 权限清单 where 用户编号 = '" + LoginFrm.strUser +"'";
//			this.ds = this.link.SelectDataBase(sendStrSQL,sendTableName);
			//系统管理用户为特殊权限用户,他始终拥有所有权利
			if ( LoginFrm.strDepartment == "系统管理员")
			{
				this.menuItem1.Enabled = true;
				this.menuItem2.Enabled = true;
				this.menuItem3.Enabled = true;
				this.menuItem4.Enabled = true;
				this.menuItem5.Enabled = true;
				this.menuItem6.Enabled = true;
				this.menuItem7.Enabled = true;
				this.menuItem8.Enabled = true;
				this.menuItem9.Enabled = true;
				this.menuItem9.Enabled = true;
				this.menuItem11.Enabled = true;
			}
			else
			{
				//设置老师及学生的权限
				if(LoginFrm.strDepartment=="老师")
				{
					this.menuItem1.Enabled = true;
					this.menuItem4.Enabled = true;
					this.menuItem3.Enabled = true;
					this.menuItem7.Enabled = true;
					this.menuItem8.Enabled = true;
					this.menuItem5.Enabled = true;
					this.menuItem9.Enabled = true;
					this.menuItem11.Enabled = true;
				}
				else{
					this.menuItem5.Enabled = true;
					this.menuItem6.Enabled = true;
					this.menuItem7.Enabled = true;
					this.menuItem11.Enabled = true;
					this.menuItem9.Enabled = true;
				}
			}
		}

		//----------------------查询MDI子窗体是否存在-----------------------------
		private bool checkChildFrmExist(string childFrmName)
		{
			foreach(Form childFrm in this.MdiChildren)
			{
				if(childFrm.Name == childFrmName) //用子窗体的Name进行判断，如果存在则将他激活
				{
					if(childFrm.WindowState == FormWindowState.Minimized)
						childFrm.WindowState = FormWindowState.Normal;
					childFrm.Activate();
					return true;
				}
			}
			return false;
		}

		//-----------------显示班级信息设置窗体-----------------------
		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("ClassInfo") == true)
			{
				return;
			}
			ClassInfo newFrm=new ClassInfo();
			newFrm.MdiParent = this;
			newFrm.Show();		
		}

		//-----------------显示学生信息设置窗体-----------------------
		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("StudentInfo") == true)
			{
				return;
			}
			StudentInfo newFrm=new StudentInfo();
			newFrm.MdiParent = this;
			newFrm.Show();		
		}

		//-----------------显示课程信息设置窗体-----------------------
		private void menuItem4_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("CourseInfo") == true)
			{
				return;
			}
			CourseInfo newFrm=new CourseInfo();
			newFrm.MdiParent = this;
			newFrm.Show();		
		}

		//-----------------显示选课窗体-----------------------
		private void menuItem6_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("CourseElect") == true)
			{
				return;
			}
			CourseElect newFrm=new CourseElect();
			newFrm.MdiParent = this;
			newFrm.Show();			
		}

		//-----------------显示学生课表-----------------------
		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("CurriculumSchedule") == true)
			{
				return;
			}
			CurriculumSchedule newFrm=new CurriculumSchedule("");
			newFrm.MdiParent = this;
			newFrm.Show();			
		}

		//-----------------显示成绩输入窗体-----------------------
		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("ScoreInput") == true)
			{
				return;
			}
			ScoreInput newFrm=new ScoreInput();
			newFrm.MdiParent = this;
			newFrm.Show();			
		}

		//-----------------显示成绩查询窗体-----------------------
		private void menuItem9_Click(object sender, System.EventArgs e)
		{

			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("ViewScore") == true)
			{
				return;
			}
			ViewScore newFrm=new ViewScore();
			newFrm.MdiParent = this;
			newFrm.Show();			
		}
		private void menuItem10_Click(object sender, System.EventArgs e)
		{		
			if (this.checkChildFrmExist("popedom") == true)
			{
				return;
			}
			popedom newFrm=new popedom();
			newFrm.MdiParent = this;
			newFrm.Show();	
		}
		//-----------------退出系统-----------------------
		private void menuItem11_Click(object sender, System.EventArgs e)
		{
			if (MessageBox.Show("确实要退出系统吗?","询问",MessageBoxButtons.YesNo) == DialogResult.Yes)
			{
				this.Close();
			}
		}

	}
}