用C#与数据库实现吃货联盟订餐系统

冷不防 2021-11-16 19:12 424阅读 0赞

## **下面是自己用C\#写的一个使用数据库实现订餐管理系统管理** ##

**（大神勿喷，初学者以借鉴为主）**

一共分为三个类分别是：Program（启动类），Zhuang（封装操作语句类），Zuo（操作类）

--------------------

***数据库表（如下）：***

**1.菜袋表**

**![20190729105731415.png][]**

**2.菜品表 **

**![20190729105820754.png][]**

> **注意**：菜袋表的dishMegs 和 菜品表的name 为主外键关系

**3.管理员表 **

**![20190729110137778.png][]**

--------------------

***代码部分（如下）：***

> 既然使用了数据库那么using还是要记得导入的呦：
> 
> using System.Data.SqlClient;  
> using System.Data;

**Program（启动类）：**

class Program
        {
            static void Main(string[] args)
            {
                Zuo zuo = new Zuo();
                zuo.DengLu();
                Console.ReadLine();
            }
        }

**Zhuang（封装操作语句类）：**

class Zhuang
        {
            private const string CONNSTR = "server=.;database=Demo2;uid=sa;pwd=sa";
            private SqlConnection _conn;
            public SqlConnection Conn {
                get {
                    if (_conn != null)
                    {
                        if (_conn.State == ConnectionState.Broken || _conn.State == ConnectionState.Open)
                        {
                            _conn.Close();
                        }
                    }
                    else {
                        _conn = new SqlConnection(CONNSTR);
                    }
                    _conn.Open();
                    return _conn;
                }
            }
            private SqlCommand _cmd;
            public SqlCommand Cmd {
                get {
                    _cmd = new SqlCommand();
                    _cmd.Connection = Conn;
                    return _cmd;
                }
            }
            //查询ExecuteReader
            public SqlDataReader ExecuteReader(string sql) {
                SqlCommand cmd = Cmd;
                cmd.CommandText = sql;
                SqlDataReader reader =  cmd.ExecuteReader(CommandBehavior.CloseConnection);
                return reader;
            }
            //查询ExecuteScalar
            public object ExecuteScalar(string sql) {
                SqlCommand cmd = Cmd;
                cmd.CommandText = sql;
                object obj = cmd.ExecuteScalar();
                cmd.Connection.Close();
                return obj;
            }
            //增，删，改ExecuteNonQuery
            public int ExecuteNonQuery(string sql) {
                SqlCommand cmd = Cmd;
                cmd.CommandText = sql;
                int result = cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                return result;
            }
        }

**Zuo（操作类）：**

