lostreaderform.h

vc++开发环境SQL数据库图书租借管理系统

			// 
			// 读者挂失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^  >(12) {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 = 15;
			this->读者挂失BindingNavigator->Text = L"bindingNavigator1";
			// 
			// 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"新增";
			// 
			// bindingNavigatorCountItem
			// 
			this->bindingNavigatorCountItem->Name = L"bindingNavigatorCountItem";
			this->bindingNavigatorCountItem->Size = System::Drawing::Size(35, 22);
			this->bindingNavigatorCountItem->Text = L"/ {0}";
			this->bindingNavigatorCountItem->ToolTipText = L"总项数";
			// 
			// bindingNavigatorDeleteItem
			// 
			this->bindingNavigatorDeleteItem->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"bindingNavigatorDeleteItem.Image")));
			this->bindingNavigatorDeleteItem->Name = L"bindingNavigatorDeleteItem";
			this->bindingNavigatorDeleteItem->RightToLeftAutoMirrorImage = true;
			this->bindingNavigatorDeleteItem->Size = System::Drawing::Size(49, 22);
			this->bindingNavigatorDeleteItem->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"移到第一条记录";
			// 
			// bindingNavigatorMovePreviousItem
			// 
			this->bindingNavigatorMovePreviousItem->DisplayStyle = System::Windows::Forms::ToolStripItemDisplayStyle::Image;
			this->bindingNavigatorMovePreviousItem->Image = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"bindingNavigatorMovePreviousItem.Image")));
			this->bindingNavigatorMovePreviousItem->Name = L"bindingNavigatorMovePreviousItem";
			this->bindingNavigatorMovePreviousItem->RightToLeftAutoMirrorImage = true;
			this->bindingNavigatorMovePreviousItem->Size = System::Drawing::Size(23, 22);
			this->bindingNavigatorMovePreviousItem->Text = L"移到上一条记录";
			// 
			// bindingNavigatorSeparator
			// 
			this->bindingNavigatorSeparator->Name = L"bindingNavigatorSeparator";
			this->bindingNavigatorSeparator->Size = System::Drawing::Size(6, 25);
			// 
			// bindingNavigatorPositionItem
			// 
			this->bindingNavigatorPositionItem->AccessibleName = L"位置";
			this->bindingNavigatorPositionItem->AutoSize = false;
			this->bindingNavigatorPositionItem->Name = L"bindingNavigatorPositionItem";
			this->bindingNavigatorPositionItem->Size = System::Drawing::Size(50, 21);
			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"移到下一条记录";
			// 
			// 姓名TextBox
			// 
			this->姓名TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->读者挂失BindingSource, L"姓名", true)));
			this->姓名TextBox->Location = System::Drawing::Point(43, 55);
			this->姓名TextBox->Name = L"姓名TextBox";
			this->姓名TextBox->ReadOnly = true;
			this->姓名TextBox->Size = System::Drawing::Size(174, 21);
			this->姓名TextBox->TabIndex = 20;
			// 
			// 编号TextBox
			// 
			this->编号TextBox->DataBindings->Add((gcnew System::Windows::Forms::Binding(L"Text", this->读者挂失BindingSource, L"编号", true)));
			this->编号TextBox->Location = System::Drawing::Point(43, 28);
			this->编号TextBox->Name = L"编号TextBox";
			this->编号TextBox->ReadOnly = true;
			this->编号TextBox->Size = System::Drawing::Size(174, 21);
			this->编号TextBox->TabIndex = 18;
			// 
			// 读者挂失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::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->读者挂失DataGridView->AutoGenerateColumns = false;
			this->读者挂失DataGridView->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^  >(6) {this->dataGridViewTextBoxColumn1, 
				this->dataGridViewTextBoxColumn2, this->dataGridViewTextBoxColumn3, this->dataGridViewTextBoxColumn4, this->dataGridViewTextBoxColumn5, 
				this->dataGridViewTextBoxColumn6});
			this->读者挂失DataGridView->DataSource = this->读者挂失BindingSource;
			this->读者挂失DataGridView->Location = System::Drawing::Point(223, 28);
			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(315, 156);
			this->读者挂失DataGridView->TabIndex = 16;
			// 
			// LostReaderForm
			// 
			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->groupBox1);
			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(挂失日期Label);
			this->Controls->Add(this->挂失日期DateTimePicker);
			this->Controls->Add(说明Label);
			this->Controls->Add(this->说明TextBox);
			this->Controls->Add(this->读者挂失BindingNavigator);
			this->Controls->Add(this->姓名TextBox);
			this->Controls->Add(this->编号TextBox);
			this->Controls->Add(this->读者挂失DataGridView);
			this->Name = L"LostReaderForm";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
			this->Text = L"读者挂失管理";
			this->Load += gcnew System::EventHandler(this, &LostReaderForm::LostReaderForm_Load);
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->MyBooksDataSet))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->读者挂失BindingSource))->EndInit();
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->读者信息DataGridView))->EndInit();
			this->groupBox1->ResumeLayout(false);
			this->groupBox1->PerformLayout();
			(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^ MyBooksConnectionString= L"Data Source=.;Initial Catalog=MyBooks;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->MyBooksDataSet->读者挂失);
			 查询Button_Click(nullptr, nullptr);
		 }
		private: System::Void LostReaderForm_Load(System::Object^  sender, System::EventArgs^  e) {
			 // TODO: 这行代码将数据加载到表“MyBooksDataSet.读者挂失”中。您可以根据需要移动或移除它。
			 this->读者挂失TableAdapter->Fill(this->MyBooksDataSet->读者挂失);
		 }
		private: System::Void 查询Button_Click(System::Object^  sender, System::EventArgs^  e) {
			String^ MySQLConnectionString = MyBooksConnectionString;
            String^ MySQL = "Select * From 有效读者视图 WHERE 姓名 LIKE '%"+this->挂失读者姓名TextBox->Text+"%' AND 证件号码 LIKE '%"+this->挂失读者证件号码TextBox->Text +"%'";
            SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
            MyConnection->Open();
			System::Data::DataTable^ MyReaderTable = gcnew System::Data::DataTable();
            SqlDataAdapter^ MyAdapter = gcnew SqlDataAdapter(MySQL, MyConnection);
            MyAdapter->Fill(MyReaderTable);
            this->读者信息DataGridView->DataSource = MyReaderTable;
			if (MyConnection->State == ConnectionState::Open)
            {
                MyConnection->Close();
            }
		 }
		private: System::Void 读者信息DataGridView_Click(System::Object^  sender, System::EventArgs^  e) {
			this->编号TextBox->Text = this->读者信息DataGridView->CurrentRow->Cells[0]->Value->ToString();
            this->姓名TextBox->Text = this->读者信息DataGridView->CurrentRow->Cells[1]->Value->ToString();
            this->证件名称TextBox->Text = this->读者信息DataGridView->CurrentRow->Cells[4]->Value->ToString();
            this->证件号码TextBox->Text = this->读者信息DataGridView->CurrentRow->Cells[5]->Value->ToString();   
		 }
	};
}