18 #include <QStringList>

    29 

    30 void searchRltWrapper::combineSqlStr(const uint &cid,

    31                                      const columnMap* const RowData, 

    32                                      QStringList &sqlList)

    33 {

    34     columnMap::const_iterator it;

    35     QString insSqlstrCnlInfo = "insert into channelInfo( ";

    36     QString insSqlstrImg     = "insert into img( ";

    37     QString insSqlstrSrhRlt  = "insert into searchrlt( "; 

    38     QString escStr;

    39     QString condStr = " where channelId ='" + QString::number(cid) + "' ";

    40 

    41     bool FstOfStatementCnl = true;

    42     bool FstOfStatementImg = true;

    43 

    44     it = RowData->begin();

    45     while(it != RowData->end())

    46     {

    47         if(channelId == it.key()) 

    48         {

    49             if(false == FstOfStatementCnl)

    50             {

    51                 insSqlstrCnlInfo += ", ";                

    52             }

    53         

    54             if(false == FstOfStatementImg)

    55             {

    56                 insSqlstrImg += ", ";                

    57             } 

    58             

    59             insSqlstrCnlInfo += colNameView[it.key()];

    60             insSqlstrImg += colNameView[it.key()];

    61             insSqlstrSrhRlt += colNameView[it.key()];

    62             FstOfStatementCnl = false;

    63             FstOfStatementImg = false;

    64         }

    65         

    66         if( (channelName == it.key()) ||(shortDesc == it.key()) )

    67         {

    68             if(false == FstOfStatementCnl)

    69             {

    70                 insSqlstrCnlInfo += ", ";                

    71             }

    72             

    73             insSqlstrCnlInfo += colNameView[it.key()];

    74             FstOfStatementCnl = false;

    75         }

    76         

    77         if(imgUrl == it.key())

    78         {

    79             if(false == FstOfStatementImg)

    80             {

    81                 insSqlstrImg += ", ";                

    82             }

    83             

    84             insSqlstrImg += colNameView[it.key()];

    85             FstOfStatementImg = false;

    86         }

    87 

    88         ++it;

    89     }

    90     

    91     insSqlstrCnlInfo += ") values(";

    92     insSqlstrImg += ") values(";

    93     insSqlstrSrhRlt += ") values(";

    94     FstOfStatementCnl = true;

    95     FstOfStatementImg = true;

    96         

    97     it = RowData->begin();

    98     while(it != RowData->end())

    99     {

   100         //here for escape char,

   101         escStr = it.value();

   102         escStr.replace('\'', "\'\'");

   103 

   104         if(channelId == it.key()) 

   105         {

   106             if(false == FstOfStatementCnl)

   107             {

   108                 insSqlstrCnlInfo += ", ";                

   109             }

   110             

   111             if(false == FstOfStatementImg)

   112             {

   113                 insSqlstrImg += ", ";                

   114             }

   115             

   116             insSqlstrCnlInfo  = insSqlstrCnlInfo + "'"+ escStr+ "'";

   117             insSqlstrImg      = insSqlstrImg + "'"+ escStr+ "'";

   118             insSqlstrSrhRlt   = insSqlstrSrhRlt + "'"+ escStr+ "'";

   119             FstOfStatementCnl = false;

   120             FstOfStatementImg = false;

   121         }

   122         

   123         if( (channelName == it.key()) ||(shortDesc == it.key()) )

   124         {

   125             if(false == FstOfStatementCnl)

   126             {

   127                 insSqlstrCnlInfo += ", ";                

   128             }

   129         

   130             insSqlstrCnlInfo = insSqlstrCnlInfo + "'"+ escStr+ "'";

   131             FstOfStatementCnl = false;                

   132         }

   133 

   134         if(imgUrl == it.key())

   135         {

   136             if(false == FstOfStatementImg)

   137             {

   138                 insSqlstrImg += ", ";                

   139             }

   140         

   141             insSqlstrImg = insSqlstrImg + "'"+ escStr+ "'";

   142             FstOfStatementImg = false;                  

   143         }            

   144           

   145         ++it;

   146     

   147     }    

   148     

   149     insSqlstrImg += ") ";

   150     insSqlstrCnlInfo += ") ";

   151     insSqlstrSrhRlt += ") ";

   152     

   153     QString updSqlStrCnlInfo = "update channelInfo set ";

   154     QString updSqlStrCnlImg = "update img set ";

   155     //part two, create update string;

   156     FstOfStatementCnl = true;

   157     FstOfStatementImg = true;

   158     

   159     it = RowData->begin();

   160      

   161     while( it != RowData->end())

   162     {

   163             //here for escape char,

   164         escStr = it.value();

   165         escStr.replace('\'', "\'\'");

   166         if( (channelName == it.key()) ||(shortDesc == it.key()) )

   167         {

   168             if(false == FstOfStatementCnl)

   169             {

   170                 updSqlStrCnlInfo += ", ";

   171             }

   172             updSqlStrCnlInfo = updSqlStrCnlInfo + colNameView[it.key()] + "=" + "'" + escStr + "'";

   173             FstOfStatementCnl = false;

   174         }

   175         if(imgUrl == it.key())

   176         {

   177             updSqlStrCnlImg = updSqlStrCnlImg + colNameView[it.key()] + "=" + "'" + escStr + "'";

   178         }  

   179 

   180         ++it;

   181     }

   182     updSqlStrCnlInfo += condStr;

   183     updSqlStrCnlImg  += condStr;

   184     sqlList<<insSqlstrCnlInfo<<insSqlstrImg<<insSqlstrSrhRlt<<updSqlStrCnlInfo<<updSqlStrCnlImg ;

   185     

   186     return;

   187 }

   188 

   189 

   190 bool searchRltWrapper::addSearchRlt(const columnMap* const RowData, bool bOpt)

   191 {

   192     uint uCid = 0;

   193     QStringList sqlStrList;

   194     

   195     if( NULL == RowData )

   196     {

   197         return false;

   198     }

   199 

   200     if(RowData->isEmpty())

   201     {

   202         return false;

   203     }

   204     uCid = srhChannelId(RowData);

   205     

   206     if(0 == uCid)

   207     {

   208         return false;

   209     }

   210     

   211     combineSqlStr(uCid, RowData, sqlStrList);

   212     

   213     return m_pIRDB->handleRstFromSrhView(uCid, sqlStrList, bOpt)? false:true;

   214           

   215 }

   216 

   217 void searchRltWrapper::addSearchRltFinished()

   218 {

   219     m_pIRDB->closeIRDBConnection();

   220     return;

   221 }

   243     int logoType = 0;