unit Login; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, jpeg, ExtCtrls, StdCtrls, Buttons, DB, ADODB; type TLoginForm = class(TForm) Image1: TImage; LoginBtn: TBitBtn; ADOConnection1: TADOConnection; LoginQuery: TADOQuery; BuyApplyTable: TADOTable; BuyCheckTable: TADOTable; BuyTable: TADOTable; DiscardTable: TADOTable; EquipTable: TADOTable; InTable: TADOTable; LabTable: TADOTable; LabManagerTable: TADOTable; MaintainApplyTable: TADOTable; MaintainCheckTable: TADOTable; MaintainTable: TADOTable; OutTable: TADOTable; PropertyTable: TADOTable; StoreTable: TADOTable; StoreManagerTable: TADOTable; UserTable: TADOTable; BuyApplyDS: TDataSource; BuyCheckDS: TDataSource; BuyDS: TDataSource; DiscardDS: TDataSource; EquipDS: TDataSource; InDS: TDataSource; LabManagerDS: TDataSource; LabDS: TDataSource; MaintainApplyDS: TDataSource; MaintainCheckDS: TDataSource; MaintainDS: TDataSource; OutDS: TDataSource; PropertyDS: TDataSource; StoreManagerDS: TDataSource; StoreDS: TDataSource; UserDS: TDataSource; ComboBox1: TComboBox; usernameEdit: TEdit; passwordEdit: TEdit; ResetBtn: TButton; procedure LoginBtnClick(Sender: TObject); private { Private declarations } public { Public declarations } end; var LoginForm: TLoginForm; implementation uses index; {$R *.dfm} procedure TLoginForm.LoginBtnClick(Sender: TObject); var position:string; name:string; password:string; begin position:=trim(ComboBox1.SelText); name:=trim(usernameEdit.Text); password:=trim(passwordEdit.Text); LoginQuery.Close; LoginQuery.SQL.Clear; LoginQuery.SQL.Add('select * from UserInfo where uId='''+name+''' and uPasswd='''+password+''' and uPosition='''+position+''''); LoginQuery.Open; if(LoginQuery.RecordCount > 0)then begin if position='系统管理员' then begin LoginForm.Hide; mainForm.Show; mainForm.PageControl1.TabSheet2.TabVisible:=False; mainForm.PageControl1.TabSheet3.TabVisible:=False; mainForm.PageControl1.TabSheet4.TabVisible:=False; mainForm.PageControl1.TabSheet5.TabVisible:=False; mainForm.PageControl1.TabSheet6.TabVisible:=False; mainForm.PageControl1.TabSheet7.TabVisible:=False; end else if position='仓库管理员' then begin LoginForm.Hide; mainForm.Show; mainForm.PageControl1.TabSheet1.TabVisible:=False; mainForm.PageControl1.TabSheet5.PageControl2.TabSheet10.TabVisible:=False; mainForm.PageControl1.TabSheet6.TabVisible:=False; end else if position='实验室管理员' then begin LoginForm.Hide; mainForm.Show; mainForm.PageControl1.TabSheet1.TabVisible:=False; mainForm.PageControl1.TabSheet2.TabVisible:=False; mainForm.PageControl1.TabSheet3.TabVisible:=False; mainForm.PageControl1.TabSheet5.PageControl2.TabSheet9.TabVisible:=False; mainForm.PageControl1.TabSheet6.TabVisible:=False; end else if position='购买登记员' then begin LoginForm.Hide; mainForm.Show; mainForm.PageControl1.TabSheet1.TabVisible:=False; mainForm.PageControl1.TabSheet2.TabVisible:=False; mainForm.PageControl1.TabSheet3.TabVisible:=False; mainForm.PageControl1.TabSheet5.TabVisible:=False; end else begin LoginForm.Hide; mainForm.Show; mainForm.PageControl1.TabSheet1.TabVisible:=False; mainForm.PageControl1.TabSheet2.TabVisible:=False; mainForm.PageControl1.TabSheet3.TabVisible:=False; mainForm.PageControl1.TabSheet4.TabVisible:=False; mainForm.PageControl1.TabSheet5.TabVisible:=False; mainForm.PageControl1.TabSheet7.TabVisible:=False; end; end else ShowMessage('登陆错误'); end; end.
2,498
社区成员
88,446
社区内容
加载中
试试用AI创作助手写篇文章吧