void PosService::on_btSetTime_clicked()
{
int button_width = data->getVariables()->value(_S("standart_button_width")).toInt();
int button_height = data->getVariables()->value(_S("standart_button_height")).toInt();
int button_margin = data->getVariables()->value(_S("standart_margins")).toInt();
QDialog dlg;
QVBoxLayout* mainLayout = new QVBoxLayout();
dlg.setLayout(mainLayout);
dlg.setWindowTitle(_T("Установка времени"));
QDateTimeEdit* edit = new QDateTimeEdit(QDateTime::currentDateTime());
edit->setMaximumHeight(button_height);
edit->setMinimumHeight(button_height);
mainLayout->addWidget(edit);
QHBoxLayout *btLayout = new QHBoxLayout();
mainLayout->addLayout(btLayout);
QPushButton* bt;
bt = new QPushButton(_T("OK"), this);
bt->setMaximumSize(button_width * 2 + button_margin, button_height);
bt->setMinimumSize(button_width * 2 + button_margin, button_height);
btLayout->addWidget(bt);
connect(bt, SIGNAL(clicked()), &dlg, SLOT(accept()));
bt = new QPushButton(_T("Отмена"), this);
bt->setMaximumSize(button_width * 2 + button_margin, button_height);
bt->setMinimumSize(button_width * 2 + button_margin, button_height);
btLayout->addWidget(bt);
connect(bt, SIGNAL(clicked()), &dlg, SLOT(reject()));
int result = dlg.exec();
if(result==QDialog::Accepted)
{
QString dt = edit->dateTime().toString(data->getSettings()->value("posservice/command_setdatetime_format").toString());
QString command = data->getSettings()->value("posservice/command_setdatetime").toString().arg(dt);
if (loglevel > 0)
qDebug() << _T("%1 Устанавливаем новое время: %2 (было: %3)")
.arg(posForLog)
.arg(edit->dateTime().toString(Qt::ISODate))
.arg(QDateTime::currentDateTime().toString(Qt::ISODate));
int result = QProcess::execute(command);
if(result<0)
{
qDebug() << _T("%1 Ошибка установки нового времени. Код ошибки: %2")
.arg(posForLog)
.arg(result);
QMessageBox message;
message.setText(_T("Ошибка установки нового времени.\nКод ошибки: %1").arg(result));
message.exec();
}
}
}
void QFRDRTableDelegate::setModelData(QWidget *editor, QAbstractItemModel *model, const QModelIndex &index) const
{
QFDoubleEdit *dEditor = qobject_cast<QFDoubleEdit *>(editor);
if (dEditor) {
QVariant v( dEditor->value());
v.convert(QVariant::Double);
//qDebug()<<v;
model->setData(index, v);
} else {
QDateTimeEdit *dateEditor = qobject_cast<QDateTimeEdit *>(editor);
if (dateEditor) {
model->setData(index, dateEditor->dateTime());
} else {
QSpinBox *sEditor = qobject_cast<QSpinBox *>(editor);
if (sEditor) {
model->setData(index, sEditor->value());
} else {
QCheckBox *check = qobject_cast<QCheckBox *>(editor);
if (check) {
model->setData(index, check->isChecked());
} else {
QLineEdit *edit = qobject_cast<QLineEdit*>(editor);
if (edit) {
model->setData(index, edit->text());
}
}
}
}
}
}
void ContactDialog::readAnniversary(int num, DateItem &ann)
{
QDateTimeEdit* editor = findChild<QDateTimeEdit*>
(QString("dteAnn%1Date").arg(num));
if (!editor) return;
anniversaryDetails[num-1].value = editor->dateTime();
ann = anniversaryDetails[num-1];
}
//Check to make sure display time comes before end display time
void NLSimpleGuiWindow::checkDisplayTimeLimitsConsistency()
{
QDateTimeEdit *endEntry = ui->endDisplayTime;
QDateTimeEdit *startEntry = ui->startDisplayTime;
if( startEntry->dateTime() <= endEntry->dateTime() )
return;
if( posixTimeToQTime(kGenericT0) == endEntry->dateTime() )
return;
if( posixTimeToQTime(kGenericT0) == startEntry->dateTime() )
return;
QObject *caller = QObject::sender();
if( caller == dynamic_cast<QObject *>(endEntry) )
{
endEntry->setDateTime( startEntry->dateTime() );
}else if( caller == dynamic_cast<QObject *>(startEntry) )
{
startEntry->setDateTime( endEntry->dateTime() );
}else
{
cout << "void NLSimpleGuiWindow::checkDisplayTimeLimitsConsistency()"
<< " error in caller logic" << endl;
endEntry->setDateTime( startEntry->dateTime() );
}//
}//void NLSimpleGuiWindow::checkDisplayTimeLimitsConsistency()
void MyDateItemDelegate::setModelData(QWidget *editor, QAbstractItemModel *model,
const QModelIndex &index) const
{
QDateTimeEdit *e = static_cast<QDateTimeEdit*>(editor);
e->interpretText();
const QDateTime& value = e->dateTime();
model->setData(index, value.toString(DATETIMEFORMAT), Qt::EditRole);
}
void setModelData(QWidget *editor, QAbstractItemModel *model, const QModelIndex &index) const {
if (!index.isValid())
return;
QDateTimeEdit *edit = qobject_cast<QDateTimeEdit *>(editor);
if (!edit) {
QItemDelegate::setModelData(editor, model, index);
return;
}
model->setData(index, edit->dateTime().toString("yyyy-MM-dd hh:mm"), Qt::EditRole);
}
void MultiDelegate::setModelData(QWidget *editor, QAbstractItemModel *model,
const QModelIndex &index) const
{
QVariant value;
QString className = editor->metaObject()->className();
if (className == "QTimeEdit") {
QTimeEdit* ed = qobject_cast<QTimeEdit*>(editor);
Q_ASSERT( ed);
value = QVariant( ed->time());
}
else if (className == "QDateEdit") {
QDateEdit* ed = qobject_cast<QDateEdit*>(editor);
Q_ASSERT( ed);
value = QVariant( ed->date());
}
else if (className == "QDateTimeEdit") {
QDateTimeEdit* ed = qobject_cast<QDateTimeEdit*>(editor);
Q_ASSERT( ed);
value = QVariant( ed->dateTime());
}
else if (className == "IconViewer") {
return;
}
else if (className == "QComboBox") {
QComboBox* ed = qobject_cast<QComboBox*>(editor);
Q_ASSERT( ed);
value = QVariant( ed->currentText());
}
else if (className == "QListWidget") {
QListWidget* ed = qobject_cast<QListWidget*>(editor);
Q_ASSERT( ed);
QStringList valList;
int itemCount = ed->count();
for (int i = 0; i < itemCount; ++i) {
QListWidgetItem* bitItem = ed->item(i);
bool isChecked = (bitItem->checkState() == Qt::Checked);
if (isChecked)
valList += bitItem->text();
}
value = QVariant( valList);
}
else if (className == "QCheckBox") {
QCheckBox* ed = qobject_cast<QCheckBox*>(editor);
Q_ASSERT( ed);
value = QVariant( ed->isChecked());
}
else {
QItemDelegate::setModelData( editor, model, index);
return;
}
model->setData(index, value, Qt::EditRole);
}
void DateTimeDelegate::setModelData(QWidget *editor, QAbstractItemModel *model,
const QModelIndex &index) const
{
QDateEdit *dateEdit = qobject_cast<QDateEdit*>(editor);
if (dateEdit) {
model->setData(index, dateEdit->date(), Qt::EditRole);
} else {
QDateTimeEdit *dateTimeEdit = qobject_cast<QDateTimeEdit*>(editor);
if (dateTimeEdit) {
model->setData(index, dateTimeEdit->dateTime(), Qt::EditRole);
}
}
}
void CDlgBulkRegister::OnBulkMonth( int nMonth )
{
QDateTimeEdit* pDt = NULL;
QDateTime dtStart;
for ( int nRow = 0; nRow < ui->tabRecord->rowCount( ); nRow++ ) {
pDt = ( QDateTimeEdit* ) ui->tabRecord->cellWidget( nRow, 5 );
dtStart = pDt->dateTime( );
pDt = ( QDateTimeEdit* ) ui->tabRecord->cellWidget( nRow, 6 );
dtStart = dtStart.addMonths( nMonth );
//qDebug( ) << dtStart.toString( ) << endl;
pDt->setDateTime( dtStart );
}
}
QVariant UIPropertyGetters::DefaultGetter(QWidget* editor, SettingsPropertyMapper::WidgetType editorType, SettingsPropertyMapper::PropertyType)
{
switch (editorType)
{
case SettingsPropertyMapper::CHECKBOX:
{
QCheckBox* pCheckBox = qobject_cast<QCheckBox*>(editor);
if (pCheckBox == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pCheckBox->isChecked());
}
case SettingsPropertyMapper::RADIOBUTTON:
{
QRadioButton* pRadioButton = qobject_cast<QRadioButton*>(editor);
if (pRadioButton == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pRadioButton->isChecked());
}
case SettingsPropertyMapper::CHECKABLE_GROUPBOX:
{
QGroupBox* pGroupBox = qobject_cast<QGroupBox*>(editor);
if (pGroupBox == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
if (!pGroupBox->isCheckable())
{
qCritical() << "Given QGroupBox is not checkable";
}
return QVariant::fromValue(pGroupBox->isChecked());
}
case SettingsPropertyMapper::LINE_EDIT:
{
QLineEdit* pLineEdit = qobject_cast<QLineEdit*>(editor);
if (pLineEdit == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pLineEdit->text());
}
case SettingsPropertyMapper::TEXT_EDIT:
{
QTextEdit* pTextEdit = qobject_cast<QTextEdit*>(editor);
if (pTextEdit == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pTextEdit->toPlainText());
}
case SettingsPropertyMapper::COMBOBOX:
{
QComboBox* pComboBox = qobject_cast<QComboBox*>(editor);
if (pComboBox == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pComboBox->currentIndex());
}
case SettingsPropertyMapper::SPINBOX:
{
QSpinBox* pSpinBox = qobject_cast<QSpinBox*>(editor);
if (pSpinBox == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pSpinBox->value());
}
case SettingsPropertyMapper::DOUBLE_SPINBOX:
{
QDoubleSpinBox* pDoubleSpinBox = qobject_cast<QDoubleSpinBox*>(editor);
if (pDoubleSpinBox == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pDoubleSpinBox->value());
}
case SettingsPropertyMapper::TIME_EDIT:
{
QTimeEdit* pTimeEdit = qobject_cast<QTimeEdit*>(editor);
if (pTimeEdit == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pTimeEdit->time());
}
case SettingsPropertyMapper::DATETIME_EDIT:
{
QDateTimeEdit* pDateTimeEdit = qobject_cast<QDateTimeEdit*>(editor);
if (pDateTimeEdit == NULL)
{
qCritical() << "Invalid editor given";
return QVariant();
}
return QVariant::fromValue(pDateTimeEdit->dateTime());
}
default:
{
return QVariant();
}
}
}
HistoryWidget::HistoryWidget(QWidget *parent)
: QDialog(parent)
{
setObjectName("HistoryWidget");
setWindowTitle(tr("History Data View"));
// layout - top
QHBoxLayout *horiLayoutTop = new QHBoxLayout();
QPushButton *buttonQuit = new QPushButton(this);
buttonQuit->setObjectName("buttonQuit");
horiLayoutTop->addSpacing(25);
horiLayoutTop->addWidget(buttonQuit, 0, Qt::AlignLeft);
horiLayoutTop->addStretch();
// button-export
QPushButton *buttonExport = new QPushButton(this);
buttonExport->setObjectName("buttonExport");
horiLayoutTop->addWidget(buttonExport);
horiLayoutTop->addStretch();
// button-open
QPushButton *buttonOpen = new QPushButton(this);
buttonOpen->setObjectName("buttonOpen");
horiLayoutTop->addWidget(buttonOpen);
horiLayoutTop->addStretch();
QFormLayout *formLayoutTime = new QFormLayout();
formLayoutTime->setFormAlignment(Qt::AlignVCenter);
horiLayoutTop->addLayout(formLayoutTime);
horiLayoutTop->addStretch();
QDateTimeEdit *dateTimeEditStart = new QDateTimeEdit(this);
dateTimeEditStart->setObjectName("dateTimeEditStart");
dateTimeEditStart->setDisplayFormat("yyyy-MM-dd HH:mm:ss");
formLayoutTime->addRow(tr("Start Time:"), dateTimeEditStart);
QDateTimeEdit *dateTimeEditEnd = new QDateTimeEdit(this);
dateTimeEditEnd->setObjectName("dateTimeEditEnd");
dateTimeEditEnd->setDisplayFormat("yyyy-MM-dd HH:mm:ss");
formLayoutTime->addRow(tr("End Time:"), dateTimeEditEnd);
//LBP
QFormLayout *formLayoutLBP = new QFormLayout();
formLayoutLBP->setFormAlignment(Qt::AlignVCenter);
formLayoutLBP->setLabelAlignment(Qt::AlignRight);
horiLayoutTop->addLayout(formLayoutLBP);
horiLayoutTop->addStretch();
QCheckBox *checkBoxLBPMajor = new QCheckBox(tr("Major"), this);
checkBoxLBPMajor->setProperty("curveColor", "#101010");
QCheckBox *checkBoxLBPMinor = new QCheckBox(tr("Minor"), this);
checkBoxLBPMinor->setProperty("curveColor", "#101010");
formLayoutLBP->addRow(tr("LBP:"), checkBoxLBPMajor);
formLayoutLBP->addRow("", checkBoxLBPMinor);
//RBP
QFormLayout *formLayoutRBP = new QFormLayout();
formLayoutRBP->setFormAlignment(Qt::AlignVCenter);
formLayoutRBP->setLabelAlignment(Qt::AlignRight);
horiLayoutTop->addLayout(formLayoutRBP);
horiLayoutTop->addStretch();
QCheckBox *checkBoxRBPMajor = new QCheckBox(tr("Major"), this);
checkBoxRBPMajor->setProperty("curveColor", "#101010");
QCheckBox *checkBoxRBPMinor = new QCheckBox(tr("Minor"), this);
checkBoxRBPMinor->setProperty("curveColor", "#101010");
formLayoutRBP->addRow(tr("RBP:"), checkBoxRBPMajor);
formLayoutRBP->addRow("", checkBoxRBPMinor);
//LRP
QFormLayout *formLayoutLRP = new QFormLayout();
formLayoutLRP->setFormAlignment(Qt::AlignVCenter);
formLayoutLRP->setLabelAlignment(Qt::AlignRight);
horiLayoutTop->addLayout(formLayoutLRP);
horiLayoutTop->addStretch();
QCheckBox *checkBoxLRPTheory = new QCheckBox(tr("Theory"), this);
checkBoxLRPTheory->setProperty("curveColor", "#101010");
QCheckBox *checkBoxLRPReal = new QCheckBox(tr("Real"), this);
checkBoxLRPReal->setProperty("curveColor", "#101010");
formLayoutLRP->addRow(tr("LRP:"), checkBoxLRPTheory);
formLayoutLRP->addRow("", checkBoxLRPReal);
//RRP
QFormLayout *formLayoutRRP = new QFormLayout();
formLayoutRRP->setFormAlignment(Qt::AlignVCenter);
formLayoutRRP->setLabelAlignment(Qt::AlignRight);
horiLayoutTop->addLayout(formLayoutRRP);
horiLayoutTop->addStretch();
QCheckBox *checkBoxRRPTheory = new QCheckBox(tr("Theory"), this);
checkBoxRRPTheory->setProperty("curveColor", "#101010");
QCheckBox *checkBoxRRPReal = new QCheckBox(tr("Real"), this);
checkBoxRRPReal->setProperty("curveColor", "#101010");
formLayoutRRP->addRow(tr("RRP:"), checkBoxRRPTheory);
formLayoutRRP->addRow("", checkBoxRRPReal);
// button-update
QPushButton *buttonUpdate = new QPushButton(this);
buttonUpdate->setObjectName("buttonUpdate");
horiLayoutTop->addWidget(buttonUpdate);
horiLayoutTop->addStretch();
/*
// button-undo
QPushButton *buttonUndo = new QPushButton(this);
buttonUndo->setObjectName("buttonUndo");
horiLayoutTop->addWidget(buttonUndo);
horiLayoutTop->addStretch();
*/
// middle - curves
CurveWidget* curveHistory = new CurveWidget(tr("History Data View"), this, true);
curveHistory->setMaximumWidth(10000000);
curveHistory->setScaleLabelFormat("yyyy/MM/dd\n HH:mm:ss");
curveHistory->clear();
QVBoxLayout *vertLayoutMain = new QVBoxLayout(this);
vertLayoutMain->addLayout(horiLayoutTop);
vertLayoutMain->addWidget(curveHistory);
connect(buttonQuit, &QPushButton::clicked, this, [=](){
this->accept();
});
connect(buttonOpen, &QPushButton::clicked, this, [=](){
QFileDialog fileDialog(this,
tr("Open history database files"),
QApplication::applicationDirPath().append("/../data"),
tr("Data Base File (*.db *.mdb)"));
if (fileDialog.exec() == QDialog::Rejected) {
return;
}
// clear curve
curveHistory->clear();
//
QStringList filePaths = fileDialog.selectedFiles();
if (filePaths.isEmpty()) {
return;
}
QString filePath = filePaths.first();
if (filePath.isEmpty()) {
return;
}
// open database
if (!DataBaseMgr::instance().open(filePath)) {
Q_ASSERT(false);
return;
}
//
QDateTime startTime = QDateTime::fromMSecsSinceEpoch(DataBaseMgr::instance().startTime());
QDateTime endTime = QDateTime::fromMSecsSinceEpoch(DataBaseMgr::instance().endTime());
dateTimeEditStart->setDateTimeRange(startTime, endTime);
dateTimeEditEnd->setDateTimeRange(startTime, endTime);
dateTimeEditEnd->setDateTime(endTime);
dateTimeEditStart->setDateTime(startTime);
// curve title
curveHistory->setTitle(tr("History Data View")
.append(" (")
.append(QFileInfo(filePath).fileName())
.append(")"));
});
connect(buttonExport, &QPushButton::clicked, this, [=](){
QStringList filePaths = QFileDialog::getOpenFileNames(this,
tr("Convert data base files to txt format and save..."),
QApplication::applicationDirPath().append("/../data"),
tr("Data Base File (*.db *.mdb)"));
if (filePaths.isEmpty()) {
return;
}
//
if (DataBaseMgr::instance().convertToText(filePaths)) {
QMessageBox::information(this, tr("Convert Database file"), tr("Convert successfully!"));
} else {
QMessageBox::information(this, tr("Convert Database file"), tr("Convert failed!"));
}
});
connect(dateTimeEditStart, &QDateTimeEdit::dateTimeChanged, this, [=](const QDateTime &dateTime){
QDateTime endDateTime = dateTimeEditEnd->dateTime();
if (dateTime > endDateTime) {
dateTimeEditStart->setDateTime(endDateTime);
}
});
connect(dateTimeEditEnd, &QDateTimeEdit::dateTimeChanged, this, [=](const QDateTime &dateTime){
QDateTime startDateTime = dateTimeEditStart->dateTime();
if (dateTime < startDateTime) {
dateTimeEditEnd->setDateTime(startDateTime);
}
});
connect(checkBoxLBPMajor, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[0] = checked;
});
connect(checkBoxLBPMinor, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[1] = checked;
});
connect(checkBoxRBPMajor, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[2] = checked;
});
connect(checkBoxRBPMinor, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[3] = checked;
});
connect(checkBoxLRPTheory, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[4] = checked;
});
connect(checkBoxLRPReal, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[5] = checked;
});
connect(checkBoxRRPTheory, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[6] = checked;
});
connect(checkBoxRRPReal, &QCheckBox::toggled, this, [=](bool checked){
_v_curve_checked[7] = checked;
});
connect(buttonUpdate, &QPushButton::clicked, this, [=](){
// clear curve
curveHistory->clear();
QVector<QPointF> points;
quint64 startTime = dateTimeEditStart->dateTime().toMSecsSinceEpoch();
quint64 endTime = dateTimeEditEnd->dateTime().toMSecsSinceEpoch();
// LBP-Major
if (checkBoxLBPMajor->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("lMBrakeP", points, startTime, endTime)) {
curveHistory->addCurve(tr("LBP-Major"), QPen(randomColor(0)), points);
}
}
//QApplication::processEvents();
// LBP-Minor
if (checkBoxLBPMinor->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("lABrakeP", points, startTime, endTime)) {
curveHistory->addCurve(tr("LBP-Minor"), QPen(randomColor(1)), points);
}
}
//QApplication::processEvents();
// RBP-Major
if (checkBoxRBPMajor->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("rMBrakeP", points, startTime, endTime)) {
curveHistory->addCurve(tr("RBP-Major"), QPen(randomColor(2)), points);
}
}
//QApplication::processEvents();
// RBP-Minor
if (checkBoxRBPMinor->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("rABrakeP", points, startTime, endTime)) {
curveHistory->addCurve(tr("RBP-Minor"), QPen(randomColor(3)), points);
}
}
//QApplication::processEvents();
// LRP-Theory
if (checkBoxLRPTheory->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("lTheorySpd", points, startTime, endTime)) {
curveHistory->addCurve(tr("LRP-Theory"), QPen(randomColor(4)), points);
}
}
//QApplication::processEvents();
// LRP-Real
if (checkBoxLRPReal->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("lWheelSpd", points, startTime, endTime)) {
curveHistory->addCurve(tr("LRP-Real"), QPen(randomColor(5)), points);
}
}
//QApplication::processEvents();
// RRP-Theory
if (checkBoxRRPTheory->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("rTheorySpd", points, startTime, endTime)) {
curveHistory->addCurve(tr("RRP-Theory"), QPen(randomColor(6)), points);
}
}
//QApplication::processEvents();
// RRP-Real
if (checkBoxRRPReal->isChecked()) {
// read
points.clear();
if (DataBaseMgr::instance().read("rWheelSpd", points, startTime, endTime)) {
curveHistory->addCurve(tr("RRP-Real"), QPen(randomColor(7)), points);
}
}
});
/*
connect(buttonUndo, &QPushButton::clicked, this, [=](){
curveHistory->setNormalScale();
});
*/
// finaly initialize
checkBoxLBPMajor->setChecked(_v_curve_checked[0]);
checkBoxLBPMinor->setChecked(_v_curve_checked[1]);
checkBoxRBPMajor->setChecked(_v_curve_checked[2]);
checkBoxRBPMinor->setChecked(_v_curve_checked[3]);
checkBoxLRPTheory->setChecked(_v_curve_checked[4]);
checkBoxLRPReal->setChecked(_v_curve_checked[5]);
checkBoxRRPTheory->setChecked(_v_curve_checked[6]);
checkBoxRRPReal->setChecked(_v_curve_checked[7]);
}
void CDlgBulkRegister::SaveMonthData( QStringList &lstDuplication, QStringList& lstTotalSql )
{
int nRows = ui->tabRecord->rowCount( );
QStringList lstSql;
QString strTrue = "1";
QString strFalse = "0";
QString strDateTime = "";
QDateTime dt;
QString strQuotation = "'";
bool bChecked = false;
QComboBox* pCB = NULL;
QDateTimeEdit* pDT = NULL;
QString strText = "";
QStringList lstExist;
QStringList lstCardNo;
for ( int nRow = 0; nRow < nRows; nRow++ ) {
lstSql.clear( );
strText = ui->tabRecord->item( nRow, 0 )->text( );
CLogicInterface::GetInterface( )->ExistCardNumber(strText, lstExist );
if ( 0 < lstExist.count( ) ) {
lstDuplication << lstExist;
continue;
}
QList< QTableWidgetItem* > lstItems = tabWidget->findItems( strText, Qt::MatchFixedString );
if ( 0 < lstItems.count( ) ) {
lstDuplication << strText;
continue;
}
tabWidget->insertRow( 0 );
lstCardNo << "'" + strText + "'";
for ( int nCol = 0; nCol < ui->tabRecord->columnCount( ); nCol++ ) {
switch ( nCol ) {
case 0 :
case 8 :
case 9 :
case 10 :
strText = ui->tabRecord->item( nRow, nCol )->text( );
lstSql << ( strQuotation + strText + strQuotation );
AddItem( strText, 0, nCol, tabWidget );
break;
case 1 :
case 2 :
case 3 :
bChecked = Qt::Checked == ui->tabRecord->item( nRow, nCol )->checkState( );
lstSql << ( bChecked ? strTrue : strFalse );
AddCheckBoxItem( 0, nCol, tabWidget, bChecked );
break;
case 4 :
case 7 :
pCB = ( QComboBox* ) ui->tabRecord->cellWidget( nRow, nCol );
strText = pCB->currentText( );
lstSql << ( strQuotation + strText + strQuotation );
AddItem( strText, 0, nCol, tabWidget );
break;
case 5 :
case 6 :
pDT = ( QDateTimeEdit* ) ui->tabRecord->cellWidget( nRow, nCol );
dt = pDT->dateTime( );
CCommonFunction::DateTime2String( dt, strDateTime );
lstSql << ( strQuotation + strDateTime + strQuotation );
AddItem( strDateTime, 0, nCol, tabWidget );
break;
}
}
lstTotalSql << ( "(" + lstSql.join( "," ) + " )" );
}
emit BroadcastCardNo( lstCardNo );
}
void DateTimeCalendarDelegate::setModelData(QWidget *editor, QAbstractItemModel *model,
const QModelIndex &index) const
{
QDateTimeEdit *e = static_cast<QDateTimeEdit*>(editor);
model->setData( index, e->dateTime(), Qt::EditRole );
}
