leibedit.pas

这个工资管理系统是我今年的毕业设计

unit leibedit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGridEh, ExtCtrls, DB, Buttons, ADODB;

type
  TForm35 = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    DBGridEh1: TDBGridEh;
    Label1: TLabel;
    DataSource1: TDataSource;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    ADOQuery1: TADOQuery;
    procedure FormPaint(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure DBGridEh1CellClick(Column: TColumnEh);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form35: TForm35;

implementation
uses login,lb,jbxishowall,ygxxedit;
{$R *.dfm}

procedure TForm35.FormPaint(Sender: TObject);
begin
canvas.Pen.Color:=clteal;
canvas.Rectangle(panel2.Left-1,panel2.Top-1,panel2.Left+panel2.Width+1,panel2.Top+panel2.Height+1);
canvas.Rectangle(speedbutton1.Left-1,speedbutton1.Top-1,speedbutton1.Left+speedbutton1.Width+1,speedbutton1.Top+speedbutton1.Height+1);
canvas.Rectangle(speedbutton2.Left-1,speedbutton2.Top-1,speedbutton2.Left+speedbutton2.Width+1,speedbutton2.Top+speedbutton2.Height+1);
canvas.Rectangle(speedbutton3.Left-1,speedbutton3.Top-1,speedbutton3.Left+speedbutton3.Width+1,speedbutton3.Top+speedbutton3.Height+1);
end;

procedure TForm35.SpeedButton2Click(Sender: TObject);
begin
close;
end;

procedure TForm35.SpeedButton1Click(Sender: TObject);
begin
if application.MessageBox('你确认要删除该项数据吗？','系统提示',mb_YesNo OR mb_Defbutton2 OR mb_iconstop or MB_applmodal)=idyes then
begin
with ADOQuery1 do
begin
try
delete;
showmessage('数据已删除！删除成功！！');
except
cancel;
showmessage('数据删除失败！');
end;
end;
form7.OnShow(self);
if assigned(ygshowall) then ygshowall.OnShow(self);
if assigned(form38) then form38.OnShow(self);
end;

end;

procedure TForm35.SpeedButton3Click(Sender: TObject);
begin
with ADOQuery1 do
begin
try
edit;
fieldbyname('类别代码').AsString:=edit1.Text;
fieldbyname('类别名称').AsString:=edit2.Text;
post;
showmessage('数据修改成功！');
except
cancel;
showmessage('数据修改失败！');
end;
end;
form7.OnShow(self);
if assigned(ygshowall) then ygshowall.OnShow(self);
if assigned(form38) then form38.OnShow(self);
end;

procedure TForm35.FormShow(Sender: TObject);
begin
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from leib');
adoquery1.Open;
edit1.Text:=ADOQuery1.FieldValues['类别代码'];
edit2.Text:=ADOQuery1.FieldValues['类别名称'];
end;

procedure TForm35.DBGridEh1CellClick(Column: TColumnEh);
begin
edit1.Text:=ADOQuery1.FieldValues['类别代码'];
edit2.Text:=ADOQuery1.FieldValues['类别名称'];
end;

procedure TForm35.FormClose(Sender: TObject; var Action: TCloseAction);
begin
adoquery1.Close;
end;

end.