bool FLUtil::writeDBSettingEntry( const QString & key, const QString & value ) { int size; bool result; sqlSelect( "flsettings", "valor", "flkey = '" + key + "'", "flsettings", &size ); if ( size > 0 ) result = sqlUpdate( "flsettings", "valor", value, "flkey = '" + key + "'" ); else result = sqlInsert( "flsettings", "flkey,valor", key + "," + value ); return result; }
bool FLUtil::writeDBSettingEntry(const QString &key, const QString &value) { int size; bool result; QString where(QString::fromLatin1("flkey='") + key + QString::fromLatin1("'")); sqlSelect("flsettings", "valor", where, "flsettings", &size); if (size > 0) { result = sqlUpdate("flsettings", "valor", value, where); } else { result = sqlInsert("flsettings", "flkey,valor", key + QString::fromLatin1(",") + value); } return result; }
QVariant FLUtil::readDBSettingEntry(const QString &key) { return sqlSelect("flsettings", "valor", QString::fromLatin1("flkey='") + key + QString::fromLatin1("'")); }
void SoftKeyPad::slotKeyInputClicked(int id) { if (17 == id) { // china_button inputChoiceFlag = false; current_choice = KeyInput_Chinese; setNumShow(); setChineseShow(); } else if (23 == id) { // english_button inputChoiceFlag = true; current_choice = KeyInput_English; setNumShow(); setEnglishShow(); } else if (52 == id) { //symbol_button inputChoiceFlag = true; current_choice = KeyInput_Symbol; setNumShow(); setSymbolShow(); } else if (15 == id) { //取消按钮压下 // ######################################## ui->textEdit->setText(""); this->close(); } else if (24 == id) { //enter button click if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } if ((KeyInput_Chinese == current_choice) && (ui->textEdit_letter->toPlainText() != "")) { ui->textEdit->insertPlainText(ui->textEdit_letter->toPlainText()); ui->textEdit_letter->setText(""); ui->textEdit_letter->setHidden(true); ui->showTxt->setHidden(true); firstInputLetter = true; } else { // 发送信号 emit sigOkPressSignal(); this->close(); } } else if (39 == id) { //OK 按钮下压 //########################################### emit sigOkPressSignal(); this->close(); } else if (13 == id) { // BS button click if ((KeyInput_Chinese == current_choice) && (ui->textEdit_letter->toPlainText() != "")) { listId = 0; course = ui->textEdit_letter->textCursor(); course.deletePreviousChar(); inputLetter = ui->textEdit_letter->toPlainText().toLower(); list.clear(); if ("" == inputLetter) { ui->textEdit_letter->setHidden(true); ui->showTxt->setHidden(true); firstInputLetter = true; } else { ui->showTxt->setHidden(false); sqlSelect(); int i = 0; for(i =0 ;i <listCount; i++) qDebug() << list.at(i); if (0 == listCount) { ui->showTxt->setHidden(true); } else if (1 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(""); ui->btn3->setText(""); ui->btn4->setText(""); ui->btn5->setText(""); ui->btn6->setText(""); ui->btn7->setText(""); ui->btn8->setText(""); } else if (2 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(""); ui->btn4->setText(""); ui->btn5->setText(""); ui->btn6->setText(""); ui->btn7->setText(""); ui->btn8->setText(""); } else if (3 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(""); ui->btn5->setText(""); ui->btn6->setText(""); ui->btn7->setText(""); ui->btn8->setText(""); } else if (4 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(list.at(3)); ui->btn5->setText(""); ui->btn6->setText(""); ui->btn7->setText(""); ui->btn8->setText(""); } else if (5 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(list.at(3)); ui->btn5->setText(list.at(5)); ui->btn6->setText(""); ui->btn7->setText(""); ui->btn8->setText(""); } else if (6 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(list.at(3)); ui->btn5->setText(list.at(4)); ui->btn6->setText(list.at(5)); ui->btn7->setText(""); ui->btn8->setText(""); } else if (7 == listCount) { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(list.at(3)); ui->btn5->setText(list.at(4)); ui->btn6->setText(list.at(5)); ui->btn7->setText(list.at(6)); ui->btn8->setText(""); } else { ui->btn1->setText(list.at(0)); ui->btn2->setText(list.at(1)); ui->btn3->setText(list.at(2)); ui->btn4->setText(list.at(3)); ui->btn5->setText(list.at(4)); ui->btn6->setText(list.at(5)); ui->btn7->setText(list.at(6)); ui->btn8->setText(list.at(7)); ui->btn_rightTurn->setEnabled(true); } } listId = 8; } else { course = ui->textEdit->textCursor(); course.deletePreviousChar(); } } else if (21 == id) { // DEL button click if ((KeyInput_Chinese == current_choice) && (ui->textEdit_letter->toPlainText() != "")) { // do nothing } else { course = ui->textEdit->textCursor(); course.deleteChar(); course.movePosition(QTextCursor::NoMove); ui->textEdit->setTextCursor(course); } } else if (32 == id) { // left move Button click if ((KeyInput_Chinese == current_choice) && (ui->textEdit_letter->toPlainText() != "")) { // do nothing } else { course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::PreviousCharacter); ui->textEdit->setTextCursor(course); } } else if (44 == id) { // right move Button click if ((KeyInput_Chinese == current_choice) && (ui->textEdit_letter->toPlainText() != "")) { // do nothing } else { course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCharacter); ui->textEdit->setTextCursor(course); } } ui->textEdit->setTextColor(Qt::black); if (KeyInput_English == current_choice) { if ((33 == id) || (45 == id)) { // left or right shift click if (true == shiftFlag) { ABCShow(); shiftABC(); } else { setEnglishShow(); shiftabc(); } } else if (51 == id) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } ui->textEdit->insertPlainText(" "); } else if (7 == id) { // & 符号单独处理,因为Qt中button按钮&有特殊含义,需要2个&&符号才能显示出“&” if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } if (false == shiftFlag) { ui->textEdit->insertPlainText("&"); } else { ui->textEdit->insertPlainText("7"); } course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCell); ui->textEdit->setTextCursor(course); setEnglishShow(); shiftabc(); } else if ((13 != id) && (15 != id) && (17 != id) && (21 != id) && (23 != id) && (24 != id) && (32 != id) && (39 != id) && (44 != id) && (52 != id)) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } ui->textEdit->insertPlainText(groupButtonAll->button(id)->text()); course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCell); ui->textEdit->setTextCursor(course); setEnglishShow(); shiftabc(); } } else if (KeyInput_Symbol == current_choice) { if (8 == id) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } ui->textEdit->insertPlainText("&"); course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCell); ui->textEdit->setTextCursor(course); } else if ((13 != id) && (15 != id) && (17 != id) && (21 != id) && (23 != id) && (32 != id) && (39 != id) && (44 != id) && (52 != id)) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } ui->textEdit->insertPlainText(groupButtonAll->button(id)->text()); course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCell); ui->textEdit->setTextCursor(course); } } else if (KeyInput_Chinese == current_choice) { list.clear(); if ((10 == id) || (11 == id) || (14 == id) || (20 == id) || (22 == id) || (25 == id) || (26 == id) || (27 == id) || (28 == id) || (29 == id) || (30 == id) || (31 == id) || (35 == id) || (37 == id) || (38 == id) || (40 == id) || (42 == id) || (43 == id) || (46 == id) || (53 == id) || (54 == id) || (55 == id) || (56 == id) || (57 == id) || (58 == id) || (59 == id) || (16 == id) || (48 == id) || (60 == id)) { chineseInputFlag = true; //chineseInout 为true时,数字按钮和标点符号按钮无效 if (true == firstInputLetter) { // 判断是否是第一个字符 singleLetter = groupButtonAll->button(id)->text().toLower(); inputLetter = ""; firstInputLetter = false; } ui->textEdit_letter->setHidden(false); qDebug() << groupButtonAll->button(id)->text(); ui->textEdit_letter->insertPlainText(groupButtonAll->button(id)->text()); inputLetter = ui->textEdit_letter->toPlainText().toLower(); sqlSelect(); // SQL 语句 ui->btn_leftTurn->setEnabled(false); listId = 0; slotRightTurnClicked(); setNumShow(); setChineseShow(); shiftabc(); } else if ((0 == id) || (1 == id) || (2 == id) || (3 == id) || (4 == id) || ( 5 == id) ||(6 == id) || (7 == id) || (8 == id) || (9 == id) || (18 == id) || (19 == id) || (34 == id) || (36 == id) ||(41 == id) || (47 ==id)) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } if (true == chineseInputFlag) { // do nothing } else { ui->textEdit->insertPlainText(groupButtonAll->button(id)->text()); course = ui->textEdit->textCursor(); course.movePosition(QTextCursor::NextCell); ui->textEdit->setTextCursor(course); setNumShow(); setChineseShow(); shiftabc(); } } else if ((33 == id) || (45 == id)) { if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } if (true == shiftFlag) { ABCShow(); shiftABC(); } else { setNumShow(); setChineseShow(); shiftabc(); } } else if (24 == id) { // enter button pressed // do nothing } else if ((50 == id) || (51 == id)) { // space button press if (firstInputFlag == true) { // 消除提示信息 ui->textEdit->setText(""); firstInputFlag = false; } if (true == chineseInputFlag) { // do nothing } else { ui->textEdit->insertPlainText(" "); } setNumShow(); setChineseShow(); shiftabc(); } } if (ui->textEdit->toPlainText() == "") { // 设置输入框提示信息 ui->textEdit->setTextColor(Qt::gray); ui->textEdit->setText(" 最多32个字符(全角字符:2)"); firstInputFlag = true; } else { ui->textEdit->setTextColor(Qt::black); } }
QVariant FLUtil::readDBSettingEntry( const QString & key ) { QVariant v = sqlSelect( "flsettings", "valor", "flkey = '" + key + "'" ); return v; }