courseelect1.cs

数据库的课程设计作业。管理有关学生、课程的基本信息

			// 
			this.toolBarButton7.Text = "取消";
			this.toolBarButton7.ToolTipText = "取消";
			// 
			// toolBarButton8
			// 
			this.toolBarButton8.Text = "提交";
			this.toolBarButton8.ToolTipText = "提交";
			// 
			// toolBarButton9
			// 
			this.toolBarButton9.Text = "退出";
			this.toolBarButton9.ToolTipText = "退出";
			// 
			// CourseElect1
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(624, 606);
			this.Controls.Add(this.btnSearch);
			this.Controls.Add(this.btnElect);
			this.Controls.Add(this.dataGrid2);
			this.Controls.Add(this.label2);
			this.Controls.Add(this.label1);
			this.Controls.Add(this.cmb2);
			this.Controls.Add(this.cmb1);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.toolBar1);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.label4);
			this.Controls.Add(this.dateTimePicker1);
			this.Controls.Add(this.dateTimePicker2);
			this.Name = "CourseElect1";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "选课[选修课]";
			this.Load += new System.EventHandler(this.CourseElect1_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataSet71)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void CourseElect1_Load(object sender, System.EventArgs e)
		{
			da1.SelectCommand.Parameters[0].Value="%%";
			da1.SelectCommand.Parameters[1].Value="%%";
			da2.SelectCommand.Parameters[0].Value="%%";
			da2.SelectCommand.Parameters[1].Value="%%";
			da1.Fill(dataSet11.选课表);
			cmOrders=(CurrencyManager) BindingContext[dataSet11,"选课表"];
			da2.Fill(dataSet71.课程表);
		}

		private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			if (e.Button.ToolTipText == "首记录")
			{
				this.dataGrid1.UnSelect(cmOrders.Position); //取消原选中的行
				cmOrders.Position = 0;
				this.dataGrid1.Select(cmOrders.Position); //选中当前行
				this.dataGrid1.CurrentRowIndex = cmOrders.Position; //移动表头指示图标
				return;
				
			}
			if (e.Button.ToolTipText == "上一记录")
			{
				if (cmOrders.Position >= 0)
				{
					this.dataGrid1.UnSelect(cmOrders.Position); 
					cmOrders.Position--;
					this.dataGrid1.Select(cmOrders.Position);      
					this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				}
				return;
			}
			if (e.Button.ToolTipText == "下一记录")
			{
				if (cmOrders.Position <= cmOrders.Count-1)
				{
					this.dataGrid1.UnSelect(cmOrders.Position); 
					cmOrders.Position++;
					this.dataGrid1.Select(cmOrders.Position);       
					this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				}
				return;
			}
			if (e.Button.ToolTipText == "尾记录")
			{
				this.dataGrid1.UnSelect(cmOrders.Position); 
				cmOrders.Position = cmOrders.Count-1;
				this.dataGrid1.Select(cmOrders.Position);       
				this.dataGrid1.CurrentRowIndex = cmOrders.Position; 
				return;
			}
			if (e.Button.ToolTipText=="修改选课")
			{
				SetModifyMode(true);
			}
			if (e.Button.ToolTipText=="删除选课")
			{
				DialogResult result=MessageBox.Show("确认删除？","删除选课",MessageBoxButtons.OKCancel);
				if (result==DialogResult.OK)
					if(cmOrders.Count>0)
					{
						cmOrders.RemoveAt(cmOrders.Position);
						da1.Update(dataSet11.选课表);
					}
					else
						MessageBox.Show("表中为空，已无可删除信息","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
			}
			if (e.Button.ToolTipText=="提交")
			{
				if(cmb1.Text.Trim()=="")
				{
					MessageBox.Show("请输入课程号","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					return;
				}
				if(cmb2.Text.Trim()=="")
				{
					MessageBox.Show("请输入学号","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					return;
				}
				cmOrders.EndCurrentEdit();
				if(dataSet11.GetChanges()!=null)
				{
					try
					{
						da1.Update(dataSet11.选课表);
						SetModifyMode(false);
					}
					catch(Exception express)
					{
						MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
						dataSet11.RejectChanges();
					}
				}
				return;
			}
			if (e.Button.ToolTipText=="取消")
			{
				try
				{
					cmOrders.CancelCurrentEdit();
					SetModifyMode(false);
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
				}
				return;
			}
			if (e.Button.ToolTipText=="退出")
				this.Close();
		}
		private void SetModifyMode(bool blnEdit)
		{
			dateTimePicker1.Enabled=blnEdit;
			dateTimePicker2.Enabled=blnEdit;
			button1.Enabled=!blnEdit;
		}

		private void label4_Click(object sender, System.EventArgs e)
		{
		
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			da1.SelectCommand.Parameters[0].Value="%%";
			da1.SelectCommand.Parameters[1].Value="%%";
			btnElect.Enabled=false;
			if(txt1.Text.Trim()!="")
			{
				da1.SelectCommand.Parameters[0].Value="%"+txt1.Text.Trim()+"%";
			}
			if(txt2.Text!="")
			{
				da1.SelectCommand.Parameters[1].Value="%"+txt2.Text+"%";
			}
			dataSet11.选课表.Clear();//刷新数据集
			da1.Fill(dataSet11);
			//允许选课，删课
			btnElect.Enabled=true;
			this.student_ID=txt1.Text.Trim();//保存获准选课的学生学号
		}			
			
			
			
 
		
	

		private void label1_Click(object sender, System.EventArgs e)
		{
		  
		}

		private void btnSearch_Click(object sender, System.EventArgs e)
		{
			da2.SelectCommand.Parameters[0].Value="%%";
			da2.SelectCommand.Parameters[1].Value="%%";
			if(cmb1.Text.Trim()!="")
			{
				da2.SelectCommand.Parameters[0].Value="%"+cmb1.Text.Trim()+"%";
			}
			if(cmb2.Text!="")
			{
				da2.SelectCommand.Parameters[1].Value="%"+cmb2.Text+"%";
			}
			dataSet71.课程表.Clear();//刷新数据集
			da2.Fill(dataSet71);
		}

		private void btnElect_Click(object sender, System.EventArgs e)
		{
			string courseID=dataGrid2[dataGrid2.CurrentCell.RowNumber,0].ToString().Trim();//当前所选的课序号
			string strConn="workstation id=localhost;Integrated Security=SSPI;database=study&teach;";
			SqlConnection cn=new SqlConnection(strConn);
			cn.Open();
			SqlCommand cmd=cn.CreateCommand();
			SqlParameter stnumber=cmd.Parameters.Add("@snumber",System.Data.SqlDbType.VarChar);
			stnumber.Direction=ParameterDirection.Input;
			stnumber.Value=this.txt1.Text;
			SqlParameter conumber=cmd.Parameters.Add("@cnumber",System.Data.SqlDbType.VarChar);
			conumber.Direction=ParameterDirection.Input;
			conumber.Value=dataGrid2[dataGrid2.CurrentCell.RowNumber,0].ToString().Trim();//当前所选的课序号
			
			SqlParameter stime=cmd.Parameters.Add("@starttime",System.Data.SqlDbType.DateTime);
			stime.Direction=ParameterDirection.Input;
			stime.Value=this.dateTimePicker1.Value;
			SqlParameter ftime=cmd.Parameters.Add("@finishtime",System.Data.SqlDbType.DateTime);
			ftime.Direction=ParameterDirection.Input;
            ftime.Value=this.dateTimePicker2.Value;
			
			foreach(DataRow aRow in dataSet11.选课表.Rows)
			{
				if(aRow["课程号"].ToString().Trim()==courseID)
				{
					MessageBox.Show("所选课程已经在课程表中","课程重复",MessageBoxButtons.OK,MessageBoxIcon.Stop);
					return;
				}
			}
            cmd.CommandType=CommandType.StoredProcedure;
			cmd.CommandText="CourseElect";
			cmd.ExecuteNonQuery();
			//重新读入学生的选课信息
			dataSet11.选课表.Clear();
			da1.Update(dataSet11);
			da1.Fill(dataSet11.选课表);//该学生的选课信息		
		}
		
	}
}