untvehicle_m.pas

用delphi编写的数据库管理软件

unit untVehicle_M;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BaseInfo_M, StdCtrls, Mask, wwdbedit, ExtCtrls, wwdblook,
  wwcheckbox, DBCtrlsEh, Buttons, DB, DBClient, ExtDlgs;

type
  TfrmVehicle_M = class(TfrmBaseInfo_M)
    Label11: TLabel;
    wwDBEdit12: TwwDBEdit;
    Label3: TLabel;
    wwDBEdit2: TwwDBEdit;
    Label4: TLabel;
    wwDBEdit3: TwwDBEdit;
    wwDBEdit4: TwwDBEdit;
    Label5: TLabel;
    Label6: TLabel;
    wwDBEdit5: TwwDBEdit;
    Label7: TLabel;
    wwDBEdit7: TwwDBEdit;
    Label8: TLabel;
    Label9: TLabel;
    wwDBEdit8: TwwDBEdit;
    wwDBEdit10: TwwDBEdit;
    Label10: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    wwDBEdit15: TwwDBEdit;
    wwDBEdit16: TwwDBEdit;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    wwDBEdit18: TwwDBEdit;
    wwDBEdit19: TwwDBEdit;
    wwDBEdit20: TwwDBEdit;
    Label20: TLabel;
    Label21: TLabel;
    Label22: TLabel;
    wwDBEdit21: TwwDBEdit;
    wwDBEdit22: TwwDBEdit;
    wwDBEdit23: TwwDBEdit;
    Label23: TLabel;
    Label24: TLabel;
    Label25: TLabel;
    wwDBEdit24: TwwDBEdit;
    wwDBEdit25: TwwDBEdit;
    wwDBEdit26: TwwDBEdit;
    Label26: TLabel;
    Label27: TLabel;
    DBDateTimeEditEh1: TDBDateTimeEditEh;
    DBDateTimeEditEh2: TDBDateTimeEditEh;
    Label28: TLabel;
    DBDateTimeEditEh3: TDBDateTimeEditEh;
    DBDateTimeEditEh4: TDBDateTimeEditEh;
    Label29: TLabel;
    Label30: TLabel;
    Label31: TLabel;
    wwDBEdit6: TwwDBEdit;
    wwDBEdit17: TwwDBEdit;
    Label32: TLabel;
    wwCheckBox1: TwwCheckBox;
    Label33: TLabel;
    wwDBEdit27: TwwDBEdit;
    wwDBLookupCombo1: TwwDBLookupCombo;
    DBDateTimeEditEh5: TDBDateTimeEditEh;
    wwDBLookupCombo2: TwwDBLookupCombo;
    wwDBLookupCombo3: TwwDBLookupCombo;
    SpeedButton1: TSpeedButton;
    CDSType: TClientDataSet;
    CDSEmployee: TClientDataSet;
    OpenPictureDialog1: TOpenPictureDialog;
    CDSTypefid: TAutoIncField;
    CDSTypefCode: TWideStringField;
    CDSTypefName: TWideStringField;
    CDSTypefRemark: TWideStringField;
    CDSEmployeefID: TAutoIncField;
    CDSEmployeefCode: TWideStringField;
    CDSEmployeefName: TWideStringField;
    CDSEmployeefDeptCode: TWideStringField;
    CDSEmployeefDriveID: TWideStringField;
    CDSEmployeefSex: TWideStringField;
    CDSEmployeefPosition: TWideStringField;
    CDSEmployeefAddress: TWideStringField;
    CDSEmployeefEmail: TWideStringField;
    CDSEmployeefTel: TWideStringField;
    CDSEmployeefMobile: TWideStringField;
    CDSEmployeefBP: TWideStringField;
    CDSEmployeefDegree: TWideStringField;
    CDSEmployeefCollege: TWideStringField;
    CDSEmployeefBirthAddress: TWideStringField;
    CDSEmployeefBirthday: TDateTimeField;
    CDSEmployeefInTime: TDateTimeField;
    CDSEmployeefOutTime: TDateTimeField;
    CDSEmployeefMoney: TBCDField;
    CDSEmployeefStatus: TBooleanField;
    CDSEmployeefNotes: TWideStringField;
    CDSEmployeefPicture: TWideStringField;
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmVehicle_M: TfrmVehicle_M;

implementation

uses untVehicle, DataProcess;

{$R *.dfm}

procedure TfrmVehicle_M.FormCreate(Sender: TObject);
begin
  inherited;
  GetsqlData(CDSType,'tSafeType','Fid',' fid>0 ',10);
  GetsqlData(CDSEmployee,'temployee','Fid',' fid>0 ',10);
  Maintable:='tVehicle';
  MasterField:='fcode';
  ParentForm:=frmVehicle;
end;

procedure TfrmVehicle_M.SpeedButton1Click(Sender: TObject);
var
sImgFile:String;
begin
  inherited;
  if OpenPictureDialog1.Execute then
  begin
  sImgFile:=OpenPictureDialog1.FileName ;
  Dataset.FieldByName('fPicture').AsString:=sImgFile;
  end
end;

end.