protected void lnkAnularSeguimiento_Click(object sender, EventArgs e) { try { LinkButton lnkAnularSeguimiento = (LinkButton)sender; char[] delimitador = { '|' }; string[] args = lnkAnularSeguimiento.CommandArgument.Split(delimitador); string numeroPedido = args[0]; string area = args[1]; string flujo = args[2]; // El flujo del pedido string nrointento = args[3]; // Nro de intento In60detalleSeg oIn60detalleSeg = new In60detalleSeg(); oIn60detalleSeg.In60codemp = _auditoria.CodigoEmpresa; oIn60detalleSeg.In60aa = _auditoria.Periodo; oIn60detalleSeg.In60Area = area; oIn60detalleSeg.In60numped = numeroPedido; oIn60detalleSeg.In60NroIntento = int.Parse(nrointento); oIn60detalleSeg.in60FlujoProceso = int.Parse(flujo); new PedidoBLL().DeshacerAprobacion(oIn60detalleSeg); oIn60detalleSeg = null; GC.Collect(); ListarPedido(); } catch (Exception ex) { throw; } }
/// <summary> /// Lista pedidos /// </summary> private void ListarPedido() { try { In60pedido oIn60pedido = new In60pedido(); In60detalleSeg oIn60DetalleSeg = new In60detalleSeg(); oIn60DetalleSeg.In60codemp=_auditoria.CodigoEmpresa; oIn60DetalleSeg.in60FlujoProceso = int.Parse(this.hidFlujoProceso.Value); oIn60DetalleSeg.In60Area = this.ddlArea.SelectedValue; oIn60DetalleSeg.In60numped = this.txtNroPedido.Text; oIn60pedido.In60TipoPedido = this.ddlTipoPedido.SelectedValue; DataTable dtData; dtData = new PedidoBLL().ListarPedidoSeguimientoxarea(oIn60DetalleSeg, oIn60pedido); this.gvBandeja.DataSource = dtData; this.gvBandeja.DataBind(); //Invoca al metodo para paginar la grilla Paginar(dtData, this.gvBandeja, this.litNumeroRegistros, this.litPagina); } catch (Exception) { throw; } }
public void RegistrarDetallePedidoSeguimiento(DbTransaction oDbTransaction, In60detalleSeg oIn60detalleSeg) { _command = _database.GetStoredProcCommand("Usp_ControlPedido_Ins_In60detalleSeg"); try { _database.AddInParameter(_command, "@In60codemp", System.Data.DbType.String, oIn60detalleSeg.In60codemp); _database.AddInParameter(_command, "@In60aa", System.Data.DbType.String, oIn60detalleSeg.In60aa); _database.AddInParameter(_command, "@In60numped", System.Data.DbType.String, oIn60detalleSeg.In60numped); _database.AddInParameter(_command, "@In60Area", System.Data.DbType.String, oIn60detalleSeg.In60Area); _database.AddInParameter(_command, "@In60Item", System.Data.DbType.Int16, oIn60detalleSeg.In60Item); _database.AddInParameter(_command, "@in60FlujoProceso", System.Data.DbType.Int16, oIn60detalleSeg.in60FlujoProceso); _database.AddInParameter(_command, "@In60EstadoAprob", System.Data.DbType.String, oIn60detalleSeg.In60EstadoAprob); _database.AddInParameter(_command, "@In60CantidadNueva", System.Data.DbType.Decimal, oIn60detalleSeg.In60CantidadNueva); _database.AddInParameter(_command, "@In60Observacion", System.Data.DbType.String, oIn60detalleSeg.In60Observacion); _database.AddInParameter(_command, "@in60flagultimoestado", System.Data.DbType.Int16, oIn60detalleSeg.in60flagultimoestado); _database.AddInParameter(_command, "@in60Cerrado", System.Data.DbType.Int16, oIn60detalleSeg.in60Cerrado); _database.AddInParameter(_command, "@in60UsuarioMod", System.Data.DbType.String, oIn60detalleSeg.@in60UsuarioMod); _database.AddInParameter(_command, "@in60FechaMod", System.Data.DbType.String, oIn60detalleSeg.in60FechaMod); _database.ExecuteNonQuery(_command, oDbTransaction); } catch (Exception) { throw; } }
public void DeshacerAprobacion(DbTransaction oDbTransaction, In60detalleSeg oIn60detalleSeg) { _command = _database.GetStoredProcCommand("usp_ControlPedido_DeshacerAprobacion"); try { _database.AddInParameter(_command, "@In60codemp", System.Data.DbType.String, oIn60detalleSeg.In60codemp); _database.AddInParameter(_command, "@In60aa", System.Data.DbType.String, oIn60detalleSeg.In60aa); _database.AddInParameter(_command, "@In60Area", System.Data.DbType.String, oIn60detalleSeg.In60Area); _database.AddInParameter(_command, "@In60numped", System.Data.DbType.String, oIn60detalleSeg.In60numped); _database.AddInParameter(_command, "@In60NroIntento", System.Data.DbType.Int16, oIn60detalleSeg.In60NroIntento); _database.AddInParameter(_command, "@in60FlujoProceso", System.Data.DbType.Int16, oIn60detalleSeg.in60FlujoProceso); _database.ExecuteNonQuery(_command, oDbTransaction); } catch (Exception) { throw; } }
public DataTable ListarDetallePedidoSeguimiento(In60detalleSeg oIn60detalleSeg) { _command = _database.GetStoredProcCommand("Usp_ControlPedido_Trae_PedParaAprobarDet"); try { _database.AddInParameter(_command, "@In60codemp", System.Data.DbType.String, oIn60detalleSeg.In60codemp); _database.AddInParameter(_command, "@In60aa", System.Data.DbType.String, oIn60detalleSeg.In60aa); _database.AddInParameter(_command, "@In60numped", System.Data.DbType.String, oIn60detalleSeg.In60numped); _database.AddInParameter(_command, "@In60Area", System.Data.DbType.String, oIn60detalleSeg.In60Area); _database.AddInParameter(_command, "@in60FlujoProceso", System.Data.DbType.Int16, oIn60detalleSeg.in60FlujoProceso); DataTable dt; dt = _database.ExecuteDataSet(_command).Tables[0]; return dt; } catch (Exception) { throw; } }
public void DeshacerAprobacion(In60detalleSeg oIn60DetalleSeg) { MC.Enterprise.Data.TransactionML objTransactionML = null; try { objTransactionML = new MC.Enterprise.Data.TransactionML(); objTransactionML.BeginTransaction(); new PedidoDAL().DeshacerAprobacion(objTransactionML.GetTransaction(), oIn60DetalleSeg); objTransactionML.CommitTransaction(); } catch (Exception) { objTransactionML.RollbackTransaction(); throw; } finally { if (objTransactionML != null) objTransactionML.Dispose(); objTransactionML = null; } }
public void RegistrarDetallePedidoSeguimiento(In60detalleSeg oIn60detalleSeg) { MC.Enterprise.Data.TransactionML objTransactionML = null; try { objTransactionML = new MC.Enterprise.Data.TransactionML(); objTransactionML.BeginTransaction(); new PedidoDAL().RegistrarDetallePedidoSeguimiento(objTransactionML.GetTransaction(), oIn60detalleSeg); objTransactionML.CommitTransaction(); } catch (Exception) { objTransactionML.RollbackTransaction(); throw; } finally { if (objTransactionML != null) objTransactionML.Dispose(); objTransactionML = null; } }
public DataTable ListarPedidoSeguimientoxarea(In60detalleSeg oIn60detalleSeg , In60pedido oIn60pedido) { return new PedidoDAL().ListarCabeceraPedidoSeguimiento(oIn60detalleSeg, oIn60pedido); }
public DataTable ListarDetallePedidoSeguimiento(In60detalleSeg oIn60detalleSeg) { return new PedidoDAL().ListarDetallePedidoSeguimiento(oIn60detalleSeg); }