C#控制台应用程序之旅游资源与线路管理系统

利用C#语言及SQL Server数据库编写的一个简化版旅游资源与线路管理系统

数据库中包含三张表：hotel表、tourist_spot表、lines表

用户分为管理员和普通用户，管理员拥有最高权限，可以对三张表进行增、删、改、查，而普通用户拥有部分权限，只能进行查询操作

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApp1
{
    class Program
    {
        static string[] Users = new string[] { "a123", "abcd","admin","driver" };
        static void Main(string[] args)
        {
            string str_id = "",str_password="";
            Console.WriteLine("      ********************************");
            Console.WriteLine("  ****欢迎您使用旅游资源及线路管理系统****");
            Console.WriteLine("      ********************************\n");
            Console.WriteLine("请你验证身份,以便于我们为您提供更加优质的服务！");
            Console.Write("请输入您的账号：");
            str_id = Console.ReadLine();
            Console.Write("请输入您的密码：");
            str_password = Console.ReadLine();
            if (str_id == "root" && str_password == "root")
            {
                do
                {
                    RootMenu();
                    Console.WriteLine("请选择：1、继续  2、退出");
                } while (Console.ReadLine() == "1");
                Environment.Exit(0);
            }
            else if(isUser(str_id.Trim()))
            {
                if(str_password.Trim()=="admin")
                    do
                    {
                        User();
                        Console.WriteLine("请选择：1、继续  2、退出");
                    } while (Console.ReadLine() == "1");
                Environment.Exit(0);
            }
        }

        //判断是否为普通用户
        static bool isUser(string x)
        {
            foreach (string i in Users)
                if (x == i)
                    return true;
                else
                    continue;
            return false;
        }

        //root管理菜单
        static void RootMenu()
        {
            Console.Clear();
            Console.WriteLine("您是超级管理员，拥有最高权限");
            Console.WriteLine("      1、酒店信息管理");
            Console.WriteLine("      2、景点信息管理");
            Console.WriteLine("      3、线路信息管理");
            bool bool1 = true;
            do
            {
                Console.Write("请输入序号选择你要管理的内容：");
                string str = Console.ReadLine();
                switch (str)
                {
                    case "1":
                        Console.Clear();
                        Console.WriteLine("欢迎进行酒店信息管理");
                        Console.WriteLine("1、酒店信息添加");
                        Console.WriteLine("2、酒店信息删除");
                        Console.WriteLine("3、酒店信息修改");
                        Console.WriteLine("4、酒店信息查询");
                        Root(1);
                        break;
                    case "2":
                        Console.Clear();
                        Console.WriteLine("欢迎进行景点信息管理");
                        Console.WriteLine("1、景点信息添加");
                        Console.WriteLine("2、景点信息删除");
                        Console.WriteLine("3、景点信息修改");
                        Console.WriteLine("4、景点信息查询");
                        Root(2);
                        break; ;
                    case "3":
                        Console.Clear();
                        Console.WriteLine("欢迎进行线路信息管理");
                        Console.WriteLine("1、线路信息添加");
                        Console.WriteLine("2、线路信息删除");
                        Console.WriteLine("3、线路信息修改");
                        Console.WriteLine("4、线路信息查询");
                        Root(3);
                        break;
                    default:
                        bool1 = false;
                        break;
                }
            } while (!bool1);
        }

        //root函数，具有所有数据操作的权限
        static void Root(int x)
        {
            switch (x)
            {
                case 1:
                    {
                        Console.Write("请选择：");
                        string str = "";
                        str = Console.ReadLine();
                        switch (str.Trim())
                        {
                            case "1":
                                HotelAdd();
                                break;
                            case "2":
                                HotelDelete();
                                break;
                            case "3":
                                HotelAlter();
                                break;
                            case "4":
                                HotelSelect();
                                break;
                            default:
                                Console.Write("非法操作！");
                                return;
                        }
                    }
                    break;

                case 2:
                    {
                        Console.Write("请选择：");
                        string str = "";
                        str = Console.ReadLine();
                        switch (str.Trim())
                        {
                            case "1":
                                Tourist_spotAdd();
                                break;
                            case "2":
                                Tourist_spotDelete();
                                break;
                            case "3":
                                Tourist_spotAlter();
                                break;
                            case "4":
                                Tourist_spotSelect();
                                break;
                            default:
                                Console.Write("非法操作！");
                                return;
                        }
                    }
                    break;
                case 3:
                    {
                        Console.Write("请选择：");
                        string str = "";
                        str = Console.ReadLine();
                        switch (str.Trim())
                        {
                            case "1":
                                LinesAdd();
                                break;
                            case "2":
                                LinesDelete();
                                break;
                            case "3":
                                LinesAlter();
                                break;
                            case "4":
                                LinesSelect();
                                break;
                            default:
                                Console.Write("非法操作！");
                                return;
                        }
                    }
                    break;
                default:
                    {
                        Console.Write("非法操作！");
                        return;
                    }
            }
        }


        //user函数，具有查询功能
        static void User()
        {
            Console.Clear();
            Console.WriteLine("您是普通用户，拥有查询权限");
            Console.WriteLine("      1、查询酒店信息");
            Console.WriteLine("      2、查询景点信息");
            Console.WriteLine("      3、查询线路信息");
            Console.Write("请输入序号选择您要查询的内容：");
            string str = Console.ReadLine();
            switch(str)
            {
                case "1":
                    HotelSelect();
                    break;
                case "2":
                    Tourist_spotSelect();
                    break;
                case "3":
                    LinesSelect();
                    break;
                default:
                    Console.WriteLine("非法输入！");
                    return;
            }
        }

        //hotel信息管理函数
        #region
        //hotel信息添加
        static void HotelAdd()
        {
            Console.WriteLine("请输入你要添加的酒店信息");
            Console.Write("酒店名称：");
            string str_hotel_name = Console.ReadLine() ;
            Console.Write("酒店地址：");
            string str_hotel_addr = Console.ReadLine();
            Console.Write("酒店电话：");
            string str_hotel_tel = Console.ReadLine();
            Console.Write("酒店价格：");
            int int_hotel_price = Convert.ToInt32(Console.ReadLine());
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
                sqlCon.Open();
                string isStr = @"insert into hotel values('" + str_hotel_name +"','" + str_hotel_addr + "'," 
                    + str_hotel_tel + ","+int_hotel_price+")";
                SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
                sqlCmd.ExecuteNonQuery();
                Console.WriteLine("酒店信息添加成功！");
            sqlCon.Close();
        }

        //hotel信息删除
        static void HotelDelete()
        {
            Console.WriteLine("请输入你要删除的酒店信息");
            Console.Write("酒店名称：");
            string str_hotel_name = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"delete from hotel where hotel_name ='" + str_hotel_name + "'";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("酒店信息删除成功！");
            sqlCon.Close();
        }

        //hotel信息修改
        static void HotelAlter()
        {
            Console.WriteLine("请输入要修改的酒店名称：");
            Console.Write("酒店名称：");
            string str_hotel_name_before = Console.ReadLine();
            Console.WriteLine("请输入修改后的酒店信息");
            Console.Write("酒店名称：");
            string str_hotel_name = Console.ReadLine();
            Console.Write("酒店地址：");
            string str_hotel_addr = Console.ReadLine();
            Console.Write("酒店电话：");
            string str_hotel_tel = Console.ReadLine();
            Console.Write("酒店价格：");
            int int_hotel_price = Convert.ToInt32(Console.ReadLine());
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"update hotel set  hotel_name ='" + str_hotel_name +
                "',hotel_addr='" + str_hotel_addr + "',hotel_tel ='" + str_hotel_tel
                + "',hotel_price=" + int_hotel_price + " where hotel_name='" + str_hotel_name_before + "'";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("酒店信息修改成功！");
            sqlCon.Close();
        }

        //hotel信息查询
        static void HotelSelect()
        {
            Console.WriteLine("请输入你要查询的酒店地址");
            Console.Write("酒店地址：");
            string str_hotel_addr = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"select * from hotel where hotel_addr ='" + str_hotel_addr + "'";
            string sltResult = "";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            SqlDataReader reader = sqlCmd.ExecuteReader();
            Console.WriteLine("查询结果：");
            if (reader.HasRows)
            {
                while(reader.Read())
                {
                    //记录每一条记录
                    sltResult += "名称："+reader["hotel_name"].ToString() +"\t电话：" + reader["hotel_tel"].ToString()
                        +"\t价格："+ reader["hotel_price"].ToString() + "\n";
                }
                Console.WriteLine(sltResult);
            }
            Console.WriteLine("酒店信息查询成功！");
            sqlCon.Close();
        }
        #endregion

        //tourist_spot信息管理函数
        #region
        //tourist_spot信息添加
        static void Tourist_spotAdd()
        {
            Console.WriteLine("请输入你要添加的景点信息");
            Console.Write("景点名称：");
            string str_Tourist_spot_name = Console.ReadLine();
            Console.Write("景点地址：");
            string str_Tourist_spot_addr = Console.ReadLine();
            Console.Write("景点价格：");
            int int_Tourist_spot_price = Convert.ToInt32(Console.ReadLine());
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"insert into tourist_spot values('" + str_Tourist_spot_name + "','" + str_Tourist_spot_addr + 
                "'," + int_Tourist_spot_price + ")";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("酒店信息添加成功！");
            sqlCon.Close();
        }

        //tourist_spot信息删除
        static void Tourist_spotDelete()
        {
            Console.WriteLine("请输入你要删除的景点信息");
            Console.Write("景点名称：");
            string str_tourist_spot_name = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"delete from tourist_spot where tourist_spot_name ='" + str_tourist_spot_name + "'";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("景点信息删除成功！");
            sqlCon.Close();
        }

        //tourist_spot信息修改
        static void Tourist_spotAlter()
        {
            Console.WriteLine("请输入要修改的景点名称：");
            Console.Write("景点名称：");
            string str_Tourist_spot_name_before = Console.ReadLine();
            Console.WriteLine("请输入修改后的景点信息");
            Console.Write("景点名称：");
            string str_Tourist_spot_name = Console.ReadLine();
            Console.Write("景点地址：");
            string str_Tourist_spot_addr = Console.ReadLine();
            Console.Write("景点价格：");
            int int_Tourist_spot_price = Convert.ToInt32(Console.ReadLine());
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"update tourist_spot set  tourist_spot_name ='" + str_Tourist_spot_name +
                "',tourist_spot_addr='" + str_Tourist_spot_addr + "',tourist_spot_price=" +
                int_Tourist_spot_price + " where tourist_spot_name='" + str_Tourist_spot_name_before + "'";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("景点信息修改成功！");
            sqlCon.Close();
        }

        //tourist_spot信息查询
        static void Tourist_spotSelect()
        {
            Console.Write("请输入你要查询的景点地址：");
            string str_Tourist_spot_addr = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"select * from tourist_spot where tourist_spot_addr ='" + str_Tourist_spot_addr + "'";
            string sltResult = "";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            SqlDataReader reader = sqlCmd.ExecuteReader();
            Console.WriteLine("查询结果：");
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    //记录每一条记录
                    sltResult += "名称：" + reader["tourist_spot_name"].ToString() 
                        + "\t价格：" + reader["tourist_spot_price"].ToString() + "\n";
                }
                Console.WriteLine(sltResult);
            }
            Console.WriteLine("景点信息查询成功！");
            sqlCon.Close();
        }
        #endregion

        //lines信息管理函数
        #region
        //lines信息添加
        static void LinesAdd()
        {
            Console.WriteLine("请输入你要添加的线路信息");
            Console.Write("车次号码：");
            string str_lines_num = Console.ReadLine();
            Console.Write("发车时间：");
            string str_lines_time = Console.ReadLine();
            Console.Write("火车起点：");
            string str_lines_from = Console.ReadLine();
            Console.Write("火车终点：");
            string str_lines_to = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"insert into lines values('" + str_lines_num + "','" + str_lines_time + "','" + 
                str_lines_from + "','" + str_lines_to + "')";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("线路信息添加成功！");
            sqlCon.Close();
        }

        //lines信息删除
        static void LinesDelete()
        {
            Console.WriteLine("请输入你要删除的线路信息");
            Console.Write("车次号码：");
            string str_lines_num = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"delete from lines where lines_num =" + str_lines_num ;
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("线路信息删除成功！");
            sqlCon.Close();
        }

        //lines信息修改
        static void LinesAlter()
        {
            Console.WriteLine("请输入你要修改的线路信息");
            Console.Write("车次号码：");
            string str_lines_num_before = Console.ReadLine();
            Console.WriteLine("请输入修改后的线路信息");
            Console.Write("车次号码：");
            string str_lines_num = Console.ReadLine();
            Console.Write("发车时间：");
            string str_lines_time = Console.ReadLine();
            Console.Write("火车起点：");
            string str_lines_from = Console.ReadLine();
            Console.Write("火车终点：");
            string str_lines_to = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"update lines set  lines_num ='" + str_lines_num + "',lines_time='" +
                str_lines_time + "',lines_from='" + str_lines_from + "',lines_to='" + str_lines_to
                + "' where lines_num=" + str_lines_num_before;
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            sqlCmd.ExecuteNonQuery();
            Console.WriteLine("线路信息修改成功！");
            sqlCon.Close();
        }

        //lines信息查询
        static void LinesSelect()
        {
            Console.Write("请输入你要查询的车次号码：");
            string str_lines_num = Console.ReadLine();
            string StrCon = @"Data Source = .;Initial Catalog=tourResour_lines;" +
                "Integrated Security = True;";
            SqlConnection sqlCon = new SqlConnection(StrCon);
            sqlCon.Open();
            string isStr = @"select * from lines where lines_num =" + str_lines_num ;
            string sltResult = "";
            SqlCommand sqlCmd = new SqlCommand(isStr, sqlCon);
            SqlDataReader reader = sqlCmd.ExecuteReader();
            Console.WriteLine("查询结果：");
            if (reader.HasRows) 
            {
                while (reader.Read())
                {
                    //记录每一条记录
                    sltResult += "车次号码：" + reader["lines_num"].ToString() + "\t发车时间：" +
                        reader["lines_time"].ToString() + "\t起始地点：" + reader["lines_from"].ToString() +
                        "\t终点城市："+reader["lines_to"].ToString() + "\n";
                }
                Console.WriteLine(sltResult);
            }
            Console.WriteLine("线路信息查询成功！");
            sqlCon.Close();
        }
        #endregion
    }
}