serviceprovidermanage.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>
	/// ServiceProviderManage 的摘要说明。
	/// </summary>
	public class ServiceProviderManage : System.Windows.Forms.UserControl
	{
		private DevExpress.XtraEditors.PanelControl panel2;
		private WebMIS.GoldFilter.GridDataFilter gridDataFilter1;
		private DevExpress.XtraEditors.PanelControl panel1;
		private System.Windows.Forms.DataGrid dgPriver;
		private DataSet dsservice=null;
		private System.Windows.Forms.CheckBox checkBox1;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.ComboBox cbSType;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label2;
		private DevExpress.XtraEditors.TextEdit txtname;
		private DevExpress.XtraEditors.TextEdit txtTel;
		private DevExpress.XtraEditors.TextEdit txtFax;
		private DevExpress.XtraEditors.TextEdit txtPosition;
		private DevExpress.XtraEditors.TextEdit txtAddr;
		private DevExpress.XtraEditors.MemoEdit txtMemo;
		private DevExpress.XtraEditors.TextEdit txtRPerson;
		private DevExpress.XtraEditors.TextEdit txtEmail;
		private DevExpress.XtraEditors.TextEdit txtGood;
		private DevExpress.XtraEditors.TextEdit txtWeb;
		private DevExpress.XtraEditors.TextEdit txtNeiRong;
		private DevExpress.XtraEditors.TextEdit txtBad;
		private DevExpress.XtraEditors.SimpleButton btAdd;
		private DevExpress.XtraEditors.SimpleButton btSave;
		private DevExpress.XtraEditors.SimpleButton btService;
		private DevExpress.XtraEditors.SimpleButton btDelete;
		private DevExpress.XtraEditors.SimpleButton btReset;
		private DevExpress.XtraEditors.DateEdit dateTimePicker1;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public ServiceProviderManage()
		{
			//
			// 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.dgPriver = new System.Windows.Forms.DataGrid();
			this.gridDataFilter1 = new WebMIS.GoldFilter.GridDataFilter();
			this.panel1 = new DevExpress.XtraEditors.PanelControl();
			this.dateTimePicker1 = new DevExpress.XtraEditors.DateEdit();
			this.btReset = new DevExpress.XtraEditors.SimpleButton();
			this.btDelete = new DevExpress.XtraEditors.SimpleButton();
			this.btService = new DevExpress.XtraEditors.SimpleButton();
			this.btSave = new DevExpress.XtraEditors.SimpleButton();
			this.btAdd = new DevExpress.XtraEditors.SimpleButton();
			this.txtBad = new DevExpress.XtraEditors.TextEdit();
			this.txtNeiRong = new DevExpress.XtraEditors.TextEdit();
			this.txtWeb = new DevExpress.XtraEditors.TextEdit();
			this.txtGood = new DevExpress.XtraEditors.TextEdit();
			this.txtEmail = new DevExpress.XtraEditors.TextEdit();
			this.txtRPerson = new DevExpress.XtraEditors.TextEdit();
			this.txtMemo = new DevExpress.XtraEditors.MemoEdit();
			this.txtAddr = new DevExpress.XtraEditors.TextEdit();
			this.txtPosition = new DevExpress.XtraEditors.TextEdit();
			this.txtFax = new DevExpress.XtraEditors.TextEdit();
			this.txtTel = new DevExpress.XtraEditors.TextEdit();
			this.txtname = new DevExpress.XtraEditors.TextEdit();
			this.label7 = new System.Windows.Forms.Label();
			this.cbSType = new System.Windows.Forms.ComboBox();
			this.label10 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label13 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label4 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label2 = new System.Windows.Forms.Label();
			((System.ComponentModel.ISupportInitialize)(this.panel2)).BeginInit();
			this.panel2.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dgPriver)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.panel1)).BeginInit();
			this.panel1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dateTimePicker1.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtBad.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtNeiRong.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtWeb.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtGood.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtEmail.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtRPerson.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtMemo.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtAddr.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPosition.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtFax.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtTel.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtname.Properties)).BeginInit();
			this.SuspendLayout();
			// 
			// panel2
			// 
			this.panel2.Controls.Add(this.checkBox1);
			this.panel2.Controls.Add(this.dgPriver);
			this.panel2.Controls.Add(this.gridDataFilter1);
			this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
			this.panel2.Location = new System.Drawing.Point(0, 208);
			this.panel2.Name = "panel2";
			this.panel2.Size = new System.Drawing.Size(848, 341);
			this.panel2.TabIndex = 15;
			// 
			// 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(112, 5);
			this.checkBox1.Name = "checkBox1";
			this.checkBox1.Size = new System.Drawing.Size(48, 16);
			this.checkBox1.TabIndex = 15;
			this.checkBox1.Text = "全选";
			this.checkBox1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
			this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
			// 
			// dgPriver
			// 
			this.dgPriver.AlternatingBackColor = System.Drawing.Color.GhostWhite;
			this.dgPriver.BackColor = System.Drawing.Color.GhostWhite;
			this.dgPriver.BackgroundColor = System.Drawing.Color.Lavender;
			this.dgPriver.CaptionBackColor = System.Drawing.Color.FromArgb(((System.Byte)(90)), ((System.Byte)(180)), ((System.Byte)(232)));
			this.dgPriver.CaptionForeColor = System.Drawing.Color.Black;
			this.dgPriver.CaptionText = "服务商信息列表";
			this.dgPriver.DataMember = "";
			this.dgPriver.Dock = System.Windows.Forms.DockStyle.Fill;
			this.dgPriver.Font = new System.Drawing.Font("Tahoma", 8F);
			this.dgPriver.ForeColor = System.Drawing.Color.MidnightBlue;
			this.dgPriver.GridLineColor = System.Drawing.Color.RoyalBlue;
			this.dgPriver.HeaderBackColor = System.Drawing.Color.DeepSkyBlue;
			this.dgPriver.HeaderFont = new System.Drawing.Font("Tahoma", 8F, System.Drawing.FontStyle.Bold);
			this.dgPriver.HeaderForeColor = System.Drawing.Color.Lavender;
			this.dgPriver.ImeMode = System.Windows.Forms.ImeMode.NoControl;
			this.dgPriver.LinkColor = System.Drawing.Color.Teal;
			this.dgPriver.Location = new System.Drawing.Point(2, 2);
			this.dgPriver.Name = "dgPriver";
			this.dgPriver.ParentRowsBackColor = System.Drawing.Color.Lavender;
			this.dgPriver.ParentRowsForeColor = System.Drawing.Color.MidnightBlue;
			this.dgPriver.SelectionBackColor = System.Drawing.Color.Teal;
			this.dgPriver.SelectionForeColor = System.Drawing.Color.PaleGreen;
			this.dgPriver.Size = new System.Drawing.Size(844, 305);
			this.dgPriver.TabIndex = 1;
			this.dgPriver.CurrentCellChanged += new System.EventHandler(this.dgPriver_CurrentCellChanged);
			// 
			// gridDataFilter1
			// 
			this.gridDataFilter1.checkbox = null;
			this.gridDataFilter1.Dock = System.Windows.Forms.DockStyle.Bottom;
			this.gridDataFilter1.Location = new System.Drawing.Point(2, 307);
			this.gridDataFilter1.Name = "gridDataFilter1";
			this.gridDataFilter1.Size = new System.Drawing.Size(844, 32);
			this.gridDataFilter1.TabIndex = 14;
			// 
			// panel1
			// 
			this.panel1.Appearance.BackColor = System.Drawing.Color.Transparent;
			this.panel1.Appearance.Options.UseBackColor = true;
			this.panel1.Controls.Add(this.dateTimePicker1);
			this.panel1.Controls.Add(this.btReset);
			this.panel1.Controls.Add(this.btDelete);
			this.panel1.Controls.Add(this.btService);
			this.panel1.Controls.Add(this.btSave);
			this.panel1.Controls.Add(this.btAdd);
			this.panel1.Controls.Add(this.txtBad);
			this.panel1.Controls.Add(this.txtNeiRong);
			this.panel1.Controls.Add(this.txtWeb);
			this.panel1.Controls.Add(this.txtGood);
			this.panel1.Controls.Add(this.txtEmail);
			this.panel1.Controls.Add(this.txtRPerson);
			this.panel1.Controls.Add(this.txtMemo);
			this.panel1.Controls.Add(this.txtAddr);
			this.panel1.Controls.Add(this.txtPosition);
			this.panel1.Controls.Add(this.txtFax);
			this.panel1.Controls.Add(this.txtTel);
			this.panel1.Controls.Add(this.txtname);
			this.panel1.Controls.Add(this.label7);
			this.panel1.Controls.Add(this.cbSType);
			this.panel1.Controls.Add(this.label10);
			this.panel1.Controls.Add(this.label3);
			this.panel1.Controls.Add(this.label12);
			this.panel1.Controls.Add(this.label8);
			this.panel1.Controls.Add(this.label14);
			this.panel1.Controls.Add(this.label13);
			this.panel1.Controls.Add(this.label6);
			this.panel1.Controls.Add(this.label4);
			this.panel1.Controls.Add(this.label11);
			this.panel1.Controls.Add(this.label9);
			this.panel1.Controls.Add(this.label1);
			this.panel1.Controls.Add(this.label5);
			this.panel1.Controls.Add(this.label2);
			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(848, 208);
			this.panel1.TabIndex = 14;
			// 
			// dateTimePicker1
			// 
			this.dateTimePicker1.EditValue = new System.DateTime(2006, 6, 29, 0, 0, 0, 0);
			this.dateTimePicker1.Location = new System.Drawing.Point(576, 24);
			this.dateTimePicker1.Name = "dateTimePicker1";
			// 
			// dateTimePicker1.Properties
			// 
			this.dateTimePicker1.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.dateTimePicker1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
																													new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
			this.dateTimePicker1.Properties.Mask.UseMaskAsDisplayFormat = true;
			this.dateTimePicker1.Size = new System.Drawing.Size(144, 21);
			this.dateTimePicker1.TabIndex = 66;
			// 
			// btReset
			// 
			this.btReset.Location = new System.Drawing.Point(752, 152);
			this.btReset.Name = "btReset";
			this.btReset.TabIndex = 65;
			this.btReset.Text = "清  空";
			this.btReset.Click += new System.EventHandler(this.btReset_Click);
			// 
			// btDelete
			// 
			this.btDelete.Location = new System.Drawing.Point(752, 120);
			this.btDelete.Name = "btDelete";
			this.btDelete.TabIndex = 64;
			this.btDelete.Text = "删  除";
			this.btDelete.Click += new System.EventHandler(this.btDelete_Click);
			// 
			// btService
			// 
			this.btService.Location = new System.Drawing.Point(752, 88);
			this.btService.Name = "btService";
			this.btService.TabIndex = 63;
			this.btService.Text = "服务记录";
			this.btService.Click += new System.EventHandler(this.btService_Click);
			// 
			// btSave
			// 
			this.btSave.Location = new System.Drawing.Point(752, 56);
			this.btSave.Name = "btSave";
			this.btSave.TabIndex = 62;
			this.btSave.Text = "修  改";
			this.btSave.Click += new System.EventHandler(this.btSave_Click);
			// 
			// btAdd
			// 
			this.btAdd.Location = new System.Drawing.Point(752, 24);
			this.btAdd.Name = "btAdd";
			this.btAdd.TabIndex = 61;
			this.btAdd.Text = "添  加";
			this.btAdd.Click += new System.EventHandler(this.btAdd_Click);
			// 
			// txtBad
			// 
			this.txtBad.EditValue = "";
			this.txtBad.Location = new System.Drawing.Point(576, 96);
			this.txtBad.Name = "txtBad";
			// 
			// txtBad.Properties
			// 
			this.txtBad.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtBad.Size = new System.Drawing.Size(144, 21);
			this.txtBad.TabIndex = 60;
			this.txtBad.EditValueChanged += new System.EventHandler(this.txtBad_EditValueChanged);
			// 
			// txtNeiRong
			// 
			this.txtNeiRong.EditValue = "";
			this.txtNeiRong.Location = new System.Drawing.Point(576, 72);
			this.txtNeiRong.Name = "txtNeiRong";
			// 
			// txtNeiRong.Properties
			// 
			this.txtNeiRong.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtNeiRong.Size = new System.Drawing.Size(144, 21);
			this.txtNeiRong.TabIndex = 59;
			this.txtNeiRong.EditValueChanged += new System.EventHandler(this.txtNeiRong_EditValueChanged);
			// 
			// txtWeb
			// 
			this.txtWeb.EditValue = "";
			this.txtWeb.Location = new System.Drawing.Point(576, 48);
			this.txtWeb.Name = "txtWeb";
			// 
			// txtWeb.Properties
			// 
			this.txtWeb.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtWeb.Size = new System.Drawing.Size(144, 21);
			this.txtWeb.TabIndex = 58;
			this.txtWeb.EditValueChanged += new System.EventHandler(this.txtWeb_EditValueChanged);
			// 
			// txtGood
			// 
			this.txtGood.EditValue = "";
			this.txtGood.Location = new System.Drawing.Point(340, 96);
			this.txtGood.Name = "txtGood";
			// 
			// txtGood.Properties
			// 
			this.txtGood.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtGood.Size = new System.Drawing.Size(156, 21);
			this.txtGood.TabIndex = 56;
			// 
			// txtEmail
			// 
			this.txtEmail.EditValue = "";
			this.txtEmail.Location = new System.Drawing.Point(340, 72);
			this.txtEmail.Name = "txtEmail";
			// 
			// txtEmail.Properties
			// 
			this.txtEmail.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtEmail.Size = new System.Drawing.Size(156, 21);
			this.txtEmail.TabIndex = 55;
			// 
			// txtRPerson
			// 
			this.txtRPerson.EditValue = "";
			this.txtRPerson.Location = new System.Drawing.Point(340, 48);
			this.txtRPerson.Name = "txtRPerson";
			// 
			// txtRPerson.Properties
			// 
			this.txtRPerson.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtRPerson.Size = new System.Drawing.Size(156, 21);
			this.txtRPerson.TabIndex = 54;
			// 
			// txtMemo
			// 
			this.txtMemo.EditValue = "";
			this.txtMemo.Location = new System.Drawing.Point(96, 144);
			this.txtMemo.Name = "txtMemo";
			// 
			// txtMemo.Properties
			// 
			this.txtMemo.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtMemo.Size = new System.Drawing.Size(624, 48);
			this.txtMemo.TabIndex = 53;
			// 
			// txtAddr
			// 
			this.txtAddr.EditValue = "";
			this.txtAddr.Location = new System.Drawing.Point(96, 120);
			this.txtAddr.Name = "txtAddr";
			//