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;
}
}
