unit uServer;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ScktComp, StdCtrls, ExtCtrls, Buttons, ComCtrls, Grids, DB,IniFiles,
  ADODB, IdBaseComponent, IdComponent, IdTCPServer, IdTimeServer, Psock,
  NMFngr;

type
  TFr_Server = class(TForm)
    ServerSocket1: TServerSocket;
    GroupBox1: TGroupBox;
    Panel1: TPanel;
    Label1: TLabel;
    Ed_IP: TEdit;
    Ed_port: TEdit;
    Label2: TLabel;
    StatusBar1: TStatusBar;
    Btn_SetPort: TSpeedButton;
    GroupBox2: TGroupBox;
    StringGrid1: TStringGrid;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    ListBox1: TListBox;
    Panel2: TPanel;
    StringGrid2: TStringGrid;
    Btn_Control: TSpeedButton;
    Memo1: TMemo;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    DateTimePicker1: TDateTimePicker;
    Label3: TLabel;
    IdTimeServer1: TIdTimeServer;
    Btn_Search: TBitBtn;
    GroupBox3: TGroupBox;
    GroupBox4: TGroupBox;
    Label4: TLabel;
    Label5: TLabel;
    Ed_manaName: TLabeledEdit;
    Ed_manaPwd: TLabeledEdit;
    Btn_Server: TBitBtn;
    Ed_name: TLabeledEdit;
    Ed_pwd: TLabeledEdit;
    Btn_user: TBitBtn;
    Ed_ID: TLabeledEdit;
    CheckBox1: TCheckBox;
    Btn_clear: TBitBtn;
    Btn_del: TBitBtn;
    NMFinger1: TNMFinger;
    procedure ServerSocket1ClientRead(Sender: TObject;
      Socket: TCustomWinSocket);
    procedure Btn_ControlClick(Sender: TObject);
    procedure ServerSocket1ClientConnect(Sender: TObject;
      Socket: TCustomWinSocket);
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Btn_SetPortClick(Sender: TObject);
    procedure Btn_ServerClick(Sender: TObject);
    procedure Btn_clearClick(Sender: TObject);
    procedure Btn_userClick(Sender: TObject);
    procedure Btn_delClick(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure Ed_manaNameKeyPress(Sender: TObject; var Key: Char);
    procedure Ed_manaPwdKeyPress(Sender: TObject; var Key: Char);
    procedure Ed_IDKeyPress(Sender: TObject; var Key: Char);
    procedure Ed_pwdKeyPress(Sender: TObject; var Key: Char);
    procedure Ed_nameKeyPress(Sender: TObject; var Key: Char);
    procedure Btn_SearchClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fr_Server: TFr_Server;
  MiniFile: TiniFile;
  procedure working;
  procedure worked;
  Function Search(tempID:string;tempstatus:string):bool;
  Function EmpLogin(tempID:string;tempPwd:string):bool;
  Function Temptime(TempID:string):String;
  Function ReadLog(tempdate:Tdate):string;
implementation

{$R *.dfm}

procedure TFr_Server.ServerSocket1ClientRead(Sender: TObject;
  Socket: TCustomWinSocket);
var Data:Tstringlist;
begin
   try
    Data:=Tstringlist.Create;
    Data.Text:=Socket.ReceiveText;
    if data.Text='' then exit;
    if data.Values['login']='login' then
       if EmpLogin(data.Values['user'],data.Values['password']) then
         begin
           socket.SendText('登錄成功');
           Listbox1.Items.Insert(0,'已經(jīng)通過編號：<'+data.Values['user']+'>員工的登錄');
         end
       else
         begin
           socket.SendText('登錄失敗');
           Listbox1.Items.Insert(0,'編號：<'+data.Values['user']+'>的員工登錄失敗');
         end;
    if data.Values['Close']='Close' then
       Listbox1.Items.Insert(0,'編號：<'+data.Values['user']+'>的員工已經(jīng)斷開'+datetimetostr(now));
    if data.Values['GoWork']='GoWork' then
      try
         if Search(data.Values['user'],'正在上班') then
            begin
              Socket.SendText('錯誤:你正在上班中!');
              Exit;
            end;
         with ADOQuery1 do
           begin
             Close;
             SQL.Clear;
             SQL.Add('insert into Server(員工編號,考勤日期,上班時間,上班狀態(tài))');
             SQL.Add('values('+''''+data.Values['user']+''''+','+''''+datetostr(date)+''''+','+''''+timetostr(time)+''''+','+'"正在上班"'+')');
             ExecSQL;
             Socket.SendText('完成上班操作!');
             Listbox1.Items.Insert(0,'編號：<'+data.Values['user']+'>的員工已經(jīng)上班'+datetimetostr(now));
           end;
      except
        Socket.SendText('添加考勤記錄時出錯');
      end;
    if data.Values['OverWork']='OverWork' then
      try
         if not Search(data.Values['user'],'正在上班') then
            begin
              Socket.SendText('錯誤:你沒有在上班中!');
              Exit;
            end;
         with ADOQuery1 do
           begin
             Close;
             SQL.Clear;
             SQL.Add('update Server set 下班時間='+''''+timetostr(time)+''''+','+'上班狀態(tài)='+'"上班結(jié)束"');
             SQL.Add(',合計時長='+''''+timetoStr(Time-Strtotime(Temptime(data.Values['user'])))+'''');
             SQL.Add('where 員工編號='+''''+data.Values['user']+'''');
             SQL.Add('and 上班狀態(tài)='+'"正在上班"');
             ExecSQL;
             Socket.SendText('完成下班操作!');
             Listbox1.Items.Insert(0,'編號：<'+data.Values['user']+'>的員工已經(jīng)下班'+datetimetostr(now));
           end;
      except
        Socket.SendText('下班考勤時出錯!');
      end;
   finally
    data.Free;
    working;
   end;
end;

procedure TFr_Server.Btn_ControlClick(Sender: TObject);
begin
  ServerSocket1.Port:=strtoint(Ed_port.Text);
  ServerSocket1.Active:=not ServerSocket1.Active;
  if serversocket1.Active then
     Listbox1.Items.Insert(0,'服務(wù)器已啟動：'+datetimetostr(now))
  else
     Listbox1.Items.Insert(0,'服務(wù)器已停止：'+datetimetostr(now))
end;

procedure TFr_Server.ServerSocket1ClientConnect(Sender: TObject;
  Socket: TCustomWinSocket);
begin
   Listbox1.Items.Insert(0,'有客戶機請求登錄'+datetimetostr(now));
end;

procedure TFr_Server.FormCreate(Sender: TObject);
begin
  if fileexists(extractfilepath(application.exename)+'Server.ini') then
  begin
  MiniFile:=Tinifile.Create(extractfilepath(application.exename)+'Server.ini');
      Ed_port.Text:=MiniFile.ReadString('SET','port','');
  MiniFile.Free;
  end;
  if not fileexists(extractfilepath(application.ExeName)+'Db\db_Server.mdb') then
     begin
     Btn_Control.Enabled:=False;
     Btn_SetPort.Enabled:=False;
     MessageBox(handle,Pchar('數(shù)據(jù)庫文件找不到,請檢查'+extractfilepath(application.exename)+'Db目錄下的數(shù)據(jù)庫文件'),'數(shù)據(jù)庫文件丟失',Mb_iconinformation);
     exit;
     end;
  ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+extractfilepath(application.ExeName)+'Db\db_Server.mdb'+';Persist Security Info=False';
  ADOConnection1.Connected:=True;
end;
procedure working;
var i,j:integer;
begin
  With Fr_server.ADOQuery1 do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select Server.員工編號,Employee.員工姓名 from Server,Employee');
       SQL.Add('where Server.上班狀態(tài)='+'"正在上班"');
       SQL.Add('and Server.員工編號=Employee.員工編號');
       open;
     end;
  with Fr_server do
    begin
     for i:=0 to Stringgrid1.RowCount do
        for j:=1 to 3 do
           stringgrid1.Cells[j,i]:='';
     if ADOQuery1.RecordCount>5 then Stringgrid1.RowCount:=ADOQuery1.RecordCount+1;
     if ADOQuery1.RecordCount>0 then
        for i:=1 to ADOQuery1.RecordCount do
           begin
              Stringgrid1.Cells[0,0]:='序號';
              stringgrid1.Cells[1,0]:='員工編號';
              Stringgrid1.Cells[2,0]:='員工姓名';
              Stringgrid1.Cells[0,i]:=inttostr(i);
              Stringgrid1.Cells[1,i]:=AdoQuery1.fieldbyname('員工編號').AsString;
              Stringgrid1.Cells[2,i]:=AdoQuery1.fieldbyname('員工姓名').AsString;
              if not ADOQuery1.Eof then ADOQuery1.Next;
           end;
    end;
end;
procedure worked;
var i,j:integer;
begin
  With Fr_server.ADOQuery1 do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select Server.員工編號,Employee.員工姓名,Server.考勤日期,Server.上班時間,Server.下班時間 from Server,Employee');
       SQL.Add('where Server.員工編號=Employee.員工編號');
       SQL.Add('order by Server.員工編號,Server.考勤日期');
       open;
     end;
  with Fr_server do
    begin
     for i:=0 to Stringgrid2.RowCount do
        for j:=1 to 6 do
           stringgrid2.Cells[j,i]:='';
     if ADOQuery1.RecordCount>5 then Stringgrid2.RowCount:=ADOQuery1.RecordCount+1;
     if ADOQuery1.RecordCount>0 then
        for i:=1 to ADOQuery1.RecordCount do
           begin
              Stringgrid2.Cells[0,0]:='序號';
              stringgrid2.Cells[1,0]:='員工姓名';
              Stringgrid2.Cells[2,0]:='考勤日期';
              Stringgrid2.Cells[3,0]:='上班時間';
              stringgrid2.Cells[4,0]:='下班時間';
              Stringgrid2.Cells[5,0]:='員工編號';
              Stringgrid2.Cells[0,i]:=inttostr(i);
              Stringgrid2.Cells[1,i]:=AdoQuery1.fieldbyname('員工姓名').AsString;
              Stringgrid2.Cells[2,i]:=AdoQuery1.fieldbyname('考勤日期').AsString;
              Stringgrid2.Cells[3,i]:=AdoQuery1.fieldbyname('上班時間').AsString;
              Stringgrid2.Cells[4,i]:=AdoQuery1.fieldbyname('下班時間').AsString;
              Stringgrid2.Cells[5,i]:=AdoQuery1.fieldbyname('員工編號').AsString;
              if not ADOQuery1.Eof then ADOQuery1.Next;
           end;
    end;
end;
procedure TFr_Server.FormShow(Sender: TObject);
begin
  Ed_ip.Text:=Nmfinger1.LocalIP;
  working;
end;
Function Search(tempID:string;tempstatus:string):bool;
var MADOQuery:TADOQuery;
begin
    MADOQuery:=TADOQuery.Create(Application);
    MADOQuery.Connection:=Fr_Server.ADOConnection1;
    try
       with MADOQuery do
         begin
           Close;
           SQL.Clear;
           SQL.Add('select * from Server');
           SQL.Add('where 上班狀態(tài)='+''''+tempstatus+'''');
           SQL.Add('and 員工編號='+''''+tempID+'''');
           Open;
         end;
       if MADOQuery.RecordCount>0 then result:=True
       else Result:=False;
    finally
      MADOQuery.Free;
    end;
end;
Function EmpLogin(tempID:string;tempPwd:string):bool;
var MADOQuery:TADOQuery;
begin
    MADOQuery:=TADOQuery.Create(Application);
    MADOQuery.Connection:=Fr_Server.ADOConnection1;
    try
       with MADOQuery do