ba120.~pas

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

unit BA120;

interface

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

type
  TfmBA120 = class(TfmSingle)
    qyMasterCompanyID: TStringField;
    qyMasterCustomerID: TStringField;
    qyMasterCustomerAttribName: TStringField;
    qyMasterCustomerName: TStringField;
    qyMasterInvoiceNo: TStringField;
    qyMasterCustomerTypeID: TStringField;
    qyMasterCustomerTypeName: TStringField;
    qyMasterRegionID: TStringField;
    qyMasterRegionName: TStringField;
    qyMasterOwner: TStringField;
    qyMasterRocID: TStringField;
    qyMasterContactPhone1: TStringField;
    qyMasterContactPhone2: TStringField;
    qyMasterFax: TStringField;
    qyMasterSalesManID: TStringField;
    qyMasterChineseName: TStringField;
    qyMasterCustomerAddressID: TStringField;
    qyMasterCustomerAddressDescription: TStringField;
    qyMasterDeliveryAddressID: TStringField;
    qyMasterDeliveryAddressDescription: TStringField;
    qyMasterInvoiceAddressID: TStringField;
    qyMasterInvoiceAddressDescription: TStringField;
    qyMasterPaymentTerm: TStringField;
    qyMasterPayDays: TBCDField;
    qyMasterCustomerPayDate: TStringField;
    qyMasterCreditLine: TBCDField;
    qyMasterCreditBalance: TBCDField;
    qyMasterCustomerClass: TStringField;
    qyMasterAdvance: TBCDField;
    qyMasterCreateMan: TStringField;
    qyMasterCreateDate: TStringField;
    qyMasterCreateTime: TStringField;
    qyMasterModifyMan: TStringField;
    qyMasterModifyDate: TStringField;
    qyMasterModifyTime: TStringField;
    Label1: TLabel;
    Label2: TLabel;
    ED2: TDBEdit;
    Label3: TLabel;
    ED3: TDBEdit;
    PageCtl: TPageControl;
    TabA: TTabSheet;
    TabB: TTabSheet;
    TabC: TTabSheet;
    ED9: TDBEdit;
    Label9: TLabel;
    Label11: TLabel;
    EDB: TDBEdit;
    Label12: TLabel;
    EDC: TDBEdit;
    Label13: TLabel;
    EDD: TDBEdit;
    EDA: TDBEdit;
    Label10: TLabel;
    Label4: TLabel;
    ED8: TDBEdit;
    Label5: TLabel;
    Label14: TLabel;
    Label8: TLabel;
    ED4DES: TDBEdit;
    ED5: TDBEdit;
    ED5DES: TDBEdit;
    ED4: TDBEdit;
    Label27: TLabel;
    DBEdit26: TDBEdit;
    Label26: TLabel;
    EDL: TDBEdit;
    Label25: TLabel;
    EDK: TDBEdit;
    Label24: TLabel;
    EDJ: TDBEdit;
    Label23: TLabel;
    Label6: TLabel;
    DBEdit1: TDBEdit;
    Label29: TLabel;
    Label28: TLabel;
    sbRegionID: TSpeedButton;
    sbSalesManID: TSpeedButton;
    ED7: TDBComboBox;
    ED6: TDBEdit;
    DBEdit30: TDBEdit;
    sbCustomerTypeID: TSpeedButton;
    DBEdit29: TDBEdit;
    DBEdit28: TDBEdit;
    DBEdit21: TDBEdit;
    EDG: TDBEdit;
    Label20: TLabel;
    DBEdit19: TDBEdit;
    EDF: TDBEdit;
    Label18: TLabel;
    DBEdit17: TDBEdit;
    EDE: TDBEdit;
    Label16: TLabel;
    sbCustomerAddressID: TSpeedButton;
    sbDeliveryAddressID: TSpeedButton;
    sbInvoiceAddressID: TSpeedButton;
    qyCustomerContact: TQuery;
    qyCustomerAddress: TQuery;
    Panel2: TPanel;
    Panel5: TPanel;
    qyCustomerContactCompanyID: TStringField;
    qyCustomerContactCustomerID: TStringField;
    qyCustomerContactContactID: TStringField;
    qyCustomerContactChineseName: TStringField;
    qyCustomerContactEnglishName: TStringField;
    qyCustomerContactTitle: TStringField;
    qyCustomerContactPhone: TStringField;
    qyCustomerContactMobilePhone: TStringField;
    qyCustomerContactEMail: TStringField;
    qyCustomerContactLiaisonRedLetterDate: TStringField;
    qyCustomerContactRedLetterDateDescription: TStringField;
    dsCustomerContact: TDataSource;
    Label7: TLabel;
    EDQ: TDBEdit;
    Label15: TLabel;
    EDR: TDBEdit;
    Label17: TLabel;
    EDS: TDBEdit;
    Label19: TLabel;
    EDT: TDBEdit;
    Label21: TLabel;
    EDM: TDBEdit;
    Label30: TLabel;
    EDN: TDBEdit;
    Label31: TLabel;
    EDO: TDBEdit;
    Label32: TLabel;
    EDP: TDBEdit;
    gdCustomerContact: TDBGrid;
    qyCustomerAddressCompanyID: TStringField;
    qyCustomerAddressCustomerID: TStringField;
    qyCustomerAddressAddressID: TStringField;
    qyCustomerAddressAddressDescription: TStringField;
    qyCustomerAddressPostalCode: TStringField;
    qyCustomerAddressLine1: TStringField;
    qyCustomerAddressLine2: TStringField;
    qyCustomerAddressLine3: TStringField;
    Label33: TLabel;
    EDU: TDBEdit;
    dsCustomerAddress: TDataSource;
    Label34: TLabel;
    EDV: TDBEdit;
    Label35: TLabel;
    EDW: TDBEdit;
    Label36: TLabel;
    EDX: TDBEdit;
    Label37: TLabel;
    EDY: TDBEdit;
    Label38: TLabel;
    EDZ: TDBEdit;
    DBGrid2: TDBGrid;
    usCustomerContact: TUpdateSQL;
    usCustomerAddress: TUpdateSQL;
    Panel6: TPanel;
    ngCustomerAddress: TDBNavigator;
    Panel7: TPanel;
    ngCustomerContact: TDBNavigator;
    qyMasterInvoiceType: TStringField;
    qyCustAddress: TQuery;
    StringField3: TStringField;
    StringField4: TStringField;
    qyMasterLastDeliveryDate: TStringField;
    rgPaymentTerm: TDBRadioGroup;
    rgInvoiceType: TDBRadioGroup;
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure FormCreate(Sender: TObject);
    procedure qyCustomerContactBeforeOpen(DataSet: TDataSet);
    procedure qyCustomerContactNewRecord(DataSet: TDataSet);
    procedure qyCustomerContactBeforeInsert(DataSet: TDataSet);
    procedure qyCustomerContactBeforeEdit(DataSet: TDataSet);
    procedure qyCustomerContactBeforeDelete(DataSet: TDataSet);
    procedure qyCustomerContactBeforePost(DataSet: TDataSet);
    procedure qyCustomerContactAfterPost(DataSet: TDataSet);
    procedure qyCustomerContactAfterDelete(DataSet: TDataSet);
    procedure dsCustomerContactStateChange(Sender: TObject);
    procedure qyCustomerContactAfterInsert(DataSet: TDataSet);
    procedure qyCustomerAddressBeforeOpen(DataSet: TDataSet);
    procedure qyCustomerAddressNewRecord(DataSet: TDataSet);
    procedure qyCustomerAddressBeforeInsert(DataSet: TDataSet);
    procedure qyCustomerAddressBeforeEdit(DataSet: TDataSet);
    procedure qyCustomerAddressBeforeDelete(DataSet: TDataSet);
    procedure qyCustomerAddressBeforePost(DataSet: TDataSet);
    procedure qyCustomerAddressAfterPost(DataSet: TDataSet);
    procedure qyCustomerAddressAfterDelete(DataSet: TDataSet);
    procedure dsCustomerAddressStateChange(Sender: TObject);
    procedure ED7Exit(Sender: TObject);
    procedure EDLExit(Sender: TObject);
    procedure qyMasterSalesManIDValidate(Sender: TField);
    procedure qyMasterRegionIDValidate(Sender: TField);
    procedure qyMasterCustomerTypeIDValidate(Sender: TField);
    procedure qyMasterCustomerAddressIDValidate(Sender: TField);
    procedure qyMasterDeliveryAddressIDValidate(Sender: TField);
    procedure qyMasterInvoiceAddressIDValidate(Sender: TField);
    procedure qyMasterAfterScroll(DataSet: TDataSet);
    procedure sbSalesManIDClick(Sender: TObject);
    procedure sbRegionIDClick(Sender: TObject);
    procedure sbCustomerTypeIDClick(Sender: TObject);
    procedure sbCustomerAddressIDClick(Sender: TObject);
    procedure sbDeliveryAddressIDClick(Sender: TObject);
    procedure sbInvoiceAddressIDClick(Sender: TObject);
    procedure dsMasterStateChange(Sender: TObject);
    procedure qyCustomerAddressAfterInsert(DataSet: TDataSet);
    procedure qyMasterUpdateRecord(DataSet: TDataSet;
      UpdateKind: TUpdateKind; var UpdateAction: TUpdateAction);
    procedure qyCustAddressBeforeOpen(DataSet: TDataSet);
    procedure qyMasterBeforeInsert(DataSet: TDataSet);
    procedure qyMasterBeforeEdit(DataSet: TDataSet);
    procedure Panel3Click(Sender: TObject);
    procedure rgPaymentTermChange(Sender: TObject);
    procedure Splitter1CanResize(Sender: TObject; var NewSize: Integer;
      var Accept: Boolean);
  private
    { Private declarations }
    function CanModifyCustomerContactAndAddress: Boolean;
    procedure qyCustomerContactApplyUpdates;
    procedure qyCustomerAddressApplyUpdates;
  public
    { Public declarations }