📄 form1.h
字号:
__mcTemp__4[6] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
__mcTemp__4[7] = new System::Data::Common::DataColumnMapping(S"ADDS", S"ADDS");
__mcTemp__3[0] = new System::Data::Common::DataTableMapping(S"Table", S"用户表", __mcTemp__4);
this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__3);
this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
//
// oleDbUpdateCommand1
//
this->oleDbUpdateCommand1->CommandText = S"UPDATE 用户表 SET NID = \?, NAME = \?, AGE = \?, SEX = \?, COMPANY = \?, PASSWORD = \?, ST"
S"ATUS = \?, ADDS = \? 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"AGE", System::Data::OleDb::OleDbType::Integer, 4, S"AGE"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 10, 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"PASSWORD", System::Data::OleDb::OleDbType::Integer, 4, S"PASSWORD"));
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"ADDS", System::Data::OleDb::OleDbType::VarChar, 50, S"ADDS"));
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));
//
// groupBox1
//
this->groupBox1->Controls->Add(this->button2);
this->groupBox1->Controls->Add(this->button1);
this->groupBox1->Controls->Add(this->textBox2);
this->groupBox1->Controls->Add(this->textBox1);
this->groupBox1->Controls->Add(this->label2);
this->groupBox1->Controls->Add(this->label1);
this->groupBox1->Location = System::Drawing::Point(32, 24);
this->groupBox1->Name = S"groupBox1";
this->groupBox1->Size = System::Drawing::Size(280, 192);
this->groupBox1->TabIndex = 4;
this->groupBox1->TabStop = false;
//
// button2
//
this->button2->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->button2->Location = System::Drawing::Point(152, 128);
this->button2->Name = S"button2";
this->button2->Size = System::Drawing::Size(75, 32);
this->button2->TabIndex = 5;
this->button2->Text = S"重置";
this->button2->Click += new System::EventHandler(this, button2_Click);
//
// button1
//
this->button1->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->button1->Location = System::Drawing::Point(56, 128);
this->button1->Name = S"button1";
this->button1->Size = System::Drawing::Size(75, 32);
this->button1->TabIndex = 4;
this->button1->Text = S"登入";
this->button1->Click += new System::EventHandler(this, button1_Click);
//
// textBox2
//
this->textBox2->Location = System::Drawing::Point(112, 72);
this->textBox2->Name = S"textBox2";
this->textBox2->PasswordChar = '*';
this->textBox2->Size = System::Drawing::Size(120, 21);
this->textBox2->TabIndex = 3;
this->textBox2->Text = S"";
//
// textBox1
//
this->textBox1->Location = System::Drawing::Point(112, 32);
this->textBox1->Name = S"textBox1";
this->textBox1->Size = System::Drawing::Size(120, 21);
this->textBox1->TabIndex = 2;
this->textBox1->Text = S"";
//
// label2
//
this->label2->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label2->Location = System::Drawing::Point(40, 32);
this->label2->Name = S"label2";
this->label2->Size = System::Drawing::Size(64, 23);
this->label2->TabIndex = 1;
this->label2->Text = S"用户ID：";
this->label2->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label1
//
this->label1->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label1->Location = System::Drawing::Point(24, 72);
this->label1->Name = S"label1";
this->label1->Size = System::Drawing::Size(80, 23);
this->label1->TabIndex = 0;
this->label1->Text = S"用户密码：";
this->label1->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// Form1
//
this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
this->ClientSize = System::Drawing::Size(336, 238);
this->Controls->Add(this->groupBox1);
this->Controls->Add(this->dataGrid1);
this->Name = S"Form1";
this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;
this->Text = S"登陆界面";
(__try_cast<System::ComponentModel::ISupportInitialize * >(this->dataGrid1))->EndInit();
this->groupBox1->ResumeLayout(false);
this->ResumeLayout(false);
}
private: System::Void button1_Click(System::Object * sender, System::EventArgs * e)
{ String *YID1=this->textBox1->Text->Trim();
String *PWN=this->textBox2->Text->Trim();
oleDbSelectCommand1->CommandText=String::Concat(S"select * from 用户表 where ",S"NID='",YID1,S"'" );
oleDbConnection1->Open();
oleDbSelectCommand1->ExecuteNonQuery();
oleDbConnection1->Close();
DataTable *table1=new DataTable();
oleDbDataAdapter1->Fill(table1);
this->dataGrid1->DataSource=table1;
int nindex=dataGrid1->CurrentRowIndex;
if(nindex<0) {MessageBox::Show("请正确输入用户名和密码");}
else{
DataTable *table2=__try_cast<DataTable*>(dataGrid1->DataSource);
DataRow * row=table2->Rows->Item[nindex];
String *YID=row->Item[0]->ToString();
String *PW=row->Item[5]->ToString();
String *YNAME=row->Item[1]->ToString();
String *STATUS=row->Item[6]->ToString();
String *SEX=row->Item[3]->ToString();
String *COMPANY=row->Item[4]->ToString();
if(PW->CompareTo(PWN)==0) {
oleDbDeleteCommand2->CommandText=String::Concat(S"delete from 登入表 ");
oleDbConnection1->Open();
oleDbDeleteCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
DateTime dtime=System::DateTime::Now;;
String *UPWORK=dtime.ToShortTimeString();
DateTime rtime=System::DateTime::Now;;
String *DATACHA=dtime.ToShortDateString();
oleDbInsertCommand2->CommandText=String::Concat(S"insert into 登入表 (", S"NID,NAME,STATUS,SEX,COMPANY,UPWORK,DATACHA) values ('", YID, S"','",YNAME,S"','",STATUS,S"','",SEX,S"','",COMPANY,S"','",UPWORK,S"','",DATACHA,S"')" );
oleDbConnection1->Open();
oleDbInsertCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
oleDbSelectCommand2->CommandText=String::Concat(S"select * from 登入表");
oleDbConnection1->Open();
oleDbSelectCommand2->ExecuteNonQuery();
oleDbConnection1->Close();
DataTable *table3=new DataTable();
oleDbDataAdapter2->Fill(table3);
this->dataGrid1->DataSource=table3;
int nindex1=dataGrid1->CurrentRowIndex;
DataTable *table4=__try_cast<DataTable*>(dataGrid1->DataSource);
DataRow * row1=table4->Rows->Item[nindex1];
String *BM=row1->Item[4]->ToString()->Trim();
if(BM->CompareTo("销售员")==0){
jiemian *child=new jiemian();
child->menuItem6->Enabled=true;
child->menuItem7->Enabled=true;
child->menuItem8->Enabled=true;
child->menuItem9->Enabled=true;
child->ShowDialog();}
if(BM->CompareTo("采购员")==0){
jiemian *child=new jiemian();
child->menuItem2->Enabled=true;
child->menuItem19->Enabled=true;
child->menuItem17->Enabled=true;
child->menuItem16->Enabled=true;
child->ShowDialog();}
if(BM->CompareTo("管理员")==0){
jiemian *child=new jiemian();
child->menuItem21->Enabled=true;
child->menuItem22->Enabled=true;
child->menuItem8->Enabled=true;
child->menuItem9->Enabled=true;
child->menuItem6->Enabled=true;
child->menuItem13->Enabled=true;
child->menuItem14->Enabled=true;
child->menuItem27->Enabled=true;
child->menuItem7->Enabled=true;
child->menuItem2->Enabled=true;
child->menuItem19->Enabled=true;
child->menuItem17->Enabled=true;
child->menuItem16->Enabled=true;
child->ShowDialog();}
this->Close();
}
else{ MessageBox::Show("请正确输入用户名和密码");
}
}
}
private: System::Void button2_Click(System::Object * sender, System::EventArgs * e)
{ this->textBox1->Text="";
this->textBox2->Text="";
}
};
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -