技术:C#+WinForm
运行环境:Visual Studio 2015
概述
酒店管理(Hotel Management ),是全球十大热门行业之一,酒店管理系统包括客房管理、员工管理、营业管理、客户管理、酒店商品管理等功能模块。
详细
一、运行效果
二、实现过程
①、房间管理
新增房间
string sql = string.Format(@"insert into RoomTable(RoomID, Floor, TypeID, StateID) values('{0}','{1}','{2}','{3}')", tbFangHao.Text, tbLouCeng.Text, cbLeiXing.SelectedValue.ToString(), cbZhuangTai.SelectedValue.ToString()); if (db.ExecuteSQLCommand(sql) > 0) { string aac = string.Format("{0}房间新增成功!", tbFangHao.Text); MessageBox.Show(aac); }
激活房卡
string sql = string.Format(@"insert into RoomIDCard(RoomID, RoomCard) values('{0}','{1}')", FangHao, tbFangKa.Text); int a = db.ExecuteSQLCommand(sql); if (a > 0) { string aaac = string.Format("激活成功!房号为:{0},房卡为:{1}", FangHao, tbFangKa.Text); MessageBox.Show(aaac); } else { string aaac = string.Format("{0}房卡激活失败!", FangHao); MessageBox.Show(aaac); }
②、房客管理
新增房客
string gender = "男"; if (rbNv.Checked) { gender = "女"; } //向顾客表中插入数据 string sql = string.Format(@"insert into CustomerTable( Name, CarID, Phone, Balance, Type, Sex, Age) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", tbXingMing.Text, tbShenFenZheng.Text, tbDianHua.Text, tbJinE.Text, cbLeiXing.SelectedValue, gender, tbNianLing.Text); if (db.ExecuteSQLCommand(sql) > 0) { string sj = DateTime.Now.ToString(); //新增到充值记录表 try { sql = string.Format(@" insert into CustomerRecharge(RechargeTime, RechargeAmount, RechargeIDCardNumber, Gifts) values('{0}','{1}','{2}','{3}')", sj, tbJinE.Text, tbShenFenZheng.Text, "新开会员"); if (db.ExecuteSQLCommand(sql) == 0) { MessageBox.Show("新增到充值记录表中失败!"); } } catch (Exception er) { MessageBox.Show(er.Message); } finally { db.CloseConnection(); } string aacc = string.Format("{0}恭喜您成为{1}", tbXingMing.Text, cbLeiXing.Text); MessageBox.Show(aacc); this.Close(); } else { MessageBox.Show("添加失败!"); }
新增房客折扣类型
string sql = s