历史库中按时间顺序排列

QString insert_sql_theory;

        QString date = "2015-03-18 00:00:00";

        QDateTime dt = QDateTime::fromString(date,"yyyy-MM-dd hh:mm:ss");

        for (i=0; i<30; i++)                //30天按照顺序排序存入历史数据库

        {

            QDateTime dt1 = dt.addDays(i+1);

            QString date1 = dt1.toString("yyyy-MM-dd hh:mm:ss");

            QDateTime dt2 = dt1.addDays(1);

            QString date2 = dt2.toString("yyyy-MM-dd hh:mm:ss");

            insert_sql_theory =QString("update hisdb.hisdb.YC_RS_1441 set CUR_006='%1' where (OCCUR_TIME>='%2') AND (OCCUR_TIME<'%3')").arg(sumall[i]).arg(date1).arg(date2);

            insert_sql_fact   =QString("update hisdb.hisdb.YC_RS_1441 set CUR_007='%1' where (OCCUR_TIME>='%2') AND (OCCUR_TIME<'%3')").arg(sumallPower[i].arg(date1).arg(date2);

            insertValueIntoHisDB(insert_sql_theory);

            insertValueIntoHisDB(insert_sql_fact);

        }