workers.pas

用户名：SYSTEM 密码：空 第一次运行请先恢复数据库 DATABASE 到SQL服务器

unit Workers;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BaseEditForm, ImgList, DB, Grids, Wwdbigrd, Wwdbgrid, ExtCtrls,
  ComCtrls, StdCtrls, Buttons,DataMod, ADODB, DBCtrls, wwdblook,
  wwdbdatetimepicker, Mask,jpeg,basemainform;

type
  TfWorkers = class(TfBaseEditForm)
    ADOQuery1: TADOQuery;
    ADOQuery1cWorkerNo: TStringField;
    ADOQuery1cWorkerName: TStringField;
    ADOQuery1cCardNo: TStringField;
    ADOQuery1cSex: TStringField;
    ADOQuery1dBirthDay: TDateTimeField;
    ADOQuery1cNativePlace: TStringField;
    ADOQuery1cFamilyAddress: TStringField;
    ADOQuery1cDepartmentNo: TStringField;
    ADOQuery1dInDate: TDateTimeField;
    ADOQuery1cUser: TStringField;
    ADOQuery1tUpdateTime: TDateTimeField;
    ADOQuery1cAction: TStringField;
    ADOQuery2: TADOQuery;
    Label2: TLabel;
    DBEdit1: TDBEdit;
    Label3: TLabel;
    DBEdit2: TDBEdit;
    Label4: TLabel;
    DBEdit3: TDBEdit;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit6: TDBEdit;
    Label8: TLabel;
    DBEdit7: TDBEdit;
    Label9: TLabel;
    Label10: TLabel;
    DBRadioGroup1: TDBRadioGroup;
    wwDBDateTimePicker1: TwwDBDateTimePicker;
    wwDBDateTimePicker2: TwwDBDateTimePicker;
    ADOQuery1txtResume: TMemoField;
    Label5: TLabel;
    DBMemo1: TDBMemo;
    ADOTable1: TADOTable;
    ADOQuery1DepartName: TStringField;
    DBEdit4: TDBEdit;
    wwDBLookupCombo1: TwwDBLookupCombo;
    ADOQuery3: TADOQuery;
    Label12: TLabel;
    DataSource1: TDataSource;
    Bevel2: TBevel;
    Label13: TLabel;
    Label14: TLabel;
    DBImage1: TDBImage;
    BitBtn1: TBitBtn;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    BitBtn2: TBitBtn;
    Edit1: TEdit;
    Edit2: TEdit;
    Label18: TLabel;
    Label19: TLabel;
    BitBtn3: TBitBtn;
    Label20: TLabel;
    Edit3: TEdit;
    Label21: TLabel;
    DBEdit5: TDBEdit;
    ADOQuery1cPrincipalShip: TStringField;
    Label11: TLabel;
    DBEdit8: TDBEdit;
    ADOQuery1cIDCardNO: TStringField;
    Label22: TLabel;
    DBText1: TDBText;
    ADOQuery1dLeaveDate: TDateTimeField;
    ADOQuery1lLeaved: TBooleanField;
    ADOQuery1tLeaveWhys: TMemoField;
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure DataSourceStateChange(Sender: TObject);
    procedure ADOQuery1AfterInsert(DataSet: TDataSet);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure DBEdit1Exit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fWorkers: TfWorkers;

implementation

{$R *.dfm}

procedure SavePicture(Const DataSet:TDataSet;const FileName: String);
var
   MemStrm:TMemoryStream;
   BlobStrm:Tstream;
   ExtName:String;
   temJepgImage:TJpegImage;
   temBitmap:TBitmap;
begin
          MemStrm:=TmemoryStream.Create;
          Extname:=UpperCase(ExtractFileExt(FileName));
          If StrPos('.BMP*.JPG*.JEPG',Pchar(ExtName))=Nil Then Exit;
          If ExtName='.BMP' Then
              MemStrm.LoadFromFile(FileName)
          Else   begin
                temJepgImage:=TJpegImage.Create;
               temBitmap:=TBitmap.Create;
               temJepgImage.LoadFromFile(FileName);
               temBitMap.Assign(temJepgImage);
               temBitMap.SaveToStream(MemStrm);
               temJepgImage.Free ;
               temBitMap.free;
          end;
          DataSet.edit;
          BlobStrm:= DataSet.CreateBlobStream( DataSet.FieldByName('imgPhoto'),bmReadWrite);
          Memstrm.SaveToStream(BlobStrm);
          BlobStrm.Free ;
          MemStrm.Free;
          DataSet.Post;
end;
procedure TfWorkers.FormCreate(Sender: TObject);
begin
  inherited;
  self.FirstFocusControl :=dbedit1;
end;

procedure TfWorkers.BitBtn1Click(Sender: TObject);
begin
  if AdoQuery1.State in [dsInsert,dsEdit] then begin
     application.MessageBox('叫