📄 bomform.h
字号:
this->groupBox1->Name = S"groupBox1";
this->groupBox1->Size = System::Drawing::Size(384, 348);
this->groupBox1->TabIndex = 3;
this->groupBox1->TabStop = false;
this->groupBox1->Text = S"物料详细信息";
//
// btnLookup
//
this->btnLookup->ImageAlign = System::Drawing::ContentAlignment::MiddleLeft;
this->btnLookup->ImageIndex = 11;
this->btnLookup->ImageList = this->imageList1;
this->btnLookup->Location = System::Drawing::Point(152, 88);
this->btnLookup->Name = S"btnLookup";
this->btnLookup->Size = System::Drawing::Size(48, 24);
this->btnLookup->TabIndex = 20;
this->btnLookup->Text = S"查找";
this->btnLookup->TextAlign = System::Drawing::ContentAlignment::MiddleRight;
this->btnLookup->Click += new System::EventHandler(this, btnLookup_Click);
//
// label10
//
this->label10->Location = System::Drawing::Point(56, 256);
this->label10->Name = S"label10";
this->label10->Size = System::Drawing::Size(56, 16);
this->label10->TabIndex = 19;
this->label10->Text = S"其它";
//
// tBoxOthers
//
this->tBoxOthers->Location = System::Drawing::Point(56, 272);
this->tBoxOthers->Name = S"tBoxOthers";
this->tBoxOthers->ReadOnly = true;
this->tBoxOthers->Size = System::Drawing::Size(248, 21);
this->tBoxOthers->TabIndex = 18;
this->tBoxOthers->Text = S"";
//
// label8
//
this->label8->Location = System::Drawing::Point(208, 208);
this->label8->Name = S"label8";
this->label8->Size = System::Drawing::Size(56, 16);
this->label8->TabIndex = 17;
this->label8->Text = S"领料库房";
//
// tBoxDrawedDepot
//
this->tBoxDrawedDepot->Location = System::Drawing::Point(208, 224);
this->tBoxDrawedDepot->Name = S"tBoxDrawedDepot";
this->tBoxDrawedDepot->ReadOnly = true;
this->tBoxDrawedDepot->Size = System::Drawing::Size(96, 21);
this->tBoxDrawedDepot->TabIndex = 16;
this->tBoxDrawedDepot->Text = S"";
//
// label9
//
this->label9->Location = System::Drawing::Point(56, 208);
this->label9->Name = S"label9";
this->label9->Size = System::Drawing::Size(56, 16);
this->label9->TabIndex = 15;
this->label9->Text = S"领料车间";
//
// tBoxDrawingWorkshop
//
this->tBoxDrawingWorkshop->Location = System::Drawing::Point(56, 224);
this->tBoxDrawingWorkshop->Name = S"tBoxDrawingWorkshop";
this->tBoxDrawingWorkshop->ReadOnly = true;
this->tBoxDrawingWorkshop->Size = System::Drawing::Size(96, 21);
this->tBoxDrawingWorkshop->TabIndex = 14;
this->tBoxDrawingWorkshop->Text = S"";
//
// label7
//
this->label7->Location = System::Drawing::Point(136, 168);
this->label7->Name = S"label7";
this->label7->Size = System::Drawing::Size(56, 16);
this->label7->TabIndex = 13;
this->label7->Text = S"底层码";
//
// tBoxInnerCode
//
this->tBoxInnerCode->Location = System::Drawing::Point(136, 184);
this->tBoxInnerCode->Name = S"tBoxInnerCode";
this->tBoxInnerCode->ReadOnly = true;
this->tBoxInnerCode->Size = System::Drawing::Size(64, 21);
this->tBoxInnerCode->TabIndex = 12;
this->tBoxInnerCode->Text = S"";
//
// label5
//
this->label5->Location = System::Drawing::Point(208, 168);
this->label5->Name = S"label5";
this->label5->Size = System::Drawing::Size(56, 16);
this->label5->TabIndex = 11;
this->label5->Text = S"审核日期";
//
// tBoxAuditingDate
//
this->tBoxAuditingDate->Location = System::Drawing::Point(208, 184);
this->tBoxAuditingDate->Name = S"tBoxAuditingDate";
this->tBoxAuditingDate->ReadOnly = true;
this->tBoxAuditingDate->Size = System::Drawing::Size(96, 21);
this->tBoxAuditingDate->TabIndex = 10;
this->tBoxAuditingDate->Text = S"";
//
// label6
//
this->label6->Location = System::Drawing::Point(56, 168);
this->label6->Name = S"label6";
this->label6->Size = System::Drawing::Size(56, 16);
this->label6->TabIndex = 9;
this->label6->Text = S"需求数量";
//
// tBoxDemandingQuantity
//
this->tBoxDemandingQuantity->Location = System::Drawing::Point(56, 184);
this->tBoxDemandingQuantity->Name = S"tBoxDemandingQuantity";
this->tBoxDemandingQuantity->ReadOnly = true;
this->tBoxDemandingQuantity->Size = System::Drawing::Size(72, 21);
this->tBoxDemandingQuantity->TabIndex = 8;
this->tBoxDemandingQuantity->Text = S"";
//
// label3
//
this->label3->Location = System::Drawing::Point(208, 120);
this->label3->Name = S"label3";
this->label3->Size = System::Drawing::Size(56, 16);
this->label3->TabIndex = 7;
this->label3->Text = S"上层名称";
//
// tBoxTopperName
//
this->tBoxTopperName->Location = System::Drawing::Point(208, 136);
this->tBoxTopperName->Name = S"tBoxTopperName";
this->tBoxTopperName->ReadOnly = true;
this->tBoxTopperName->Size = System::Drawing::Size(96, 21);
this->tBoxTopperName->TabIndex = 6;
this->tBoxTopperName->Text = S"";
//
// label4
//
this->label4->Location = System::Drawing::Point(56, 120);
this->label4->Name = S"label4";
this->label4->Size = System::Drawing::Size(72, 16);
this->label4->TabIndex = 5;
this->label4->Text = S"上层编号";
//
// tBoxTopperID
//
this->tBoxTopperID->Location = System::Drawing::Point(56, 136);
this->tBoxTopperID->Name = S"tBoxTopperID";
this->tBoxTopperID->ReadOnly = true;
this->tBoxTopperID->Size = System::Drawing::Size(96, 21);
this->tBoxTopperID->TabIndex = 4;
this->tBoxTopperID->Text = S"";
//
// label2
//
this->label2->Location = System::Drawing::Point(208, 72);
this->label2->Name = S"label2";
this->label2->Size = System::Drawing::Size(56, 16);
this->label2->TabIndex = 3;
this->label2->Text = S"物料名称";
//
// tBoxMaterialName
//
this->tBoxMaterialName->Location = System::Drawing::Point(208, 88);
this->tBoxMaterialName->Name = S"tBoxMaterialName";
this->tBoxMaterialName->ReadOnly = true;
this->tBoxMaterialName->Size = System::Drawing::Size(96, 21);
this->tBoxMaterialName->TabIndex = 2;
this->tBoxMaterialName->Text = S"";
//
// label1
//
this->label1->Location = System::Drawing::Point(56, 72);
this->label1->Name = S"label1";
this->label1->Size = System::Drawing::Size(56, 16);
this->label1->TabIndex = 1;
this->label1->Text = S"物料编号";
//
// tBoxMaterialID
//
this->tBoxMaterialID->Location = System::Drawing::Point(56, 88);
this->tBoxMaterialID->Name = S"tBoxMaterialID";
this->tBoxMaterialID->ReadOnly = true;
this->tBoxMaterialID->Size = System::Drawing::Size(96, 21);
this->tBoxMaterialID->TabIndex = 0;
this->tBoxMaterialID->Text = S"";
//
// BomSelectSqlCmd
//
this->BomSelectSqlCmd->CommandText = S"SELECT 物料清单.*, 物料主文件.物料名称 FROM 物料清单 INNER JOIN 物料主文件 ON 物料清单.物料编号 = 物料主文件.物料编号";
//
// BomInsertSqlCmd
//
this->BomInsertSqlCmd->CommandText = S"INSERT INTO 物料清单 (父项编号, 物料编号, 需要数量, 领料车间, 领料库房, 低层码, 其它事项) VALUES (@父项编号, @物料编号, "
S"@需要数量, @领料车间, @领料库房, @低层码, @其它事项)";
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@父项编号", System::Data::SqlDbType::VarChar, 14, S"父项编号"));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需要数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)18, (System::Byte)4, S"需要数量", System::Data::DataRowVersion::Current, 0));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@领料车间", System::Data::SqlDbType::VarChar, 10, S"领料车间"));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@领料库房", System::Data::SqlDbType::VarChar, 10, S"领料库房"));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@低层码", System::Data::SqlDbType::Int, 4, S"低层码"));
this->BomInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@其它事项", System::Data::SqlDbType::Text, 2147483647, S"其它事项"));
//
// BomUpdateSqlCmd
//
this->BomUpdateSqlCmd->CommandText = S"UPDATE 物料清单 SET 父项编号 = @父项编号,物料编号 = @物料编号,需要数量 = @需要数量, 领料车间 = @领料车间, 领料库房 = @领料库"
S"房, 低层码 = @低层码,其它事项 = @其它事项 Where 物料编号 = @Origin_物料编号";
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@父项编号", System::Data::SqlDbType::VarChar, 14, S"父项编号"));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需要数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)18, (System::Byte)4, S"需要数量", System::Data::DataRowVersion::Current, 0));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@领料车间", System::Data::SqlDbType::VarChar, 10, S"领料车间"));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@领料库房", System::Data::SqlDbType::VarChar, 10, S"领料库房"));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@低层码", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"低层码", System::Data::DataRowVersion::Current, S"0"));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@其它事项", System::Data::SqlDbType::NText, 2147483647, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"其它事项", System::Data::DataRowVersion::Current, S"10"));
this->BomUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Origin_物料编号", System::Data::SqlDbType::NVarChar, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
//
// BomDeleteSqlCmd
//
this->BomDeleteSqlCmd->CommandText = S"DELETE FROM 物料清单 WHERE (物料编号 = @物料编号)";
this->BomDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
//
// BomAdapter
//
this->BomAdapter->ContinueUpdateOnError = true;
this->BomAdapter->DeleteCommand = this->BomDeleteSqlCmd;
this->BomAdapter->InsertCommand = this->BomInsertSqlCmd;
this->BomAdapter->SelectCommand = this->BomSelectSqlCmd;
this->BomAdapter->UpdateCommand = this->BomUpdateSqlCmd;
this->BomAdapter->RowUpdating += new System::Data::SqlClient::SqlRowUpdatingEventHandler(this, BomAdapter_RowUpdating);
//
// BomForm
//
this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
this->ClientSize = System::Drawing::Size(624, 389);
this->Controls->Add(this->tvMaterialTree);
this->Controls->Add(this->groupBox1);
this->Controls->Add(this->toolBar1);
this->Name = S"BomForm";
this->Text = S"物料清单";
this->Load += new System::EventHandler(this, BomForm_Load);
this->groupBox1->ResumeLayout(false);
this->ResumeLayout(false);
}
//---------------------递归输入所有节点的信息------------------------------
void PopulateTreeView(String* parentPart,TreeNode* parentNode,DataRowView* parentRow)
{
String* strMaterialName;
//将物料清单另存为tempTable
DataTable* tempTable = this->ds->Tables->Item[S"物料清单"];
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -