commonpropertyform.h

小区物业管理系统

			// 
			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->AutoGenerateColumns = false;
			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->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^  >(10) {this->财产编号DataGridViewTextBoxColumn, 
				this->财产名称DataGridViewTextBoxColumn, this->规格型号DataGridViewTextBoxColumn, this->所属类别DataGridViewTextBoxColumn, this->财产原值DataGridViewTextBoxColumn, 
				this->启用日期DataGridViewTextBoxColumn, this->存放位置DataGridViewTextBoxColumn, this->当前状态DataGridViewTextBoxColumn, this->保管人员DataGridViewTextBoxColumn, 
				this->补充说明DataGridViewTextBoxColumn});
			this->公共财产DataGridView->DataSource = this->公共财产BindingSource;
			this->公共财产DataGridView->Location = System::Drawing::Point(7, 128);
			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(529, 282);
			this->公共财产DataGridView->TabIndex = 46;
			// 
			// 财产名称DataGridViewTextBoxColumn
			// 
			this->财产名称DataGridViewTextBoxColumn->DataPropertyName = L"财产名称";
			this->财产名称DataGridViewTextBoxColumn->HeaderText = L"财产名称";
			this->财产名称DataGridViewTextBoxColumn->Name = L"财产名称DataGridViewTextBoxColumn";
			this->财产名称DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 规格型号DataGridViewTextBoxColumn
			// 
			this->规格型号DataGridViewTextBoxColumn->DataPropertyName = L"规格型号";
			this->规格型号DataGridViewTextBoxColumn->HeaderText = L"规格型号";
			this->规格型号DataGridViewTextBoxColumn->Name = L"规格型号DataGridViewTextBoxColumn";
			this->规格型号DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 所属类别DataGridViewTextBoxColumn
			// 
			this->所属类别DataGridViewTextBoxColumn->DataPropertyName = L"所属类别";
			this->所属类别DataGridViewTextBoxColumn->HeaderText = L"所属类别";
			this->所属类别DataGridViewTextBoxColumn->Name = L"所属类别DataGridViewTextBoxColumn";
			this->所属类别DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 财产原值DataGridViewTextBoxColumn
			// 
			this->财产原值DataGridViewTextBoxColumn->DataPropertyName = L"财产原值";
			this->财产原值DataGridViewTextBoxColumn->HeaderText = L"财产原值";
			this->财产原值DataGridViewTextBoxColumn->Name = L"财产原值DataGridViewTextBoxColumn";
			this->财产原值DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 启用日期DataGridViewTextBoxColumn
			// 
			this->启用日期DataGridViewTextBoxColumn->DataPropertyName = L"启用日期";
			this->启用日期DataGridViewTextBoxColumn->HeaderText = L"启用日期";
			this->启用日期DataGridViewTextBoxColumn->Name = L"启用日期DataGridViewTextBoxColumn";
			this->启用日期DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 存放位置DataGridViewTextBoxColumn
			// 
			this->存放位置DataGridViewTextBoxColumn->DataPropertyName = L"存放位置";
			this->存放位置DataGridViewTextBoxColumn->HeaderText = L"存放位置";
			this->存放位置DataGridViewTextBoxColumn->Name = L"存放位置DataGridViewTextBoxColumn";
			this->存放位置DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 当前状态DataGridViewTextBoxColumn
			// 
			this->当前状态DataGridViewTextBoxColumn->DataPropertyName = L"当前状态";
			this->当前状态DataGridViewTextBoxColumn->HeaderText = L"当前状态";
			this->当前状态DataGridViewTextBoxColumn->Name = L"当前状态DataGridViewTextBoxColumn";
			this->当前状态DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 保管人员DataGridViewTextBoxColumn
			// 
			this->保管人员DataGridViewTextBoxColumn->DataPropertyName = L"保管人员";
			this->保管人员DataGridViewTextBoxColumn->HeaderText = L"保管人员";
			this->保管人员DataGridViewTextBoxColumn->Name = L"保管人员DataGridViewTextBoxColumn";
			this->保管人员DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 补充说明DataGridViewTextBoxColumn
			// 
			this->补充说明DataGridViewTextBoxColumn->DataPropertyName = L"补充说明";
			this->补充说明DataGridViewTextBoxColumn->HeaderText = L"补充说明";
			this->补充说明DataGridViewTextBoxColumn->Name = L"补充说明DataGridViewTextBoxColumn";
			this->补充说明DataGridViewTextBoxColumn->ReadOnly = true;
			// 
			// 保管人员TextBox
			// 
			this->保管人员TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"保管人员", true)));
			this->保管人员TextBox->Location = System::Drawing::Point(444, 76);
			this->保管人员TextBox->Name = L"保管人员TextBox";
			this->保管人员TextBox->Size = System::Drawing::Size(92, 21);
			this->保管人员TextBox->TabIndex = 43;
			// 
			// 补充说明TextBox
			// 
			this->补充说明TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"补充说明", true)));
			this->补充说明TextBox->Location = System::Drawing::Point(68, 101);
			this->补充说明TextBox->Name = L"补充说明TextBox";
			this->补充说明TextBox->Size = System::Drawing::Size(468, 21);
			this->补充说明TextBox->TabIndex = 45;
			this->补充说明TextBox->Text = L"暂无";
			// 
			// 当前状态TextBox
			// 
			this->当前状态TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"当前状态", true)));
			this->当前状态TextBox->Location = System::Drawing::Point(300, 76);
			this->当前状态TextBox->Name = L"当前状态TextBox";
			this->当前状态TextBox->Size = System::Drawing::Size(73, 21);
			this->当前状态TextBox->TabIndex = 41;
			// 
			// 财产编号TextBox
			// 
			this->财产编号TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"财产编号", true)));
			this->财产编号TextBox->Location = System::Drawing::Point(67, 28);
			this->财产编号TextBox->Name = L"财产编号TextBox";
			this->财产编号TextBox->Size = System::Drawing::Size(113, 21);
			this->财产编号TextBox->TabIndex = 27;
			// 
			// 财产名称TextBox
			// 
			this->财产名称TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"财产名称", true)));
			this->财产名称TextBox->Location = System::Drawing::Point(246, 28);
			this->财产名称TextBox->Name = L"财产名称TextBox";
			this->财产名称TextBox->Size = System::Drawing::Size(107, 21);
			this->财产名称TextBox->TabIndex = 29;
			// 
			// 规格型号TextBox
			// 
			this->规格型号TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"规格型号", true)));
			this->规格型号TextBox->Location = System::Drawing::Point(421, 28);
			this->规格型号TextBox->Name = L"规格型号TextBox";
			this->规格型号TextBox->Size = System::Drawing::Size(115, 21);
			this->规格型号TextBox->TabIndex = 31;
			// 
			// 所属类别TextBox
			// 
			this->所属类别TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"所属类别", true)));
			this->所属类别TextBox->Location = System::Drawing::Point(67, 52);
			this->所属类别TextBox->Name = L"所属类别TextBox";
			this->所属类别TextBox->Size = System::Drawing::Size(87, 21);
			this->所属类别TextBox->TabIndex = 33;
			// 
			// 财产原值TextBox
			// 
			this->财产原值TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"财产原值", true)));
			this->财产原值TextBox->Location = System::Drawing::Point(246, 52);
			this->财产原值TextBox->Name = L"财产原值TextBox";
			this->财产原值TextBox->Size = System::Drawing::Size(88, 21);
			this->财产原值TextBox->TabIndex = 35;
			// 
			// 启用日期DateTimePicker
			// 
			this->启用日期DateTimePicker->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Value", this->公共财产BindingSource, L"启用日期", 
				true)));
			this->启用日期DateTimePicker->Location = System::Drawing::Point(405, 52);
			this->启用日期DateTimePicker->Name = L"启用日期DateTimePicker";
			this->启用日期DateTimePicker->Size = System::Drawing::Size(132, 21);
			this->启用日期DateTimePicker->TabIndex = 37;
			// 
			// 存放位置TextBox
			// 
			this->存放位置TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->公共财产BindingSource, L"存放位置", true)));
			this->存放位置TextBox->Location = System::Drawing::Point(67, 76);
			this->存放位置TextBox->Name = L"存放位置TextBox";
			this->存放位置TextBox->Size = System::Drawing::Size(163, 21);
			this->存放位置TextBox->TabIndex = 39;
			// 
			// CommonPropertyForm
			// 
			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->公共财产DataGridView);
			this->Controls->Add(财产编号Label);
			this->Controls->Add(财产名称Label);
			this->Controls->Add(规格型号Label);
			this->Controls->Add(所属类别Label);
			this->Controls->Add(财产原值Label);
			this->Controls->Add(启用日期Label);
			this->Controls->Add(存放位置Label);
			this->Controls->Add(当前状态Label);
			this->Controls->Add(保管人员Label);
			this->Controls->Add(this->保管人员TextBox);
			this->Controls->Add(补充说明Label);
			this->Controls->Add(this->补充说明TextBox);
			this->Controls->Add(this->当前状态TextBox);
			this->Controls->Add(this->财产编号TextBox);
			this->Controls->Add(this->财产名称TextBox);
			this->Controls->Add(this->规格型号TextBox);
			this->Controls->Add(this->所属类别TextBox);
			this->Controls->Add(this->财产原值TextBox);
			this->Controls->Add(this->启用日期DateTimePicker);
			this->Controls->Add(this->存放位置TextBox);
			this->Controls->Add(this->公共财产BindingNavigator);
			this->Name = L"CommonPropertyForm";
			this->ShowInTaskbar = false;
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
			this->Text = L"基本管理[公共财产管理]";
			this->Load += gcnew System::EventHandler(this, &CommonPropertyForm::CommonPropertyForm_Load);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->DBCommunityDataSet))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->公共财产BindingSource))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->公共财产BindingNavigator))->EndInit();
			this->公共财产BindingNavigator->ResumeLayout(false);
			this->公共财产BindingNavigator->PerformLayout();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->公共财产DataGridView))->EndInit();
			this->ResumeLayout(false);
			this->PerformLayout();

		}
