0515

wumu

2024-05-15 16e4354e393799963ec49630d814292bbfeae110

0515

 internal_system_v1/clientmainwindow.ui

@@ -11,7 +11,7 @@
   </rect>
  </property>
  <property name="windowTitle">
   <string>IS v2.0</string>
   <string>IS v3.0</string>
  </property>
  <widget class="QWidget" name="centralWidget">
   <layout class="QGridLayout" name="gridLayout_3">

 internal_system_v1/threemergeproblemlist.cpp

@@ -830,3 +830,88 @@
    QMessageBox::information(this,"保存提示",QString("总行数为%1,成功%2行，失败%3行。").arg(ui->tableWidget->rowCount())
                             .arg(hasContentRow).arg(ui->tableWidget->rowCount()-hasContentRow));
}

void ThreeMergeProblemList::on_pushButton_moreSearch_clicked()
{
    QString sql = "select * from standing_book_info ";

    QVector<QString> vecCon; // 保存所有条件

    if(ui->checkBox_type->isChecked()){
        QString condition= QString(" 审计类别='%1' ").arg(ui->comboBox_type->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_year->isChecked()){
        QString condition= QString(" 审计年度='%1' ").arg(ui->dateEdit_year->text());
        vecCon.append(condition);
    }
    if(ui->checkBox_com->isChecked()){
        QString condition= QString(" 审计单位='%1' ").arg(ui->comboBox_com->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_way->isChecked()){
        QString condition= QString(" 审计方式='%1' ").arg(ui->comboBox_way->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_mainCom->isChecked()){
        QString condition= QString(" 责任主体名称='%1' ").arg(ui->comboBox_mainCom->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_pro->isChecked()){
        QString condition= QString(" 审计项目='%1' ").arg(ui->comboBox_pro->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_proName->isChecked()){
        QString condition= QString(" 审计项目名称='%1' ").arg(ui->comboBox_proName->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_qtype->isChecked()){
        QString condition= QString(" 问题类别='%1' ").arg(ui->comboBox_qtype->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_qdx->isChecked()){
        QString condition= QString(" 问题定性='%1' ").arg(ui->comboBox_qdx->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_about_money->isChecked()){
        QString condition= QString(" 涉及金额>='%1' and 涉及金额<='%2' ").arg(ui->comboBox_about_bgMonney->currentText()).arg(ui->comboBox_about_edMoney->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_changeMoney->isChecked()){
        QString condition= QString(" 整改金额>='%1' and 整改金额<='%2' ").arg(ui->comboBox_change_bgMoney->currentText()).arg(ui->comboBox_change_edMoney->currentText());
        vecCon.append(condition);
    }
    if(ui->checkBox_change_over_time->isChecked()){
        QString condition= QString(" 整改完成时间='%1' ").arg(ui->dateEdit_change_over_time->text());
        vecCon.append(condition);
    }
    if(ui->checkBox_change_expected_time->isChecked()){
        QString condition= QString(" 整改预计完成时间='%1' ").arg(ui->dateEdit_change_expected_time->text());
        vecCon.append(condition);
    }
    QString condition;
    if(vecCon.size() == 1){
        condition += QString(" where %1").arg(vecCon.at(0));
    }else if(vecCon.size() > 1){
        condition += QString(" where %1").arg(vecCon.at(0));
        for(int i=1;i<vecCon.size();++i){
            condition += QString(" and %1 ").arg(vecCon.at(i));
        }
    }
    sql += condition;
    qDebug()<<sql;

    QVector<QVector<QString>> res;
    int rows = selectSQL(sql,res);
    if(rows > 0){
        ui->tableWidget->setRowCount(rows);
        for(int i=0;i<res.size();++i){
            for(int j=0;j<res.at(0).size()-1;++j){ // 去掉记录时间
                ui->tableWidget->setItem(i,j,new QTableWidgetItem(res[i][j]));
            }
        }
    }else{
        QMessageBox::information(this,"查询失败","可能查询的内容不正确或者没有记录相应的数据");
    }

}

 internal_system_v1/threemergeproblemlist.h

@@ -68,6 +68,8 @@

    void on_pushButton_save_3_clicked();

    void on_pushButton_moreSearch_clicked();

private:
    Ui::ThreeMergeProblemList *ui;
    QMenu *m_menu; // 问题清单菜单

 internal_system_v1/threemergeproblemlist.ui

@@ -6,8 +6,8 @@
   <rect>
    <x>0</x>
    <y>0</y>
    <width>1483</width>
    <height>1031</height>
    <width>1281</width>
    <height>1038</height>
   </rect>
  </property>
  <property name="windowTitle">
@@ -25,8 +25,8 @@
        <rect>
         <x>0</x>
         <y>0</y>
         <width>1459</width>
         <height>956</height>
         <width>1257</width>
         <height>654</height>
        </rect>
       </property>
       <layout class="QGridLayout" name="gridLayout_5">
@@ -199,33 +199,6 @@
        </item>
        <item row="5" column="0">
         <layout class="QGridLayout" name="gridLayout_3">
          <item row="1" column="1">
           <widget class="QLabel" name="label">
            <property name="text">
             <string>要删除某一行直接右击删除即可</string>
            </property>
           </widget>
          </item>
          <item row="1" column="2">
           <spacer name="horizontalSpacer">
            <property name="orientation">
             <enum>Qt::Horizontal</enum>
            </property>
            <property name="sizeHint" stdset="0">
             <size>
              <width>40</width>
              <height>20</height>
             </size>
            </property>
           </spacer>
          </item>
          <item row="1" column="3">
           <widget class="QPushButton" name="pushButton_save">
            <property name="text">
             <string>保存</string>
            </property>
           </widget>
          </item>
          <item row="2" column="0" colspan="4">
           <widget class="QTableWidget" name="tableWidget_2">
            <attribute name="horizontalHeaderVisible">
@@ -311,10 +284,30 @@
            </column>
           </widget>
          </item>
          <item row="1" column="0">
           <widget class="QPushButton" name="pushButton_addRow">
          <item row="1" column="2">
           <spacer name="horizontalSpacer">
            <property name="orientation">
             <enum>Qt::Horizontal</enum>
            </property>
            <property name="sizeHint" stdset="0">
             <size>
              <width>40</width>
              <height>20</height>
             </size>
            </property>
           </spacer>
          </item>
          <item row="1" column="3">
           <widget class="QPushButton" name="pushButton_save">
            <property name="text">
             <string>增加一行</string>
             <string>保存</string>
            </property>
           </widget>
          </item>
          <item row="1" column="1">
           <widget class="QLabel" name="label">
            <property name="text">
             <string>要删除某一行直接右击删除即可</string>
            </property>
           </widget>
          </item>
@@ -322,6 +315,13 @@
           <widget class="QLabel" name="label_5">
            <property name="text">
             <string>整改成果</string>
            </property>
           </widget>
          </item>
          <item row="1" column="0">
           <widget class="QPushButton" name="pushButton_addRow">
            <property name="text">
             <string>增加一行</string>
            </property>
           </widget>
          </item>
@@ -682,6 +682,384 @@
      </widget>
     </widget>
    </item>
    <item row="1" column="0">
     <widget class="QGroupBox" name="groupBox">
      <property name="minimumSize">
       <size>
        <width>0</width>
        <height>200</height>
       </size>
      </property>
      <property name="title">
       <string>多维度查询条件</string>
      </property>
      <layout class="QGridLayout" name="gridLayout_6">
       <item row="0" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout">
         <item>
          <widget class="QCheckBox" name="checkBox_type">
           <property name="text">
            <string>审计类别</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_type">
           <item>
            <property name="text">
             <string>内审</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>外审</string>
            </property>
           </item>
          </widget>
         </item>
        </layout>
       </item>
       <item row="0" column="1">
        <layout class="QHBoxLayout" name="horizontalLayout_10">
         <item>
          <widget class="QCheckBox" name="checkBox_about_money">
           <property name="text">
            <string>涉及金额(万)</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_about_bgMonney">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QLabel" name="label_8">
           <property name="text">
            <string>至</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_about_edMoney">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="1" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_2">
         <item>
          <widget class="QCheckBox" name="checkBox_year">
           <property name="text">
            <string>审计年度</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QDateEdit" name="dateEdit_year">
           <property name="displayFormat">
            <string>yyyy</string>
           </property>
           <property name="date">
            <date>
             <year>2024</year>
             <month>1</month>
             <day>1</day>
            </date>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="1" column="1">
        <layout class="QHBoxLayout" name="horizontalLayout_11">
         <item>
          <widget class="QCheckBox" name="checkBox_changeMoney">
           <property name="text">
            <string>整改金额(万)</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_change_bgMoney">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QLabel" name="label_9">
           <property name="text">
            <string>至</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_change_edMoney">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="2" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_3">
         <item>
          <widget class="QCheckBox" name="checkBox_com">
           <property name="text">
            <string>审计单位</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_com">
           <item>
            <property name="text">
             <string>审计局</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>审计厅</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>审计署</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>其他</string>
            </property>
           </item>
          </widget>
         </item>
        </layout>
       </item>
       <item row="2" column="1">
        <layout class="QHBoxLayout" name="horizontalLayout_12">
         <item>
          <widget class="QCheckBox" name="checkBox_change_over_time">
           <property name="text">
            <string>整改完成时间</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QDateEdit" name="dateEdit_change_over_time">
           <property name="displayFormat">
            <string>yyyy/MM/dd</string>
           </property>
           <property name="date">
            <date>
             <year>2024</year>
             <month>1</month>
             <day>1</day>
            </date>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="3" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_4">
         <item>
          <widget class="QCheckBox" name="checkBox_way">
           <property name="text">
            <string>审计方式</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_way">
           <item>
            <property name="text">
             <string>就地审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>报送审计</string>
            </property>
           </item>
          </widget>
         </item>
        </layout>
       </item>
       <item row="3" column="1" rowspan="2">
        <layout class="QHBoxLayout" name="horizontalLayout_13">
         <item>
          <widget class="QCheckBox" name="checkBox_change_expected_time">
           <property name="text">
            <string>整改预计完成时间</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QDateEdit" name="dateEdit_change_expected_time">
           <property name="displayFormat">
            <string>yyyy/MM/dd</string>
           </property>
           <property name="date">
            <date>
             <year>2024</year>
             <month>1</month>
             <day>1</day>
            </date>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="4" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_5">
         <item>
          <widget class="QCheckBox" name="checkBox_mainCom">
           <property name="text">
            <string>责任主体</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_mainCom">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="5" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_6">
         <item>
          <widget class="QCheckBox" name="checkBox_pro">
           <property name="text">
            <string>审计项目</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_pro">
           <item>
            <property name="text">
             <string>贯彻落实国家重大政策措施审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>财政财务收支审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>固定资产投资审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>内部控制和风险管理审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>经济责任审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>信息系统审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>境外审计</string>
            </property>
           </item>
           <item>
            <property name="text">
             <string>其他</string>
            </property>
           </item>
          </widget>
         </item>
        </layout>
       </item>
       <item row="6" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_7">
         <item>
          <widget class="QCheckBox" name="checkBox_proName">
           <property name="text">
            <string>审计项目名称</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_proName">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="7" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_8">
         <item>
          <widget class="QCheckBox" name="checkBox_qtype">
           <property name="text">
            <string>问题类别</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_qtype">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
       <item row="7" column="2" rowspan="2">
        <widget class="QPushButton" name="pushButton_moreSearch">
         <property name="font">
          <font>
           <pointsize>15</pointsize>
          </font>
         </property>
         <property name="text">
          <string>多维度查询</string>
         </property>
        </widget>
       </item>
       <item row="8" column="0">
        <layout class="QHBoxLayout" name="horizontalLayout_9">
         <item>
          <widget class="QCheckBox" name="checkBox_qdx">
           <property name="text">
            <string>问题定性</string>
           </property>
          </widget>
         </item>
         <item>
          <widget class="QComboBox" name="comboBox_qdx">
           <property name="editable">
            <bool>true</bool>
           </property>
          </widget>
         </item>
        </layout>
       </item>
      </layout>
     </widget>
    </item>
   </layout>
  </widget>
  <widget class="QMenuBar" name="menubar">
@@ -689,7 +1067,7 @@
    <rect>
     <x>0</x>
     <y>0</y>
     <width>1483</width>
     <width>1281</width>
     <height>26</height>
    </rect>
   </property>