using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using Aptech.Student.DataAccess;
using System.Data;
using Aptech.Student.Common;

namespace 學(xué)生管理系統(tǒng)
{
	/// <summary>
	/// frmMangeSubject 的摘要說(shuō)明。
	/// </summary>
	public class frmMangeSubject : System.Windows.Forms.Form
	{          
		       frmMain frm;
		public Subjects subject;
		private DataSet dsSubject;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ToolBarButton tbbNew;
		private System.Windows.Forms.ToolBarButton tbbChange;
		private System.Windows.Forms.ToolBarButton tbbDelete;
		private System.Windows.Forms.ImageList imageList1;
		private System.Windows.Forms.DataGrid dgSubject;
		private System.ComponentModel.IContainer components;

		public frmMangeSubject( frmMain frm)
		{
			//
			// Windows 窗體設(shè)計(jì)器支持所必需的
			//
			InitializeComponent();
            this.frm =frm;
			//
			// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
			//
		}

		/// <summary>
		/// 清理所有正在使用的資源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗體設(shè)計(jì)器生成的代碼
		/// <summary>
		/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmMangeSubject));
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.tbbNew = new System.Windows.Forms.ToolBarButton();
			this.tbbChange = new System.Windows.Forms.ToolBarButton();
			this.tbbDelete = new System.Windows.Forms.ToolBarButton();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.dgSubject = new System.Windows.Forms.DataGrid();
			((System.ComponentModel.ISupportInitialize)(this.dgSubject)).BeginInit();
			this.SuspendLayout();
			// 
			// toolBar1
			// 
			this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																						this.tbbNew,
																						this.tbbChange,
																						this.tbbDelete});
			this.toolBar1.DropDownArrows = true;
			this.toolBar1.ImageList = this.imageList1;
			this.toolBar1.Location = new System.Drawing.Point(0, 0);
			this.toolBar1.Name = "toolBar1";
			this.toolBar1.ShowToolTips = true;
			this.toolBar1.Size = new System.Drawing.Size(584, 41);
			this.toolBar1.TabIndex = 1;
			this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
			// 
			// tbbNew
			// 
			this.tbbNew.ImageIndex = 0;
			this.tbbNew.Text = "新建";
			// 
			// tbbChange
			// 
			this.tbbChange.ImageIndex = 2;
			this.tbbChange.Text = "修改";
			// 
			// tbbDelete
			// 
			this.tbbDelete.ImageIndex = 1;
			this.tbbDelete.Text = "刪除";
			// 
			// imageList1
			// 
			this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
			this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
			this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// dgSubject
			// 
			this.dgSubject.DataMember = "";
			this.dgSubject.Dock = System.Windows.Forms.DockStyle.Fill;
			this.dgSubject.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgSubject.Location = new System.Drawing.Point(0, 41);
			this.dgSubject.Name = "dgSubject";
			this.dgSubject.Size = new System.Drawing.Size(584, 357);
			this.dgSubject.TabIndex = 2;
			// 
			// frmMangeSubject
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(584, 398);
			this.Controls.Add(this.dgSubject);
			this.Controls.Add(this.toolBar1);
			this.Name = "frmMangeSubject";
			this.Text = "frmMangeSubject";
			this.Load += new System.EventHandler(this.frmMangeSubject_Load);
			((System.ComponentModel.ISupportInitialize)(this.dgSubject)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void frmMangeSubject_Load(object sender, System.EventArgs e)
		{
			subject=new Subjects ();
			this.dsSubject =subject.SelectSubject (-1,"");
			this.dgSubject .DataSource =dsSubject.Tables [0].DefaultView ;
		
		}

		private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
          System.Data.DataView  dv;
			if(e.Button.Equals(tbbNew))//添加
			{
				//創(chuàng)建視圖
				dv = new DataView(this.dsSubject .Tables[0]);
				//過(guò)濾被修改過(guò)的記錄
				dv.RowStateFilter = DataViewRowState.Added;
				foreach(DataRowView drv in dv)
				{
					subject.InsertSubject(drv[1].ToString(),drv[2].ToString());
				}
				this.dsSubject = subject.SelectSubject(-1,"");//重新取得數(shù)據(jù)集
				this.dgSubject.DataSource = new DataView(this.dsSubject.Tables[0]);
				//重新綁定數(shù)據(jù)集
				MessageBox.Show("添加成功!");
              
			}
			if(e.Button.Equals(tbbChange))//更新
			{
				//創(chuàng)建視圖
				dv = new DataView(this.dsSubject .Tables[0]);
				//過(guò)濾被修改過(guò)的記錄
				
			
				dv.RowStateFilter = DataViewRowState.ModifiedCurrent;
				foreach(DataRowView drv in dv)
				{
					subject.UpdateSubject((int)drv[0],drv[1].ToString(),drv[2].ToString());
					
				}
               MessageBox.Show("更新成功!");
			}
			if(e.Button.Equals(tbbDelete))//刪除
			{

				for(int i = 0 ;i<this.dsSubject .Tables[0].Rows.Count ;i++)//遍歷
				{
					if(this.dgSubject .IsSelected(i))//如果被選中就刪除
					{
						subject.DeleteSubject((int)this.dgSubject [i,0]);
					}
				}
				dv = new DataView(this.dsSubject.Tables[0]);
				//重新綁定DataGrid的數(shù)據(jù)源
				this.dsSubject  =subject.SelectSubject(-1,"");
				this.dgSubject .DataSource = new DataView(this.dsSubject .Tables[0]);
				MessageBox.Show("刪除成功!");

			}
		
		}
	}
}