echo "open data base,and select records/n";
$dmsDbInfo = CMSDbInfoConfig();
$infoPro = new CInfoProvider;
$infoPro->SetAdoConnectionPtr($dmsDbInfo);
//
$searchMd5 = "select ";
$searchMd5 .= "*";
$searchMd5 .= " from ";
$searchMd5 .= FUN2_POST_XML_MAP_TBL;
$searchMd5 .= " where ";
$searchMd5 .= "(";
$searchMd5 .= FUN2_PXM_MD5;
$searchMd5 .= " = '";
$searchMd5 .= $md5;
$searchMd5 .= "'";
$searchMd5 .= ")";
$searchMd5 .= "AND";
$searchMd5 .= "(";
$searchMd5 .= FUN2_PXM_STATE;
$searchMd5 .= " = ";
$searchMd5 .= FUN2_PXM_STATE_ENABLE_QUERY;
$searchMd5 .= ")";
if( FUN2_ERR_SUCCESS != $infoPro->Search($searchMd5) )
{
echo "DB failed/n";
$strRet.= FUN2_ERR_FAILED;
}
else
{
if( $infoPro->MoveFirst() )
{
$record = $infoPro->GetRecordsetPtr();
if( NULL != $record )
{
echo $record."=>md5-find it/n";
$strRet .=1;
}
else
{
$strRet.=FUN2_ERR_PARAM;
}
}
else
{
$strRet.= FUN2_ERR_FAILED;
}
}
//update records if you have known primary key
$sqlCommand = "UPDATE ";
$sqlCommand .= FUN2_UEVT_VEH_MAP_TABLE;
$sqlCommand .= " SET ";
$sqlCommand .= FUN2_UEV_STATUS;
$sqlCommand .= "='";
$sqlCommand .= $handleRes;
$sqlCommand .= "'";
$sqlCommand .= " where ";
$sqlCommand .= FUN2_UEV_VHC_ID;
$sqlCommand .= " IN (";
foreach($carIds AS $carId )
{
$sqlCommand .= "'";
$sqlCommand .= $carId;
$sqlCommand .= "',";
}
$sqlCommand = substr($sqlCommand,0,strlen($sqlCommand)-1);
$sqlCommand .= ")";
$sqlCommand .= " and ";
$sqlCommand .= FUN2_UEV_EVT;
$sqlCommand .= "='";
$sqlCommand .= $eventId;
$sqlCommand .= "'";
$sqlCommand .= " and ";
$sqlCommand .= FUN2_UEV_STATUS;
$sqlCommand .= "='";
$sqlCommand .= FUN2_UEV_STATUS_ACKNOWLEDGED;
$sqlCommand .= "'";
$cmsDbInfo = CMSDbInfoConfig();
$db = new CMysqlConnect;
$db->SetDbInfo($cmsDbInfo);
$ret = $db->Connent();
if(!$ret)
{
$strRet.=FUN2_ERR_FAILED;
goto Err;
}
$result = mysql_query($sqlCommand); if( FALSE == $result ) { $strRet.=FUN2_ERR_FAILED; goto Err; } else { $strRet.=FUN2_ERR_SUCCESS; }