ba020.cs

C#简单练习进销存代码

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

namespace star.BA
{
	public class BA020 : star.Public.SimpleList
	{
		private System.Data.DataTable dataTable1;
		private System.Data.DataColumn dataColumn1;
		private System.ComponentModel.IContainer components = null;

		public BA020()
		{
			// This call is required by the Windows Form Designer.
			InitializeComponent();

			// TODO: Add any initialization after the InitializeComponent call
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(BA020));
			this.dataTable1 = new System.Data.DataTable();
			this.dataColumn1 = new System.Data.DataColumn();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.DsMast)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataTable1)).BeginInit();
			// 
			// dataGrid1
			// 
			this.dataGrid1.DataSource = this.DsMast;
			this.dataGrid1.Name = "dataGrid1";
			// 
			// toolBar1
			// 
			this.toolBar1.Name = "toolBar1";
			// 
			// imageList1
			// 
			//this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
			// 
			// DsMast
			// 
			this.DsMast.Tables.AddRange(new System.Data.DataTable[] {
																		this.dataTable1});
			// 
			// dataTable1
			// 
			this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
																			  this.dataColumn1});
			this.dataTable1.TableName = "Supplier";
			// 
			// dataColumn1
			// 
			this.dataColumn1.ColumnName = "Column1";
			// 
			// BA020
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
			this.ClientSize = new System.Drawing.Size(368, 277);
			this.Name = "BA020";
			this.Text = "Suppliers";
			this.Load += new System.EventHandler(this.BA020_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.DsMast)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataTable1)).EndInit();

		}
		#endregion
		protected override void ReFill()
		{
			this.DaMast.SelectCommand=new System.Data.OleDb.OleDbCommand("select * from Sup",((wmMain)this.MdiParent).db);
			System.Data.OleDb.OleDbCommandBuilder OleDbCommandBuilder1=new System.Data.OleDb.OleDbCommandBuilder (this.DaMast);
			this.DsMast.Clear();
			this.dataGrid1.TableStyles.Clear();
			this.DaMast.Fill(DsMast,"Sup");
			this.dataGrid1.SetDataBinding (DsMast,"Sup");
			this.BindMast= (CurrencyManager)this.BindingContext[DsMast, "Sup"];
			this.dataGrid1.TableStyles.Add(new DataGridTableStyle());
			dataGrid1.TableStyles[0].MappingName="Sup";
			this.dataGrid1.TableStyles[0].GridColumnStyles.RemoveAt(0);

		}
		protected override void Save()
		{
			BindMast.EndCurrentEdit();
			try
			{
				DaMast.Update (DsMast,"Sup");
			}
			catch(Exception e)
			{
				MessageBox.Show("Current records have error. The transaction will be ignore! Error:"+e.Message.ToString ());
				this.DsMast.RejectChanges();
			}	
		}

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

	
	}
}