unit rydl;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ComCtrls, Grids, DBGrids, DB, ADODB;

type
  TfrmRydl = class(TForm)
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Button1: TButton;
    DTPLksj: TDateTimePicker;
    EdtLkyy: TEdit;
    Button2: TButton;
    Button3: TButton;
    ADOQuery1: TADOQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmRydl: TfrmRydl;

implementation

uses DM, grzl;

{$R *.dfm}

procedure TfrmRydl.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := caFree ;
end;

procedure TfrmRydl.Button3Click(Sender: TObject);
begin
  frmGrzl := TfrmGrzl.Create(nil);
  frmGrzl.FormStyle := fsNormal ;
  frmGrzl.Visible := False ;
  frmGrzl.ShowModal ;
end;

procedure TfrmRydl.Button2Click(Sender: TObject);
begin
  Close ;
end;

procedure TfrmRydl.Button1Click(Sender: TObject);
var
  strLkyy,strSQL:String ;
begin
  with DataModule1.ADODataSetJbzl do
  begin
    if trim(EdtLkyy.Text)='' then  //未輸入離開原因
    begin
      strLkyy :=  '未輸入';
    end
    else
    begin
      strLkyy :=  EdtLkyy.Text;
    end;
    if MessageDlg('是否提交調離記錄并終止所有的兼職?'+ #13#10 +
              '工號:' + FieldByName('JBZL_GH').AsString + #13#10 +
              '姓名:' + FieldByName('JBZL_Xm').AsString + #13#10 +
              '離開時間:' + DateToStr(DTPLksj.Date) + #13#10 +
              '離開原因:' + strLkyy ,mtWarning ,[mbYes,mbNo],MB_YESNO)
              = mrYes then                  //用戶確認提交記錄
    begin
      // 向基本資料中添加離開信息
      if DTPLksj.Date< FieldByName('JBZL_JBDWRQ').AsDateTime  then
      begin
        ShowMessage('離開本單位時間早于進本單位時間！');
        exit;
      end;
      try
        Edit;
        FieldByName('JBZL_Lkbdwsj').Value := DateToStr(DTPLksj.Date);
        FieldByName('JBZL_LKBDWYY').Value := EdtLkyy.Text;
        Post;
      except
        FieldByName('JBZL_Lkbdwsj').Value := Null ;
        FieldByName('JBZL_LKBDWYY').Value := Null ;
      end;
      Requery([]);
      //向兼職信息表中添加離開信息
      strSQL :=  'update jzxx set jzxx_zzsj = #' +
                DateToStr(DTPLksj.Date) +
                '# where trim(jzxx_gh) =''' +
                FieldByName('JBZL_GH').AsString + '''';
      ADOQuery1.SQL.Clear ;
      ADOQuery1.SQL.Add(strSQL);
      ADOQuery1.ExecSQL ;
    end;
  end;
end;

procedure TfrmRydl.FormCreate(Sender: TObject);
begin
  DTPLksj.MaxDate := now;
end;

end.