VERSION 5.00
Begin VB.Form gjq_frmDelete 
   Caption         =   "按編號刪除員工"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   Begin VB.CommandButton cmdDelete 
      Caption         =   "按編號刪除"
      Height          =   495
      Left            =   1200
      TabIndex        =   1
      Top             =   1560
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Height          =   495
      Left            =   1200
      TabIndex        =   0
      Top             =   480
      Width           =   1575
   End
End
Attribute VB_Name = "gjq_frmDelete"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub cmdDelete_Click()
If Text1.Text = "" Then
gjq_Response = MsgBox("請輸入要刪除員工的編號", vbOKOnly)
Exit Sub
End If


GJQ_strsql = "select * from t_employee where employeeid='" & Trim(Text1.Text) & "'"
Set Dblink.rs = Dblink.executeSQL(GJQ_strsql)
If Dblink.rs.RecordCount > 0 Then

GJQ_strsql = "delete from t_employee where employeeid='" & Trim(Text1.Text) & "'"

Call Dblink.executeSQL(GJQ_strsql)
GJQ_strsql = "select employeeid as 編號,empname as 姓名,sex as 性別,birthday as 生日,knowledge as 學歷,cardid as 身份證,department as 部門 from t_employee"
Set gjq_frmmaninfo.MSHFlexGrid1.DataSource = Dblink.executeSQL(GJQ_strsql)
Else
gjq_Response = MsgBox("無此編號員工", vbOKOnly)
End If

End Sub

Private Sub Form_Load()
Text1.Text = gjq_frmmaninfo.MSHFlexGrid1.TextMatrix(gjq_frmmaninfo.MSHFlexGrid1.Row, 1)
End Sub