class Zuo
        {
            Zhuang zhang = new Zhuang();
            //管理员登录
            #region  管理员登录
            public void DengLu() {
                Console.Write("请输入管理员用户名：");
                string username = Console.ReadLine();
                Console.Write("请输入管理员密码：");
                string password = Console.ReadLine();
                string sql = "SELECT username,[password] FROM GuanLi";
                SqlDataReader reader = zhang.ExecuteReader(sql);
                if (reader.HasRows) {
                    while (reader.Read())
                    {
                        if (username.Equals(reader["username"]) && password.Equals(reader["password"])) {
                            reader.Close();
                            Console.WriteLine("登录成功！");
                            CaiDan();
                            return;
                        }
                    }
                }
                reader.Close();
                Console.WriteLine("登录失败！");
                return;
            }
            #endregion
    
            //菜单
            #region  菜单
            public void CaiDan() {
                bool huan = true;
                do {
                    Console.WriteLine("\n************欢迎使用老明宇吃货联盟订单系统************");
                    Console.WriteLine("1.我要订餐\n2.查看菜袋\n3.签收订单\n4.删除订单\n5.我要点赞\n6.退出系统");
                    Console.WriteLine("******************************************************");
                    Console.Write("请选择：");
                    int xuanZe = int.Parse(Console.ReadLine());
                    switch (xuanZe)
                    {
                        case 1:
                            Console.WriteLine("-->我要订餐");
                            DingDan();
                            continue;
                        case 2:
                            Console.WriteLine("-->查看菜袋");
                            LookCaiDai();
                            continue;
                        case 3:
                            Console.WriteLine("-->签收订单");
                            QianShou();
                            continue;
                        case 4:
                            Console.WriteLine("-->删除订单");
                            DeleteDingDan();
                            continue;
                        case 5:
                            Console.WriteLine("-->我要点赞");
                            IZan();
                            continue;
                        case 6:
                            Console.WriteLine("-->欢迎使用，感谢您的下次光临！");
                            huan = false;
                            break;
                        default:
                            Console.WriteLine("-->无该选项！");
                            continue;
                    }
                } while (huan);
            }
            #endregion
    
            //one:我要订餐
            #region  我要订餐
            public void DingDan() {
                Console.WriteLine("请输入订单人的姓名：");
                string names = Console.ReadLine();
                Console.WriteLine("序号\t菜名\t单价\t点赞数");
                string sql = "SELECT caiID,name,money,Zan FROM CaiDan";
                SqlDataReader reader = zhang.ExecuteReader(sql);
                if (reader.HasRows) {
                    while (reader.Read()) {
                        Console.WriteLine("{0}\t{1}\t{2}\t{3}",reader["caiID"],reader["name"], reader["money"], reader["Zan"]);
                    }
                }
                reader.Close();
                Console.WriteLine("请输入您要点的菜品编号：");
                int bianHao = int.Parse(Console.ReadLine());
                SqlDataReader reader1 = zhang.ExecuteReader(sql);
                string caipinName = null;//菜品名称
                double danJia = 0.0;//菜品单价
                while (reader1.Read()) {
                    if (bianHao == Convert.ToInt32(reader1["caiID"])) {
                        caipinName = reader1["name"].ToString();
                        danJia = Convert.ToDouble(reader1["money"]);
                        break;
                    }
                }
                if (caipinName == null) {
                    Console.WriteLine("对不起，没有该编号！");
                    return;
                }
                reader1.Close();
                Console.WriteLine("请输入您的需要的份数：");
                int fenShu = int.Parse(Console.ReadLine());
                Console.WriteLine("请输入送餐时间（送餐时间是10~20点间整点送餐）：");
                int shiJian = int.Parse(Console.ReadLine());
                if (shiJian<10 || shiJian>20) {
                    Console.WriteLine("对不起，因为任性我们只在10~20整点送餐！");
                    return;
                }
                Console.WriteLine("请输入送货地址：");
                string diZhi = Console.ReadLine();  //状态中0表示以预定，1表示已完成
                double zje = 0.0;//总金额
                const int yunFei = 5;//运费
                if (danJia * fenShu < 50)
                {
                    zje = danJia * fenShu + yunFei;
                }
                else {
                    zje = danJia * fenShu;
                }
                string sql1 = "INSERT INTO UserCaiDan VALUES ('"+names+"','"+ caipinName + "',"+ fenShu + ","+ shiJian + ",'"+ diZhi + "','0','"+ zje + "')";
                int result = zhang.ExecuteNonQuery(sql1);
                if (result == 1)
                {
                    Console.WriteLine("订单成功！");
                }
                else {
                    Console.WriteLine("对不起，订单失败！");
                }
                FanHui();//返回
            }
            #endregion
    
            //two:查看菜袋
            #region  查看菜袋
            public void LookCaiDai() {
                Console.WriteLine("序号\t订单人\t餐品信息\t送餐日期\t送餐地址\t总金额\t订单状态");
                string sql = "SELECT userID,name,dishMegs,fenShu,times,address,states,sumPrices FROM UserCaiDan";
                SqlDataReader reader = zhang.ExecuteReader(sql);
                if (reader.HasRows) {
                    while (reader.Read()) {
                        string tai = Convert.ToInt32(reader["states"])==0 ? "已预定":"已完成";
                        Console.WriteLine("{0}\t{1}\t{2}\t{3}\t\t{4}\t\t{5}\t{6}",reader["userID"], reader["name"], reader["dishMegs"].ToString()+reader["fenShu"]+"份", reader["times"], reader["address"], reader["sumPrices"], tai);
                    }
                }
                reader.Close();
                FanHui();//返回
            }
            #endregion
    
            //three:签收订单
            #region  签收订单
            public void QianShou() {
                Console.WriteLine("请输入要签收的订单序号：");
                int xuHao = int.Parse(Console.ReadLine());
                string sql = "UPDATE UserCaiDan SET states = 1 WHERE userID = "+ xuHao + "";
                int gai = zhang.ExecuteNonQuery(sql);
                if (gai == 1)
                {
                    Console.WriteLine("签收成功！");
                }
                else {
                    Console.WriteLine("对不起，签收失败！");
                }
                FanHui();//返回
            }
            #endregion
    
            //four:删除订单
            #region  删除订单
            public void DeleteDingDan() {
                Console.WriteLine("请输入要删除的订单序号：");
                int xuHao = int.Parse(Console.ReadLine());
                string sql1 = "SELECT userID FROM UserCaiDan";
                SqlDataReader reader = zhang.ExecuteReader(sql1);
                bool qianShou = true;//订单是否签收
                while (reader.Read()) {
                    if (xuHao == Convert.ToInt32(reader["userID"])) {
                        qianShou = false;
                        break;
                    }
                }
                reader.Close();
                if (qianShou)
                {
                    Console.WriteLine("对不起，没有找到该序号！");
                }
                else {
                    string sql = "DELETE FROM UserCaiDan WHERE states = 1";
                    int gai = zhang.ExecuteNonQuery(sql);
                    if (gai == 1)
                    {
                        Console.WriteLine("删除成功！");
                    }
                    else
                    {
                        Console.WriteLine("对不起，您选择的订单未签收，不可删除！");
                    }
                }
                FanHui();//返回
            }
            #endregion
    
            //five:我要点赞
            #region  我要点赞
            public void IZan() {
                Console.WriteLine("序号\t菜名\t\t单价\t点赞数");
                string sql = "SELECT caiID,name,money,Zan FROM CaiDan";
                SqlDataReader reader = zhang.ExecuteReader(sql);
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        Console.WriteLine("{0}\t{1}\t{2}\t{3}", reader["caiID"], reader["name"], reader["money"], reader["Zan"]);
                    }
                }
                reader.Close();
                Console.WriteLine("请输入您要点赞的菜品序号：");
                int bianHao = int.Parse(Console.ReadLine());
                SqlDataReader reader1 = zhang.ExecuteReader(sql);
                bool cunZai = true;
                while (reader1.Read())
                {
                    if (bianHao == Convert.ToInt32(reader1["caiID"]))
                    {
                        cunZai = false;
                        break;
                    }
                }
                if (cunZai)
                {
                    Console.WriteLine("对不起，没有该编号！");
                    return;
                }
                reader1.Close();
                string sql2 = "UPDATE CaiDan SET Zan = Zan+1 WHERE caiID = "+ bianHao + "";
                int gai = zhang.ExecuteNonQuery(sql2);
                if (gai == 1)
                {
                    Console.WriteLine("点赞成功！");
                }
                else {
    
                    Console.WriteLine("对不起，点赞失败！");
                }
                FanHui();//返回
            }
            #endregion
    
            //输入0返回方法
            #region  输入0返回方法
            public void FanHui() {
                int shuRu = 0;
                do {
                    Console.Write("输入0返回：");
                    shuRu = int.Parse(Console.ReadLine());
                } while (shuRu != 0);
                CaiDan();
            }
            #endregion
    
        }

封装类有宝宝们还不懂的请打开：

[https://blog.csdn.net/qq\_44860582/article/details/97615515][https_blog.csdn.net_qq_44860582_article_details_97615515]

[20190729105731415.png]: /images/20211116/c63e890fa6154786a17f002d662cf046.png
[20190729105820754.png]: /images/20211116/82bd504b9b274017a85c1a383acce258.png
[20190729110137778.png]: /images/20211116/a8cbffa1e7904760b6ae52a34c8bffc2.png
[https_blog.csdn.net_qq_44860582_article_details_97615515]: https://blog.csdn.net/qq_44860582/article/details/97615515