// Modifica Detalles
public void ActualizarDetallePedido(DbTransaction oDbTransaction, In60detalle oIn60detalle)
{
_command = _database.GetStoredProcCommand("usp_ControlPedido_ModificarIn60detalle");
try
{
_database.AddInParameter(_command, "@In60codemp", System.Data.DbType.String, oIn60detalle.In60codemp);
_database.AddInParameter(_command, "@In60aa", System.Data.DbType.String, oIn60detalle.In60aa);
_database.AddInParameter(_command, "@In60numped", System.Data.DbType.String, oIn60detalle.In60numped);
_database.AddInParameter(_command, "@In60Item", System.Data.DbType.Int16, oIn60detalle.In60Item);
_database.AddInParameter(_command, "@In60unidad", System.Data.DbType.String, oIn60detalle.In60unidad);
_database.AddInParameter(_command, "@In60cantidad", System.Data.DbType.Decimal, oIn60detalle.In60cantidad);
_database.AddInParameter(_command, "@In60Area", System.Data.DbType.String, oIn60detalle.In60Area);
_database.AddInParameter(_command, "@In60NroParte", System.Data.DbType.String, oIn60detalle.In60NroParte);
_database.AddInParameter(_command, "@In60Prioridad", System.Data.DbType.String, oIn60detalle.In60Prioridad);
_database.AddInParameter(_command, "@In60Equipo", System.Data.DbType.String, oIn60detalle.In60Equipo);
_database.AddInParameter(_command, "@In60Observacion", System.Data.DbType.String, oIn60detalle.In60Observacion);
_database.AddInParameter(_command, "@In60desart", System.Data.DbType.String, oIn60detalle.In60desart);
_database.ExecuteNonQuery(_command, oDbTransaction);
}
catch (Exception)
{
throw;
}
}
// Elimina Detalles
public void EliminarDetallePedido(DbTransaction oDbTransaction, In60detalle oIn60detalle)
{
_command = _database.GetStoredProcCommand("usp_ControlPedido_EliminarIn60detalle");
try
{
_database.AddInParameter(_command, "@In60codemp", System.Data.DbType.String, oIn60detalle.In60codemp);
_database.AddInParameter(_command, "@In60aa", System.Data.DbType.String, oIn60detalle.In60aa);
_database.AddInParameter(_command, "@In60numped", System.Data.DbType.String, oIn60detalle.In60numped);
_database.AddInParameter(_command, "@In60Item", System.Data.DbType.Int16, oIn60detalle.In60Item);
_database.AddInParameter(_command, "@In60Area", System.Data.DbType.String, oIn60detalle.In60Area);
_database.ExecuteNonQuery(_command, oDbTransaction);
}
catch (Exception)
{
throw;
}
}
public void RegistrarDetallePedido(In60detalle oIn60detalle)
{
MC.Enterprise.Data.TransactionML objTransactionML = null;
try
{
objTransactionML = new MC.Enterprise.Data.TransactionML();
objTransactionML.BeginTransaction();
new PedidoDAL().RegistrarDetallePedido(objTransactionML.GetTransaction(), oIn60detalle);
objTransactionML.CommitTransaction();
}
catch (Exception)
{
objTransactionML.RollbackTransaction();
throw;
}
finally
{
if (objTransactionML != null) objTransactionML.Dispose();
objTransactionML = null;
}
}