示例#1
0
 private void finishOrder_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         orders oder = orderList.SelectedItems[0] as orders;
         string sql  = "update orders set isFinished='1' where time='" + oder.time.Text + "'";
         mysqlwrite(sql);
         orderListRefresh();
         guestName.Clear();
         address.Clear();
         orderInfo.Items.Clear();
     }
     catch { }
     menuRefresh();
 }
示例#2
0
        private void orderListRefresh()
        {
            this.orderList.Items.Clear();
            string          sql       = "select name,isEatHere,price,time from orders where isFinished='0' order by time desc";
            MySqlDataReader get_order = getmysqlread(sql);

            while (get_order.Read())
            {
                orders temp = new orders();
                temp.name.Text = get_order["name"].ToString();
                if (get_order["isEatHere"].ToString() == "1")
                {
                    temp.option.Text = "堂吃";
                }
                else
                {
                    temp.option.Text = "外卖";
                }
                temp.price.Text = "¥ " + get_order["price"].ToString();
                DateTime dt = (DateTime)get_order["time"];
                temp.time.Text = dt.Year.ToString() + "/" + dt.ToString();
                this.orderList.Items.Add(temp);
            }
        }