inv_itemsalesum.pas

一个MRPII系统源代码版本

unit Inv_ItemSaleSum;

Interface

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

Type
  TFrm_Inv_ItemSaleSum = Class(TFrm_Base_Qry)
    AdoQry_MainItemCode: TStringField;
    AdoQry_MainItemName: TStringField;
    AdoQry_MainItemCodeName: TStringField;
    AdoQry_MainUomName: TStringField;
    AdoQry_MainInvBillQty: TFloatField;
    AdoQry_MainInvBillSalePrice: TFloatField;
    AdoQry_MainInvBillSaleAmount: TBCDField;
  private
    { Private declarations }
  public
    { Public declarations }
    procedure InitForm(AdOConnection:TAdOConnection;ShowExtendColumn:Boolean);Override;
  end;

var
  Frm_Inv_ItemSaleSum: TFrm_Inv_ItemSaleSum;

implementation

uses Inv_ItemSaleSum_C;

{$R *.DFM}

{ TFrm_Inv_ItemSaleSum }

procedure TFrm_Inv_ItemSaleSum.InitForm(AdOConnection: TAdOConnection;
  ShowExtendColumn: Boolean);
begin
  AmountFields:='InvBillSaleAmount,';
  PriceFields:='InvBillSalePrice,';
  if Param1='0203' then
  begin
    Caption:='材料分物料销售汇总';
    Pnl_Title.Caption:='材料分物料销售汇总';  
    ConditionUserDefine:='InvOutBill.BillTypeCode='''+Param1+''''
    +' And InvOutBill.InvBillWHChck=1';
  end
  else if Param1='0204' then
  begin
    ConditionUserDefine:='InvOutBill.BillTypeCode='''+Param1+''''
    +' And InvOutBill.InvBillWHChck=1';
    if Param2='NoMps' then
    begin
      ConditionUserDefine:=ConditionUserDefine
        +'And InvOutBill.MpsSale=0';
      Caption:='非主计划分物料销售汇总';
      Pnl_Title.Caption:='非主计划分物料销售汇总';
    end
    else
    begin
      ConditionUserDefine:=ConditionUserDefine
        +'And InvOutBill.MpsSale=1';
      Caption:='主计划分物料销售汇总';
      Pnl_Title.Caption:='主计划分物料销售汇总';
    end;
  end;
  inherited;
  SelectFromSQL:='Select InvOutBillLine.ItemCode'
    +',Item.ItemName'
    +',InvOutBillLine.ItemCode+'' ''+Item.ItemName As ItemCodeName'
    +',Uom.UomName'
    +',Sum(InvOutBillLine.InvBillQty) As InvBillQty'
    +',Case When Sum(InvOutBillLine.InvBillQty)=0 then 0'
    +' Else Sum(RealSalePrice.InvBillSaleAmount)/Sum(InvOutBillLine.InvBillQty)'
    +' end As InvBillSalePrice'
    +',Sum(RealSalePrice.InvBillSaleAmount) As InvBillSaleAmount'
    +' From InvOutBillLine'
    +' Join InvOutBill on InvOutBillLine.InvBillId=InvOutBill.InvBillId'
    +' Join Item on InvOutBillLine.ItemCode=Item.ItemCode'
    +' Join Uom on Item.UomCode=Uom.UomCode'
    +' Join RealSalePrice on InvOutBillLine.InvBillId=RealSalePrice.InvBillId'
    +' And InvOutBillLine.InvBillLineNo=RealSalePrice.InvBillLineNo';
  OrderByFields:='ItemCodeName';
  GroupByFields:='InvOutBillLine.ItemCode,Item.ItemName,Uom.UomName';
  Frm_Sys_Condition:=TFrm_Inv_ItemSaleSum_C.Create(Self);
  Act_Filter.Execute;
end;

end.