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;
using DrawFlat;
namespace CallCenter.BusinessInterfaces.MainForms
{
	/// <summary>
	/// CustomersManage 的摘要说明。
	/// </summary>
	public class CustomersManage : System.Windows.Forms.UserControl
	{
		private DevExpress.XtraEditors.PanelControl panel2;
		private DevExpress.XtraEditors.PanelControl 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.Label label3;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label5;
		private DevExpress.XtraEditors.TextEdit txtname;
		private DevExpress.XtraEditors.TextEdit txtCtelnumber;
		private DevExpress.XtraEditors.TextEdit txtFax;
		private DevExpress.XtraEditors.TextEdit txtAddr;
		private DevExpress.XtraEditors.TextEdit txtEmail;
		private DevExpress.XtraEditors.TextEdit txtRelation;
		private DevExpress.XtraEditors.MemoEdit txtMemo;
		private DevExpress.XtraEditors.ComboBoxEdit cbSex;
		private DevExpress.XtraEditors.SimpleButton btAdd;
		private DevExpress.XtraEditors.SimpleButton btReset;
		private DevExpress.XtraEditors.SimpleButton btDelete;
		private DevExpress.XtraEditors.SimpleButton btSave;
		private DrawFlat.FlatComboBox cbCType;
		/// <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 DevExpress.XtraEditors.PanelControl();
			this.checkBox1 = new System.Windows.Forms.CheckBox();
			this.dgCustomer = new System.Windows.Forms.DataGrid();
			this.gridDataFilter1 = new WebMIS.GoldFilter.GridDataFilter();
			this.panel1 = new DevExpress.XtraEditors.PanelControl();
			this.btReset = new DevExpress.XtraEditors.SimpleButton();
			this.btDelete = new DevExpress.XtraEditors.SimpleButton();
			this.btSave = new DevExpress.XtraEditors.SimpleButton();
			this.btAdd = new DevExpress.XtraEditors.SimpleButton();
			this.cbSex = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtMemo = new DevExpress.XtraEditors.MemoEdit();
			this.txtRelation = new DevExpress.XtraEditors.TextEdit();
			this.txtEmail = new DevExpress.XtraEditors.TextEdit();
			this.txtAddr = new DevExpress.XtraEditors.TextEdit();
			this.txtFax = new DevExpress.XtraEditors.TextEdit();
			this.txtCtelnumber = new DevExpress.XtraEditors.TextEdit();
			this.txtname = new DevExpress.XtraEditors.TextEdit();
			this.label9 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.cbCType = new DrawFlat.FlatComboBox();
			this.label3 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			((System.ComponentModel.ISupportInitialize)(this.panel2)).BeginInit();
			this.panel2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgCustomer)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.panel1)).BeginInit();
			this.panel1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.cbSex.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtMemo.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtRelation.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtEmail.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtAddr.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtFax.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtCtelnumber.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtname.Properties)).BeginInit();
			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.Color.FromArgb(((System.Byte)(90)), ((System.Byte)(180)), ((System.Byte)(232)));
			this.checkBox1.Font = new System.Drawing.Font("宋体", 8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.checkBox1.ForeColor = System.Drawing.Color.Black;
			this.checkBox1.Location = new System.Drawing.Point(104, 6);
			this.checkBox1.Name = "checkBox1";
			this.checkBox1.Size = new System.Drawing.Size(56, 17);
			this.checkBox1.TabIndex = 15;
			this.checkBox1.Text = "全选";
			this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
			// 
			// dgCustomer
			// 
			this.dgCustomer.AlternatingBackColor = System.Drawing.Color.GhostWhite;
			this.dgCustomer.BackColor = System.Drawing.Color.GhostWhite;
			this.dgCustomer.BackgroundColor = System.Drawing.Color.Lavender;
			this.dgCustomer.CaptionBackColor = System.Drawing.Color.FromArgb(((System.Byte)(90)), ((System.Byte)(180)), ((System.Byte)(232)));
			this.dgCustomer.CaptionForeColor = System.Drawing.Color.Black;
			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(2, 2);
			this.dgCustomer.Name = "dgCustomer";
			this.dgCustomer.Size = new System.Drawing.Size(856, 281);
			this.dgCustomer.TabIndex = 1;
			this.dgCustomer.CurrentCellChanged += new System.EventHandler(this.dgCustomer_CurrentCellChanged);
			// 
			// gridDataFilter1
			// 
			this.gridDataFilter1.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(141)), ((System.Byte)(193)), ((System.Byte)(230)));
			this.gridDataFilter1.checkbox = null;
			this.gridDataFilter1.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.gridDataFilter1.Location = new System.Drawing.Point(2, 283);
			this.gridDataFilter1.Name = "gridDataFilter1";
			this.gridDataFilter1.Size = new System.Drawing.Size(856, 32);
			this.gridDataFilter1.TabIndex = 14;
			// 
			// panel1
			// 
			this.panel1.Controls.Add(this.btReset);
			this.panel1.Controls.Add(this.btDelete);
			this.panel1.Controls.Add(this.btSave);
			this.panel1.Controls.Add(this.btAdd);
			this.panel1.Controls.Add(this.cbSex);
			this.panel1.Controls.Add(this.txtMemo);
			this.panel1.Controls.Add(this.txtRelation);
			this.panel1.Controls.Add(this.txtEmail);
			this.panel1.Controls.Add(this.txtAddr);
			this.panel1.Controls.Add(this.txtFax);
			this.panel1.Controls.Add(this.txtCtelnumber);
			this.panel1.Controls.Add(this.txtname);
			this.panel1.Controls.Add(this.label9);
			this.panel1.Controls.Add(this.label8);
			this.panel1.Controls.Add(this.label7);
			this.panel1.Controls.Add(this.cbCType);
			this.panel1.Controls.Add(this.label3);
			this.panel1.Controls.Add(this.label1);
			this.panel1.Controls.Add(this.label4);
			this.panel1.Controls.Add(this.label2);
			this.panel1.Controls.Add(this.label6);
			this.panel1.Controls.Add(this.label5);
			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;
			// 
			// btReset
			// 
			this.btReset.Location = new System.Drawing.Point(720, 120);
			this.btReset.Name = "btReset";
			this.btReset.TabIndex = 49;
			this.btReset.Text = "清空";
			this.btReset.Click += new System.EventHandler(this.btReset_Click);
			// 
			// btDelete
			// 
			this.btDelete.Location = new System.Drawing.Point(720, 88);
			this.btDelete.Name = "btDelete";
			this.btDelete.TabIndex = 48;
			this.btDelete.Text = "删除";
			this.btDelete.Click += new System.EventHandler(this.btDelete_Click);
			// 
			// btSave
			// 
			this.btSave.Location = new System.Drawing.Point(720, 56);
			this.btSave.Name = "btSave";
			this.btSave.TabIndex = 47;
			this.btSave.Tag = "修改";
			this.btSave.Text = "修改";
			this.btSave.Click += new System.EventHandler(this.btSave_Click);
			// 
			// btAdd
			// 
			this.btAdd.Location = new System.Drawing.Point(720, 24);
			this.btAdd.Name = "btAdd";
			this.btAdd.TabIndex = 46;
			this.btAdd.Text = "添加";
			this.btAdd.Click += new System.EventHandler(this.btAdd_Click);
			// 
			// cbSex
			// 
			this.cbSex.EditValue = "";
			this.cbSex.Location = new System.Drawing.Point(472, 24);
			this.cbSex.Name = "cbSex";
			// 
			// cbSex.Properties
			// 
			this.cbSex.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.cbSex.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
																										  new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
			this.cbSex.Properties.Items.AddRange(new object[] {
																  "男",
																  "女"});
			this.cbSex.Size = new System.Drawing.Size(216, 21);
			this.cbSex.TabIndex = 45;
			// 
			// txtMemo
			// 
			this.txtMemo.EditValue = "";
			this.txtMemo.Location = new System.Drawing.Point(96, 120);
			this.txtMemo.Name = "txtMemo";
			// 
			// txtMemo.Properties
			// 
			this.txtMemo.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtMemo.Size = new System.Drawing.Size(592, 40);
			this.txtMemo.TabIndex = 44;
			// 
			// txtRelation
			// 
			this.txtRelation.EditValue = "";
			this.txtRelation.Location = new System.Drawing.Point(472, 96);
			this.txtRelation.Name = "txtRelation";
			// 
			// txtRelation.Properties
			// 
			this.txtRelation.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtRelation.Size = new System.Drawing.Size(216, 21);
			this.txtRelation.TabIndex = 42;
			this.txtRelation.EditValueChanged += new System.EventHandler(this.txtRelation_EditValueChanged);
			// 
			// txtEmail
			// 
			this.txtEmail.EditValue = "";
			this.txtEmail.Location = new System.Drawing.Point(472, 72);
			this.txtEmail.Name = "txtEmail";
			// 
			// txtEmail.Properties
			// 
			this.txtEmail.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtEmail.Size = new System.Drawing.Size(216, 21);
			this.txtEmail.TabIndex = 41;
			this.txtEmail.EditValueChanged += new System.EventHandler(this.txtEmail_EditValueChanged);
			// 
			// txtAddr
			// 
			this.txtAddr.EditValue = "";
			this.txtAddr.Location = new System.Drawing.Point(96, 96);
			this.txtAddr.Name = "txtAddr";
			// 
			// txtAddr.Properties
			// 
			this.txtAddr.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtAddr.Size = new System.Drawing.Size(272, 21);
			this.txtAddr.TabIndex = 40;
			// 
			// txtFax
			// 
			this.txtFax.EditValue = "";
			this.txtFax.Location = new System.Drawing.Point(96, 72);
			this.txtFax.Name = "txtFax";
			// 
			// txtFax.Properties
			// 
			this.txtFax.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtFax.Size = new System.Drawing.Size(272, 21);
			this.txtFax.TabIndex = 39;
			// 
			// txtCtelnumber