unit BA050;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Simple, Db, DBTables, StdCtrls, Mask, DBCtrls, Buttons, ExtCtrls;

type
  TfmBA050 = class(TfmSimple)
    qyMasterCompanyID: TStringField;
    qyMasterWarehouseID: TStringField;
    qyMasterWarehouseName: TStringField;
    qyMasterCreateMan: TStringField;
    qyMasterCreateDate: TStringField;
    qyMasterCreateTime: TStringField;
    qyMasterModifyMan: TStringField;
    qyMasterModifyDate: TStringField;
    qyMasterModifyTime: TStringField;
    Label1: TLabel;
    Label2: TLabel;
    ED2: TDBEdit;
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure qyMasterBeforeDelete(DataSet: TDataSet);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure OpenDB; override;
  end;

var
  fmBA050: TfmBA050;

implementation

uses Main, PublicFunction, CheckData;

{$R *.DFM}

{ TfmSimpleTe }

procedure TfmBA050.FormCreate(Sender: TObject);
begin

  inherited;

  // sPrevID := '';
end;

procedure TfmBA050.OpenDB;
begin
  qyMaster.Close;
  OrderBySQL := 'WarehouseID';
  qyMaster.SQL.Text := SQLText;
  qyMaster.Open;

end;

procedure TfmBA050.qyMasterNewRecord(DataSet: TDataSet);
begin
  inherited;

  qyMaster.FieldByName('WarehouseID').AsString := Space(4);
  qyMaster.FieldByName('WarehouseName').AsString := Space(10);
end;

procedure TfmBA050.qyMasterBeforePost(DataSet: TDataSet);
begin
  inherited;

  if qyMaster.State = dsInsert then
  begin
    if Trim(qyMaster.FieldByName('WarehouseID').AsString) = '' then
    begin
      NullWarning('倉庫編號');
      ED1.SetFocus;
      Abort;
    end;
  with qyTemp do
  begin
    Close;
    SQL.Clear;
    SQL.Add('SELECT WarehouseID ');
    SQL.Add('FROM Warehouse ');
    SQL.Add('WHERE CompanyID = :CompanyID');
    SQL.Add('AND WarehouseID = :WarehouseID');
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('WarehouseID').AsString := qyMaster.FieldByName('WarehouseID').AsString;
    Open;
  end;
  if qyTemp.FieldByName('WarehouseID').AsString <> '' then
  begin
    RepeatWarning('倉庫編號');
    ED1.SetFocus;
    Abort;
  end;
end;
  if Trim(qyMaster.FieldByName('WarehouseName').AsString) = '' then
  begin
    NullWarning('倉庫名稱');
    ED2.SetFocus;
    Abort;
  end
end;

procedure TfmBA050.qyMasterBeforeDelete(DataSet: TDataSet);
begin
{  Result := True;
  with qyTemp do
  begin
    Close;
    SQL.Clear;
    SQL.Add('SELECT WarehouseID');
    SQL.Add('FROM InventoryAnalyst');
    SQL.Add('WHERE CompanyID = :CompanyID');
    SQL.Add('AND WarehouseID = :WarehouseID');
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('WarehouseID').AsString := qyMaster.FieldByName('WarehouseID').AsString;
    Open;
  end;
  if qyTemp.FieldByName('WarehouseID').AsString <> '' then
  begin
    CannotDeleteWarning('倉庫編號',qyMaster.FieldByName('WarehouseID').AsString);
    Result := False;
  end;
  with qyTemp do
  begin
    Close;
    SQl.Clear;
    SQL.Add('SELECT WarehouseID');
    SQL.Add('FROM InventoryBeginning');
    SQL.Add('WHERE CompanyID = :CompanyID');
    SQL.Add('AND WarehouseID = :WarehouseID');
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('WarehouseID').AsString := qyMaster.FieldByName('WarehouseID').AsString;
    Open;
  end;
  if qyTemp.FieldByName('WarehouseID').AsString <> '' then
  begin
    CannotDeleteWarning('倉庫編號',qyMaster.FieldByName('WarehouseID').AsString);
    Result := False;
  end;
  with qyTemp do
  begin
    Close;
    SQL.Clear;
    SQL.Add('SELECT TransferOutWarehouseID,TransferInWarehouseID');
    SQL.Add('FROM TransferMaster');
    SQL.Add('WHERE CompanyID = :CompanyID');
    SQL.Add('AND TransferOutWarehouseID = :TransferOutWarehouseID');
    SQL.Add('OR TransferInWarehouseID = :TransferInWarehouseID');
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('TransferOutWarehouseID').AsString :=
                qyMaster.FieldByName('WarehouseID').AsString;
    ParamByName('TransferInWarehouseID').AsString :=
                qyMaster.FieldByName('WarehouseID').AsString;
    Open;
  end;
  if  qyTemp.FieldByName('TransferOutWarehouseID').AsString <> '' then
  begin
    CannotDeleteWarning('調出倉庫',qyMaster.FieldByName('WarehouseID').AsString);
    Result := False;
  end;
  if qyTemp.FieldByName('TransferInwarehouseID').AsString <> '' then
  begin
    CannotDeleteWarning('調出倉庫',qyMaster.FieldByName('WarehouseID').AsString);
    Result := False;
  end;}
  inherited;
    // sPrevID := qyMaster.FieldByName('ID').AsString;
end;



end.