querydepreciationform.h

vc++开发环境SQL数据库固定资产管理系统

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

	protected:
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		~QueryDepreciationForm()
		{
			if (components)
			{
				delete components;
			}
		}
	private: My::MyAssetsDataSet^  MyAssetsDataSet;
	protected: 
	private: System::Windows::Forms::BindingSource^  累计折旧查询视图BindingSource;
	private: My::MyAssetsDataSetTableAdapters::累计折旧查询视图TableAdapter^  累计折旧查询视图TableAdapter;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn2;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn3;
	private: System::Windows::Forms::DataGridView^  累计折旧查询视图DataGridView;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn1;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn4;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn5;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn7;
	private: System::Windows::Forms::DataGridViewTextBoxColumn^  dataGridViewTextBoxColumn10;
	private: System::Windows::Forms::ToolStripComboBox^  折旧年份ToolStripComboBox;
	private: System::Windows::Forms::ToolStripLabel^  折旧年份ToolStripLabel;
	private: System::Windows::Forms::ToolStrip^  fillToolStrip;
	private: System::Windows::Forms::ToolStripLabel^  折旧月份ToolStripLabel;
	private: System::Windows::Forms::ToolStripComboBox^  折旧月份ToolStripComboBox;
	private: System::Windows::Forms::ToolStripButton^  查询ToolStripButton;
	private: System::Windows::Forms::ToolStripButton^  打印ToolStripButton;






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


