📄 frmstudent.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using ExamSystem.BusinessFacade.TeacherFac;
using TeachersClient.StuManFrm;
namespace TeachersClient
{
/// <summary>
/// FrmStudent 的摘要说明。
/// </summary>
public class FrmStudent : System.Windows.Forms.Form
{
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.TreeView tvClass;
private System.Windows.Forms.DataGrid dgStudent;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
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;//记录树型目录的Index对应班级ID
private void addColumn(DataTable dt)
{
dt.Columns.Add("Sex");
for(int i=0;i<dt.Rows.Count;i++)
{
if(((bool)dt.Rows[i]["StuSex"])==false)
{
dt.Rows[i]["Sex"]="男";
}
else
{
dt.Rows[i]["Sex"]="女";
}
}
}
/// <summary>
/// 设置显示学生信息的DataGrid的样式
/// </summary>
/// <param name="tableName">映射的表名</param>
private void setStuStlye(string tableName)
{
dgStudent.TableStyles.Clear();
DataGridTableStyle dtStyle=new DataGridTableStyle();
dtStyle.MappingName=tableName;
GridColumnStylesCollection colStyles=dtStyle.GridColumnStyles;
dgStudent.TableStyles.Add(dtStyle);
colStyles[0].Width=0;
colStyles[4].Width=0;
colStyles[1].HeaderText="学号";
colStyles[2].HeaderText="姓名";
colStyles[3].HeaderText="出生日期";
colStyles[5].HeaderText="性别";
}
/// <summary>
/// 填充学生信息
/// </summary>
/// <param name="classID">班级ID</param>
private void fillStudents(string className)
{
StudentFac stuFac=new StudentFac();
DataSet ds=stuFac.getStuByClass(-1,className);
dgStudent.DataSource=ds.Tables[0];
addColumn(ds.Tables[0]);
setStuStlye(ds.Tables[0].TableName);
}
/// <summary>
/// 填充班级信息
/// </summary>
private void fillClasses()
{
tvClass.Nodes.Clear();
GradeFac grdFac=new GradeFac();
DataSet dsGrade=grdFac.getGrade(-1,"");
ClassFac clsFac=new ClassFac();
DataSet dsClass=clsFac.getClass(-1,"",-1);
DataView dvClass=dsClass.Tables[0].DefaultView;
for(int i=0;i<dsGrade.Tables[0].Rows.Count;i++)//穷举所有年级
{
TreeNode nodeGrade=new TreeNode(dsGrade.Tables[0].Rows[i][1].ToString());
tvClass.Nodes.Add(nodeGrade);
dvClass.RowFilter="Grade="+dsGrade.Tables[0].Rows[i][0].ToString();//过滤年级所属的班级
for(int k=0;k<dvClass.Count;k++)//把班级加到所属的年级下
{
TreeNode nodeClass=new TreeNode(dvClass[k][1].ToString());
nodeGrade.Nodes.Add(nodeClass);
}
}
}
public FrmStudent()
{
//
// 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.tvClass = new System.Windows.Forms.TreeView();
this.panel1 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.label1 = new System.Windows.Forms.Label();
this.panel3 = new System.Windows.Forms.Panel();
this.panel4 = new System.Windows.Forms.Panel();
this.dgStudent = new System.Windows.Forms.DataGrid();
this.label2 = new System.Windows.Forms.Label();
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.panel1.SuspendLayout();
this.panel2.SuspendLayout();
this.panel3.SuspendLayout();
this.panel4.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgStudent)).BeginInit();
this.SuspendLayout();
//
// tvClass
//
this.tvClass.Dock = System.Windows.Forms.DockStyle.Fill;
this.tvClass.ImageIndex = -1;
this.tvClass.Location = new System.Drawing.Point(0, 0);
this.tvClass.Name = "tvClass";
this.tvClass.SelectedImageIndex = -1;
this.tvClass.Size = new System.Drawing.Size(94, 263);
this.tvClass.TabIndex = 0;
this.tvClass.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.tvClass_AfterSelect);
//
// panel1
//
this.panel1.Controls.Add(this.panel2);
this.panel1.Controls.Add(this.label1);
this.panel1.Dock = System.Windows.Forms.DockStyle.Left;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(94, 279);
this.panel1.TabIndex = 1;
//
// panel2
//
this.panel2.Controls.Add(this.tvClass);
this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel2.Location = new System.Drawing.Point(0, 16);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(94, 263);
this.panel2.TabIndex = 2;
//
// label1
//
this.label1.BackColor = System.Drawing.SystemColors.Desktop;
this.label1.Dock = System.Windows.Forms.DockStyle.Top;
this.label1.Location = new System.Drawing.Point(0, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(94, 16);
this.label1.TabIndex = 1;
this.label1.Text = "班列表";
//
// panel3
//
this.panel3.Controls.Add(this.panel4);
this.panel3.Controls.Add(this.label2);
this.panel3.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel3.Location = new System.Drawing.Point(94, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(356, 279);
this.panel3.TabIndex = 2;
//
// panel4
//
this.panel4.Controls.Add(this.dgStudent);
this.panel4.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel4.Location = new System.Drawing.Point(0, 18);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(356, 261);
this.panel4.TabIndex = 1;
//
// dgStudent
//
this.dgStudent.CaptionVisible = false;
this.dgStudent.DataMember = "";
this.dgStudent.Dock = System.Windows.Forms.DockStyle.Fill;
this.dgStudent.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgStudent.Location = new System.Drawing.Point(0, 0);
this.dgStudent.Name = "dgStudent";
this.dgStudent.ReadOnly = true;
this.dgStudent.Size = new System.Drawing.Size(356, 261);
this.dgStudent.TabIndex = 0;
this.dgStudent.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dgStudent_Navigate);
//
// label2
//
this.label2.BackColor = System.Drawing.SystemColors.Desktop;
this.label2.Dock = System.Windows.Forms.DockStyle.Top;
this.label2.Location = new System.Drawing.Point(0, 0);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(356, 18);
this.label2.TabIndex = 0;
this.label2.Text = "学生信息";
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem2,
this.menuItem3,
this.menuItem4,
this.menuItem5});
this.menuItem1.Text = "学生管理";
//
// menuItem2
//
this.menuItem2.Index = 0;
this.menuItem2.Text = "添加学生";
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 = "添加班级";
//
// menuItem5
//
this.menuItem5.Index = 3;
this.menuItem5.Text = "添加年级";
//
// FrmStudent
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(450, 279);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel1);
this.Menu = this.mainMenu1;
this.Name = "FrmStudent";
this.Text = "学生信息";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.FrmStudent_Load);
this.panel1.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.panel3.ResumeLayout(false);
this.panel4.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dgStudent)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void FrmStudent_Load(object sender, System.EventArgs e)
{
fillClasses();
}
private void dgStudent_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
private void tvClass_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
TreeNode tmpNode=e.Node;
if(tmpNode.Parent!=null)
{
fillStudents(tmpNode.Text);
}
}
private void TextBox_TextChanged(object sender, EventArgs e)
{
TextBox tmp=(TextBox)sender;
MessageBox.Show(tmp.Text);
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
FrmAdd frmAdd=new FrmAdd();
frmAdd.ShowDialog();
if(frmAdd.HasAdd)
{
fillClasses();
dgStudent.DataSource=null;
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -