ar_qry_chginfoarap_c.pas

一个MRPII系统源代码版本

unit Ar_Qry_ChgInfoArAp_C;

Interface

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

Type
  TFrm_Ar_Qry_ChgInfoArAp_C = Class(TFrm_Base_Condition)
    Label1: TLabel;
    medts: TMaskEdit;
    Label3: TLabel;
    Label2: TLabel;
    edt_Invoiceno1: TEdit;
    edt_Invoiceno2: TEdit;
    Label4: TLabel;
    Label5: TLabel;
    edt_EmployeeCode1: TLinkEdit;
    edt_EmployeeCode2: TLinkEdit;
    edt_EmployeeName1: TEdit;
    edt_EmployeeName2: TEdit;
    medte: TMaskEdit;
    Label6: TLabel;
    procedure edt_CustomerCode1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormShow(Sender: TObject);
    procedure edt_EmployeeCode1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure edt_EmployeeCode1ButtonClick(Sender: TObject);
    procedure edt_EmployeeCode1Exit(Sender: TObject);
    procedure edt_EmployeeCode2Exit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Ar_Qry_ChgInfoArAp_C: TFrm_Ar_Qry_ChgInfoArAp_C;

implementation
uses Sys_Global;
{$R *.DFM}

procedure TFrm_Ar_Qry_ChgInfoArAp_C.edt_CustomerCode1KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=120 then
  CommOnHint(Sender,AdoQry_Tmp,'customerName',
             '销售客户名称','customerCode','销售客户代码','customer');
end;

procedure TFrm_Ar_Qry_ChgInfoArAp_C.FormShow(Sender: TObject);
begin
  inherited;
  medts.Text:=formatdatetime('yyyy.mm.dd',date-30);
  medte.Text:=formatdatetime('yyyy.mm.dd',date);
end;

procedure TFrm_Ar_Qry_ChgInfoArAp_C.edt_EmployeeCode1KeyDown(
  Sender: TObject; var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=vk_f9 then
  CommOnHint(Sender,AdoQry_Tmp,'EmployeeName',
             '操作员名称','EmployeeCode','操作员代码','Employee');
end;

procedure TFrm_Ar_Qry_ChgInfoArAp_C.edt_EmployeeCode1ButtonClick(
  Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'EmployeeName',
             '操作员名称','EmployeeCode','操作员代码','Employee');

end;

procedure TFrm_Ar_Qry_ChgInfoArAp_C.edt_EmployeeCode1Exit(
  Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Employee where EmployeeCode='+quotedstr(Tedit(sender).text),0);
  edt_EmployeeName1.Text:=AdoQry_tmp.fieldbyname('EmployeeName').asstring;

end;

procedure TFrm_Ar_Qry_ChgInfoArAp_C.edt_EmployeeCode2Exit(
  Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Employee where EmployeeCode='+quotedstr(Tedit(sender).text),0);
  edt_EmployeeName2.Text:=AdoQry_tmp.fieldbyname('EmployeeName').asstring;

end;

end.