gl_qry_accountbook2_c.pas

一个MRPII系统源代码版本

unit Gl_Qry_AccountBook2_C;

Interface

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

Type
  TFrm_Gl_Qry_AccountBook2_C = Class(TFrm_Base_Condition)
    Label1: TLabel;
    Label4: TLabel;
    medts: TMaskEdit;
    medte: TMaskEdit;
    Label3: TLabel;
    Label2: TLabel;
    edt_kmCode1: TLinkEdit;
    edt_kmCode2: TLinkEdit;
    edt_kmName1: TEdit;
    edt_kmName2: TEdit;
    Label7: TLabel;
    cmb_Currency: TComboBox;
    Label5: TLabel;
    cmb_include: TComboBox;
    procedure edt_kmCode1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure edt_kmCode1ButtonClick(Sender: TObject);
    procedure edt_kmCode1Exit(Sender: TObject);
    procedure edt_kmCode2Exit(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Gl_Qry_AccountBook2_C: TFrm_Gl_Qry_AccountBook2_C;

implementation
uses Sys_Global;
{$R *.DFM}

procedure TFrm_Gl_Qry_AccountBook2_C.edt_kmCode1KeyDown(Sender: TObject;
  var Key: Word; Shift: TShiftState);
begin
  inherited;
  if key=120 then
  CommOnHint(Sender,AdoQry_Tmp,'kmName',
             '科目名称','kmCode','科目代码','Gl_AccountSubject');

end;

procedure TFrm_Gl_Qry_AccountBook2_C.edt_kmCode1ButtonClick(
  Sender: TObject);
begin
  inherited;
  CommOnHint(Sender,AdoQry_Tmp,'kmName',
             '科目名称','kmCode','科目代码','Gl_AccountSubject');

end;

procedure TFrm_Gl_Qry_AccountBook2_C.edt_kmCode1Exit(Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Gl_AccountSubject where kmCode='+quotedstr(Tedit(sender).text),0);
  edt_kmName1.Text:=AdoQry_tmp.fieldbyname('kmName').asstring;
end;

procedure TFrm_Gl_Qry_AccountBook2_C.edt_kmCode2Exit(Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select * from Gl_AccountSubject where kmCode='+quotedstr(Tedit(sender).text),0);
  edt_kmName2.Text:=AdoQry_tmp.fieldbyname('kmName').asstring;
end;

procedure TFrm_Gl_Qry_AccountBook2_C.FormShow(Sender: TObject);
begin
  inherited;
  Executesql(AdoQry_tmp,'select dateName(yy,getdate()) as yy,dateName(mm,getdate()) as mm,dateName(dd,getdate()) as dd ',0);
  medts.Text:=AdoQry_tmp.fieldbyname('yy').asstring+'.'+AdoQry_tmp.fieldbyname('mm').asstring;
  medte.Text:=AdoQry_tmp.fieldbyname('yy').asstring+'.'+AdoQry_tmp.fieldbyname('mm').asstring;
  cmb_Currency.Items.clear;
  cmb_Currency.Items.Add('综合本位币');
  Executesql(AdoQry_tmp,'select * from currency',0);
  while not AdoQry_tmp.Eof do
   begin
     cmb_Currency.Items.Add(AdoQry_tmp.fieldbyname('currencyCode').asstring+' '+AdoQry_tmp.fieldbyname('currencyName').asstring);
     AdoQry_tmp.Next;
   end;
  cmb_Currency.ItemIndex:=0;
  cmb_include.ItemIndex:=1;
end;

end.