?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace 餐飲管理系統
{
    public partial class frm添加預定類型 : Form
    {
        public frm添加預定類型()
        {
            InitializeComponent();
        }
        //添加餐臺編號到listbox中
        private void button1_Click(object sender, EventArgs e)
        {
            this.listBox1.Items.Add(textBoxTableNo.Text);
            textBoxTableNo.Text = "";
            textBoxTableNo.Focus();
        }

        private void buttonOK_Click(object sender, EventArgs e)
        {
            foreach (string strItem in listBox1.Items)
            {
                string strSql = string.Format("insert into dt_Htype@TabNo(房間類型,餐臺編號)values('{0}','{1}')",
                textBoxHtype.Text.Trim(), strItem);
                DBserver.setCommNornQuey(strSql);
            }
            this.DialogResult = DialogResult.OK;
        }
    }
}