📄 form1.h
字号:
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定人", System::Data::SqlDbType::VarChar, 20, S"预定人"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定公司", System::Data::SqlDbType::VarChar, 60, S"预定公司"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@联系电话", System::Data::SqlDbType::VarChar, 40, S"联系电话"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 510, S"备注"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@操作员", System::Data::SqlDbType::VarChar, 10, S"操作员"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@业务员", System::Data::SqlDbType::VarChar, 50, S"业务员"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_预定单号", System::Data::SqlDbType::VarChar, 36, 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, 50, 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::Int, 4, 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::Int, 4, 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::Money, 8, 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::Money, 8, 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, 20, 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, 510, 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::Money, 8, 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, 4, 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, 12, 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, 5, System::Data::ParameterDirection::Input, false, (System::Byte)4, (System::Byte)2, S"折扣", System::Data::DataRowVersion::Original, 0));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_折扣原因", System::Data::SqlDbType::VarChar, 60, 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::DateTime, 4, 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, 10, 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::Bit, 1, 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::DateTime, 4, 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, 40, 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, 20, 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, 60, 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::Money, 8, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"预收款", System::Data::DataRowVersion::Original, 0));
//
// Form1
//
this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
this->ClientSize = System::Drawing::Size(536, 341);
this->Controls->Add(this->statusBar1);
this->IsMdiContainer = true;
this->Menu = this->mainMenu1;
this->Name = S"Form1";
this->Text = S"酒店管理系统";
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->statusBarPanel2))->EndInit();
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->statusBarPanel3))->EndInit();
this->ResumeLayout(false);
}
//------------------------查询一个子窗口是否存在--------------------------------
private: bool CheckChildFrmExist(String* ChildFrmName)
{
Form* tempChild;
//逐个查找子窗口，如果存在则将其激活
for(int i = 0;i < this->MdiChildren->Length;i++)
{
tempChild = dynamic_cast<Form*>(this->MdiChildren[i]);
if(String::Compare(tempChild->Name,ChildFrmName) == 0)
{
if(tempChild->WindowState == FormWindowState::Minimized)
{
tempChild->WindowState = FormWindowState::Maximized;
}
tempChild->Activate();
return true;
}
}
return false;
}
//客房类型设置
private: System::Void menuItem5_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("RoomType"))
{
return;
}
else
{
RoomType* newFrm = new RoomType();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//客房信息设置
private: System::Void menuItem6_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("RoomInfo"))
{
return;
}
else
{
RoomInfo* newFrm = new RoomInfo();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//预订管理
private: System::Void menuItem7_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("HotelReserve"))
{
return;
}
else
{
HotelReserve* newFrm = new HotelReserve();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//入住管理
private: System::Void menuItem8_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("HotelArrival"))
{
return;
}
else
{
HotelArrival* newFrm = new HotelArrival();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//消费记帐
private: System::Void menuItem9_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("ClientConsume"))
{
return;
}
else
{
ClientConsume* newFrm = new ClientConsume();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//收银结帐
private: System::Void menuItem10_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("HotelLeaves"))
{
return;
}
else
{
HotelLeaves* newFrm = new HotelLeaves();
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
//房态管理
private: System::Void menuItem1_Click(System::Object * sender, System::EventArgs * e)
{
if(this->CheckChildFrmExist("RoomStatus"))
{
return;
}
else
{
RoomStatus* newFrm = new RoomStatus(false);
newFrm->MdiParent = this;
newFrm->WindowState = FormWindowState::Maximized;
newFrm->Show();
}
}
private: System::Void menuItem4_Click(System::Object * sender, System::EventArgs * e)
{
this->Close();
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -