sy150.pas

一套融入了系统营销管理思想的管理软件产品

unit SY150;

interface

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

type
  TfmSY150 = class(TfmSimple)
    qyMasterCompanyID: TStringField;
    qyMasterAttribName: TStringField;
    qyMasterCompanyName: TStringField;
    qyMasterInvoiceNo: TStringField;
    qyMasterOpenningYear: TStringField;
    qyMasterOpenningMonth: TStringField;
    qyMasterPeriodYear: TStringField;
    qyMasterPeriodMonth: TStringField;
    qyMasterCreateMan: TStringField;
    qyMasterCreateDate: TStringField;
    qyMasterCreateTime: TStringField;
    qyMasterModifyMan: TStringField;
    qyMasterModifyDate: TStringField;
    qyMasterModifyTime: TStringField;
    Label1: TLabel;
    Label2: TLabel;
    ED2: TDBEdit;
    Label3: TLabel;
    ED3: TDBEdit;
    Label4: TLabel;
    ED4: TDBEdit;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    ED5: TDBComboBox;
    ED6: TDBComboBox;
    ED8: TDBComboBox;
    ED7: TDBComboBox;
    procedure qyMasterBeforeOpen(DataSet: TDataSet);
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure dsMasterStateChange(Sender: TObject);
    procedure qyMasterBeforeDelete(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure OpenDB; override;
  end;

var
  fmSY150: TfmSY150;

implementation

uses PublicFunction, Main;

{$R *.DFM}

{ TfmSY150 }

procedure TfmSY150.OpenDB;
begin
  qyMaster.Close;
  OrderBySQL := 'CompanyID';
  qyMaster.SQL.Text := SQLText;
  qyMaster.Open;
end;

procedure TfmSY150.qyMasterBeforeOpen(DataSet: TDataSet);
begin
  //inherited;
end;

procedure TfmSY150.qyMasterNewRecord(DataSet: TDataSet);
begin
  inherited;
  with qyMaster do
  begin
    FieldByName('CompanyID').AsString := Space(2);
    FieldByName('AttribName').AsString := Space(10);
    FieldByName('CompanyName').AsString := Space(60);
    FieldByName('InvoiceNo').AsString := Space(8);
    FieldByName('OpenningYear').AsString := LeftStr(Today, 2);
    FieldByName('OpenningMonth').AsString := SubStr(Today, 4, 2);
    FieldByName('PeriodYear').AsString := LeftStr(Today, 2);
    FieldByName('PeriodMonth').AsString := SubStr(Today, 4, 2);
  end;
end;

procedure TfmSY150.qyMasterBeforePost(DataSet: TDataSet);
begin
  inherited;
  if qyMaster.State = dsInsert then
  begin
    if Trim(qyMaster.FieldByName('CompanyID').AsString) = '' then
    begin
      NullWarning('公司编号');
      ED1.SetFocus;
      Abort;
    end;
    with qyTemp do
    begin
      Close;
      SQL.Clear;
      SQL.Add('SELECT CompanyID ');
      SQL.Add('FROM Company ');
      SQL.Add('WHERE CompanyID = :CompanyID ');
      ParamByName('CompanyID').AsString := qyMaster.FieldByName('CompanyID').AsString;
      Open;
    end;
    if qyTemp.FieldByName('CompanyID').AsString <> '' then
    begin
      RepeatWarning('公司编号');
      ED1.SetFocus;
      Abort;
    end;
  end;
  if Trim(qyMaster.FieldByName('AttribName').AsString) = '' then
  begin
    NullWarning('公司简称');
    ED2.SetFocus;
    Abort;
  end;
end;

procedure TfmSY150.dsMasterStateChange(Sender: TObject);
begin
  inherited;
  ED5.ReadOnly := (not (qyMaster.State = dsInsert));
  ED6.ReadOnly := (not (qyMaster.State = dsInsert));
end;

procedure TfmSY150.qyMasterBeforeDelete(DataSet: TDataSet);
begin
  if not MyConfirmation('确定删除本笔数据吗？') then
    Abort;
end;

end.