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

			   DataView* DetailView;
		//-------------------成员声明结束-----------------------
	public: 
		SendMedicine(void)
		{
			InitializeComponent();
			//初始化
			this->MyDataBase = new LinkDataBase();
			this->ds = new DataSet();
			this->ChargeAdapter = new SqlDataAdapter();
			this->PriceView = new DataView();
			this->DetailView = new DataView();
            
			//查询门诊划价
			this->strSQL = S"SELECT 门诊挂号.姓名, 门诊挂号.性别, 门诊划价.编号, 门诊划价.科室, 门诊划价.挂号编号, 门诊划价.医生, 门诊划价.划价时间, 门诊划价.是否收费, 门诊划价.划价员, 门诊划价.收费员, 门诊划价.收费时间, 门诊划价.划价金额, 门诊划价.是否发药, 门诊划价.发药时间, 门诊划价.发药员 FROM 门诊划价 INNER JOIN 门诊挂号 ON 门诊划价.挂号编号 = 门诊挂号.编号 Where 门诊划价.是否收费 = '是' AND 门诊划价.是否发药 = '否'";
			this->strTableName = S"门诊划价";
			this->MyDataBase->SelectDataBase(this->ChargeAdapter,this->ds,this->strSQL,this->strTableName);
			this->PriceView->Table = this->ds->Tables->Item[S"门诊划价"];

			//查询门诊划价明细
			this->strSQL = S"SELECT 门诊划价明细.编号, 门诊划价明细.划价编号, 门诊划价明细.药品编号, 药品资料.名称, 门诊划价明细.单价, 门诊划价明细.数量, 门诊划价明细.金额 FROM  门诊划价明细 INNER JOIN 药品资料 ON 门诊划价明细.药品编号 = 药品资料.编号";
			this->strTableName = S"门诊划价明细";
			this->MyDataBase->SelectDataBase(this->ChargeAdapter,this->ds,this->strSQL,this->strTableName);
			this->DetailView->Table = this->ds->Tables->Item[S"门诊划价明细"];

			//显示划价单第一项的明细
			this->DetailView->RowFilter = String::Format(S"划价编号 = '{0}'",this->ds->Tables->Item[S"门诊划价"]->Rows->Item[0]->Item[S"编号"]->ToString());
			//设置DataGrid
			this->dgrdPrice->DataSource = this->PriceView;
			this->dgrdPriceDetail->DataSource = this->DetailView;
			this->DataGridStateControl();
		}
        
	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}






	private: System::Windows::Forms::Label *  label4;

	private: System::Windows::Forms::Label *  label8;
	private: System::Windows::Forms::TextBox *  tBoxStartTime;
	private: System::Windows::Forms::TextBox *  tBoxID;
	private: System::Windows::Forms::TextBox *  tBoxEndTime;
	private: System::Windows::Forms::TextBox *  tBoxName;
	private: System::Windows::Forms::Label *  label9;





	private: System::Windows::Forms::DataGrid *  dgrdPrice;
	private: System::Windows::Forms::DataGrid *  dgrdPriceDetail;
	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::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::SendMedicine));
			this->groupBox1 = new System::Windows::Forms::GroupBox();
			this->btnReceive = new System::Windows::Forms::Button();
			this->label9 = new System::Windows::Forms::Label();
			this->tBoxEndTime = new System::Windows::Forms::TextBox();
			this->label4 = new System::Windows::Forms::Label();
			this->tBoxName = new System::Windows::Forms::TextBox();
			this->label8 = new System::Windows::Forms::Label();
			this->tBoxStartTime = new System::Windows::Forms::TextBox();
			this->label2 = new System::Windows::Forms::Label();
			this->tBoxID = new System::Windows::Forms::TextBox();
			this->label1 = new System::Windows::Forms::Label();
			this->btnSearch = new System::Windows::Forms::Button();
			this->imageList1 = new System::Windows::Forms::ImageList(this->components);
			this->dgrdPrice = new System::Windows::Forms::DataGrid();
			this->dgrdPriceDetail = new System::Windows::Forms::DataGrid();
			this->groupBox1->SuspendLayout();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdPrice))->BeginInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdPriceDetail))->BeginInit();
			this->SuspendLayout();
			// 
			// groupBox1
			// 
			this->groupBox1->Controls->Add(this->btnReceive);
			this->groupBox1->Controls->Add(this->label9);
			this->groupBox1->Controls->Add(this->tBoxEndTime);
			this->groupBox1->Controls->Add(this->label4);
			this->groupBox1->Controls->Add(this->tBoxName);
			this->groupBox1->Controls->Add(this->label8);
			this->groupBox1->Controls->Add(this->tBoxStartTime);
			this->groupBox1->Controls->Add(this->label2);
			this->groupBox1->Controls->Add(this->tBoxID);
			this->groupBox1->Controls->Add(this->label1);
			this->groupBox1->Controls->Add(this->btnSearch);
			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(736, 128);
			this->groupBox1->TabIndex = 1;
			this->groupBox1->TabStop = false;
			// 
			// btnReceive
			// 
			this->btnReceive->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
			this->btnReceive->Location = System::Drawing::Point(648, 64);
			this->btnReceive->Name = S"btnReceive";
			this->btnReceive->Size = System::Drawing::Size(56, 24);
			this->btnReceive->TabIndex = 72;
			this->btnReceive->Text = S"发药";
			this->btnReceive->Click += new System::EventHandler(this, btnReceive_Click);
			// 
			// label9
			// 
			this->label9->Location = System::Drawing::Point(448, 64);
			this->label9->Name = S"label9";
			this->label9->Size = System::Drawing::Size(112, 11);
			this->label9->TabIndex = 9;
			this->label9->Text = S"格式如：2005-1-1";
			// 
			// tBoxEndTime
			// 
			this->tBoxEndTime->Location = System::Drawing::Point(448, 88);
			this->tBoxEndTime->Name = S"tBoxEndTime";
			this->tBoxEndTime->Size = System::Drawing::Size(120, 21);
			this->tBoxEndTime->TabIndex = 8;
			this->tBoxEndTime->Text = S"";
			// 
			// label4
			// 
			this->label4->Location = System::Drawing::Point(384, 96);
			this->label4->Name = S"label4";
			this->label4->Size = System::Drawing::Size(56, 11);
			this->label4->TabIndex = 7;
			this->label4->Text = S"结束时间";
			// 
			// tBoxName
			//