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


namespace?HospitalityManagementSystem
{
????public?partial?class?AddBeautySpot?:?Form
????{
????????public?AddBeautySpot（）
????????{
????????????InitializeComponent（）;
????????}

????????
????????private?void?insert（）
????????{
????????????int?res?=?0;
????????????SqlConnection?conn?=?SqlData.CreateConn（）;
????????????conn.Open（）;
???????????//?this.txtHid.Text=?“select?Hid?from?Hotel?where?Hname=‘“?+?this.comboBox1.SelectedItem?+?“‘“;
????????????string?str?=?“insert?into?Beautyspot?（BSidBSnameVisitingdayHid）?values?（‘“?+?this.txtBSid.Text?+?“‘‘“?+?this.txtBSname.Text?+?“‘‘“?+?this.txtvisitingday.Text?+?“‘‘“?+this.txtHid.Text?+?“‘）“;
????????????SqlCommand?cmd1?=?new?SqlCommand（str?conn）;
????????????//cmd1.ExecuteNonQuery（）;
????????????res?=?（int）cmd1.ExecuteNonQuery（）;
????????????if?（res?==?1）
????????????{
????????????????MessageBox.Show（“添加成功“）;
????????????}

????????????conn.Close（）;

????????}

????????private?void?AddBeautySpot_Load（object?sender?EventArgs?e）
????????{
????????????//?TODO:?這行代碼將數據加載到表“myDatabaseDataSet1.Beautyspot”中。您可以根據需要移動或移除它。
????????????//this.beautyspotTableAdapter.Fill（this.myDatabaseDataSet.Beautyspot）;
????????????hotellist（）;
????????????BSlist（）;
????????}

????????private?void?BSlist（）?
????????{
????????????SqlConnection?conn?=?SqlData.CreateConn（）;
????????????conn.Open（）;
????????????string?str?=?“select?*?from?Beautyspot“;
????????????SqlCommand?cmd?=?new?SqlCommand（strconn）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（cmd）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds“Beautyspot“）;
????????????this.dataGridView1.DataSource=ds.Tables[“Beautyspot“];
?????????
????????}
????????private?void?hotellist（）
????????{
????????????SqlConnection?conn?=?SqlData.CreateConn（）;
????????????conn.Open（）;
????????????string?str?=?“select?Hname?from?Hotel“;
????????????SqlCommand?cmd1?=?new?SqlCommand（str?conn）;
????????????SqlDataReader?dr1?=?cmd1.ExecuteReader（）;
????????????while?（dr1.Read（））
????????????{
????????????????this.comboBox1.Items.Add（dr1[“Hname“].ToString（））;
????????????}

????????????dr1.Close（）;
????????????conn.Close（）;
????????}

????????private?void?textBox2_TextChanged（object?sender?EventArgs?e）
????????{

????????}


????????private?void?button1_Click_1（object?sender?EventArgs?e）
????????{
????????????insert（）;
????????????this.BSlist（）;
????????}

????????private?void?comboBox1_SelectedIndexChanged（object?sender?EventArgs?e）
????????{

????????????SqlConnection?conn?=?SqlData.CreateConn（）;
????????????conn.Open（）;
????????????string?str=“select?Hid?from?Hotel?where?Hname=‘“?+?this.comboBox1.SelectedItem?+?“‘“;
????????????this.txtHid.Text?=?str;
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3197??2009-12-23?12:43??HospitalityManagementSystem\HospitalityManagementSystem\AddBeautySpot.cs

?????文件???????8906??2009-12-23?12:43??HospitalityManagementSystem\HospitalityManagementSystem\AddBeautySpot.Designer.cs

?????文件???????5814??2009-12-23?12:43??HospitalityManagementSystem\HospitalityManagementSystem\AddBeautySpot.resx

?????文件???????6933??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddCustomer.cs

?????文件??????20026??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddCustomer.Designer.cs

?????文件???????6438??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddCustomer.resx

?????文件????????503??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddEmployee.cs

?????文件???????7424??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddEmployee.Designer.cs

?????文件???????5814??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddEmployee.resx

?????文件????????497??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddHotel.cs

?????文件???????7505??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddHotel.Designer.cs

?????文件???????5814??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\AddHotel.resx

?????文件????????495??2009-12-23?13:06??HospitalityManagementSystem\HospitalityManagementSystem\AddTeam.cs

?????文件???????7505??2009-12-23?13:06??HospitalityManagementSystem\HospitalityManagementSystem\AddTeam.Designer.cs

?????文件???????5814??2009-12-23?13:06??HospitalityManagementSystem\HospitalityManagementSystem\AddTeam.resx

?????文件????????471??2009-12-05?15:49??HospitalityManagementSystem\HospitalityManagementSystem\app.config

?????文件?????526336??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.exe

?????文件????????471??2009-12-05?15:49??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.exe.config

?????文件?????140800??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.pdb

?????文件??????14328??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.vshost.exe

?????文件????????471??2009-12-05?15:49??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.vshost.exe.config

?????文件????????490??2007-07-21?01:33??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\HospitalityManagementSystem.vshost.exe.manifest

?????文件????2293760??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\MyDatabase.mdf

?????文件?????573440??2009-12-23?12:45??HospitalityManagementSystem\HospitalityManagementSystem\bin\Debug\MyDatabase_log.ldf

?????文件????????772??2009-10-11?15:55??HospitalityManagementSystem\HospitalityManagementSystem\Form1.cs

?????文件???????6798??2009-10-11?15:55??HospitalityManagementSystem\HospitalityManagementSystem\Form1.Designer.cs

?????文件?????267566??2009-10-11?15:55??HospitalityManagementSystem\HospitalityManagementSystem\Form1.resx

?????文件???????8837??2009-12-22?19:11??HospitalityManagementSystem\HospitalityManagementSystem\HospitalityManagementSystem.csproj

?????文件????????486??2009-12-05?17:43??HospitalityManagementSystem\HospitalityManagementSystem\HospitalityManagementSystem.csproj.user

?????文件???????1425??2009-12-23?12:40??HospitalityManagementSystem\HospitalityManagementSystem\MainForm.cs

............此處省略49個文件信息