2017年4月13日 星期四

程設丙級 第二站 生分證

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

程設丙級 第二站 08

Public Class Form1
    Dim d(100, 6)
    Dim rno = 0
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
        '讀檔案
        rdata()
        '處理
        sp1()
        '輸出
        wdata()
    End Sub
    Sub rdata()
        FileOpen(1, "C:/丙設磁片/940308.SM", OpenMode.Input)
        Do Until EOF(1)
            rno += 1
            Input(1, d(rno, 1)) : Input(1, d(rno, 2)) : Input(1, d(rno, 3)) : Input(1, d(rno, 4)) : Input(1, d(rno, 5))

        Loop
        FileClose()
    End Sub
    Sub sp1()
        Dim num, denum As Integer '分子/分母
        Dim b, a, y, x As Integer

        For i = 1 To rno
            b = d(i, 1)
            a = d(i, 2)
            y = d(i, 4)
            x = d(i, 5)
            Select Case d(i, 3)
                Case "+"
                    num = (b * x + a * y)
                    denum = a * x
                Case "-"
                    num = (b * x - a * y)
                    denum = a * x
                Case "*"
                    num = b * y
                    denum = a * x
                Case "/"
                    num = b * x
                    denum = a * y
            End Select
            '約分
            Dim g = GCD(num, denum)
            num = num / g
            denum = denum / g
            Dim m3 = num & "/" & denum
            If denum = 1 Then m3 = num
            If denum = 0 Then m3 = 0
            d(i, 6) = m3
        Next

    End Sub
    Function GCD(a, b)
        If b = 0 Then
            Return a
        Else
            Return GCD(b, a Mod b)
        End If
    End Function

    Sub wdata()
        DGV.Columns.Add("VALUE1", "VALUE1")
        DGV.Columns.Add("OP", "OP")
        DGV.Columns.Add("VALUE2", "VALUE2")
        DGV.Columns.Add("ANSWER", "ANSWER")
        For i = 1 To rno
            DGV.Rows.Add(d(i, 1) & "/" & d(i, 2), d(i, 3), d(i, 4) & "/" & d(i, 5), d(i, 6))
        Next
        DGV.AllowUserToAddRows = False
        DGV.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
    End Sub


End Class