pvbgfm6cj
/
hotel
1
0
Fork 1
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
hotel/administration.cpp

516 lines
18 KiB
Raw Permalink Blame History

#include "administration.h"
#include "ui_administration.h"
#include "registers.h"
#include "add_administration.h"
administration::administration(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::administration){
init();
}
void administration::paintEvent(QPaintEvent*)
{
labels->resize(ui->widget->size());
}
void administration::init()
{
ui->setupUi(this);
this->setFixedSize(1920,1080);
this->setWindowTitle("用户界面");
this->setWindowIcon(QIcon(":image/icon/logo"));
labels = new QLabel(this);
labels->setScaledContents(true);
labels->setFixedSize(1920,1080);
labels->setPixmap(QPixmap(":/image/bg/login.png"));
labels->lower();
ui->HotelTable->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
ui->AcounTable->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
ui->AcounTable->horizontalHeader()->setStyleSheet("QHeaderView::section{background-color: rgb(0, 0, 0,30);}");//表头透明度
ui->AcounTable->verticalHeader()->setStyleSheet("QHeaderView::section{background-color: rgb(0, 0, 0,30);}");//行头透明度
ui->HotelTable->horizontalHeader()->setStyleSheet("QHeaderView::section{background-color: rgb(0, 0, 0,30);}");//表头透明度
ui->HotelTable->verticalHeader()->setStyleSheet("QHeaderView::section{background-color: rgb(0, 0, 0,30);}");//行头透明度
ui->Add->setEnabled(false);//初始退订按钮灰色
ui->Del->setEnabled(false);//初始退订按钮灰色
ui->Modify->setEnabled(false);//初始退订按钮灰色
ui->Search->setEnabled(false);//初始退订按钮灰色
ui->AcounTable->hide();
ui->HotelTable->hide();
on_Hman_clicked();
}
void administration::init_account(){
findall2();
flush_data2(userinfo);
value_customer = ui->AcounTable->model()->rowCount();
findall3();
flush_data3(userinfo);
ui->AcounTable->setHorizontalHeaderLabels({"客户账号","密码","姓名","性别","身份证"});
}
void administration::init_hotel(){
findall();
flush_data(userinfo);
ui->HotelTable->setHorizontalHeaderLabels({"房间号","房间类型","是否带窗","负责人","状态"});
}
administration::~administration()
{
delete ui;
}
//切换到Hotel table,同时关闭Acount table
void administration::on_Hman_clicked()
{
ui->Add->setEnabled(true);//初始退订按钮灰色
ui->Del->setEnabled(true);//初始退订按钮灰色
ui->Modify->setEnabled(true);//初始退订按钮灰色
ui->Search->setEnabled(true);//初始退订按钮灰色
init_hotel();
ui->HotelTable->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
ui->HotelTable->setSelectionBehavior(QAbstractItemView::SelectRows); //整行选中的方式
ui->HotelTable->setSelectionMode(QAbstractItemView::SingleSelection); //设置可以选中单个
ui->HotelTable->show();
ui->AcounTable->hide();
tool = 1;
}
//切换到Acount table,同时关闭Hotel table
void administration::on_Aman_clicked()
{
ui->Add->setEnabled(true);//初始退订按钮灰色
ui->Del->setEnabled(true);//初始退订按钮灰色
ui->Modify->setEnabled(true);//初始退订按钮灰色
ui->Search->setEnabled(true);//初始退订按钮灰色
init_account();
ui->AcounTable->setSelectionBehavior(QAbstractItemView::SelectRows); //整行选中的方式
ui->AcounTable->setSelectionMode(QAbstractItemView::SingleSelection); //设置可以选中单个
ui->HotelTable->hide();
ui->AcounTable->show();
tool = 0;
}
//增加行 完成
void administration::on_Add_clicked()
{
if(tool == 0){
registers *reg = new registers;
reg->settype(2);
reg->show();
/*int cols=ui->AcounTable->columnCount();
int rows=ui->AcounTable->rowCount();
qDebug()<<rows;
ui->AcounTable->insertRow(rows);
for(int i=0;i<cols;i++)
{
ui->AcounTable->setItem(rows,i,new QTableWidgetItem(""));
}
ui->AcounTable->selectRow(rows);
QSqlQuery query((db));
query.prepare("INSERT into customer VALUES(:n,1,1,1,1,NULL);");
query.bindValue(":n",QRandomGenerator::global()->bounded(10000));//随机数 一万以内正整数
query.exec();
QMessageBox::information(this,tr("提示"),("添加成功"));
init_account();*/
}
else if(tool == 1){
int cols=ui->HotelTable->columnCount();
int rows=ui->HotelTable->rowCount();
ui->HotelTable->insertRow(rows);
for(int i=0;i<cols;i++)
{
ui->HotelTable->setItem(rows,i,new QTableWidgetItem(""));
}
ui->HotelTable->selectRow(rows);
add_administration *ad = new add_administration;
ad->show();
}
else QMessageBox::about(this,"警告","出错");
}
//删除操作 完成
void administration::on_Del_clicked()
{
if(tool == 0){
//if(row <= value_customer-userinfo.size()+1){
QSqlQuery query((db));
QTableWidgetItem *item = ui->AcounTable->currentItem();
QString n = 0;
n = ui->AcounTable->model()->index(item->row(),0).data().toString();
//int num = n.toInt();
query.prepare("DELETE from customer where account = :num ");
query.bindValue(":num",n);
query.exec();
query.prepare("DELETE from employee where account = :num ");
query.bindValue(":num",n);
query.exec();
if(item==Q_NULLPTR)return;
ui->AcounTable->removeRow(item->row());
QMessageBox::information(this,tr("提示"),("删除成功"));
init_account();
// }
/* else if(row > value_customer-userinfo.size()){
QSqlQuery query((db));
QTableWidgetItem *item = ui->AcounTable->currentItem();
QString n = 0;
n = ui->AcounTable->model()->index(item->row(),0).data().toString();//n是房间号
int num = n.toInt();
if(item==Q_NULLPTR)return;
ui->AcounTable->removeRow(item->row());
QMessageBox::information(this,tr("提示"),("删除成功"));
init_account();
}*/
}
else if(tool == 1){
QSqlQuery query((db));
QTableWidgetItem *item = ui->HotelTable->currentItem();
QString n = 0;
n = ui->HotelTable->model()->index(item->row(),0).data().toString();//n是房间号
int num = n.toInt();
query.prepare("DELETE from room where room_num = :num ");
query.bindValue(":num",num);
query.exec();
if(item==Q_NULLPTR)return;
ui->HotelTable->removeRow(item->row());
QMessageBox::information(this,tr("提示"),("删除成功"));
}
else QMessageBox::about(this,"警告","出错");
}
//修改操作
void administration::on_Modify_clicked()
{
int c = row;
if(tool == 0){
//if(row <= value_customer-userinfo.size()){
QSqlQuery query((db));
QString n1 = 0;
n1 = ui->AcounTable->model()->index(c,0).data().toString();//n是房间号
num = n1.toInt();
QString n2 = "0";
n2 = ui->AcounTable->model()->index(c,1).data().toString();
query.prepare("UPDATE customer set password=:QS where account = :num");
query.bindValue(":QS",n2);
query.bindValue(":num",n1);
query.exec();
QString n3 = 0;
n3 = ui->AcounTable->model()->index(c,2).data().toString();
query.prepare("UPDATE customer set name=:QS where account = :num");
query.bindValue(":QS",n3);
query.bindValue(":num",n1);
query.exec();
QString n4 = 0;
n4 = ui->AcounTable->model()->index(c,3).data().toString();
query.prepare("UPDATE customer set gender=:QS where account = :num");
query.bindValue(":QS",n4);
query.bindValue(":num",n1);
query.exec();
QString n5 = 0;
n5 = ui->AcounTable->model()->index(c,4).data().toString();
query.prepare("UPDATE customer set id=:QS where account = :num");
query.bindValue(":QS",n5);
query.bindValue(":num",n1);
query.exec();
query.prepare("UPDATE employee set password=:QS where account = :num");
query.bindValue(":QS",n2);
query.bindValue(":num",n1);
query.exec();
init_account();
// }
/* else if(row > value_customer-userinfo.size()){
QSqlQuery query((db));
QString n1 = 0;
n1 = ui->AcounTable->model()->index(row,0).data().toString();//n是房间号
num = n1.toInt();
QString n2 = "0";
n2 = ui->AcounTable->model()->index(row,1).data().toString();
init_account();*/
//}
}
else if(tool == 1){
QSqlQuery query((db));
QString n1 = 0;
n1 = ui->HotelTable->model()->index(c,0).data().toString();//n是房间号
num = n1.toInt();
QString n2 = "0";
n2 = ui->HotelTable->model()->index(c,1).data().toString();
query.prepare("UPDATE room set type=:QS where room_num = :num");
query.bindValue(":QS",n2);
query.bindValue(":num",num);
query.exec();
QString n3 = 0;
n3 = ui->HotelTable->model()->index(c,2).data().toString();
query.prepare("UPDATE room set withwindow=:QS where room_num = :num");
query.bindValue(":QS",n3);
query.bindValue(":num",num);
query.exec();
QString n4 = 0;
n4 = ui->HotelTable->model()->index(c,3).data().toString();
query.prepare("UPDATE room set responsible_person=:QS where room_num = :num");
query.bindValue(":QS",n4);
query.bindValue(":num",num);
query.exec();
QString n5 = 0;
n5 = ui->HotelTable->model()->index(c,4).data().toString();
query.prepare("UPDATE room set status=:QS where room_num = :num");
query.bindValue(":QS",n5);
query.bindValue(":num",num);
query.exec();
init_hotel();
}
QMessageBox::information(this,tr("提示"),("修改成功"));
}
//插入账号数据
void administration::flush_data2(QVector<QVector<QString>>&userinfo)//插入数据 完成
{
ui->AcounTable->clear();
if(!userinfo.size())return;
ui->AcounTable->setRowCount(userinfo.size());//行
ui->AcounTable->setColumnCount(5);//列
for(int i=0;i<userinfo.size();i++)
{
for(int j=0;j<userinfo[0].size();j++)
{
QTableWidgetItem *QW = new QTableWidgetItem(userinfo[i][j]);
ui->AcounTable->setItem(i,j,QW);//行 列 内容
QW->setTextAlignment(Qt::AlignCenter);//设置中心对齐
}
}
}
//插入客房数据
void administration::flush_data(QVector<QVector<QString>>&userinfo)//插入数据 完成
{
ui->HotelTable->clear();
if(!userinfo.size())return;
ui->HotelTable->setRowCount(userinfo.size());//行
ui->HotelTable->setColumnCount(5);//列
for(int i=0;i<userinfo.size();i++)
{
for(int j=0;j<userinfo[0].size();j++)
{
QTableWidgetItem *QW = new QTableWidgetItem(userinfo[i][j]);
ui->HotelTable->setItem(i,j,QW);//行 列 内容
QW->setTextAlignment(Qt::AlignCenter);//设置中心对齐
}
}
}
void administration::flush_data3(QVector<QVector<QString>>&userinfo)//插入数据 完成
{
//ui->AcounTable->clear();
if(!userinfo.size())return;
ui->AcounTable->setRowCount(userinfo.size()+ui->AcounTable->model()->rowCount());//行
//ui->AcounTable->setColumnCount(5);//列
for(int i=0;i<userinfo.size();i++)
{
for(int j=0;j<userinfo[0].size();j++)
{
QTableWidgetItem *QW = new QTableWidgetItem(userinfo[i][j]);
QTableWidgetItem *QW2 = new QTableWidgetItem("/");
QTableWidgetItem *QW3 = new QTableWidgetItem("/");
QTableWidgetItem *QW4 = new QTableWidgetItem("/");
ui->AcounTable->setItem(i+ui->AcounTable->model()->rowCount()-userinfo.size(),j,QW);//行 列 内容
ui->AcounTable->setItem(i+ui->AcounTable->model()->rowCount()-userinfo.size(),2,QW2);
ui->AcounTable->setItem(i+ui->AcounTable->model()->rowCount()-userinfo.size(),3,QW3);
ui->AcounTable->setItem(i+ui->AcounTable->model()->rowCount()-userinfo.size(),4,QW4);
QW->setTextAlignment(Qt::AlignCenter);//设置中心对齐
QW2->setTextAlignment(Qt::AlignCenter);
QW3->setTextAlignment(Qt::AlignCenter);
QW4->setTextAlignment(Qt::AlignCenter);
}
}
}
//搜索
void administration::findall()//显示全部 完成
{
userinfo.clear();//清楚存储向量rec的向量的数据
QSqlQuery query((db));
query.prepare("select * from room");
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
for(int i=0;i<query.record().count();i++)
{
rec.push_back(query.record().value(i).toString());//将sql搜索到的一行记录塞入rec向量
}
userinfo.push_back(rec);//将rec向量塞入向量
}
}
}
void administration::findall2()//显示全部 完成
{
userinfo.clear();//清楚存储向量rec的向量的数据
QSqlQuery query((db));
query.prepare("select * from customer");
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
for(int i=0;i<query.record().count();i++)
{
rec.push_back(query.record().value(i).toString());//将sql搜索到的一行记录塞入rec向量
}
userinfo.push_back(rec);//将rec向量塞入向量
}
}
}
void administration::findall3()//显示全部 完成
{
userinfo.clear();//清楚存储向量rec的向量的数据
QSqlQuery query((db));
query.prepare("select * from employee");
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
for(int i=0;i<query.record().count();i++)
{
rec.push_back(query.record().value(i).toString());//将sql搜索到的一行记录塞入rec向量
}
userinfo.push_back(rec);//将rec向量塞入向量
}
}
}
void administration::on_Search_clicked()
{
QString number=ui->lineEdit->text();
if(number == NULL && tool == 0){
init_account();
}
else if(number == NULL && tool == 1){
init_hotel();
}
else if(find_byname2(number) && tool == 0)
{
flush_data2(userinfo);
userinfo.clear();
if(ui->AcounTable->model()->index(0,0).data().toString() != NULL)condition_search = 1;
if(condition_search == 0 && find_byname3(number) && tool == 0){
flush_data2(userinfo);
userinfo.clear();
}
condition_search = 0;
ui->AcounTable->setHorizontalHeaderLabels({"客户账号","密码","姓名","性别","身份证"});
}
else if(find_byname(number) && tool == 1){
flush_data(userinfo);
userinfo.clear();
ui->HotelTable->setHorizontalHeaderLabels({"房间号","房间类型","是否带窗","负责人","状态"});
}
else QMessageBox::critical(nullptr, "错误", "未知的错误", QMessageBox::Retry);
}
bool administration::find_byname(QString n)//搜索 完成
{
int number = n.toInt();
userinfo.clear();
QSqlQuery query(db);
query.prepare("select * from room where room_num like :number;");//以开头搜索 不行
query.bindValue(":number",number);
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
rec.push_back(query.record().value("room_num").toString());
rec.push_back(query.record().value("type").toString());
rec.push_back(query.record().value("withwindow").toString());
rec.push_back(query.record().value("responsible_person").toString());
rec.push_back(query.record().value("status").toString());
rec.push_back(query.record().value("checkout_time").toString());
rec.push_back(query.record().value("customer_id").toString());
userinfo.push_back(rec);
}
return true;
}
return false;
}
bool administration::find_byname2(QString n)//搜索
{
userinfo.clear();
QSqlQuery query(db);
query.prepare("select * from customer where account like :number;");//以开头搜索 不行
query.bindValue(":number",n);
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
rec.push_back(query.record().value("account").toString());
rec.push_back(query.record().value("password").toString());
rec.push_back(query.record().value("name").toString());
rec.push_back(query.record().value("gender").toString());
rec.push_back(query.record().value("id").toString());
userinfo.push_back(rec);
}
return true;
}
return false;
}
bool administration::find_byname3(QString n)//搜索
{
userinfo.clear();
QSqlQuery query(db);
query.prepare("select * from employee where account like :number;");//以开头搜索 不行
query.bindValue(":number",n);
if(query.exec())
{
while (query.next()) {
QVector<QString>rec;
rec.push_back(query.record().value("account").toString());
rec.push_back(query.record().value("password").toString());
userinfo.push_back(rec);
}
return true;
}
return false;
}
void administration::on_AcounTable_itemClicked(QTableWidgetItem *item)
{
row = item->row();
qDebug() << "当前选中行： " << row;
}
void administration::on_HotelTable_itemClicked(QTableWidgetItem *item)
{
row = item->row();
qDebug() << "当前选中行： " << row;
}
Reference in new issue View Git Blame Copy Permalink