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
| Private Sub AjoutRisque()
Dim q As New SubSonic.Query("TBrisque")
q.QueryType = SubSonic.QueryType.Insert
q.AddUpdateSetting("Theme", TbTheme.Text)
q.AddUpdateSetting("Risque", TbRisque.Text)
q.AddUpdateSetting("descripRisque", TbDescRisque.Text)
q.AddUpdateSetting("Niveau1RisqueBrut", CbRisqueBrut1.SelectedValue)
q.AddUpdateSetting("Niveau0RisqueBrut", CbRisqueBrut0.SelectedValue)
q.AddUpdateSetting("EnjeuEconomique", CInt(TbEnjEco.Text))
q.AddUpdateSetting("calculEnjeuEco", TbCalcEnjEco.Text)
If Me.RbActControleoui.Checked = True Then
q.AddUpdateSetting("activiteControle", RbActControleoui.Checked = True)
ElseIf Me.RbActControlenon.Checked = False Then
q.AddUpdateSetting("activiteControle", RbActControleoui.Checked = False)
End If
q.AddUpdateSetting("descripActControle", TbDescActControl.Text)
If Me.RbOkOui.Checked = True Then
q.AddUpdateSetting("OK", RbOkOui.Checked = True)
ElseIf Me.RbOkNon.Checked = False Then
q.AddUpdateSetting("OK", RbOkNon.Checked = True)
End If
If Me.RbMAJoui.Checked = True Then
q.AddUpdateSetting("Maj", RbMAJoui.Checked = True)
ElseIf Me.RbMAJnon.Checked = False Then
q.AddUpdateSetting("Maj", RbMAJnon.Checked = True)
End If
If Me.RbIncompletoui.Checked = True Then
q.AddUpdateSetting("Incomplet", RbIncompletoui.Checked = True)
ElseIf Me.RbIncompletnon.Checked = False Then
q.AddUpdateSetting("Incomplet", RbIncompletnon.Checked = True)
End If
If Me.RbInexistantoui.Checked = True Then
q.AddUpdateSetting("Inexistant", RbInexistantoui.Checked = True)
ElseIf Me.RbInexistantnon.Checked = False Then
q.AddUpdateSetting("Inexistant", RbInexistantnon.Checked = True)
End If
q.AddUpdateSetting("Niveau1RisqueNet", CbRisqueNet1.SelectedValue)
q.AddUpdateSetting("Niveau0RisqueNet", CbRisqueNet0.SelectedValue)
q.AddUpdateSetting("planAction", TbPlActions.Text)
q.AddUpdateSetting("Deadline", TbDeadline.Text)
q.AddUpdateSetting("Responsable", TbResponsable.Text)
q.AddUpdateSetting("Commentaires", TbCommentaires.Text)
q.AddUpdateSetting("idDomaine", CBlistDomaine.SelectedValue).Execute()
'q.AddUpdateSetting("idRisque", LBidMapping2.Text)
'q.WHERE(R_DAL.TBrisque.Columns.IdRisque, Me.Request.QueryString("idRisque"))
'q.AND(R_DAL.TBrisque.Columns.IdDomaine, Me.Request.QueryString("idDomaine"))
Me.DisplayAlert("Enregistrement du risque effectuée")
End Sub |
Partager