Contents

Views 62014 Comment 0
?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print
?

Shortcut

PrevPrev Article

NextNext Article

Larger Font Smaller Font Up Down Go comment Print
DefSng A-Z
Dim a(10) As String, b(10), c(10), d(10), e(10) As String, f(10), g(10), h(10), pc, tmp As Variant, a1(10) As String, b1(10), c1(10), d1(10)
Private Sub Command1_Click()
    pc = pc + 1
    a(pc) = Text1.Text
    b(pc) = Text2.Text
    c(pc) = Text3.Text
    d(pc) = Text4.Text

    a1(pc) = Text1.Text
    b1(pc) = Text2.Text
    c1(pc) = Text3.Text
    d1(pc) = Text4.Text

    Text1.Text = ""
    Text2.Text = ""
    Text3.Text = ""
    Text4.Text = ""

    Text1.SetFocus
End Sub

Private Sub Command2_Click()
    For i = 1 To pc - 1
        For j = i + 1 To pc
            If a(i) < a(j) Then
                tmp = a(i): a(i) = a(j): a(j) = tmp
                tmp = b(i): b(i) = b(j): b(j) = tmp
                tmp = c(i): c(i) = c(j): c(j) = tmp
                tmp = d(i): d(i) = d(j): d(j) = tmp
            End If
        Next j
    Next i

    For i = 1 To pc
        Select Case UCase(a(i))
            Case "A1": e(i) = "영업 1팀": z = 0.21
            Case "A2": e(i) = "영업 2팀": z = 0.23
            Case "A3": e(i) = "영업 3팀": z = 0.27
            Case "A4": e(i) = "영업 4팀": z = 0.29
            Case "A5": e(i) = "영업 5팀": z = 0.28
            Case "A6": e(i) = "영업 6팀": z = 0.25
        End Select

        f(i) = b(i) + c(i) + d(i)
        g(i) = b(i) * 15000 + c(i) * 30000 + d(i) * 25000

        h(i) = g(i) * z

        total = total + f(i)
    Next


    Form1.Hide

    Form2.Show
    Form2.Print "비번호:333"
    Form2.Print ""
    Form2.Print "부서코드", "부서명", "판매수량", "판매금액", "고과점수"

    For i = 1 To pc
        Form2.Print a(i), e(i), f(i), g(i), h(i)
    Next
    
    Form2.Print "전체 판매수량"; total
    Form2.Print ""
    Form2.Print ""
    Form2.Print "입력자료"
    
    For i = 1 To pc
        Form2.Print a1(i), b1(i), c1(i), d(i)
    Next
    
End Sub


?

List of Articles
No. Category Subject Author Date Views
15 Develop OPT와 CAS에 대한 자료.. (교수님 메일로 보내드린 자료..) file hooni 2013.04.23 15061
14 Develop OpenGL 강좌 사이트 모음 hooni 2013.04.23 12413
13 Develop OGNL(Object Graph Navigation Language) hooni 2013.04.23 16956
12 Develop macOS에 node, npm 설치하기 (homebrew) file hooni 2021.11.06 4547
11 Develop Mac OS 에 Jenkins 설치하기 (Homebrew) 2 file hooni 2017.03.15 13251
10 Develop Laravel 5 Failed opening required bootstrap/../vendor/autoload.php hooni 2018.01.24 6117
9 Develop JSON, BSON 변환 file hooni 2013.04.23 13133
8 Develop How to Test SMTP AUTH using Telnet hooni 2018.04.05 6185
7 Develop GPL, AGPL, MPL,.. 한눈에 보는 오픈소스SW 라이선스 file hooni 2014.10.14 2062
6 Develop git 브런치 배우기 (링크) hooni 2013.07.09 22079
5 Develop GCM 사용하기 3 (JSP로 GCM 푸시 서버 만들기) 4 file hooni 2013.07.06 27129
4 Develop GCM 사용하기 2 (단말에 GCM 구현하기) file hooni 2013.07.06 24652
Board Pagination Prev 1 ... 62 63 64 65 66 67 68 69 70 71 Next
/ 71