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;

namespace?HotelManage
{
????public?partial?class?AddRoom?:?Form
????{
????????public?AddRoom（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?btnAdd_Click（object?sender?EventArgs?e）
????????{
????????????string?sql?;
????????????string?roomType=cboRoomType.Text;
????????????string?roomNumber=txtRoomNumber.Text;
????????????float?roomPrice=float.Parse（txtRoomPrice.Text）;
????????????string?remarks=txtRemarks.Text;
????????????int?result;
????????????sql?=?“insert?into?RoomInfo（RoomNumberRoomTypeRoomPriceRemarks）?values（?‘“?+?roomNumber?+?“‘‘“?+?roomType?+?“‘“?+?roomPrice?+?“‘“?+?remarks?+?“‘）“;//定義插入語句
????????????if?（txtRoomNumber.Text?!=?““?&&?txtRoomPrice.Text?!=?““?&&?cboRoomType.Text?!=?““）//判斷輸入文本框等是否有數(shù)據(jù)
????????????{
????????????????result?=?DBHelper.ExecuteSql（sql）;//執(zhí)行插入語句，返回影響行數(shù)
????????????????if?（result?==?1）//根據(jù)返回影響行數(shù)判斷是否插入數(shù)據(jù)成功
????????????????{
????????????????????MessageBox.Show（“客房添加成功！“?“成功提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“客房添加失敗！“?“錯誤提示“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????}
????????????}
????????????else
????????????{
????????????????MessageBox.Show（“請檢查數(shù)據(jù)輸入的正確性！“?“錯誤提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????}
????????}

????????private?void?btnExit_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;//關(guān)閉當(dāng)前窗體
????????}
????}
}

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

????..A..H.?????90624??2018-12-27?22:15??4酒店客房管理系統(tǒng)\HotelManage\.vs\HotelManage\v14\.suo

?????文件????3145728??2018-12-11?22:28??4酒店客房管理系統(tǒng)\HotelManage\data\2005\Hotel.mdf

?????文件????1048576??2018-12-11?22:28??4酒店客房管理系統(tǒng)\HotelManage\data\2005\Hotel_log.ldf

?????文件????3145728??2018-12-11?07:41??4酒店客房管理系統(tǒng)\HotelManage\data\2008\Hotel.mdf

?????文件????3538944??2018-12-11?15:49??4酒店客房管理系統(tǒng)\HotelManage\data\2008\Hotel_log.ldf

?????文件???????1917??2014-05-15?15:07??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddRoom.cs

?????文件???????8279??2014-05-15?15:07??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddRoom.Designer.cs

?????文件???????5817??2014-05-15?15:07??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddRoom.resx

?????文件???????1941??2014-05-06?17:50??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddUser.cs

?????文件???????6769??2014-05-06?17:50??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddUser.Designer.cs

?????文件???????5817??2014-05-06?17:50??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\AddUser.resx

????.......????304640??2018-12-27?12:45??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\bin\Debug\HotelManage.exe

?????文件?????130560??2018-12-27?12:45??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\bin\Debug\HotelManage.pdb

????.......?????22696??2018-12-27?22:15??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\bin\Debug\HotelManage.vshost.exe

?????文件????????490??2017-09-29?21:43??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\bin\Debug\HotelManage.vshost.exe.manifest

?????文件???????4198??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookRoom.cs

?????文件??????17971??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookRoom.Designer.cs

?????文件???????5817??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookRoom.resx

?????文件???????1431??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookSearch.cs

?????文件???????9140??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookSearch.Designer.cs

?????文件???????5817??2014-05-15?15:08??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\BookSearch.resx

?????文件???????3049??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CancelReservation.cs

?????文件??????17313??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CancelReservation.Designer.cs

?????文件???????5817??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CancelReservation.resx

?????文件???????4859??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckIn.cs

?????文件??????20451??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckIn.Designer.cs

?????文件???????5817??2014-05-15?15:09??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckIn.resx

?????文件???????6601??2014-05-15?15:11??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckOut.cs

?????文件??????14922??2014-05-15?15:11??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckOut.Designer.cs

?????文件???????5817??2014-05-15?15:11??4酒店客房管理系統(tǒng)\HotelManage\HotelManage\CheckOut.resx

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