stocktable.cs

进销存管理系统 C#完整源码 内含SQl建库脚本等

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

namespace 进销存管理系统
{
	/// <summary>
	/// StockTable 的摘要说明。
	/// </summary>
	public class StockTable : System.Windows.Forms.Form
	{
		private	LinkDataBase link = new LinkDataBase();	
		private DataTable newTable;
		//保存从"商品信息维护"窗体中选择后传过来的数据,它们将被放入DataGrid的相应表格中
		public static string [] inputDataGridArray = new string [] {null,null,null};
		//保存从"供货商信息维护"窗体中选择后传过来的数据,它们将被赋值给供货商号和名称的控件Text属性
		//确定要赋的值为文本，故用空字符初始化
		public static string [] inputTextDataArray = new string [] {"",""};
		private DateTime gridMouseDownTime; //记录点击DataGrid时的时间

		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ToolBarButton tbarBtnSave;
		private System.Windows.Forms.ImageList imageList1;
		private System.Windows.Forms.ToolBarButton tbarBtnDelete;
		private System.Windows.Forms.ToolBarButton tbarBtnPrint;
		private System.Windows.Forms.DataGrid dgrd_StockTable;
		private System.Windows.Forms.TextBox txt_StockDate;
		private System.Windows.Forms.TextBox txt_Maker;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.TextBox txt_NoTax;
		private System.Windows.Forms.TextBox txt_Tax;
		private System.Windows.Forms.ComboBox cmb_StokerID;
		private System.Windows.Forms.TextBox txt_StokerName;
		private System.Windows.Forms.TextBox txt_TotalCount;
		private System.Windows.Forms.ComboBox cmb_Oprater;
		private System.ComponentModel.IContainer components;

		public StockTable()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
			this.selectDataBase();
			this.DataGridStateControl();
			this.cmb_StokerID.Items.Add("");
		}

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

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(StockTable));
			this.dgrd_StockTable = new System.Windows.Forms.DataGrid();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.cmb_Oprater = new System.Windows.Forms.ComboBox();
			this.cmb_StokerID = new System.Windows.Forms.ComboBox();
			this.txt_StockDate = new System.Windows.Forms.TextBox();
			this.txt_Maker = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.txt_StokerName = new System.Windows.Forms.TextBox();
			this.label5 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.tbarBtnSave = new System.Windows.Forms.ToolBarButton();
			this.tbarBtnDelete = new System.Windows.Forms.ToolBarButton();
			this.tbarBtnPrint = new System.Windows.Forms.ToolBarButton();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.txt_TotalCount = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.txt_NoTax = new System.Windows.Forms.TextBox();
			this.label10 = new System.Windows.Forms.Label();
			this.txt_Tax = new System.Windows.Forms.TextBox();
			((System.ComponentModel.ISupportInitialize)(this.dgrd_StockTable)).BeginInit();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.SuspendLayout();
			// 
			// dgrd_StockTable
			// 
			this.dgrd_StockTable.AllowSorting = false;
			this.dgrd_StockTable.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.dgrd_StockTable.CaptionVisible = false;
			this.dgrd_StockTable.DataMember = "";
			this.dgrd_StockTable.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgrd_StockTable.Location = new System.Drawing.Point(0, 104);
			this.dgrd_StockTable.Name = "dgrd_StockTable";
			this.dgrd_StockTable.Size = new System.Drawing.Size(720, 264);
			this.dgrd_StockTable.TabIndex = 5;
			this.dgrd_StockTable.MouseDown += new System.Windows.Forms.MouseEventHandler(this.dgrd_StockTable_MouseDown);
			this.dgrd_StockTable.DoubleClick += new System.EventHandler(this.dgrd_StockTable_DoubleClick);
			this.dgrd_StockTable.CurrentCellChanged += new System.EventHandler(this.dgrd_StockTable_CurrentCellChanged);
			// 
			// groupBox1
			// 
			this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.groupBox1.Controls.Add(this.cmb_Oprater);
			this.groupBox1.Controls.Add(this.cmb_StokerID);
			this.groupBox1.Controls.Add(this.txt_StockDate);
			this.groupBox1.Controls.Add(this.txt_Maker);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.txt_StokerName);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.label6);
			this.groupBox1.Controls.Add(this.label7);
			this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
			this.groupBox1.Location = new System.Drawing.Point(0, 22);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(720, 82);
			this.groupBox1.TabIndex = 0;
			this.groupBox1.TabStop = false;
			// 
			// cmb_Oprater
			// 
			this.cmb_Oprater.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cmb_Oprater.ItemHeight = 12;
			this.cmb_Oprater.Location = new System.Drawing.Point(524, 16);
			this.cmb_Oprater.Name = "cmb_Oprater";
			this.cmb_Oprater.Size = new System.Drawing.Size(121, 20);
			this.cmb_Oprater.Sorted = true;
			this.cmb_Oprater.TabIndex = 3;
			// 
			// cmb_StokerID
			// 
			this.cmb_StokerID.Location = new System.Drawing.Point(140, 51);
			this.cmb_StokerID.MaxDropDownItems = 1;
			this.cmb_StokerID.Name = "cmb_StokerID";
			this.cmb_StokerID.Size = new System.Drawing.Size(128, 20);
			this.cmb_StokerID.Sorted = true;
			this.cmb_StokerID.TabIndex = 4;
			this.cmb_StokerID.DropDown += new System.EventHandler(this.cmb_Stoker_DropDown);
			this.cmb_StokerID.KeyUp += new System.Windows.Forms.KeyEventHandler(this.cmb_StokerID_KeyUp);
			// 
			// txt_StockDate
			// 
			this.txt_StockDate.Location = new System.Drawing.Point(140, 16);
			this.txt_StockDate.Name = "txt_StockDate";
			this.txt_StockDate.Size = new System.Drawing.Size(128, 21);
			this.txt_StockDate.TabIndex = 1;
			this.txt_StockDate.Text = "";
			// 
			// txt_Maker
			// 
			this.txt_Maker.Location = new System.Drawing.Point(343, 16);
			this.txt_Maker.Name = "txt_Maker";
			this.txt_Maker.TabIndex = 2;
			this.txt_Maker.Text = "sys";
			// 
			// label4
			// 
			this.label4.Location = new System.Drawing.Point(75, 55);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(60, 16);
			this.label4.TabIndex = 19;
			this.label4.Text = "供货商号:";
			// 
			// txt_StokerName
			// 
			this.txt_StokerName.Location = new System.Drawing.Point(295, 51);
			this.txt_StokerName.Name = "txt_StokerName";
			this.txt_StokerName.ReadOnly = true;
			this.txt_StokerName.Size = new System.Drawing.Size(350, 21);
			this.txt_StokerName.TabIndex = 9;
			this.txt_StokerName.TabStop = false;
			this.txt_StokerName.Text = "";
			// 
			// label5
			// 
			this.label5.Location = new System.Drawing.Point(290, 22);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(42, 16);
			this.label5.TabIndex = 17;
			this.label5.Text = "制单人:";
			// 
			// label6
			// 
			this.label6.Location = new System.Drawing.Point(468, 22);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(48, 16);
			this.label6.TabIndex = 18;
			this.label6.Text = "业务员:";
			// 
			// label7
			// 
			this.label7.Location = new System.Drawing.Point(75, 22);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(60, 16);
			this.label7.TabIndex = 16;
			this.label7.Text = "进货日期:";
			// 
			// toolBar1
			// 
			this.toolBar1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																						this.tbarBtnSave,
																						this.tbarBtnDelete,
																						this.tbarBtnPrint});
			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(720, 29);
			this.toolBar1.TabIndex = 7;
			this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
			// 
			// tbarBtnSave
			// 
			this.tbarBtnSave.ImageIndex = 0;
			this.tbarBtnSave.ToolTipText = "保存修改";
			// 
			// tbarBtnDelete