bas_employee.pas

一个MRPII系统源代码版本

unit Bas_Employee;

Interface

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

Type
  TFrm_Bas_Employee = Class(TFrm_Base_Outer)
    AdoQry_MainEmployeeCode: TStringField;
    AdoQry_MainDeptCode: TStringField;
    AdoQry_MainEmployeeName: TStringField;
    AdoQry_MainDeptName: TStringField;
  private
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function  SetDeleteSql:String;Override;
    { Public declarations }
  end;

var
  Frm_Bas_Employee: TFrm_Bas_Employee;

implementation

uses Bas_Employee_D;

{$R *.DFM}

procedure TFrm_Bas_Employee. InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);
begin
  inherited;
  SelectFromSQL:='Select Employee.EmployeeCode'
    +',Employee.DeptCode'
    +',Employee.EmployeeName'
    +',Dept.DeptName'
    +' From Employee'
    +' Join Dept On Employee.DeptCode=Dept.DeptCode';
  OrderByFields:='EmployeeCode';
  ConditionUserDefine:='EmployeeCode<>''System''';
  GetData;
  Frm_Sys_Detail:=TFrm_Bas_Employee_D.Create(Application);
end;

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

end.