#pragma endregion
	public:String^ MyCommunity;
	private: System::Void CommonPropertyForm_Load(System::Object^  sender, System::EventArgs^  e) 
	{// TODO: 这行代码将数据加载到表“DBCommunityDataSet.公共财产”中
      this->公共财产TableAdapter->Fill(this->DBCommunityDataSet->公共财产);
	}
	private: System::Void 公共财产BindingNavigatorSaveItem_Click(System::Object^  sender, System::EventArgs^  e) 
	{
	  this->Validate();
	  this->公共财产BindingSource->EndEdit();
	  this->公共财产TableAdapter->Update(this->DBCommunityDataSet->公共财产);
	}
	private: System::Void 打印ToolStripButton_Click(System::Object^  sender, System::EventArgs^  e) 
	{//打印公共财产信息
	  ApplicationClass^ MyExcel;
	  Workbooks^ MyWorkBooks;
	  Workbook^ MyWorkBook;
	  Worksheet^ MyWorkSheet;
	  char MyColumns;
	  int Count,i,j;
	  Range^ MyRange;
	  array<System::Object^,2>^ MyData=gcnew array<System::Object^,2>(5000,30);
	  MyExcel = gcnew ApplicationClass();
	  MyExcel->Visible = true;
	  if (MyExcel == nullptr)
	  {
		MessageBox::Show("Excel程序无法启动！", "信息提示", MessageBoxButtons::OK, MessageBoxIcon::Information);
		return;
	  }
	  MyWorkBooks = MyExcel->Workbooks;
	  MyWorkBook = MyWorkBooks->Add(Missing::Value);
	  MyWorkSheet = (Worksheet^)MyWorkBook->Worksheets[1];
	  MyColumns = (char)(this->DBCommunityDataSet->公共财产->Columns->Count + 64);
	  array<System::Byte>^ MyBytes =gcnew array<System::Byte> {MyColumns};
	  System::Text::UTF8Encoding^ MyEncoding=gcnew System::Text::UTF8Encoding();
	  MyRange = MyWorkSheet->Range["A5", MyEncoding->GetString(MyBytes) + "5"];
	  Count = 0;
	  for each (DataColumn^ MyNewColumn in this->DBCommunityDataSet->公共财产->Columns)
	  {
		MyData[0, Count] = MyNewColumn->ColumnName;
		Count = Count + 1;
	  }
	  j = 1;
	  //输出数据库记录
	  for each (DataRow^ MyRow in this->DBCommunityDataSet->公共财产->Rows)
	  {
		for (i = 0; i < this->DBCommunityDataSet->公共财产->Columns->Count; i++)
		{
	      if (i == 5)
          {
			MyData[j, i] = DateTime::Parse(MyRow[i]->ToString()).ToShortDateString();
          }
		  else
		  {
		    MyData[j, i] = MyRow[i]->ToString();
		  }
		}
		j++;
	  }
	  MyRange = MyRange->Resize[this->DBCommunityDataSet->公共财产->Rows->Count + 1, this->DBCommunityDataSet->公共财产->Columns->Count];
	  MyRange->Value2 = MyData;
	  MyRange->EntireColumn->AutoFit();
	  MyWorkSheet->Cells[2, 2] = this->MyCommunity+ "公共财产信息表";
      Range^ MyRange22 = MyWorkSheet->Range["B2", "B2"];
      MyRange22->Font->Bold = true;
      MyRange22->Font->Size = "20";
	  MyWorkSheet->Cells[4, 1] = "打印日期：" + DateTime::Now.ToShortDateString();
	}
  };
}