private void button4_Click(object sender, EventArgs e)
{
frm_reporte_factura fac = new frm_reporte_factura();
frm_cotizacion cot = new frm_cotizacion();
string id = tipo;
object celda = cell;
string data = datos;
string campo = "";
string campo2 = "";
switch (id)
{
case "1":
campo = "a.cedula";
campo2 = "cedula_c";
break;
case "2":
campo = "a.cedula";
campo2 = "cedula_c";
break;
case "3":
campo = "a.nombre";
campo2 = "nombre_c";
break;
case "4":
campo = "a.apellido";
campo2 = "apellido_c";
break;
}
//string datos = cbx_estado.SelectedItem.ToString();
con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT b.nombre as Gasto, b.monto as Monto, b.detalle as Detalle, a.nombre as Nombre, a.apellido as Apellido, a.cedula as Cedula, a.oficialia_civil as Oficialia FROM pr_clientes AS a INNER JOIN pr_gastos AS b ON a.client_Id = b.client_Id where a.hidden=0 and " + campo + "='" + data + "' and b.tipo = '" + celda + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
fac.dataGridView1.Visible = true;
da.Fill(dt);
fac.dataGridView1.DataSource = dt;
con.Close();
//fac.txt_sub_total.Text = txt_sub_total.Text;
fac.textBox4.Text = textBox4.Text;
fac.textBox3.Text = textBox3.Text;
string info = cbx_estado.SelectedItem.ToString();
fac.textBox5.Text = info;
fac.Show();
}
private void button4_Click(object sender, EventArgs e)
{
frm_reporte_factura fac = new frm_reporte_factura();
frm_cotizacion cot = new frm_cotizacion();
string id = tipo;
object celda = cell;
string data = datos;
string campo = "";
string campo2 = "";
switch (id)
{
case "1":
campo = "a.cedula";
campo2 = "cedula_c";
break;
case "2":
campo = "a.cedula";
campo2 = "cedula_c";
break;
case "3":
campo = "a.nombre";
campo2 = "nombre_c";
break;
case "4":
campo = "a.apellido";
campo2 = "apellido_c";
break;
}
//string datos = cbx_estado.SelectedItem.ToString();
con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT b.nombre as Gasto, b.monto as Monto, b.detalle as Detalle, a.nombre as Nombre, a.apellido as Apellido, a.cedula as Cedula, a.oficialia_civil as Oficialia FROM pr_clientes AS a INNER JOIN pr_gastos AS b ON a.client_Id = b.client_Id where a.hidden=0 and " + campo + "='" + data + "' and b.tipo = '" + celda + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
fac.dataGridView1.Visible = true;
da.Fill(dt);
fac.dataGridView1.DataSource = dt;
con.Close();
//fac.txt_sub_total.Text = txt_sub_total.Text;
fac.textBox4.Text = textBox4.Text;
fac.textBox3.Text = textBox3.Text;
string info = cbx_estado.SelectedItem.ToString();
fac.textBox5.Text = info;
fac.Show();
}
private void cotizacionToolStripMenuItem_Click(object sender, EventArgs e)
{
frm_cotizacion cot = new frm_cotizacion();
cot.Show();
}
private void cotizacionToolStripMenuItem_Click(object sender, EventArgs e)
{
frm_cotizacion cot = new frm_cotizacion();
cot.Show();
}
private void button3_Click(object sender, EventArgs e)
{
frm_cotizacion cot = new frm_cotizacion();
cot.Show();
}
private void button3_Click(object sender, EventArgs e)
{
frm_cotizacion cot = new frm_cotizacion();
cot.Show();
}
