public Boolean InsertChekeoDetalle(clsDetalleArqueo detarqe, int codArq)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("ChekeaDetalleArqueo", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter oParam;
oParam = cmd.Parameters.AddWithValue("fisico", detarqe.DStockF);
oParam = cmd.Parameters.AddWithValue("dif", detarqe.DDiferencia);
oParam = cmd.Parameters.AddWithValue("observa", detarqe.SObservacion);
oParam = cmd.Parameters.AddWithValue("codDeta", detarqe.ICodDetalle);
oParam = cmd.Parameters.AddWithValue("codArq", codArq);
int x = cmd.ExecuteNonQuery();
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean InsertDetalle(clsDetalleArqueo detarqe)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("GuardaDetalleArqueo", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter oParam;
oParam = cmd.Parameters.AddWithValue("codArq", detarqe.ICodArqueo);
oParam = cmd.Parameters.AddWithValue("codUser", detarqe.ICodUsuario);
oParam = cmd.Parameters.AddWithValue("observ", detarqe.SObservacion);
oParam = cmd.Parameters.AddWithValue("codAlma", detarqe.ICodAlma);
int x = cmd.ExecuteNonQuery();
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean insertChekeoDetalle(clsDetalleArqueo detarqe, Int32 codArq)
{
try
{
return(Marqueo.InsertChekeoDetalle(detarqe, codArq));
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
