unit BA110;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Single, Menus, Db, DBTables, Grids, DBGrids, Buttons, ExtCtrls, StdCtrls,
  Mask, DBCtrls;

type
  TfmBA110 = class(TfmSingle)
    qyMasterCompanyID: TStringField;
    qyMasterSalesManID: TStringField;
    qyMasterChineseName: TStringField;
    qyMasterEnglishName: TStringField;
    qyMasterRegionID: TStringField;
    qyMasterContactPhone: TStringField;
    qyMasterMobilePhone: TStringField;
    qyMasterContactAddress: TStringField;
    qyMasterEMail: TStringField;
    qyMasterCreateMan: TStringField;
    qyMasterCreateDate: TStringField;
    qyMasterCreateTime: TStringField;
    qyMasterModifyMan: TStringField;
    qyMasterModifyDate: TStringField;
    qyMasterModifyTime: TStringField;
    qyMasterRegionName: TStringField;
    Label1: TLabel;
    Label2: TLabel;
    ED2: TDBEdit;
    Label3: TLabel;
    ED3: TDBEdit;
    Label4: TLabel;
    ED4: TDBEdit;
    DBEdit1: TDBEdit;
    Label5: TLabel;
    ED5: TDBEdit;
    Label6: TLabel;
    ED6: TDBEdit;
    Label7: TLabel;
    ED17: TDBEdit;
    Label8: TLabel;
    ED8: TDBEdit;
    sbRegionID: TSpeedButton;
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure qyMasterRegionIDValidate(Sender: TField);
    procedure sbRegionIDClick(Sender: TObject);
    procedure dsMasterStateChange(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
     procedure OpenDB; override;
  end;

var
  fmBA110: TfmBA110;

implementation

uses Main, DataModule, PublicFunction, CheckData, GetData, BaseSearch;

{$R *.DFM}

{ TfmBA110 }


procedure TfmBA110.OpenDB;
begin
  qyMaster.Close;
  OrderBySQL := 'M.SalesManID';
  qyMaster.SQL.Text := SQLText;
  qyMaster.Open;

end;

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

  with qyMaster do
  begin
    FieldByName('SalesManID').AsString := Space(4);
    FieldByName('ChineseName').AsString := Space(8);
    FieldByName('EnglishName').AsString := Space(15);
    FieldByName('RegionID').AsString := '00';
    FieldByName('ContactPhone').AsString := Space(20);
    FieldByName('MobilePhone').AsString := Space(10);
    FieldByName('ContactAddress').AsString := Space(60);
    FieldByName('EMail').AsString := Space(30);
  end;
end;

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

  if qyMaster.State = dsInsert then
  begin
    if Trim(qyMaster.FieldByName('SalesManID').AsString) = '' then
    begin
      NullWarning('銷售員編碼');
      ED1.SetFocus;
      Abort;
    end;
    with qyTemp do
    begin
      Close;
      SQL.Clear;
      SQL.Add('SELECT SalesManID');
      SQL.Add('FROM SalesMan');
      SQL.Add('WHERE CompanyID = :CompanyID AND SalesManID = :SalesManID');
      ParamByName('CompanyID').AsString := sCompanyID;
      ParamByName('SalesManID').AsString := qyMaster.FieldByName('SalesManID').AsString;
      Open;
    end;
    if qyTemp.FieldByName('SalesManID').AsString <> '' then
    begin
      RepeatWarning('銷售員編碼');
      Ed1.SetFocus;
      Abort;
    end;
  end;
  if Trim(qyMaster.FieldByName('ChineseName').AsString) = '' then
  begin
    NullWarning('中文名');
    ED2.SetFocus;
    Abort;
  end;
  if not CheckRegionID(qyMaster.FieldByName('RegionID').AsString) then
  begin
    ED4.SetFocus;
    Abort;
  end;
end;

procedure TfmBA110.qyMasterRegionIDValidate(Sender: TField);
begin
  inherited;
  qyMaster.FieldByName('RegionName').AsString :=
           GetRegionName(qyMaster.FieldByName('RegionID').AsString);
end;

procedure TfmBA110.sbRegionIDClick(Sender: TObject);
begin
  inherited;
  SearchData(ED4, DM.qyRegion);
end;

procedure TfmBA110.dsMasterStateChange(Sender: TObject);
begin
  inherited;
  sbRegionID.Enabled := qyMaster.State in [dsInsert, dsEdit];
end;

end.