当前位置: 首页>>代码示例>>PHP>>正文


PHP SQLQBuilder::deleteRecord方法代码示例

本文整理汇总了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
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:14,代码来源:EmpPhoto.php

示例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
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:15,代码来源:EmpRepUserGroups.php

示例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
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:15,代码来源:SalCurDet.php

示例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;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:16,代码来源:JobTitEmpStat.php

示例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
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:16,代码来源:EmpBasSalary.php

示例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;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:15,代码来源:Education.php

示例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;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:16,代码来源:TimeEvent.php

示例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
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:15,代码来源:EmpLang.php

示例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;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:15,代码来源:SalaryGrades.php

示例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;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:14,代码来源:LanguageInfo.php

示例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;
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:18,代码来源:Location.php

示例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
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:16,代码来源:EmpMembership.php

示例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);
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:20,代码来源:Holidays.php

示例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;
 }
开发者ID:googlecode-mirror,项目名称:pucit-orangehrm,代码行数:15,代码来源:MembershipInfo.php

示例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);
     }
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:18,代码来源:Workshift.php


注:本文中的SQLQBuilder::deleteRecord方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。