sqlite-add

int Administrative_affaires_dao::add(QSharedPointer<AdministrativeAffaires> obj)
{
    QSqlQuery query(database_);
    // 先查询是否有一条一样的记录(根据时间)
    quint32 udsn = 0;
    QString cmd = QString("SELECT count(*) FROM %1 WHERE GenerateTime=:generateTime")
                      .arg(QString::fromStdString(kTableAdminAffaires));
    bool prepare_flag = query.prepare(cmd);
    if (!prepare_flag) return -1;
    query.bindValue(":generateTime",obj->generateTime());
    query.exec();
    if(query.next())
    {
        udsn = query.value(0).toInt();
    }
    
    cmd = QString("INSERT INTO %1").arg(QString::fromStdString(kTableAdminAffaires));
    prepare_flag = query.prepare(
        cmd + " (Udsn,GenerateTime,StationId,OperatorId,WatchId," +
              "AffairsType,TransAmount,ActualAmount,ReasonType," +
              "FaultDeviceId,Payment,Note,BatchNum,Flag) " +
              "VALUES (:Udsn,:GenerateTime,:StationId,:OperatorId,:WatchId," +
              ":AffairsType,:TransAmount,:ActualAmount,:ReasonType," +
              ":FaultDeviceId,:Payment,:Note,:batch,:flag);");
    qDebug() << query.executedQuery();
    if(!prepare_flag) return -1;

    query.bindValue(":Udsn", udsn);
    query.bindValue(":GenerateTime",obj->generateTime());
    query.bindValue(":StationId",obj->stationId());
    query.bindValue(":OperatorId",obj->operatorId());
    query.bindValue(":WatchId",obj->watchId());
    query.bindValue(":AffairsType",obj->affairsType());
    query.bindValue(":TransAmount",obj->transAmount());
    query.bindValue(":ActualAmount",obj->actualAmount());
    query.bindValue(":ReasonType",obj->reasonType());
    query.bindValue(":FaultDeviceId",obj->faultDeviceId());
    query.bindValue(":Payment",obj->payment());
    query.bindValue(":Note",obj->note());
    query.bindValue(":batch",obj->batchNum());
    query.bindValue(":flag", 0);
    bool ret = query.exec();
    return ret ? 0 : -2;
}