📄 contactform.h
字号:
this->bindingNavigatorDeleteItem->Size = System::Drawing::Size(49, 22);
this->bindingNavigatorDeleteItem->Text = L"删除";
//
// bindingNavigatorCountItem
//
this->bindingNavigatorCountItem->Name = L"bindingNavigatorCountItem";
this->bindingNavigatorCountItem->Size = System::Drawing::Size(35, 22);
this->bindingNavigatorCountItem->Text = L"/ {0}";
this->bindingNavigatorCountItem->ToolTipText = L"总项数";
//
// bindingNavigatorAddNewItem
//
this->bindingNavigatorAddNewItem->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"bindingNavigatorAddNewItem.Image")));
this->bindingNavigatorAddNewItem->Name = L"bindingNavigatorAddNewItem";
this->bindingNavigatorAddNewItem->RightToLeftAutoMirrorImage = true;
this->bindingNavigatorAddNewItem->Size = System::Drawing::Size(49, 22);
this->bindingNavigatorAddNewItem->Text = L"新增";
this->bindingNavigatorAddNewItem->MouseUp += gcnew System::Windows::Forms::MouseEventHandler(this, &ContactForm::bindingNavigatorAddNewItem_MouseUp);
//
// toolStripLabel1
//
this->toolStripLabel1->Name = L"toolStripLabel1";
this->toolStripLabel1->Size = System::Drawing::Size(59, 22);
this->toolStripLabel1->Text = L"单位名称:";
//
// bindingNavigatorMoveFirstItem
//
this->bindingNavigatorMoveFirstItem->DisplayStyle = System::Windows::Forms::ToolStripItemDisplayStyle::Image;
this->bindingNavigatorMoveFirstItem->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"bindingNavigatorMoveFirstItem.Image")));
this->bindingNavigatorMoveFirstItem->Name = L"bindingNavigatorMoveFirstItem";
this->bindingNavigatorMoveFirstItem->RightToLeftAutoMirrorImage = true;
this->bindingNavigatorMoveFirstItem->Size = System::Drawing::Size(23, 22);
this->bindingNavigatorMoveFirstItem->Text = L"移到第一条记录";
//
// 查询ToolStripButton
//
this->查询ToolStripButton->Image = (cli::safe_cast<System::Drawing::Image^ >(resources->GetObject(L"查询ToolStripButton.Image")));
this->查询ToolStripButton->Name = L"查询ToolStripButton";
this->查询ToolStripButton->Size = System::Drawing::Size(49, 22);
this->查询ToolStripButton->Text = L"查询";
this->查询ToolStripButton->Click += gcnew System::EventHandler(this, &ContactForm::查询ToolStripButton_Click);
//
// 单位名称ToolStripTextBox
//
this->单位名称ToolStripTextBox->Name = L"单位名称ToolStripTextBox";
this->单位名称ToolStripTextBox->Size = System::Drawing::Size(80, 25);
this->单位名称ToolStripTextBox->Text = L"%%";
//
// 联系方式管理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^ >(15) {this->dataGridViewTextBoxColumn1,
this->dataGridViewTextBoxColumn2, this->dataGridViewTextBoxColumn3, this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5,
this->dataGridViewTextBoxColumn6, this->dataGridViewTextBoxColumn7, this->dataGridViewTextBoxColumn8, this->dataGridViewTextBoxColumn9,
this->dataGridViewTextBoxColumn10, this->dataGridViewTextBoxColumn11, this->dataGridViewTextBoxColumn12, this->dataGridViewTextBoxColumn13,
this->dataGridViewTextBoxColumn14, this->dataGridViewTextBoxColumn15});
this->联系方式管理DataGridView->DataSource = this->联系方式管理BindingSource;
this->联系方式管理DataGridView->Location = System::Drawing::Point(4, 145);
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(533, 268);
this->联系方式管理DataGridView->TabIndex = 33;
//
// 联系方式管理BindingNavigator
//
this->联系方式管理BindingNavigator->AddNewItem = this->bindingNavigatorAddNewItem;
this->联系方式管理BindingNavigator->BindingSource = this->联系方式管理BindingSource;
this->联系方式管理BindingNavigator->CountItem = this->bindingNavigatorCountItem;
this->联系方式管理BindingNavigator->DeleteItem = this->bindingNavigatorDeleteItem;
this->联系方式管理BindingNavigator->Items->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^ >(15) {this->toolStripLabel1,
this->单位名称ToolStripTextBox, this->查询ToolStripButton, this->bindingNavigatorMoveFirstItem, this->bindingNavigatorMovePreviousItem,
this->bindingNavigatorSeparator, this->bindingNavigatorPositionItem, this->bindingNavigatorCountItem, this->bindingNavigatorSeparator1,
this->bindingNavigatorMoveNextItem, this->bindingNavigatorMoveLastItem, this->bindingNavigatorSeparator2, this->bindingNavigatorAddNewItem,
this->bindingNavigatorDeleteItem, this->联系方式管理BindingNavigatorSaveItem});
this->联系方式管理BindingNavigator->Location = System::Drawing::Point(0, 0);
this->联系方式管理BindingNavigator->MoveFirstItem = this->bindingNavigatorMoveFirstItem;
this->联系方式管理BindingNavigator->MoveLastItem = this->bindingNavigatorMoveLastItem;
this->联系方式管理BindingNavigator->MoveNextItem = this->bindingNavigatorMoveNextItem;
this->联系方式管理BindingNavigator->MovePreviousItem = this->bindingNavigatorMovePreviousItem;
this->联系方式管理BindingNavigator->Name = L"联系方式管理BindingNavigator";
this->联系方式管理BindingNavigator->PositionItem = this->bindingNavigatorPositionItem;
this->联系方式管理BindingNavigator->Size = System::Drawing::Size(542, 25);
this->联系方式管理BindingNavigator->TabIndex = 32;
this->联系方式管理BindingNavigator->Text = L"bindingNavigator1";
//
// ContactForm
//
this->AutoScaleDimensions = System::Drawing::SizeF(6, 12);
this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
this->ClientSize = System::Drawing::Size(542, 416);
this->Controls->Add(自编号Label);
this->Controls->Add(this->自编号TextBox);
this->Controls->Add(类别Label);
this->Controls->Add(this->类别ComboBox);
this->Controls->Add(性别Label);
this->Controls->Add(this->性别ComboBox);
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->qQTextBox);
this->Controls->Add(this->mSNTextBox);
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(qQLabel);
this->Controls->Add(mSNLabel);
this->Controls->Add(邮政编码Label);
this->Controls->Add(联系地址Label);
this->Controls->Add(说明Label);
this->Controls->Add(this->联系方式管理DataGridView);
this->Controls->Add(this->联系方式管理BindingNavigator);
this->Name = L"ContactForm";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"联系方式管理";
this->Load += gcnew System::EventHandler(this, &ContactForm::ContactForm_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->MyOfficeDataSet))->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();
this->ResumeLayout(false);
this->PerformLayout();
}
#pragma endregion
private: static String^ MyOfficeConnectionString= L"Data Source=.;Initial Catalog=MyOffice;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->MyOfficeDataSet->联系方式管理);
}
private: System::Void ContactForm_Load(System::Object^ sender, System::EventArgs^ e) {
// TODO: 这行代码将数据加载到表“MyOfficeDataSet.联系方式管理”中。您可以根据需要移动或移除它。
this->联系方式管理TableAdapter->Fill(this->MyOfficeDataSet->联系方式管理);
}
private: System::Void bindingNavigatorAddNewItem_MouseUp(System::Object^ sender, System::Windows::Forms::MouseEventArgs^ e) {
//自动计算自编号
String^ MySQLConnectionString = MyOfficeConnectionString;
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
String^ MySQL = "Select max(自编号) 自编号 From 联系方式管理";
SqlCommand^ MyCommand = gcnew SqlCommand(MySQL, MyConnection);
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 = "LX0000000" + MyID.ToString();
break;
case 2:
MyNewID = "LX000000" + MyID.ToString();
break;
case 3:
MyNewID = "LX00000" + MyID.ToString();
break;
case 4:
MyNewID = "LX0000" + MyID.ToString();
break;
case 5:
MyNewID = "LX000" + MyID.ToString();
break;
case 6:
MyNewID = "LX00" + MyID.ToString();
break;
case 7:
MyNewID = "LX0" + 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->FillBy(this->MyOfficeDataSet->联系方式管理, 单位名称ToolStripTextBox->Text);
}
catch (System::Exception^ ex)
{
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -