public bool InsertarPlanSolicitud_DTH(PlanDetalleConsumer objDetalle, ref string rMsg) { DAABRequest.Parameter[] arrParam = { new DAABRequest.Parameter("P_RESULTADO", DbType.Int64, ParameterDirection.Output), new DAABRequest.Parameter("P_SOLIN_CODIGO", DbType.Int64, ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLC_MONTO_TOTAL", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLN_MONTO_UNIT", DbType.Double, ParameterDirection.Input), new DAABRequest.Parameter("P_PLANC_CODIGO", DbType.String, 4,ParameterDirection.Input), new DAABRequest.Parameter("P_TPROC_CODIGO", DbType.String, 2,ParameterDirection.Input), new DAABRequest.Parameter("P_SOPLN_CANTIDAD", DbType.Int64, ParameterDirection.Input) }; for (int i = 0; i < arrParam.Length; i++) { arrParam[i].Value = DBNull.Value; } arrParam[1].Value = objDetalle.SOLIN_CODIGO; arrParam[2].Value = objDetalle.SOPLC_MONTO_TOTAL; arrParam[3].Value = objDetalle.SOPLN_MONTO_UNIT; arrParam[4].Value = objDetalle.PLANC_CODIGO; arrParam[5].Value = objDetalle.TPROC_CODIGO; arrParam[6].Value = objDetalle.SOPLN_CANTIDAD; bool salida = false; BDSISACT obj = new BDSISACT(BaseDatos.BD_SISACT); DAABRequest obRequest = obj.CreaRequest(); obRequest.CommandType = CommandType.StoredProcedure; obRequest.Command = BaseDatos.PKG_SISACT_DTH + ".SISACT_INSERTAR_SOL_PLANES_DTH"; obRequest.Parameters.AddRange(arrParam); obRequest.Transactional = true; try { obRequest.Factory.ExecuteNonQuery(ref obRequest); obRequest.Factory.CommitTransaction(); salida = true; } catch (Exception ex) { obRequest.Factory.RollBackTransaction(); rMsg = "Error al Insertar la Solicitud. \nMensaje : " + ex.Message; throw ex; } finally { IDataParameter pSalida1; pSalida1 = (IDataParameter)obRequest.Parameters[0]; rMsg = Funciones.CheckStr(pSalida1.Value); obRequest.Factory.Dispose(); } return(salida); }
public bool InsertarPlanSolicitud_DTH(PlanDetalleConsumer objDetalle, ref string rMsg) { return(new PlanDetalleConsDatos().InsertarPlanSolicitud_DTH(objDetalle, ref rMsg)); }
public bool InsertarPlanSolicitud(PlanDetalleConsumer objDetalle) { return(new SolicitudDatos().InsertarPlanSolicitud(objDetalle)); }