courseinfo.cs

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

			// 
			// cmb5
			// 
			this.cmb5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "课程表.上课地点"));
			this.cmb5.DataSource = this.dataSet11.课程表;
			this.cmb5.DisplayMember = "上课地点";
			this.cmb5.Enabled = false;
			this.cmb5.Location = new System.Drawing.Point(280, 472);
			this.cmb5.Name = "cmb5";
			this.cmb5.Size = new System.Drawing.Size(160, 20);
			this.cmb5.TabIndex = 20;
			// 
			// cmb6
			// 
			this.cmb6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "课程表.是否本学期课程"));
			this.cmb6.Enabled = false;
			this.cmb6.Items.AddRange(new object[] {
													  "是",
													  "否"});
			this.cmb6.Location = new System.Drawing.Point(496, 408);
			this.cmb6.Name = "cmb6";
			this.cmb6.Size = new System.Drawing.Size(72, 20);
			this.cmb6.TabIndex = 21;
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(488, 384);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(96, 23);
			this.label10.TabIndex = 22;
			this.label10.Text = "是否本学期课程";
			this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			// 
			// toolBarButton7
			// 
			this.toolBarButton7.Text = "修改";
			this.toolBarButton7.ToolTipText = "修改";
			// 
			// toolBarButton8
			// 
			this.toolBarButton8.Text = "提交";
			this.toolBarButton8.ToolTipText = "提交";
			// 
			// toolBarButton9
			// 
			this.toolBarButton9.Text = "取消";
			this.toolBarButton9.ToolTipText = "取消";
			// 
			// toolBarButton10
			// 
			this.toolBarButton10.Text = "退出";
			this.toolBarButton10.ToolTipText = "退出";
			// 
			// CourseInfo
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(656, 510);
			this.Controls.Add(this.label10);
			this.Controls.Add(this.cmb6);
			this.Controls.Add(this.cmb5);
			this.Controls.Add(this.cmb4);
			this.Controls.Add(this.txt8);
			this.Controls.Add(this.txt7);
			this.Controls.Add(this.cmb3);
			this.Controls.Add(this.cmb2);
			this.Controls.Add(this.label9);
			this.Controls.Add(this.label8);
			this.Controls.Add(this.label7);
			this.Controls.Add(this.label6);
			this.Controls.Add(this.label5);
			this.Controls.Add(this.label4);
			this.Controls.Add(this.label3);
			this.Controls.Add(this.cmb1);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.toolBar1);
			this.Controls.Add(this.groupBox1);
			this.Name = "CourseInfo";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "课程信息维护";
			this.Load += new System.EventHandler(this.CourseInfo_Load);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

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

		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=="添加")
			{
				cmOrders.AddNew();
				SetModifyMode(true);
			}
			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(txt7.Text.Trim()=="")
				{
					MessageBox.Show("请输入课程号","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					return;
				}
				if(txt8.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)
		{
			txt7.ReadOnly=!blnEdit;
			txt8.ReadOnly=!blnEdit;
			cmb1.Enabled=blnEdit;
			cmb2.Enabled=blnEdit;
			cmb3.Enabled=blnEdit;
			cmb4.Enabled=blnEdit;
			cmb5.Enabled=blnEdit;
			cmb6.Enabled=blnEdit;
			btnSearch.Enabled=!blnEdit;
		}

		private void btnSearch_Click(object sender, System.EventArgs e)
		{
			da1.SelectCommand.Parameters[0].Value="%%";
			da1.SelectCommand.Parameters[1].Value="%%";
			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);
		}

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

	}

}