QT 披萨店点餐系统（完整代码可运行）

#include<QTableView> #include<QMessageBox> #include"myorder.h" #include"menu.h" #include"connection.h" #include "login.h" #include"finalorder.h" myorder::myorder(QWidget *parent,QString no_):QWidget(parent),no1(no_) { ui.setupUi(this); ui.label_deskno->setText(no1); QString str=ui.label_deskno->text(); QSqlQueryModel *model=new QSqlQueryModel(); model->setQuery("SELECT * FROM myorder WHERE DeskNo='"+str+"'"); ui.tableView->setModel(model); connect(ui.pushButton_6,SIGNAL(clicked()),this,SLOT(Button_return_clicked())); connect(ui.pushButton,SIGNAL(clicked()),this,SLOT(search())); QSqlQuery query; query.exec("select distinct Type from myorder"); while(query.next()) { ui.comboBox->addItem(query.value(0).toString()); } connect(ui.pushButton_2,SIGNAL(clicked()),this,SLOT(Button_delete())); connect(ui.pushButton_3,SIGNAL(clicked()),this,SLOT(Button_modify())); connect(ui.pushButton_4,SIGNAL(clicked()),this,SLOT(Button_refresh())); Button_refresh(); connect(ui.pushButton_7,SIGNAL(clicked()),this,SLOT(Button_clear())); connect(ui.pushButton_5,SIGNAL(clicked()),this,SLOT(Button_submit())); setWindowTitle("Myorder"); QPixmap pixmap(QString::fromUtf8("./1_1.jpg")); QPalette palette = this->palette(); palette.setBrush(backgroundRole(),QBrush(pixmap)); setPalette(palette); } void myorder::search() { QString s_type; s_type=ui.comboBox->currentText(); model=new QSqlQueryModel(); if(s_type=="Type all") { model->setQuery("select * from myorder"); } else { model->setQuery("select * from myorder where Type='"+s_type+"'"); } ui.tableView->setModel(model); } void myorder::Button_delete() { QString s_id,flag; s_id=ui.lineEdit_2->text(); QSqlQuery query; query.exec("select * from myorder where ID='"+s_id+"'"); while(query.next()) { flag=query.value(1).toString(); } if(flag==0) { QMessageBox::information(this,"notice","No such Dishes!"); } else { bool value; value=query.exec("delete from myorder where ID='"+s_id+"'"); if(value) { QMessageBox::information(this,"notice","Delete Succeed!"); } model=new QSqlQueryModel(); model->setQuery("select * from myorder"); ui.tableView->setModel(model); } } void myorder::Button_modify() { QString s_id,s_num,flag; QSqlQuery query; bool ok; s_id=ui.lineEdit->text(); s_num=ui.lineEdit_3->text(); int n = s_num.toInt(&ok); if(n==0) { QMessageBox::information(this,"notice","Not allowed!"); } else { query.exec("select * from myorder where ID='"+s_id+"'"); while(query.next()) { flag=query.value(1).toString(); } if(flag==0) { QMessageBox::information(this,"notice","No such Dishes!"); } else { bool value; value=query.exec("UPDATE myorder SET Num='"+s_num+"' WHERE ID='"+s_id+"'"); if(value) { QMessageBox::information(this,"notice","Modify Succeed!"); } } model=new QSqlQueryModel(); model->setQuery("select * from myorder"); ui.tableView->setModel(model); } } void myorder::Button_refresh() { double sum=0; QSqlQuery query; query.exec("select Price,Num from myorder"); while(query.next()) { sum = sum + query.value(0).toDouble() * query.value(1).toInt(); } QString total=QString("%1").arg(sum); ui.label_total->setText(total); } void myorder::Button_clear() { QSqlQuery query; QString s_no=ui.label_deskno->text(); QMessageBox msgBox; msgBox.setText("This could clear all you have ordered!"); msgBox.setInformativeText("Do you want to order again?"); msgBox.setStandardButtons(QMessageBox::Yes | QMessageBox::No); msgBox.setDefaultButton(QMessageBox::No); int ret = msgBox.exec(); switch(ret) { case QMessageBox::Yes: { query.exec("delete from myorder where DeskNo='"+s_no+"'"); Button_return_clicked(); } break; case QMessageBox::No: break; default: break; } } void myorder::Button_submit() { QMessageBox msgBox; msgBox.setText("This could lead to your final ordered!"); msgBox.setInformativeText("Do you want to submit?"); msgBox.setStandardButtons(QMessageBox::Yes | QMessageBox::No); msgBox.setDefaultButton(QMessageBox::No); int ret = msgBox.exec(); switch(ret) { case QMessageBox::Yes: { login *w = new login(); w->show(); this->close(); } break; case QMessageBox::No: break; default: break; } } void myorder::Button_return_clicked() { QString no = ui.label_deskno->text(); menu *w = new menu(NULL,no); w->show(); this->close(); } myorder::~myorder() { }