main.cs

VS2003+sqlserver 开发的客户关系管理系统,已有公司在使用,上传的是第一个版本.

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data;
using System.Runtime.InteropServices;

namespace WindowsApplication1
{
	/// <summary>
	/// main 的摘要说明。
	/// </summary>
	public class main_win : System.Windows.Forms.Form
	{
//		[DllImport("appface.dll")]
//		public static extern long SkinStart(string SkinFile,int nDefWinType,string CheckSum,long nType,
//			long hInstance,long nLen);
//		[DllImport("appface.dll")]
//		public static extern long SkinRemove() ;

		private System.Windows.Forms.Panel panel4;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.ComboBox comboBox1;
		private System.Windows.Forms.ComboBox comboBox2;
		private System.Windows.Forms.TextBox textBox18;
		private System.Windows.Forms.CheckBox checkBox1;
		private System.Windows.Forms.Button button1;
		private System.Windows.Forms.Panel panel5;
		private System.Windows.Forms.Button button2;
		private System.Windows.Forms.Button button3;
		private System.Windows.Forms.Button button4;
		private System.Windows.Forms.Button button5;
		private System.Windows.Forms.Button button6;
		private System.Windows.Forms.Button button7;
		private System.Windows.Forms.DateTimePicker dateTimePicker1;
		private System.Windows.Forms.Button button8;
		private System.Windows.Forms.DateTimePicker dateTimePicker2;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.PictureBox pictureBox1;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.Label label46;
		private System.Windows.Forms.TextBox textBox45;
		private System.Windows.Forms.Label label47;
		string tablename;
		string query;
		private DataSet ds=new DataSet();
		private System.Windows.Forms.TextBox textBox44;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.ComboBox comboBox3;

		private SqlDataAdapter clientada =new SqlDataAdapter();
		//private SqlDataAdapter linkmanada =new SqlDataAdapter();
		private SqlDataAdapter distributionada =new SqlDataAdapter();
		private SqlDataAdapter feedbackada =new SqlDataAdapter();
		private SqlDataAdapter pwd=new SqlDataAdapter();
		private System.Windows.Forms.Label l29;
		private System.ComponentModel.IContainer components;
		private System.Windows.Forms.ToolTip toolTip1;

