//文件名：BookForm.cs
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?MyHotel
{
????public?partial?class?BookForm?:?Form
????{
????????public?BookForm（）
????????{
????????????InitializeComponent（）;
????????}
????????public?string?MyOperator;
????????public?String?MyCompany;

????????private?void?BookForm_Load（object?sender?EventArgs?e）
????????{
????????????//添加酒店房間類(lèi)別ComboBox控件的列表項(xiàng)
????????????SqlConnection?MyConnection?=?new?SqlConnection（）;
????????????MyConnection.ConnectionString?=?global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
????????????MyConnection.Open（）;
????????????SqlCommand?MyCommand?=?new?SqlCommand（“Select?DISTINCT?類(lèi)別??From?酒店房間“?MyConnection）;
????????????SqlDataReader?MyReader?=?MyCommand.ExecuteReader（）;
????????????while?（MyReader.Read（））
????????????{
????????????????this.酒店房間類(lèi)別ComboBox.Items.Add（MyReader.GetString（0））;
????????????}
????????????this.酒店房間類(lèi)別ComboBox.Items.Add（“所有房間“）;
????????????this.酒店房間類(lèi)別ComboBox.Text?=?“所有房間“;
????????????if?（MyConnection.State?==?ConnectionState.Open）
????????????{
????????????????MyConnection.Close（）;
????????????}
????????}

????????private?void?酒店房間類(lèi)別ComboBox_SelectedIndexChanged（object?sender?EventArgs?e）
????????{
????????????//獲取未完全入住房間信息
????????????this.酒店可用房間DataGridView.GridColor?=?Color.Blue;
????????????String?MySQLConnectionString?=?global::MyHotel.Properties.Settings.Default.MyHotelConnectionString;
????????????string?MySQL?=?“Select?房號(hào)單價(jià)可容納人數(shù)-已入住人數(shù)?as?可入住人數(shù)樓層類(lèi)別說(shuō)明可容納人數(shù)已入住人數(shù)?From?酒店房間?Where?類(lèi)別=‘“?+?this.酒店房間類(lèi)別ComboBox.Text?+?“‘“;
????????????if?（this.酒店房間類(lèi)別ComboBox.Text?==?“所有房間“）
????????????{
????????????????MySQL?=?“Select?房號(hào)單價(jià)可容納人數(shù)-已入住人數(shù)?as?可入住人數(shù)樓層類(lèi)別說(shuō)明可容納人數(shù)已入住人數(shù)?From?酒店房間?“;
????????????}
????????????SqlConnection?MyConnection?=?new?SqlConnection（MySQLConnectionString）;
????????????MyConnection.Open（）;
????????????DataTable?MyTable?=?new?DataTable（）;
????????????SqlDataAdapter?MyAdapter?=?new?SqlDataAdapter（MySQL?MyConnection）;
????????????MyAdapter.Fill（MyTable）;
????????????this.酒店可用房間DataGridView.DataSource?=?MyTable;
????????????if?（MyConnection.State?==?ConnectionState.Open）
????????????{
????????????????MyConnection.Close（）;
????????????}
????????}

????????private?void?酒店可用房間DataGridView_Click（object?sender?EventArgs?e）
????????{
????????????//確定是否設(shè)置房號(hào)和住宿人數(shù)信息
????????????this.房號(hào)TextBox.Text?=?this.酒店可用房間DataGridView.CurrentRow.Cells[0].Value.ToString（）;
????????????int?MyCount?=?Convert.ToInt16（this.酒店可用房間DataGridView.CurrentRow.Cells[2].Value.ToString（））;
????????????this.住宿人數(shù)ComboBox.Items.Clear（）;
????????????for?（int?i?=?1;?i?<=?MyCount;?i++）
????????????{
????????????????this.住宿人數(shù)ComboBox.Items.Add（i.ToString（））;
????????????}
????????????this.住宿人數(shù)ComboBox.Text?=?MyCount.ToString（）;
????????}

??

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2012-02-21?16:48??賓館酒店管理系統(tǒng)\
?????目錄???????????0??2012-02-21?16:48??賓館酒店管理系統(tǒng)\Backup\
?????目錄???????????0??2012-02-21?16:48??賓館酒店管理系統(tǒng)\Backup\MyHotel\
?????文件?????????405??2006-11-28?16:08??賓館酒店管理系統(tǒng)\Backup\MyHotel\app.config
?????文件???????12914??2007-02-17?11:16??賓館酒店管理系統(tǒng)\Backup\MyHotel\BookForm.cs
?????文件???????23435??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\BookForm.Designer.cs
?????文件???????25358??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\BookForm.resx
?????文件????????5819??2007-02-17?11:16??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeForm.cs
?????文件???????11881??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeForm.Designer.cs
?????文件????????7144??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeForm.resx
?????文件????????2124??2007-02-16?20:57??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeUserPasswordForm.cs
?????文件????????8866??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeUserPasswordForm.Designer.cs
?????文件????????7080??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ChangeUserPasswordForm.resx
?????文件???????18899??2007-02-17?11:16??賓館酒店管理系統(tǒng)\Backup\MyHotel\CheckOutForm.cs
?????文件???????23593??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\CheckOutForm.Designer.cs
?????文件???????22860??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\CheckOutForm.resx
?????文件?????????981??2007-02-16?20:57??賓館酒店管理系統(tǒng)\Backup\MyHotel\CompanyForm.cs
?????文件???????35619??2006-12-10?21:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\CompanyForm.Designer.cs
?????文件???????14872??2006-12-10?21:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\CompanyForm.resx
?????文件???????14435??2007-02-17?09:15??賓館酒店管理系統(tǒng)\Backup\MyHotel\ConsumeForm.cs
?????文件???????17912??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ConsumeForm.Designer.cs
?????文件???????23424??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\ConsumeForm.resx
?????文件???????12232??2007-02-17?09:15??賓館酒店管理系統(tǒng)\Backup\MyHotel\DepositForm.cs
?????文件???????20069??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\DepositForm.Designer.cs
?????文件???????22860??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\DepositForm.resx
?????文件???????13221??2007-02-17?09:15??賓館酒店管理系統(tǒng)\Backup\MyHotel\EatingForm.cs
?????文件???????15164??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\EatingForm.Designer.cs
?????文件???????23618??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\EatingForm.resx
?????文件???????13762??2007-02-17?11:16??賓館酒店管理系統(tǒng)\Backup\MyHotel\FromBookToRegisterForm.cs
?????文件???????26662??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\FromBookToRegisterForm.Designer.cs
?????文件???????26134??2006-12-10?23:04??賓館酒店管理系統(tǒng)\Backup\MyHotel\FromBookToRegisterForm.resx
............此處省略314個(gè)文件信息