📄 manageregisterform.h
字号:
this->dataGridViewTextBoxColumn8->HeaderText = L"套内面积";
this->dataGridViewTextBoxColumn8->Name = L"dataGridViewTextBoxColumn8";
this->dataGridViewTextBoxColumn8->ReadOnly = true;
//
// dataGridViewTextBoxColumn5
//
this->dataGridViewTextBoxColumn5->DataPropertyName = L"计费年份";
this->dataGridViewTextBoxColumn5->HeaderText = L"计费年份";
this->dataGridViewTextBoxColumn5->Name = L"dataGridViewTextBoxColumn5";
this->dataGridViewTextBoxColumn5->ReadOnly = true;
//
// dataGridViewTextBoxColumn6
//
this->dataGridViewTextBoxColumn6->DataPropertyName = L"计费月份";
this->dataGridViewTextBoxColumn6->HeaderText = L"计费月份";
this->dataGridViewTextBoxColumn6->Name = L"dataGridViewTextBoxColumn6";
this->dataGridViewTextBoxColumn6->ReadOnly = true;
//
// dataGridViewTextBoxColumn1
//
this->dataGridViewTextBoxColumn1->DataPropertyName = L"自动编号";
this->dataGridViewTextBoxColumn1->HeaderText = L"自动编号";
this->dataGridViewTextBoxColumn1->Name = L"dataGridViewTextBoxColumn1";
this->dataGridViewTextBoxColumn1->ReadOnly = true;
this->dataGridViewTextBoxColumn1->Visible = false;
//
// dataGridViewTextBoxColumn10
//
this->dataGridViewTextBoxColumn10->DataPropertyName = L"登记标志";
this->dataGridViewTextBoxColumn10->HeaderText = L"登记标志";
this->dataGridViewTextBoxColumn10->Name = L"dataGridViewTextBoxColumn10";
this->dataGridViewTextBoxColumn10->Visible = false;
//
// dataGridViewTextBoxColumn11
//
this->dataGridViewTextBoxColumn11->DataPropertyName = L"费用状态";
this->dataGridViewTextBoxColumn11->HeaderText = L"费用状态";
this->dataGridViewTextBoxColumn11->Name = L"dataGridViewTextBoxColumn11";
this->dataGridViewTextBoxColumn11->Visible = false;
//
// dataGridViewTextBoxColumn12
//
this->dataGridViewTextBoxColumn12->DataPropertyName = L"收据编号";
this->dataGridViewTextBoxColumn12->HeaderText = L"收据编号";
this->dataGridViewTextBoxColumn12->Name = L"dataGridViewTextBoxColumn12";
this->dataGridViewTextBoxColumn12->Visible = false;
//
// ManageRegisterForm
//
this->AutoScaleDimensions = System::Drawing::SizeF(6, 12);
this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
this->ClientSize = System::Drawing::Size(542, 416);
this->Controls->Add(this->物管费用DataGridView);
this->Controls->Add(this->物管费用BindingNavigator);
this->Name = L"ManageRegisterForm";
this->ShowInTaskbar = false;
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterParent;
this->Text = L"费用管理[物管费用登记]";
this->Load += gcnew System::EventHandler(this, &ManageRegisterForm::ManageRegisterForm_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->DBCommunityDataSet))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->物管费用BindingSource))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->物管费用BindingNavigator))->EndInit();
this->物管费用BindingNavigator->ResumeLayout(false);
this->物管费用BindingNavigator->PerformLayout();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->物管费用DataGridView))->EndInit();
this->ResumeLayout(false);
this->PerformLayout();
}
#pragma endregion
public:String^ MySQLConnectionString;
private: System::Void ManageRegisterForm_Load(System::Object^ sender, System::EventArgs^ e)
{
for (int i = 2006; i <= 2030; i++)
{
this->计费年份ToolStripComboBox->Items->Add(i.ToString());
}
for (int i = 1; i <= 12; i++)
{
this->计费月份ToolStripComboBox->Items->Add(i.ToString());
}
String^ MySQL = "SELECT * FROM [楼栋信息]";
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
System::Data::DataTable^ MyTable = gcnew System::Data::DataTable();
SqlDataAdapter^ MyAdapter = gcnew SqlDataAdapter(MySQL, MyConnection);
MyAdapter->Fill(MyTable);
for each (System::Data::DataRow^ MyRow in MyTable->Rows)
{
this->楼栋名称ToolStripComboBox->Items->Add(MyRow["楼栋名称"]->ToString());
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
}
private: System::Void 物管费用BindingNavigatorSaveItem_Click(System::Object^ sender, System::EventArgs^ e)
{
this->Validate();
this->物管费用BindingSource->EndEdit();
this->物管费用TableAdapter->Update(this->DBCommunityDataSet->物管费用);
}
private: System::Void 查询ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e)
{
try
{
this->物管费用TableAdapter->Fill(this->DBCommunityDataSet->物管费用, 楼栋名称ToolStripComboBox->Text, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费年份ToolStripComboBox->Text,System::Int32::typeid)))), System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费月份ToolStripComboBox->Text,System::Int32::typeid)))),"正在登记");
}
catch (System::Exception^ ex)
{
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
private: System::Void 新增ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e)
{//新增物管费用信息
String^ MyAddInfo = "现在将新增指定月份的物业管理费数据，是否继续？";
if (MessageBox::Show(MyAddInfo, "信息提示", MessageBoxButtons::YesNo, MessageBoxIcon::Question) == System::Windows::Forms::DialogResult::No)
{
return;
}
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
String^ MySQL = "Select Count(*) From 物管费用 WHERE 计费年份=" + this->计费年份ToolStripComboBox->Text + " AND 计费月份=" + this->计费月份ToolStripComboBox->Text + " AND 楼栋名称='" + this->楼栋名称ToolStripComboBox->Text + "'";
SqlCommand^ MyCommand = MyConnection->CreateCommand();
MyCommand->CommandText = MySQL;
String^ MyCount = MyCommand->ExecuteScalar()->ToString();
if (Convert::ToInt16(MyCount) == 0)
{//插入新月份的物管费用基本信息
MySQL = "INSERT INTO 物管费用 (楼栋名称,业主编号,业主姓名,建筑面积,套内面积) SELECT 楼栋名称,业主编号,业主姓名,建筑面积,套内面积 FROM 业主信息 WHERE (业主编号 NOT IN (SELECT 业主编号 FROM 迁出信息)) AND (楼栋名称='" + this->楼栋名称ToolStripComboBox->Text + "')";
MyCommand->CommandText = MySQL;
MyCommand->ExecuteNonQuery();
MySQL = "UPDATE 物管费用 SET 登记标志='正在登记',计费年份=" + this->计费年份ToolStripComboBox->Text + ",计费月份=" + this->计费月份ToolStripComboBox->Text + " WHERE 登记标志 IS NULL";
MyCommand->CommandText = MySQL;
MyCommand->ExecuteNonQuery();
int MyLastMonth = Convert::ToInt16(this->计费月份ToolStripComboBox->Text) - 1;
int MyLastYear = Convert::ToInt16(this->计费年份ToolStripComboBox->Text);
if (MyLastMonth == 0)
{
MyLastMonth = 12;
MyLastYear = Convert::ToInt16(this->计费年份ToolStripComboBox->Text) - 1;
}
//将上月计费单价作为新月物管费用计费单价
MySQL = "Select 业主编号,计费单价 FROM 物管费用 WHERE 计费年份=" + MyLastYear.ToString() + " AND 计费月份=" + MyLastMonth.ToString() + " AND 楼栋名称='" + this->楼栋名称ToolStripComboBox->Text + "' AND 登记标志='完成登记'";
System::Data::DataTable^ MyComputeTable = gcnew System::Data::DataTable();
SqlDataAdapter^ MyAdatper = gcnew SqlDataAdapter(MySQL, MyConnection);
MyAdatper->Fill(MyComputeTable);
for each (System::Data::DataRow^ MyRow in MyComputeTable->Rows)
{
String^ My业主编号 = MyRow[0]->ToString();
String^ My计费单价 = MyRow[1]->ToString();
MySQL = "UPDATE 物管费用 SET 计费单价=" + My计费单价 + " WHERE 计费年份=" + this->计费年份ToolStripComboBox->Text + " AND 计费月份=" + this->计费月份ToolStripComboBox->Text + " AND 楼栋名称='" + this->楼栋名称ToolStripComboBox->Text + "' AND 业主编号='" + My业主编号 + "'";
MyCommand->CommandText = MySQL;
MyCommand->ExecuteNonQuery();
}
}
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
try
{
this->物管费用TableAdapter->Fill(this->DBCommunityDataSet->物管费用, 楼栋名称ToolStripComboBox->Text, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费年份ToolStripComboBox->Text,System::Int32::typeid)))), System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费月份ToolStripComboBox->Text,System::Int32::typeid)))),"正在登记");
}
catch (System::Exception^ ex)
{
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
private: System::Void 登记ToolStripButton_Click(System::Object^ sender, System::EventArgs^ e)
{//登记物管费用信息
String^ MyRegInfo = "现在将登记指定月份的物业管理费数据，是否继续？";
if (MessageBox::Show(MyRegInfo, "信息提示", MessageBoxButtons::YesNo, MessageBoxIcon::Question) == System::Windows::Forms::DialogResult::No)
{
return;
}
SqlConnection^ MyConnection = gcnew SqlConnection(MySQLConnectionString);
MyConnection->Open();
String^ MySQL = "UPDATE 物管费用 SET 登记标志='完成登记',费用状态='未交费' WHERE 计费年份=" + 计费年份ToolStripComboBox->Text + " AND 计费月份=" + 计费月份ToolStripComboBox->Text + " AND 楼栋名称='" + 楼栋名称ToolStripComboBox->Text + "'";
SqlCommand^ MyCommand = MyConnection->CreateCommand();
MyCommand->CommandText = MySQL;
MyCommand->ExecuteNonQuery();
if (MyConnection->State == ConnectionState::Open)
{
MyConnection->Close();
}
try
{
this->物管费用TableAdapter->Fill(this->DBCommunityDataSet->物管费用, 楼栋名称ToolStripComboBox->Text, System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费年份ToolStripComboBox->Text,System::Int32::typeid)))), System::Nullable<System::Int32 >((*cli::safe_cast<System::Int32^>(System::Convert::ChangeType(计费月份ToolStripComboBox->Text,System::Int32::typeid)))),"正在登记");
}
catch (System::Exception^ ex)
{
System::Windows::Forms::MessageBox::Show(ex->Message);
}
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -