inv_whsumqry_c.pas

一个MRPII系统源代码版本

unit Inv_WhSumQry_C;

Interface

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

Type
  TFrm_Inv_WhSumQry_C = Class(TFrm_Base_Condition)
    Label2: TLabel;
    MEdt_Month: TMaskEdit;
    Label1: TLabel;
    MEdt_Month1: TMaskEdit;
    procedure btn_okClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure MEdt_Month1Exit(Sender: TObject);
    procedure MEdt_MonthExit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_Inv_WhSumQry_C: TFrm_Inv_WhSumQry_C;

implementation

uses Sys_Global,Inv_Global;

{$R *.DFM}

procedure TFrm_Inv_WhSumQry_C.btn_okClick(Sender: TObject);
begin
  inherited;
  Condition:='InvMonthSum.InvMonth Between '''+MEdt_Month.Text
    +''' And '''+MEdt_Month1.Text+'''';
  ConditionHint:='月份： '+MEdt_Month.Text+' 到 '+MEdt_Month1.Text;
  ModalResult:=mrOk;
end;

procedure TFrm_Inv_WhSumQry_C.FormCreate(Sender: TObject);
begin
  inherited;
  MEdt_Month.Text:=FormatDateTime('yyyy.mm',IncMonth(Now,-1));
  MEdt_Month1.Text:=FormatDateTime('yyyy.mm',Now);
end;

procedure TFrm_Inv_WhSumQry_C.MEdt_Month1Exit(Sender: TObject);
begin
  inherited;
  MonthCheck(Sender);
  InvDataChangeCheck(AdoQry_Tmp,TEdit(Sender).Text);
  if StrToDateTime(MEdt_Month.Text+'.01')>StrToDateTime(MEdt_Month1.Text+'.01')then
  begin
    DispInfo('查询终止月份不能小于起始月份！',3);
    TWinControl(Sender).SetFocus;
    Abort;
  end;
end;

procedure TFrm_Inv_WhSumQry_C.MEdt_MonthExit(Sender: TObject);
begin
  inherited;
  MonthCheck(Sender);
  InvDataChangeCheck(AdoQry_Tmp,TEdit(Sender).Text);
end;

end.