Пример #1
0
        public ActionResult <IEnumerable <UserInfo> > shopTow()
        {
            var Rather = new List <UserInfo>();

            using (SqlConnection connection = new SqlConnection(_connectionString))
            {
                SqlCommand command = new SqlCommand($"select * from Goods a join GoodsType b on a.Id=b.TypeParentid where b.TypeName='男装'", connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Rather.Add(HelpTool.ADONetToClass <UserInfo>(reader));
                }
            }

            return(Ok(Rather));
        }
Пример #2
0
        public ActionResult <IEnumerable <UserInfo> > shopOne()
        {
            var Rather = new List <UserInfo>();

            using (SqlConnection connection = new SqlConnection(_connectionString))
            {
                SqlCommand command = new SqlCommand($"select * from UserInfo where sex='女'", connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Rather.Add(HelpTool.ADONetToClass <UserInfo>(reader));
                }
            }

            return(Ok(Rather));
        }