📄 materialsform.h
字号:
this->tBoxMaterialIDDisplay->Size = System::Drawing::Size(112, 21);
this->tBoxMaterialIDDisplay->TabIndex = 2;
this->tBoxMaterialIDDisplay->Text = S"";
this->tBoxMaterialIDDisplay->Leave += new System::EventHandler(this, tBoxMaterialIDDisplay_Leave);
//
// 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"物料编号";
//
// tBoxMaterialWordDisplay
//
this->tBoxMaterialWordDisplay->Location = System::Drawing::Point(256, 48);
this->tBoxMaterialWordDisplay->Name = S"tBoxMaterialWordDisplay";
this->tBoxMaterialWordDisplay->Size = System::Drawing::Size(120, 21);
this->tBoxMaterialWordDisplay->TabIndex = 6;
this->tBoxMaterialWordDisplay->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(136, 32);
this->label7->Name = S"label7";
this->label7->Size = System::Drawing::Size(56, 11);
this->label7->TabIndex = 3;
this->label7->Text = S"物料名称";
//
// imageList1
//
this->imageList1->ImageSize = System::Drawing::Size(16, 16);
this->imageList1->ImageStream = (__try_cast<System::Windows::Forms::ImageListStreamer * >(resources->GetObject(S"imageList1.ImageStream")));
this->imageList1->TransparentColor = System::Drawing::Color::Transparent;
//
// MaterialsForm
//
this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
this->ClientSize = System::Drawing::Size(760, 469);
this->Controls->Add(this->dgrdMaterials);
this->Controls->Add(this->groupBox2);
this->Controls->Add(this->groupBox1);
this->Controls->Add(this->toolBar1);
this->Name = S"MaterialsForm";
this->Text = S"物料主文件";
this->groupBox1->ResumeLayout(false);
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dgrdMaterials))->EndInit();
this->groupBox2->ResumeLayout(false);
this->ResumeLayout(false);
}
private:
//----------------设置控件ReadOnly属性------------------------
void SetModify(bool isModifiable)
{
this->tBoxMaterialIDDisplay->ReadOnly = !isModifiable;
this->tBoxMateriaNameDisplay->ReadOnly = !isModifiable;
this->tBoxMaterialWordDisplay->ReadOnly = !isModifiable;
this->tBoxModel->ReadOnly = !isModifiable;
this->tBoxRecorder->ReadOnly = !isModifiable;
this->tBoxRecordDate->ReadOnly = !isModifiable;
this->tBoxProperty1->ReadOnly = !isModifiable;
this->tBoxProperty2->ReadOnly = !isModifiable;
this->tBoxProperty3->ReadOnly = !isModifiable;
this->tBoxProperty4->ReadOnly = !isModifiable;
this->tBoxLong->ReadOnly = !isModifiable;
this->tBoxWidth->ReadOnly = !isModifiable;
this->tBoxHeight->ReadOnly = !isModifiable;
this->tBoxNetWeight->ReadOnly = !isModifiable;
this->tBoxBrand->ReadOnly = !isModifiable;
this->tBoxColour->ReadOnly = !isModifiable;
this->tBoxRank->ReadOnly = !isModifiable;
this->tBoxImportAhead->ReadOnly = !isModifiable;
this->tBoxPrepareCycle->ReadOnly = !isModifiable;
this->tBoxProduceCycle->ReadOnly = !isModifiable;
this->tBoxMinimumPack->ReadOnly = !isModifiable;
this->tBoxBatch->ReadOnly = !isModifiable;
this->tBoxMaximumStorage->ReadOnly = !isModifiable;
this->tBoxMinimumStorage->ReadOnly = !isModifiable;
this->tBoxStorageTerm->ReadOnly = !isModifiable;
this->tBoxMinimumDistribution->ReadOnly = !isModifiable;
this->cmbPlanType->Enabled = isModifiable;
this->cmbUnit->Enabled = isModifiable;
this->btnSearch->Enabled = !isModifiable;
this->dgrdMaterials->ReadOnly = !isModifiable;
}
//---------------------设置控件的数据邦定--------------------------
void SetDataBindings()
{
this->tBoxMaterialIDDisplay->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料编号");
this->tBoxMateriaNameDisplay->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料名称");
this->tBoxMaterialWordDisplay->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"拼音编码");
this->tBoxModel->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"规格型号");
this->tBoxRecorder->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"录入者");
this->tBoxRecordDate->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"录入日期");
this->tBoxProperty1->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料特性a");
this->tBoxProperty2->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料特性b");
this->tBoxProperty3->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料特性c");
this->tBoxProperty4->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"物料特性d");
this->tBoxLong->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"长");
this->tBoxWidth->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"宽");
this->tBoxHeight->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"高");
this->tBoxNetWeight->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"净重");
this->tBoxBrand->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"品牌");
this->tBoxColour->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"颜色");
this->tBoxRank->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"等级");
this->tBoxImportAhead->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"进货提前期");
this->tBoxPrepareCycle->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"准备周期");
this->tBoxProduceCycle->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"生产周期");
this->tBoxMinimumPack->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"最小包装量");
this->tBoxBatch->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"批量");
this->tBoxMaximumStorage->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"最高库存");
this->tBoxMinimumStorage->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"最低库存");
this->tBoxStorageTerm->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"库存期限");
this->tBoxMinimumDistribution->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"最低销售量");
this->cmbPlanType->DataBindings->Add(S"SelectedValue",this->ds->Tables->Item[S"物料主文件"],S"计划类别");
this->cmbUnit->DataBindings->Add(S"Text",this->ds->Tables->Item[S"物料主文件"],S"计量单位");
}
//-----------------------设置表格各列的属性-----------------------
void DataGridStateControl()
{
DataGridTableStyle* ts = new DataGridTableStyle();
ts->MappingName = this->ds->Tables->Item[S"物料主文件"]->TableName;
DataGridTextBoxColumn* aColumnTextColumn;
ts->AllowSorting = false;
ts->AlternatingBackColor = Color::LightGray;
aColumnTextColumn = new DataGridTextBoxColumn();
aColumnTextColumn->MappingName = this->ds->Tables->Item[0]->Columns->Item[S"物料编号"]->ColumnName;
aColumnTextColumn->HeaderText = this->ds->Tables->Item[0]->Columns->Item[S"物料编号"]->ColumnName;
aColumnTextColumn->NullText = String::Empty;
ts->GridColumnStyles->Add(aColumnTextColumn);
aColumnTextColumn = new DataGridTextBoxColumn();
aColumnTextColumn->MappingName = this->ds->Tables->Item[0]->Columns->Item[S"物料名称"]->ColumnName;
aColumnTextColumn->HeaderText = this->ds->Tables->Item[0]->Columns->Item[S"物料名称"]->ColumnName;
aColumnTextColumn->NullText = String::Empty;
ts->GridColumnStyles->Add(aColumnTextColumn);
this->dgrdMaterials->TableStyles->Add(ts);
}
//-----------------------工具栏按钮-----------------------
private:System::Void toolBar1_ButtonClick(System::Object * sender, System::Windows::Forms::ToolBarButtonClickEventArgs * e)
{
//设置控件属性
this->SetModify(false);
if(String::Compare(e->Button->ToolTipText,S"首记录") == 0)
{
this->dgrdMaterials->UnSelect(this->cmOrders->Position);
this->cmOrders->Position = 0;
this->dgrdMaterials->Select(this->cmOrders->Position);
this->dgrdMaterials->CurrentRowIndex = this->cmOrders->Position;
}
else if(String::Compare(e->Button->ToolTipText,S"上一记录") == 0)
{
if(this->cmOrders->Position > 0)
{
this->dgrdMaterials->UnSelect(this->cmOrders->Position);
this->cmOrders->Position--;
this->dgrdMaterials->Select(this->cmOrders->Position);
this->dgrdMaterials->CurrentRowIndex = this->cmOrders->Position;
}
}
else if(String::Compare(e->Button->ToolTipText,S"下一记录") == 0)
{
if(this->cmOrders->Position < this->cmOrders->Count)
{
this->dgrdMaterials->UnSelect(this->cmOrders->Position);
this->cmOrders->Position++;
this->dgrdMaterials->Select(this->cmOrders->Position);
this->dgrdMaterials->CurrentRowIndex = this->cmOrders->Position;
}
}
else if(String::Compare(e->Button->ToolTipText,S"尾记录") == 0)
{
this->dgrdMaterials->UnSelect(this->cmOrders->Position);
this->cmOrders->Position = this->cmOrders->Count;
this->dgrdMaterials->Select(this->cmOrders->Position);
this->dgrdMaterials->CurrentRowIndex = this->cmOrders->Position;
}
else if(String::Compare(e->Button->ToolTipText,S"新增") == 0)
{
this->cmOrders->AddNew();
//设置默认值
this->SetModify(true);
this->dgrdMaterials->UnSelect(this->cmOrders->Position);
this->cmOrders->Position = this->cmOrders->Count;
this->dgrdMaterials->Select(this->cmOrders->Position);
this->dgrdMaterials->CurrentRowIndex = this->cmOrders->Position;
this->tBoxMaterialIDDisplay->Text = S"9999";
this->tBoxMateriaNameDisplay->Text = S"新增物料";
}
else if(String::Compare(e->Button->ToolTipText,S"修改") == 0)
{
this->SetModify(true);
}
else if(String::Compare(e->Button->ToolTipText,S"删除") == 0)
{
System::Windows::Forms::DialogResult r = MessageBox::Show(S"确定删除？",S"删除数据",MessageBoxButtons::OKCancel);
if(r == DialogResult::OK)
{
if(this->cmOrders->Count > 0)
this->cmOrders->RemoveAt(this->dgrdMaterials->CurrentRowIndex);
else
MessageBox::Show(S"表格已空，无可删除数据",S"提示");
}
}
else if(String::Compare(e->Button->ToolTipText,S"提交") == 0)
{
this->btnSearch->Focus();
this->cmOrders->EndCurrentEdit();
this->MyDataBase->UpdateDataBase(this->MaterialsAdpater,this->ds,S"物料主文件");
}
else if(String::Compare(e->Button->ToolTipText,S"取消") == 0)
{
try
{
this->cmOrders->CancelCurrentEdit();
}
catch(Exception* e)
{
MessageBox::Show(e->Message,S"提示");
}
}
else if(String::Compare(e->Button->ToolTipText,S"退出") == 0)
{
this->Close();
}
}
private: System::Void tBoxMaterialIDDisplay_Leave(System::Object * sender, System::EventArgs * e)
{
if(String::Compare(this->tBoxMaterialIDDisplay->Text,String::Empty) == 0)
{
MessageBox::Show(S"物料编号不能为空",S"提示");
this->tBoxMaterialIDDisplay->Text = S"9999";
}
}
private: System::Void tBoxMateriaNameDisplay_Leave(System::Object * sender, System::EventArgs * e)
{
if(String::Compare(this->tBoxMaterialIDDisplay->Text,String::Empty) == 0)
{
MessageBox::Show(S"物料名称不能为空",S"提示");
this->tBoxMaterialIDDisplay->Text = S"物料名称";
}
}
private: System::Void btnSearch_Click(System::Object * sender, System::EventArgs * e)
{
String* strMaterialID = this->tBoxMaterialID->Text->Trim();
String* strMaterialName = this->tBoxMaterialName->Text->Trim();
String* strMaterialWord = this->tBoxMaterialWord->Text->Trim();
String* Filter = S"";
if(String::Compare(strMaterialID,String::Empty) != 0)
{
Filter = String::Format(S"{0} AND (物料编号 LIKE '%{1}%')",Filter,strMaterialID);
}
if(String::Compare(strMaterialName,String::Empty) != 0)
{
Filter = String::Format(S"{0} AND (物料名称 LIKE '%{1}%')",Filter,strMaterialName);
}
if(String::Compare(strMaterialWord,String::Empty) != 0)
{
Filter = String::Format(S"{0} AND (拼音编码 LIKE '%{1}%')",Filter,strMaterialWord);
}
this->ds->Tables->Item[S"物料主文件"]->Clear();
if(String::Compare(Filter,String::Empty) != 0)
{
Filter = Filter->Substring(5,Filter->Length - 5);
//查询物料主文件
this->strSQL = String::Format(S"Select * from 物料主文件 where {0}",Filter);
this->strTableName = S"物料主文件";
this->MyDataBase->SelectDataBase(this->MaterialsAdpater,this->ds,this->strSQL,this->strTableName);
}
else
{
//查询物料主文件
this->strSQL = S"Select * from 物料主文件";
this->strTableName = S"物料主文件";
this->MyDataBase->SelectDataBase(this->MaterialsAdpater,this->ds,this->strSQL,this->strTableName);
}
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -