public IActionResult Snake(string SnakeName) { var snake = Sql.Read("SELECT * FROM Snake WHERE speciesName=@0", SnakeName); Snake mysnake = new Snake(); var model = new HandBookModel(); foreach (DataRow SNAKE in snake) { var ID = Convert.ToInt32(SNAKE[0]); mysnake.snake_ID = ID; mysnake.order = SNAKE[1].ToString(); mysnake.family = SNAKE[2].ToString(); mysnake.genus = SNAKE[3].ToString(); mysnake.speciesName = SNAKE[4].ToString(); mysnake.names = SNAKE[5].ToString(); var isP = Convert.ToInt32(SNAKE[6]); if (isP == 1) { mysnake.is_Poisonous = true; } else { mysnake.is_Poisonous = false; } mysnake.province = SNAKE[7].ToString(); mysnake.snakeIntro = SNAKE[8].ToString(); } model.snake = mysnake; return(View(model)); }
public IActionResult Index() { var snake = Sql.Read("SELECT speciesName FROM Snake");//查找所有蛇名 var snakes = new List <string>(); var model = new HandBookModel(); foreach (DataRow SNAKE in snake) { snakes.Add(SNAKE[0].ToString()); } model.snakes = snakes; return(View(model)); }