コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }
コード例 #3
0
ファイル: menu.cs プロジェクト: jesusfsg06/jf-suit-v1.0
 private void cotizacionToolStripMenuItem_Click(object sender, EventArgs e)
 {
     frm_cotizacion cot = new frm_cotizacion();
     cot.Show();
 }
コード例 #4
0
        private void cotizacionToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frm_cotizacion cot = new frm_cotizacion();

            cot.Show();
        }
コード例 #5
0
        private void button3_Click(object sender, EventArgs e)
        {
            frm_cotizacion cot = new frm_cotizacion();

            cot.Show();
        }
コード例 #6
0
 private void button3_Click(object sender, EventArgs e)
 {
     frm_cotizacion cot = new frm_cotizacion();
     cot.Show();
 }