Contents

Views 55134 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
13 Develop OGNL(Object Graph Navigation Language) hooni 2013.04.23 15727
12 Develop macOS에 node, npm 설치하기 (homebrew) file hooni 2021.11.06 1139
11 Develop Mac OS 에 Jenkins 설치하기 (Homebrew) 2 file hooni 2017.03.15 8091
10 Develop Laravel 5 Failed opening required bootstrap/../vendor/autoload.php hooni 2018.01.24 1652
9 Develop JSON, BSON 변환 file hooni 2013.04.23 11814
8 Develop How to Test SMTP AUTH using Telnet hooni 2018.04.05 1332
7 Develop GPL, AGPL, MPL,.. 한눈에 보는 오픈소스SW 라이선스 file hooni 2014.10.14 1146
6 Develop git 브런치 배우기 (링크) hooni 2013.07.09 20571
5 Develop GCM 사용하기 3 (JSP로 GCM 푸시 서버 만들기) 4 file hooni 2013.07.06 25315
4 Develop GCM 사용하기 2 (단말에 GCM 구현하기) file hooni 2013.07.06 23248
3 Develop DDay Memo 1.9.4 소스코드 secret hooni 2015.10.03 0
2 Develop Aspect Oriented Programming in Objective-C hooni 2015.05.18 674
Board Pagination Prev 1 ... 62 63 64 65 66 67 68 69 70 71 Next
/ 71