基于Qt的酒店管理系统（毕业设计）

开发工具集：
Qt5.12.4、VS2017、Sqlite3轻量级数据库（免除安装数据库的烦恼）

百度网盘链接：
链接：https://pan.baidu.com/s/1rNt6EI8uAAIuHCQeGXKinA 
提取码：0mcn

效果图

1、加载数据库部分

void DatabaseInfo::loadDatabaseInfo()
{
	// 加载房间类型表
	loadTRoomType();
	// 加载房间状态列表
	loadTRoomState();
	// 加载房号列表
	loadRoomNumber();
}

void DatabaseInfo::loadTRoomType()
{
	m_mapRoomType.clear();

	QSqlQuery query;
	QString strSql = "";
	strSql = QString("SELECT * FROM T_ROOMTYPE");
	query.exec(strSql);
	while (query.next())
	{
		TRoomType data;
		data.roomId = query.value("roomId").toInt();
		data.roomType = query.value("roomType").toString();
		data.roomIntroduce = query.value("roomIntroduce").toString();
		data.roomPrice = query.value("roomPrice").toInt();
		data.roomPixmap = query.value("roomPixmap").toByteArray();

		m_mapRoomType[data.roomId] = data;
	}
}

void DatabaseInfo::loadTRoomState()
{
	m_mapRoomState.clear();

	QSqlQuery query;
	QString strSql = "";
	strSql = QString("SELECT * FROM T_ROOMSTATE");
	query.exec(strSql);
	while (query.next())
	{
		m_mapRoomState[query.value("id").toInt()] = query.value("roomState").toString();
	}
}

void DatabaseInfo::loadRoomNumber()
{
	m_vecRoomNumber.clear();

	QSqlQuery query;
	QString strSql = "";
	strSql = QString("SELECT roomNumber FROM T_ROOMINFO GROUP BY roomNumber");
	query.exec(strSql);
	while (query.next())
	{
		m_vecRoomNumber.push_back(query.value("roomNumber").toInt());
	}
}

2、登记入住部分

void FormCheckIn::on_btnSubmitOrder_clicked()
{
	QString userName = ui.lEditName->text().trimmed();
	QString userSex = ui.rdoBtnMale->isChecked() ? "男" : "女";
	QString userIdNumber = ui.lEditIdNumber->text().trimmed();
	QString userPhone = ui.lEditPhone->text().trimmed();
	if (userName.isEmpty() || userIdNumber.isEmpty() || userPhone.isEmpty())
	{
		ui.lblError->setProperty("checkIn", false);
		ui.lblError->setText("登记信息内容不能为空！");
		return;
	}

	QString checkInTime = ui.lblCheckInTime->text();
	QString checkOutTime = ui.lblCheckOutTime->text();
	int checkInDays = (QDate::fromString(checkInTime, "yyyy-MM-dd")).daysTo(QDate::fromString(checkOutTime, "yyyy-MM-dd"));
	int userState = (m_type == RESERVER) ? 1 : 2;
	QString userPayment = ui.lblMoney->text();
	userPayment = QString::number((userPayment.left(userPayment.length() - 1)).toInt() / checkInDays);
	int userRoomNumber = getRoomNumber(m_roomId);

	QSqlQuery query;
	SqlManage::getDataBase().transaction(); // 数据库开启事务
	for (int i = 0; i < checkInDays; i++)
	{// 插入T_USERINFO表
		QString tempCheckInTime = (QDate::fromString(checkInTime, "yyyy-MM-dd")).addDays(i).toString("yyyy-MM-dd");
		QString tempCheckOutTime = (QDate::fromString(checkInTime, "yyyy-MM-dd")).addDays(i + 1).toString("yyyy-MM-dd");
		QString strSql = QString("INSERT INTO T_USERINFO(userName, userSex, userIdNumber, userPhone, userRoomNumber, userCheckInTime, userCheckInDays,"
			"userCheckOutTime, userState, userPayment) values ('%1', '%2', '%3', '%4', %5, '%6', %7, '%8', %9, %10);")
			.arg(userName).arg(userSex).arg(userIdNumber).arg(userPhone).arg(userRoomNumber).arg(tempCheckInTime)
			.arg(1).arg(tempCheckOutTime).arg(userState).arg(userPayment.toInt());
		qDebug() << strSql;
		if (!query.exec(strSql))
		{
			SqlManage::getDataBase().rollback();	// 数据库回滚操作，撤销所有插入语句
			ui.lblError->setProperty("checkIn", false);
			ui.lblError->setText("订单提交失败！");
			return;
		}
		strSql = QString("UPDATE T_ROOMINFO SET roomState = %1 WHERE roomNumber = %2 AND roomDate = '%3'")
			.arg((m_type == RESERVER) ? Hotel::ROOM_STATE_PRE_PLEDGE : Hotel::ROOM_STATE_LIVING).arg(userRoomNumber).arg(tempCheckInTime);
		qDebug() << strSql;
		if (!query.exec(strSql))
		{
			SqlManage::getDataBase().rollback();	// 数据库回滚操作，撤销所有插入语句
			ui.lblError->setProperty("checkIn", false);
			ui.lblError->setText("订单提交失败！");
			return;
		}
	}
	
	SqlManage::getDataBase().commit();	// 数据库提交事务，真正执行所有插入语句
	ui.lblError->setProperty("checkIn", true);
	ui.lblError->setText("订单提交成功！");
	setBtnEnabled(false);
	// 更新客房界面信息
	UpdateFormInfo::addFormInfo(Hotel::UPDATE_CHECK_IN);
}

3、房间图片部分

void FormUpdateRoomPixmap::updatePixmap()
{
	int i = 0;

	QSqlQuery query;
	QString strSql = "SELECT roomPixmap FROM T_ROOMTYPE";
	query.exec(strSql);
	while (query.next())
	{
		QByteArray byteArray = query.value("roomPixmap").toByteArray();
		QPixmap pixmap;
		pixmap.loadFromData(byteArray);
		QSize size = m_listLables[i]->size();
		m_listLables[i++]->setPixmap(pixmap.scaled(size));
	}
}