gl_qry_accountbook5_c.pas

一个MRPII系统源代码版本

unit Gl_Qry_AccountBook5_C;

Interface

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

Type
  TFrm_Gl_Qry_AccountBook5_C = Class(TFrm_Base_Condition)
    Label1: TLabel;
    Label4: TLabel;
    medts: TMaskEdit;
    medte: TMaskEdit;
    Label7: TLabel;
    cmb_MoreAccountBook: TComboBox;
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Gl_Qry_AccountBook5_C: TFrm_Gl_Qry_AccountBook5_C;

implementation
uses Sys_Global;
{$R *.DFM}

procedure TFrm_Gl_Qry_AccountBook5_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+'.01';
medte.Text:=AdoQry_tmp.fieldbyname('yy').asstring+'.'+AdoQry_tmp.fieldbyname('mm').asstring;
cmb_MoreAccountBook.Items.clear;
Executesql(AdoQry_tmp,'select * from Gl_MoreAccountBook',0);
while not AdoQry_tmp.Eof do
 begin
   cmb_MoreAccountBook.Items.Add(AdoQry_tmp.fieldbyname('AccountBookCode').asstring+' '+AdoQry_tmp.fieldbyname('AccountBookName').asstring);
   AdoQry_tmp.Next;
 end;
cmb_MoreAccountBook.ItemIndex:=0;
end;

end.