📄 medinfo.h
字号:
this->tBoxPinyinShow->Size = System::Drawing::Size(88, 21);
this->tBoxPinyinShow->TabIndex = 70;
this->tBoxPinyinShow->Text = S"";
//
// label18
//
this->label18->Location = System::Drawing::Point(256, 80);
this->label18->Name = S"label18";
this->label18->Size = System::Drawing::Size(56, 11);
this->label18->TabIndex = 65;
this->label18->Text = S"费用归类";
//
// tBoxWholeSalePrice
//
this->tBoxWholeSalePrice->Location = System::Drawing::Point(608, 48);
this->tBoxWholeSalePrice->Name = S"tBoxWholeSalePrice";
this->tBoxWholeSalePrice->Size = System::Drawing::Size(72, 21);
this->tBoxWholeSalePrice->TabIndex = 64;
this->tBoxWholeSalePrice->Text = S"";
//
// label11
//
this->label11->Location = System::Drawing::Point(608, 32);
this->label11->Name = S"label11";
this->label11->Size = System::Drawing::Size(80, 11);
this->label11->TabIndex = 63;
this->label11->Text = S"批发价";
//
// tBoxExportPrice
//
this->tBoxExportPrice->Location = System::Drawing::Point(528, 48);
this->tBoxExportPrice->Name = S"tBoxExportPrice";
this->tBoxExportPrice->Size = System::Drawing::Size(72, 21);
this->tBoxExportPrice->TabIndex = 62;
this->tBoxExportPrice->Text = S"";
//
// label3
//
this->label3->Location = System::Drawing::Point(528, 32);
this->label3->Name = S"label3";
this->label3->Size = System::Drawing::Size(80, 11);
this->label3->TabIndex = 61;
this->label3->Text = S"出库单价";
//
// tBoxImportPrice
//
this->tBoxImportPrice->Location = System::Drawing::Point(448, 48);
this->tBoxImportPrice->Name = S"tBoxImportPrice";
this->tBoxImportPrice->Size = System::Drawing::Size(72, 21);
this->tBoxImportPrice->TabIndex = 60;
this->tBoxImportPrice->Text = S"";
//
// tBoxScale
//
this->tBoxScale->Location = System::Drawing::Point(16, 96);
this->tBoxScale->Name = S"tBoxScale";
this->tBoxScale->Size = System::Drawing::Size(72, 21);
this->tBoxScale->TabIndex = 59;
this->tBoxScale->Text = S"";
//
// label12
//
this->label12->Location = System::Drawing::Point(16, 80);
this->label12->Name = S"label12";
this->label12->Size = System::Drawing::Size(56, 11);
this->label12->TabIndex = 58;
this->label12->Text = S"整数比";
//
// tBoxMedNameShow
//
this->tBoxMedNameShow->Location = System::Drawing::Point(96, 48);
this->tBoxMedNameShow->Name = S"tBoxMedNameShow";
this->tBoxMedNameShow->Size = System::Drawing::Size(152, 21);
this->tBoxMedNameShow->TabIndex = 49;
this->tBoxMedNameShow->Text = S"";
//
// label26
//
this->label26->Location = System::Drawing::Point(96, 80);
this->label26->Name = S"label26";
this->label26->Size = System::Drawing::Size(120, 11);
this->label26->TabIndex = 48;
this->label26->Text = S"分类";
//
// label8
//
this->label8->Location = System::Drawing::Point(448, 32);
this->label8->Name = S"label8";
this->label8->Size = System::Drawing::Size(80, 11);
this->label8->TabIndex = 16;
this->label8->Text = S"入库单价";
//
// tBoxUnit
//
this->tBoxUnit->Location = System::Drawing::Point(384, 48);
this->tBoxUnit->Name = S"tBoxUnit";
this->tBoxUnit->Size = System::Drawing::Size(56, 21);
this->tBoxUnit->TabIndex = 12;
this->tBoxUnit->Text = S"";
//
// tBoxSpec
//
this->tBoxSpec->Location = System::Drawing::Point(256, 48);
this->tBoxSpec->Name = S"tBoxSpec";
this->tBoxSpec->Size = System::Drawing::Size(56, 21);
this->tBoxSpec->TabIndex = 10;
this->tBoxSpec->Text = S"";
//
// label9
//
this->label9->Location = System::Drawing::Point(320, 32);
this->label9->Name = S"label9";
this->label9->Size = System::Drawing::Size(56, 11);
this->label9->TabIndex = 9;
this->label9->Text = S"整量单位";
//
// tBoxWholeUnit
//
this->tBoxWholeUnit->Location = System::Drawing::Point(320, 48);
this->tBoxWholeUnit->Name = S"tBoxWholeUnit";
this->tBoxWholeUnit->Size = System::Drawing::Size(56, 21);
this->tBoxWholeUnit->TabIndex = 14;
this->tBoxWholeUnit->Text = S"";
//
// label10
//
this->label10->Location = System::Drawing::Point(384, 32);
this->label10->Name = S"label10";
this->label10->Size = System::Drawing::Size(56, 11);
this->label10->TabIndex = 13;
this->label10->Text = S"散量单位";
//
// tBoxMedIDShow
//
this->tBoxMedIDShow->Location = System::Drawing::Point(16, 48);
this->tBoxMedIDShow->Name = S"tBoxMedIDShow";
this->tBoxMedIDShow->Size = System::Drawing::Size(72, 21);
this->tBoxMedIDShow->TabIndex = 2;
this->tBoxMedIDShow->Text = S"";
//
// label5
//
this->label5->Location = System::Drawing::Point(16, 32);
this->label5->Name = S"label5";
this->label5->Size = System::Drawing::Size(56, 11);
this->label5->TabIndex = 1;
this->label5->Text = S"编号";
//
// label6
//
this->label6->Location = System::Drawing::Point(256, 32);
this->label6->Name = S"label6";
this->label6->Size = System::Drawing::Size(56, 11);
this->label6->TabIndex = 5;
this->label6->Text = S"规格";
//
// label7
//
this->label7->Location = System::Drawing::Point(96, 32);
this->label7->Name = S"label7";
this->label7->Size = System::Drawing::Size(56, 11);
this->label7->TabIndex = 3;
this->label7->Text = S"名称";
//
// cmbMedKind
//
this->cmbMedKind->Location = System::Drawing::Point(96, 96);
this->cmbMedKind->Name = S"cmbMedKind";
this->cmbMedKind->Size = System::Drawing::Size(152, 20);
this->cmbMedKind->TabIndex = 7;
//
// sqlDataAdapter1
//
this->sqlDataAdapter1->DeleteCommand = this->sqlDeleteCommand1;
this->sqlDataAdapter1->InsertCommand = this->sqlInsertCommand1;
this->sqlDataAdapter1->SelectCommand = this->sqlSelectCommand1;
System::Data::Common::DataTableMapping* __mcTemp__2[] = new System::Data::Common::DataTableMapping*[1];
System::Data::Common::DataColumnMapping* __mcTemp__3[] = new System::Data::Common::DataColumnMapping*[11];
__mcTemp__3[0] = new System::Data::Common::DataColumnMapping(S"编号", S"编号");
__mcTemp__3[1] = new System::Data::Common::DataColumnMapping(S"病人编号", S"病人编号");
__mcTemp__3[2] = new System::Data::Common::DataColumnMapping(S"姓名", S"姓名");
__mcTemp__3[3] = new System::Data::Common::DataColumnMapping(S"性别", S"性别");
__mcTemp__3[4] = new System::Data::Common::DataColumnMapping(S"挂号科室", S"挂号科室");
__mcTemp__3[5] = new System::Data::Common::DataColumnMapping(S"费用类型", S"费用类型");
__mcTemp__3[6] = new System::Data::Common::DataColumnMapping(S"挂号类型", S"挂号类型");
__mcTemp__3[7] = new System::Data::Common::DataColumnMapping(S"挂号费用", S"挂号费用");
__mcTemp__3[8] = new System::Data::Common::DataColumnMapping(S"医生", S"医生");
__mcTemp__3[9] = new System::Data::Common::DataColumnMapping(S"时间", S"时间");
__mcTemp__3[10] = new System::Data::Common::DataColumnMapping(S"是否已划价", S"是否已划价");
__mcTemp__2[0] = new System::Data::Common::DataTableMapping(S"Table", S"门诊挂号", __mcTemp__3);
this->sqlDataAdapter1->TableMappings->AddRange(__mcTemp__2);
this->sqlDataAdapter1->UpdateCommand = this->sqlUpdateCommand1;
//
// sqlConnection1
//
this->sqlConnection1->ConnectionString = S"workstation id=\"SKS-DD7828BA353\";packet size=4096;integrated security=SSPI;initia"
S"l catalog=hisbook;persist security info=False";
//
// sqlSelectCommand1
//
this->sqlSelectCommand1->CommandText = S"SELECT 编号, 病人编号, 姓名, 性别, 挂号科室, 费用类型, 挂号类型, 挂号费用, 医生, 时间, 是否已划价 FROM 门诊挂号";
this->sqlSelectCommand1->Connection = this->sqlConnection1;
//
// sqlInsertCommand1
//
this->sqlInsertCommand1->CommandText = S"INSERT INTO 门诊挂号(编号, 病人编号, 姓名, 性别, 挂号科室, 费用类型, 挂号类型, 挂号费用, 医生, 时间, 是否已划价) VALUES "
S"(@编号, @病人编号, @姓名, @性别, @挂号科室, @费用类型, @挂号类型, @挂号费用, @医生, @时间, @是否已划价); SELECT 编号,"
S" 病人编号, 姓名, 性别, 挂号科室, 费用类型, 挂号类型, 挂号费用, 医生, 时间, 是否已划价 FROM 门诊挂号 WHERE (编号 = @编号)";
this->sqlInsertCommand1->Connection = this->sqlConnection1;
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@编号", System::Data::SqlDbType::VarChar, 15, S"编号"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@病人编号", System::Data::SqlDbType::VarChar, 15, S"病人编号"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@姓名", System::Data::SqlDbType::VarChar, 30, S"姓名"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@性别", System::Data::SqlDbType::VarChar, 2, S"性别"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号科室", System::Data::SqlDbType::VarChar, 30, S"挂号科室"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@费用类型", System::Data::SqlDbType::VarChar, 30, S"费用类型"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号类型", System::Data::SqlDbType::VarChar, 30, S"挂号类型"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号费用", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)12, (System::Byte)2, S"挂号费用", System::Data::DataRowVersion::Current, 0));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@医生", System::Data::SqlDbType::VarChar, 30, S"医生"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@时间", System::Data::SqlDbType::DateTime, 8, S"时间"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@是否已划价", System::Data::SqlDbType::VarChar, 2, S"是否已划价"));
//
// sqlUpdateCommand1
//
this->sqlUpdateCommand1->CommandText = S"UPDATE 门诊挂号 SET 编号 = @编号, 病人编号 = @病人编号, 姓名 = @姓名, 性别 = @性别, 挂号科室 = @挂号科室, 费用类型 = "
S"@费用类型, 挂号类型 = @挂号类型, 挂号费用 = @挂号费用, 医生 = @医生, 时间 = @时间, 是否已划价 = @是否已划价 WHERE (编号 "
S"= @Original_编号) AND (医生 = @Original_医生 OR @Original_医生 IS NULL AND 医生 IS NULL) A"
S"ND (姓名 = @Original_姓名 OR @Original_姓名 IS NULL AND 姓名 IS NULL) AND (性别 = @Origina"
S"l_性别 OR @Original_性别 IS NULL AND 性别 IS NULL) AND (挂号科室 = @Original_挂号科室 OR @Orig"
S"inal_挂号科室 IS NULL AND 挂号科室 IS NULL) AND (挂号类型 = @Original_挂号类型 OR @Original_挂号类型"
S" IS NULL AND 挂号类型 IS NULL) AND (挂号费用 = @Original_挂号费用 OR @Original_挂号费用 IS NULL "
S"AND 挂号费用 IS NULL) AND (时间 = @Original_时间 OR @Original_时间 IS NULL AND 时间 IS NULL)"
S" AND (是否已划价 = @Original_是否已划价 OR @Original_是否已划价 IS NULL AND 是否已划价 IS NULL) AND "
S"(病人编号 = @Original_病人编号 OR @Original_病人编号 IS NULL AND 病人编号 IS NULL) AND (费用类型 = @"
S"Original_费用类型 OR @Original_费用类型 IS NULL AND 费用类型 IS NULL); SELECT 编号, 病人编号, 姓名, "
S"性别, 挂号科室, 费用类型, 挂号类型, 挂号费用, 医生, 时间, 是否已划价 FROM 门诊挂号 WHERE (编号 = @编号)";
this->sqlUpdateCommand1->Connection = this->sqlConnection1;
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@编号", System::Data::SqlDbType::VarChar, 15, S"编号"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@病人编号", System::Data::SqlDbType::VarChar, 15, S"病人编号"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@姓名", System::Data::SqlDbType::VarChar, 30, S"姓名"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@性别", System::Data::SqlDbType::VarChar, 2, S"性别"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号科室", System::Data::SqlDbType::VarChar, 30, S"挂号科室"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@费用类型", System::Data::SqlDbType::VarChar, 30, S"费用类型"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号类型", System::Data::SqlDbType::VarChar, 30, S"挂号类型"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@挂号费用", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)12, (System::Byte)2, S"挂号费用", System::Data::DataRowVersion::Current, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@医生", System::Data::SqlDbType::VarChar, 30, S"医生"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@时间", System::Data::SqlDbType::DateTime, 8, S"时间"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@是否已划价", System::Data::SqlDbType::VarChar, 2, S"是否已划价"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_编号", System::Data::SqlDbType::VarChar, 15, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"编号", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_医生", System::Data::SqlDbType::VarChar, 30, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"医生", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_姓名", System::Data::SqlDbType::VarChar, 30, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"姓名", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_性别", System::Data::SqlDbType::VarChar, 2, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"性别", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_挂号科室", System::Data::SqlDbType::VarChar, 30, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"挂号科室", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_挂号类型", System::Data::SqlDbType::VarChar, 30, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"挂号类型", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_挂号费用", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)12, (System::Byte)2, S"挂号费用", System::Data::DataRowVersion::Original, 0));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -