inv_qry_invcancelmps.pas

一个MRPII系统源代码版本

unit Inv_Qry_InvCancelMps;

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_Inv_Qry_InvCancelMps = Class(TFrm_Base_Qry)
    AdoQry_MainMpsID: TIntegerField;
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MainItemCodeName: TStringField;
    AdoQry_MainInvBillLineNo: TStringField;
    AdoQry_MainCancelQty: TFloatField;
    AdoQry_MainInvBillno: TStringField;
    procedure FormDestroy(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
  end;

var
  Frm_Inv_Qry_InvCancelMps: TFrm_Inv_Qry_InvCancelMps;

implementation

{$R *.DFM}

{ TFrm_Inv_Qry_InvCancelMps }

procedure TFrm_Inv_Qry_InvCancelMps.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  inherited;
  //AmountFields:='CancelQty,';
  SelectFromSQL:=' select Inv_InvCancelMps.MpsID,'+
                        ' InvInBillline.ItemCode,'+
                        ' Item.ItemName,'+
                        ' InvInBillline.ItemCode+'' ''+Item.ItemName as ItemCodeName,'+
                        ' InvInBill.InvBillno,'+
                        ' Inv_InvCancelMps.InvBillLineNo,'+
                        ' Inv_InvCancelMps.CancelQty '+
                 ' from Inv_InvCancelMps left join InvInBillline '+
                        ' on Inv_InvCancelMps.InvBillid=InvInBillline.InvBillid '+
                        ' and Inv_InvCancelMps.InvBilllineNo=InvInBillline.InvBilllineNo '+
                 ' left join InvInBill on InvInBill.InvBillid=InvInBillline.InvBillid '+
                 ' left join Item on InvInBillline.ItemCode=Item.ItemCode';
  OrderByFields:='Mpsid';
  Getdata;
end;

procedure TFrm_Inv_Qry_InvCancelMps.FormDestroy(Sender: TObject);
begin
  inherited;
  Frm_Inv_Qry_InvCancelMps:=nil;

end;

end.