frmmain.cs

c#编写“三层体系结构的应用-学员管理系统2(界”

			// 
			this.menuItem5.Index = 0;
			this.menuItem5.Text = "新建班级(&C)";
			this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
			// 
			// menuItem7
			// 
			this.menuItem7.Index = 1;
			this.menuItem7.Text = "科目管理(&S)";
			this.menuItem7.Click += new System.EventHandler(this.menuItem7_Click);
			// 
			// menuItem8
			// 
			this.menuItem8.Index = 2;
			this.menuItem8.Text = "建立课程(&R)";
			this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
			// 
			// menuItem2
			// 
			this.menuItem2.Index = 3;
			this.menuItem2.Text = "退出(&Q)";
			this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
			// 
			// menuItem3
			// 
			this.menuItem3.Index = 1;
			this.menuItem3.Text = "视图";
			// 
			// menuItem4
			// 
			this.menuItem4.Index = 2;
			this.menuItem4.Text = "帮助";
			// 
			// frmMain
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(632, 446);
			this.Controls.Add(this.pnlMain);
			this.Controls.Add(this.pnlLeft);
			this.Menu = this.mainMenu1;
			this.Name = "frmMain";
			this.Text = "学员管理系统";
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.Load += new System.EventHandler(this.frmMain_Load);
			this.pnlLeft.ResumeLayout(false);
			this.pnlMain.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

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

		private void frmMain_Load(object sender, System.EventArgs e)
		{
			GetClass();
			CreateCourseTemp();

		
		}

		private void GetClass()
		{
			lstClass.Items.Clear();
			this.statusBar1.Panels[1].Text = "正在获取班级信息...";
			Classs classs = new Classs();
			DataSet dataSet = new DataSet();
			try
			{
				dataSet = classs.SelectClass(
					-1,
					"");
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
			ColumnHeader columnHeader = new ColumnHeader();
			columnHeader.Text = "班级";
			lstClass.Columns.Add(columnHeader);
			
			columnHeader = new ColumnHeader();
			columnHeader.Text = "ClassId";
			lstClass.Columns.Add(columnHeader);
			lstClass.Columns[0].Width = lstClass.Width;
			lstClass.Columns[1].Width = 0;
			string[] sItems = new string[2];
 
			for(int i = 0; i < dataSet.Tables[0].Rows.Count; i ++)
			{
				DataRow row = dataSet.Tables[0].Rows[i];
				sItems[0] = row["ClassName"].ToString();
				sItems[1] = row["ClassId"].ToString();
				ListViewItem item = new ListViewItem(sItems, 0);
				lstClass.Items.Add(item);
			}
			classs.Dispose();
			this.statusBar1.Panels[1].Text = "ok";
		}	

		private void GetCourse()
		{
			int iClassId = -1;
			try
			{
				iClassId = Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].Text);
			}
			catch{}
			lstCourse.Items.Clear();
			DataSet dataSet = new DataSet();
			Courses courses = new Courses();
			try
			{
				dataSet = courses.SelectCourse(
					-1,
					iClassId,
					-1);
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
				Application.Exit();
			}
			for(int i = 0; i < dataSet.Tables[0].Rows.Count; i ++)
			{
				
				DataRow row = dataSet.Tables[0].Rows[i];
				string[] sItems = new string[2];
				sItems[0] = row["SubjectName"].ToString();
				sItems[1] = row["CourseId"].ToString();
				
				ListViewItem item = new ListViewItem(sItems, 2);
						
				lstCourse.Items.Add(item);
			}
			courses.Dispose();

		}

		private void CreateCourseTemp()
		{
			ColumnHeader columnHeader = new ColumnHeader();
			columnHeader.Text = "课程名称";
			lstCourse.Columns.Add(columnHeader);
		
			columnHeader = new ColumnHeader();
			columnHeader.Text = "CourseId";
			lstCourse.Columns.Add(columnHeader);
		}
		
		private void lstCourse_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		}


		private void lstClass_Click(object sender, System.EventArgs e)
		{
			GetCourse();
		}

		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			frmNewClass newClass = new frmNewClass();
			newClass.ShowDialog();
			GetClass();
		}

		private void lstClass_DoubleClick(object sender, System.EventArgs e)
		{
			frmUpdateClass updateClass = new frmUpdateClass(Convert.ToInt32(lstClass.SelectedItems[0].SubItems[1].Text));
			updateClass.ShowDialog();
			GetClass();
		}

		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			frmSubject subject = new frmSubject();
			subject.ShowDialog();
		}

		private void lstCourse_DoubleClick(object sender, System.EventArgs e)
		{
			int iCourseId = Convert.ToInt32(lstCourse.SelectedItems[0].SubItems[1].Text);
			frmUpdateCourse updateCourse = new frmUpdateCourse(iCourseId);
			updateCourse.ShowDialog();
			GetCourse();
		}

		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			Application.Exit();
		}

		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			frmNewCourse frmNewCourse = new frmNewCourse();
			frmNewCourse.ShowDialog();
			GetCourse();
		}


		private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		}

		private void dataGrid1_MouseLeave(object sender, System.EventArgs e)
		{
			System.Xml.Schema.XmlSchema xmlSchema = new System.Xml.Schema.XmlSchema();
			System.Xml.XmlConvert xmlConvert = new XmlConvert();
			//System.Xml.XmlDataDocument xmlDataDocument = new XmlDataDocument();
			System.Xml.XmlDocument xmlDocument = new XmlDocument();
			System.Xml.XmlReader xmlReader = new XmlReader();
			System.Xml.XmlWriter xmlWriter = new XmlWriter();
			PrintService printService =
		}

	}
}