Public Class Form1
Dim d(100, 4) '資料
Dim rno As Integer '筆數
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
readdata()
For i = 1 To rno
If d(i, 4) = "" Then sp1(i)
If d(i, 4) = "" Then sp2(i)
If d(i, 4) = "" Then sp3(i)
Next
writedata()
End Sub
Sub readdata() ' 讀檔
FileOpen(1, "C:/丙設磁片/940306.SM", OpenMode.Input)
rno = 0
Do Until EOF(1)
rno += 1
Input(1, d(rno, 1)) : Input(1, d(rno, 2)) : Input(1, d(rno, 3))
Loop
FileClose()
End Sub
Sub writedata() '輸出
'加欄
DGV.Columns.Add("ID NOM", "ID NOM")
DGV.Columns.Add("NAME", "NAME")
DGV.Columns.Add("SEX", "SEX")
DGV.Columns.Add("ERROR", "ERROR")
'加入列
For i = 1 To rno
DGV.Rows.Add(d(i, 1), d(i, 2), d(i, 3), d(i, 4))
Next
'調整
DGV.AllowUserToAddRows = False
DGV.Columns(2).Width = 50
DGV.Columns(3).Width = 150
DGV.Sort(DGV.Columns(0), System.ComponentModel.ListSortDirection.Ascending)
End Sub
Sub sp1(i) 'FORMAT ERROR
If d(i, 1) Like "[A-Z]#########" Then Else d(i, 4) = "FORMAT ERROR"
End Sub
Sub sp2(i) 'SEX CODE ERROR
Dim sex As String = Mid(d(i, 1), 2, 1) & d(i, 3)
If sex = "1M" Or sex = "2F" Then Else d(i, 4) = "SEX CODE ERROR"
End Sub
Sub sp3(i) 'CHECK SUM ERROR。
Dim id As String = "ABCDEFGHJKLMNPQRSTUVXYWZIO"
Dim X1X2 As Integer = InStr(id, Mid(d(i, 1), 1, 1)) + 9
Dim X1 = X1X2 \ 10
Dim X2 = X1X2 Mod 10
Dim d1 As Integer = Mid(d(i, 1), 2, 1)
Dim d2 As Integer = Mid(d(i, 1), 3, 1)
Dim d3 As Integer = Mid(d(i, 1), 4, 1)
Dim d4 As Integer = Mid(d(i, 1), 5, 1)
Dim d5 As Integer = Mid(d(i, 1), 6, 1)
Dim d6 As Integer = Mid(d(i, 1), 7, 1)
Dim d7 As Integer = Mid(d(i, 1), 8, 1)
Dim d8 As Integer = Mid(d(i, 1), 9, 1)
Dim d9 As Integer = Mid(d(i, 1), 10, 1)
Dim Y = X1 + 9 * X2 + 8 * d1 + 7 * d2 + 6 * d3 + 5 * d4 + 4 * d5 + 3 * d6 + 2 * d7 + d8 + d9
If Y Mod 10 <> 0 Then d(i, 4) = "CHECK SUM ERROR"
End Sub
End Class