c#语言 完成随机点餐代码

Question

c#语言，完成随机点餐功能，cs架构，SQLITE数据库

（ 十个商家 几个菜品 代码 ）

学渣一个 只为完成老师给的作业 不求完美只求过关

Answer 1

采纳本回答，留下邮箱，将代码给你

其他人如果需要，完整代码：https://download.csdn.net/download/caozhy/11092305

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Linq;
using System.Text;

namespace Q755018
{
    class Program
    {
        static void Main(string[] args)
        {
            List<string> dishes = new List<string>();
            List<string> shops = new List<string>();
            SQLiteConnection conn = new SQLiteConnection("Data Source=Q755018DB.db;Version=3;");
            conn.Open();
            SQLiteCommand cmd = new SQLiteCommand("select * from dishes", conn);
            var reader = cmd.ExecuteReader();
            while (reader.Read())
                dishes.Add(reader["dishname"].ToString().Trim());
            reader.Close();
            cmd.CommandText = "select * from shops";
            reader = cmd.ExecuteReader();
            while (reader.Read())
                shops.Add(reader["shopname"].ToString().Trim());
            reader.Close();
            Console.Write("随机选一个店：");
            Console.WriteLine(shops.OrderBy(x => Guid.NewGuid()).First());
            Console.WriteLine("随机点五个菜：");
            foreach (var item in dishes.OrderBy(x => Guid.NewGuid()).Take(5))
                Console.WriteLine("\t" + item);
        }
    }
}