📄 xiugaimima.h
字号:
//
this->oleDbDataAdapter2->DeleteCommand = this->oleDbDeleteCommand2;
this->oleDbDataAdapter2->InsertCommand = this->oleDbInsertCommand2;
this->oleDbDataAdapter2->SelectCommand = this->oleDbSelectCommand2;
System::Data::Common::DataTableMapping* __mcTemp__1[] = new System::Data::Common::DataTableMapping*[1];
System::Data::Common::DataColumnMapping* __mcTemp__2[] = new System::Data::Common::DataColumnMapping*[8];
__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"NID", S"NID");
__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"NAME", S"NAME");
__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"AGE", S"AGE");
__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"SEX", S"SEX");
__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"COMPANY", S"COMPANY");
__mcTemp__2[5] = new System::Data::Common::DataColumnMapping(S"PASSWORD", S"PASSWORD");
__mcTemp__2[6] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
__mcTemp__2[7] = new System::Data::Common::DataColumnMapping(S"ADDS", S"ADDS");
__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"用户表", __mcTemp__2);
this->oleDbDataAdapter2->TableMappings->AddRange(__mcTemp__1);
this->oleDbDataAdapter2->UpdateCommand = this->oleDbUpdateCommand2;
//
// oleDbDeleteCommand2
//
this->oleDbDeleteCommand2->CommandText = S"DELETE FROM 用户表 WHERE (NID = \?)";
this->oleDbDeleteCommand2->Connection = this->oleDbConnection1;
this->oleDbDeleteCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
//
// oleDbConnection1
//
this->oleDbConnection1->ConnectionString = S"Integrated Security=SSPI;Packet Size=4096;Data Source=4B2E371A2A9F47E;Tag with co"
S"lumn collation when possible=False;Initial Catalog=超市收银数据库;Use Procedure for Pre"
S"pare=1;Auto Translate=True;Persist Security Info=False;Provider=\"SQLOLEDB.1\";Wor"
S"kstation ID=4B2E371A2A9F47E;Use Encryption for Data=False";
//
// oleDbInsertCommand2
//
this->oleDbInsertCommand2->CommandText = S"INSERT INTO 用户表(NID, NAME, AGE, SEX, COMPANY, PASSWORD, STATUS, ADDS) VALUES (\?, "
S"\?, \?, \?, \?, \?, \?, \?)";
this->oleDbInsertCommand2->Connection = this->oleDbConnection1;
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"AGE", System::Data::OleDb::OleDbType::Integer, 4, S"AGE"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 10, S"SEX"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"PASSWORD", System::Data::OleDb::OleDbType::Integer, 4, S"PASSWORD"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"ADDS", System::Data::OleDb::OleDbType::VarChar, 50, S"ADDS"));
//
// oleDbSelectCommand2
//
this->oleDbSelectCommand2->CommandText = S"SELECT NID, NAME, AGE, SEX, COMPANY, PASSWORD, STATUS, ADDS FROM 用户表";
this->oleDbSelectCommand2->Connection = this->oleDbConnection1;
//
// oleDbUpdateCommand2
//
this->oleDbUpdateCommand2->CommandText = S"UPDATE 用户表 SET NID = \?, NAME = \?, AGE = \?, SEX = \?, COMPANY = \?, PASSWORD = \?, ST"
S"ATUS = \?, ADDS = \? WHERE (NID = \?)";
this->oleDbUpdateCommand2->Connection = this->oleDbConnection1;
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"AGE", System::Data::OleDb::OleDbType::Integer, 4, S"AGE"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 10, S"SEX"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"PASSWORD", System::Data::OleDb::OleDbType::Integer, 4, S"PASSWORD"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"ADDS", System::Data::OleDb::OleDbType::VarChar, 50, S"ADDS"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
//
// dataGrid1
//
this->dataGrid1->DataMember = S"";
this->dataGrid1->HeaderForeColor = System::Drawing::SystemColors::ControlText;
this->dataGrid1->Location = System::Drawing::Point(108, 83);
this->dataGrid1->Name = S"dataGrid1";
this->dataGrid1->TabIndex = 26;
//
// oleDbDataAdapter1
//
this->oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;
this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
System::Data::Common::DataTableMapping* __mcTemp__3[] = new System::Data::Common::DataTableMapping*[1];
System::Data::Common::DataColumnMapping* __mcTemp__4[] = new System::Data::Common::DataColumnMapping*[7];
__mcTemp__4[0] = new System::Data::Common::DataColumnMapping(S"NID", S"NID");
__mcTemp__4[1] = new System::Data::Common::DataColumnMapping(S"NAME", S"NAME");
__mcTemp__4[2] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
__mcTemp__4[3] = new System::Data::Common::DataColumnMapping(S"SEX", S"SEX");
__mcTemp__4[4] = new System::Data::Common::DataColumnMapping(S"COMPANY", S"COMPANY");
__mcTemp__4[5] = new System::Data::Common::DataColumnMapping(S"UPWORK", S"UPWORK");
__mcTemp__4[6] = new System::Data::Common::DataColumnMapping(S"DATACHA", S"DATACHA");
__mcTemp__3[0] = new System::Data::Common::DataTableMapping(S"Table", S"登入表", __mcTemp__4);
this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__3);
this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
//
// oleDbDeleteCommand1
//
this->oleDbDeleteCommand1->CommandText = S"DELETE FROM 登入表 WHERE (NID = \?)";
this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
//
// oleDbInsertCommand1
//
this->oleDbInsertCommand1->CommandText = S"INSERT INTO 登入表(NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA) VALUES (\?, \?, \?"
S", \?, \?, \?, \?)";
this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
//
// oleDbSelectCommand1
//
this->oleDbSelectCommand1->CommandText = S"SELECT NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA FROM 登入表";
this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
//
// oleDbUpdateCommand1
//
this->oleDbUpdateCommand1->CommandText = S"UPDATE 登入表 SET NID = \?, NAME = \?, STATUS = \?, SEX = \?, COMPANY = \?, UPWORK = \?, D"
S"ATACHA = \? WHERE (NID = \?)";
this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
//
// textBox1
//
this->textBox1->Location = System::Drawing::Point(244, 99);
this->textBox1->Name = S"textBox1";
this->textBox1->TabIndex = 27;
this->textBox1->Text = S"";
//
// xiugaimima
//
this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
this->ClientSize = System::Drawing::Size(384, 270);
this->Controls->Add(this->groupBox1);
this->Controls->Add(this->dataGrid1);
this->Controls->Add(this->textBox1);
this->Name = S"xiugaimima";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;
this->Text = S"修改密码";
this->Load += new System::EventHandler(this, xiugaimima_Load);
this->groupBox1->ResumeLayout(false);
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dataGrid1))->EndInit();
this->ResumeLayout(false);
}
private: System::Void xiugaimima_Load(System::Object * sender, System::EventArgs * e)
{oleDbSelectCommand2->CommandText=String::Concat(S"select * from 登入表");
oleDbConnection1->Open();
oleDbSelectCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
DataTable *table1=new DataTable();
oleDbDataAdapter2->Fill(table1);
this->dataGrid1->DataSource=table1;
int nindex=dataGrid1->CurrentRowIndex;
DataTable *table2=__try_cast<DataTable*>(dataGrid1->DataSource);
DataRow * row=table2->Rows->Item[nindex];
String *WID=row->Item[0]->ToString();
this->label2->Text=row->Item[0]->ToString();
}
private: System::Void button1_Click(System::Object * sender, System::EventArgs * e)
{ String *NID=this->label2->Text->Trim();
String *PASSWORD=this->textBox3->Text->Trim();
String *NEWPW1=this->textBox4->Text->Trim();
String *NEWPW2=this->textBox5->Text->Trim();
oleDbSelectCommand2->CommandText=String::Concat(S"select PASSWORD from 用户表 where ",S"NID='",NID,S"'" );
oleDbConnection1->Open();
oleDbSelectCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
DataTable *table3=new DataTable();
oleDbDataAdapter2->Fill(table3);
this->dataGrid1->DataSource=table3;
int nindex=dataGrid1->CurrentRowIndex;
DataTable *table4=__try_cast<DataTable*>(dataGrid1->DataSource);
DataRow * row=table4->Rows->Item[nindex];
String *pw=row->Item[0]->ToString();
if(NEWPW1->CompareTo(NEWPW2)!=0)
{ MessageBox::Show("确认新密码不一致");
}
else{
if(pw->CompareTo(PASSWORD)!=0)
{ MessageBox::Show("旧密码错误");
}
else{
oleDbUpdateCommand2->CommandText=String::Concat(S"update 用户表 set ",S"PASSWORD='",NEWPW1,S"'",S" where NID='",NID,S"'" );
oleDbConnection1->Open();
oleDbUpdateCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
DataTable *table10=new DataTable();
oleDbDataAdapter2->Fill(table10);
MessageBox::Show("密码修改成功");
this->Close();
}
}
}
private: System::Void button2_Click(System::Object * sender, System::EventArgs * e)
{this->textBox3->Text="";
this->textBox4->Text="";
this->textBox5->Text="";
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -