diff --git a/softwareDirectory/AutoVerScheme/basecommonapi.cpp b/softwareDirectory/AutoVerScheme/basecommonapi.cpp index 52380da..dcc0bf5 100644 --- a/softwareDirectory/AutoVerScheme/basecommonapi.cpp +++ b/softwareDirectory/AutoVerScheme/basecommonapi.cpp @@ -1365,9 +1365,15 @@ { QSqlQuery query; query.prepare("UPDATE zd_verification_program_info " - " SET program_name = :program_name,create_name = :create_name, create_time = :create_time" - "remark = :remark,img_path = :img_path,tested_device_id = :tested_device_id,standard_device_id = :standard_device_id ,update_time = :update_time" - "WHERE id = :id;"); + " SET program_name = :program_name," + "create_name = :create_name, " + "create_time = :create_time," + "remark = :remark," + "img_path = :img_path," + "tested_device_id = :tested_device_id," + "standard_device_id = :standard_device_id ," + "update_time = :update_time " + " WHERE id = :id;"); QString formattedDateTime = verInfo.create_time.toString("yyyy-MM-dd HH:mm:ss"); QString currentDateTime = QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss"); query.bindValue(":update_time",currentDateTime); @@ -1380,6 +1386,7 @@ query.bindValue(":standard_device_id", verInfo.standard_device_id); query.bindValue(":id", verInfo.id); bool isSuccess = query.exec(); + qDebug() << "执行的sql:" <setTextAlignment(Qt::AlignCenter); //ui->tableWidget->setItem(0, 0, item); //设置数据 - ui->tableWidget->setColumnWidth(0, 0); // 设置第一列的宽度为0 +// ui->tableWidget->setColumnWidth(0, 0); // 设置第一列的宽度为0 //初始化TableWidget 设置列 QStringList headers; headers << "ID"<< "序号" << "设备名称" << "型号规则" << "出厂编号"