statusmanage.cs

c#写图书管理系统 界面美观 功能齐全 配有完整的数据库

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.Resources.ResourceManager resources = new System.Resources.ResourceManager(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();
			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(440, 176);
			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.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnStuMove.Image = ((System.Drawing.Image)(resources.GetObject("btnStuMove.Image")));
			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.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			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(16, 24);
			this.groupBox9.Name = "groupBox9";
			this.groupBox9.Size = new System.Drawing.Size(360, 53);
			this.groupBox9.TabIndex = 119;
			this.groupBox9.TabStop = false;
			// 
			// textID
			// 
			this.textID.Location = new System.Drawing.Point(88, 16);
			this.textID.Name = "textID";
			this.textID.Size = new System.Drawing.Size(80, 21);
			this.textID.TabIndex = 124;
			this.textID.Text = "";
			// 
			// label19
			// 
			this.label19.Location = new System.Drawing.Point(24, 19);
			this.label19.Name = "label19";
			this.label19.Size = new System.Drawing.Size(48, 23);
			this.label19.TabIndex = 123;
			this.label19.Text = "学生ID";
			// 
			// btnApply
			// 
			this.btnApply.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnApply.Image = ((System.Drawing.Image)(resources.GetObject("btnApply.Image")));
			this.btnApply.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnApply.Location = new System.Drawing.Point(208, 16);
			this.btnApply.Name = "btnApply";
			this.btnApply.Size = new System.Drawing.Size(56, 24);
			this.btnApply.TabIndex = 103;
			this.btnApply.Text = "确认";
			this.btnApply.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
			// 
			// groupBox7
			// 
			this.groupBox7.Controls.Add(this.label6);
			this.groupBox7.Controls.Add(this.dateTimePicker1);
			this.groupBox7.Controls.Add(this.label8);
			this.groupBox7.Controls.Add(this.comboLeaveType);
			this.groupBox7.Controls.Add(this.btnStuLeave);
			this.groupBox7.Location = new System.Drawing.Point(440, 24);
			this.groupBox7.Name = "groupBox7";
			this.groupBox7.Size = new System.Drawing.Size(248, 128);
			this.groupBox7.TabIndex = 118;
			this.groupBox7.TabStop = false;
			this.groupBox7.Text = "学生离校";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(40, 48);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(56, 23);
			this.label6.TabIndex = 113;
			this.label6.Text = "离校时间";
			// 
			// dateTimePicker1
			// 
			this.dateTimePicker1.CustomFormat = "";
			this.dateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Short;
			this.dateTimePicker1.Location = new System.Drawing.Point(104, 48);
			this.dateTimePicker1.Name = "dateTimePicker1";
			this.dateTimePicker1.Size = new System.Drawing.Size(88, 21);
			this.dateTimePicker1.TabIndex = 112;
			// 
			// label8
			// 
			this.label8.Location = new System.Drawing.Point(40, 16);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(56, 23);
			this.label8.TabIndex = 111;
			this.label8.Text = "离校种类";
			// 
			// comboLeaveType
			// 
			this.comboLeaveType.ForeColor = System.Drawing.SystemColors.Desktop;
			this.comboLeaveType.Items.AddRange(new object[] {
																"毕业",
																"结业",
																"退学",
																"开除"});
			this.comboLeaveType.Location = new System.Drawing.Point(104, 16);
			this.comboLeaveType.Name = "comboLeaveType";
			this.comboLeaveType.Size = new System.Drawing.Size(88, 20);
			this.comboLeaveType.TabIndex = 109;
			// 
			// btnStuLeave
			// 
			this.btnStuLeave.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnStuLeave.Image = ((System.Drawing.Image)(resources.GetObject("btnStuLeave.Image")));
			this.btnStuLeave.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnStuLeave.Location = new System.Drawing.Point(88, 88);
			this.btnStuLeave.Name = "btnStuLeave";
			this.btnStuLeave.Size = new System.Drawing.Size(72, 24);
			this.btnStuLeave.TabIndex = 97;
			this.btnStuLeave.Text = "学生离校";
			this.btnStuLeave.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnStuLeave.Click += new System.EventHandler(this.btnStuLeave_Click);
			// 
			// btnExit
			// 
			this.btnExit.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnExit.Image = ((System.Drawing.Image)(resources.GetObject("btnExit.Image")));
			this.btnExit.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExit.Location = new System.Drawing.Point(528, 480);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(56, 24);
			this.btnExit.TabIndex = 122;
			this.btnExit.Text = "退出";
			this.btnExit.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// button2
			// 
			this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.button2.Image = ((System.Drawing.Image)(resources.GetObject("button2.Image")));
			this.button2.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button2.Location = new System.Drawing.Point(528, 440);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(56, 24);
			this.button2.TabIndex = 123;
			this.button2.Text = "保存";
			this.button2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.lblStatus);
			this.groupBox1.Controls.Add(this.lblAge);
			this.groupBox1.Controls.Add(this.lblNation);
			this.groupBox1.Controls.Add(this.lblInDate);
			this.groupBox1.Controls.Add(this.lblNativePlace);
			this.groupBox1.Controls.Add(this.lblSex);
			this.groupBox1.Controls.Add(this.lblStuName);
			this.groupBox1.Controls.Add(this.label2);
			this.groupBox1.Controls.Add(this.label3);