c# 酒店客房管理系统.docx
《c# 酒店客房管理系统.docx》由会员分享,可在线阅读,更多相关《c# 酒店客房管理系统.docx(80页珍藏版)》请在冰豆网上搜索。
c#酒店客房管理系统
一共13个窗口,dbhelper.Cs是数据库操作类。
有不明白的地方可以加我qq:
1002230228
1BuildInfo.cs1
2DBHelper.cs9
3DormInfo.cs11
4DormRegister.cs20
5FoulsFeedback.cs25
6FoulsRecord.cs28
7login.cs32
8MRegister.cs35
9MUpdate.cs38
10RepairFeedback.cs44
11RepairRecord.cs47
12StuInfoRegister.cs52
13StuInfoSearch.cs54
14WFMain.cs58
1BuildInfo.cs
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Data.SqlClient;
usingSystem.Linq;
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());
lviManageInfo.SubItems.Add(dataReader["buildNo"].ToString());
lviManageInfo.SubItems.Add(dataReader["buildMsg"].ToString());
listView1.Items.Add(lviManageInfo);
}
dataReader.Close();
DBHelper.connection.Close();
dCboBuildArea.Items.Clear();
sql="selectdistinctbuildAreafromDB_BuildInfo";
dataReader=DBHelper.GetResult(sql);
while(dataReader.Read())
{
dCboBuildArea.Items.Add(dataReader[0].ToString());
}
}
finally
{
DBHelper.connection.Close();
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);
}
else
{
stringsql=String.Format("select*fromDB_BuildInfowherebuildArea='{0}'",dCboBuildArea.Text);
try
{
SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);
DBHelper.connection.Open();
SqlDataReaderdataReader=command.ExecuteReader();
if(!
dataReader.Read())
{
MessageBox.Show
("查¨¦无T此ä?
区?
域®¨°记?
录?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
}
else
{
dataReader.Close();
sql=String.Format("select*fromDB_BuildInfowherebuildArea='{0}'",dCboBuildArea.Text);
command.CommandText=sql;
dataReader=command.ExecuteReader();
listView1.Items.Clear();
while(dataReader.Read())
{
ListViewItemlviManageInfo=newListViewItem();
lviManageInfo.SubItems.Clear();
lviManageInfo.SubItems[0].Text=dataReader["buildId"].ToString();
lviManageInfo.SubItems.Add(dataReader["buildArea"].ToString());
lviManageInfo.SubItems.Add(dataReader["buildNo"].ToString());
lviManageInfo.SubItems.Add(dataReader["buildMsg"].ToString());
listView1.Items.Add(lviManageInfo);
}
}
dataReader.Close();
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
}
}
}
privatevoidbutton2_Click(objectsender,EventArgse)
{
listView1.Items.Clear();
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())
{
stringsql=String.Format("selectcount(*)fromDB_BuildInfowherebuildArea='{0}'andbuildNo={1}",
cboBuildArea.Text,Convert.ToInt32(txtBuildNo.Text.Trim()));
try
{
intcount=DBHelper.GetSqlResult(sql);
if(count==-1)
{
MessageBox.Show("该?
楼£¤号?
已°?
经-存ä?
在¨²,ê?
请?
另¢¨ª外ªa选?
择?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
sql=String.Format(@"insertintoDB_BuildInfo(buildArea,buildNo,buildMsg)values('{0}','{1}','{2}')",
cboBuildArea.Text,Convert.ToInt32(txtBuildNo.Text.Trim()),cboBuildMsg.Text);
intresult=DBHelper.GetDsqlResult(sql);
if(result==1)
{
MessageBox.Show("添¬¨ª加¨®记?
录?
成¨¦功|,ê?
请?
另¢¨ª外ªa选?
择?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添¬¨ª加¨®记?
录?
失º¡ì败㨹,ê?
请?
另¢¨ª外ªa选?
择?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
if(dCboBuildArea.Text=="")
{
listView1.Items.Clear();
button2.PerformClick();
}
else
{
FormRefresh();
}
}
}
}
privateboolIsValidataInput()
{
if(cboBuildArea.Text=="")
{
MessageBox.Show("请?
确¨¡¤定¡§客¨ª房¤?
地Ì?
理¤¨ª区?
域®¨°!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
cboBuildArea.Focus();
returnfalse;
}
elseif(txtBuildNo.Text.Trim()=="")
{
MessageBox.Show("请?
输º?
入¨?
客¨ª房¤?
楼£¤号?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
txtBuildNo.Focus();
returnfalse;
}
elseif(cboBuildMsg.Text.Trim()=="")
{
MessageBox.Show("请?
输º?
入¨?
客¨ª房¤?
属º?
性?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
cboBuildMsg.Focus();
returnfalse;
}
returntrue;
}
privatevoidFormRefresh()
{
listView1.Items.Clear();
stringsqlString=String.Format("select*fromDB_BuildInfowherebuildArea='{0}'",dCboBuildArea.Text);
try
{
SqlDataReaderdataReader=DBHelper.GetResult(sqlString);
while(dataReader.Read())
{
ListViewItemlviManageInfo=newListViewItem();
lviManageInfo.SubItems.Clear();
lviManageInfo.SubItems[0].Text=dataReader["buildId"].ToString();
lviManageInfo.SubItems.Add(dataReader["buildArea"].ToString());
lviManageInfo.SubItems.Add(dataReader["buildNo"].ToString());
lviManageInfo.SubItems.Add(dataReader["buildMsg"].ToString());
listView1.Items.Add(lviManageInfo);
}
dataReader.Close();
}
finally
{
DBHelper.connection.Close();
cboBuildArea.SelectedIndex=-1;
txtBuildNo.Clear();
cboBuildMsg.SelectedIndex=-1;
lblBuildArea.Text="";
lblBuildId.Text="";
lblBuildNo.Text="";
dCboBulidMsg.SelectedIndex=-1;
}
}
privatevoidbutton4_Click(objectsender,EventArgse)
{
if(listView1.SelectedItems.Count==0)
{
MessageBox.Show("请?
选?
择?
要°a更¨¹新?
的Ì?
记?
录?
!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
DialogResultresult=MessageBox.Show("您¨²确¨¡¤定¡§要°a更¨¹新?
该?
条¬?
记?
录?
?
ê?
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OKCancel,MessageBoxIcon.Information);
if(result==DialogResult.OK)
{
stringsql=String.Format("updateDB_BuildInfosetbuildMsg='{0}'wherebuildId={1}",
dCboBulidMsg.Text,Convert.ToInt32(lblBuildId.Text));
try
{
intcount=DBHelper.GetDsqlResult(sql);
if(count==1)
{
MessageBox.Show("更¨¹新?
记?
录?
成¨¦功|!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
MessageBox.Show("更¨¹新?
记?
录?
失º¡ì败㨹!
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
if(dCboBuildArea.Text=="")
{
listView1.Items.Clear();
BuildInfo_Load(sender,e);
}
else
{
FormRefresh();
}
}
}
}
privatevoidbutton5_Click(objectsender,EventArgse)
{
if(listView1.SelectedItems.Count==0)
{
MessageBox.Show("请?
选?
择?
要°a删¦?
除y的Ì?
用®?
户¡ì记?
录?
!
ê?
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
return;
}
DialogResultresult=MessageBox.Show
("您¨²确¨¡¤定¡§要°a删¦?
除y该?
用®?
户¡ì信?
息¡é?
ê?
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if(result==DialogResult.OK)
{
stringsql=String.Format
("deletefromDB_BuildInfowherebuildId={0}",
Convert.ToInt32(lblBuildId.Text));
try
{
SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);
DBHelper.connection.Open();
intcount=command.ExecuteNonQuery();
if(count==1)
{
MessageBox.Show
("删¦?
除y记?
录?
成¨¦功|!
ê?
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show
("删¦?
除y记?
录?
失º¡ì败㨹!
ê?
","操¨´作Á¡Â提¬¨¢示º?
",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
}
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
}
finally
{
DBHelper.connection.Close();
if(dCboBuildArea.Text=="")
{
listView1.Items.Clear();
BuildInfo_Load(sender,e);
}
else
{
FormRefresh();
}
}
}
}
}
}
2DBHelper.cs
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Data.SqlClient;
usingSystem.Text;
usingSystem.Windows.Forms;
namespacejdkfglxt
{
classDBHelper
{
privatestaticSqlCommandcmd=null;
privatestaticSqlDataReaderdr=null;
privatestaticstringconnectionString="Server=.;DataBase=HotelRoomsManagementSystem;IntegratedSecurity=True";
publicstaticSqlConnectionconnection=newSqlConnection(connectionString);
publicDBHelper(){}
publicstaticSqlDataReaderGetResult(stringsql)
{
try
{
cmd=newSqlCommand();
cmd.CommandText=sql;
cmd.Connection=connection;
cmd.Connection.Open();
dr=cmd.ExecuteReader();
returndr;
}
catch(Exceptionex)
{
MessageBox.Show(ex.Message);
returnnull;
}
}
publicstaticintGetSqlResult(stringsql)
{
try
{
cmd=newSqlCommand();
cmd.CommandText=sql;
cmd.Connection=connection;
cmd.Connection.Open();
inta=(int)cmd.ExecuteScalar();
ret