easygas_mangtick.pas

EasyGasDpr 瓶装液化气 钢瓶 SQL,用户名：SYSTEM 密码：空

unit EASYGAS_MANGTICK;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, EASY_GASMAIN, DBGridEh, StdCtrls, Mask, DBCtrlsEh, DBLookupEh,
  DB, ADODB, ExtCtrls, DBCtrls, Buttons;

type
  TMANGTICK = class(TForm)
    DBLookupComboboxEh1: TDBLookupComboboxEh;
    TYPES: TDataSource;
    MANGTYPE: TADODataSet;
    MANGTICK: TADODataSet;
    MANGS: TDataSource;
    DBText1: TDBText;
    Label1: TLabel;
    Bevel1: TBevel;
    Label2: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DBComboBoxEh1: TDBComboBoxEh;
    Label3: TLabel;
    DBText2: TDBText;
    DBText3: TDBText;
    Label4: TLabel;
    DBText4: TDBText;
    Label5: TLabel;
    B1: TADODataSet;
    YH: TADODataSet;
    YHS: TDataSource;
    DBLookupComboboxEh2: TDBLookupComboboxEh;
    Bevel2: TBevel;
    BUTTLE: TADODataSet;
    COMM: TADOCommand;
    procedure MANGTICKNewRecord(DataSet: TDataSet);
    procedure DBLookupComboboxEh1Change(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure DBLookupComboboxEh2Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    BOTTLE_No:LongInt;
  end;

var
  MANGTICK: TMANGTICK;

implementation

{$R *.dfm}

procedure TMANGTICK.MANGTICKNewRecord(DataSet: TDataSet);
begin
  With Dataset do
  Begin
    Edit;
    Fieldbyname('钢瓶编码').AsInteger:=BOTTLE_No;
    Fieldbyname('操作员').AsString:=USER.Name;
    Fieldbyname('操作日期').AsDateTime:=Now;
  end;
end;

procedure TMANGTICK.DBLookupComboboxEh1Change(Sender: TObject);
begin
  With MANGTICK do
  Begin
    Edit;
    Fieldbyname('操作值').AsCurrency:=MANGTYPE.fieldbyname('管理收费').AsCurrency;
    Fieldbyname('有效天数').AsInteger:=MANGTYPE.Fieldbyname('有效天数').AsInteger;
    Fieldbyname('归属').AsString:=MANGTYPE.Fieldbyname('归属').AsString;
  end;
end;

procedure TMANGTICK.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=VK_RETURN then Postmessage(TWincontrol(Sender).handle,WM_KEYDOWN,VK_TAB,0);
end;

procedure TMANGTICK.DBLookupComboboxEh2Change(Sender: TObject);
begin
  With MANGTICK do
  Begin
    Edit;
    Fieldbyname('银行').AsCurrency:=YH.fieldbyname('序号').asinteger;
  end;

end;

end.