bookreturn.h

Visual C++.net数据库开发经典案例

#pragma once
#include "LinkDataBase.h"
#include "DataGridNoActiveCellColumn.h"

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;


namespace My
{
	/// <summary> 
	/// BookReturn 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class BookReturn : public System::Windows::Forms::Form
	{
		//--------------------成员声明------------------------
	private:
		LinkDataBase* MyDataBase;	//数据库连接类
		DataSet* ds;
		String* strTableName;
	private: System::Windows::Forms::GroupBox *  groupBox2;
	private: System::Windows::Forms::Button *  btnReturn;
			 String* strSQL;
		//-------------------成员声明结束-----------------------
	public: 
		BookReturn(void)
		{
			InitializeComponent();
			//初始化
			this->MyDataBase = new LinkDataBase();
			this->ds = new DataSet();		

			//查询图书借阅
			
			 this->BookReturnAdapter->SelectCommand->Parameters->Item[S"@图书编号"]->Value = S"%%";
			 this->BookReturnAdapter->SelectCommand->Parameters->Item[S"@读者编号"]->Value = S"%%";
			 this->BookReturnAdapter->SelectCommand->Parameters->Item[S"@读者姓名"]->Value = S"%%";
			
			 this->BookReturnAdapter->Fill(this->ds,S"图书借阅");			
			//设置DataGrid
			this->dgrdBooks->DataSource = this->ds->Tables->Item[S"图书借阅"];
			this->DataGridStateControl();			
		}
        
	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: System::Windows::Forms::GroupBox *  groupBox1;
	private: System::Windows::Forms::Button *  btnSearch;
	private: System::Windows::Forms::Label *  label1;
	private: System::Windows::Forms::Label *  label2;
	private: System::Windows::Forms::Label *  label4;
	private: System::Windows::Forms::TextBox *  tBoxBookID;
	private: System::Windows::Forms::TextBox *  tBoxReaderID;
	private: System::Windows::Forms::DataGrid *  dgrdBooks;
    private: System::Windows::Forms::TextBox *  tBoxReaderName;
	private: System::Data::SqlClient::SqlDataAdapter *  BookReturnAdapter;
	private: System::Data::SqlClient::SqlCommand *  sqlSelectCommand1;
	private: System::Data::SqlClient::SqlConnection *  sqlConnection1;

	private: System::ComponentModel::IContainer *  components;
			 	private: System::Windows::Forms::ImageList *  imageList1;
	private:
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>


		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->components = new System::ComponentModel::Container();
			System::Resources::ResourceManager *  resources = new System::Resources::ResourceManager(__typeof(My::BookReturn));
			this->groupBox1 = new System::Windows::Forms::GroupBox();
			this->tBoxBookID = new System::Windows::Forms::TextBox();
			this->label2 = new System::Windows::Forms::Label();
			this->tBoxReaderName = new System::Windows::Forms::TextBox();
			this->label1 = new System::Windows::Forms::Label();
			this->btnSearch = new System::Windows::Forms::Button();
			this->imageList1 = new System::Windows::Forms::ImageList(this->components);
			this->tBoxReaderID = new System::Windows::Forms::TextBox();
			this->label4 = new System::Windows::Forms::Label();
			this->dgrdBooks = new System::Windows::Forms::DataGrid();
			this->BookReturnAdapter = new System::Data::SqlClient::SqlDataAdapter();
			this->sqlSelectCommand1 = new System::Data::SqlClient::SqlCommand();
			this->sqlConnection1 = new System::Data::SqlClient::SqlConnection();
			this->groupBox2 = new System::Windows::Forms::GroupBox();
			this->btnReturn = new System::Windows::Forms::Button();
			this->groupBox1->SuspendLayout();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdBooks))->BeginInit();
			this->groupBox2->SuspendLayout();
			this->SuspendLayout();
			// 
			// groupBox1
			// 
			this->groupBox1->Controls->Add(this->tBoxBookID);
			this->groupBox1->Controls->Add(this->label2);
			this->groupBox1->Controls->Add(this->tBoxReaderName);
			this->groupBox1->Controls->Add(this->label1);
			this->groupBox1->Controls->Add(this->btnSearch);
			this->groupBox1->Controls->Add(this->tBoxReaderID);
			this->groupBox1->Controls->Add(this->label4);
			this->groupBox1->Dock = System::Windows::Forms::DockStyle::Top;
			this->groupBox1->Location = System::Drawing::Point(0, 0);
			this->groupBox1->Name = S"groupBox1";
			this->groupBox1->Size = System::Drawing::Size(760, 79);
			this->groupBox1->TabIndex = 1;
			this->groupBox1->TabStop = false;
			// 
			// tBoxBookID
			// 
			this->tBoxBookID->Location = System::Drawing::Point(408, 40);
			this->tBoxBookID->Name = S"tBoxBookID";
			this->tBoxBookID->Size = System::Drawing::Size(120, 21);
			this->tBoxBookID->TabIndex = 4;
			this->tBoxBookID->Text = S"";
			// 
			// label2
			// 
			this->label2->Location = System::Drawing::Point(536, 48);
			this->label2->Name = S"label2";
			this->label2->Size = System::Drawing::Size(56, 11);
			this->label2->TabIndex = 3;
			this->label2->Text = S"读者姓名";
			// 
			// tBoxReaderName
			// 
			this->tBoxReaderName->Location = System::Drawing::Point(592, 40);
			this->tBoxReaderName->Name = S"tBoxReaderName";
			this->tBoxReaderName->Size = System::Drawing::Size(120, 21);
			this->tBoxReaderName->TabIndex = 2;
			this->tBoxReaderName->Text = S"";
			// 
			// label1
			// 
			this->label1->Location = System::Drawing::Point(144, 45);
			this->label1->Name = S"label1";
			this->label1->Size = System::Drawing::Size(56, 11);
			this->label1->TabIndex = 1;
			this->label1->Text = S"读者编号";
			// 
			// btnSearch
			// 
			this->btnSearch->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
			this->btnSearch->ImageIndex = 6;
			this->btnSearch->ImageList = this->imageList1;
			this->btnSearch->Location = System::Drawing::Point(64, 40);
			this->btnSearch->Name = S"btnSearch";
			this->btnSearch->Size = System::Drawing::Size(56, 24);
			this->btnSearch->TabIndex = 0;
			this->btnSearch->Text = S"搜索";
			this->btnSearch->TextAlign = System::Drawing::ContentAlignment::MiddleRight;