基于QT的酒店管理系统设计

#include "admcustomer.h" #include "ui_admcustomer.h" #include <QFileDialog> #include <QMessageBox> #include <QSql> #include <QSqlQuery> #include "admdialog1.h" void admcustomer::openTableA() { qryModel->setQuery("SELECT RoomNo,Name,Gender,PhoneNo,Square,RoomType,Number," "Time,ReserveNo,Price,TotalPrice FROM dingdan ORDER BY RoomNo"); if(qryModel->lastError().isValid()) { QMessageBox::information(this,"error","error info:"+qryModel->lastError().text()); return; } qryModel->setHeaderData(0,Qt::Horizontal,"房间号"); qryModel->setHeaderData(1,Qt::Horizontal,"姓名"); qryModel->setHeaderData(2,Qt::Horizontal,"性别"); qryModel->setHeaderData(3,Qt::Horizontal,"手机号"); qryModel->setHeaderData(4,Qt::Horizontal,"房间面积(m²)"); qryModel->setHeaderData(5,Qt::Horizontal,"房间类型"); qryModel->setHeaderData(6,Qt::Horizontal,"订单号"); qryModel->setHeaderData(7,Qt::Horizontal,"预订时间"); qryModel->setHeaderData(8,Qt::Horizontal,"预订天数"); qryModel->setHeaderData(9,Qt::Horizontal,"价格"); qryModel->setHeaderData(10,Qt::Horizontal,"付款总额"); ui->tableView->resizeColumnsToContents(); ui->tableView->horizontalHeader()->setStretchLastSection(true); ui->actOpenDB->setEnabled(false); ui->actRecInsert->setEnabled(true); ui->actRecDelete->setEnabled(true); ui->actRecEdit->setEnabled(true); ui->actScan->setEnabled(true); ui->groupBoxFilter->setEnabled(true); } void admcustomer::getFileNames() { } admcustomer::admcustomer(QWidget *parent) : QMainWindow(parent), ui(new Ui::admcustomer) { ui->setupUi(this); QSqlDatabase db; db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("bishe.db");//数据库名称 db.open(); if(!db.open()) { QMessageBox::information(this,tr("错误"),tr("打开数据库失败!")); return; } qryModel=new QSqlQueryModel; theSelection=new QItemSelectionModel(qryModel); ui->tableView->setModel(qryModel); ui->tableView->setSelectionModel(theSelection); ui->tableView->setAlternatingRowColors(true); DB=QSqlDatabase::addDatabase("QSQLITE"); DB.setDatabaseName("bishe.db"); if(!DB.open()) { QMessageBox::warning(this,"错误","打开数据库失败"); return; } qryModel->setQuery("SELECT RoomNo,Name,Gender,PhoneNo,Square,RoomType,Number," "Time,ReserveNo,Price,TotalPrice,RoomState FROM dingdan ORDER BY RoomNo"); if(qryModel->lastError().isValid()) { QMessageBox::information(this,"error","error info:"+qryModel->lastError().text()); return; } qryModel->setHeaderData(0,Qt::Horizontal,"房间号"); qryModel->setHeaderData(1,Qt::Horizontal,"姓名"); qryModel->setHeaderData(2,Qt::Horizontal,"性别"); qryModel->setHeaderData(3,Qt::Horizontal,"手机号"); qryModel->setHeaderData(4,Qt::Horizontal,"房间面积(m²)"); qryModel->setHeaderData(5,Qt::Horizontal,"房间类型"); qryModel->setHeaderData(6,Qt::Horizontal,"订单号"); qryModel->setHeaderData(7,Qt::Horizontal,"预订时间"); qryModel->setHeaderData(8,Qt::Horizontal,"预订天数"); qryModel->setHeaderData(9,Qt::Horizontal,"价格"); qryModel->setHeaderData(10,Qt::Horizontal,"付款总额"); qryModel->setHeaderData(11,Qt::Horizontal,"预订状态"); ui->tableView->resizeColumnsToContents(); ui->tableView->horizontalHeader()->setStretchLastSection(true); ui->actRecDelete->setEnabled(true); ui->actRecInsert->setEnabled(true); ui->actRecEdit->setEnabled(true); ui->groupBoxFilter->setEnabled(true); connect(ui->tableView,SIGNAL(doubleClicked(QModelIndex)),this,SLOT(on_TableViewDoubleClicked(QModelIndex))); //房间预订情况 db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("bishe.db");//数据库名称 db.open(); if(!db.open()) { QMessageBox::information(this,tr("错误"),tr("打开数据库失败!")); return; } QSqlQuery query; float size=0,totalSize=0; query.exec("select COUNT(RoomState) From dingdan WHERE RoomState='已预订'"); // 获取查询结果中记录的个数 query.next(); size=query.value(0).toInt(); query.exec("select COUNT(RoomNo) From dingdan"); query.next(); totalSize=query.value(0).toInt(); qDebug()<<size; qDebug()<<totalSize; ui->progressBar->setValue(size/totalSize*100); //新加的 } admcustomer::~admcustomer() { delete ui; } void admcustomer::on_actOpenDB_triggered() { QString aFile=QFileDialog::getOpenFileName(this,"选择数据库","","SQLITE数据库(*.db *.db3)"); if(aFile.isEmpty()) return; DB=QSqlDatabase::addDatabase("QSQLITE"); DB.setDatabaseName(aFile); if(!DB.open()) { QMessageBox::warning(this,"错误","打开数据库失败"); return; } openTableA(); } void admcustomer::on_actRecInsert_triggered() { QSqlQuery query; query.exec("select * from dingdan where RoomNo=-1"); QSqlRecord curRec=query.record(); admdialog1 *dataDlg=new admdialog1; Qt::WindowFlags flags=dataDlg->windowFlags(); dataDlg->setWindowFlags(flags|Qt::MSWindowsFixedSizeDialogHint);//固定大小 dataDlg->setInsertRecord(curRec); int ret=dataDlg->exec(); if(ret==QDialog::Accepted) { QSqlRecord recData=dataDlg->getRecordData(); query.prepare("INSERT INTO dingdan (RoomNo,Name,Gender,PhoneNo,Square,RoomType,Number," "Time,ReserveNo,Price,TotalPrice) " "VALUES(:RoomNo,:Name,:Gender,:PhoneNo,:Square,:RoomType,:Number," ":Time,:ReserveNo,:Price,:TotalPrice)"); query.bindValue(":RoomNo",recData.value("RoomNo")); query.bindValue(":Name",recData.value("Name")); query.bindValue(":Gender",recData.value("Gender")); query.bindValue(":PhoneNo",recData.value("PhoneNo")); query.bindValue(":Square",recData.value("Square")); query.bindValue(":RoomType",recData.value("RoomType")); query.bindValue(":Number",recData.value("Number")); query.bindValue(":Time",recData.value("Time")); query.bindValue(":ReserveNo",recData.value("ReserveNo")); query.bindValue(":Price",recData.value("Price")); query.bindValue(":TotalPrice",recData.value("TotalPrice")); if(!query.exec()) { QMessageBox::critical(this,"err","information:"+query.lastError().text()); } else { // qryModel->setQuery("SELECT RoomNo,Name,Gender,PhoneNo,Square,RoomType,Number," // "Time,ReserveNo,Price,,TotalPrice From dingdan order by RoomNo"); QString sqlstr=qryModel->query().executedQuery(); qryModel->setQuery(sqlstr); } } delete dataDlg; } void admcustomer::on_actRecDelete_triggered() { //删除当前记录 int curRecNo=theSelection->currentIndex().row(); QSqlRecord curRec=qryModel->record(curRecNo); //获取当前记录 if (curRec.isEmpty()) //当前为空记录 return; int RoomNo=curRec.value("RoomNo").toInt();//获取房间号 QSqlQuery query; query.prepare("delete from dingdan where RoomNo = :ID"); query.bindValue(":ID",RoomNo); if (!query.exec()) QMessageBox::critical(this, "错误", "删除记录出现错误\n"+query.lastError().text(), QMessageBox::Ok,QMessageBox::NoButton); else //插入，删除记录后需要重新设置SQL语句查询 { QString sqlStr