c# 酒店客房管理系统Word文档格式.docx
《c# 酒店客房管理系统Word文档格式.docx》由会员分享,可在线阅读,更多相关《c# 酒店客房管理系统Word文档格式.docx(80页珍藏版)》请在冰豆网上搜索。
usingSystem.Text;
usingSystem.Windows.Forms;
namespacejdkfglxt
{
publicpartialclassBuildInfo:
Form
{
publicBuildInfo()
InitializeComponent();
}
privatevoidBuildInfo_Load(objectsender,EventArgse)
stringsql="
select*fromDB_BuildInfoorderbybuildId"
;
try
SqlDataReaderdataReader=DBHelper.GetResult(sql);
while(dataReader.Read())
ListViewItemlviManageInfo=newListViewItem();
lviManageInfo.SubItems.Clear();
lviManageInfo.SubItems[0].Text=dataReader["
buildId"
].ToString();
lviManageInfo.SubItems.Add(dataReader["
buildArea"
].ToString());
buildNo"
buildMsg"
listView1.Items.Add(lviManageInfo);
}
dataReader.Close();
DBHelper.connection.Close();
dCboBuildArea.Items.Clear();
sql="
selectdistinctbuildAreafromDB_BuildInfo"
dataReader=DBHelper.GetResult(sql);
dCboBuildArea.Items.Add(dataReader[0].ToString());
finally
txtBuildNo.Clear();
cboBuildMsg.SelectedIndex=-1;
lblBuildArea.Text="
"
lblBuildId.Text="
lblBuildNo.Text="
dCboBulidMsg.SelectedIndex=-1;
if(listView1.Items.Count==0)
dCboBuildArea.Enabled=false;
else
dCboBuildArea.Enabled=true;
privatevoidbutton1_Click(objectsender,EventArgse)
if(dCboBuildArea.Text=="
)
MessageBox.Show
("
请?
选?
择?
所¨
´
要°
a查¨
¦
询¡
¥
的Ì
?
地Ì
理¤
¨
ª
区?
域®
°
!
"
操¨
作Á
¡
Â
提¬
¢
示º
MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
stringsql=String.Format("
select*fromDB_BuildInfowherebuildArea='
{0}'
dCboBuildArea.Text);
SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);
DBHelper.connection.Open();
SqlDataReaderdataReader=command.ExecuteReader();
if(!
dataReader.Read())
查¨
无T此ä
记?
录?
sql=String.Format("
command.CommandText=sql;
dataReader=command.ExecuteReader();
listView1.Items.Clear();
catch(Exceptionex)
MessageBox.Show(ex.Message);
privatevoidbutton2_Click(objectsender,EventArgse)
BuildInfo_Load(sender,e);
privatevoidlistView1_ItemSelectionChanged(objectsender,ListViewItemSelectionChangedEventArgse)
if(e.IsSelected)
lblBuildId.Text=e.Item.SubItems[0].Text;
lblBuildArea.Text=e.Item.SubItems[1].Text;
lblBuildNo.Text=e.Item.SubItems[2].Text;
dCboBulidMsg.Text=e.Item.SubItems[3].Text;
privatevoidbutton3_Click(objectsender,EventArgse)
if(IsValidataInput())
selectcount(*)fromDB_BuildInfowherebuildArea='
andbuildNo={1}"
cboBuildArea.Text,Convert.ToInt32(txtBuildNo.Text.Trim()));
intcount=DBHelper.GetSqlResult(sql);
if(count==-1)
MessageBox.Show("
该?
楼£
¤
号?
已°
经-存ä
在¨
²
,ê
另¢
外ª
a选?
MessageBoxButtons.OK,MessageBoxIcon.Information);
sql=String.Format(@"
insertintoDB_BuildInfo(buildArea,buildNo,buildMsg)values('
'
{1}'
{2}'
)"
cboBuildArea.Text,Convert.ToInt32(txtBuildNo.Text.Trim()),cboBuildMsg.Text);
intresult=DBHelper.GetDsqlResult(sql);
if(result==1)
添¬
加¨
®
成¨
功|,ê
失º
ì
败ã
¹
button2.PerformClick();
FormRefresh();
privateboolIsValidataInput()
if(cboBuildArea.Text=="
确¨
定¡
§
客¨
房¤
cboBuildArea.Focus();
returnfalse;
elseif(txtBuildNo.Text.Trim()=="
输º
入¨
txtBuildNo.Focus();
elseif(cboBuildMsg.Text.Trim()=="
属º
性?
cboBuildMsg.Focus();
returntrue;
privatevoidFormRefresh()
stringsqlString=String.Format("
SqlDataReaderdataReader=DBHelper.GetResult(sqlString);
cboBuildArea.SelectedIndex=-1;
privatevoidbutton4_Click(objectsender,EventArgse)
if(listView1.SelectedItems.Count==0)
a更¨
新?
DialogResultresult=MessageBox.Show("
您¨
条¬
?
ê
MessageBoxButtons.OKCancel,MessageBoxIcon.Information);
if(result==DialogResult.OK)
updateDB_BuildInfosetbuildMsg='
wherebuildId={1}"
dCboBulidMsg.Text,Convert.ToInt32(lblBuildId.Text));
intcount=DBHelper.GetDsqlResult(sql);
if(count==1)
更¨
功|!
privatevoidbutton5_Click(objectsender,EventArgse)
a删¦
除y的Ì
用®
户¡
!
return;
DialogResultresult=MessageBox.Show
除y该?
信?
息¡
é
MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
stringsql=String.Format
deletefromDB_BuildInfowherebuildId={0}"
Convert.ToInt32(lblBuildId.Text));
intcount=command.ExecuteNonQuery();
删¦
除y记?
功|!
}
2DBHelper.cs
classDBHelper
privatestaticSqlCommandcmd=null;
privatestaticSqlDataReaderdr=null;
privatestaticstringconnectionString="
Server=.;
DataBase=HotelRoomsManagementSystem;
IntegratedSecurity=True"
publicstaticSqlConnectionconnection=newSqlConnection(connectionString);
publicDBHelper(){}
publicstaticSqlDataReaderGetResult(stringsql)
cmd=newSqlCommand();
cmd.CommandText=sql;
cmd.Connection=connection;
cmd.Connection.Open();
dr=cmd.ExecuteReader();
returndr;
returnnull;
publicstaticintGetSqlResult(stringsql)
inta=(int)cmd.ExecuteScalar();
ret