frm添加预定类型.cs

c#can yin guan li xi tong

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;
        }
    }
}