		private string username;
		private System.Windows.Forms.TabPage tabPage1;
		private System.Windows.Forms.Panel panel11;
		private System.Windows.Forms.TextBox textBox50;
		private System.Windows.Forms.Label label59;
		private System.Windows.Forms.Label label24;
		private System.Windows.Forms.TextBox textBox22;
		private System.Windows.Forms.TextBox textBox36;
		private System.Windows.Forms.Label label38;
		private System.Windows.Forms.Label label35;
		private System.Windows.Forms.TextBox textBox25;
		private System.Windows.Forms.TextBox textBox24;
		private System.Windows.Forms.Label label25;
		private System.Windows.Forms.Label label36;
		private System.Windows.Forms.TextBox textBox19;
		private System.Windows.Forms.Panel panel3;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.TextBox textBox3;
		private System.Windows.Forms.Label label64;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.ComboBox comboBox10;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.TextBox textBox6;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.TextBox textBox17;
		private System.Windows.Forms.TextBox textBox9;
		private System.Windows.Forms.TextBox textBox12;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.TextBox textBox1;
		private System.Windows.Forms.TextBox textBox14;
		private System.Windows.Forms.TextBox textBox16;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.TextBox textBox11;
		private System.Windows.Forms.TextBox textBox10;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.TextBox textBox13;
		private System.Windows.Forms.TextBox textBox7;
		private System.Windows.Forms.TextBox textBox8;
		private System.Windows.Forms.TextBox textBox2;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.TabPage tabPage3;
		private System.Windows.Forms.Panel panel8;
		private System.Windows.Forms.DataGrid dataGrid2;
		private System.Windows.Forms.Panel panel1;
		private System.Windows.Forms.Label label63;
		private System.Windows.Forms.ComboBox comboBox5;
		private System.Windows.Forms.DateTimePicker dateTimePicker5;
		private System.Windows.Forms.Label label55;
		private System.Windows.Forms.TextBox textBox52;
		private System.Windows.Forms.Label label54;
		private System.Windows.Forms.Label label50;
		private System.Windows.Forms.TextBox textBox48;
		private System.Windows.Forms.TextBox textBox47;
		private System.Windows.Forms.TextBox textBox46;
		private System.Windows.Forms.Label label49;
		private System.Windows.Forms.Label label48;
		private System.Windows.Forms.Label label39;
		private System.Windows.Forms.Label label43;
		private System.Windows.Forms.Label label44;
		private System.Windows.Forms.TextBox textBox37;
		private System.Windows.Forms.TabPage tabPage4;
		private System.Windows.Forms.Panel panel10;
		private System.Windows.Forms.DataGrid dataGrid3;
		private System.Windows.Forms.Panel panel9;
		private System.Windows.Forms.ComboBox comboBox6;
		private System.Windows.Forms.DateTimePicker dateTimePicker3;
		private System.Windows.Forms.Label label22;
		private System.Windows.Forms.TextBox textBox63;
		private System.Windows.Forms.DateTimePicker dateTimePicker4;
		private System.Windows.Forms.Label label61;
		private System.Windows.Forms.Label label56;
		private System.Windows.Forms.TextBox textBox54;
		private System.Windows.Forms.Label label71;
		private System.Windows.Forms.TextBox textBox68;
		private System.Windows.Forms.Label label65;
		private System.Windows.Forms.Label label60;
		private System.Windows.Forms.TabPage tabPage5;
		private System.Windows.Forms.GroupBox groupBox4;
		private System.Windows.Forms.Button button12;
		private System.Windows.Forms.Button button11;
		private System.Windows.Forms.CheckBox checkBox2;
		private System.Windows.Forms.TextBox textBox32;
		private System.Windows.Forms.ComboBox comboBox7;
		private System.Windows.Forms.Label label51;
		private System.Windows.Forms.Label label62;
		private System.Windows.Forms.DataGrid dataGrid5;
		private System.Windows.Forms.TextBox textBox27;
		private System.Windows.Forms.Label label29;
		private System.Windows.Forms.GroupBox groupBox3;
		private System.Windows.Forms.TextBox textBox43;
		private System.Windows.Forms.Label label40;
		private System.Windows.Forms.Label label42;
		private System.Windows.Forms.Button button9;
		private System.Windows.Forms.TextBox textBox40;
		private System.Windows.Forms.Label label41;
		private System.Windows.Forms.TextBox textBox38;
		private System.Windows.Forms.ProgressBar progressBar1;
		private System.Windows.Forms.TabControl tabControl1;
		private System.Windows.Forms.Label label57;
		private System.Windows.Forms.TextBox textBox49;
		private System.Windows.Forms.Label label58;
		private System.Windows.Forms.TextBox textBox20;
		private System.Windows.Forms.Label label23;
		private System.Windows.Forms.ComboBox comboBox4;
		private System.Windows.Forms.Panel panel6;
		private System.Windows.Forms.PictureBox pictureBox2;
		private System.Windows.Forms.Panel panel7;
		private System.Windows.Forms.PictureBox pictureBox3;
		private System.Windows.Forms.Panel panel12;
		private System.Windows.Forms.PictureBox pictureBox4;
		private System.Windows.Forms.Panel panel13;
		private System.Windows.Forms.PictureBox pictureBox5;
		private System.Windows.Forms.Panel panel14;
		private System.Windows.Forms.PictureBox pictureBox6;
		private System.Windows.Forms.Panel panel15;
		private System.Windows.Forms.PictureBox pictureBox7;
		private System.Windows.Forms.Panel panel16;
		private System.Windows.Forms.PictureBox pictureBox8;
		private System.Windows.Forms.Panel panel17;
		private System.Windows.Forms.PictureBox pictureBox9;
		private string powerclass;
		public main_win(string powerclass,string username)
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
			this.username =username;
			this.powerclass=powerclass;
	
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

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

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(main_win));
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.textBox45 = new System.Windows.Forms.TextBox();
			this.label47 = new System.Windows.Forms.Label();
			this.textBox44 = new System.Windows.Forms.TextBox();
			this.label46 = new System.Windows.Forms.Label();
			this.panel4 = new System.Windows.Forms.Panel();
			this.label20 = new System.Windows.Forms.Label();
			this.label19 = new System.Windows.Forms.Label();
			this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
			this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
			this.button1 = new System.Windows.Forms.Button();
			this.checkBox1 = new System.Windows.Forms.CheckBox();
			this.textBox18 = new System.Windows.Forms.TextBox();
			this.comboBox2 = new System.Windows.Forms.ComboBox();
			this.comboBox1 = new System.Windows.Forms.ComboBox();
			this.label18 = new System.Windows.Forms.Label();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.comboBox3 = new System.Windows.Forms.ComboBox();
			this.panel5 = new System.Windows.Forms.Panel();
			this.button8 = new System.Windows.Forms.Button();
			this.button7 = new System.Windows.Forms.Button();
			this.button6 = new System.Windows.Forms.Button();
			this.button5 = new System.Windows.Forms.Button();
			this.button4 = new System.Windows.Forms.Button();
			this.button3 = new System.Windows.Forms.Button();
			this.button2 = new System.Windows.Forms.Button();
			this.pictureBox1 = new System.Windows.Forms.PictureBox();
			this.l29 = new System.Windows.Forms.Label();
			this.toolTip1 = new System.Windows.Forms.ToolTip(this.components);
			this.tabPage1 = new System.Windows.Forms.TabPage();
			this.panel11 = new System.Windows.Forms.Panel();
			this.label57 = new System.Windows.Forms.Label();
			this.textBox49 = new System.Windows.Forms.TextBox();
			this.label58 = new System.Windows.Forms.Label();
			this.textBox20 = new System.Windows.Forms.TextBox();
			this.label23 = new System.Windows.Forms.Label();
			this.textBox50 = new System.Windows.Forms.TextBox();
			this.label59 = new System.Windows.Forms.Label();
			this.label24 = new System.Windows.Forms.Label();
			this.textBox22 = new System.Windows.Forms.TextBox();
			this.textBox36 = new System.Windows.Forms.TextBox();
			this.label38 = new System.Windows.Forms.Label();
			this.label35 = new System.Windows.Forms.Label();
			this.textBox25 = new System.Windows.Forms.TextBox();
			this.panel3 = new System.Windows.Forms.Panel();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.panel2 = new System.Windows.Forms.Panel();
			this.textBox3 = new System.Windows.Forms.TextBox();
			this.label64 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.comboBox10 = new System.Windows.Forms.ComboBox();
			this.label2 = new System.Windows.Forms.Label();
			this.textBox6 = new System.Windows.Forms.TextBox();
			this.label15 = new System.Windows.Forms.Label();
			this.label17 = new System.Windows.Forms.Label();
			this.textBox17 = new System.Windows.Forms.TextBox();
			this.textBox9 = new System.Windows.Forms.TextBox();
			this.textBox12 = new System.Windows.Forms.TextBox();
			this.label12 = new System.Windows.Forms.Label();
			this.label1 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.textBox1 = new System.Windows.Forms.TextBox();
			this.textBox14 = new System.Windows.Forms.TextBox();
			this.textBox16 = new System.Windows.Forms.TextBox();
			this.label16 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.textBox11 = new System.Windows.Forms.TextBox();
			this.textBox10 = new System.Windows.Forms.TextBox();
			this.label10 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label13 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.textBox13 = new System.Windows.Forms.TextBox();
			this.textBox7 = new System.Windows.Forms.TextBox();
			this.textBox8 = new System.Windows.Forms.TextBox();
			this.textBox2 = new System.Windows.Forms.TextBox();
			this.label8 = new System.Windows.Forms.Label();
			this.textBox24 = new System.Windows.Forms.TextBox();
			this.label25 = new System.Windows.Forms.Label();
			this.textBox19 = new System.Windows.Forms.TextBox();
			this.label36 = new System.Windows.Forms.Label();
			this.tabPage3 = new System.Windows.Forms.TabPage();
			this.panel8 = new System.Windows.Forms.Panel();
			this.dataGrid2 = new System.Windows.Forms.DataGrid();
			this.panel1 = new System.Windows.Forms.Panel();
			this.label63 = new System.Windows.Forms.Label();
			this.comboBox5 = new System.Windows.Forms.ComboBox();
			this.dateTimePicker5 = new System.Windows.Forms.DateTimePicker();
			this.label55 = new System.Windows.Forms.Label();
			this.textBox52 = new System.Windows.Forms.TextBox();
			this.label54 = new System.Windows.Forms.Label();
			this.label50 = new System.Windows.Forms.Label();
			this.textBox48 = new System.Windows.Forms.TextBox();
			this.textBox47 = new System.Windows.Forms.TextBox();
			this.textBox46 = new System.Windows.Forms.TextBox();
			this.label49 = new System.Windows.Forms.Label();
			this.label48 = new System.Windows.Forms.Label();
			this.label39 = new System.Windows.Forms.Label();
			this.label43 = new System.Windows.Forms.Label();
			this.label44 = new System.Windows.Forms.Label();
			this.textBox37 = new System.Windows.Forms.TextBox();
			this.tabPage4 = new System.Windows.Forms.TabPage();