📄 medinfo.h

📁 医院管理系统本系统包括说明文件,运行文件,希望站长接受如此好的系统.
💻 H
📖 第 1 页 / 共 4 页
字号:
12 3 4 下一页
#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> 
	/// MedInfo 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class MedInfo : public System::Windows::Forms::Form
	{
		//--------------------成员声明------------------------
	private:
		LinkDataBase* MyDataBase;	//数据库连接类
		SqlDataAdapter* MedAdapter;
		DataSet* ds;
		String* strTableName;
		String* strSQL;
	private: System::Data::SqlClient::SqlDataAdapter *  sqlDataAdapter1;




	private: System::Data::SqlClient::SqlConnection *  sqlConnection1;
	private: System::Data::SqlClient::SqlCommand *  sqlSelectCommand1;
	private: System::Data::SqlClient::SqlCommand *  sqlInsertCommand1;
	private: System::Data::SqlClient::SqlCommand *  sqlUpdateCommand1;
	private: System::Data::SqlClient::SqlCommand *  sqlDeleteCommand1;








			 CurrencyManager* cmMed;
		//-------------------成员声明结束-----------------------
	public: 
		MedInfo(void)
		{
			InitializeComponent();
			//初始化
			this->MyDataBase = new LinkDataBase();
			this->ds = new DataSet();
			this->MedAdapter = new SqlDataAdapter();		

			//查询药品资料
			this->strSQL = S"Select * from 药品资料";
			this->strTableName = S"药品资料";
			this->MyDataBase->SelectDataBase(this->MedAdapter,this->ds,this->strSQL,this->strTableName);

			this->cmMed = __try_cast<CurrencyManager*>(this->BindingContext->Item[this->ds->Tables->Item[S"药品资料"]]);
			//设置DataGrid
			this->dgrdMed->DataSource = this->ds->Tables->Item[S"药品资料"];
			this->DataGridStateControl();
			

			//填充[药品分类]的选项
			String* tempSQL = S"Select distinct 名称,编号 from 药品分类";
			this->MyDataBase->SelectDataBase(this->ds,tempSQL,S"药品分类");
			this->cmbMedKind->DataSource = this->ds->Tables->Item[S"药品分类"];
			this->cmbMedKind->DisplayMember = S"名称";
			this->cmbMedKind->ValueMember = S"编号";
						
			//设置控件的数据邦定
			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 *  label8;
	private: System::Windows::Forms::Label *  label9;
	private: System::Windows::Forms::Label *  label10;
	private: System::Windows::Forms::Label *  label12;
	protected: System::Windows::Forms::ImageList *  imageList1;
	private: System::Windows::Forms::DataGrid *  dgrdMed;
	private: System::Windows::Forms::Label *  label3;
	private: System::Windows::Forms::Label *  label11;
	private: System::Windows::Forms::Label *  label13;
	private: System::Windows::Forms::Label *  label14;
	private: System::Windows::Forms::Label *  label15;
	private: System::Windows::Forms::Label *  label16;
	private: System::Windows::Forms::Label *  label18;
	private: System::Windows::Forms::TextBox *  tBoxMedName;
	private: System::Windows::Forms::TextBox *  tBoxPinyin;
	private: System::Windows::Forms::TextBox *  tBoxMedID;
	private: System::Windows::Forms::TextBox *  tBoxScale;
	private: System::Windows::Forms::TextBox *  tBoxMedNameShow;
	private: System::Windows::Forms::TextBox *  tBoxUnit;
	private: System::Windows::Forms::TextBox *  tBoxSpec;
	private: System::Windows::Forms::TextBox *  tBoxWholeUnit;
	private: System::Windows::Forms::TextBox *  tBoxMedIDShow;
	private: System::Windows::Forms::ComboBox *  cmbMedKind;
	private: System::Windows::Forms::TextBox *  tBoxImportPrice;
	private: System::Windows::Forms::TextBox *  tBoxExportPrice;
	private: System::Windows::Forms::TextBox *  tBoxWholeSalePrice;
	private: System::Windows::Forms::TextBox *  tBoxFloorLimit;
	private: System::Windows::Forms::TextBox *  tBoxUpperLimit;
	private: System::Windows::Forms::TextBox *  tBoxValidate;
	private: System::Windows::Forms::TextBox *  tBoxFeeClassify;
	private: System::Windows::Forms::TextBox *  tBoxPinyinShow;
	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::MedInfo));
			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->tBoxMedName = new System::Windows::Forms::TextBox();
			this->label2 = new System::Windows::Forms::Label();
			this->tBoxPinyin = new System::Windows::Forms::TextBox();
			this->label1 = new System::Windows::Forms::Label();
			this->btnSearch = new System::Windows::Forms::Button();
			this->tBoxMedID = new System::Windows::Forms::TextBox();
			this->label4 = new System::Windows::Forms::Label();
			this->dgrdMed = new System::Windows::Forms::DataGrid();
			this->groupBox2 = new System::Windows::Forms::GroupBox();
			this->tBoxFloorLimit = new System::Windows::Forms::TextBox();
			this->label13 = new System::Windows::Forms::Label();
			this->tBoxUpperLimit = new System::Windows::Forms::TextBox();
			this->label14 = new System::Windows::Forms::Label();
			this->tBoxValidate = new System::Windows::Forms::TextBox();
			this->label15 = new System::Windows::Forms::Label();
			this->tBoxFeeClassify = new System::Windows::Forms::TextBox();
			this->label16 = new System::Windows::Forms::Label();
			this->tBoxPinyinShow = new System::Windows::Forms::TextBox();
			this->label18 = new System::Windows::Forms::Label();
			this->tBoxWholeSalePrice = new System::Windows::Forms::TextBox();
			this->label11 = new System::Windows::Forms::Label();
			this->tBoxExportPrice = new System::Windows::Forms::TextBox();
			this->label3 = new System::Windows::Forms::Label();
			this->tBoxImportPrice = new System::Windows::Forms::TextBox();
			this->tBoxScale = new System::Windows::Forms::TextBox();
			this->label12 = new System::Windows::Forms::Label();
			this->tBoxMedNameShow = new System::Windows::Forms::TextBox();
			this->label26 = new System::Windows::Forms::Label();
			this->label8 = new System::Windows::Forms::Label();
			this->tBoxUnit = new System::Windows::Forms::TextBox();
			this->tBoxSpec = new System::Windows::Forms::TextBox();
			this->label9 = new System::Windows::Forms::Label();
			this->tBoxWholeUnit = new System::Windows::Forms::TextBox();
			this->label10 = new System::Windows::Forms::Label();
			this->tBoxMedIDShow = new System::Windows::Forms::TextBox();
			this->label5 = new System::Windows::Forms::Label();
			this->label6 = new System::Windows::Forms::Label();
			this->label7 = new System::Windows::Forms::Label();
			this->cmbMedKind = new System::Windows::Forms::ComboBox();
			this->sqlDataAdapter1 = new System::Data::SqlClient::SqlDataAdapter();
			this->sqlConnection1 = new System::Data::SqlClient::SqlConnection();
			this->sqlSelectCommand1 = new System::Data::SqlClient::SqlCommand();
			this->sqlInsertCommand1 = new System::Data::SqlClient::SqlCommand();
			this->sqlUpdateCommand1 = new System::Data::SqlClient::SqlCommand();
			this->sqlDeleteCommand1 = new System::Data::SqlClient::SqlCommand();
			this->groupBox1->SuspendLayout();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdMed))->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->tBtnPreviousRecord;
			__mcTemp__1[2] = this->tBtnNextRecord;
			__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(768, 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"首记录";
			//
12 3 4 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -