sal_qry_saleplanofdeptanalyse_c.pas

一个MRPII系统源代码版本

unit Sal_Qry_SalePlanOfDeptAnalyse_C;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base_Condition, Db, AdODB, StdCtrls, Mask, linkedit;

Type
  TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C = Class(TFrm_Base_Condition)
    Label3: TLabel;
    Label2: TLabel;
    edt_DeptCode1: TLinkEdit;
    edt_DeptCode2: TLinkEdit;
    edt_DeptName1: TEdit;
    edt_DeptName2: TEdit;
    Label1: TLabel;
    edt_Year: TEdit;
    procedure edt_DeptCode1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure edt_DeptCode1ButtonClick(Sender: TObject);
    procedure edt_DeptCode1Exit(Sender: TObject);
    procedure edt_DeptCode2Exit(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Sal_Qry_SalePlanOfDeptAnalyse_C: TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C;

implementation
uses Sys_Global;
{$R *.DFM}

procedure TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C.edt_DeptCode1KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=120 then
  CommOnHint(Sender,AdoQry_Tmp,'DeptName',
             '销售部门名称','DeptCode','销售部门代码','Dept');

end;

procedure TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C.edt_DeptCode1ButtonClick(
  Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'DeptName',
             '销售部门名称','DeptCode','销售部门代码','Dept');

end;

procedure TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C.edt_DeptCode1Exit(Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Dept where DeptCode='+quotedstr(Tedit(sender).text),0);
  edt_DeptName1.Text:=AdoQry_tmp.fieldbyname('DeptName').asstring;
end;

procedure TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C.edt_DeptCode2Exit(Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Dept where DeptCode='+quotedstr(Tedit(sender).text),0);
  edt_DeptName2.Text:=AdoQry_tmp.fieldbyname('DeptName').asstring;
end;

procedure TFrm_Sal_Qry_SalePlanOfDeptAnalyse_C.FormCreate(Sender: TObject);
begin
  inherited;
  edt_Year.Text:=formatdatetime('yyyy',now);
end;

end.