if(ui->dateEdit->date()>ui->dateEdit_2->date()) { QMessage<a href="https://www.jb51.cc/tag/Box/" target="_blank" class="keywords">Box</a>::about(this,tr("日期范围<a href="https://www.jb51.cc/tag/cuowu/" target="_blank" class="keywords">错误</a>"),tr("开单的起始时间不能大于开单的截止时间,请点击'确定'返回重新设置日期间隔！")); return; } QString datetime1,datetime2; datetime1=QString::number(ui->dateEdit->date().year()); if(ui->dateEdit->date().month()<10) { datetime1=datetime1+tr("-0")+QString::number(ui->dateEdit->date().month()); } else { datetime1=datetime1+tr("-")+QString::number(ui->dateEdit->date().month()); } if(ui->dateEdit->date().day()<10) { datetime1=datetime1+tr("-0")+QString::number(ui->dateEdit->date().day()); } else { datetime1=datetime1+tr("-")+QString::number(ui->dateEdit->date().day()); } datetime2=QString::number(ui->dateEdit_2->date().year()); if(ui->dateEdit_2->date().month()<10) { datetime2=datetime2+tr("-0")+QString::number(ui->dateEdit_2->date().month()); } else { datetime2=datetime2+tr("-")+QString::number(ui->dateEdit_2->date().month()); } if(ui->dateEdit_2->date().day()<10) { datetime2=datetime2+tr("-0")+QString::number(ui->dateEdit_2->date().day()); } else { datetime2=datetime2+tr("-")+QString::number(ui->dateEdit_2->date().day()); } <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>String=tr("select * from 客户表 where 开单日期 >=")+tr("'")+datetime1+tr("'"); <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>String=<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>String+tr(" and 开单日期 <=")+tr("'")+datetime2+tr("'"); this->fillmodeltable(); //QMessage<a href="https://www.jb51.cc/tag/Box/" target="_blank" class="keywords">Box</a>::about(this,QString::number(pagecount),<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>String);