Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'Verificar se o orçamento já existe
- Try
- orcamentosConn_orcamentosIDAdapter = New OleDb.OleDbDataAdapter("SELECT ID FROM OrcamentosT WHERE ID=" & OrcamentoID, orcamentosConn)
- orcamentosConn_orcamentosIDDataTable = New DataTable
- orcamentosConn_orcamentosIDAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
- orcamentosConn_orcamentosIDAdapter.Fill(orcamentosConn_orcamentosIDDataTable)
- Catch ex As Exception
- MsgBox("Ocorreu um erro a carregar o orçamento : " & vbCrLf & vbCrLf & ex.Message, MsgBoxStyle.Critical, "Erro Fatal")
- End
- End Try
- Try
- existeOrcamento = orcamentosConn_orcamentosIDDataTable.Rows.Item(0).Item(0).ToString()
- Catch ex As Exception
- existeOrcamento = ""
- End Try
- If existeOrcamento = "" Then
- Try
- orcamentosConn.Open()
- Catch ex As Exception
- Erro("Ocorreu um erro a abrir a conecção à DB: " & vbCrLf & vbCrLf & ex.Message)
- End Try
- Dim cmd As New OleDb.OleDbCommand
- Dim cmdText As String
- cmdText = "INSERT INTO OrcamentosT (ID, Cliente, Morada, CodigoPostal, NumContribuinte, Telefone, PrecoUniProd1, PrecoUniProd2, PrecoUniProd3, PrecoUniProd4, PrecoUniProd5, PrecoUniProd6, PrecoUniProd7, PrecoUniProd8, PrecoUniProd9, PrecoUniProd10, PrecoUniProd11, PrecoUniProd12, PrecoUniProd13, PrecoUniProd14, PrecoUniProd15, QuantProd1, QuantProd2, QuantProd3, QuantProd4, QuantProd5, QuantProd6, QuantProd7, QuantProd8, QuantProd9, QuantProd10, QuantProd11, QuantProd12, QuantProd13, QuantProd14, QuantProd15, PrecoTotal1, PrecoTotal2, PrecoTotal3, PrecoTotal4, PrecoTotal5, PrecoTotal6, PrecoTotal7, PrecoTotal8, PrecoTotal9, PrecoTotal10, PrecoTotal11, PrecoTotal12, PrecoTotal13, PrecoTotal14, PrecoTotal15, NomeProd1, NomeProd2, NomeProd3, NomeProd4, NomeProd5, NomeProd6, NomeProd7, NomeProd8, NomeProd9, NomeProd10, NomeProd11, NomeProd12, NomeProd13, NomeProd14, NomeProd15, Tmr) " & _
- "VALUES (" & _
- OrcamentoID & ", " & _
- "'" & Replace(txtNome.Text, "'", "") & "', " & _
- "'" & Replace(txtMorada.Text, "'", "") & "', " & _
- "'" & txtCodPostal.Text & "', " & _
- "'" & txtNcontribuinte.Text & "', " & _
- "'" & txtTelefone.Text & "', " & _
- "'" & txtProd_PrecUni_01.Text & "', " & _
- "'" & txtProd_PrecUni_02.Text & "', " & _
- "'" & txtProd_PrecUni_03.Text & "', " & _
- "'" & txtProd_PrecUni_04.Text & "', " & _
- "'" & txtProd_PrecUni_05.Text & "', " & _
- "'" & txtProd_PrecUni_06.Text & "', " & _
- "'" & txtProd_PrecUni_07.Text & "', " & _
- "'" & txtProd_PrecUni_08.Text & "', " & _
- "'" & txtProd_PrecUni_09.Text & "', " & _
- "'" & txtProd_PrecUni_10.Text & "', " & _
- "'" & txtProd_PrecUni_11.Text & "', " & _
- "'" & txtProd_PrecUni_12.Text & "', " & _
- "'" & txtProd_PrecUni_13.Text & "', " & _
- "'" & txtProd_PrecUni_14.Text & "', " & _
- "'" & txtProd_PrecUni_15.Text & "', " & _
- "'" & txtProd_Quant_01.Text & "', " & _
- "'" & txtProd_Quant_02.Text & "', " & _
- "'" & txtProd_Quant_03.Text & "', " & _
- "'" & txtProd_Quant_04.Text & "', " & _
- "'" & txtProd_Quant_05.Text & "', " & _
- "'" & txtProd_Quant_06.Text & "', " & _
- "'" & txtProd_Quant_07.Text & "', " & _
- "'" & txtProd_Quant_08.Text & "', " & _
- "'" & txtProd_Quant_09.Text & "', " & _
- "'" & txtProd_Quant_10.Text & "', " & _
- "'" & txtProd_Quant_11.Text & "', " & _
- "'" & txtProd_Quant_12.Text & "', " & _
- "'" & txtProd_Quant_13.Text & "', " & _
- "'" & txtProd_Quant_14.Text & "', " & _
- "'" & txtProd_Quant_15.Text & "', " & _
- "'" & txtProd_PrecTot_01.Text & "', " & _
- "'" & txtProd_PrecTot_02.Text & "', " & _
- "'" & txtProd_PrecTot_03.Text & "', " & _
- "'" & txtProd_PrecTot_04.Text & "', " & _
- "'" & txtProd_PrecTot_05.Text & "', " & _
- "'" & txtProd_PrecTot_06.Text & "', " & _
- "'" & txtProd_PrecTot_07.Text & "', " & _
- "'" & txtProd_PrecTot_08.Text & "', " & _
- "'" & txtProd_PrecTot_09.Text & "', " & _
- "'" & txtProd_PrecTot_10.Text & "', " & _
- "'" & txtProd_PrecTot_11.Text & "', " & _
- "'" & txtProd_PrecTot_12.Text & "', " & _
- "'" & txtProd_PrecTot_13.Text & "', " & _
- "'" & txtProd_PrecTot_14.Text & "', " & _
- "'" & txtProd_PrecTot_15.Text & "', " & _
- "'" & txtProd_Nome_01.Text & "', " & _
- "'" & txtProd_Nome_02.Text & "', " & _
- "'" & txtProd_Nome_03.Text & "', " & _
- "'" & txtProd_Nome_04.Text & "', " & _
- "'" & txtProd_Nome_05.Text & "', " & _
- "'" & txtProd_Nome_06.Text & "', " & _
- "'" & txtProd_Nome_07.Text & "', " & _
- "'" & txtProd_Nome_08.Text & "', " & _
- "'" & txtProd_Nome_09.Text & "', " & _
- "'" & txtProd_Nome_10.Text & "', " & _
- "'" & txtProd_Nome_11.Text & "', " & _
- "'" & txtProd_Nome_12.Text & "', " & _
- "'" & txtProd_Nome_13.Text & "', " & _
- "'" & txtProd_Nome_14.Text & "', " & _
- "'" & txtProd_Nome_15.Text & "', " & _
- "'" & tmr.Text & "')"
- cmd.Connection = orcamentosConn
- cmd.CommandText = cmdText
- Try
- cmd.ExecuteNonQuery()
- Catch ex As Exception
- Erro("Ocorreu um erro a tentar executar a query: " & vbCrLf & "'" & cmdText & "'" & vbCrLf & vbCrLf & ex.Message)
- End Try
- orcamentosConn.Close()
- CarregarOrcamento()
- ActualizarDataTables()
- Else
- Try
- orcamentosConn.Open()
- Catch ex As Exception
- Erro("Ocorreu um erro a abrir a conecção à DB: " & vbCrLf & vbCrLf & ex.Message)
- End Try
- Dim cmd As New OleDb.OleDbCommand
- Dim cmdText As String
- '***Alteração/Acrescento NomeProd.
- cmdText = "UPDATE OrcamentosT SET " & _
- "Cliente='" & Replace(txtNome.Text, "'", "") & "', " & _
- "Morada='" & Replace(txtMorada.Text, "'", "") & "', " & _
- "CodigoPostal='" & txtCodPostal.Text & "', " & _
- "NumContribuinte='" & txtNcontribuinte.Text & "', " & _
- "Telefone='" & txtTelefone.Text & "', " & _
- "PrecoUniProd1='" & txtProd_PrecUni_01.Text & "', " & _
- "PrecoUniProd2='" & txtProd_PrecUni_02.Text & "', " & _
- "PrecoUniProd3='" & txtProd_PrecUni_03.Text & "', " & _
- "PrecoUniProd4='" & txtProd_PrecUni_04.Text & "', " & _
- "PrecoUniProd5='" & txtProd_PrecUni_05.Text & "', " & _
- "PrecoUniProd6='" & txtProd_PrecUni_06.Text & "', " & _
- "PrecoUniProd7='" & txtProd_PrecUni_07.Text & "', " & _
- "PrecoUniProd8='" & txtProd_PrecUni_08.Text & "', " & _
- "PrecoUniProd9='" & txtProd_PrecUni_09.Text & "', " & _
- "PrecoUniProd10='" & txtProd_PrecUni_10.Text & "', " & _
- "PrecoUniProd11='" & txtProd_PrecUni_11.Text & "', " & _
- "PrecoUniProd12='" & txtProd_PrecUni_12.Text & "', " & _
- "PrecoUniProd13='" & txtProd_PrecUni_13.Text & "', " & _
- "PrecoUniProd14='" & txtProd_PrecUni_14.Text & "', " & _
- "PrecoUniProd15='" & txtProd_PrecUni_15.Text & "', " & _
- "QuantProd1='" & txtProd_Quant_01.Text & "', " & _
- "QuantProd2='" & txtProd_Quant_02.Text & "', " & _
- "QuantProd3='" & txtProd_Quant_03.Text & "', " & _
- "QuantProd4='" & txtProd_Quant_04.Text & "', " & _
- "QuantProd5='" & txtProd_Quant_05.Text & "', " & _
- "QuantProd6='" & txtProd_Quant_06.Text & "', " & _
- "QuantProd7='" & txtProd_Quant_07.Text & "', " & _
- "QuantProd8='" & txtProd_Quant_08.Text & "', " & _
- "QuantProd9='" & txtProd_Quant_09.Text & "', " & _
- "QuantProd10='" & txtProd_Quant_10.Text & "', " & _
- "QuantProd11='" & txtProd_Quant_11.Text & "', " & _
- "QuantProd12='" & txtProd_Quant_12.Text & "', " & _
- "QuantProd13='" & txtProd_Quant_13.Text & "', " & _
- "QuantProd14='" & txtProd_Quant_14.Text & "', " & _
- "QuantProd15='" & txtProd_Quant_15.Text & "', " & _
- "PrecoTotal1='" & txtProd_PrecTot_01.Text & "', " & _
- "PrecoTotal2='" & txtProd_PrecTot_02.Text & "', " & _
- "PrecoTotal3='" & txtProd_PrecTot_03.Text & "', " & _
- "PrecoTotal4='" & txtProd_PrecTot_04.Text & "', " & _
- "PrecoTotal5='" & txtProd_PrecTot_05.Text & "', " & _
- "PrecoTotal6='" & txtProd_PrecTot_06.Text & "', " & _
- "PrecoTotal7='" & txtProd_PrecTot_07.Text & "', " & _
- "PrecoTotal8='" & txtProd_PrecTot_08.Text & "', " & _
- "PrecoTotal9='" & txtProd_PrecTot_09.Text & "', " & _
- "PrecoTotal10='" & txtProd_PrecTot_10.Text & "', " & _
- "PrecoTotal11='" & txtProd_PrecTot_11.Text & "', " & _
- "PrecoTotal12='" & txtProd_PrecTot_12.Text & "', " & _
- "PrecoTotal13='" & txtProd_PrecTot_13.Text & "', " & _
- "PrecoTotal14='" & txtProd_PrecTot_14.Text & "', " & _
- "PrecoTotal15='" & txtProd_PrecTot_15.Text & "', " & _
- "NomeProd1='" & txtProd_Nome_01.Text & "', " & _
- "NomeProd2='" & txtProd_Nome_02.Text & "', " & _
- "NomeProd3='" & txtProd_Nome_03.Text & "', " & _
- "NomeProd4='" & txtProd_Nome_04.Text & "', " & _
- "NomeProd5='" & txtProd_Nome_05.Text & "', " & _
- "NomeProd6='" & txtProd_Nome_06.Text & "', " & _
- "NomeProd7='" & txtProd_Nome_07.Text & "', " & _
- "NomeProd8='" & txtProd_Nome_08.Text & "', " & _
- "NomeProd9='" & txtProd_Nome_09.Text & "', " & _
- "NomeProd10='" & txtProd_Nome_10.Text & "', " & _
- "NomeProd11='" & txtProd_Nome_11.Text & "', " & _
- "NomeProd12='" & txtProd_Nome_12.Text & "', " & _
- "NomeProd13='" & txtProd_Nome_13.Text & "', " & _
- "NomeProd14='" & txtProd_Nome_14.Text & "', " & _
- "NomeProd15='" & txtProd_Nome_15.Text & "', " & _
- "Tmr='" & tmr.Text & "' " & _
- "WHERE ID=" & OrcamentoID
- cmd.Connection = orcamentosConn
- cmd.CommandText = cmdText
- Try
- cmd.ExecuteNonQuery()
- Catch ex As Exception
- Erro("Ocorreu um erro a tentar executar a query: " & vbCrLf & "'" & cmdText & "'" & vbCrLf & vbCrLf & ex.Message)
- End Try
- orcamentosConn.Close()
- CarregarOrcamento()
- ActualizarDataTables()
- End If
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement