本文整理汇总了PHP中SQLQBuilder::deleteRecord方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQBuilder::deleteRecord方法的具体用法?PHP SQLQBuilder::deleteRecord怎么用?PHP SQLQBuilder::deleteRecord使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLQBuilder
的用法示例。
在下文中一共展示了SQLQBuilder::deleteRecord方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: delEmpPic
function delEmpPic($arrList)
{
$tableName = 'HS_HR_EMP_PICTURE';
$arrFieldList[0] = 'EMP_NUMBER';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
}
示例2: delRepUserGroup
function delRepUserGroup($arrList)
{
$tableName = 'HS_HR_EMPREP_USERGROUP';
$arrFieldList1[0] = 'USERG_ID';
$arrFieldList1[1] = 'REP_CODE';
$sql_builder1 = new SQLQBuilder();
$sql_builder1->table_name = $tableName;
$sql_builder1->flg_delete = 'true';
$sql_builder1->arr_delete = $arrFieldList1;
$sqlDelString = $sql_builder1->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection1 = new DMLFunctions();
$message2 = $dbConnection1->executeQuery($sqlDelString);
//Calling the addData() function
}
示例3: delSalCurDet
function delSalCurDet($arrList)
{
$tableName = 'HS_PR_SALARY_CURRENCY_DETAIL';
$arrFieldList1[0] = 'SAL_GRD_CODE';
$arrFieldList1[1] = 'CURRENCY_ID';
$sql_builder1 = new SQLQBuilder();
$sql_builder1->table_name = $tableName;
$sql_builder1->flg_delete = 'true';
$sql_builder1->arr_delete = $arrFieldList1;
$sqlDelString = $sql_builder1->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection1 = new DMLFunctions();
$message2 = $dbConnection1->executeQuery($sqlDelString);
//Calling the addData() function
}
示例4: delJobTitEmpStat
function delJobTitEmpStat($arrList)
{
$tableName = 'HS_HR_JOBTIT_EMPSTAT';
$arrFieldList[0] = 'JOBTIT_CODE';
$arrFieldList[1] = 'ESTAT_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例5: delEmpBasSal
function delEmpBasSal($arrList)
{
$tableName = 'hs_hr_emp_basicsalary';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'SAL_GRD_CODE';
$arrFieldList[2] = 'CURRENCY_ID';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
}
示例6: delEducation
function delEducation($arrList)
{
$tableName = 'HS_HR_EDUCATION';
$arrFieldList[0] = 'EDU_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例7: deleteTimeEvent
public function deleteTimeEvent()
{
$tableName = self::TIME_EVENT_DB_TABLE_TIME_EVENT;
$arrFieldList[0] = self::TIME_EVENT_DB_FIELD_TIME_EVENT_ID;
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$arrList = array(array($this->getTimeEventId()));
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例8: delEmpLang
function delEmpLang($arrList)
{
$tableName = 'HS_HR_EMP_LANGUAGE';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'LANG_CODE';
$arrFieldList[2] = 'ELANG_TYPE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
}
示例9: delSalaryGrades
function delSalaryGrades($arrList)
{
$tableName = 'HS_PR_SALARY_GRADE';
$arrFieldList[0] = 'SAL_GRD_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例10: delLanguageInfo
function delLanguageInfo($arrList)
{
$tableName = 'HS_HR_LANGUAGE';
$arrFieldList[0] = 'LANG_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例11: delLocation
function delLocation($arrList)
{
$tableName = 'HS_HR_LOCATION';
$arrFieldList[0] = 'LOC_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
$dbConnection = new DMLFunctions();
$sqlQString1 = sprintf("SELECT * FROM `hs_hr_compstructtree` WHERE `loc_code` = '%s'", implode("' OR `loc_code` = '", $arrList[0]));
$message1 = $dbConnection->executeQuery($sqlQString1);
if (mysql_num_rows($message1) == 0) {
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return true;
}
}
示例12: delEmpMembership
function delEmpMembership($arrList)
{
$tableName = 'HS_HR_EMP_MEMBER_DETAIL';
$arrFieldList[0] = 'EMP_NUMBER';
$arrFieldList[1] = 'MEMBSHIP_CODE';
$arrFieldList[2] = 'MEMBTYPE_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
}
示例13: delete
/**
* Deletes holiday
*
* The object needs to be filled.
*
* @access public
*/
public function delete()
{
$sql_builder = new SQLQBuilder();
$arrFieldList[0] = self::HOLIDAYS_TABLE_HOLIDAY_ID;
$arrValueList[0] = array($this->getHolidayId());
$sql_builder->table_name = self::HOLIDAYS_TABLE;
$sql_builder->arr_delete = $arrFieldList;
$sql_builder->flg_delete = 'true';
$query = $sql_builder->deleteRecord($arrValueList);
//echo $query;
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);
}
示例14: delMembershipInfo
function delMembershipInfo($arrList)
{
$tableName = 'HS_HR_MEMBERSHIP';
$arrFieldList[0] = 'MEMBSHIP_CODE';
$sql_builder = new SQLQBuilder();
$sql_builder->table_name = $tableName;
$sql_builder->flg_delete = 'true';
$sql_builder->arr_delete = $arrFieldList;
$sqlQString = $sql_builder->deleteRecord($arrList);
//echo $sqlQString;
$dbConnection = new DMLFunctions();
$message2 = $dbConnection->executeQuery($sqlQString);
//Calling the addData() function
return $message2;
}
示例15: _deleteWorkshifts
private static function _deleteWorkshifts($ids)
{
$tableName = self::WORKSHIFT_TABLE;
$arrFieldList[0] = self::DB_FIELD_WORKSHIFT_ID;
$sqlBuilder = new SQLQBuilder();
$sqlBuilder->table_name = $tableName;
$sqlBuilder->flg_delete = 'true';
$sqlBuilder->arr_delete = $arrFieldList;
$arrList[] = $ids;
$sqlQString = $sqlBuilder->deleteRecord($arrList);
$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($sqlQString);
if ($result) {
return mysql_affected_rows();
} else {
throw new WorkshiftException("Error in SQL Query", WorkshiftException::ERROR_IN_DB_QUERY);
}
}