#pragma region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要
		/// 使用代码编辑器修改此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->components = (gcnew System::ComponentModel::Container());
			System::ComponentModel::ComponentResourceManager^  resources = (gcnew System::ComponentModel::ComponentResourceManager(QueryDepreciationForm::typeid));
			this->MyAssetsDataSet = (gcnew My::MyAssetsDataSet());
			this->累计折旧查询视图BindingSource = (gcnew System::Windows::Forms::BindingSource(this->components));
			this->累计折旧查询视图TableAdapter = (gcnew My::MyAssetsDataSetTableAdapters::累计折旧查询视图TableAdapter());
			this->dataGridViewTextBoxColumn2 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->dataGridViewTextBoxColumn3 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->累计折旧查询视图DataGridView = (gcnew System::Windows::Forms::DataGridView());
			this->dataGridViewTextBoxColumn1 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->dataGridViewTextBoxColumn4 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->dataGridViewTextBoxColumn5 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->dataGridViewTextBoxColumn7 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->dataGridViewTextBoxColumn10 = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
			this->折旧年份ToolStripComboBox = (gcnew System::Windows::Forms::ToolStripComboBox());
			this->折旧年份ToolStripLabel = (gcnew System::Windows::Forms::ToolStripLabel());
			this->fillToolStrip = (gcnew System::Windows::Forms::ToolStrip());
			this->折旧月份ToolStripLabel = (gcnew System::Windows::Forms::ToolStripLabel());
			this->折旧月份ToolStripComboBox = (gcnew System::Windows::Forms::ToolStripComboBox());
			this->查询ToolStripButton = (gcnew System::Windows::Forms::ToolStripButton());
			this->打印ToolStripButton = (gcnew System::Windows::Forms::ToolStripButton());
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->MyAssetsDataSet))->BeginInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->累计折旧查询视图BindingSource))->BeginInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->累计折旧查询视图DataGridView))->BeginInit();
			this->fillToolStrip->SuspendLayout();
			this->SuspendLayout();
			// 
			// MyAssetsDataSet
			// 
			this->MyAssetsDataSet->DataSetName = L"MyAssetsDataSet";
			this->MyAssetsDataSet->SchemaSerializationMode = System::Data::SchemaSerializationMode::IncludeSchema;
			// 
			// 累计折旧查询视图BindingSource
			// 
			this->累计折旧查询视图BindingSource->DataMember = L"累计折旧查询视图";
			this->累计折旧查询视图BindingSource->DataSource = this->MyAssetsDataSet;
			// 
			// 累计折旧查询视图TableAdapter
			// 
			this->累计折旧查询视图TableAdapter->ClearBeforeFill = true;
			// 
			// dataGridViewTextBoxColumn2
			// 
			this->dataGridViewTextBoxColumn2->DataPropertyName = L"类别";
			this->dataGridViewTextBoxColumn2->HeaderText = L"  类别";
			this->dataGridViewTextBoxColumn2->Name = L"dataGridViewTextBoxColumn2";
			this->dataGridViewTextBoxColumn2->ReadOnly = true;
			this->dataGridViewTextBoxColumn2->Width = 60;
			// 
			// dataGridViewTextBoxColumn3
			// 
			this->dataGridViewTextBoxColumn3->DataPropertyName = L"资产编号";
			this->dataGridViewTextBoxColumn3->HeaderText = L"资产编号";
			this->dataGridViewTextBoxColumn3->Name = L"dataGridViewTextBoxColumn3";
			this->dataGridViewTextBoxColumn3->ReadOnly = true;
			this->dataGridViewTextBoxColumn3->Width = 80;
			// 
			// 累计折旧查询视图DataGridView
			// 
			this->累计折旧查询视图DataGridView->AllowUserToAddRows = false;
			this->累计折旧查询视图DataGridView->AllowUserToDeleteRows = false;
			this->累计折旧查询视图DataGridView->AllowUserToResizeRows = false;
			this->累计折旧查询视图DataGridView->AutoGenerateColumns = false;
			this->累计折旧查询视图DataGridView->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^  >(7) {this->dataGridViewTextBoxColumn1, 
				this->dataGridViewTextBoxColumn2, this->dataGridViewTextBoxColumn3, this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5, 
				this->dataGridViewTextBoxColumn7, this->dataGridViewTextBoxColumn10});
			this->累计折旧查询视图DataGridView->DataSource = this->累计折旧查询视图BindingSource;
			this->累计折旧查询视图DataGridView->Dock = System::Windows::Forms::DockStyle::Fill;
			this->累计折旧查询视图DataGridView->Location = System::Drawing::Point(0, 25);
			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(542, 391);
			this->累计折旧查询视图DataGridView->TabIndex = 5;
			// 
			// dataGridViewTextBoxColumn1
			// 
			this->dataGridViewTextBoxColumn1->DataPropertyName = L"使用部门";
			this->dataGridViewTextBoxColumn1->HeaderText = L"使用部门";
			this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";
			this->dataGridViewTextBoxColumn1->ReadOnly = true;
			this->dataGridViewTextBoxColumn1->Width = 60;
			// 
			// dataGridViewTextBoxColumn4
			// 
			this->dataGridViewTextBoxColumn4->DataPropertyName = L"名称";
			this->dataGridViewTextBoxColumn4->HeaderText = L"        名称";
			this->dataGridViewTextBoxColumn4->Name = L"dataGridViewTextBoxColumn4";
			this->dataGridViewTextBoxColumn4->ReadOnly = true;
			this->dataGridViewTextBoxColumn4->Width = 120;
			// 
			// dataGridViewTextBoxColumn5
			// 
			this->dataGridViewTextBoxColumn5->DataPropertyName = L"资产原值";
			this->dataGridViewTextBoxColumn5->HeaderText = L"资产原值";
			this->dataGridViewTextBoxColumn5->Name = L"dataGridViewTextBoxColumn5";
			this->dataGridViewTextBoxColumn5->ReadOnly = true;
			this->dataGridViewTextBoxColumn5->Width = 60;
			// 
			// dataGridViewTextBoxColumn7
			// 
			this->dataGridViewTextBoxColumn7->DataPropertyName = L"折旧方法";
			this->dataGridViewTextBoxColumn7->HeaderText = L"折旧方法";
			this->dataGridViewTextBoxColumn7->Name = L"dataGridViewTextBoxColumn7";
			this->dataGridViewTextBoxColumn7->ReadOnly = true;
			this->dataGridViewTextBoxColumn7->Width = 70;
			// 
			// dataGridViewTextBoxColumn10
			// 
			this->dataGridViewTextBoxColumn10->DataPropertyName = L"月度折旧额";
			this->dataGridViewTextBoxColumn10->HeaderText = L"月度折旧额";
			this->dataGridViewTextBoxColumn10->Name = L"dataGridViewTextBoxColumn10";
			this->dataGridViewTextBoxColumn10->ReadOnly = true;
			this->dataGridViewTextBoxColumn10->Width = 70;
			// 
			// 折旧年份ToolStripComboBox
			// 
			this->折旧年份ToolStripComboBox->DropDownStyle = System::Windows::Forms::ComboBoxStyle::DropDownList;
			this->折旧年份ToolStripComboBox->Name = L"折旧年份ToolStripComboBox";
			this->折旧年份ToolStripComboBox->Size = System::Drawing::Size(75, 25);
			// 
			// 折旧年份ToolStripLabel
			// 
			this->折旧年份ToolStripLabel->Name = L"折旧年份ToolStripLabel";
			this->折旧年份ToolStripLabel->Size = System::Drawing::Size(59, 22);
			this->折旧年份ToolStripLabel->Text = L"折旧年份:";
			//