gangwei.pas

档案管理系统,档案管理系统vb+access源代码+可执行文件+论文+开题报告+外文翻译..

unit GangWei;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ExtCtrls, ComCtrls, ToolWin, DB, DBTables,
  ImgList, Grids, DBGridEh;

type
  TForm4 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    Panel1: TPanel;
    BitBtn1: TBitBtn;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolBar2: TToolBar;
    ToolButton7: TToolButton;
    ToolButton8: TToolButton;
    ToolButton9: TToolButton;
    ToolButton10: TToolButton;
    ToolButton11: TToolButton;
    ToolBar3: TToolBar;
    ToolButton13: TToolButton;
    ToolButton14: TToolButton;
    ToolButton15: TToolButton;
    ToolButton16: TToolButton;
    ToolButton17: TToolButton;
    ToolBar4: TToolBar;
    ToolButton19: TToolButton;
    ToolButton20: TToolButton;
    ToolButton21: TToolButton;
    ToolButton22: TToolButton;
    ToolButton23: TToolButton;
    ImageList1: TImageList;
    Table1: TTable;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    Table2: TTable;
    DataSource3: TDataSource;
    Table3: TTable;
    DataSource4: TDataSource;
    Table4: TTable;
    DBGridEh1: TDBGridEh;
    DBGridEh2: TDBGridEh;
    DBGridEh3: TDBGridEh;
    DBGridEh4: TDBGridEh;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton7Click(Sender: TObject);
    procedure ToolButton8Click(Sender: TObject);
    procedure ToolButton9Click(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure ToolButton11Click(Sender: TObject);
    procedure ToolButton13Click(Sender: TObject);
    procedure ToolButton14Click(Sender: TObject);
    procedure ToolButton15Click(Sender: TObject);
    procedure ToolButton16Click(Sender: TObject);
    procedure ToolButton17Click(Sender: TObject);
    procedure ToolButton19Click(Sender: TObject);
    procedure ToolButton20Click(Sender: TObject);
    procedure ToolButton21Click(Sender: TObject);
    procedure ToolButton23Click(Sender: TObject);
    procedure ToolButton22Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.BitBtn1Click(Sender: TObject);
begin
  self.Close;
end;

procedure TForm4.FormCreate(Sender: TObject);
begin
  Table1.Active := True;
  Table2.Active := True;
  Table3.Active := True;
  Table4.Active := True;
end;

procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Table1.Active := False;
  Table2.Active := False;
  Table3.Active := False;
  Table4.Active := False;
end;

procedure TForm4.ToolButton1Click(Sender: TObject);
begin
  Table1.Append;
end;

procedure TForm4.ToolButton2Click(Sender: TObject);
begin
  Table1.Post;
  DBGridEh1.ReadOnly := True;
end;

procedure TForm4.ToolButton3Click(Sender: TObject);
begin
  Table1.Cancel;
end;

procedure TForm4.ToolButton4Click(Sender: TObject);
begin
  if Table1.RecordCount>0 Then
  try
    if application.MessageBox('确定要删除吗？','警告',MB_OKCANCEL +MB_ICONQUESTION)=idok Then
       Table1.Delete;
  except
       Table1.Cancel;
  end;
end;

procedure TForm4.ToolButton5Click(Sender: TObject);
Var
  FindZhiWei:String;
begin
  FindZhiWei := InPutBox('职位查询','请输入职位名称：','');
  if not Table1.Locate('ZhiWeiMC',FindZhiWei,[]) Then
  Application.MessageBox('没有相对应的记录','警告',idok);
end;

procedure TForm4.ToolButton7Click(Sender: TObject);
begin
  Table2.Append;
end;

procedure TForm4.ToolButton8Click(Sender: TObject);
begin
  Table2.Post;
  DBGridEh2.ReadOnly := True;
end;

procedure TForm4.ToolButton9Click(Sender: TObject);
begin
  Table2.Cancel;
end;

procedure TForm4.ToolButton10Click(Sender: TObject);
begin
  if Table2.RecordCount > 0 Then
  try
    if Application.MessageBox('确定要删除','警告',MB_OKCANCEL +MB_ICONQUESTION)=idok Then
       Table2.Delete;
    except
    table2.Cancel;
    end;
end;

procedure TForm4.ToolButton11Click(Sender: TObject);
Var
  FindZhiCheng:String;
begin
  FindZhiCheng := InPutBox('职称查询','请输入职称名：','');
  if not Table2.Locate('ZhiChengMC',FindZhiCheng,[]) Then
  Application.MessageBox('没有相对应的记录','警告',idok);
end;

procedure TForm4.ToolButton13Click(Sender: TObject);
begin
  Table3.Append;
end;

procedure TForm4.ToolButton14Click(Sender: TObject);
begin
  Table3.Post;
  DBGridEh3.ReadOnly := True;
end;

procedure TForm4.ToolButton15Click(Sender: TObject);
begin
  Table3.Cancel;
end;

procedure TForm4.ToolButton16Click(Sender: TObject);
begin
  if Table3.RecordCount >0 Then
    try
      if Application.MessageBox('确定要删除？','警告',MB_OKCANCEL +MB_ICONQUESTION)=idok Then
         Table3.Delete;
      except
         table3.Cancel;
      end;
end;

procedure TForm4.ToolButton17Click(Sender: TObject);
Var
  FindGangWeiZL:String;
begin
  FindGangWeiZL := InPutBox('职称查询','请输入职称名：','');
  if not Table3.Locate('GangWeiZLMC',FindGangWeiZL,[]) Then
  Application.MessageBox('没有相对应的记录','警告',idok);
end;

procedure TForm4.ToolButton19Click(Sender: TObject);
begin
  Table4.Append;
end;

procedure TForm4.ToolButton20Click(Sender: TObject);
begin
  Table4.Post;
  DBGridEh4.ReadOnly := True;
end;

procedure TForm4.ToolButton21Click(Sender: TObject);
begin
  Table4.Cancel;
end;

procedure TForm4.ToolButton23Click(Sender: TObject);
Var
  FindGangWeiJB:String;
begin
  FindGangWeiJB := InPutBox('职称查询','请输入职称名：','');
  if not Table4.Locate('GangWeiJBMC',FindGangWeiJB,[loCaseInsensitive, loPartialKey]) Then
  Application.MessageBox('没有相对应的记录','警告',idok);
end;

procedure TForm4.ToolButton22Click(Sender: TObject);
begin
  if Table4.RecordCount>0 Then
  try
    if Application.MessageBox('确定要删除？','警告',MB_OKCANCEL +MB_ICONQUESTION)=idok Then
    Table4.Delete;
    except
    Table4.Cancel;
    end;
end;

end.