customersmanage.cs

c#编写的汽车销售公司erp进销存系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using CallCenter.BusinessLayer;
using CallCenter.DALFactory;
using CallCenter.IDAL;
using CallCenter.Modules;
using CallCenter.OracleDAL;
using System.Data;
namespace CallCenter.BusinessInterfaces.MainForms
{
	/// <summary>
	/// CustomersManage 的摘要说明。
	/// </summary>
	public class CustomersManage : System.Windows.Forms.UserControl
	{
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.Panel panel1;
		private System.Windows.Forms.DataGrid dgCustomer;
		private WebMIS.GoldFilter.GridDataFilter gridDataFilter1;
		private DataSet dscustomers=null;
		private System.Windows.Forms.CheckBox checkBox1;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox txtMemo;
		private System.Windows.Forms.ComboBox cbCType;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.TextBox txtAddr;
		private System.Windows.Forms.Button btDelete;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txtEmail;
		private System.Windows.Forms.TextBox txtRelation;
		private System.Windows.Forms.TextBox txtFax;
		private System.Windows.Forms.TextBox txtname;
		private System.Windows.Forms.ComboBox cbSex;
		private System.Windows.Forms.Button btReset;
		private System.Windows.Forms.TextBox txtCtelnumber;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Button btAdd;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Button btSave;
		private System.Windows.Forms.TabControl tabControl1;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

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

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <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.panel2 = new System.Windows.Forms.Panel();
			this.checkBox1 = new System.Windows.Forms.CheckBox();
			this.dgCustomer = new System.Windows.Forms.DataGrid();
			this.gridDataFilter1 = new WebMIS.GoldFilter.GridDataFilter();
			this.panel1 = new System.Windows.Forms.Panel();
			this.label9 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.txtMemo = new System.Windows.Forms.TextBox();
			this.cbCType = new System.Windows.Forms.ComboBox();
			this.label3 = new System.Windows.Forms.Label();
			this.txtAddr = new System.Windows.Forms.TextBox();
			this.btDelete = new System.Windows.Forms.Button();
			this.label1 = new System.Windows.Forms.Label();
			this.txtEmail = new System.Windows.Forms.TextBox();
			this.txtRelation = new System.Windows.Forms.TextBox();
			this.txtFax = new System.Windows.Forms.TextBox();
			this.txtname = new System.Windows.Forms.TextBox();
			this.cbSex = new System.Windows.Forms.ComboBox();
			this.btReset = new System.Windows.Forms.Button();
			this.txtCtelnumber = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.btAdd = new System.Windows.Forms.Button();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.btSave = new System.Windows.Forms.Button();
			this.tabControl1 = new System.Windows.Forms.TabControl();
			this.panel2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgCustomer)).BeginInit();
			this.panel1.SuspendLayout();
			this.SuspendLayout();
			// 
			// panel2
			// 
			this.panel2.Controls.Add(this.checkBox1);
			this.panel2.Controls.Add(this.dgCustomer);
			this.panel2.Controls.Add(this.gridDataFilter1);
			this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
			this.panel2.Location = new System.Drawing.Point(0, 176);
			this.panel2.Name = "panel2";
			this.panel2.Size = new System.Drawing.Size(860, 317);
			this.panel2.TabIndex = 8;
			// 
			// checkBox1
			// 
			this.checkBox1.BackColor = System.Drawing.SystemColors.ActiveCaption;
			this.checkBox1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.checkBox1.ForeColor = System.Drawing.SystemColors.ControlLightLight;
			this.checkBox1.Location = new System.Drawing.Point(104, 0);
			this.checkBox1.Name = "checkBox1";
			this.checkBox1.Size = new System.Drawing.Size(56, 20);
			this.checkBox1.TabIndex = 15;
			this.checkBox1.Text = "全选";
			this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
			// 
			// dgCustomer
			// 
			this.dgCustomer.BackgroundColor = System.Drawing.SystemColors.ActiveCaptionText;
			this.dgCustomer.CaptionText = "客户信息列表";
			this.dgCustomer.DataMember = "";
			this.dgCustomer.Dock = System.Windows.Forms.DockStyle.Fill;
			this.dgCustomer.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dgCustomer.Location = new System.Drawing.Point(0, 0);
			this.dgCustomer.Name = "dgCustomer";
			this.dgCustomer.Size = new System.Drawing.Size(860, 285);
			this.dgCustomer.TabIndex = 1;
			this.dgCustomer.CurrentCellChanged += new System.EventHandler(this.dgCustomer_CurrentCellChanged);
			// 
			// gridDataFilter1
			// 
			this.gridDataFilter1.BackColor = System.Drawing.SystemColors.Menu;
			this.gridDataFilter1.checkbox = null;
			this.gridDataFilter1.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.gridDataFilter1.Location = new System.Drawing.Point(0, 285);
			this.gridDataFilter1.Name = "gridDataFilter1";
			this.gridDataFilter1.Size = new System.Drawing.Size(860, 32);
			this.gridDataFilter1.TabIndex = 14;
			// 
			// panel1
			// 
			this.panel1.Controls.Add(this.label9);
			this.panel1.Controls.Add(this.label8);
			this.panel1.Controls.Add(this.label7);
			this.panel1.Controls.Add(this.txtMemo);
			this.panel1.Controls.Add(this.cbCType);
			this.panel1.Controls.Add(this.label3);
			this.panel1.Controls.Add(this.txtAddr);
			this.panel1.Controls.Add(this.btDelete);
			this.panel1.Controls.Add(this.label1);
			this.panel1.Controls.Add(this.txtEmail);
			this.panel1.Controls.Add(this.txtRelation);
			this.panel1.Controls.Add(this.txtFax);
			this.panel1.Controls.Add(this.txtname);
			this.panel1.Controls.Add(this.cbSex);
			this.panel1.Controls.Add(this.btReset);
			this.panel1.Controls.Add(this.txtCtelnumber);
			this.panel1.Controls.Add(this.label4);
			this.panel1.Controls.Add(this.label2);
			this.panel1.Controls.Add(this.btAdd);
			this.panel1.Controls.Add(this.label6);
			this.panel1.Controls.Add(this.label5);
			this.panel1.Controls.Add(this.btSave);
			this.panel1.Controls.Add(this.tabControl1);
			this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
			this.panel1.Location = new System.Drawing.Point(0, 0);
			this.panel1.Name = "panel1";
			this.panel1.Size = new System.Drawing.Size(860, 176);
			this.panel1.TabIndex = 7;
			// 
			// label9
			// 
			this.label9.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label9.Location = new System.Drawing.Point(32, 48);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(72, 23);
			this.label9.TabIndex = 30;
			this.label9.Text = "客户来电";
			this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label8
			// 
			this.label8.BackColor = System.Drawing.SystemColors.Menu;
			this.label8.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label8.Location = new System.Drawing.Point(32, 96);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(72, 23);
			this.label8.TabIndex = 36;
			this.label8.Text = "客户地址";
			this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label7
			// 
			this.label7.BackColor = System.Drawing.SystemColors.Menu;
			this.label7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label7.Location = new System.Drawing.Point(392, 24);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 34;
			this.label7.Text = "客户性别";
			this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// txtMemo
			// 
			this.txtMemo.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.txtMemo.Location = new System.Drawing.Point(112, 120);
			this.txtMemo.Multiline = true;
			this.txtMemo.Name = "txtMemo";
			this.txtMemo.Size = new System.Drawing.Size(592, 40);
			this.txtMemo.TabIndex = 18;
			this.txtMemo.Text = "";
			// 
			// cbCType
			// 
			this.cbCType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cbCType.Location = new System.Drawing.Point(472, 48);
			this.cbCType.Name = "cbCType";
			this.cbCType.Size = new System.Drawing.Size(232, 20);
			this.cbCType.TabIndex = 17;
			// 
			// label3
			// 
			this.label3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label3.Location = new System.Drawing.Point(392, 96);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(72, 23);
			this.label3.TabIndex = 21;
			this.label3.Text = "联系方式";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// txtAddr
			// 
			this.txtAddr.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.txtAddr.Location = new System.Drawing.Point(112, 96);
			this.txtAddr.Name = "txtAddr";
			this.txtAddr.Size = new System.Drawing.Size(232, 21);
			this.txtAddr.TabIndex = 37;
			this.txtAddr.Text = "";
			// 
			// btDelete
			// 
			this.btDelete.BackColor = System.Drawing.SystemColors.Menu;
			this.btDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btDelete.Font = new System.Drawing.Font("宋体", 9F);
			this.btDelete.Location = new System.Drawing.Point(736, 88);
			this.btDelete.Name = "btDelete";
			this.btDelete.Size = new System.Drawing.Size(75, 24);
			this.btDelete.TabIndex = 32;
			this.btDelete.Text = "删除";
			this.btDelete.Click +=new EventHandler(btDelete_Click);
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(32, 128);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 20;
			this.label1.Text = "备注信息";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// txtEmail
			// 
			this.txtEmail.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.txtEmail.Location = new System.Drawing.Point(472, 72);
			this.txtEmail.Name = "txtEmail";
			this.txtEmail.Size = new System.Drawing.Size(232, 21);
			this.txtEmail.TabIndex = 27;
			this.txtEmail.Text = "";
			// 
			// txtRelation