📄 readerinfo.h
字号:
#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>
/// ReaderInfo 摘要
///
/// 警告: 如果您更改该类的名称，则将需要更改
/// 与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的
/// “资源文件名”属性。 否则，
/// 设计器将不能与此窗体关联的
/// 本地化资源正确交互。
/// </summary>
public __gc class ReaderInfo : public System::Windows::Forms::Form
{
//--------------------成员声明------------------------
private:
LinkDataBase* MyDataBase; //数据库连接类
SqlDataAdapter* ReaderAdapter;
DataSet* ds;
String* strTableName;
String* strSQL;
CurrencyManager* cmReader;
//-------------------成员声明结束-----------------------
public:
ReaderInfo(void)
{
InitializeComponent();
//初始化
this->MyDataBase = new LinkDataBase();
this->ds = new DataSet();
this->ReaderAdapter = new SqlDataAdapter();
//查询读者信息
this->strSQL = S"Select * from 读者信息";
this->strTableName = S"读者信息";
this->MyDataBase->SelectDataBase(this->ReaderAdapter,this->ds,this->strSQL,this->strTableName);
this->cmReader = __try_cast<CurrencyManager*>(this->BindingContext->get_Item(this->ds,S"读者信息"));
//设置DataGrid
this->dgrdReaders->DataSource = this->ds->Tables->Item[S"读者信息"];
this->DataGridStateControl();
//填充[类型]的选项
String* tempSQL = S"Select distinct 类型 from 读者类型";
SqlDataReader* tempReader = this->MyDataBase->SQLRead(tempSQL);
while(tempReader->Read())
{
this->cmbReaderClass->Items->Add(tempReader->GetValue(0)->ToString()->Trim());
}
tempReader->Close();
//设置控件的数据邦定
this->SetDataBindings();
//设置控件ReadOnly属性
this->SetModify(false);
}
protected:
void Dispose(Boolean disposing)
{
if (disposing && components)
{
components->Dispose();
}
__super::Dispose(disposing);
}
private: System::Windows::Forms::ToolBar * toolBar1;
private: System::Windows::Forms::ToolBarButton * tBtnFirstRecord;
private: System::Windows::Forms::ToolBarButton * tBtnNextRecord;
private: System::Windows::Forms::ToolBarButton * tBtnPreviousRecord;
private: System::Windows::Forms::ToolBarButton * tBtnLastRecord;
private: System::Windows::Forms::ToolBarButton * tBtnNewRecord;
private: System::Windows::Forms::ToolBarButton * tBtnModifyRecord;
private: System::Windows::Forms::ToolBarButton * tBtnDeleteRecord;
private: System::Windows::Forms::ToolBarButton * tBtnPostModified;
private: System::Windows::Forms::ToolBarButton * tBtnCancleModified;
private: System::Windows::Forms::ToolBarButton * tBtnQuit;
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::GroupBox * groupBox2;
private: System::Windows::Forms::Label * label5;
private: System::Windows::Forms::Label * label6;
private: System::Windows::Forms::Label * label7;
private: System::Windows::Forms::Label * label3;
private: System::Windows::Forms::Label * label8;
private: System::Windows::Forms::Label * label9;
private: System::Windows::Forms::Label * label10;
private: System::Windows::Forms::Label * label11;
private: System::Windows::Forms::Label * label29;
private: System::Windows::Forms::Label * label30;
private: System::Windows::Forms::Label * label12;
private: System::Windows::Forms::Label * label13;
private: System::Windows::Forms::Label * label14;
private: System::Windows::Forms::Label * label15;
private: System::Windows::Forms::TextBox * tBoxContactation;
private: System::Windows::Forms::ComboBox * cmbSex;
private: System::Windows::Forms::ComboBox * cmbReaderClass;
private: System::Windows::Forms::ComboBox * cmbValidCertificate;
private: System::Windows::Forms::TextBox * tBoxCertificateNumber;
private: System::Windows::Forms::TextBox * tBoxMemo;
private: System::Windows::Forms::TextBox * tBoxOperator;
private: System::Windows::Forms::TextBox * tBoxBookBorrowTimes;
private: System::Windows::Forms::TextBox * tBoxMagazineBorrowTimes;
private: System::Windows::Forms::DateTimePicker * dtpValidate;
private: System::Windows::Forms::DateTimePicker * dtpRegisterDate;
private: System::Windows::Forms::DateTimePicker * dtpBirthday;
private: System::Windows::Forms::CheckBox * chkIsReportToLost;
private: System::Windows::Forms::ImageList * imageList1;
private: System::Windows::Forms::TextBox * tBoxReaderID;
private: System::Windows::Forms::TextBox * tBoxBarCode;
private: System::Windows::Forms::TextBox * tBoxReaderName;
private: System::Windows::Forms::TextBox * tBoxReaderIDShow;
private: System::Windows::Forms::TextBox * tBoxBarCodeShow;
private: System::Windows::Forms::TextBox * tBoxReaderNameShow;
private: System::Windows::Forms::DataGrid * dgrdReaders;
private: System::Windows::Forms::Label * label26;
private: System::ComponentModel::IContainer * components;
private:
/// <summary>
/// 必需的设计器变量。
/// </summary>
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
void InitializeComponent(void)
{
this->components = new System::ComponentModel::Container();
System::Resources::ResourceManager * resources = new System::Resources::ResourceManager(__typeof(My::ReaderInfo));
this->toolBar1 = new System::Windows::Forms::ToolBar();
this->tBtnFirstRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnNextRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnPreviousRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnLastRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnNewRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnModifyRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnDeleteRecord = new System::Windows::Forms::ToolBarButton();
this->tBtnPostModified = new System::Windows::Forms::ToolBarButton();
this->tBtnCancleModified = new System::Windows::Forms::ToolBarButton();
this->tBtnQuit = new System::Windows::Forms::ToolBarButton();
this->imageList1 = new System::Windows::Forms::ImageList(this->components);
this->groupBox1 = new System::Windows::Forms::GroupBox();
this->tBoxReaderID = new System::Windows::Forms::TextBox();
this->label2 = new System::Windows::Forms::Label();
this->tBoxBarCode = new System::Windows::Forms::TextBox();
this->label1 = new System::Windows::Forms::Label();
this->btnSearch = new System::Windows::Forms::Button();
this->tBoxReaderName = new System::Windows::Forms::TextBox();
this->label4 = new System::Windows::Forms::Label();
this->dgrdReaders = new System::Windows::Forms::DataGrid();
this->groupBox2 = new System::Windows::Forms::GroupBox();
this->dtpValidate = new System::Windows::Forms::DateTimePicker();
this->dtpRegisterDate = new System::Windows::Forms::DateTimePicker();
this->dtpBirthday = new System::Windows::Forms::DateTimePicker();
this->chkIsReportToLost = new System::Windows::Forms::CheckBox();
this->label15 = new System::Windows::Forms::Label();
this->label14 = new System::Windows::Forms::Label();
this->label12 = new System::Windows::Forms::Label();
this->label13 = new System::Windows::Forms::Label();
this->tBoxMemo = new System::Windows::Forms::TextBox();
this->label26 = new System::Windows::Forms::Label();
this->tBoxOperator = new System::Windows::Forms::TextBox();
this->label8 = new System::Windows::Forms::Label();
this->cmbValidCertificate = new System::Windows::Forms::ComboBox();
this->tBoxBookBorrowTimes = new System::Windows::Forms::TextBox();
this->tBoxContactation = new System::Windows::Forms::TextBox();
this->label9 = new System::Windows::Forms::Label();
this->tBoxCertificateNumber = new System::Windows::Forms::TextBox();
this->label10 = new System::Windows::Forms::Label();
this->label11 = new System::Windows::Forms::Label();
this->label3 = new System::Windows::Forms::Label();
this->cmbSex = new System::Windows::Forms::ComboBox();
this->tBoxReaderIDShow = new System::Windows::Forms::TextBox();
this->tBoxBarCodeShow = new System::Windows::Forms::TextBox();
this->label5 = new System::Windows::Forms::Label();
this->tBoxReaderNameShow = new System::Windows::Forms::TextBox();
this->label6 = new System::Windows::Forms::Label();
this->label7 = new System::Windows::Forms::Label();
this->label29 = new System::Windows::Forms::Label();
this->cmbReaderClass = new System::Windows::Forms::ComboBox();
this->label30 = new System::Windows::Forms::Label();
this->tBoxMagazineBorrowTimes = new System::Windows::Forms::TextBox();
this->groupBox1->SuspendLayout();
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dgrdReaders))->BeginInit();
this->groupBox2->SuspendLayout();
this->SuspendLayout();
//
// toolBar1
//
System::Windows::Forms::ToolBarButton* __mcTemp__1[] = new System::Windows::Forms::ToolBarButton*[10];
__mcTemp__1[0] = this->tBtnFirstRecord;
__mcTemp__1[1] = this->tBtnNextRecord;
__mcTemp__1[2] = this->tBtnPreviousRecord;
__mcTemp__1[3] = this->tBtnLastRecord;
__mcTemp__1[4] = this->tBtnNewRecord;
__mcTemp__1[5] = this->tBtnModifyRecord;
__mcTemp__1[6] = this->tBtnDeleteRecord;
__mcTemp__1[7] = this->tBtnPostModified;
__mcTemp__1[8] = this->tBtnCancleModified;
__mcTemp__1[9] = this->tBtnQuit;
this->toolBar1->Buttons->AddRange(__mcTemp__1);
this->toolBar1->DropDownArrows = true;
this->toolBar1->ImageList = this->imageList1;
this->toolBar1->Location = System::Drawing::Point(0, 0);
this->toolBar1->Name = S"toolBar1";
this->toolBar1->ShowToolTips = true;
this->toolBar1->Size = System::Drawing::Size(760, 41);
this->toolBar1->TabIndex = 0;
this->toolBar1->ButtonClick += new System::Windows::Forms::ToolBarButtonClickEventHandler(this, toolBar1_ButtonClick);
//
// tBtnFirstRecord
//
this->tBtnFirstRecord->ImageIndex = 5;
this->tBtnFirstRecord->Text = S"首记录";
this->tBtnFirstRecord->ToolTipText = S"首记录";
//
// tBtnNextRecord
//
this->tBtnNextRecord->ImageIndex = 8;
this->tBtnNextRecord->Text = S"上一记录";
this->tBtnNextRecord->ToolTipText = S"上一记录";
//
// tBtnPreviousRecord
//
this->tBtnPreviousRecord->ImageIndex = 4;
this->tBtnPreviousRecord->Text = S"下一记录";
this->tBtnPreviousRecord->ToolTipText = S"下一记录";
//
// tBtnLastRecord
//
this->tBtnLastRecord->ImageIndex = 7;
this->tBtnLastRecord->Text = S"尾记录";
this->tBtnLastRecord->ToolTipText = S"尾记录";
//
// tBtnNewRecord
//
this->tBtnNewRecord->ImageIndex = 9;
this->tBtnNewRecord->Text = S"新增";
this->tBtnNewRecord->ToolTipText = S"新增";
//
// tBtnModifyRecord
//
this->tBtnModifyRecord->ImageIndex = 10;
this->tBtnModifyRecord->Text = S"修改";
this->tBtnModifyRecord->ToolTipText = S"修改";
//
// tBtnDeleteRecord
//
this->tBtnDeleteRecord->ImageIndex = 3;
this->tBtnDeleteRecord->Text = S"删除";
this->tBtnDeleteRecord->ToolTipText = S"删除";
//
// tBtnPostModified
//
this->tBtnPostModified->ImageIndex = 0;
this->tBtnPostModified->Text = S"提交";
this->tBtnPostModified->ToolTipText = S"提交";
//
// tBtnCancleModified
//
this->tBtnCancleModified->ImageIndex = 2;
this->tBtnCancleModified->Text = S"取消";
this->tBtnCancleModified->ToolTipText = S"取消";
//
// tBtnQuit
//
this->tBtnQuit->Text = S"退出";
this->tBtnQuit->ToolTipText = S"退出";
//
// imageList1
//
this->imageList1->ImageSize = System::Drawing::Size(16, 16);
this->imageList1->ImageStream = (__try_cast<System::Windows::Forms::ImageListStreamer * >(resources->GetObject(S"imageList1.ImageStream")));
this->imageList1->TransparentColor = System::Drawing::Color::Transparent;
//
// groupBox1
//
this->groupBox1->Controls->Add(this->tBoxReaderID);
this->groupBox1->Controls->Add(this->label2);
this->groupBox1->Controls->Add(this->tBoxBarCode);
this->groupBox1->Controls->Add(this->label1);
this->groupBox1->Controls->Add(this->btnSearch);
this->groupBox1->Controls->Add(this->tBoxReaderName);
this->groupBox1->Controls->Add(this->label4);
this->groupBox1->Dock = System::Windows::Forms::DockStyle::Top;
this->groupBox1->Location = System::Drawing::Point(0, 41);
this->groupBox1->Name = S"groupBox1";
this->groupBox1->Size = System::Drawing::Size(760, 79);
this->groupBox1->TabIndex = 1;
this->groupBox1->TabStop = false;
//
// tBoxReaderID
//
this->tBoxReaderID->Location = System::Drawing::Point(408, 39);
this->tBoxReaderID->Name = S"tBoxReaderID";
this->tBoxReaderID->Size = System::Drawing::Size(120, 21);
this->tBoxReaderID->TabIndex = 4;
this->tBoxReaderID->Text = S"";
//
// label2
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -