private void toolStripButton3_Click(object sender, EventArgs e)
{
try
{
SCOOPDataSet.MedicaoDataTable Dt = new MedicaoTableAdapter().GetDataBy1(dataGridView1.Rows[Convert.ToInt32(bindingNavigatorPositionItem.TextBox.Text) - 1].Cells[1].Value.ToString());
foreach (SCOOPDataSet.MedicaoRow linha in Dt)
{
mskTxtBoxFolhaNumero.Text = linha.Codigo_Medicao;
MskTxtBoxCodigoOrcamento.Text = linha.Codigo_Orcamento;
mskTxtBoxContrato.Text = new ContratoTableAdapter().ObterCodigoContrato(linha.Codigo_Orcamento);
//ComboBoxEngFiscal.Text = linha.
this.med_ServicoTableAdapter2.FillBy(this.sCOOPDataSet.Med_Servico, linha.Codigo_Medicao);
tabControl1.SelectedTab = tabPage1;
}
bindingNavigator1.Enabled = true;
GrupoBoxServicos.Enabled = true;
BttCadastrarMedicao.Visible = false;
BttRecibo.Enabled = true;
BttSolicitacao.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Erro ao tentar Alterar a medição.");
}
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
for (int i = 0; i < dataGridView1.RowCount; i++)
{
string Orcamento = new MedicaoTableAdapter().ObterOrcamentoMedicao(dataGridView1.Rows[i].Cells[1].Value.ToString());
SCOOPDataSet.OrcamentoDataTable Dt = new OrcamentoTableAdapter().GetDataBy2(Orcamento);
foreach (SCOOPDataSet.OrcamentoRow linha in Dt)
{
dataGridView1.Rows[i].Cells[4].Value = linha.Descricao;
dataGridView1.Rows[i].Cells[5].Value = linha.Logradouro;
dataGridView1.Rows[i].Cells[6].Value = linha.Bairro;
}
dataGridView1.Rows[i].Cells[7].Value = new Med_ServicoTableAdapter().ObterTotalMedicaoServico(dataGridView1.Rows[i].Cells[1].Value.ToString()).ToString();
}
}
