subjectsetting.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> 
	/// SubjectSetting 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class SubjectSetting : public System::Windows::Forms::Form
	{
	//--------------------成员声明------------------------
	private:
		LinkDataBase* MyDataBase;	//数据库连接类
		DataSet* ds;		
		String* strTableName;
		String* strSQL;
		CurrencyManager* cmSubject;
	private: System::Windows::Forms::ImageList *  imageList1;
			 SqlDataAdapter* SubjectAdapter;
	//-------------------成员声明结束-----------------------
	public: 
		SubjectSetting(void)
		{
			InitializeComponent();
			this->MyDataBase = new LinkDataBase();
			this->SubjectAdapter = new SqlDataAdapter();
			this->ds = new DataSet();
			this->strSQL = S"SELECT * FROM  科目表";
			this->strTableName = S"科目表";
			this->MyDataBase->SelectDataBase(this->SubjectAdapter,this->ds,this->strSQL,this->strTableName);			
		}
        
	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 *  tBtnPreviousRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnNextRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnLastRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnAddRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnDeleteRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnModifyRecord;
	private: System::Windows::Forms::ToolBarButton *  tBtnCancelModify;
	private: System::Windows::Forms::ToolBarButton *  tBtnQuit;
	private: System::Windows::Forms::Label *  label6;
	private: System::Windows::Forms::Label *  label5;
	private: System::Windows::Forms::Label *  label3;
	private: System::Windows::Forms::Label *  label2;
	private: System::Windows::Forms::Label *  label1;
    private: System::Windows::Forms::ComboBox *  cmbBalance;
	private: System::Windows::Forms::ComboBox *  cmbSubjectType;
	private: System::Windows::Forms::ToolBarButton *  tBtnModify;
	private: System::Windows::Forms::GroupBox *  groupBox1;
	private: System::Windows::Forms::GroupBox *  groupBox2;
	private: System::Windows::Forms::Button *  btnSearch;
	private: System::Windows::Forms::Label *  label9;
	private: System::Windows::Forms::Label *  label10;
	private: System::Windows::Forms::TextBox *  tBoxSubjectName;
	private: System::Windows::Forms::TextBox *  tBoxSubjectCode;


	private: System::Windows::Forms::TextBox *  tBoxSubjectHelpCode;
	private: System::Windows::Forms::TextBox *  tBoxSubjectNameShow;
	private: System::Windows::Forms::TextBox *  tBoxSubjectCodeShow;

	private: System::Windows::Forms::DataGrid *  dgrdSubject;
	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::SubjectSetting));
			this->toolBar1 = new System::Windows::Forms::ToolBar();
			this->tBtnFirstRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnPreviousRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnNextRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnLastRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnAddRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnModify = new System::Windows::Forms::ToolBarButton();
			this->tBtnDeleteRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnModifyRecord = new System::Windows::Forms::ToolBarButton();
			this->tBtnCancelModify = new System::Windows::Forms::ToolBarButton();
			this->tBtnQuit = new System::Windows::Forms::ToolBarButton();
			this->dgrdSubject = new System::Windows::Forms::DataGrid();
			this->label6 = new System::Windows::Forms::Label();
			this->label5 = new System::Windows::Forms::Label();
			this->label3 = new System::Windows::Forms::Label();
			this->label2 = new System::Windows::Forms::Label();
			this->label1 = new System::Windows::Forms::Label();
			this->cmbBalance = new System::Windows::Forms::ComboBox();
			this->cmbSubjectType = new System::Windows::Forms::ComboBox();
			this->tBoxSubjectHelpCode = new System::Windows::Forms::TextBox();
			this->tBoxSubjectNameShow = new System::Windows::Forms::TextBox();
			this->tBoxSubjectCodeShow = new System::Windows::Forms::TextBox();
			this->groupBox1 = new System::Windows::Forms::GroupBox();
			this->groupBox2 = new System::Windows::Forms::GroupBox();
			this->btnSearch = new System::Windows::Forms::Button();
			this->label9 = new System::Windows::Forms::Label();
			this->label10 = new System::Windows::Forms::Label();
			this->tBoxSubjectName = new System::Windows::Forms::TextBox();
			this->tBoxSubjectCode = new System::Windows::Forms::TextBox();
			this->imageList1 = new System::Windows::Forms::ImageList(this->components);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdSubject))->BeginInit();
			this->groupBox1->SuspendLayout();
			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->tBtnPreviousRecord;
			__mcTemp__1[2] = this->tBtnNextRecord;
			__mcTemp__1[3] = this->tBtnLastRecord;
			__mcTemp__1[4] = this->tBtnAddRecord;
			__mcTemp__1[5] = this->tBtnModify;
			__mcTemp__1[6] = this->tBtnDeleteRecord;
			__mcTemp__1[7] = this->tBtnModifyRecord;
			__mcTemp__1[8] = this->tBtnCancelModify;
			__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(768, 41);
			this->toolBar1->TabIndex = 1;
			this->toolBar1->ButtonClick += new System::Windows::Forms::ToolBarButtonClickEventHandler(this, toolBar1_ButtonClick);
			// 
			// tBtnFirstRecord
			// 
			this->tBtnFirstRecord->ImageIndex = 5;
			this->tBtnFirstRecord->Text = S"首记录";
			this->tBtnFirstRecord->ToolTipText = S"首记录";
			// 
			// tBtnPreviousRecord
			// 
			this->tBtnPreviousRecord->ImageIndex = 4;
			this->tBtnPreviousRecord->Text = S"上一记录";
			this->tBtnPreviousRecord->ToolTipText = S"上一记录";
			// 
			// tBtnNextRecord
			// 
			this->tBtnNextRecord->ImageIndex = 8;
			this->tBtnNextRecord->Text = S"下一记录";
			this->tBtnNextRecord->ToolTipText = S"下一记录";
			// 
			// tBtnLastRecord
			// 
			this->tBtnLastRecord->ImageIndex = 7;
			this->tBtnLastRecord->Text = S"尾记录";
			this->tBtnLastRecord->ToolTipText = S"尾记录";
			// 
			// tBtnAddRecord
			// 
			this->tBtnAddRecord->ImageIndex = 9;
			this->tBtnAddRecord->Text = S"新增记录";
			this->tBtnAddRecord->ToolTipText = S"新增记录";
			// 
			// tBtnModify
			// 
			this->tBtnModify->ImageIndex = 10;
			this->tBtnModify->Text = S"修改记录";
			this->tBtnModify->ToolTipText = S"修改记录";
			// 
			// tBtnDeleteRecord
			// 
			this->tBtnDeleteRecord->ImageIndex = 3;
			this->tBtnDeleteRecord->Text = S"删除记录";
			this->tBtnDeleteRecord->ToolTipText = S"删除记录";
			// 
			// tBtnModifyRecord
			// 
			this->tBtnModifyRecord->ImageIndex = 0;
			this->tBtnModifyRecord->Text = S"保存修改";
			this->tBtnModifyRecord->ToolTipText = S"保存修改";
			// 
			// tBtnCancelModify
			// 
			this->tBtnCancelModify->ImageIndex = 2;
			this->tBtnCancelModify->Text = S"取消修改";
			this->tBtnCancelModify->ToolTipText = S"取消修改";
			// 
			// tBtnQuit
			// 
			this->tBtnQuit->ImageIndex = 15;
			this->tBtnQuit->Text = S"退出";
			this->tBtnQuit->ToolTipText = S"退出";
			// 
			// dgrdSubject
			// 
			this->dgrdSubject->AllowNavigation = false;
			this->dgrdSubject->DataMember = S"";
			this->dgrdSubject->Dock = System::Windows::Forms::DockStyle::Fill;
			this->dgrdSubject->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dgrdSubject->Location = System::Drawing::Point(0, 137);
			this->dgrdSubject->Name = S"dgrdSubject";
			this->dgrdSubject->ReadOnly = true;
			this->dgrdSubject->Size = System::Drawing::Size(456, 276);
			this->dgrdSubject->TabIndex = 3;
			// 
			// label6
			// 
			this->label6->Location = System::Drawing::Point(40, 208);
			this->label6->Name = S"label6";
			this->label6->Size = System::Drawing::Size(56, 16);
			this->label6->TabIndex = 26;
			this->label6->Text = S"余额方向";
			// 
			// label5
			// 
			this->label5->Location = System::Drawing::Point(40, 168);
			this->label5->Name = S"label5";
			this->label5->Size = System::Drawing::Size(56, 16);
			this->label5->TabIndex = 25;
			this->label5->Text = S"科目类别";
			// 
			// label3
			// 
			this->label3->Location = System::Drawing::Point(40, 120);
			this->label3->Name = S"label3";
			this->label3->Size = System::Drawing::Size(56, 16);
			this->label3->TabIndex = 23;
			this->label3->Text = S"助记码";
			// 
			// label2
			// 
			this->label2->Location = System::Drawing::Point(40, 72);
			this->label2->Name = S"label2";
			this->label2->Size = System::Drawing::Size(56, 16);
			this->label2->TabIndex = 22;
			this->label2->Text = S"科目名称";
			// 
			// label1
			// 
			this->label1->Location = System::Drawing::Point(40, 24);
			this->label1->Name = S"label1";
			this->label1->Size = System::Drawing::Size(56, 16);
			this->label1->TabIndex = 9;
			this->label1->Text = S"科目代码";
			// 
			// cmbBalance
			// 
			this->cmbBalance->ItemHeight = 12;
			System::Object* __mcTemp__2[] = new System::Object*[2];
			__mcTemp__2[0] = S"借方";
			__mcTemp__2[1] = S"贷方";
			this->cmbBalance->Items->AddRange(__mcTemp__2);
			this->cmbBalance->Location = System::Drawing::Point(40, 224);
			this->cmbBalance->Name = S"cmbBalance";
			this->cmbBalance->Size = System::Drawing::Size(240, 20);
			this->cmbBalance->TabIndex = 5;
			// 
			// cmbSubjectType
			// 
			this->cmbSubjectType->ItemHeight = 12;
			System::Object* __mcTemp__3[] = new System::Object*[5];
			__mcTemp__3[0] = S"资产";
			__mcTemp__3[1] = S"负载";
			__mcTemp__3[2] = S"权益";
			__mcTemp__3[3] = S"损益";
			__mcTemp__3[4] = S"成本";
			this->cmbSubjectType->Items->AddRange(__mcTemp__3);
			this->cmbSubjectType->Location = System::Drawing::Point(40, 184);
			this->cmbSubjectType->Name = S"cmbSubjectType";
			this->cmbSubjectType->Size = System::Drawing::Size(240, 20);
			this->cmbSubjectType->TabIndex = 4;
			// 
			// tBoxSubjectHelpCode
			// 
			this->tBoxSubjectHelpCode->Location = System::Drawing::Point(40, 136);
			this->tBoxSubjectHelpCode->Name = S"tBoxSubjectHelpCode";
			this->tBoxSubjectHelpCode->Size = System::Drawing::Size(240, 21);
			this->tBoxSubjectHelpCode->TabIndex = 2;
			this->tBoxSubjectHelpCode->Text = S"";