예제 #1
0
        public string Parametro(string Parametro)
        {
            string _parametro = string.Empty;

            try
            {
                _parametro = Convert.ToString(data.LoadScalarData("SELECT dbo.fncConsultaParametros('" + Parametro.Trim() + "', 4)", CommandType.Text, null));
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(_parametro);
        }
예제 #2
0
        public bool ConsultaAutorizacionesPendientes()
        {
            bool _retValue = true;

            SqlParameter[] _param = new SqlParameter[1];
            _param[0]       = new SqlParameter("@Cliente", SqlDbType.Int);
            _param[0].Value = _cliente;

            try
            {
                _retValue = Convert.ToBoolean(_data.LoadScalarData("spCyCSCConsultaAutorizacionPendiente", CommandType.StoredProcedure, _param));
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                _data.CloseConnection();
            }
            return(_retValue);
        }