📄 manage.cpp
字号:
if(!ADOQuery1->IsEmpty())
{
if(suiEdit30->Text==suiEdit31->Text)
{
if(suiEdit30->Text==ADOQuery1->FieldByName("adminpasswd")->Value)
{
if(MessageBox(NULL,"请仔细核对信息，再继续！","确认提示",MB_OKCANCEL)==IDOK)
{
String sex;
if(suiRadioButton3->Checked==true)
sex="男";
else
sex="女";
String sa;
if(suiCheckBox1->Checked==true)
sa="1";
else
sa="0";
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("Update admin set adminname='"+suiEdit32->Text+"',adminsex='"+sex+"',superadmin='"+sa+"' where adminno='"+suiEdit29->Text+"'");
ADOQuery1->ExecSQL();
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
MessageBox(NULL,"信息更改成功！","成功提示",MB_ICONINFORMATION);
}
else
{
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
}
}
else
{
MessageBox(NULL,"对不起，您输入的密码不正确！","错误提示",MB_ICONERROR);
suiEdit30->Text="";
suiEdit31->Text="";
}
}
else
{
MessageBox(NULL,"对不起，您两次输入的密码不一致！","错误提示",MB_ICONERROR);
suiEdit30->Text="";
suiEdit31->Text="";
}
}
else
{
MessageBox(NULL,"对不起！该业务员不存在。","错误提示",MB_ICONHAND);
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
}
}
}
//---------------------------------------------------------------------------
void __fastcall TForm2::suiButton16Click(TObject *Sender)
{
if(suiEdit29->Text!=""&&suiEdit30->Text!=""&&suiEdit31->Text!=""&&suiEdit32->Text!="")
{
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from admin where adminno='"+suiEdit29->Text+"'");
ADOQuery1->Open();
if(ADOQuery1->IsEmpty())
{
if(suiEdit30->Text==suiEdit31->Text)
{
if(MessageBox(NULL,"请仔细核对信息，再继续！","确认提示",MB_OKCANCEL)==IDOK)
{
String sex;
if(suiRadioButton3->Checked==true)
sex="男";
else
sex="女";
String sa;
if(suiCheckBox1->Checked==true)
sa="1";
else
sa="0";
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("Insert into admin(adminno,adminpasswd,adminname,adminsex,superadmin) values('"+suiEdit29->Text+"','"+suiEdit30->Text+"','"+suiEdit32->Text+"','"+sex+"','"+sa+"')");
ADOQuery1->ExecSQL();
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
MessageBox(NULL,"业务员添加成功！","成功提示",MB_ICONINFORMATION);
}
else
{
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
}
}
else
{
MessageBox(NULL,"对不起，您两次输入的密码不一致！","错误提示",MB_ICONERROR);
suiEdit30->Text="";
suiEdit31->Text="";
}
}
else
{
MessageBox(NULL,"对不起，该业务员已经存在！","错误提示",MB_ICONERROR);
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
}
}
}
//---------------------------------------------------------------------------
void __fastcall TForm2::suiButton17Click(TObject *Sender)
{
if(suiEdit29->Text!="")
{
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from admin where adminno='"+suiEdit29->Text+"'");
ADOQuery1->Open();
if(!ADOQuery1->IsEmpty())
{
suiEdit32->Text=ADOQuery1->FieldByName("adminname")->Value;
String sex=ADOQuery1->FieldByName("adminsex")->Value;
if(sex=="男")
suiRadioButton3->Checked=true;
else
suiRadioButton4->Checked=true;
String sa=ADOQuery1->FieldByName("superadmin")->Value;
if(sa=="1")
suiCheckBox1->Checked=true;
else
suiCheckBox1->Checked=false;
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select * from manage where adminno='"+suiEdit29->Text+"'");
ADOQuery1->Open();
if(ADOQuery1->IsEmpty())
{
if(MessageBox(NULL,"请仔细核对信息，再继续！","确认提示",MB_OKCANCEL)==IDOK)
{
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("delete from admin where adminno='"+suiEdit29->Text+"'");
ADOQuery1->ExecSQL();
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
MessageBox(NULL,"业务员删除成功！","成功提示",MB_ICONINFORMATION);
}
else
{
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
}
}
else
{
MessageBox(NULL,"对不起，该业务员存在业务关系，不能删除！","错误提示",MB_ICONERROR);
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
suiEdit32->Text="";
suiRadioButton3->Checked=true;
suiCheckBox1->Checked=false;
}
}
else
{
MessageBox(NULL,"对不起！该业务员不存在。","错误提示",MB_ICONHAND);
suiEdit29->Text="";
suiEdit30->Text="";
suiEdit31->Text="";
}
}
}
//---------------------------------------------------------------------------
void __fastcall TForm2::suiButton1Click(TObject *Sender)
{
suiEdit3->Text="";
suiEdit4->Text="";
suiEdit5->Text="";
suiEdit6->Text="";
suiEdit7->Text="";
suiEdit8->Text="";
AdvStringGrid1->Rows[1]->Clear();
suiEdit9->Text="";
suiRadioButton1->Checked=true;
suiEdit10->Text="";
suiEdit11->Text="";
suiEdit9->Enabled=false;
suiRadioButton1->Enabled=false;
suiRadioButton2->Enabled=false;
suiEdit11->Enabled=false;
suiComboBox2->Enabled=false;
suiEdit12->Enabled=false;
suiComboBox1->Enabled=false;
suiEdit13->Enabled=false;
suiEdit12->Text="";
suiEdit13->Text="";
suiComboBox1->Text="";
suiComboBox2->Text="";
AdvStringGrid2->Rows[1]->Clear();
suiEdit14->Text="";
suiEdit15->Text="";
suiEdit16->Text="";
Label22->Font->Color=clWindowText;
Label23->Font->Color=clWindowText;
Label24->Font->Color=clWindowText;
Label25->Font->Color=clWindowText;
suiEdit17->Enabled=false;
suiEdit18->Enabled=false;
suiEdit19->Enabled=false;
suiEdit20->Enabled=false;
suiComboBox3->Text="";
suiEdit17->Text="";
suiEdit18->Text="";
suiEdit19->Text="";
suiEdit20->Text="";
suiEdit21->Text="";
suiEdit22->Text="";
suiEdit23->Text="";
suiEdit24->Text="";
suiEdit25->Text="";
suiEdit26->Text="";
suiEdit27->Text="";
suiEdit28->Text="";
for(int i=1;i<=AdvStringGrid3->RowCount;i++)
{
AdvStringGrid3->Rows[i]->Clear();
}
AdvStringGrid3->RowCount=2;
suiComboBox4->Text="";
suiEdit37->Text="";
suiEdit38->Text="";
suiEdit39->Text="";
suiEdit40->Text="";
suiEdit41->Text="";
suiEdit42->Text="";
suiEdit43->Text="";
suiEdit44->Text="";
suiEdit45->Text="";
suiEdit46->Text="";
suiEdit47->Text="";
suiEdit48->Text="";
suiEdit49->Text="";
Label39->Font->Color=clWindowText;
Label45->Font->Color=clWindowText;
Label46->Font->Color=clWindowText;
suiEdit37->Enabled=false;
suiEdit38->Enabled=false;
suiEdit39->Enabled=false;
for(int i=1;i<=AdvStringGrid4->RowCount;i++)
{
AdvStringGrid4->Rows[i]->Clea⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -