private void DGservicos_CellClick(object sender, DataGridViewCellEventArgs e)
{
CBcliente.SelectedIndex = CBcliente.FindString(DGservicos.CurrentRow.Cells[0].Value.ToString());
CBsituacao.SelectedIndex = CBsituacao.FindString(DGservicos.CurrentRow.Cells[2].Value.ToString());
TXTservicos.Text = DGservicos.CurrentRow.Cells[1].Value.ToString();
TXTobs.Text = DGservicos.CurrentRow.Cells[6].Value.ToString();;
TXTvalor.Text = DGservicos.CurrentRow.Cells[5].Value.ToString();;
sql = "select * from tb03_movimentacoes where tb03_cod_servico = " + DGservicos.CurrentRow.Cells[7].Value.ToString();
model.open();
model.Execsql(sql);
if (model.resultado.HasRows)
{
TXTvalor.Enabled = false;
BTdel.Visible = false;
label6.Visible = false;
}
else
{
BTdel.Visible = true;
label6.Visible = true;
}
model.close();
BTadd.ButtonText = "Salvar edição";
BTcancela.Visible = true;
DGservicos.ClearSelection();
}
private void DGservicos_DoubleClick(object sender, EventArgs e)
{
Detalhes det = new Detalhes(this);
det.ShowDialog();
DGservicos.ClearSelection();
}
private void Add_servicos_Load(object sender, EventArgs e)
{
sql = "select * from tb01_clientes order by tb01_nome";
model.open();
model.Execsql(sql);
carregaComboBox();
model.close();
sql = "select * from tb01_clientes, tb02_servicos where tb01_cod = tb02_cod_cliente order by tb02_data_cadastro desc";
model.open();
model.Execsql(sql);
carregaGrid();
model.close();
DGservicos.ClearSelection();
}
private void BTpesquisa_Click(object sender, EventArgs e)
{
filtro();
TXTservico.Text = "";
TXTobs.Text = "";
combobox.SelectedIndex = -1;
TXTstatus.Text = "";
TXTvalor.Text = "";
TXTpago.Text = "";
TXTpagar.Text = "";
itens[0] = "";
itens[1] = "";
BTaddValor.Visible = false;
DGservicos.ClearSelection();
}
private void DGservicos_CellClick(object sender, DataGridViewCellEventArgs e)
{
TXTservico.Text = DGservicos.CurrentRow.Cells[1].Value.ToString();
TXTobs.Text = DGservicos.CurrentRow.Cells[4].Value.ToString();
combobox.Text = DGservicos.CurrentRow.Cells[2].Value.ToString();
TXTstatus.Text = DGservicos.CurrentRow.Cells[7].Value.ToString();
TXTvalor.Text = DGservicos.CurrentRow.Cells[5].Value.ToString();
TXTpago.Text = DGservicos.CurrentRow.Cells[6].Value.ToString();
TXTpagar.Text = (Convert.ToDouble(TXTvalor.Text) - Convert.ToDouble(TXTpago.Text)).ToString();
itens[0] = combobox.Text;
itens[1] = TXTpagar.Text;
if (TXTstatus.Text == "Pendente")
{
BTaddValor.Visible = true;
}
DGservicos.ClearSelection();
}
public void carregaGrid()
{
DGservicos.Rows.Clear();
if (model.resultado.HasRows)
{
while (model.resultado.Read())
{
DGservicos.Rows.Add(
model.resultado["tb01_nome"].ToString(),
model.resultado["tb02_servicos"].ToString(),
model.resultado["tb02_situacao"].ToString(),
model.resultado["tb02_data_cadastro"].ToString(),
model.resultado["tb02_obs"].ToString(),
model.resultado["tb02_valor"].ToString(),
model.resultado["tb02_valor_pago"].ToString(),
model.resultado["tb02_status"].ToString(),
model.resultado["tb02_cod"].ToString()
);
}
}
DGservicos.ClearSelection();
}
