sumform.h

实现了很好的客户关系管理功能

			// 银行帐号TextBox
			// 
			this->银行帐号TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->银行帐号TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"银行帐号", true)));
			this->银行帐号TextBox->Location = System::Drawing::Point(64, 151);
			this->银行帐号TextBox->Name = L"银行帐号TextBox";
			this->银行帐号TextBox->Size = System::Drawing::Size(60, 21);
			this->银行帐号TextBox->TabIndex = 29;
			// 
			// 纳税号码TextBox
			// 
			this->纳税号码TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->纳税号码TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"纳税号码", true)));
			this->纳税号码TextBox->Location = System::Drawing::Point(193, 151);
			this->纳税号码TextBox->Name = L"纳税号码TextBox";
			this->纳税号码TextBox->Size = System::Drawing::Size(63, 21);
			this->纳税号码TextBox->TabIndex = 31;
			// 
			// 客户来源TextBox
			// 
			this->客户来源TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户来源TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户来源", true)));
			this->客户来源TextBox->Location = System::Drawing::Point(327, 109);
			this->客户来源TextBox->Name = L"客户来源TextBox";
			this->客户来源TextBox->Size = System::Drawing::Size(45, 21);
			this->客户来源TextBox->TabIndex = 33;
			// 
			// 客户类型TextBox
			// 
			this->客户类型TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户类型TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户类型", true)));
			this->客户类型TextBox->Location = System::Drawing::Point(327, 130);
			this->客户类型TextBox->Name = L"客户类型TextBox";
			this->客户类型TextBox->Size = System::Drawing::Size(45, 21);
			this->客户类型TextBox->TabIndex = 35;
			// 
			// 客户阶段TextBox
			// 
			this->客户阶段TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户阶段TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户阶段", true)));
			this->客户阶段TextBox->Location = System::Drawing::Point(327, 4);
			this->客户阶段TextBox->Name = L"客户阶段TextBox";
			this->客户阶段TextBox->Size = System::Drawing::Size(45, 21);
			this->客户阶段TextBox->TabIndex = 37;
			// 
			// 客户状态TextBox
			// 
			this->客户状态TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户状态TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户状态", true)));
			this->客户状态TextBox->Location = System::Drawing::Point(327, 25);
			this->客户状态TextBox->Name = L"客户状态TextBox";
			this->客户状态TextBox->Size = System::Drawing::Size(45, 21);
			this->客户状态TextBox->TabIndex = 39;
			// 
			// 客户级别TextBox
			// 
			this->客户级别TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户级别TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户级别", true)));
			this->客户级别TextBox->Location = System::Drawing::Point(327, 46);
			this->客户级别TextBox->Name = L"客户级别TextBox";
			this->客户级别TextBox->Size = System::Drawing::Size(45, 21);
			this->客户级别TextBox->TabIndex = 41;
			// 
			// 信用等级TextBox
			// 
			this->信用等级TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->信用等级TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"信用等级", true)));
			this->信用等级TextBox->Location = System::Drawing::Point(327, 67);
			this->信用等级TextBox->Name = L"信用等级TextBox";
			this->信用等级TextBox->Size = System::Drawing::Size(45, 21);
			this->信用等级TextBox->TabIndex = 43;
			// 
			// 客户规模TextBox
			// 
			this->客户规模TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->客户规模TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"客户规模", true)));
			this->客户规模TextBox->Location = System::Drawing::Point(327, 88);
			this->客户规模TextBox->Name = L"客户规模TextBox";
			this->客户规模TextBox->Size = System::Drawing::Size(45, 21);
			this->客户规模TextBox->TabIndex = 45;
			// 
			// 说明TextBox
			// 
			this->说明TextBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->说明TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->客户资料BindingSource, L"说明", true)));
			this->说明TextBox->Location = System::Drawing::Point(306, 151);
			this->说明TextBox->Name = L"说明TextBox";
			this->说明TextBox->Size = System::Drawing::Size(66, 21);
			this->说明TextBox->TabIndex = 47;
			// 
			// 客户名称ListBox
			// 
			this->客户名称ListBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Bottom) 
				| System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->客户名称ListBox->FormattingEnabled = true;
			this->客户名称ListBox->ItemHeight = 12;
			this->客户名称ListBox->Location = System::Drawing::Point(6, 31);
			this->客户名称ListBox->Name = L"客户名称ListBox";
			this->客户名称ListBox->Size = System::Drawing::Size(155, 376);
			this->客户名称ListBox->TabIndex = 3;
			this->客户名称ListBox->SelectedIndexChanged += gcnew System::EventHandler(this, &SumForm::客户名称ListBox_SelectedIndexChanged);
			// 
			// 查询Button
			// 
			this->查询Button->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right));
			this->查询Button->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"查询Button.Image")));
			this->查询Button->Location = System::Drawing::Point(104, 3);
			this->查询Button->Name = L"查询Button";
			this->查询Button->Size = System::Drawing::Size(56, 23);
			this->查询Button->TabIndex = 2;
			this->查询Button->Text = L"查询";
			this->查询Button->TextAlign = System::Drawing::ContentAlignment::MiddleRight;
			this->查询Button->TextImageRelation = System::Windows::Forms::TextImageRelation::ImageBeforeText;
			this->查询Button->UseVisualStyleBackColor = true;
			this->查询Button->Click += gcnew System::EventHandler(this, &SumForm::查询Button_Click);
			// 
			// splitContainer1
			// 
			this->splitContainer1->Dock = System::Windows::Forms::DockStyle::Fill;
			this->splitContainer1->Location = System::Drawing::Point(0, 0);
			this->splitContainer1->Name = L"splitContainer1";
			// 
			// splitContainer1.Panel1
			// 
			this->splitContainer1->Panel1->Controls->Add(this->客户名称ListBox);
			this->splitContainer1->Panel1->Controls->Add(this->查询Button);
			this->splitContainer1->Panel1->Controls->Add(this->省份ComboBox);
			this->splitContainer1->Panel1->Controls->Add(this->label1);
			// 
			// splitContainer1.Panel2
			// 
			this->splitContainer1->Panel2->Controls->Add(this->splitContainer2);
			this->splitContainer1->Size = System::Drawing::Size(542, 416);
			this->splitContainer1->SplitterDistance = 163;
			this->splitContainer1->TabIndex = 1;
			// 
			// 省份ComboBox
			// 
			this->省份ComboBox->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->省份ComboBox->FormattingEnabled = true;
			this->省份ComboBox->Location = System::Drawing::Point(44, 5);
			this->省份ComboBox->Name = L"省份ComboBox";
			this->省份ComboBox->Size = System::Drawing::Size(60, 20);
			this->省份ComboBox->TabIndex = 1;
			this->省份ComboBox->Text = L"%%";
			// 
			// label1
			// 
			this->label1->AutoSize = true;
			this->label1->Location = System::Drawing::Point(4, 9);
			this->label1->Name = L"label1";
			this->label1->Size = System::Drawing::Size(41, 12);
			this->label1->TabIndex = 0;
			this->label1->Text = L"省份：";
			// 
			// SumForm
			// 
			this->AutoScaleDimensions = System::Drawing::SizeF(6, 12);
			this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
			this->ClientSize = System::Drawing::Size(542, 416);
			this->Controls->Add(this->splitContainer1);
			this->Name = L"SumForm";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
			this->Text = L"客户综合管理";
			this->Load += gcnew System::EventHandler(this, &SumForm::SumForm_Load);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->MyCRMDataSet))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户资料BindingSource))->EndInit();
			this->客户联系管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户联系管理DataGridView))->EndInit();
			this->tabControl1->ResumeLayout(false);
			this->客户提醒管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户提醒管理DataGridView))->EndInit();
			this->客户回访管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户回访管理DataGridView))->EndInit();
			this->客户投诉管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户投诉管理DataGridView))->EndInit();
			this->客户产品管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户产品管理DataGridView))->EndInit();
			this->客户合同管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户合同管理DataGridView))->EndInit();
			this->客户代表管理TabPage->ResumeLayout(false);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户代表管理DataGridView))->EndInit();
			this->splitContainer2->Panel1->ResumeLayout(false);
			this->splitContainer2->Panel1->PerformLayout();
			this->splitContainer2->Panel2->ResumeLayout(false);
			this->splitContainer2->ResumeLayout(false);
			this->splitContainer1->Panel1->ResumeLayout(false);
			this->splitContainer1->Panel1->PerformLayout();
			this->splitContainer1->Panel2->ResumeLayout(false);
			this->splitContainer1->ResumeLayout(false);
			this->ResumeLayout(false);

		}
