stk_whemployee.pas

一个MRPII系统源代码版本

unit Stk_WhEmployee;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base_Outer, Menus, ExtPrintReport, Db, ActnList, AdODB, Grids, DBGridEh,
  StdCtrls, ExtCtrls, ComCtrls, ToolWin, jpeg;

Type
  TFrm_Stk_WhEmployee = Class(TFrm_Base_Outer)
    AdoQry_MainEmployeeCode: TStringField;
    AdoQry_MainEmployeeName: TStringField;
    AdoQry_MainWhEmployeeUsable: TIntegerField;
  private
    { Private declarations }
  public
    { Public declarations }
    procedure Initform(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function SetDeleteSql:String;Override;
  end;

var
  Frm_Stk_WhEmployee: TFrm_Stk_WhEmployee;

implementation

uses Stk_WhEmployee_D;

{$R *.DFM}

procedure TFrm_Stk_WhEmployee.initform(AdOConnection: TAdOConnection;
  ReadOnly: boolean);
begin
  inherited;
  SelectFromSQL:='Select WhEmployee.EmployeeCode'
    +',Employee.EmployeeName'
    +',WhEmployee.WhEmployeeUsable'
    +' From WhEmployee'
    +' Join Employee On WhEmployee.EmployeeCode=Employee.EmployeeCode';
  OrderByFields:='EmployeeCode';
  Frm_Sys_Detail:=TFrm_Stk_WhEmployee_D.Create(Application);
  GetData;
end;

function TFrm_Stk_WhEmployee.SetDeleteSql: String;
begin
  Result:='Delete WhEmployee'
    +' Where EmployeeCode='''+AdoQry_Main.fieldbyname('EmployeeCode').AsString+'''';
end;

end.