form1.cs

一个学籍管理系统 以在某高校投入使用了

            this.statusBarPanel6.Name = "statusBarPanel6";
            // 
            // Form1
            // 
            this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
            this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
            this.ClientSize = new System.Drawing.Size(664, 309);
            this.Controls.Add(this.statusBar1);
            this.IsMdiContainer = true;
            this.Menu = this.mainMenu1;
            this.Name = "Form1";
            this.Text = "学生学籍管理系统";
            this.Load += new System.EventHandler(this.Form1_Load);
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel3)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel4)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel5)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.statusBarPanel6)).EndInit();
            this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main() 
		{
			Application.Run(new Form1());
		}

		private void Form1_Load(object sender, System.EventArgs e)
		{

			frmLogin f = new frmLogin();
			f.LoginEvent+=new prjLogin.frmLogin.LoginHandler(f_LoginEvent);
			f.ShowDialog();
		}
		

		private void f_LoginEvent(string user, string pur)
		{
			this.user=user;
			this.pur=pur;
			this.statusBarPanel2.Text=user;
			this.WindowState=System.Windows.Forms.FormWindowState.Maximized;
			this.statusBarPanel4.Text=DateTime.Now.ToShortDateString().ToString();
			this.statusBarPanel6.Text=DateTime.Now.ToShortTimeString().ToString();
			if(this.pur!="超级用户")
			{
				this.menuItem9.Enabled=false;
				this.menuItem11.Enabled=false;
			}
			string server;
			string uid;
			string pwd;
			FileStream fs = new FileStream("ClassData.txt",FileMode.Open,FileAccess.Read);
			StreamReader sr = new StreamReader(fs);
			server=sr.ReadLine();
			uid = sr.ReadLine();
			pwd=sr.ReadLine();
			this.parthWrit=sr.ReadLine();
		}

		private void menuItem9_Click(object sender, System.EventArgs e)
		{

			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddUser)
				{
					return;
				}
			}
			frmAddUser f = new frmAddUser();
			f.MdiParent = this;
			f.Show();

			
		}

		private void menuItem10_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmPwd)
				{
					return;
				}
			}
			frmPwd f = new frmPwd(this.user);
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem11_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs )
			{
				if(ff is frmEditUser)
				{
					return;
				}
			}
			frmEditUser f = new frmEditUser();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem16_Click(object sender, System.EventArgs e)
		{
			if(MessageBox.Show("确认退出","提示信息!",MessageBoxButtons.OKCancel,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2)==DialogResult.OK)
			{
				Application.Exit();
			}
		}

		private void menuItem17_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddSpec)
				{
					return;
				}
			}
			frmAddSpec f = new frmAddSpec();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem18_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is prjEditSpec)
				{
					return;
				}
			}
			prjEditSpec f = new prjEditSpec();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem19_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddClass)
				{
					return;
				}
			}
			frmAddClass f = new frmAddClass();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem20_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmClass)
				{
					return;
				}
			}
			frmClass f = new frmClass();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddPro)
				{
					return;
				}
			}
			frmAddPro f = new frmAddPro();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem21_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmPro)
				{
					return;
				}
			}
			frmPro f = new frmPro();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem22_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddStu)
				{
					return;
				}
			}
			frmAddStu f = new frmAddStu();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem23_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmStuInfo)
				{
					return;
				}
			}
			frmStuInfo f = new frmStuInfo();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem24_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmAddScore)
				{
					return;
				}
			}
			frmAddScore f = new frmAddScore();
			f.MdiParent=this;
			f.Show();
		}

		private void menuItem25_Click(object sender, System.EventArgs e)
		{
			Form[] fs = this.MdiChildren;
			foreach(Form ff in fs)
			{
				if(ff is frmEditScore)
				{
					return;
				}
			}
			frmEditScore f = new frmEditScore();
			f.MdiParent=this;
			f.Show();
		}

		
		/// <summary>
		/// 备份数据的方法
		/// </summary>
		private void BackData()
		{
			SaveFileDialog sfd = new SaveFileDialog();
			sfd.Filter = "*.bak|*.bak";

			
			if(sfd.ShowDialog()==DialogResult.OK)
			{
				string parth = sfd.FileName;
				string parth1=Directory.GetParent(parth).ToString();
				if(File.Exists(parth1+"\\ClassData.txt")==false)
				{
					File.Copy(this.parthWrit+"ClassData.txt",parth1+"\\ClassData.txt");
				}
				if(parth=="")
				{
					MessageBox.Show("请输入文件名！","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
				}
				else
				{
					string Sql = @"backup database Class to disk='"+parth+"'";
					c.EditData(Sql);
					MessageBox.Show("备份成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
				}
			}
		}

		/// <summary>
		/// 还原数据的方法
		/// </summary>
		private void RestorData()
		{
			OpenFileDialog sfd = new OpenFileDialog();
			sfd.Filter = "*.bak|*.bak";
			if(sfd.ShowDialog()==DialogResult.OK)
			{
				string parth = sfd.FileName;

				string parth1=Directory.GetParent(parth).ToString();
				if(File.Exists(parth1+"\\ClassData.txt")==false)
				{
					File.Copy(this.parthWrit+"ClassData.txt",parth1+"\\ClassData.txt");
				}
				if(parth=="")
				{
					MessageBox.Show("请选择文件！","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
				}
				else
				{
					
					string Sql = @"restore   database   Class   from   disk   = '"+parth+"'";
					c.EditData(Sql);
					MessageBox.Show("加载数据成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
					
				}
			}
		}
		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			 BackData();
		}

		private void menuItem14_Click(object sender, System.EventArgs e)
		{
			RestorData();
		}

        private void statusBar1_PanelClick(object sender, StatusBarPanelClickEventArgs e)
        {

        }
	}
}