#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個文件信息