📄 leaseform.h
字号:
this->bindingNavigatorPositionItem->Text = L"0";
this->bindingNavigatorPositionItem->ToolTipText = L"当前位置";
//
// bindingNavigatorSeparator1
//
this->bindingNavigatorSeparator1->Name = L"bindingNavigatorSeparator1";
this->bindingNavigatorSeparator1->Size = System::Drawing::Size(6, 25);
//
// bindingNavigatorMoveNextItem
//
this->bindingNavigatorMoveNextItem->DisplayStyle = System::Windows::Forms::ToolStripItemDisplayStyle::Image;
this->bindingNavigatorMoveNextItem->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"bindingNavigatorMoveNextItem.Image")));
this->bindingNavigatorMoveNextItem->Name = L"bindingNavigatorMoveNextItem";
this->bindingNavigatorMoveNextItem->RightToLeftAutoMirrorImage = true;
this->bindingNavigatorMoveNextItem->Size = System::Drawing::Size(23, 22);
this->bindingNavigatorMoveNextItem->Text = L"移到下一条记录";
//
// bindingNavigatorMoveLastItem
//
this->bindingNavigatorMoveLastItem->DisplayStyle = System::Windows::Forms::ToolStripItemDisplayStyle::Image;
this->bindingNavigatorMoveLastItem->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"bindingNavigatorMoveLastItem.Image")));
this->bindingNavigatorMoveLastItem->Name = L"bindingNavigatorMoveLastItem";
this->bindingNavigatorMoveLastItem->RightToLeftAutoMirrorImage = true;
this->bindingNavigatorMoveLastItem->Size = System::Drawing::Size(23, 22);
this->bindingNavigatorMoveLastItem->Text = L"移到最后一条记录";
//
// bindingNavigatorSeparator2
//
this->bindingNavigatorSeparator2->Name = L"bindingNavigatorSeparator2";
this->bindingNavigatorSeparator2->Size = System::Drawing::Size(6, 25);
//
// 租借固定资产BindingNavigatorSaveItem
//
this->租借固定资产BindingNavigatorSaveItem->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"租借固定资产BindingNavigatorSaveItem.Image")));
this->租借固定资产BindingNavigatorSaveItem->Name = L"租借固定资产BindingNavigatorSaveItem";
this->租借固定资产BindingNavigatorSaveItem->Size = System::Drawing::Size(49, 22);
this->租借固定资产BindingNavigatorSaveItem->Text = L"保存";
this->租借固定资产BindingNavigatorSaveItem->Click += gcnew System::EventHandler(this, &LeaseForm::租借固定资产BindingNavigatorSaveItem_Click);
//
// dataGridViewTextBoxColumn3
//
this->dataGridViewTextBoxColumn3->DataPropertyName = L"名称";
this->dataGridViewTextBoxColumn3->HeaderText = L"名称";
this->dataGridViewTextBoxColumn3->Name = L"dataGridViewTextBoxColumn3";
this->dataGridViewTextBoxColumn3->ReadOnly = true;
//
// dataGridViewTextBoxColumn4
//
this->dataGridViewTextBoxColumn4->DataPropertyName = L"数量";
this->dataGridViewTextBoxColumn4->HeaderText = L"数量";
this->dataGridViewTextBoxColumn4->Name = L"dataGridViewTextBoxColumn4";
this->dataGridViewTextBoxColumn4->ReadOnly = true;
//
// dataGridViewTextBoxColumn1
//
this->dataGridViewTextBoxColumn1->DataPropertyName = L"自编号";
this->dataGridViewTextBoxColumn1->HeaderText = L"自编号";
this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";
this->dataGridViewTextBoxColumn1->ReadOnly = true;
//
// dataGridViewTextBoxColumn2
//
this->dataGridViewTextBoxColumn2->DataPropertyName = L"资产编号";
this->dataGridViewTextBoxColumn2->HeaderText = L"资产编号";
this->dataGridViewTextBoxColumn2->Name = L"dataGridViewTextBoxColumn2";
this->dataGridViewTextBoxColumn2->ReadOnly = true;
//
// dataGridViewTextBoxColumn5
//
this->dataGridViewTextBoxColumn5->DataPropertyName = L"单位";
this->dataGridViewTextBoxColumn5->HeaderText = L"单位";
this->dataGridViewTextBoxColumn5->Name = L"dataGridViewTextBoxColumn5";
this->dataGridViewTextBoxColumn5->ReadOnly = true;
//
// dataGridViewTextBoxColumn8
//
this->dataGridViewTextBoxColumn8->DataPropertyName = L"拟还日期";
this->dataGridViewTextBoxColumn8->HeaderText = L"拟还日期";
this->dataGridViewTextBoxColumn8->Name = L"dataGridViewTextBoxColumn8";
this->dataGridViewTextBoxColumn8->ReadOnly = true;
//
// dataGridViewTextBoxColumn9
//
this->dataGridViewTextBoxColumn9->DataPropertyName = L"预期收益";
this->dataGridViewTextBoxColumn9->HeaderText = L"预期收益";
this->dataGridViewTextBoxColumn9->Name = L"dataGridViewTextBoxColumn9";
this->dataGridViewTextBoxColumn9->ReadOnly = true;
//
// dataGridViewTextBoxColumn6
//
this->dataGridViewTextBoxColumn6->DataPropertyName = L"租借公司";
this->dataGridViewTextBoxColumn6->HeaderText = L"租借公司";
this->dataGridViewTextBoxColumn6->Name = L"dataGridViewTextBoxColumn6";
this->dataGridViewTextBoxColumn6->ReadOnly = true;
//
// dataGridViewTextBoxColumn7
//
this->dataGridViewTextBoxColumn7->DataPropertyName = L"租借日期";
this->dataGridViewTextBoxColumn7->HeaderText = L"租借日期";
this->dataGridViewTextBoxColumn7->Name = L"dataGridViewTextBoxColumn7";
this->dataGridViewTextBoxColumn7->ReadOnly = true;
//
// 租借固定资产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->AutoGenerateColumns = false;
this->租借固定资产DataGridView->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(11) {this->dataGridViewTextBoxColumn1,
this->dataGridViewTextBoxColumn2, this->dataGridViewTextBoxColumn3, this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5,
this->dataGridViewTextBoxColumn6, this->dataGridViewTextBoxColumn7, this->dataGridViewTextBoxColumn8, this->dataGridViewTextBoxColumn9,
this->dataGridViewTextBoxColumn10, this->dataGridViewTextBoxColumn11});
this->租借固定资产DataGridView->DataSource = this->租借固定资产BindingSource;
this->租借固定资产DataGridView->Location = System::Drawing::Point(5, 285);
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(530, 126);
this->租借固定资产DataGridView->TabIndex = 27;
//
// LeaseForm
//
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->单位TextBox);
this->Controls->Add(this->数量TextBox);
this->Controls->Add(this->租借公司TextBox);
this->Controls->Add(this->租借日期DateTimePicker);
this->Controls->Add(this->拟还日期DateTimePicker);
this->Controls->Add(this->预期收益TextBox);
this->Controls->Add(this->经办人TextBox);
this->Controls->Add(this->说明TextBox);
this->Controls->Add(this->可用固定资产视图DataGridView);
this->Controls->Add(this->名称TextBox);
this->Controls->Add(this->自编号TextBox);
this->Controls->Add(this->资产编号TextBox);
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(经办人Label);
this->Controls->Add(说明Label);
this->Controls->Add(this->租借固定资产BindingNavigator);
this->Controls->Add(this->租借固定资产DataGridView);
this->Name = L"LeaseForm";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"登记借出的固定资产";
this->Load += gcnew System::EventHandler(this, &LeaseForm::LeaseForm_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->MyAssetsDataSet))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->租借固定资产BindingSource))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->可用固定资产视图BindingSource))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->可用固定资产视图DataGridView))->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
private: static String^ MyAssetsConnectionString= L"Data Source=.;Initial Catalog=MyAssets;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->MyAssetsDataSet->租借固定资产);
}
private: System::Void LeaseForm_Load(System::Object^ sender, System::EventArgs^ e) {
// TODO: 这行代码将数据加载到表“MyAssetsDataSet.租借固定资产”中。您可以根据需要移动或移除它。
this->租借固定资产TableAdapter->Fill(this->MyAssetsDataSet->租借固定资产);
}
private: System::Void bindingNavigatorAddNewItem_MouseUp(System::Object^ sender, System::Windows::Forms::MouseEventArgs^ e) {
查询ToolStripButton_Click(nullptr, nullptr);
//自动计算自编号
String^ MySQLConnectionString = MyAssetsConnectionString;
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
SqlCommand^ MyCommand = MyConnection->CreateCommand();
MyCommand->CommandText = "Select max(自编号) 最大编号 From 租借固定资产";
System::Object^ MyResult = MyCommand->ExecuteScalar();
System::Int64 MyID = 1;
if (MyResult != System::DBNull::Value)
{
String^ MyMaxID = MyResult->ToString()->Trim();
MyMaxID = MyMaxID->Substring(2, MyMaxID->Length - 2);
MyID = Convert::ToInt64(MyMaxID) + 1;
}
int MyLength = MyID.ToString()->Length;
String^ MyNewID = "";
switch (MyLength)
{
case 1:
MyNewID = "ZJ0000000" + MyID.ToString();
break;
case 2:
MyNewID = "ZJ000000" + MyID.ToString();
break;
case 3:
MyNewID = "ZJ00000" + MyID.ToString();
break;
case 4:
MyNewID = "ZJ0000" + MyID.ToString();
break;
case 5:
MyNewID = "ZJ000" + MyID.ToString();
break;
case 6:
MyNewID = "ZJ00" + MyID.ToString();
break;
case 7:
MyNewID = "ZJ0" + MyID.ToString();
break;
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
this->自编号TextBox->Text = MyNewID;
}
private: System::Void 查询ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e) {
try
{
this->可用固定资产视图TableAdapter->Fill(this->MyAssetsDataSet->可用固定资产视图, 名称ToolStripTextBox->Text);
}
catch (System::Exception^ ex)
{
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
private: System::Void 可用固定资产视图DataGridView_Click(System::Object^ sender, System::EventArgs^ e) {
this->资产编号TextBox->Text =this->可用固定资产视图DataGridView->CurrentRow->Cells[1]->Value->ToString();
this->名称TextBox->Text = this->可用固定资产视图DataGridView->CurrentRow->Cells[2]->Value->ToString();
this->数量TextBox->Text = this->可用固定资产视图DataGridView->CurrentRow->Cells[12]->Value->ToString();
this->单位TextBox->Text = this->可用固定资产视图DataGridView->CurrentRow->Cells[13]->Value->ToString();
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -