statusmanage.cs

c# + sql2000 学生管理系统

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

using System.Data;
using System.Data.SqlClient;
using StudentManage.DataLevel;
using StudentManage.BussinessRule;

namespace StudentManage.UILevel
{
	/// <summary>
	/// StatusManage 的摘要说明。
	/// </summary>
	public class StatusManage : System.Windows.Forms.Form
	{
		private System.Windows.Forms.GroupBox groupBox10;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label23;
		private System.Windows.Forms.GroupBox groupBox9;
		private System.Windows.Forms.GroupBox groupBox7;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label8;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		private string originDep;
		private string originCla;		
		
		private System.Windows.Forms.ComboBox comboClass;
		private System.Windows.Forms.ComboBox comboDepartment;
		private System.Windows.Forms.Button btnApply;
		


		private string selectStr;
		private SqlConnection Connection1=null;
		private SqlCommand  Command1=null;
		private SqlDataReader DataReader1=null;
		private SqlDataAdapter dataAdapter1=null;								
		
		private System.Windows.Forms.Button btnExit;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label lblClass;
		private System.Windows.Forms.Label lblDepartment;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.TextBox textID;
		private System.Windows.Forms.Label lblStuName;
		private System.Windows.Forms.Label lblSex;
		private System.Windows.Forms.Label lblNativePlace;
		private System.Windows.Forms.Label lblInDate;
		private System.Windows.Forms.Label lblNation;
		private System.Windows.Forms.Label lblAge;
		private System.Windows.Forms.Label lblStatus;
		private System.Windows.Forms.DateTimePicker dateTimePicker2;
		private System.Windows.Forms.DateTimePicker dateTimePicker1;
		private System.Windows.Forms.ComboBox comboLeaveType;				
		private string commandStr;
		private System.Windows.Forms.Button btnStuMove;
		private System.Windows.Forms.Button btnStuLeave;				

		BussinessRule.StatusManage statusManage=new BussinessRule.StatusManage();
				

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

			this.selectStr="select * from Student";
			this.Connection1=new SqlConnection(DataLevel.Connection.ConnString);
			this.Command1=new SqlCommand();		
			this.Command1.Connection=this.Connection1;						
			
			


