private bool Guardar() { try { if (!Valida()) { return(false); } MaterialLogica mate = new MaterialLogica(); mate.Material = cbbMaterial.Text.ToString().ToUpper(); mate.Nombre = txtNombre.Text.ToString(); double dEstd = 0; if (double.TryParse(txtEstd.Text, out dEstd)) { mate.Estandar = dEstd; } else { mate.Estandar = 0; } if (MaterialLogica.Guardar(mate) == 0) { MessageBox.Show("Error al intentar guardar el Material", Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } return(true); } catch (Exception ex) { MessageBox.Show("Favor de notificar al Administrador" + Environment.NewLine + "MaterialLogica.Guardar(mate)" + Environment.NewLine + ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
private void cbbArea_KeyDown(object sender, KeyEventArgs e) { try { if (e.KeyCode == Keys.Escape) { Close(); } if (e.KeyCode != Keys.Enter) { return; } if (string.IsNullOrEmpty(cbbMaterial.Text)) { return; } MaterialLogica mate = new MaterialLogica(); mate.Material = cbbMaterial.Text.ToString().ToUpper(); DataTable datos = MaterialLogica.Consultar(mate); if (datos.Rows.Count != 0) { cbbMaterial.SelectedValue = datos.Rows[0]["material"].ToString(); txtNombre.Text = datos.Rows[0]["nombre"].ToString(); txtEstd.Text = datos.Rows[0]["estandar"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
private void btnDelete_Click(object sender, EventArgs e) { if (cbbMaterial.SelectedIndex == -1) { return; } DialogResult Result = MessageBox.Show("Desea borrar el Material?", Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Result == DialogResult.Yes) { try { MaterialLogica mate = new MaterialLogica(); mate.Material = cbbMaterial.SelectedValue.ToString(); if (MaterialLogica.Eliminar(mate)) { MessageBox.Show("El Material ha sido borrado", Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Inicio(); } } catch (Exception ex) { MessageBox.Show("Favor de Notificar al Administrador" + Environment.NewLine + ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } }
private void cbbMaterial_SelectionChangeCommitted(object sender, EventArgs e) { dgwTurno1.DataSource = null; dgwTurno2.DataSource = null; CargarStd(); MaterialLogica mat = new MaterialLogica(); mat.Material = cbbMaterial.SelectedValue.ToString(); DataTable data = MaterialLogica.Consultar(mat); double dStd = 0; if (!double.TryParse(data.Rows[0]["estandar"].ToString(), out dStd)) { dStd = 0; } //std 1er turno for (int i = 0; i < 10; i++) { int iHora = 7; iHora += i; string sHora = iHora.ToString().PadLeft(2, '0') + ":00"; DataTable dt = dgwTurno1.DataSource as DataTable; dt.Rows.Add(cbbLinea.SelectedValue.ToString(), 0, "1", sHora, dStd); } for (int i = 0; i < 9; i++) { int iHora = 17; iHora += i; if (i == 7) { iHora = 0; } else { if (i == 8) { iHora = 1; } } string sHora = iHora.ToString().PadLeft(2, '0') + ":20"; DataTable dt = dgwTurno2.DataSource as DataTable; dt.Rows.Add(cbbLinea.SelectedValue.ToString(), 0, "2", sHora, dStd); } _lbCambioDet = true; _lbCambioDet2 = true; CargarStd(); }
private void Inicio() { cbbMaterial.ResetText(); DataTable dtmate = MaterialLogica.Listar(); cbbMaterial.DataSource = dtmate; cbbMaterial.ValueMember = "material"; cbbMaterial.DisplayMember = "material"; cbbMaterial.SelectedIndex = -1; txtNombre.Clear(); txtEstd.Clear(); cbbMaterial.Focus(); }
private void Inicio() { cbbLinea.ResetText(); DataTable data = LineaLogica.Listar(); cbbLinea.DataSource = data; cbbLinea.ValueMember = "linea"; cbbLinea.DisplayMember = "linea"; cbbLinea.SelectedIndex = -1; txtNombre.Clear(); cbbPlanta.ResetText(); DataTable dtT = PlantaLogica.Listar(); cbbPlanta.DataSource = dtT; cbbPlanta.ValueMember = "planta"; cbbPlanta.DisplayMember = "nombre"; cbbPlanta.SelectedIndex = -1; cbbArea.ResetText(); cbbArea.DataSource = null; cbbMaterial.ResetText(); DataTable dt = MaterialLogica.Listar(); cbbMaterial.DataSource = dt; cbbMaterial.ValueMember = "material"; cbbMaterial.DisplayMember = "nombre"; cbbMaterial.SelectedIndex = -1; dgwTurno1.DataSource = null; dgwTurno2.DataSource = null; dgwLineasRemove.DataSource = null; CargarStd(); cbbLinea.Focus(); }
private void cbbArea_SelectionChangeCommitted(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(cbbMaterial.Text)) { return; } MaterialLogica mate = new MaterialLogica(); mate.Material = cbbMaterial.Text.ToString().ToUpper(); DataTable datos = MaterialLogica.Consultar(mate); if (datos.Rows.Count != 0) { txtNombre.Text = datos.Rows[0]["nombre"].ToString(); txtEstd.Text = datos.Rows[0]["estandar"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), Text, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }