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;
}
