reportcontactform.h

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

//文件名：ReportContactForm.h
#pragma once

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;

using namespace System::Data::SqlClient;
using namespace Microsoft::Office::Interop::Excel;
using namespace System::Reflection;

namespace 客户关系管理系统 {

	/// <summary>
	/// ReportContactForm 摘要
	///
	/// 警告: 如果更改此类的名称，则需要更改
	///          与此类所依赖的所有 .resx 文件关联的托管资源编译器工具的
	///          “资源文件名”属性。否则，
	///          设计器将不能与此窗体的关联
	///          本地化资源正确交互。
	/// </summary>
	public ref class ReportContactForm : public System::Windows::Forms::Form
	{
	public:
		ReportContactForm(void)
		{
			InitializeComponent();
			//
			//TODO: 在此处添加构造函数代码
			//
		}

	protected:
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		~ReportContactForm()
		{
			if (components)
			{
				delete components;
			}
		}
	private: System::Windows::Forms::TextBox^  查询值TextBox;
	protected: 
	private: System::Windows::Forms::DataGridView^  客户联系DataGridView;
	private: System::Windows::Forms::Button^  打印Button;
	private: System::Windows::Forms::DateTimePicker^  结束日期DateTimePicker;
	private: System::Windows::Forms::Label^  label3;
	private: System::Windows::Forms::DateTimePicker^  开始日期DateTimePicker;
	private: System::Windows::Forms::Label^  label4;
	private: System::Windows::Forms::Button^  查询Button;
	private: System::Windows::Forms::Label^  label2;
	private: System::Windows::Forms::ComboBox^  查询条件ComboBox;
	private: System::Windows::Forms::Label^  label1;

	private:
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		System::ComponentModel::Container ^components;

#pragma region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要
		/// 使用代码编辑器修改此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			System::ComponentModel::ComponentResourceManager^  resources = (gcnew System::ComponentModel::ComponentResourceManager(ReportContactForm::typeid));
			this->查询值TextBox = (gcnew System::Windows::Forms::TextBox());
			this->客户联系DataGridView = (gcnew System::Windows::Forms::DataGridView());
			this->打印Button = (gcnew System::Windows::Forms::Button());
			this->结束日期DateTimePicker = (gcnew System::Windows::Forms::DateTimePicker());
			this->label3 = (gcnew System::Windows::Forms::Label());
			this->开始日期DateTimePicker = (gcnew System::Windows::Forms::DateTimePicker());
			this->label4 = (gcnew System::Windows::Forms::Label());
			this->查询Button = (gcnew System::Windows::Forms::Button());
			this->label2 = (gcnew System::Windows::Forms::Label());
			this->查询条件ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->label1 = (gcnew System::Windows::Forms::Label());
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->客户联系DataGridView))->BeginInit();
			this->SuspendLayout();
			// 
			// 查询值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->Location = System::Drawing::Point(267, 4);
			this->查询值TextBox->Name = L"查询值TextBox";
			this->查询值TextBox->Size = System::Drawing::Size(190, 21);
			this->查询值TextBox->TabIndex = 30;
			// 
			// 客户联系DataGridView
			// 
			this->客户联系DataGridView->AllowUserToAddRows = false;
			this->客户联系DataGridView->AllowUserToDeleteRows = false;
			this->客户联系DataGridView->AllowUserToResizeRows = false;
			this->客户联系DataGridView->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->客户联系DataGridView->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->客户联系DataGridView->Location = System::Drawing::Point(3, 55);
			this->客户联系DataGridView->MultiSelect = false;
			this->客户联系DataGridView->Name = L"客户联系DataGridView";
			this->客户联系DataGridView->ReadOnly = true;
			this->客户联系DataGridView->RowHeadersVisible = false;
			this->客户联系DataGridView->RowTemplate->Height = 23;
			this->客户联系DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->客户联系DataGridView->Size = System::Drawing::Size(535, 358);
			this->客户联系DataGridView->TabIndex = 29;
			// 
			// 打印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(463, 28);
			this->打印Button->Name = L"打印Button";
			this->打印Button->Size = System::Drawing::Size(75, 23);
			this->打印Button->TabIndex = 28;
			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, &ReportContactForm::打印Button_Click);
			// 
			// 结束日期DateTimePicker
			// 
			this->结束日期DateTimePicker->Anchor = static_cast<System::Windows::Forms::AnchorStyles>(((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->结束日期DateTimePicker->Location = System::Drawing::Point(267, 28);
			this->结束日期DateTimePicker->Name = L"结束日期DateTimePicker";
			this->结束日期DateTimePicker->Size = System::Drawing::Size(190, 21);
			this->结束日期DateTimePicker->TabIndex = 27;
			// 
			// label3
			// 
			this->label3->AutoSize = true;
			this->label3->Location = System::Drawing::Point(208, 32);
			this->label3->Name = L"label3";
			this->label3->Size = System::Drawing::Size(65, 12);
			this->label3->TabIndex = 26;
			this->label3->Text = L"结束日期：";
			// 
			// 开始日期DateTimePicker
			// 
			this->开始日期DateTimePicker->Location = System::Drawing::Point(67, 28);
			this->开始日期DateTimePicker->Name = L"开始日期DateTimePicker";
			this->开始日期DateTimePicker->Size = System::Drawing::Size(140, 21);
			this->开始日期DateTimePicker->TabIndex = 25;
			this->开始日期DateTimePicker->Value = System::DateTime(2005, 3, 2, 13, 56, 0, 0);
			// 
			// label4
			// 
			this->label4->AutoSize = true;
			this->label4->Location = System::Drawing::Point(1, 32);
			this->label4->Name = L"label4";
			this->label4->Size = System::Drawing::Size(65, 12);
			this->label4->TabIndex = 24;
			this->label4->Text = L"开始日期：";
			// 
			// 查询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(463, 4);
			this->查询Button->Name = L"查询Button";
			this->查询Button->Size = System::Drawing::Size(75, 23);
			this->查询Button->TabIndex = 23;
			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, &ReportContactForm::查询Button_Click);
			// 
			// label2
			// 
			this->label2->AutoSize = true;
			this->label2->Location = System::Drawing::Point(208, 9);
			this->label2->Name = L"label2";
			this->label2->Size = System::Drawing::Size(53, 12);
			this->label2->TabIndex = 22;
			this->label2->Text = L"查询值：";
			// 
			// 查询条件ComboBox
			//