			//
			// 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()
		{
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(StatusManage));
            this.groupBox10 = new System.Windows.Forms.GroupBox();
            this.label1 = new System.Windows.Forms.Label();
            this.label17 = new System.Windows.Forms.Label();
            this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
            this.label23 = new System.Windows.Forms.Label();
            this.btnStuMove = new System.Windows.Forms.Button();
            this.comboClass = new System.Windows.Forms.ComboBox();
            this.comboDepartment = new System.Windows.Forms.ComboBox();
            this.groupBox9 = new System.Windows.Forms.GroupBox();
            this.textID = new System.Windows.Forms.TextBox();
            this.label19 = new System.Windows.Forms.Label();
            this.btnApply = new System.Windows.Forms.Button();
            this.groupBox7 = new System.Windows.Forms.GroupBox();
            this.label6 = new System.Windows.Forms.Label();
            this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
            this.label8 = new System.Windows.Forms.Label();
            this.comboLeaveType = new System.Windows.Forms.ComboBox();
            this.btnStuLeave = new System.Windows.Forms.Button();
            this.btnExit = new System.Windows.Forms.Button();
            this.button2 = new System.Windows.Forms.Button();
            this.groupBox1 = new System.Windows.Forms.GroupBox();
            this.lblStatus = new System.Windows.Forms.Label();
            this.lblAge = new System.Windows.Forms.Label();
            this.lblNation = new System.Windows.Forms.Label();
            this.lblInDate = new System.Windows.Forms.Label();
            this.lblNativePlace = new System.Windows.Forms.Label();
            this.lblSex = new System.Windows.Forms.Label();
            this.lblStuName = new System.Windows.Forms.Label();
            this.label2 = new System.Windows.Forms.Label();
            this.label3 = new System.Windows.Forms.Label();
            this.lblClass = new System.Windows.Forms.Label();
            this.lblDepartment = new System.Windows.Forms.Label();
            this.label16 = new System.Windows.Forms.Label();
            this.label14 = new System.Windows.Forms.Label();
            this.label12 = new System.Windows.Forms.Label();
            this.label11 = new System.Windows.Forms.Label();
            this.pictureBox1 = new System.Windows.Forms.PictureBox();
            this.label9 = new System.Windows.Forms.Label();
            this.label7 = new System.Windows.Forms.Label();
            this.label4 = new System.Windows.Forms.Label();
            this.label5 = new System.Windows.Forms.Label();
            this.groupBox10.SuspendLayout();
            this.groupBox9.SuspendLayout();
            this.groupBox7.SuspendLayout();
            this.groupBox1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
            this.SuspendLayout();
            // 
            // groupBox10
            // 
            this.groupBox10.Controls.Add(this.label1);
            this.groupBox10.Controls.Add(this.label17);
            this.groupBox10.Controls.Add(this.dateTimePicker2);
            this.groupBox10.Controls.Add(this.label23);
            this.groupBox10.Controls.Add(this.btnStuMove);
            this.groupBox10.Controls.Add(this.comboClass);
            this.groupBox10.Controls.Add(this.comboDepartment);
            this.groupBox10.Location = new System.Drawing.Point(32, 253);
            this.groupBox10.Name = "groupBox10";
            this.groupBox10.Size = new System.Drawing.Size(248, 192);
            this.groupBox10.TabIndex = 120;
            this.groupBox10.TabStop = false;
            this.groupBox10.Text = "学生调动";
            // 
            // label1
            // 
            this.label1.Location = new System.Drawing.Point(8, 56);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(56, 23);
            this.label1.TabIndex = 120;
            this.label1.Text = "调到班级";
            // 
            // label17
            // 
            this.label17.Location = new System.Drawing.Point(8, 88);
            this.label17.Name = "label17";
            this.label17.Size = new System.Drawing.Size(56, 23);
            this.label17.TabIndex = 113;
            this.label17.Text = "调动时间";
            // 
            // dateTimePicker2
            // 
            this.dateTimePicker2.CustomFormat = "";
            this.dateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Short;
            this.dateTimePicker2.Location = new System.Drawing.Point(72, 88);
            this.dateTimePicker2.Name = "dateTimePicker2";
            this.dateTimePicker2.Size = new System.Drawing.Size(120, 21);
            this.dateTimePicker2.TabIndex = 112;
            // 
            // label23
            // 
            this.label23.Location = new System.Drawing.Point(8, 24);
            this.label23.Name = "label23";
            this.label23.Size = new System.Drawing.Size(56, 23);
            this.label23.TabIndex = 111;
            this.label23.Text = "调到院系";
            // 
            // btnStuMove
            // 
            this.btnStuMove.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
            this.btnStuMove.Location = new System.Drawing.Point(96, 136);
            this.btnStuMove.Name = "btnStuMove";
            this.btnStuMove.Size = new System.Drawing.Size(80, 24);
            this.btnStuMove.TabIndex = 115;
            this.btnStuMove.Text = "学生调动";
            this.btnStuMove.Click += new System.EventHandler(this.btnStuMove_Click);
            // 
            // comboClass
            // 
            this.comboClass.Location = new System.Drawing.Point(72, 56);
            this.comboClass.Name = "comboClass";
            this.comboClass.Size = new System.Drawing.Size(120, 20);
            this.comboClass.TabIndex = 118;
            // 
            // comboDepartment
            // 
            this.comboDepartment.Location = new System.Drawing.Point(72, 24);
            this.comboDepartment.Name = "comboDepartment";
            this.comboDepartment.Size = new System.Drawing.Size(120, 20);
            this.comboDepartment.TabIndex = 117;
            this.comboDepartment.SelectedIndexChanged += new System.EventHandler(this.comboDepartment_SelectedIndexChanged);
            // 
            // groupBox9
            // 
            this.groupBox9.Controls.Add(this.textID);
            this.groupBox9.Controls.Add(this.label19);
            this.groupBox9.Controls.Add(this.btnApply);
            this.groupBox9.Location = new System.Drawing.Point(32, 24);
            this.groupBox9.Name = "groupBox9";
            this.groupBox9.Size = new System.Drawing.Size(248, 53);
            this.groupBox9.TabIndex = 119;
            this.groupBox9.TabStop = false;
            // 
            // textID
            // 
            this.textID.Location = new System.Drawing.Point(72, 16);
            this.textID.Name = "textID";
            this.textID.Size = new System.Drawing.Size(80, 21);
            this.textID.TabIndex = 124;
            // 
            // label19
            //