memberform.cs

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

					CollegeCocomboBox.Items.Add(dr.GetValue(0).ToString());
					MemberNacomboBox.Items.Add(dr.GetValue(1).ToString());
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(" 读取数据失败！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			finally
			{
				MemberConnection.Close();
			}
		}

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

		private void MemberdataGrid_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 MemberdataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			if(Row!=-1)
			{
				MemberdataGrid.Select(Row);
			}
		}

		private void addBtn_Click(object sender, System.EventArgs e)
		{
			AddMember ac = new AddMember();
			ac.Connection = this.MemberConnection;
			ac.ShowDialog();
			Initial();
		}

		private void updateBtn_Click(object sender, System.EventArgs e)
		{
			string name = null;
			string collegeName = null;
			DataTable dt = ds.Tables["Member"];
			for(int i = 0;i<dt.Rows.Count;i++)
			{
				if(MemberdataGrid.IsSelected(i))
				{
					name = dt.Rows[i][0].ToString();
					collegeName = dt.Rows[i][1].ToString();
					break;
				}
			}
			if(name==null)
			{
				MessageBox.Show("请选择在表框中所要修改的分类的行！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			string MemberCo = null;
			string selectString = "select MemberCo from Member where MemberNa=\'"+name+"\'";
			MemberSelectCommand.CommandText = selectString;
			try
			{
				MemberConnection.Open();
				SqlDataReader dr = MemberSelectCommand.ExecuteReader();
				while(dr.Read())
				{
					MemberCo = dr.GetValue(0).ToString();
					break;
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(" 读取数据失败！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			finally
			{
				MemberConnection.Close();
			}
			if(MemberCo==null)
			{
				MessageBox.Show("操作失败，请重试！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			AddMember am = new AddMember();
			am.SetMemberBtnText("修改");
			am.SetMemberCoText(MemberCo.ToString());
			am.SetMemberSNText(name);
			am.SetMemberCollegeTextBoxText(collegeName);
			am.SetFormTital("修改院系");
			am.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;
			DataTable dt = ds.Tables["Member"];
			for(int i = 0;i<dt.Rows.Count;i++)
			{
				if(MemberdataGrid.IsSelected(i))
				{
					name = dt.Rows[i][0].ToString();
					break;
				}
			}
			if(name==null)
			{
				MessageBox.Show("请选择在表框中所要修改的分类的行！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			string MemberCo = null;
			string selectString = "select MemberCo from Member where MemberNa=\'"+name+"\'";
			MemberSelectCommand.CommandText = selectString;
			try
			{
				MemberConnection.Open();
				SqlDataReader dr = MemberSelectCommand.ExecuteReader();
				while(dr.Read())
				{
					MemberCo = dr.GetValue(0).ToString();
					break;
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(" 读取数据失败！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			finally
			{
				MemberConnection.Close();
			}
			if(MemberCo==null)
			{
				MessageBox.Show("操作失败，请重试！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				return;
			}
			MemberDeleteCommand.CommandType = CommandType.StoredProcedure;
			MemberDeleteCommand.Parameters.Clear();
			MemberDeleteCommand.Parameters.Add("@MemberCo",SqlDbType.Int);
			MemberDeleteCommand.Parameters["@MemberCo"].Value = Convert.ToInt16(MemberCo.Trim());
			try
			{
				MemberConnection.Open();
				MemberDeleteCommand.ExecuteNonQuery();
				MessageBox.Show("删除成功！","系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			catch(Exception ex)
			{
				MessageBox.Show("删除失败，原因是："+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
			}
			finally
			{
				MemberConnection.Close();
			}
			
			Initial();
		}

		private void selectBtn_Click(object sender, System.EventArgs e)
		{
			string sqlStr = "select MemberNa as 成员性名,CollegeNa as 所属院系 from Member,College where Member.CollegeCo=College.CollegeCo";
			if(colegetextBox.Text!="")
			{
				sqlStr += " and MemberNa like \'%" +colegetextBox.Text.Trim()+"%\' "; 
			}
			if(MemberNacomboBox.SelectedIndex!=-1)
			{
				sqlStr += " and Member.CollegeCo="+CollegeCocomboBox.SelectedItem.ToString();
			}
			ds.Clear();
			try
			{
				MemberDataAdapter.SelectCommand.CommandText = sqlStr;
				MemberDataAdapter.Fill(ds,"Member");
			}
			catch(Exception ex)
			{
				MessageBox.Show("载入错误！原因是"+ex.ToString(),"系统提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
			MemberdataGrid.SetDataBinding(ds,"Member");
		}

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

		private void MemberNacomboBox_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			CollegeCocomboBox.SelectedIndex = MemberNacomboBox.SelectedIndex;
		}

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