private void OrcamentodataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { for (int i = 0; i < OrcamentodataGridView1.RowCount; i++) { SCOOP.DAO.SCOOPDataSet.Orcamento_ContratadoDataTable Dt = new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().GetDataBy11(Convert.ToInt32(OrcamentodataGridView1.Rows[i].Cells[1].Value)); foreach (SCOOP.DAO.SCOOPDataSet.Orcamento_ContratadoRow linha in Dt) { OrcamentodataGridView1.Rows[i].Cells[0].Value = linha.Sequencial.ToString(); OrcamentodataGridView1.Rows[i].Cells[5].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.EmpresaTableAdapter().ObterDescricaoEmpresa(linha.Empresa); OrcamentodataGridView1.Rows[i].Cells[6].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.LicitadoTableAdapter().ObterDescricaoLicitacao(linha.Licitado); OrcamentodataGridView1.Rows[i].Cells[7].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.SecretariaTableAdapter().ObterDescricaoSecretaria(linha.Secretaria); OrcamentodataGridView1.Rows[i].Cells[8].Value = linha.Empresa; OrcamentodataGridView1.Rows[i].Cells[9].Value = linha.Licitado; OrcamentodataGridView1.Rows[i].Cells[10].Value = linha.Secretaria; OrcamentodataGridView1.Rows[i].Cells[11].Value = linha.CPF_CNPJ; OrcamentodataGridView1.Rows[i].Cells[12].Value = linha.Prazo; OrcamentodataGridView1.Rows[i].Cells[13].Value = linha.Data_Criacao; OrcamentodataGridView1.Rows[i].Cells[14].Value = linha.Usuario; OrcamentodataGridView1.Rows[i].Cells[15].Value = linha.Data_alteracao; OrcamentodataGridView1.Rows[i].Cells[16].Value = linha.OrdemServico; OrcamentodataGridView1.Rows[i].Cells[17].Value = linha.Data_final; } } }
/// <summary> /// Estornar Orçamento Contratado /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string ExisteMedicao = ""; try { ExisteMedicao = new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().VerificarSeExisteMedicaoOrcamentoContratado(OrcamentotextBox.Text).ToString(); } catch (Exception ex) { ExisteMedicao = ""; } string erro = null; try { if (ExisteMedicao == "") { try { new SCOOP.DAO.SCOOPDataSetTableAdapters.ContratoTableAdapter().Delete(new SCOOP.DAO.SCOOPDataSetTableAdapters.ContratoTableAdapter().ObterCodigoContrato(OrcamentotextBox.Text)); ContratopictureBox.Image = global::SCOOP.Properties.Resources.ok; } catch (Exception ex) { ContratopictureBox.Image = global::SCOOP.Properties.Resources.errado; erro = "Problema ao estornar o contrato!"; } try { new SCOOP.DAO.SCOOPDataSetTableAdapters.Orc_Cont_ServicoTableAdapter().Delete(OrcamentotextBox.Text); ServicopictureBox.Image = global::SCOOP.Properties.Resources.ok; } catch (Exception ex) { ServicopictureBox.Image = global::SCOOP.Properties.Resources.errado; erro = "\nProblema ao estornar o Serviço do orçamento contratado!"; } try { new SCOOP.DAO.SCOOPDataSetTableAdapters.Dotacao_Orc_ContTableAdapter().Delete(OrcamentotextBox.Text); } catch (Exception ex) { erro = "\nProblema ao estornar as dotações do orçamento contratado."; } try { new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().Delete((int)new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().ObterSequencialOrcamentoContratado((int)new SCOOP.DAO.SCOOPDataSetTableAdapters.OrcamentoTableAdapter().ObterSequencialOrcamento(OrcamentotextBox.Text))); OrcamentoContratadopictureBox.Image = global::SCOOP.Properties.Resources.ok; OrdemServicopictureBox.InitialImage = global::SCOOP.Properties.Resources.ok; } catch (Exception ex) { OrcamentoContratadopictureBox.Image = global::SCOOP.Properties.Resources.errado; OrdemServicopictureBox.InitialImage = global::SCOOP.Properties.Resources.errado; erro = "\nProblema ao estornar no orçamento contratado!"; } } else { MessageBox.Show("Deve excluir todas as medições!"); } } catch (Exception ex) { MessageBox.Show("Erro\n" + ex.Message + erro); } }