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

	private: System::Windows::Forms::Label *  label1;
	private: System::Windows::Forms::TextBox *  tBoxID;
	private: System::Windows::Forms::TextBox *  tBoxDepot;
	private: System::Windows::Forms::TextBox *  tBoxName;
			 String* strSQL;

		//-------------------成员声明结束-----------------------
	public: 
		MedQuery(void)
		{
			InitializeComponent();
			//初始化
			this->MyDataBase = new LinkDataBase();
			this->ds = new DataSet();
			this->MedAdapter = new SqlDataAdapter();
		            
			//查询药品库存
			this->strSQL = S"SELECT 药品库存.编号, 药品资料.名称, 药品库存.库房, 药品库存.药品编号, 药品库存.药品数量, 药品库存.备注 FROM  药品库存 INNER JOIN  药品资料 ON  药品库存.药品编号 = 药品资料.编号";
			this->strTableName = S"药品库存";
			this->MyDataBase->SelectDataBase(this->MedAdapter,this->ds,this->strSQL,this->strTableName);

			//设置DataGrid
			this->dgrdPrice->DataSource = this->ds->Tables->Item[S"药品库存"];		
			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::DataGrid *  dgrdPrice;

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

	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::MedQuery));
			this->groupBox1 = new System::Windows::Forms::GroupBox();
			this->tBoxName = new System::Windows::Forms::TextBox();
			this->label1 = new System::Windows::Forms::Label();
			this->tBoxID = new System::Windows::Forms::TextBox();
			this->label4 = new System::Windows::Forms::Label();
			this->tBoxDepot = new System::Windows::Forms::TextBox();
			this->label2 = 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->groupBox1->SuspendLayout();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdPrice))->BeginInit();
			this->SuspendLayout();
			// 
			// groupBox1
			// 
			this->groupBox1->Controls->Add(this->tBoxName);
			this->groupBox1->Controls->Add(this->label1);
			this->groupBox1->Controls->Add(this->tBoxID);
			this->groupBox1->Controls->Add(this->label4);
			this->groupBox1->Controls->Add(this->tBoxDepot);
			this->groupBox1->Controls->Add(this->label2);
			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, 72);
			this->groupBox1->TabIndex = 1;
			this->groupBox1->TabStop = false;
			// 
			// tBoxName
			// 
			this->tBoxName->Location = System::Drawing::Point(472, 24);
			this->tBoxName->Name = S"tBoxName";
			this->tBoxName->Size = System::Drawing::Size(120, 21);
			this->tBoxName->TabIndex = 10;
			this->tBoxName->Text = S"";
			// 
			// label1
			// 
			this->label1->Location = System::Drawing::Point(408, 32);
			this->label1->Name = S"label1";
			this->label1->Size = System::Drawing::Size(56, 11);
			this->label1->TabIndex = 9;
			this->label1->Text = S"药品名称";
			// 
			// tBoxID
			// 
			this->tBoxID->Location = System::Drawing::Point(280, 24);
			this->tBoxID->Name = S"tBoxID";
			this->tBoxID->Size = System::Drawing::Size(120, 21);
			this->tBoxID->TabIndex = 8;
			this->tBoxID->Text = S"";
			// 
			// label4
			// 
			this->label4->Location = System::Drawing::Point(216, 32);
			this->label4->Name = S"label4";
			this->label4->Size = System::Drawing::Size(56, 11);
			this->label4->TabIndex = 7;
			this->label4->Text = S"药品编号";
			// 
			// tBoxDepot
			// 
			this->tBoxDepot->Location = System::Drawing::Point(88, 24);
			this->tBoxDepot->Name = S"tBoxDepot";
			this->tBoxDepot->Size = System::Drawing::Size(120, 21);
			this->tBoxDepot->TabIndex = 4;
			this->tBoxDepot->Text = S"";
			// 
			// label2
			// 
			this->label2->Location = System::Drawing::Point(24, 32);
			this->label2->Name = S"label2";
			this->label2->Size = System::Drawing::Size(56, 11);
			this->label2->TabIndex = 3;
			this->label2->Text = S"库房";
			// 
			// btnSearch
			// 
			this->btnSearch->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
			this->btnSearch->ImageIndex = 6;
			this->btnSearch->ImageList = this->imageList1;
			this->btnSearch->Location = System::Drawing::Point(656, 24);
			this->btnSearch->Name = S"btnSearch";
			this->btnSearch->Size = System::Drawing::Size(56, 24);
			this->btnSearch->TabIndex = 0;
			this->btnSearch->Text = S"搜索";
			this->btnSearch->TextAlign = System::Drawing::ContentAlignment::MiddleRight;
			this->btnSearch->Click += new System::EventHandler(this, btnSearch_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;
			// 
			// dgrdPrice
			// 
			this->dgrdPrice->DataMember = S"";
			this->dgrdPrice->Dock = System::Windows::Forms::DockStyle::Fill;
			this->dgrdPrice->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dgrdPrice->Location = System::Drawing::Point(0, 72);
			this->dgrdPrice->Name = S"dgrdPrice";
			this->dgrdPrice->Size = System::Drawing::Size(736, 285);
			this->dgrdPrice->TabIndex = 2;
			// 
			// MedQuery
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(736, 357);
			this->Controls->Add(this->dgrdPrice);
			this->Controls->Add(this->groupBox1);
			this->Name = S"MedQuery";
			this->Text = S"药物库存量";
			this->groupBox1->ResumeLayout(false);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdPrice))->EndInit();
			this->ResumeLayout(false);

		}		
	private:
	
		//-----------------------设置表格各列的属性-----------------------
		void DataGridStateControl()
		{

			DataGridTableStyle* ts = new DataGridTableStyle();			
			ts->MappingName = this->ds->Tables->Item[S"药品库存"]->TableName;
			
			DataGridNoActiveCellColumn* aTextColumn;
			ts->AllowSorting = false;
			ts->AlternatingBackColor = Color::LightGray;

			int numCols = this->ds->Tables->Item[S"药品库存"]->Columns->Count;
			for(int i = 0;i < numCols;i++)
			{
				aTextColumn = new DataGridNoActiveCellColumn();
				aTextColumn->get_TextBox()->Enabled = false;
				aTextColumn->MappingName = this->ds->Tables->Item[S"药品库存"]->Columns->Item[i]->ColumnName;
				aTextColumn->HeaderText = this->ds->Tables->Item[S"药品库存"]->Columns->Item[i]->ColumnName;
				aTextColumn->NullText = S"";
				aTextColumn->Format = S"D";
				ts->GridColumnStyles->Add(aTextColumn);
			}

			this->dgrdPrice->TableStyles->Add(ts);			
  		 }		
		 //按条件查询
private: System::Void btnSearch_Click(System::Object *  sender, System::EventArgs *  e)
		 {
			 String* strDepot = this->tBoxDepot->Text->Trim();
			 String* strID = this->tBoxID->Text->Trim();
			 String* strName = this->tBoxName->Text->Trim();
			 String* Filter = S"";
			 if(String::Compare(strDepot,String::Empty) != 0)
			 {
				 Filter = String::Format(S"{0} AND (库房 Like '%{1}%')",Filter,strDepot);
			 }
			 if(String::Compare(strID,String::Empty) != 0)
			 {
				 Filter = String::Format(S"{0} AND (药品编号 Like '%{1}%')",Filter,strID);
			 }
			 if(String::Compare(strName,String::Empty) != 0)
			 {
				 Filter = String::Format(S"{0} AND (名称 Like '%{1}%')",Filter,strName);
			 }

			 this->ds->Tables->Item[S"药品库存"]->Clear();

			 if(String::Compare(Filter,String::Empty) != 0)
			 {
				 Filter = Filter->Substring(5,Filter->Length - 5);
				 this->strSQL = String::Format(S"SELECT 药品库存.编号, 药品资料.名称, 药品库存.库房, 药品库存.药品编号, 药品库存.药品数量, 药品库存.备注 FROM  药品库存 INNER JOIN  药品资料 ON  药品库存.药品编号 = 药品资料.编号 Where {0}",Filter);
				 this->strTableName = S"药品库存";
				 this->MyDataBase->SelectDataBase(this->MedAdapter,this->ds,this->strSQL,this->strTableName);

			 }			 
		 }
};
}