gasqueryform.h

小区物业管理系统

//文件名：GasQueryForm.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 Microsoft::Office::Interop::Excel;
using namespace System::Reflection;
using namespace System::Data::SqlClient;

namespace MyCommunity {

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

	protected:
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		~GasQueryForm()
		{
			if (components)
			{
				delete components;
			}
		}
	private: System::Windows::Forms::DataGridView^  水电气费DataGridView;
	protected: 
	private: System::Windows::Forms::Button^  打印Button;
	private: System::Windows::Forms::ComboBox^  费用状态ComboBox;
	private: System::Windows::Forms::Label^  费用状态Label;
	private: System::Windows::Forms::ComboBox^  业主姓名ComboBox;
	private: System::Windows::Forms::Label^  业主姓名Label;
	private: System::Windows::Forms::ComboBox^  楼栋名称ComboBox;
	private: System::Windows::Forms::Label^  楼栋名称Label;
	private: System::Windows::Forms::Button^  查询Button;
	private: System::Windows::Forms::ComboBox^  费用类型ComboBox;
	private: System::Windows::Forms::Label^  费用类型Label;
	private: System::Windows::Forms::ComboBox^  计费月份ComboBox;
	private: System::Windows::Forms::Label^  计费月份Label;
	private: System::Windows::Forms::ComboBox^  计费年份ComboBox;
	private: System::Windows::Forms::Label^  计费年份Label;

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

#pragma region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要
		/// 使用代码编辑器修改此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			System::Windows::Forms::DataGridViewCellStyle^  dataGridViewCellStyle1 = (gcnew System::Windows::Forms::DataGridViewCellStyle());
			System::Windows::Forms::DataGridViewCellStyle^  dataGridViewCellStyle2 = (gcnew System::Windows::Forms::DataGridViewCellStyle());
			System::Windows::Forms::DataGridViewCellStyle^  dataGridViewCellStyle3 = (gcnew System::Windows::Forms::DataGridViewCellStyle());
			System::ComponentModel::ComponentResourceManager^  resources = (gcnew System::ComponentModel::ComponentResourceManager(GasQueryForm::typeid));
			this->水电气费DataGridView = (gcnew System::Windows::Forms::DataGridView());
			this->打印Button = (gcnew System::Windows::Forms::Button());
			this->费用状态ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->费用状态Label = (gcnew System::Windows::Forms::Label());
			this->业主姓名ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->业主姓名Label = (gcnew System::Windows::Forms::Label());
			this->楼栋名称ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->楼栋名称Label = (gcnew System::Windows::Forms::Label());
			this->查询Button = (gcnew System::Windows::Forms::Button());
			this->费用类型ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->费用类型Label = (gcnew System::Windows::Forms::Label());
			this->计费月份ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->计费月份Label = (gcnew System::Windows::Forms::Label());
			this->计费年份ComboBox = (gcnew System::Windows::Forms::ComboBox());
			this->计费年份Label = (gcnew System::Windows::Forms::Label());
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->水电气费DataGridView))->BeginInit();
			this->SuspendLayout();
			// 
			// 水电气费DataGridView
			// 
			this->水电气费DataGridView->AllowUserToAddRows = false;
			this->水电气费DataGridView->AllowUserToDeleteRows = 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->BackgroundColor = System::Drawing::Color::LightGray;
			this->水电气费DataGridView->ColumnHeadersBorderStyle = System::Windows::Forms::DataGridViewHeaderBorderStyle::Sunken;
			dataGridViewCellStyle1->Alignment = System::Windows::Forms::DataGridViewContentAlignment::MiddleCenter;
			dataGridViewCellStyle1->BackColor = System::Drawing::SystemColors::ActiveCaption;
			dataGridViewCellStyle1->Font = (gcnew System::Drawing::Font(L"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, 
				static_cast<System::Byte>(134)));
			dataGridViewCellStyle1->ForeColor = System::Drawing::SystemColors::WindowText;
			dataGridViewCellStyle1->SelectionBackColor = System::Drawing::SystemColors::Highlight;
			dataGridViewCellStyle1->SelectionForeColor = System::Drawing::SystemColors::GradientActiveCaption;
			dataGridViewCellStyle1->WrapMode = System::Windows::Forms::DataGridViewTriState::True;
			this->水电气费DataGridView->ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
			this->水电气费DataGridView->Location = System::Drawing::Point(10, 61);
			this->水电气费DataGridView->MultiSelect = false;
			this->水电气费DataGridView->Name = L"水电气费DataGridView";
			this->水电气费DataGridView->ReadOnly = true;
			dataGridViewCellStyle2->Alignment = System::Windows::Forms::DataGridViewContentAlignment::TopCenter;
			dataGridViewCellStyle2->BackColor = System::Drawing::SystemColors::Control;
			dataGridViewCellStyle2->Font = (gcnew System::Drawing::Font(L"宋体", 9, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, 
				static_cast<System::Byte>(134)));
			dataGridViewCellStyle2->ForeColor = System::Drawing::SystemColors::WindowText;
			dataGridViewCellStyle2->SelectionBackColor = System::Drawing::SystemColors::Highlight;
			dataGridViewCellStyle2->SelectionForeColor = System::Drawing::SystemColors::HighlightText;
			dataGridViewCellStyle2->WrapMode = System::Windows::Forms::DataGridViewTriState::True;
			this->水电气费DataGridView->RowHeadersDefaultCellStyle = dataGridViewCellStyle2;
			this->水电气费DataGridView->RowHeadersVisible = false;
			dataGridViewCellStyle3->SelectionBackColor = System::Drawing::Color::Green;
			this->水电气费DataGridView->RowsDefaultCellStyle = dataGridViewCellStyle3;
			this->水电气费DataGridView->RowTemplate->Height = 23;
			this->水电气费DataGridView->SelectionMode = System::Windows::Forms::DataGridViewSelectionMode::FullRowSelect;
			this->水电气费DataGridView->Size = System::Drawing::Size(523, 345);
			this->水电气费DataGridView->TabIndex = 49;
			// 
			// 打印Button
			// 
			this->打印Button->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"打印Button.Image")));
			this->打印Button->Location = System::Drawing::Point(467, 30);
			this->打印Button->Name = L"打印Button";
			this->打印Button->Size = System::Drawing::Size(67, 23);
			this->打印Button->TabIndex = 48;
			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, &GasQueryForm::打印Button_Click);
			// 
			// 费用状态ComboBox
			// 
			this->费用状态ComboBox->FormattingEnabled = true;
			this->费用状态ComboBox->Location = System::Drawing::Point(379, 31);
			this->费用状态ComboBox->Name = L"费用状态ComboBox";
			this->费用状态ComboBox->Size = System::Drawing::Size(81, 20);
			this->费用状态ComboBox->TabIndex = 47;
			this->费用状态ComboBox->Text = L"全部";
			// 
			// 费用状态Label
			// 
			this->费用状态Label->AutoSize = true;
			this->费用状态Label->Location = System::Drawing::Point(311, 36);
			this->费用状态Label->Name = L"费用状态Label";
			this->费用状态Label->Size = System::Drawing::Size(65, 12);
			this->费用状态Label->TabIndex = 46;
			this->费用状态Label->Text = L"费用状态：";
			// 
			// 业主姓名ComboBox
			// 
			this->业主姓名ComboBox->FormattingEnabled = true;
			this->业主姓名ComboBox->Location = System::Drawing::Point(230, 31);
			this->业主姓名ComboBox->Name = L"业主姓名ComboBox";
			this->业主姓名ComboBox->Size = System::Drawing::Size(75, 20);
			this->业主姓名ComboBox->TabIndex = 45;
			this->业主姓名ComboBox->Text = L"全部";
			// 
			// 业主姓名Label
			// 
			this->业主姓名Label->AutoSize = true;
			this->业主姓名Label->Location = System::Drawing::Point(162, 36);
			this->业主姓名Label->Name = L"业主姓名Label";
			this->业主姓名Label->Size = System::Drawing::Size(65, 12);
			this->业主姓名Label->TabIndex = 44;
			this->业主姓名Label->Text = L"业主姓名：";
			// 
			// 楼栋名称ComboBox
			// 
			this->楼栋名称ComboBox->FormattingEnabled = true;
			this->楼栋名称ComboBox->Location = System::Drawing::Point(73, 31);
			this->楼栋名称ComboBox->Name = L"楼栋名称ComboBox";
			this->楼栋名称ComboBox->Size = System::Drawing::Size(81, 20);
			this->楼栋名称ComboBox->TabIndex = 43;
			this->楼栋名称ComboBox->Text = L"全部";
			this->楼栋名称ComboBox->SelectedIndexChanged += gcnew System::EventHandler(this, &GasQueryForm::楼栋名称ComboBox_SelectedIndexChanged);
			// 
			// 楼栋名称Label
			// 
			this->楼栋名称Label->AutoSize = true;
			this->楼栋名称Label->Location = System::Drawing::Point(8, 36);
			this->楼栋名称Label->Name = L"楼栋名称Label";
			this->楼栋名称Label->Size = System::Drawing::Size(65, 12);
			this->楼栋名称Label->TabIndex = 42;
			this->楼栋名称Label->Text = L"楼栋名称：";
			// 
			// 查询Button
			// 
			this->查询Button->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"查询Button.Image")));
			this->查询Button->Location = System::Drawing::Point(467, 6);
			this->查询Button->Name = L"查询Button";
			this->查询Button->Size = System::Drawing::Size(67, 23);
			this->查询Button->TabIndex = 41;
			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, &GasQueryForm::查询Button_Click);
			// 
			// 费用类型ComboBox
			// 
			this->费用类型ComboBox->FormattingEnabled = true;
			this->费用类型ComboBox->Location = System::Drawing::Point(380, 8);
			this->费用类型ComboBox->Name = L"费用类型ComboBox";