frmundersafetystock.pas

物流供应链管理系统

unit frmUnderSafetyStock;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, DBClient, MConnect, SConnect, Grids, DBGrids, StdCtrls,
  Mask, DBCtrls, DataSetToExcel;

type
  TFormUnderSafetyStock = class(TForm)
    SocketConQuery: TSocketConnection;
    cdsQuery: TClientDataSet;
    DSQuery: TDataSource;
    cdsQueryBarCode: TWideStringField;
    cdsQueryName: TWideStringField;
    cdsQueryVendorId: TWideStringField;
    cdsQueryAmount: TLargeintField;
    cdsQueryMinOrder: TLargeintField;
    cdsQueryMaxOrde: TLargeintField;
    cdsQueryEOQ: TLargeintField;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    Button1: TButton;
    DataSetToExcel: TDataSetToExcel;
    ExcelDlg: TSaveDialog;
    Button3: TButton;
    cdsQuerySafetyStock: TLargeintField;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormUnderSafetyStock: TFormUnderSafetyStock;

implementation
uses untConfig, CommonFunc, qrQueryBelowSofetyStock, QueryGoodsBiz_TLB;
{$R *.dfm}

procedure TFormUnderSafetyStock.Button1Click(Sender: TObject);
begin
  if not VarIsNull(cdsQuery.Data) then
  begin
    if ExcelDlg.Execute then
      DataSetToExcel.SaveExcelToFile(AddExtToFileName(ExcelDlg.FileName,'.xls'),'sheet2');
  end    
  else
    LCShowMessage('没有数据!');
end;


procedure TFormUnderSafetyStock.Button3Click(Sender: TObject);
var
  LDlg: TQueryBelowSofetyStockQR;
begin
  if not VarIsNull(cdsQuery.Data) then
  begin
    LDlg := TQueryBelowSofetyStockQR.Create(nil);
    LDlg.PreviewModal;
    LDlg.Free;
  end
  else
    LCShowMessage('没有数据!');
end;

procedure TFormUnderSafetyStock.FormCreate(Sender: TObject);
begin
  SetSocketConnectionConnect(SocketConQuery);
end;

procedure TFormUnderSafetyStock.FormDestroy(Sender: TObject);
begin
  SocketConQuery.Close;
end;

procedure TFormUnderSafetyStock.FormShow(Sender: TObject);
var
  Lmts: ImtsQueryGoodsObjDisp;
  v: OleVariant;
begin
  Lmts := ImtsQueryGoodsObjDisp(SocketConQuery.GetServer);
  v := Lmts.QueryGoodsBelowSafetyStock;
  if not VarIsNull(v) then
    cdsQuery.Data := v;
end;

end.