ar_qry_ar4_c.pas

来自「一个MRPII系统源代码版本」· PAS 代码 · 共 225 行

unit Ar_Qry_Ar4_C;

Interface

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

Type
  TFrm_Ar_Qry_Ar4_C = Class(TFrm_Base_Condition)
    Label1: TLabel;
    medt_Date1: TMaskEdit;
    Label2: TLabel;
    medt_Date2: TMaskEdit;
    Label3: TLabel;
    edt_CustomerCode1: TLinkEdit;
    Label4: TLabel;
    edt_CustomerCode2: TLinkEdit;
    Label5: TLabel;
    edt_DeptCode1: TLinkEdit;
    Label6: TLabel;
    edt_DeptCode2: TLinkEdit;
    Label7: TLabel;
    edt_EmployeeCode1: TLinkEdit;
    Label8: TLabel;
    edt_EmployeeCode2: TLinkEdit;
    Label9: TLabel;
    edt_Invoiceno1: TLinkEdit;
    Label10: TLabel;
    edt_Invoiceno2: TLinkEdit;
    Label11: TLabel;
    edt_CurrencyCode1: TLinkEdit;
    edt_CustomerName1: TEdit;
    edt_CustomerName2: TEdit;
    edt_DeptName1: TEdit;
    edt_DeptName2: TEdit;
    edt_SaleEmployeeName1: TEdit;
    edt_SaleEmployeeName2: TEdit;
    edt_CurrencyName: TEdit;
    Label12: TLabel;
    edt_CurrencyCode2: TLinkEdit;
    edt_CurrencyName2: TEdit;
    Label13: TLabel;
    Label14: TLabel;
    edt_SaleTypeCode1: TLinkEdit;
    edt_SaleTypeCode2: TLinkEdit;
    edt_SaleTypeName1: TEdit;
    edt_SaleTypeName2: TEdit;
    procedure edt_Invoiceno1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure edt_Invoiceno1ButtonClick(Sender: TObject);
    procedure edt_Invoiceno2ButtonClick(Sender: TObject);
    procedure edt_Invoiceno2KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormShow(Sender: TObject);
    procedure edt_CustomerCode1Exit(Sender: TObject);
    procedure edt_CustomerCode2Exit(Sender: TObject);
    procedure edt_DeptCode1Exit(Sender: TObject);
    procedure edt_DeptCode2Exit(Sender: TObject);
    procedure edt_EmployeeCode1Exit(Sender: TObject);
    procedure edt_EmployeeCode2Exit(Sender: TObject);
    procedure edt_CurrencyCode2Exit(Sender: TObject);
    procedure edt_CurrencyCode1Exit(Sender: TObject);
    procedure edt_SaleTypeCode1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure edt_SaleTypeCode1ButtonClick(Sender: TObject);
    procedure edt_SaleTypeCode1Exit(Sender: TObject);
    procedure edt_SaleTypeCode2Exit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Ar_Qry_Ar4_C: TFrm_Ar_Qry_Ar4_C;

implementation
uses  Sys_Global;
{$R *.DFM}

procedure TFrm_Ar_Qry_Ar4_C.edt_Invoiceno1KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=120 then 
  CommOnHint(Sender,AdoQry_Tmp,'createdate',
             '发票日期','Invoiceno','销售发票号','sa_SaleInvoice','OrderType=0 and active=1 ');

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_Invoiceno1ButtonClick(Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'createdate',
             '发票日期','Invoiceno','销售发票号','sa_SaleInvoice','OrderType=0 and active=1 ');

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_Invoiceno2ButtonClick(Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'createdate',
             '发票日期','Invoiceno','销售发票号','sa_SaleInvoice','OrderType=0 and active=1 ');

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_Invoiceno2KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=120 then 
  CommOnHint(Sender,AdoQry_Tmp,'createdate',
             '发票日期','Invoiceno','销售发票号','sa_SaleInvoice','OrderType=0 and active=1 ');

end;

procedure TFrm_Ar_Qry_Ar4_C.FormShow(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from currency',0);
edt_CurrencyCode1.Text:=AdoQry_tmp.fieldbyname('currencyCode').asstring;
edt_CurrencyName.Text:=AdoQry_tmp.fieldbyname('currencyName').asstring;
end;

procedure TFrm_Ar_Qry_Ar4_C.edt_CustomerCode1Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from customer where customerCode='+quotedstr(Tlinkedit(sender).text),0);
edt_CustomerName1.Text:=AdoQry_tmp.fieldbyname('customerName').asstring;

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_CustomerCode2Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from customer where customerCode='+quotedstr(Tlinkedit(sender).text),0);
edt_CustomerName2.Text:=AdoQry_tmp.fieldbyname('customerName').asstring;

end;

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

end;

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

end;

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

end;

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

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_CurrencyCode2Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from currency where currencyCode='+quotedstr(Tlinkedit(sender).text),0);
edt_CurrencyName2.Text:=AdoQry_tmp.fieldbyname('currencyName').asstring;

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_CurrencyCode1Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from currency where currencyCode='+quotedstr(Tlinkedit(sender).text),0);
edt_CurrencyName.Text:=AdoQry_tmp.fieldbyname('currencyName').asstring;

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_SaleTypeCode1KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
if key=120 then 
  CommOnHint(Sender,AdoQry_Tmp,'SaleTypeName','销售类型名称','SaleTypeCode',
             '销售类型代码',' SaleType ');

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_SaleTypeCode1ButtonClick(Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'SaleTypeName','销售类型名称','SaleTypeCode',
             '销售类型代码',' SaleType ');

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_SaleTypeCode1Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from SaleType where SaleTypeCode='+quotedstr(Tlinkedit(sender).text),0);
edt_SaleTypeName1.Text:=AdoQry_tmp.fieldbyname('SaleTypeName').asstring;

end;

procedure TFrm_Ar_Qry_Ar4_C.edt_SaleTypeCode2Exit(Sender: TObject);
begin
  inherited;
Executesql(AdoQry_tmp,'select * from SaleType where SaleTypeCode='+quotedstr(Tlinkedit(sender).text),0);
edt_SaleTypeName2.Text:=AdoQry_tmp.fieldbyname('SaleTypeName').asstring;

end;

end.