accountsetting.h

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

#pragma once
#include "LinkDataBase.h"
#include "TrialBalance.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> 
	/// AccountSetting 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class AccountSetting : public System::Windows::Forms::Form
	{
	//--------------------成员声明------------------------
	private:
		LinkDataBase* MyDataBase;	//数据库连接类
		DataSet* ds;		
		String* strTableName;
		String* strSQL;
		CurrencyManager* cmSubject;
		SqlDataAdapter* AccountAdapter;
	private: System::Windows::Forms::ImageList *  imageList1;
	private: System::Data::SqlClient::SqlCommand *  SqlCmdSystemUpdate;

	private: System::Data::SqlClient::SqlCommand *  SqlCmdSystemInsert;
	private: System::Data::SqlClient::SqlCommand *  sqlCommand2;
			 SqlDataAdapter* SystemAdapter;
	//-------------------成员声明结束-----------------------
	public: 
		AccountSetting(void)
		{
			InitializeComponent();
			this->MyDataBase = new LinkDataBase();
			this->AccountAdapter = new SqlDataAdapter();
			this->SystemAdapter = new SqlDataAdapter();
			this->ds = new DataSet();
			this->strSQL = S"SELECT 科目代码,科目名称,累计借方,累计贷方,期初余额,余额方向 FROM  帐簿初始化表";			
			this->MyDataBase->SelectDataBase(this->AccountAdapter,this->ds,this->strSQL,S"帐簿初始化表");

			this->strSQL = S"SELECT * FROM  系统参数表";			
			this->MyDataBase->SelectDataBase(this->SystemAdapter,this->ds,this->strSQL,S"系统参数表");
			
			this->SqlCmdSystemUpdate->Connection = this->MyDataBase->myConnection;
			this->SystemAdapter->UpdateCommand = this->SqlCmdSystemUpdate;
			this->SqlCmdSystemInsert->Connection = this->MyDataBase->myConnection;
			this->SystemAdapter->InsertCommand = this->SqlCmdSystemInsert;

			this->sqlCommand2->Connection = this->MyDataBase->myConnection;
			this->SystemAdapter->DeleteCommand = this->sqlCommand2;			
		}
        
	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}


	private: System::Windows::Forms::GroupBox *  groupBox1;




	private: System::Windows::Forms::Button *  btnNewAccount;
	private: System::Windows::Forms::Button *  btnStartAccount;
	private: System::Windows::Forms::Button *  btnBalance;
	private: System::Windows::Forms::Button *  btnQuit;
	private: System::Windows::Forms::DataGrid *  dgrdAccountInitial;
	private: System::Windows::Forms::DataGrid *  dgrdSystemParameter;
	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::AccountSetting));
			this->dgrdAccountInitial = new System::Windows::Forms::DataGrid();
			this->dgrdSystemParameter = new System::Windows::Forms::DataGrid();
			this->groupBox1 = new System::Windows::Forms::GroupBox();
			this->btnQuit = new System::Windows::Forms::Button();
			this->imageList1 = new System::Windows::Forms::ImageList(this->components);
			this->btnBalance = new System::Windows::Forms::Button();
			this->btnStartAccount = new System::Windows::Forms::Button();
			this->btnNewAccount = new System::Windows::Forms::Button();
			this->SqlCmdSystemUpdate = new System::Data::SqlClient::SqlCommand();
			this->SqlCmdSystemInsert = new System::Data::SqlClient::SqlCommand();
			this->sqlCommand2 = new System::Data::SqlClient::SqlCommand();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdAccountInitial))->BeginInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdSystemParameter))->BeginInit();
			this->groupBox1->SuspendLayout();
			this->SuspendLayout();
			// 
			// dgrdAccountInitial
			// 
			this->dgrdAccountInitial->AllowNavigation = false;
			this->dgrdAccountInitial->DataMember = S"";
			this->dgrdAccountInitial->Dock = System::Windows::Forms::DockStyle::Fill;
			this->dgrdAccountInitial->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dgrdAccountInitial->Location = System::Drawing::Point(0, 72);
			this->dgrdAccountInitial->Name = S"dgrdAccountInitial";
			this->dgrdAccountInitial->Size = System::Drawing::Size(472, 309);
			this->dgrdAccountInitial->TabIndex = 4;
			// 
			// dgrdSystemParameter
			// 
			this->dgrdSystemParameter->AllowNavigation = false;
			this->dgrdSystemParameter->DataMember = S"";
			this->dgrdSystemParameter->Dock = System::Windows::Forms::DockStyle::Right;
			this->dgrdSystemParameter->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dgrdSystemParameter->Location = System::Drawing::Point(472, 72);
			this->dgrdSystemParameter->Name = S"dgrdSystemParameter";
			this->dgrdSystemParameter->Size = System::Drawing::Size(256, 309);
			this->dgrdSystemParameter->TabIndex = 5;
			// 
			// groupBox1
			// 
			this->groupBox1->Controls->Add(this->btnQuit);
			this->groupBox1->Controls->Add(this->btnBalance);
			this->groupBox1->Controls->Add(this->btnStartAccount);
			this->groupBox1->Controls->Add(this->btnNewAccount);
			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(728, 72);
			this->groupBox1->TabIndex = 6;
			this->groupBox1->TabStop = false;
			// 
			// btnQuit
			// 
			this->btnQuit->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
			this->btnQuit->ImageIndex = 15;
			this->btnQuit->ImageList = this->imageList1;
			this->btnQuit->Location = System::Drawing::Point(536, 32);
			this->btnQuit->Name = S"btnQuit";
			this->btnQuit->Size = System::Drawing::Size(88, 24);
			this->btnQuit->TabIndex = 3;
			this->btnQuit->Text = S"退出";
			this->btnQuit->Click += new System::EventHandler(this, btnQuit_Click);
			// 
			// 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;
			// 
			// btnBalance
			// 
			this->btnBalance->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
			this->btnBalance->ImageIndex = 14;
			this->btnBalance->ImageList = this->imageList1;
			this->btnBalance->Location = System::Drawing::Point(384, 32);