usergl.pas

这是我在去年年底利用业余时间做的一个鞋塑企业的计件工资系统。由于本人技术有限

unit UserGl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, DB, ADODB, Grids, DBGrids, Buttons, Mask,
  DBCtrls, ComCtrls, ToolWin,DateUtils;

type
  TfrmUserGL = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label5: TLabel;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    edtID: TEdit;
    edtName: TEdit;
    edtPass1: TEdit;
    edtPass2: TEdit;
    ToolBar1: TToolBar;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    ToolButton9: TToolButton;
    ToolButton1: TToolButton;
    ToolButton10: TToolButton;
    ToolButton13: TToolButton;
    ToolButton11: TToolButton;
    CoolBar1: TCoolBar;
    CheckBox1: TCheckBox;
    Label4: TLabel;
    dtDate: TDateTimePicker;
    Panel1: TPanel;
    Panel2: TPanel;
    Image1: TImage;
    Panel3: TPanel;
    BitBtn1: TBitBtn;
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton8Click(Sender: TObject);
    procedure ToolButton9Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure ToolButton11Click(Sender: TObject);
    Procedure PassToText();
    procedure FormShow(Sender: TObject);
    procedure Image1DblClick(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);

  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmUserGL: TfrmUserGL;

implementation

{$R *.dfm}
uses
  DataCenter,Login,Main;
procedure TfrmUserGL.ToolButton2Click(Sender: TObject);
begin
  dmData.qryUserGL.First;
  PassToText();
end;

procedure TfrmUserGL.ToolButton3Click(Sender: TObject);
begin
  dmData.qryUserGL.Prior;
  PassToText();
end;

procedure TfrmUserGL.ToolButton4Click(Sender: TObject);
begin
  dmData.qryUserGL.Next;
  PassToText();
end;

procedure TfrmUserGL.ToolButton5Click(Sender: TObject);
begin
  dmData.qryUserGL.Last;
  PassToText();
end;

procedure TfrmUserGL.ToolButton8Click(Sender: TObject);
begin
  dmData.qryUserGL.Append;
  PassToText();
  edtID.SetFocus;
end;

procedure TfrmUserGL.PassToText();
begin
  edtID.Text:=dmData.qryUserGL.fieldByName('ID').AsString;
  edtName.Text:=dmData.qryUserGL.fieldByName('UserName').AsString;
  edtPass1.Text:=dmData.qryUserGL.fieldByName('Password').AsString;
  edtPass2.Text:=dmData.qryUserGL.fieldByName('Password').AsString;
  if (not dmData.qryUserGL.Eof) and (not dmData.qryUserGL.Bof) then
  begin
    if (Trim(edtID.text)=Trim(Login.frmLogin.Sys_UserID)) or (Trim(Login.frmLogin.Sys_UserID)='SUPE') then
    begin
       ToolButton9.Enabled:=True;
       ToolButton10.Enabled:=True;
    end else
    begin
       ToolButton9.Enabled:=False;
       ToolButton10.Enabled:=False;
    end;
  end;
end;

procedure TfrmUserGL.ToolButton9Click(Sender: TObject);
begin
  if not (dmData.qryUserGL.State in [dsInsert,dsEdit]) then
    dmData.qryUserGL.Edit;
  if (edtPass1.text=edtPass2.Text) and (edtPass1.Text<>'') then
  begin
    dmData.qryUserGL.Fields[0].AsString:=edtID.text;
    dmData.qryUserGL.Fields[1].AsString:=edtName.text;
    dmData.qryUserGL.Fields[2].AsString:=frmLogin.PassJM(trim(edtPass1.text));
    dmData.qryUserGL.UpdateBatch;
    ShowMessage('保存成功!');
  end else
  begin
    ShowMessage('密码不能为空或输入的两个密码不一致，请重新输入!');
    edtPass1.Text:='';
    edtPass2.Text:='';
    edtPass1.SetFocus;
  end;
end;

procedure TfrmUserGL.ToolButton1Click(Sender: TObject);
begin
  dmData.qryUserGL.CancelBatch;
  PassToText()
end;

procedure TfrmUserGL.ToolButton10Click(Sender: TObject);
begin
  if MessageDlg('你确定要删除此记录吗?',mtConfirmation,[mbYes, mbNo],0)=mrYes then
  begin
    dmData.qryUserGL.Delete;
    dmData.qryUserGL.UpdateBatch;
    PassToText();
  end;
end;

procedure TfrmUserGL.ToolButton11Click(Sender: TObject);
begin
  close;
end;

procedure TfrmUserGL.FormShow(Sender: TObject);
begin
  frmMain.ADOTable1.Close;
  frmMain.ADOTable1.Open;

  dmData.qryUserGL.Close;
  dmData.qryUserGL.SQL.Clear;
  dmData.qryUserGL.SQL.Add('select * from password');
  dmData.qryUserGL.Open;
  dmData.qryUserGL.Locate('ID',frmLogin.Sys_UserID,[]);
  PassToText();

end;

procedure TfrmUserGL.Image1DblClick(Sender: TObject);
begin
  if frmLogin.Sys_UserID='SUPE' then
  begin
    if InputBox('版权管理','请输入超级用户代码：','')=IntToStr(HourOf(Time)+MinuteOf(Time)) then
    begin
      try
        dtDate.Date:=StrToDate(frmLogin.PassMJ(frmMain.ADOTable1MatureDate.AsString));
      except
        showmessage('数据可能被人为更改!');
      end;
      Panel1.Visible:=Panel3.Visible;
      Panel3.Visible:=False;
    end;
    edtID.SetFocus;
  end;
end;

procedure TfrmUserGL.BitBtn1Click(Sender: TObject);
begin
  if Checkbox1.Checked then
    dtDate.Date:=StrToDate('2100-01-01');
  frmMain.ADOTable1.Edit;
  frmMain.ADOTable1MatureDate.AsString:=frmLogin.PassJM(Trim(DateToStr(dtDate.Date)));
  frmMain.ADOTable1.Post;
  frmMain.ADOTable1.UpdateBatch();
  close;

end;

procedure TfrmUserGL.DBGrid1CellClick(Column: TColumn);
begin
  PassToText();

end;

end.