mc_rylb.pas

1、系统环境要求：所有程序均在Windows98/XP操作系统下测试运行。 2、建议用户在系统上安装DELPHI7.0企业版。 3、如果数据库为SQL Server数据库

unit MC_RYLB;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  DBCtrls, Db, Grids, DBGrids, DBTables, StdCtrls, Buttons;

type
  TRYLB = class(TForm)
    Table1: TTable;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Table2: TTable;
    Table2BDEDesigner: TStringField;
    DataSource2: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    BitBtn1: TBitBtn;
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RYLB: TRYLB;

implementation

uses MC_TSDJ, MC_XGTSXX, MC_TSCX, MC_WXDJ;

{$R *.DFM}

procedure TRYLB.FormShow(Sender: TObject);
begin
     DBLookupComboBox1.KeyValue:=Table2.FieldByName('工种').AsString;
end;

procedure TRYLB.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     if Assigned(TSDj) then
        begin
             if Table1.RecordCount<>0 then
             TSDJ.Table1.FieldByName('管理人').AsString:=Table1.FieldbyName('姓名').AsString;
        end;
     if Assigned(XGTSXX) then
        begin
             if Table1.RecordCount<>0 then
             TSCX.Query1.FieldByName('管理人').AsString:=Table1.FieldbyName('姓名').AsString;
        end;
     if Assigned(WXDJ) then
        begin
             if Table1.RecordCount<>0 then
             WXDJ.Table1.FieldByName('维修人员').AsString:=Table1.FieldbyName('姓名').AsString;
        end;
     RYLB.Release;
     RYLB:=Nil;
end;

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

end.