grxxmanage.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 GrxxManage : 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.Label label10;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label8;
		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 label1;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label2;
		private DevExpress.XtraEditors.SimpleButton btAdd;
		private DevExpress.XtraEditors.SimpleButton btSave;
		private DevExpress.XtraEditors.SimpleButton btDelete;
		private DevExpress.XtraEditors.SimpleButton btReset;
		private DevExpress.XtraEditors.MemoEdit txtbz;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.Label label22;
		private System.Windows.Forms.Label label23;
		private DevExpress.XtraEditors.TextEdit txttsjnnr;
		private DevExpress.XtraEditors.TextEdit txtysr;
		private DevExpress.XtraEditors.TextEdit txtzw;
		private DevExpress.XtraEditors.TextEdit txtzy;
		private DevExpress.XtraEditors.TextEdit txtyyah;
		private DevExpress.XtraEditors.TextEdit txtdzyx;
		private DevExpress.XtraEditors.TextEdit txtcz;
		private DevExpress.XtraEditors.TextEdit txtyddh;
		private DevExpress.XtraEditors.TextEdit txtdh;
		private DevExpress.XtraEditors.TextEdit txtqh;
		private DevExpress.XtraEditors.TextEdit txtxxdz;
		private DevExpress.XtraEditors.TextEdit txtyzbm;
		private DevExpress.XtraEditors.TextEdit txtcs;
		private DevExpress.XtraEditors.TextEdit txtsf;
		private DevExpress.XtraEditors.TextEdit txtwhcd;
		private DevExpress.XtraEditors.ComboBoxEdit cbxb;
		private DevExpress.XtraEditors.TextEdit txtkhsd;
		private DevExpress.XtraEditors.TextEdit txtnl;
		private DevExpress.XtraEditors.TextEdit txtkhly;
		private DevExpress.XtraEditors.TextEdit txtsfzh;
		private DevExpress.XtraEditors.TextEdit txtkhxm;
		private DevExpress.XtraEditors.DateEdit dttsjnrq;
		private DevExpress.XtraEditors.SimpleButton simpleButton1;
		private DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem();
		private DevExpress.XtraPrintingLinks.DataGridLink printLink = new DevExpress.XtraPrintingLinks.DataGridLink();

		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public GrxxManage()
		{
			//
			// 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.simpleButton1 = new DevExpress.XtraEditors.SimpleButton();
			this.dttsjnrq = new DevExpress.XtraEditors.DateEdit();
			this.txttsjnnr = new DevExpress.XtraEditors.TextEdit();
			this.txtysr = new DevExpress.XtraEditors.TextEdit();
			this.txtzw = new DevExpress.XtraEditors.TextEdit();
			this.txtzy = new DevExpress.XtraEditors.TextEdit();
			this.txtyyah = new DevExpress.XtraEditors.TextEdit();
			this.txtdzyx = new DevExpress.XtraEditors.TextEdit();
			this.txtcz = new DevExpress.XtraEditors.TextEdit();
			this.txtyddh = new DevExpress.XtraEditors.TextEdit();
			this.txtdh = new DevExpress.XtraEditors.TextEdit();
			this.txtqh = new DevExpress.XtraEditors.TextEdit();
			this.txtxxdz = new DevExpress.XtraEditors.TextEdit();
			this.txtyzbm = new DevExpress.XtraEditors.TextEdit();
			this.txtcs = new DevExpress.XtraEditors.TextEdit();
			this.txtsf = new DevExpress.XtraEditors.TextEdit();
			this.txtwhcd = new DevExpress.XtraEditors.TextEdit();
			this.cbxb = new DevExpress.XtraEditors.ComboBoxEdit();
			this.txtkhsd = new DevExpress.XtraEditors.TextEdit();
			this.txtnl = new DevExpress.XtraEditors.TextEdit();
			this.txtkhly = new DevExpress.XtraEditors.TextEdit();
			this.txtsfzh = new DevExpress.XtraEditors.TextEdit();
			this.txtkhxm = new DevExpress.XtraEditors.TextEdit();
			this.label23 = new System.Windows.Forms.Label();
			this.label22 = new System.Windows.Forms.Label();
			this.label21 = new System.Windows.Forms.Label();
			this.label20 = new System.Windows.Forms.Label();
			this.label19 = new System.Windows.Forms.Label();
			this.label18 = new System.Windows.Forms.Label();
			this.label17 = new System.Windows.Forms.Label();
			this.label16 = new System.Windows.Forms.Label();
			this.label15 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.txtbz = new DevExpress.XtraEditors.MemoEdit();
			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.label7 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label3 = new System.Windows.Forms.Label();
			this.label8 = 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.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.dttsjnrq.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txttsjnnr.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtysr.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtzw.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtzy.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtyyah.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtdzyx.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtcz.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtyddh.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtdh.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtqh.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtxxdz.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtyzbm.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtcs.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtsf.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtwhcd.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.cbxb.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtkhsd.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtnl.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtkhly.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtsfzh.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtkhxm.Properties)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.txtbz.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, 264);
			this.panel2.Name = "panel2";
			this.panel2.Size = new System.Drawing.Size(848, 285);
			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, 249);
			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, 251);
			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.simpleButton1);
			this.panel1.Controls.Add(this.dttsjnrq);
			this.panel1.Controls.Add(this.txttsjnnr);
			this.panel1.Controls.Add(this.txtysr);
			this.panel1.Controls.Add(this.txtzw);
			this.panel1.Controls.Add(this.txtzy);
			this.panel1.Controls.Add(this.txtyyah);
			this.panel1.Controls.Add(this.txtdzyx);
			this.panel1.Controls.Add(this.txtcz);
			this.panel1.Controls.Add(this.txtyddh);
			this.panel1.Controls.Add(this.txtdh);
			this.panel1.Controls.Add(this.txtqh);
			this.panel1.Controls.Add(this.txtxxdz);
			this.panel1.Controls.Add(this.txtyzbm);
			this.panel1.Controls.Add(this.txtcs);
			this.panel1.Controls.Add(this.txtsf);
			this.panel1.Controls.Add(this.txtwhcd);
			this.panel1.Controls.Add(this.cbxb);
			this.panel1.Controls.Add(this.txtkhsd);
			this.panel1.Controls.Add(this.txtnl);
			this.panel1.Controls.Add(this.txtkhly);
			this.panel1.Controls.Add(this.txtsfzh);
			this.panel1.Controls.Add(this.txtkhxm);
			this.panel1.Controls.Add(this.label23);
			this.panel1.Controls.Add(this.label22);
			this.panel1.Controls.Add(this.label21);
			this.panel1.Controls.Add(this.label20);
			this.panel1.Controls.Add(this.label19);
			this.panel1.Controls.Add(this.label18);
			this.panel1.Controls.Add(this.label17);
			this.panel1.Controls.Add(this.label16);
			this.panel1.Controls.Add(this.label15);
			this.panel1.Controls.Add(this.label14);
			this.panel1.Controls.Add(this.label12);
			this.panel1.Controls.Add(this.label9);
			this.panel1.Controls.Add(this.txtbz);
			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.label7);
			this.panel1.Controls.Add(this.label10);
			this.panel1.Controls.Add(this.label3);
			this.panel1.Controls.Add(this.label8);
			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.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, 264);
			this.panel1.TabIndex = 14;
			// 
			// simpleButton1
			// 
			this.simpleButton1.Location = new System.Drawing.Point(760, 168);
			this.simpleButton1.Name = "simpleButton1";
			this.simpleButton1.TabIndex = 108;
			this.simpleButton1.Text = "打印";
			this.simpleButton1.Click += new System.EventHandler(this.simpleButton1_Click);
			// 
			// dttsjnrq
			// 
			this.dttsjnrq.EditValue = new System.DateTime(2006, 8, 29, 0, 0, 0, 0);
			this.dttsjnrq.Location = new System.Drawing.Point(88, 192);
			this.dttsjnrq.Name = "dttsjnrq";
			// 
			// dttsjnrq.Properties
			// 
			this.dttsjnrq.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.dttsjnrq.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
																											 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
			this.dttsjnrq.Size = new System.Drawing.Size(168, 21);
			this.dttsjnrq.TabIndex = 107;
			// 
			// txttsjnnr
			// 
			this.txttsjnnr.EditValue = "";
			this.txttsjnnr.Location = new System.Drawing.Point(344, 192);
			this.txttsjnnr.Name = "txttsjnnr";
			// 
			// txttsjnnr.Properties
			// 
			this.txttsjnnr.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txttsjnnr.Size = new System.Drawing.Size(400, 21);
			this.txttsjnnr.TabIndex = 106;
			// 
			// txtysr
			// 
			this.txtysr.EditValue = "";
			this.txtysr.Location = new System.Drawing.Point(568, 168);
			this.txtysr.Name = "txtysr";
			// 
			// txtysr.Properties
			// 
			this.txtysr.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtysr.Size = new System.Drawing.Size(176, 21);
			this.txtysr.TabIndex = 104;
			// 
			// txtzw
			// 
			this.txtzw.EditValue = "";
			this.txtzw.Location = new System.Drawing.Point(328, 168);
			this.txtzw.Name = "txtzw";
			// 
			// txtzw.Properties
			// 
			this.txtzw.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtzw.Size = new System.Drawing.Size(176, 21);
			this.txtzw.TabIndex = 103;
			// 
			// txtzy
			// 
			this.txtzy.EditValue = "";
			this.txtzy.Location = new System.Drawing.Point(88, 168);