1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172
| Public Class MainWindow
Private MaxMainLevel As Byte = 85
Private IsInitialized As Boolean = False
Private Sub MainWindow_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'TODO*: cette ligne de code charge les données dans la table 'DataSet.Weapon'. Vous pouvez la déplacer ou la supprimer selon vos besoins.
Me.WeaponTableAdapter.Fill(Me.DataSet.Weapon)
Me.WeaponDataGridView.Sort(NamesDataGridViewTextBoxColumn12,
'TODO*: cette ligne de code charge les données dans la table 'DataSet.Jobs_List'. Vous pouvez la déplacer ou la supprimer selon vos besoins.
Me.Jobs_ListTableAdapter.Fill(Me.DataSet.Jobs_List)
Dim MainJob1View As DataView = New DataView(Me.DataSet.Jobs_List)
Me.MainJob1.DataSource = MainJob1View
Me.MainJob1.DisplayMember = "Jobs"
Dim MainJob2View As DataView = New DataView(Me.DataSet.Jobs_List)
Me.MainJob2.DataSource = MainJob2View
Me.MainJob2.DisplayMember = "Jobs"
Me.MainLevel1.Maximum = MaxMainLevel
Me.MainLevel2.Maximum = MaxMainLevel
Me.MainLevel1.Value = Me.MainLevel1.Maximum
Me.MainLevel2.Value = Me.MainLevel2.Maximum
Me.SubLevel1.Maximum = Math.Floor(Me.MainLevel1.Maximum / 2)
Me.SubLevel2.Maximum = Math.Floor(Me.MainLevel2.Maximum / 2)
Me.SubLevel1.Value = Math.Floor(Me.MainLevel1.Value / 2)
Me.SubLevel2.Value = Math.Floor(Me.MainLevel2.Value / 2)
Dim MainWeapon1View As DataView = New DataView(Me.DataSet.Weapon)
MainWeapon1View.RowFilter = "( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
MainWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
Me.MainWeapon1.DataSource = MainWeapon1View
Me.MainWeapon1.DisplayMember = "Names"
Me.MainWeapon1.ResetText()
Me.MainWeapon1.Tag = ""
Dim SubWeapon1View As DataView = New DataView(Me.DataSet.Weapon)
SubWeapon1View = New DataView(Me.DataSet.Weapon)
SubWeapon1View.RowFilter = "( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
SubWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
Me.SubWeapon1.DataSource = SubWeapon1View
Me.SubWeapon1.DisplayMember = "Names"
Me.SubWeapon1.ResetText()
Me.SubWeapon1.Tag = ""
Dim MainWeapon2View As DataView = New DataView(Me.DataSet.Weapon)
MainWeapon2View.RowFilter = "( [Equippable Jobs] LIKE '*" & Me.MainJob2.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel2.Value & "'"
MainWeapon2View.RowStateFilter = DataViewRowState.CurrentRows
Me.MainWeapon2.DataSource = MainWeapon2View
Me.MainWeapon2.DisplayMember = "Names"
Me.MainWeapon2.ResetText()
Me.MainWeapon2.Tag = ""
Dim SubWeapon2View As DataView = New DataView(Me.DataSet.Weapon)
SubWeapon2View = New DataView(Me.DataSet.Weapon)
SubWeapon2View.RowFilter = "( [Equippable Jobs] LIKE '*" & Me.MainJob2.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel2.Value & "'"
SubWeapon2View.RowStateFilter = DataViewRowState.CurrentRows
Me.SubWeapon2.DataSource = SubWeapon2View
Me.SubWeapon2.DisplayMember = "Names"
Me.SubWeapon2.ResetText()
Me.SubWeapon2.Tag = ""
IsInitialized = True
End Sub
'---------------------------------- SETUP 1 SECTION ------------------------------------------
'--- Equipments Sub-Section ---
Private Sub MainJob1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MainJob1.TextChanged
Dim SubJob1View As DataView = New DataView(Me.DataSet.Jobs_List)
SubJob1View.RowFilter = "Jobs <>'" & Me.MainJob1.Text & "'"
SubJob1View.RowStateFilter = DataViewRowState.CurrentRows
Me.SubJob1.DataSource = SubJob1View
Me.SubJob1.DisplayMember = "Jobs"
Me.SubJob1.Text = "No SubJob"
UpdateEquip1List()
End Sub
Private Sub MainLevel1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MainLevel1.ValueChanged
Me.SubLevel1.Maximum = Math.Floor(Me.MainLevel1.Value / 2)
UpdateEquip1List()
End Sub
Private Sub MainWeapon1_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles MainWeapon1.Leave
If Me.MainWeapon1.Text = "" Then
Me.MainWeapon1.Tag = Me.MainWeapon1.Text
UpdateEquip1List()
Else : Me.MainWeapon1.SelectAll()
End If
'TODO: Si le texte tapé lorsque l'utilisateur quitte la combobox n'existe pas
'dans la liste déroulante courante (ou ne déclenche pas l'event SelectedIndexChanged),
'alors SelectAll + afficher bulle d'erreur
End Sub
Private Sub SubWeapon1_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubWeapon1.Leave
If Me.SubWeapon1.Text = "" Then
Me.SubWeapon1.Tag = Me.SubWeapon1.Text
UpdateEquip1List()
Else : Me.SubWeapon1.SelectAll()
End If
'TODO: Si le texte tapé lorsque l'utilisateur quitte la combobox n'existe pas
'dans la liste déroulante courante (ou ne déclenche pas l'event SelectedIndexChanged),
'alors SelectAll + afficher bulle d'erreur
End Sub
Private Sub MainWeapon1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MainWeapon1.SelectedIndexChanged
If IsInitialized Then
IsInitialized = False
Dim SubWeapon1View = New DataView(Me.DataSet.Weapon)
SubWeapon1View.RowFilter = "NOT( Names = '" & Replace(Me.MainWeapon1.Text, "'", "''") & "' AND [Rare Tag] = 'True' ) AND ( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
SubWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
Me.SubWeapon1.DataSource = SubWeapon1View
Me.SubWeapon1.DisplayMember = "Names"
Me.MainWeapon1.Tag = Me.MainWeapon1.Text
Me.SubWeapon1.Text = Me.SubWeapon1.Tag.ToString
IsInitialized = True
End If
End Sub
Private Sub SubWeapon1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubWeapon1.SelectedIndexChanged
If IsInitialized Then
IsInitialized = False
Dim MainWeapon1View As DataView = New DataView(Me.DataSet.Weapon)
MainWeapon1View.RowFilter = "NOT( Names = '" & Replace(Me.SubWeapon1.Text, "'", "''") & "' AND [Rare Tag] = 'True' ) AND ( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
MainWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
Me.MainWeapon1.DataSource = MainWeapon1View
Me.MainWeapon1.DisplayMember = "Names"
Me.SubWeapon1.Tag = Me.SubWeapon1.Text
Me.MainWeapon1.Text = Me.MainWeapon1.Tag.ToString
IsInitialized = True
End If
End Sub
Private Sub UpdateEquip1List()
If IsInitialized Then
IsInitialized = False
Dim MainWeapon1View As DataView = New DataView(Me.DataSet.Weapon)
MainWeapon1View.RowFilter = "NOT( Names = '" & Replace(Me.SubWeapon1.Text, "'", "''") & "' AND [Rare Tag] = 'True' ) AND ( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
MainWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
MainWeapon1View.ApplyDefaultSort = True
Me.MainWeapon1.DataSource = MainWeapon1View
Me.MainWeapon1.DisplayMember = "Names"
If MainWeapon1View.Find(Me.MainWeapon1.Tag.ToString) > -1 Then
Me.MainWeapon1.Text = Me.MainWeapon1.Tag.ToString
Else
Me.MainWeapon1.ResetText()
Me.MainWeapon1.Tag = ""
End If
Dim SubWeapon1View As DataView = New DataView(Me.DataSet.Weapon)
SubWeapon1View = New DataView(Me.DataSet.Weapon)
SubWeapon1View.RowFilter = "NOT( Names = '" & Replace(Me.MainWeapon1.Text, "'", "''") & "' AND [Rare Tag] = 'True' ) AND ( [Equippable Jobs] LIKE '*" & Me.MainJob1.Text & "*' OR [Equippable Jobs] LIKE 'ALL' ) AND Level <= '" & Me.MainLevel1.Value & "'"
SubWeapon1View.RowStateFilter = DataViewRowState.CurrentRows
SubWeapon1View.ApplyDefaultSort = True
Me.SubWeapon1.DataSource = SubWeapon1View
Me.SubWeapon1.DisplayMember = "Names"
If SubWeapon1View.Find(Me.SubWeapon1.Tag.ToString) > -1 Then
Me.SubWeapon1.Text = Me.SubWeapon1.Tag.ToString
Else
Me.SubWeapon1.ResetText()
Me.SubWeapon1.Tag = ""
End If
IsInitialized = True
End If
End Sub
'End Class |
Partager