#pragma endregion
		private: static String^ MyCRMConnectionString= L"Data Source=.;Initial Catalog=MyCRM;Integrated Security=True;Pooling=False";
		private: System::Void 客户资料BindingNavigatorSaveItem_Click(System::Object^  sender, System::EventArgs^  e) {
			 this->Validate();
			 this->客户资料BindingSource->EndEdit();
			 this->客户资料TableAdapter->Update(this->MyCRMDataSet->客户资料);
		 }
		private: System::Void SumForm_Load(System::Object^  sender, System::EventArgs^  e) {
			 // TODO: 这行代码将数据加载到表“MyCRMDataSet.客户资料”中。您可以根据需要移动或移除它。
			 //this->客户资料TableAdapter->Fill(this->MyCRMDataSet->客户资料);
			String^ MySQLConnectionString = MyCRMConnectionString;
            SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
            MyConnection->Open();
            System::Data::DataTable^ MyQueryTable = gcnew System::Data::DataTable();
            String^ MySQL = "SELECT DISTINCT 省份 FROM 中国省份";
            SqlDataAdapter^ MyAdapter = gcnew SqlDataAdapter(MySQL, MyConnection);
            MyAdapter->Fill(MyQueryTable);
            for each (DataRow^ MyRow in MyQueryTable->Rows)
            {
                this->省份ComboBox->Items->Add(MyRow[0]->ToString());
            }
            this->省份ComboBox->Items->Add("%%");
            if (MyConnection->State == ConnectionState::Open)
            {
                MyConnection->Close();
            }    
		 }
		private: System::Void 查