QT 智能家居系统

QT 智能家居系统

#include “sqlhelp.h“

#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include 

SqlHelp::SqlHelp（Qobject *parent） :
    Qobject（parent）
{
    StartIndex = 0;
    TempSql = ““;
    Sql = ““;
    RowsCount = 0;
    RowsCountAll = 0;
    PageCount = 0;
    PageCurrent = 1;
}

/*
 *函数名：GetTableId（）
 *输入参数：数据表名，数据表中ID字段名
 *返回值：表中最大的Id值
*/
QString SqlHelp::GetTableMaxId（const QString tableName const QString IdName）
{
    QSqlQuery query;
    QString MaxId = ““;
    query.exec（“SELECT MAX（“ + IdName + “） FROM “ + tableName + “;“）;
    while（query.next（））
        MaxId = query.value（0）.toString（）;
    return MaxId;
}

/*
 *函数名：GetTableColumnValue（）
 *功能：返回表中某一列的值
*/
QString SqlHelp::

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2018-10-14 03:10  SmartHome-Qt-master\
     文件          25  2018-10-14 03:10  SmartHome-Qt-master\.gitignore
     文件          55  2018-10-14 03:10  SmartHome-Qt-master\SmartHome.rc
     文件        1169  2018-10-14 03:10  SmartHome-Qt-master\SmartHomeV5.pro
     目录           0  2018-10-14 03:10  SmartHome-Qt-master\file\
     文件      348160  2018-10-14 03:10  SmartHome-Qt-master\file\SmartHome.db
     文件        2996  2018-10-14 03:10  SmartHome-Qt-master\file\SmartHome.sql
     目录           0  2018-10-14 03:10  SmartHome-Qt-master\file\sound\
     文件       17068  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM1.WAV
     文件      143396  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM10.WAV
     文件      202444  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM11.WAV
     文件      343978  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM12.WAV
     文件      327958  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM13.WAV
     文件      341428  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM14.WAV
     文件       59210  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM15.WAV
     文件       67144  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM16.WAV
     文件      121344  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM17.WAV
     文件       25364  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM18.WAV
     文件       14828  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM2.WAV
     文件       14444  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM3.WAV
     文件        1516  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM4.WAV
     文件        8550  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM5.WAV
     文件       42461  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM6.WAV
     文件       28558  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM7.WAV
     文件      209452  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM8.WAV
     文件       76151  2018-10-14 03:10  SmartHome-Qt-master\file\sound\ALARM9.WAV
     文件       27738  2018-10-14 03:10  SmartHome-Qt-master\file\sound\HOSTCONNECT.WAV
     文件      100044  2018-10-14 03:10  SmartHome-Qt-master\file\sound\HOSTDISCONNECT.WAV
     文件        2958  2018-10-14 03:10  SmartHome-Qt-master\image.qrc
     目录           0  2018-10-14 03:10  SmartHome-Qt-master\images\
     目录           0  2018-10-14 03:10  SmartHome-Qt-master\images\Icon\
............此处省略263个文件信息