sal_qry_chginfosalecontracth.pas

一个MRPII系统源代码版本

unit Sal_Qry_ChgInfoSaleContractH;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base_Qry, Menus, ExtPrintReport, Db, ActnList, AdODB, Grids, DBGridEh,
  StdCtrls, ExtCtrls, ComCtrls, ToolWin, jpeg;

Type
  TFrm_Sal_Qry_ChgInfoSaleContractH = Class(TFrm_Base_Qry)
    AdoQry_MainCustomerCode: TStringField;
    AdoQry_MainCUSTOMERName: TStringField;
    AdoQry_MainCustomerB: TStringField;
    AdoQry_MainSlcNo: TStringField;
    AdoQry_MainSlcDate: TDateTimeField;
    AdoQry_MainTaxRate_Percent: TFloatField;
    AdoQry_MainCurrencyCode: TStringField;
    AdoQry_MainCURRENCYName: TStringField;
    AdoQry_MainCurrencyB: TStringField;
    AdoQry_MainRemArk: TStringField;
    AdoQry_MainEmployeeName: TStringField;
    AdoQry_MainEmployeeB: TStringField;
    AdoQry_MainChgType: TStringField;
    AdoQry_Mainchgtime: TDateTimeField;
    AdoQry_MainchgEmployeeCode: TStringField;
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
  end;

var
  Frm_Sal_Qry_ChgInfoSaleContractH: TFrm_Sal_Qry_ChgInfoSaleContractH;

implementation

uses Sal_Qry_ChgInfoSaleContractH_C;

{$R *.DFM}
procedure TFrm_Sal_Qry_ChgInfoSaleContractH.InitForm(AdOConnection: TAdOConnection;
  ReadOnly: Boolean);
begin
  inherited;
  SelectFromSql:=' select  sa_SaleContractHistory.CustomerCode,'+
                ' Customer.CUSTOMERName,'+
                ' sa_SaleContractHistory.CustomerCode+'' ''+Customer.CUSTOMERName As CustomerB,'+
                ' sa_SaleContractHistory.SlcNo,'+
                ' sa_SaleContractHistory.SlcDate,'+
                ' sa_SaleContractHistory.TaxRate_Percent,'+
                ' sa_SaleContractHistory.CurrencyCode,'+
                ' Currency.CURRENCYName,'+
                ' sa_SaleContractHistory.CurrencyCode+'' ''+Currency.CURRENCYName As CurrencyB,'+
                ' sa_SaleContractHistory.RemArk,'+
                ' sa_SaleContractHistory.chgEmployeeCode,'+
                ' Employee.EmployeeName,'+
                ' sa_SaleContractHistory.chgEmployeeCode+'' ''+Employee.EmployeeName As EmployeeB,'+
                ' sa_SaleContractHistory.ChgType,'+
                ' sa_SaleContractHistory.chgtime'+
        ' from  sa_SaleContractHistory'+
        ' join Customer on sa_SaleContractHistory.CustomerCode=Customer.CUSTOMERCode'+
        ' join Currency on sa_SaleContractHistory.CurrencyCode=Currency.CURRENCYCode'+
        ' join Employee on sa_SaleContractHistory.CreateEmployeeCode=Employee.EmployeeCode';
  OrderByFields:=' chgtime,CustomerCode ';
  Frm_Sys_Condition:=TFrm_Sal_Qry_ChgInfoSaleContractH_C.Create(self);
  Act_Filter.Execute;
  conditionuserDefine:=condition;
  Frm_Sys_Condition:=nil;
end;


end.