📄 form1.h
字号:
this->statusBar1->Location = System::Drawing::Point(0, 317);
this->statusBar1->Name = S"statusBar1";
System::Windows::Forms::StatusBarPanel* __mcTemp__4[] = new System::Windows::Forms::StatusBarPanel*[2];
__mcTemp__4[0] = this->statusBarPanel2;
__mcTemp__4[1] = this->statusBarPanel3;
this->statusBar1->Panels->AddRange(__mcTemp__4);
this->statusBar1->ShowPanels = true;
this->statusBar1->Size = System::Drawing::Size(536, 24);
this->statusBar1->TabIndex = 9;
this->statusBar1->Text = S"statusBar1";
//
// statusBarPanel2
//
this->statusBarPanel2->AutoSize = System::Windows::Forms::StatusBarPanelAutoSize::Contents;
this->statusBarPanel2->Text = S"《数据库开发经典案例解析》 清华大学出版社";
this->statusBarPanel2->Width = 311;
//
// statusBarPanel3
//
this->statusBarPanel3->AutoSize = System::Windows::Forms::StatusBarPanelAutoSize::Spring;
this->statusBarPanel3->Width = 209;
//
// sqlDataAdapter1
//
this->sqlDataAdapter1->DeleteCommand = this->sqlDeleteCommand1;
this->sqlDataAdapter1->InsertCommand = this->sqlInsertCommand1;
this->sqlDataAdapter1->SelectCommand = this->sqlSelectCommand1;
System::Data::Common::DataTableMapping* __mcTemp__5[] = new System::Data::Common::DataTableMapping*[1];
System::Data::Common::DataColumnMapping* __mcTemp__6[] = new System::Data::Common::DataColumnMapping*[21];
__mcTemp__6[0] = new System::Data::Common::DataColumnMapping(S"预定单号", S"预定单号");
__mcTemp__6[1] = new System::Data::Common::DataColumnMapping(S"会员编号", S"会员编号");
__mcTemp__6[2] = new System::Data::Common::DataColumnMapping(S"客房类型", S"客房类型");
__mcTemp__6[3] = new System::Data::Common::DataColumnMapping(S"抵店时间", S"抵店时间");
__mcTemp__6[4] = new System::Data::Common::DataColumnMapping(S"离店时间", S"离店时间");
__mcTemp__6[5] = new System::Data::Common::DataColumnMapping(S"单据状态", S"单据状态");
__mcTemp__6[6] = new System::Data::Common::DataColumnMapping(S"入住人数", S"入住人数");
__mcTemp__6[7] = new System::Data::Common::DataColumnMapping(S"客房编号", S"客房编号");
__mcTemp__6[8] = new System::Data::Common::DataColumnMapping(S"客房价格", S"客房价格");
__mcTemp__6[9] = new System::Data::Common::DataColumnMapping(S"入住价格", S"入住价格");
__mcTemp__6[10] = new System::Data::Common::DataColumnMapping(S"折扣", S"折扣");
__mcTemp__6[11] = new System::Data::Common::DataColumnMapping(S"折扣原因", S"折扣原因");
__mcTemp__6[12] = new System::Data::Common::DataColumnMapping(S"是否加床", S"是否加床");
__mcTemp__6[13] = new System::Data::Common::DataColumnMapping(S"加床价格", S"加床价格");
__mcTemp__6[14] = new System::Data::Common::DataColumnMapping(S"预收款", S"预收款");
__mcTemp__6[15] = new System::Data::Common::DataColumnMapping(S"预定人", S"预定人");
__mcTemp__6[16] = new System::Data::Common::DataColumnMapping(S"预定公司", S"预定公司");
__mcTemp__6[17] = new System::Data::Common::DataColumnMapping(S"联系电话", S"联系电话");
__mcTemp__6[18] = new System::Data::Common::DataColumnMapping(S"备注", S"备注");
__mcTemp__6[19] = new System::Data::Common::DataColumnMapping(S"操作员", S"操作员");
__mcTemp__6[20] = new System::Data::Common::DataColumnMapping(S"业务员", S"业务员");
__mcTemp__5[0] = new System::Data::Common::DataTableMapping(S"Table", S"预定单历史", __mcTemp__6);
this->sqlDataAdapter1->TableMappings->AddRange(__mcTemp__5);
this->sqlDataAdapter1->UpdateCommand = this->sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this->sqlDeleteCommand1->CommandText = S"DELETE FROM 预定单历史 WHERE (预定单号 = @Original_预定单号) AND (业务员 = @Original_业务员 OR @Orig"
S"inal_业务员 IS NULL AND 业务员 IS NULL) AND (会员编号 = @Original_会员编号 OR @Original_会员编号 I"
S"S NULL AND 会员编号 IS NULL) AND (入住人数 = @Original_入住人数 OR @Original_入住人数 IS NULL AN"
S"D 入住人数 IS NULL) AND (入住价格 = @Original_入住价格 OR @Original_入住价格 IS NULL AND 入住价格 IS"
S" NULL) AND (加床价格 = @Original_加床价格 OR @Original_加床价格 IS NULL AND 加床价格 IS NULL) AN"
S"D (单据状态 = @Original_单据状态 OR @Original_单据状态 IS NULL AND 单据状态 IS NULL) AND (备注 = @"
S"Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 O"
S"R @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型 OR @Origin"
S"al_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 = @Original_客房编号 OR @Original_客房编号 I"
S"S NULL AND 客房编号 IS NULL) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 I"
S"S NULL) AND (折扣原因 = @Original_折扣原因 OR @Original_折扣原因 IS NULL AND 折扣原因 IS NULL) A"
S"ND (抵店时间 = @Original_抵店时间 OR @Original_抵店时间 IS NULL AND 抵店时间 IS NULL) AND (操作员 ="
S" @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (是否加床 = @Original_是"
S"否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NULL) AND (离店时间 = @Original_离店时间 OR @O"
S"riginal_离店时间 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 预定公司 I"
S"S NULL) AND (预收款 = @Original_预收款 OR @Original_预收款 IS NULL AND 预收款 IS NULL)";
this->sqlDeleteCommand1->Connection = this->sqlConnection1;
this->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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->sqlDeleteCommand1->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));
//
// sqlConnection1
//
this->sqlConnection1->ConnectionString = S"workstation id=\"SKS-DD7828BA353\";packet size=4096;integrated security=SSPI;initia"
S"l catalog=hotelbook;persist security info=False";
//
// sqlInsertCommand1
//
this->sqlInsertCommand1->CommandText = S"INSERT INTO 预定单历史(预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣,"
S" 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员) VALUES (@预定单号, @会员编号, @客房"
S"类型, @抵店时间, @离店时间, @单据状态, @入住人数, @客房编号, @客房价格, @入住价格, @折扣, @折扣原因, @是否加床, @加床价格, @"
S"预收款, @预定人, @预定公司, @联系电话, @备注, @操作员, @业务员); SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, "
S"单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作"
S"员, 业务员 FROM 预定单历史 WHERE (预定单号 = @预定单号)";
this->sqlInsertCommand1->Connection = this->sqlConnection1;
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定单号", System::Data::SqlDbType::VarChar, 36, S"预定单号"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@会员编号", System::Data::SqlDbType::Int, 4, S"会员编号"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房类型", System::Data::SqlDbType::VarChar, 4, S"客房类型"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@抵店时间", System::Data::SqlDbType::DateTime, 4, S"抵店时间"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@离店时间", System::Data::SqlDbType::DateTime, 4, S"离店时间"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@单据状态", System::Data::SqlDbType::VarChar, 20, S"单据状态"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@入住人数", System::Data::SqlDbType::Int, 4, S"入住人数"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房编号", System::Data::SqlDbType::VarChar, 12, S"客房编号"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房价格", System::Data::SqlDbType::Money, 8, S"客房价格"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@入住价格", System::Data::SqlDbType::Money, 8, S"入住价格"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@折扣", System::Data::SqlDbType::Decimal, 5, System::Data::ParameterDirection::Input, false, (System::Byte)4, (System::Byte)2, S"折扣", System::Data::DataRowVersion::Current, 0));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@折扣原因", System::Data::SqlDbType::VarChar, 60, S"折扣原因"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@是否加床", System::Data::SqlDbType::Bit, 1, S"是否加床"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@加床价格", System::Data::SqlDbType::Money, 8, S"加床价格"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预收款", System::Data::SqlDbType::Money, 8, S"预收款"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定人", System::Data::SqlDbType::VarChar, 20, S"预定人"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定公司", System::Data::SqlDbType::VarChar, 60, S"预定公司"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@联系电话", System::Data::SqlDbType::VarChar, 40, S"联系电话"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 510, S"备注"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@操作员", System::Data::SqlDbType::VarChar, 10, S"操作员"));
this->sqlInsertCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@业务员", System::Data::SqlDbType::VarChar, 50, S"业务员"));
//
// sqlSelectCommand1
//
this->sqlSelectCommand1->CommandText = S"SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床"
S", 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员 FROM 预定单历史";
this->sqlSelectCommand1->Connection = this->sqlConnection1;
//
// sqlUpdateCommand1
//
this->sqlUpdateCommand1->CommandText = S"UPDATE 预定单历史 SET 预定单号 = @预定单号, 会员编号 = @会员编号, 客房类型 = @客房类型, 抵店时间 = @抵店时间, 离店时间 = @"
S"离店时间, 单据状态 = @单据状态, 入住人数 = @入住人数, 客房编号 = @客房编号, 客房价格 = @客房价格, 入住价格 = @入住价格, 折扣 ="
S" @折扣, 折扣原因 = @折扣原因, 是否加床 = @是否加床, 加床价格 = @加床价格, 预收款 = @预收款, 预定人 = @预定人, 预定公司 = @"
S"预定公司, 联系电话 = @联系电话, 备注 = @备注, 操作员 = @操作员, 业务员 = @业务员 WHERE (预定单号 = @Original_预定单"
S"号) AND (业务员 = @Original_业务员 OR @Original_业务员 IS NULL AND 业务员 IS NULL) AND (会员编号 "
S"= @Original_会员编号 OR @Original_会员编号 IS NULL AND 会员编号 IS NULL) AND (入住人数 = @Origin"
S"al_入住人数 OR @Original_入住人数 IS NULL AND 入住人数 IS NULL) AND (入住价格 = @Original_入住价格 O"
S"R @Original_入住价格 IS NULL AND 入住价格 IS NULL) AND (加床价格 = @Original_加床价格 OR @Origin"
S"al_加床价格 IS NULL AND 加床价格 IS NULL) AND (单据状态 = @Original_单据状态 OR @Original_单据状态 I"
S"S NULL AND 单据状态 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 I"
S"S NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) A"
S"ND (客房类型 = @Original_客房类型 OR @Original_客房类型 IS NULL AND 客房类型 IS NULL) AND (客房编号 "
S"= @Original_客房编号 OR @Original_客房编号 IS NULL AND 客房编号 IS NULL) AND (折扣 = @Original"
S"_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (折扣原因 = @Original_折扣原因 OR @Origi"
S"nal_折扣原因 IS NULL AND 折扣原因 IS NULL) AND (抵店时间 = @Original_抵店时间 OR @Original_抵店时间 "
S"IS NULL AND 抵店时间 IS NULL) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND "
S"操作员 IS NULL) AND (是否加床 = @Original_是否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NU"
S"LL) AND (离店时间 = @Original_离店时间 OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND ("
S"联系电话 = @Original_联系电话 OR @Original_联系电话 IS NULL AND 联系电话 IS NULL) AND (预定人 = @Or"
S"iginal_预定人 OR @Original_预定人 IS NULL AND 预定人 IS NULL) AND (预定公司 = @Original_预定公司 "
S"OR @Original_预定公司 IS NULL AND 预定公司 IS NULL) AND (预收款 = @Original_预收款 OR @Origina"
S"l_预收款 IS NULL AND 预收款 IS NULL); SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数,"
S" 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员 FROM"
S" 预定单历史 WHERE (预定单号 = @预定单号)";
this->sqlUpdateCommand1->Connection = this->sqlConnection1;
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预定单号", System::Data::SqlDbType::VarChar, 36, S"预定单号"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@会员编号", System::Data::SqlDbType::Int, 4, S"会员编号"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房类型", System::Data::SqlDbType::VarChar, 4, S"客房类型"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@抵店时间", System::Data::SqlDbType::DateTime, 4, S"抵店时间"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@离店时间", System::Data::SqlDbType::DateTime, 4, S"离店时间"));
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::Int, 4, S"入住人数"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房编号", System::Data::SqlDbType::VarChar, 12, S"客房编号"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@客房价格", System::Data::SqlDbType::Money, 8, S"客房价格"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@入住价格", System::Data::SqlDbType::Money, 8, S"入住价格"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@折扣", System::Data::SqlDbType::Decimal, 5, System::Data::ParameterDirection::Input, false, (System::Byte)4, (System::Byte)2, S"折扣", System::Data::DataRowVersion::Current, 0));
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::Bit, 1, S"是否加床"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@加床价格", System::Data::SqlDbType::Money, 8, S"加床价格"));
this->sqlUpdateCommand1->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预收款", System::Data::SqlDbType::Money, 8, S"预收款"));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -