📄 requireplan.h
字号:
//
this->label4->Location = System::Drawing::Point(64, 24);
this->label4->Name = S"label4";
this->label4->Size = System::Drawing::Size(56, 11);
this->label4->TabIndex = 15;
this->label4->Text = S"物料编号";
//
// label8
//
this->label8->Location = System::Drawing::Point(64, 72);
this->label8->Name = S"label8";
this->label8->Size = System::Drawing::Size(56, 11);
this->label8->TabIndex = 17;
this->label8->Text = S"物料名称";
//
// tBoxEndedDate
//
this->tBoxEndedDate->Location = System::Drawing::Point(64, 272);
this->tBoxEndedDate->Name = S"tBoxEndedDate";
this->tBoxEndedDate->Size = System::Drawing::Size(136, 21);
this->tBoxEndedDate->TabIndex = 10;
this->tBoxEndedDate->Text = S"";
//
// label9
//
this->label9->Location = System::Drawing::Point(64, 256);
this->label9->Name = S"label9";
this->label9->Size = System::Drawing::Size(56, 11);
this->label9->TabIndex = 9;
this->label9->Text = S"结束日期";
//
// tBoxMemo
//
this->tBoxMemo->Location = System::Drawing::Point(64, 416);
this->tBoxMemo->Multiline = true;
this->tBoxMemo->Name = S"tBoxMemo";
this->tBoxMemo->Size = System::Drawing::Size(136, 80);
this->tBoxMemo->TabIndex = 14;
this->tBoxMemo->Text = S"";
//
// label10
//
this->label10->Location = System::Drawing::Point(64, 400);
this->label10->Name = S"label10";
this->label10->Size = System::Drawing::Size(56, 11);
this->label10->TabIndex = 13;
this->label10->Text = S"备注";
//
// tBoxPlanDateDisplay
//
this->tBoxPlanDateDisplay->Location = System::Drawing::Point(64, 176);
this->tBoxPlanDateDisplay->Name = S"tBoxPlanDateDisplay";
this->tBoxPlanDateDisplay->Size = System::Drawing::Size(136, 21);
this->tBoxPlanDateDisplay->TabIndex = 4;
this->tBoxPlanDateDisplay->Text = S"";
//
// tBoxYearDisplay
//
this->tBoxYearDisplay->Location = System::Drawing::Point(64, 128);
this->tBoxYearDisplay->Name = S"tBoxYearDisplay";
this->tBoxYearDisplay->Size = System::Drawing::Size(136, 21);
this->tBoxYearDisplay->TabIndex = 2;
this->tBoxYearDisplay->Text = S"";
//
// label5
//
this->label5->Location = System::Drawing::Point(64, 112);
this->label5->Name = S"label5";
this->label5->Size = System::Drawing::Size(56, 11);
this->label5->TabIndex = 1;
this->label5->Text = S"年份";
//
// tBoxBeginDate
//
this->tBoxBeginDate->Location = System::Drawing::Point(64, 224);
this->tBoxBeginDate->Name = S"tBoxBeginDate";
this->tBoxBeginDate->Size = System::Drawing::Size(136, 21);
this->tBoxBeginDate->TabIndex = 6;
this->tBoxBeginDate->Text = S"";
//
// label6
//
this->label6->Location = System::Drawing::Point(64, 208);
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(64, 160);
this->label7->Name = S"label7";
this->label7->Size = System::Drawing::Size(56, 11);
this->label7->TabIndex = 3;
this->label7->Text = S"计划期";
//
// groupBox1
//
this->groupBox1->Controls->Add(this->tBoxMaterialID);
this->groupBox1->Controls->Add(this->label3);
this->groupBox1->Controls->Add(this->tBoxPlanDate);
this->groupBox1->Controls->Add(this->label2);
this->groupBox1->Controls->Add(this->tBoxYear);
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, 41);
this->groupBox1->Name = S"groupBox1";
this->groupBox1->Size = System::Drawing::Size(768, 79);
this->groupBox1->TabIndex = 7;
this->groupBox1->TabStop = false;
//
// tBoxMaterialID
//
this->tBoxMaterialID->Location = System::Drawing::Point(216, 40);
this->tBoxMaterialID->Name = S"tBoxMaterialID";
this->tBoxMaterialID->Size = System::Drawing::Size(120, 21);
this->tBoxMaterialID->TabIndex = 6;
this->tBoxMaterialID->Text = S"";
//
// label3
//
this->label3->Location = System::Drawing::Point(152, 48);
this->label3->Name = S"label3";
this->label3->Size = System::Drawing::Size(56, 11);
this->label3->TabIndex = 5;
this->label3->Text = S"物料编号";
//
// tBoxPlanDate
//
this->tBoxPlanDate->Location = System::Drawing::Point(608, 39);
this->tBoxPlanDate->Name = S"tBoxPlanDate";
this->tBoxPlanDate->Size = System::Drawing::Size(120, 21);
this->tBoxPlanDate->TabIndex = 4;
this->tBoxPlanDate->Text = S"";
//
// label2
//
this->label2->Location = System::Drawing::Point(544, 44);
this->label2->Name = S"label2";
this->label2->Size = System::Drawing::Size(56, 11);
this->label2->TabIndex = 3;
this->label2->Text = S"计划期";
//
// tBoxYear
//
this->tBoxYear->Location = System::Drawing::Point(408, 40);
this->tBoxYear->Name = S"tBoxYear";
this->tBoxYear->Size = System::Drawing::Size(120, 21);
this->tBoxYear->TabIndex = 2;
this->tBoxYear->Text = S"";
//
// label1
//
this->label1->Location = System::Drawing::Point(344, 45);
this->label1->Name = S"label1";
this->label1->Size = System::Drawing::Size(56, 11);
this->label1->TabIndex = 1;
this->label1->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(32, 40);
this->btnSearch->Name = S"btnSearch";
this->btnSearch->Size = System::Drawing::Size(72, 24);
this->btnSearch->TabIndex = 0;
this->btnSearch->Text = S"搜索";
this->btnSearch->Click += new System::EventHandler(this, btnSearch_Click);
//
// toolBar1
//
System::Windows::Forms::ToolBarButton* __mcTemp__1[] = new System::Windows::Forms::ToolBarButton*[10];
__mcTemp__1[0] = this->tBtnFirstRecord;
__mcTemp__1[1] = this->tBtnPreviousRecord;
__mcTemp__1[2] = this->tBtnNextRecord;
__mcTemp__1[3] = this->tBtnLastRecord;
__mcTemp__1[4] = this->tBtnNewRecord;
__mcTemp__1[5] = this->tBtnModifyRecord;
__mcTemp__1[6] = this->tBtnDeleteRecord;
__mcTemp__1[7] = this->tBtnPostModified;
__mcTemp__1[8] = this->tBtnCancleModified;
__mcTemp__1[9] = this->tBtnQuit;
this->toolBar1->Buttons->AddRange(__mcTemp__1);
this->toolBar1->DropDownArrows = true;
this->toolBar1->ImageList = this->imageList1;
this->toolBar1->Location = System::Drawing::Point(0, 0);
this->toolBar1->Name = S"toolBar1";
this->toolBar1->ShowToolTips = true;
this->toolBar1->Size = System::Drawing::Size(768, 41);
this->toolBar1->TabIndex = 6;
this->toolBar1->ButtonClick += new System::Windows::Forms::ToolBarButtonClickEventHandler(this, toolBar1_ButtonClick);
//
// tBtnFirstRecord
//
this->tBtnFirstRecord->ImageIndex = 5;
this->tBtnFirstRecord->Text = S"首记录";
this->tBtnFirstRecord->ToolTipText = S"首记录";
//
// tBtnPreviousRecord
//
this->tBtnPreviousRecord->ImageIndex = 4;
this->tBtnPreviousRecord->Text = S"上一记录";
this->tBtnPreviousRecord->ToolTipText = S"上一记录";
//
// tBtnNextRecord
//
this->tBtnNextRecord->ImageIndex = 8;
this->tBtnNextRecord->Text = S"下一记录";
this->tBtnNextRecord->ToolTipText = S"下一记录";
//
// tBtnLastRecord
//
this->tBtnLastRecord->ImageIndex = 7;
this->tBtnLastRecord->Text = S"尾记录";
this->tBtnLastRecord->ToolTipText = S"尾记录";
//
// tBtnNewRecord
//
this->tBtnNewRecord->ImageIndex = 9;
this->tBtnNewRecord->Text = S"新增";
this->tBtnNewRecord->ToolTipText = S"新增";
//
// tBtnModifyRecord
//
this->tBtnModifyRecord->ImageIndex = 10;
this->tBtnModifyRecord->Text = S"修改";
this->tBtnModifyRecord->ToolTipText = S"修改";
//
// tBtnDeleteRecord
//
this->tBtnDeleteRecord->ImageIndex = 3;
this->tBtnDeleteRecord->Text = S"删除";
this->tBtnDeleteRecord->ToolTipText = S"删除";
//
// tBtnPostModified
//
this->tBtnPostModified->ImageIndex = 0;
this->tBtnPostModified->Text = S"保存";
this->tBtnPostModified->ToolTipText = S"保存";
//
// tBtnCancleModified
//
this->tBtnCancleModified->ImageIndex = 2;
this->tBtnCancleModified->Text = S"取消";
this->tBtnCancleModified->ToolTipText = S"取消";
//
// tBtnQuit
//
this->tBtnQuit->ImageIndex = 12;
this->tBtnQuit->Text = S"退出";
this->tBtnQuit->ToolTipText = S"退出";
//
// dgrdRequirePlan
//
this->dgrdRequirePlan->DataMember = S"";
this->dgrdRequirePlan->Dock = System::Windows::Forms::DockStyle::Fill;
this->dgrdRequirePlan->HeaderForeColor = System::Drawing::SystemColors::ControlText;
this->dgrdRequirePlan->Location = System::Drawing::Point(0, 120);
this->dgrdRequirePlan->Name = S"dgrdRequirePlan";
this->dgrdRequirePlan->Size = System::Drawing::Size(472, 509);
this->dgrdRequirePlan->TabIndex = 9;
this->dgrdRequirePlan->Click += new System::EventHandler(this, dgrdRequirePlan_Click);
//
// DemandInsertSqlCmd
//
this->DemandInsertSqlCmd->CommandText = S"INSERT INTO 主需求计划 (编号, 物料编号, 年份, 计划期, 开始日期, 结束日期, 需求数量, 状态, 备注) VALUES (@编号, @物料编"
S"号, @年份, @计划期, @开始日期, @结束日期, @需求数量, @状态, @备注)";
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@编号", System::Data::SqlDbType::VarChar, 14, S"编号"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, S"年份"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, S"计划期"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@开始日期", System::Data::SqlDbType::Int, 4, S"开始日期"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@结束日期", System::Data::SqlDbType::Int, 4, S"结束日期"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Current, 0));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@状态", System::Data::SqlDbType::VarChar, 10, S"状态"));
this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 40, S"备注"));
//
// DemandDeleteSqlCmd
//
this->DemandDeleteSqlCmd->CommandText = S"DELETE FROM 主需求计划 WHERE (年份 = @Original_年份) AND (物料编号 = @Original_物料编号) AND (计划期 "
S"= @Original_计划期) AND (备注 = @Original_备注) AND (开始日期 = @Original_开始日期) AND (状态 = @"
S"Original_状态) AND (结束日期 = @Original_结束日期) AND (编号 = @Original_编号) AND (需求数量 = @Or"
S"iginal_需求数量)";
this->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
this->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->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->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"编号", System::Data::DataRowVersion::Original, 0));
this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Original, 0));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -