levelform.cs

《数据库原理及应用》-刘玉宝主编-源代码

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

namespace KTMIS
{
	/// <summary>
	/// Level 的摘要说明。
	/// </summary>
	public class Level : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Button returnBtn;
		private System.Windows.Forms.DataGrid LeveldataGrid;
		private System.Windows.Forms.Label Levellabel;
		private System.Windows.Forms.TextBox LeveltextBox;
		private System.Windows.Forms.Button selectBtn;
		private System.Windows.Forms.Button deleteBtn;
		private System.Windows.Forms.Button updateBtn;
		private System.Windows.Forms.Button addBtn;

		private SqlConnection LevelConnection = null;
		private SqlCommand LevelSelectCommand = null;
		private SqlCommand LevelDeleteCommand = null;
		private SqlDataAdapter LevelDataAdapter = null;
		private DataSet ds = null;
		private string sqlString = null; 
		private int Row = -1;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Level()
		{
			//
			// 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.returnBtn = new System.Windows.Forms.Button();
			this.LeveldataGrid = new System.Windows.Forms.DataGrid();
			this.Levellabel = new System.Windows.Forms.Label();
			this.LeveltextBox = new System.Windows.Forms.TextBox();
			this.selectBtn = new System.Windows.Forms.Button();
			this.deleteBtn = new System.Windows.Forms.Button();
			this.updateBtn = new System.Windows.Forms.Button();
			this.addBtn = new System.Windows.Forms.Button();
			((System.ComponentModel.ISupportInitialize)(this.LeveldataGrid)).BeginInit();
			this.SuspendLayout();
			// 
			// returnBtn
			// 
			this.returnBtn.Location = new System.Drawing.Point(552, 31);
			this.returnBtn.Name = "returnBtn";
			this.returnBtn.Size = new System.Drawing.Size(120, 32);
			this.returnBtn.TabIndex = 15;
			this.returnBtn.Text = "返回";
			this.returnBtn.Click += new System.EventHandler(this.returnBtn_Click);
			// 
			// LeveldataGrid
			// 
			this.LeveldataGrid.DataMember = "";
			this.LeveldataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.LeveldataGrid.Location = new System.Drawing.Point(24, 127);
			this.LeveldataGrid.Name = "LeveldataGrid";
			this.LeveldataGrid.ReadOnly = true;
			this.LeveldataGrid.Size = new System.Drawing.Size(664, 328);
			this.LeveldataGrid.TabIndex = 14;
			this.LeveldataGrid.MouseDown += new System.Windows.Forms.MouseEventHandler(this.LeveldataGrid_MouseDown);
			this.LeveldataGrid.MouseUp += new System.Windows.Forms.MouseEventHandler(this.LeveldataGrid_MouseUp);
			// 
			// Levellabel
			// 
			this.Levellabel.Location = new System.Drawing.Point(32, 79);
			this.Levellabel.Name = "Levellabel";
			this.Levellabel.Size = new System.Drawing.Size(280, 32);
			this.Levellabel.TabIndex = 13;
			this.Levellabel.Text = "请输入所要查询的级别名称：";
			// 
			// LeveltextBox
			// 
			this.LeveltextBox.Location = new System.Drawing.Point(320, 79);
			this.LeveltextBox.Name = "LeveltextBox";
			this.LeveltextBox.Size = new System.Drawing.Size(200, 30);
			this.LeveltextBox.TabIndex = 12;
			this.LeveltextBox.Text = "";
			// 
			// selectBtn
			// 
			this.selectBtn.Location = new System.Drawing.Point(544, 79);
			this.selectBtn.Name = "selectBtn";
			this.selectBtn.Size = new System.Drawing.Size(96, 32);
			this.selectBtn.TabIndex = 11;
			this.selectBtn.Text = "查询";
			this.selectBtn.Click += new System.EventHandler(this.selectBtn_Click);
			// 
			// deleteBtn
			// 
			this.deleteBtn.Location = new System.Drawing.Point(376, 31);
			this.deleteBtn.Name = "deleteBtn";
			this.deleteBtn.Size = new System.Drawing.Size(120, 32);
			this.deleteBtn.TabIndex = 10;
			this.deleteBtn.Text = "删除";
			this.deleteBtn.Click += new System.EventHandler(this.deleteBtn_Click);
			// 
			// updateBtn
			// 
			this.updateBtn.Location = new System.Drawing.Point(208, 31);
			this.updateBtn.Name = "updateBtn";
			this.updateBtn.Size = new System.Drawing.Size(120, 32);
			this.updateBtn.TabIndex = 9;
			this.updateBtn.Text = "修改";
			this.updateBtn.Click += new System.EventHandler(this.updateBtn_Click);
			// 
			// addBtn
			// 
			this.addBtn.Location = new System.Drawing.Point(40, 31);
			this.addBtn.Name = "addBtn";
			this.addBtn.Size = new System.Drawing.Size(120, 32);
			this.addBtn.TabIndex = 8;
			this.addBtn.Text = "添加";
			this.addBtn.Click += new System.EventHandler(this.addBtn_Click);
			// 
			// Level
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(11, 23);
			this.ClientSize = new System.Drawing.Size(720, 478);
			this.Controls.Add(this.returnBtn);
			this.Controls.Add(this.LeveldataGrid);
			this.Controls.Add(this.Levellabel);
			this.Controls.Add(this.LeveltextBox);
			this.Controls.Add(this.selectBtn);
			this.Controls.Add(this.deleteBtn);
			this.Controls.Add(this.updateBtn);
			this.Controls.Add(this.addBtn);
			this.Font = new System.Drawing.Font("宋体", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.Name = "Level";
			this.Text = "级别信息维护";
			this.Load += new System.EventHandler(this.Level_Load);
			((System.ComponentModel.ISupportInitialize)(this.LeveldataGrid)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void LeveldataGrid_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			DataGrid myGrid = (DataGrid) sender;
			DataGrid.HitTestInfo hti;
			hti = myGrid.HitTest(e.X, e.Y);
			if(hti.Type==DataGrid.HitTestType.Cell)
			{
				Row = hti.Row;
			}
			else
			{
				Row = -1;
			}
		}

		private void LeveldataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if(Row!=-1)
			{
				LeveldataGrid.Select(Row);
			}
		}

		private void Level_Load(object sender, System.EventArgs e)
		{
			//string connString = "user id=sa;data source=\".\";initial catalog=KTMIS";
			//LevelConnection = new SqlConnection(connString);
			LevelSelectCommand = new SqlCommand("",LevelConnection);
			LevelDeleteCommand = new SqlCommand("DeleteLevel",LevelConnection); 
			sqlString = "select LevelNa as 级别名称,LevelPY as 级别拼音缩写 from Level"; 
			ds = new DataSet();
			try
			{
				LevelDataAdapter = new SqlDataAdapter(sqlString,LevelConnection);
				LevelDataAdapter.Fill(ds,"Level");
			}
			catch(Exception ex)
			{
				MessageBox.Show("载入错误！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			LeveldataGrid.SetDataBinding(ds,"Level");
		}

		private void Initial()
		{
			ds.Clear();
			LevelDataAdapter.SelectCommand.CommandText = sqlString;
			try
			{
				LevelConnection.Open();
				LevelDataAdapter.Fill(ds,"Level");
				LeveldataGrid.SetDataBinding(ds,"Level");
			}
			catch(Exception e)
			{
				MessageBox.Show("初始化错误！原因是"+e.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			finally
			{
				LevelConnection.Close();
			}
		}

		private void addBtn_Click(object sender, System.EventArgs e)
		{
			AddLevel al = new AddLevel();
			al.Connection = this.LevelConnection;
			al.ShowDialog();
			Initial();
		}

		private void updateBtn_Click(object sender, System.EventArgs e)
		{
			string name = null;
			string py = null;
			DataTable dt = ds.Tables["Level"];
			for(int i = 0;i<dt.Rows.Count;i++)
			{
				if(LeveldataGrid.IsSelected(i))
				{
					name = dt.Rows[i][0].ToString();
					py = dt.Rows[i][1].ToString();
					break;
				}
			}
			if(name==null)
			{
				MessageBox.Show("请选择在表框中所要修改的分类的行！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			string LevelCo = null;
			string selectString = "select LevelCo from Level where LevelNa=\'"+name+"\' and LevelPY=\'"+py+"\'";
			LevelSelectCommand.CommandText = selectString;
			try
			{
				LevelConnection.Open();
				SqlDataReader dr = LevelSelectCommand.ExecuteReader();
				while(dr.Read())
				{
					LevelCo = dr.GetValue(0).ToString();
					break;
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(" 读取数据失败！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			finally
			{
				LevelConnection.Close();
			}
			if(LevelCo==null)
			{
				MessageBox.Show("操作失败，请重试！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			AddLevel al = new AddLevel();
			al.SetLevelBtnText("修改");
			al.SetLevelCoText(LevelCo.ToString());
			al.SetLevelSNText(name);
			al.SetLevelSNPYText(py);
			al.SetFormTital("修改级别");
			al.ShowDialog();
			Initial();
		}

		private void deleteBtn_Click(object sender, System.EventArgs e)
		{
			string questionStr = "若删除该级别信息，与其相关的课题信息亦将同时被删除！\n\n是否继续？";
			DialogResult dialogResult = MessageBox.Show(questionStr, "系统提问", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
			if(dialogResult == DialogResult.No)
			{
				return;
			}

			string name = null;
			string py = null;
			DataTable dt = ds.Tables["Level"];
			for(int i = 0;i<dt.Rows.Count;i++)
			{
				if(LeveldataGrid.IsSelected(i))
				{
					name = dt.Rows[i][0].ToString();
					py = dt.Rows[i][1].ToString();
					break;
				}
			}
			if(name==null)
			{
				MessageBox.Show("请选择在表框中所要修改的分类的行！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			string LevelCo = null;
			string selectString = "select LevelCo from Level where LevelNa=\'"+name+"\' and LevelPY=\'"+py+"\'";
			LevelSelectCommand.CommandText = selectString;
			try
			{
				LevelConnection.Open();
				SqlDataReader dr = LevelSelectCommand.ExecuteReader();
				while(dr.Read())
				{
					LevelCo = dr.GetValue(0).ToString();
					break;
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(" 读取数据失败！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			finally
			{
				LevelConnection.Close();
			}
			if(LevelCo==null)
			{
				MessageBox.Show("操作失败，请重试！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			LevelDeleteCommand.CommandType = CommandType.StoredProcedure;
			LevelDeleteCommand.Parameters.Clear();
			LevelDeleteCommand.Parameters.Add("@LevelCo",SqlDbType.Int);
			LevelDeleteCommand.Parameters["@LevelCo"].Value = Convert.ToInt16(LevelCo.Trim());
			try
			{
				LevelConnection.Open();
				LevelDeleteCommand.ExecuteNonQuery();
				MessageBox.Show("删除成功！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			catch(Exception ex)
			{
				MessageBox.Show("删除失败，原因是："+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
				return;
			}
			finally
			{
				LevelConnection.Close();
			}
			
			Initial();
		}

		private void returnBtn_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void selectBtn_Click(object sender, System.EventArgs e)
		{
			string sqlStr = "select LevelNa as 级别名称,LevelPY as 级别拼音缩写 from Level where LevelNa like \'%" +LeveltextBox.Text.Trim()+"%\'"; 
			ds.Clear();
			try
			{
				LevelDataAdapter.SelectCommand.CommandText = sqlStr;
				LevelDataAdapter.Fill(ds,"Level");
			}
			catch(Exception ex)
			{
				MessageBox.Show("载入错误！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			LeveldataGrid.SetDataBinding(ds,"Level");
		}

		public System.Data.SqlClient.SqlConnection Connection
		{
			set
			{
				this.LevelConnection = value;
			}
		}
	}
}