dl110.~pa

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

unit DL110;

interface

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

type
  TfmDL110 = class(TfmMasterDetail)
    qyMasterCompanyID: TStringField;
    qyMasterDeliveryID: TStringField;
    qyMasterDeliveryDate: TStringField;
    qyMasterCustomerID: TStringField;
    qyMasterCustomerAttribName: TStringField;
    qyMasterWarehouseID: TStringField;
    qyMasterWarehouseName: TStringField;
    qyMasterSalesManID: TStringField;
    qyMasterChineseName: TStringField;
    qyMasterDeliveryProperty: TStringField;
    qyMasterInvoiceType: TStringField;
    qyMasterInvoiceNo: TStringField;
    qyMasterCustomerOrderNo: TStringField;
    qyMasterSubTotal: TBCDField;
    qyMasterValueAddTax: TBCDField;
    qyMasterAmount: TBCDField;
    qyMasterSales: TBCDField;
    qyMasterTax: TBCDField;
    qyMasterReceived: TBCDField;
    qyMasterCreateMan: TStringField;
    qyMasterCreateDate: TStringField;
    qyMasterCreateTime: TStringField;
    qyMasterModifyMan: TStringField;
    qyMasterModifyDate: TStringField;
    qyMasterModifyTime: TStringField;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    Label3: TLabel;
    ED2: TDBEdit;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    ED6: TDBEdit;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    ED4: TDBEdit;
    DBEdit8: TDBEdit;
    Label9: TLabel;
    sbWarehouseID: TSpeedButton;
    sbSalesManID: TSpeedButton;
    sbCustomerID: TSpeedButton;
    ED5: TDBComboBox;
    Label10: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    ED8: TDBEdit;
    ED9: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    ED7: TDBComboBox;
    qyDetailCompanyID: TStringField;
    qyDetailDeliveryItem: TStringField;
    qyDetailProductID: TStringField;
    qyDetailProductName: TStringField;
    qyDetailSalesQuantity: TBCDField;
    qyDetailSalesUnitPrice: TBCDField;
    qyDetailSalesAmount: TBCDField;
    qyDetailSalesAnalystAmount: TBCDField;
    sbDeliveryDate: TSpeedButton;
    qyMasterDeliveryPropertyName: TStringField;
    DBEdit2: TDBEdit;
    qyMasterDeliveryAddressID: TStringField;
    qyMasterAddressDescription: TStringField;
    Label4: TLabel;
    ED3: TDBEdit;
    DBEdit5: TDBEdit;
    sbDeliveryAddressID: TSpeedButton;
    qyDetailDeliveryID: TStringField;
    qyTemp2: TQuery;
    qyTemp1: TQuery;
    procedure FormCreate(Sender: TObject);
    procedure qyMasterBeforeOpen(DataSet: TDataSet);
    procedure qyMasterNewRecord(DataSet: TDataSet);
    procedure qyMasterBeforePost(DataSet: TDataSet);
    procedure qyMasterCalcFields(DataSet: TDataSet);
    procedure qyMasterBeforeDelete(DataSet: TDataSet);
    procedure qyDetailBeforeOpen(DataSet: TDataSet);
    procedure qyDetailNewRecord(DataSet: TDataSet);
    procedure qyDetailBeforePost(DataSet: TDataSet);
    procedure qyDetailCalcFields(DataSet: TDataSet);
    procedure qyDetailBeforeDelete(DataSet: TDataSet);
    procedure sbDeliveryDateClick(Sender: TObject);
    procedure qyDetailSalesQuantityValidate(Sender: TField);
    procedure qyDetailSalesUnitPriceValidate(Sender: TField);
    procedure dsMasterStateChange(Sender: TObject);
    procedure qyDetailBeforeInsert(DataSet: TDataSet);
    procedure qyDetailBeforeEdit(DataSet: TDataSet);
    procedure qyMasterCustomerIDValidate(Sender: TField);
    procedure qyMasterDeliveryAddressIDValidate(Sender: TField);
    procedure qyMasterSalesManIDValidate(Sender: TField);
    procedure qyMasterDeliveryPropertyValidate(Sender: TField);
    procedure qyMasterWarehouseIDValidate(Sender: TField);
    procedure qyDetailProductIDValidate(Sender: TField);
    procedure gdDetailEditButtonClick(Sender: TObject);
  private
    { Private declarations }
    AStartPeriodDate, AEndPeriodDate : String;
    AStartCustomerID, AEndCustomerID : String;
    AStartSalesManID, AEndSalesManID : String;
    AStartWarehouseID, AEndWarehouseID : String;
    AProperty1, AProperty2, AProperty3, AProperty4 : String;
    procedure CalcSalesAmount;
    procedure UpdateSalesAnalyst(DeliveryDate, CustomerID, ProductID,
              DeliveryProperty: String; SalesQuantity, SalesAmount: Extended);
    procedure UpdateCustomerInventory(CustomerID, ProductID: String;
              Quantity: Extended);
    procedure UpdateDeliveryPropertyName;
  public
    { Public declarations }
    procedure OpenDB; override;
    procedure AfterInsertPost; override;
    procedure AfterEditPost; override;
    function BeforeDelete: Boolean; override;
    procedure AfterDelete; override;
    procedure DetailAfterInsertPost; override;
    procedure DetailAfterEditPost; override;
    function DetailBeforeDelete: Boolean; override;
    procedure DetailAfterDelete; override;
    procedure CalcAmount; override;
    procedure SetOthersButton; override;
  end;

var
  fmDL110: TfmDL110;

implementation

uses Main, DataModule, PublicFunction, CheckData, ChinaCalendar, GetData,
  SearchProductID;

var
  sPrevDeliveryID, sPrevDeliveryDate, sPrevCustomerID, sPrevWarehouseID : String; //