📄 studentinfo.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>
/// StudentInfo 摘要
///
/// 警告: 如果您更改该类的名称，则将需要更改
/// 与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的
/// “资源文件名”属性。 否则，
/// 设计器将不能与此窗体关联的
/// 本地化资源正确交互。
/// </summary>
public __gc class StudentInfo : public System::Windows::Forms::Form
{
//--------------------成员声明------------------------
private:
LinkDataBase* MyDataBase; //数据库连接类
SqlDataAdapter* StudentAdapter;
DataSet* ds;
String* strTableName;
String* strSQL;
CurrencyManager* cmStudent;
//-------------------成员声明结束-----------------------
public:
StudentInfo(void)
{
InitializeComponent();
//初始化
this->MyDataBase = new LinkDataBase();
this->ds = new DataSet();
this->StudentAdapter = new SqlDataAdapter();
//查询政治面貌代码表
this->strSQL = S"Select * from 政治面貌代码表";
this->strTableName = S"政治面貌代码表";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmbPolicy->DataSource = this->ds->Tables->Item[S"政治面貌代码表"];
this->cmbPolicy->ValueMember = S"政治面貌编号";
this->cmbPolicy->DisplayMember = S"政治面貌";
//查询籍贯代码表
this->strSQL = S"Select * from 籍贯代码表";
this->strTableName = S"籍贯代码表";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmbHomeTown->DataSource = this->ds->Tables->Item[S"籍贯代码表"];
this->cmbHomeTown->ValueMember = S"籍贯编号";
this->cmbHomeTown->DisplayMember = S"籍贯";
//查询民族代码表
this->strSQL = S"Select * from 民族代码表";
this->strTableName = S"民族代码表";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmbRate->DataSource = this->ds->Tables->Item[S"民族代码表"];
this->cmbRate->ValueMember = S"民族编号";
this->cmbRate->DisplayMember = S"民族";
//查询学籍代码表
this->strSQL = S"Select * from 学籍代码表";
this->strTableName = S"学籍代码表";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmbSchool->DataSource = this->ds->Tables->Item[S"学籍代码表"];
this->cmbSchool->ValueMember = S"学籍编号";
this->cmbSchool->DisplayMember = S"学籍名称";
//查询班级信息
this->strSQL = S"Select * from 班级信息";
this->strTableName = S"班级信息";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmbClass->DataSource = this->ds->Tables->Item[S"班级信息"];
this->cmbClass->ValueMember = S"班级编号";
this->cmbClass->DisplayMember = S"班级名称";
//查询学生信息
this->strSQL = S"Select * from 学生信息";
this->strTableName = S"学生信息";
this->MyDataBase->SelectDataBase(this->StudentAdapter,this->ds,this->strSQL,this->strTableName);
this->cmStudent = __try_cast<CurrencyManager*>(BindingContext->get_Item(ds,S"学生信息"));
//设置DataGrid
this->dgrdStudent->DataSource = this->ds->Tables->Item[S"学生信息"];
this->DataGridStateControl();
//设置控件的数据邦定
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 * label9;
private: System::Windows::Forms::Label * label10;
protected: System::Windows::Forms::ImageList * imageList1;
private: System::Windows::Forms::TextBox * tBoxName;
private: System::Windows::Forms::TextBox * tBoxStudentID;
private: System::Windows::Forms::TextBox * tBoxGrade;
private: System::Windows::Forms::Label * label3;
private: System::Windows::Forms::Label * label6;
private: System::Windows::Forms::Label * label7;
private: System::Windows::Forms::Label * label8;
private: System::Windows::Forms::Label * label13;
private: System::Windows::Forms::Label * label12;
private: System::Windows::Forms::Label * label11;
private: System::Windows::Forms::TextBox * tBoxNameShow;
private: System::Windows::Forms::TextBox * tBoxGradeShow;
private: System::Windows::Forms::TextBox * tBoxStudentIDShow;
private: System::Windows::Forms::ComboBox * cmbSex;
private: System::Windows::Forms::ComboBox * cmbClass;
private: System::Windows::Forms::ComboBox * cmbSchool;
private: System::Windows::Forms::ComboBox * cmbRate;
private: System::Windows::Forms::TextBox * tBoxPersonalID;
private: System::Windows::Forms::ComboBox * cmbHomeTown;
private: System::Windows::Forms::ComboBox * cmbPolicy;
private: System::Windows::Forms::DataGrid * dgrdStudent;
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::StudentInfo));
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->tBoxName = new System::Windows::Forms::TextBox();
this->label2 = new System::Windows::Forms::Label();
this->tBoxStudentID = new System::Windows::Forms::TextBox();
this->label1 = new System::Windows::Forms::Label();
this->btnSearch = new System::Windows::Forms::Button();
this->tBoxGrade = new System::Windows::Forms::TextBox();
this->label4 = new System::Windows::Forms::Label();
this->dgrdStudent = new System::Windows::Forms::DataGrid();
this->groupBox2 = new System::Windows::Forms::GroupBox();
this->label11 = new System::Windows::Forms::Label();
this->cmbPolicy = new System::Windows::Forms::ComboBox();
this->label12 = new System::Windows::Forms::Label();
this->cmbHomeTown = new System::Windows::Forms::ComboBox();
this->label7 = new System::Windows::Forms::Label();
this->cmbSchool = new System::Windows::Forms::ComboBox();
this->label8 = new System::Windows::Forms::Label();
this->cmbRate = new System::Windows::Forms::ComboBox();
this->tBoxPersonalID = new System::Windows::Forms::TextBox();
this->label13 = new System::Windows::Forms::Label();
this->label6 = new System::Windows::Forms::Label();
this->cmbClass = new System::Windows::Forms::ComboBox();
this->label3 = new System::Windows::Forms::Label();
this->cmbSex = new System::Windows::Forms::ComboBox();
this->tBoxNameShow = new System::Windows::Forms::TextBox();
this->label9 = new System::Windows::Forms::Label();
this->tBoxGradeShow = new System::Windows::Forms::TextBox();
this->label10 = new System::Windows::Forms::Label();
this->tBoxStudentIDShow = new System::Windows::Forms::TextBox();
this->label5 = new System::Windows::Forms::Label();
this->groupBox1->SuspendLayout();
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dgrdStudent))->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
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -