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));
}
