コード例 #1
0
            public Meses ObtenerMeses(string Dias)
            {
                Meses meses = null;

                DataTable table = null;

                SqlCommand comando = new SqlCommand();

                comando.CommandText = "usp_BuscarMeses";
                comando.CommandType = CommandType.StoredProcedure;

                comando.Parameters.Add("@VchMeses", SqlDbType.NVarChar, 50);
                comando.Parameters["@VchMeses"].Value = Dias;

                table = Conexion.Busquedas(comando);


                foreach (DataRow row in table.Rows)
                {
                    meses = new Meses()
                    {
                        UidMes = (Guid)row["UidMes"],
                        strMes = (string)row["VchMes"],
                    };
                }


                return(meses);
            }
コード例 #2
0
            public List <Meses> ConsultarMeses()
            {
                List <Meses> meses = new List <Meses>();

                SqlCommand comando = new SqlCommand();

                try
                {
                    comando.CommandText = "usp_ConsultarMeses";
                    comando.CommandType = CommandType.StoredProcedure;

                    DataTable table = new Connection().ExecuteQuery(comando);

                    foreach (DataRow row in table.Rows)
                    {
                        Meses mes = new Meses()
                        {
                            UidMes = (Guid)row["UidMes"],
                            strMes = (string)row["VchMes"],
                        };
                        meses.Add(mes);
                    }
                }
                catch (SqlException e)
                {
                    throw;
                }

                return(meses);
            }