ckitemadd_unit.pas

餐营的数据核算,模拟入库,出库,库存.对餐营的流程详细叙述

unit CKITEMADD_Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBGridEh, StdCtrls, Buttons, DBCtrlsEh, Mask, DBLookupEh,
  TFlatGroupBoxUnit, TFlatSpeedButtonUnit, DB, ADODB, Tabenter;

type
  TCKITEMADD_Form = class(TForm)
    FlatSpeedButton1: TFlatSpeedButton;
    FlatSpeedButton2: TFlatSpeedButton;
    FlatGroupBox1: TFlatGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBLookupComboboxEh1: TDBLookupComboboxEh;
    DBEditEh1: TDBEditEh;
    DBEditEh2: TDBEditEh;
    DBEditEh3: TDBEditEh;
    DBEditEh4: TDBEditEh;
    DBEditEh5: TDBEditEh;
    CKDITEMFINDADOQ: TADOQuery;
    kEnterAsTab1: TkEnterAsTab;
    Label7: TLabel;
    DBEditEh6: TDBEditEh;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormDestroy(Sender: TObject);
    procedure FlatSpeedButton2Click(Sender: TObject);
    procedure DBLookupComboboxEh1CheckDrawRequiredState(Sender: TObject;
      var DrawState: Boolean);
    procedure FlatSpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  CKITEMADD_Form: TCKITEMADD_Form;

implementation

uses DMUnit;

{$R *.dfm}

procedure TCKITEMADD_Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
Action:=cafree;
end;

procedure TCKITEMADD_Form.FormDestroy(Sender: TObject);
begin
  CKITEMADD_FORM:=nil;
end;

procedure TCKITEMADD_Form.FlatSpeedButton2Click(Sender: TObject);
begin
DM.CKDP_ADOT.Cancel;
Close;
end;

procedure TCKITEMADD_Form.DBLookupComboboxEh1CheckDrawRequiredState(
  Sender: TObject; var DrawState: Boolean);
begin
  if Trim(DBLookupComboboxEh1.Text)='' then Exit;
  with CKDITEMFINDADOQ DO
  begin
    Close;
    SQL.Clear;
    SQL.Add(' SELECT IU.NUIT_NAME,II.ITEM_UNIT,ITS.SORTNAME,II.ITEM_SOTR,II.ITEM_PRICE FROM ITEM_ITEM II ');
    SQL.Add(' LEFT JOIN ITEM_UNIT IU ON II.ITEM_UNIT=IU.NUIT_ID ');
    SQL.Add(' LEFT JOIN ITEM_SORT ITS ON II.ITEM_SOTR=ITS.SORTID ');
    SQL.Add(' WHERE II.ITEM_NAME='''+DBLookupComboboxEh1.Text+'''');
    OPEN;
  end;
   DBEditEh1.Text:=CKDITEMFINDADOQ.Fields[2].AsString;
   DBEditEh2.Text:=CKDITEMFINDADOQ.Fields[0].AsString;
   DBEditEh3.Text:=CKDITEMFINDADOQ.Fields[4].AsString;
end;

procedure TCKITEMADD_Form.FlatSpeedButton1Click(Sender: TObject);
begin
  if DM.CKDP_ADOT.State in [DSINSERT,DSEDIT] then
     //DM.CKDP_ADOT.FieldByName('ITEM_MON').AsCurrency:=DM.CKDP_ADOT.FieldbyName('ITEM_PRICE').AsCurrency*DM.CKDP_ADOT.FieldbyName('ITEM_NUM').AsFloat;
     DM.CKDP_ADOT.FieldByName('ITEM_MON').AsCurrency:=StrtoCurr(DBEditEh3.Text)*StrtoCurr(DBEditEh4.Text);
     DM.CKDP_ADOT.Post;
     CKITEMADD_Form.Close;
end;

end.