PHP CCBuildUpdate函數代碼示例

//.........這裏部分代碼省略.........
     if (!is_null($this->cp["object_address_name"]->GetValue()) and !strlen($this->cp["object_address_name"]->GetText()) and !is_bool($this->cp["object_address_name"]->GetValue())) {
         $this->cp["object_address_name"]->SetValue($this->object_address_name->GetValue(true));
     }
     if (!is_null($this->cp["p_bphtb_legal_doc_type_id"]->GetValue()) and !strlen($this->cp["p_bphtb_legal_doc_type_id"]->GetText()) and !is_bool($this->cp["p_bphtb_legal_doc_type_id"]->GetValue())) {
         $this->cp["p_bphtb_legal_doc_type_id"]->SetValue($this->p_bphtb_legal_doc_type_id->GetValue(true));
     }
     if (!is_null($this->cp["npop"]->GetValue()) and !strlen($this->cp["npop"]->GetText()) and !is_bool($this->cp["npop"]->GetValue())) {
         $this->cp["npop"]->SetValue($this->npop->GetValue(true));
     }
     if (!is_null($this->cp["npop_tkp"]->GetValue()) and !strlen($this->cp["npop_tkp"]->GetText()) and !is_bool($this->cp["npop_tkp"]->GetValue())) {
         $this->cp["npop_tkp"]->SetValue($this->npop_tkp->GetValue(true));
     }
     if (!is_null($this->cp["npop_kp"]->GetValue()) and !strlen($this->cp["npop_kp"]->GetText()) and !is_bool($this->cp["npop_kp"]->GetValue())) {
         $this->cp["npop_kp"]->SetValue($this->npop_kp->GetValue(true));
     }
     if (!is_null($this->cp["bphtb_amt"]->GetValue()) and !strlen($this->cp["bphtb_amt"]->GetText()) and !is_bool($this->cp["bphtb_amt"]->GetValue())) {
         $this->cp["bphtb_amt"]->SetValue($this->bphtb_amt->GetValue(true));
     }
     if (!is_null($this->cp["bphtb_amt_final"]->GetValue()) and !strlen($this->cp["bphtb_amt_final"]->GetText()) and !is_bool($this->cp["bphtb_amt_final"]->GetValue())) {
         $this->cp["bphtb_amt_final"]->SetValue($this->bphtb_amt_final->GetValue(true));
     }
     if (!is_null($this->cp["bphtb_discount"]->GetValue()) and !strlen($this->cp["bphtb_discount"]->GetText()) and !is_bool($this->cp["bphtb_discount"]->GetValue())) {
         $this->cp["bphtb_discount"]->SetValue($this->bphtb_discount->GetValue(true));
     }
     if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
         $this->cp["description"]->SetValue($this->description->GetValue(true));
     }
     if (!is_null($this->cp["market_price"]->GetValue()) and !strlen($this->cp["market_price"]->GetText()) and !is_bool($this->cp["market_price"]->GetValue())) {
         $this->cp["market_price"]->SetValue($this->market_price->GetValue(true));
     }
     if (!is_null($this->cp["mobile_phone_no"]->GetValue()) and !strlen($this->cp["mobile_phone_no"]->GetText()) and !is_bool($this->cp["mobile_phone_no"]->GetValue())) {
         $this->cp["mobile_phone_no"]->SetValue($this->mobile_phone_no->GetValue(true));
     }
     if (!is_null($this->cp["wp_p_region_id_kec"]->GetValue()) and !strlen($this->cp["wp_p_region_id_kec"]->GetText()) and !is_bool($this->cp["wp_p_region_id_kec"]->GetValue())) {
         $this->cp["wp_p_region_id_kec"]->SetValue($this->wp_p_region_id_kec->GetValue(true));
     }
     if (!is_null($this->cp["object_p_region_id_kel"]->GetValue()) and !strlen($this->cp["object_p_region_id_kel"]->GetText()) and !is_bool($this->cp["object_p_region_id_kel"]->GetValue())) {
         $this->cp["object_p_region_id_kel"]->SetValue($this->object_p_region_id_kel->GetValue(true));
     }
     if (!is_null($this->cp["jenis_harga_bphtb"]->GetValue()) and !strlen($this->cp["jenis_harga_bphtb"]->GetText()) and !is_bool($this->cp["jenis_harga_bphtb"]->GetValue())) {
         $this->cp["jenis_harga_bphtb"]->SetValue($this->jenis_harga_bphtb->GetValue(true));
     }
     if (!is_null($this->cp["jenis_harga_bphtb"]->GetValue()) and !strlen($this->cp["jenis_harga_bphtb"]->GetText()) and !is_bool($this->cp["jenis_harga_bphtb"]->GetValue())) {
         $this->cp["jenis_harga_bphtb"]->SetValue($this->jenis_harga_bphtb->GetValue(true));
     }
     if (!is_null($this->cp["bphtb_legal_doc_description"]->GetValue()) and !strlen($this->cp["bphtb_legal_doc_description"]->GetText()) and !is_bool($this->cp["bphtb_legal_doc_description"]->GetValue())) {
         $this->cp["bphtb_legal_doc_description"]->SetValue($this->bphtb_legal_doc_description->GetValue(true));
     }
     if (!is_null($this->cp["add_disc_percent"]->GetValue()) and !strlen($this->cp["add_disc_percent"]->GetText()) and !is_bool($this->cp["add_disc_percent"]->GetValue())) {
         $this->cp["add_disc_percent"]->SetValue($this->add_disc_percent->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $wp->Criterion[2] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("2"), $this->ToSQL($wp->GetDBValue("2"), ccsFloat), false);
     $wp->Criterion[3] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("3"), $this->ToSQL($wp->GetDBValue("3"), ccsFloat), false);
     $Where = $wp->opAND(false, $wp->opAND(false, $wp->Criterion[1], $wp->Criterion[2]), $wp->Criterion[3]);
     $this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->UpdateFields["wp_p_region_id"]["Value"] = $this->cp["wp_p_region_id"]->GetDBValue(true);
     $this->UpdateFields["wp_p_region_id_kel"]["Value"] = $this->cp["wp_p_region_id_kel"]->GetDBValue(true);
     $this->UpdateFields["wp_name"]["Value"] = $this->cp["wp_name"]->GetDBValue(true);
     $this->UpdateFields["wp_address_name"]["Value"] = $this->cp["wp_address_name"]->GetDBValue(true);
     $this->UpdateFields["npwp"]["Value"] = $this->cp["npwp"]->GetDBValue(true);
     $this->UpdateFields["object_p_region_id_kec"]["Value"] = $this->cp["object_p_region_id_kec"]->GetDBValue(true);
     $this->UpdateFields["object_p_region_id"]["Value"] = $this->cp["object_p_region_id"]->GetDBValue(true);
     $this->UpdateFields["land_area"]["Value"] = $this->cp["land_area"]->GetDBValue(true);
     $this->UpdateFields["land_price_per_m"]["Value"] = $this->cp["land_price_per_m"]->GetDBValue(true);
     $this->UpdateFields["land_total_price"]["Value"] = $this->cp["land_total_price"]->GetDBValue(true);
     $this->UpdateFields["building_area"]["Value"] = $this->cp["building_area"]->GetDBValue(true);
     $this->UpdateFields["building_price_per_m"]["Value"] = $this->cp["building_price_per_m"]->GetDBValue(true);
     $this->UpdateFields["building_total_price"]["Value"] = $this->cp["building_total_price"]->GetDBValue(true);
     $this->UpdateFields["wp_rt"]["Value"] = $this->cp["wp_rt"]->GetDBValue(true);
     $this->UpdateFields["wp_rw"]["Value"] = $this->cp["wp_rw"]->GetDBValue(true);
     $this->UpdateFields["object_rt"]["Value"] = $this->cp["object_rt"]->GetDBValue(true);
     $this->UpdateFields["object_rw"]["Value"] = $this->cp["object_rw"]->GetDBValue(true);
     $this->UpdateFields["njop_pbb"]["Value"] = $this->cp["njop_pbb"]->GetDBValue(true);
     $this->UpdateFields["object_address_name"]["Value"] = $this->cp["object_address_name"]->GetDBValue(true);
     $this->UpdateFields["p_bphtb_legal_doc_type_id"]["Value"] = $this->cp["p_bphtb_legal_doc_type_id"]->GetDBValue(true);
     $this->UpdateFields["npop"]["Value"] = $this->cp["npop"]->GetDBValue(true);
     $this->UpdateFields["npop_tkp"]["Value"] = $this->cp["npop_tkp"]->GetDBValue(true);
     $this->UpdateFields["npop_kp"]["Value"] = $this->cp["npop_kp"]->GetDBValue(true);
     $this->UpdateFields["bphtb_amt"]["Value"] = $this->cp["bphtb_amt"]->GetDBValue(true);
     $this->UpdateFields["bphtb_amt_final"]["Value"] = $this->cp["bphtb_amt_final"]->GetDBValue(true);
     $this->UpdateFields["bphtb_discount"]["Value"] = $this->cp["bphtb_discount"]->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->cp["description"]->GetDBValue(true);
     $this->UpdateFields["market_price"]["Value"] = $this->cp["market_price"]->GetDBValue(true);
     $this->UpdateFields["mobile_phone_no"]["Value"] = $this->cp["mobile_phone_no"]->GetDBValue(true);
     $this->UpdateFields["wp_p_region_id_kec"]["Value"] = $this->cp["wp_p_region_id_kec"]->GetDBValue(true);
     $this->UpdateFields["object_p_region_id_kel"]["Value"] = $this->cp["object_p_region_id_kel"]->GetDBValue(true);
     $this->UpdateFields["jenis_harga_bphtb"]["Value"] = $this->cp["jenis_harga_bphtb"]->GetDBValue(true);
     $this->UpdateFields["jenis_harga_bphtb"]["Value"] = $this->cp["jenis_harga_bphtb"]->GetDBValue(true);
     $this->UpdateFields["bphtb_legal_doc_description"]["Value"] = $this->cp["bphtb_legal_doc_description"]->GetDBValue(true);
     $this->UpdateFields["add_disc_percent"]["Value"] = $this->cp["add_disc_percent"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("t_bphtb_registration", $this->UpdateFields, $this);
     $this->SQL .= strlen($Where) ? " WHERE " . $Where : $Where;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["name"]["Value"] = $this->name->GetDBValue(true);
     $this->UpdateFields["taxid"]["Value"] = $this->taxid->GetDBValue(true);
     $this->UpdateFields["website"]["Value"] = $this->website->GetDBValue(true);
     $this->UpdateFields["city"]["Value"] = $this->city->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["address"]["Value"] = $this->address->GetDBValue(true);
     $this->UpdateFields["assigned_to"]["Value"] = $this->assigned_to->GetDBValue(true);
     $this->UpdateFields["customertype_id"]["Value"] = $this->customertype_id->GetDBValue(true);
     $this->UpdateFields["shortname"]["Value"] = $this->shortname->GetDBValue(true);
     $this->UpdateFields["budgetdate"]["Value"] = $this->budgetdate->GetDBValue(true);
     $this->UpdateFields["assigned_to"]["Value"] = $this->assigned_to_user->GetDBValue(true);
     $this->UpdateFields["businesspartner"]["Value"] = $this->businesspartner->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["username"]["Value"] = $this->username->GetDBValue(true);
     $this->UpdateFields["password"]["Value"] = $this->password->GetDBValue(true);
     $this->UpdateFields["fullname"]["Value"] = $this->fullname->GetDBValue(true);
     $this->UpdateFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->UpdateFields["jobposition"]["Value"] = $this->jobposition->GetDBValue(true);
     $this->UpdateFields["phone"]["Value"] = $this->phone->GetDBValue(true);
     $this->UpdateFields["created_userid"]["Value"] = $this->created_userid->GetDBValue(true);
     $this->UpdateFields["modified_userid"]["Value"] = $this->modified_userid->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->guid->GetDBValue(true);
     $this->UpdateFields["personal_id"]["Value"] = $this->personal_id->GetDBValue(true);
     $this->UpdateFields["email"]["Value"] = $this->email->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["id_manufacturer"]["Value"] = $this->manufacturer->GetDBValue(true);
     $this->UpdateFields["suite_code"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->UpdateFields["suite_long_description"]["Value"] = $this->suite_long_description->GetDBValue(true);
     $this->UpdateFields["id_suite_status"]["Value"] = $this->id_suite_status->GetDBValue(true);
     $this->UpdateFields["suite_description"]["Value"] = $this->suite_description->GetDBValue(true);
     $this->UpdateFields["legacy_expire_date"]["Value"] = $this->legacy_expire_date->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_product_suites", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["clinic_id"]["Value"] = $this->clinic_id->GetDBValue(true);
     $this->UpdateFields["result"]["Value"] = $this->result1->GetDBValue(true);
     $this->UpdateFields["conclusion"]["Value"] = $this->conclusion->GetDBValue(true);
     $this->UpdateFields["sup_dept_id"]["Value"] = $this->sup_dept_id->GetDBValue(true);
     $this->UpdateFields["statistical_conclusion_id"]["Value"] = $this->stat_conclusion->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $SelectWhere = $this->Where;
     $this->Where = "title_id=" . $this->ToSQL($this->CachedColumns["title_id"], ccsInteger);
     $this->UpdateFields["title"]["Value"] = $this->title->GetDBValue(true);
     $this->SQL = CCBuildUpdate("title", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
     $this->Where = $SelectWhere;
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->SQL = CCBuildUpdate("users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["consultant_i_c"]["Value"] = $this->consultant_i_c->GetDBValue(true);
     $this->UpdateFields["l_m_p"]["Value"] = $this->l_m_p->GetDBValue(true);
     $this->UpdateFields["clinic_id"]["Value"] = $this->clinic_id->GetDBValue(true);
     $this->UpdateFields["primary_diagnosis"]["Value"] = $this->primary_diagnosis->GetDBValue(true);
     $this->UpdateFields["clinical_notes"]["Value"] = $this->clinical_notes->GetDBValue(true);
     $this->UpdateFields["date"]["Value"] = $this->date->GetDBValue(true);
     $this->UpdateFields["sup_dept_id"]["Value"] = $this->sup_dept_id->GetDBValue(true);
     $this->UpdateFields["amount_to_pay"]["Value"] = $this->amount_to_pay->GetDBValue(true);
     $this->UpdateFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->UpdateFields["patient_id"]["Value"] = $this->patient_id->GetDBValue(true);
     $this->UpdateFields["status_id"]["Value"] = $this->status_id->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["restitusi_amt"] = new clsSQLParameter("ctrlrestitusi_amt", ccsFloat, "", "", $this->restitusi_amt->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["alasan"] = new clsSQLParameter("ctrlalasan", ccsText, "", "", $this->alasan->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlt_bphtb_restitusi_id", ccsFloat, "", "", $this->t_bphtb_restitusi_id->GetValue(true), "", false);
     if (!$wp->AllParamsSet()) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $wp->AddParameter("2", "urlt_bphtb_registration_id", ccsFloat, "", "", CCGetFromGet("t_bphtb_registration_id", NULL), "", false);
     if (!$wp->AllParamsSet()) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $wp->AddParameter("3", "urlt_bphtb_registration_id", ccsFloat, "", "", CCGetFromGet("t_bphtb_registration_id", NULL), "", false);
     if (!$wp->AllParamsSet()) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     if (!is_null($this->cp["restitusi_amt"]->GetValue()) and !strlen($this->cp["restitusi_amt"]->GetText()) and !is_bool($this->cp["restitusi_amt"]->GetValue())) {
         $this->cp["restitusi_amt"]->SetValue($this->restitusi_amt->GetValue(true));
     }
     if (!is_null($this->cp["alasan"]->GetValue()) and !strlen($this->cp["alasan"]->GetText()) and !is_bool($this->cp["alasan"]->GetValue())) {
         $this->cp["alasan"]->SetValue($this->alasan->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "t_bphtb_restitusi_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $wp->Criterion[2] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("2"), $this->ToSQL($wp->GetDBValue("2"), ccsFloat), false);
     $wp->Criterion[3] = $wp->Operation(opEqual, "t_bphtb_registration_id", $wp->GetDBValue("3"), $this->ToSQL($wp->GetDBValue("3"), ccsFloat), false);
     $Where = $wp->opAND(false, $wp->opAND(false, $wp->Criterion[1], $wp->Criterion[2]), $wp->Criterion[3]);
     $this->UpdateFields["restitusi_amt"]["Value"] = $this->cp["restitusi_amt"]->GetDBValue(true);
     $this->UpdateFields["alasan"]["Value"] = $this->cp["alasan"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("t_bphtb_restitusi", $this->UpdateFields, $this);
     $this->SQL .= strlen($Where) ? " WHERE " . $Where : $Where;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["id_suite"]["Value"] = $this->suite_code->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["channel_sku"]["Value"] = $this->channel_sku->GetDBValue(true);
     $this->UpdateFields["msrp_price"]["Value"] = $this->msrp_price->GetDBValue(true);
     $this->UpdateFields["product_content"]["Value"] = $this->product_content->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->detaileddescription->GetDBValue(true);
     $this->UpdateFields["id_product_type"]["Value"] = $this->id_product_type->GetDBValue(true);
     $this->UpdateFields["id_product_tag"]["Value"] = $this->id_product_tag->GetDBValue(true);
     $this->UpdateFields["id_licensed_by"]["Value"] = $this->id_licensed_by->GetDBValue(true);
     $this->UpdateFields["licensed_amount"]["Value"] = $this->licensed_amount->GetDBValue(true);
     $this->UpdateFields["range_min"]["Value"] = $this->range_min->GetDBValue(true);
     $this->UpdateFields["range_max"]["Value"] = $this->range_max->GetDBValue(true);
     $this->UpdateFields["id_license_sector"]["Value"] = $this->id_license_sector->GetDBValue(true);
     $this->UpdateFields["id_license_granttype"]["Value"] = $this->id_license_granttype->GetDBValue(true);
     $this->UpdateFields["id_license_type"]["Value"] = $this->id_license_type->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_products", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["appointment_date"]["Value"] = $this->appointment_date->GetDBValue(true);
     $this->UpdateFields["appointment_time"]["Value"] = $this->appointment_time->GetDBValue(true);
     $this->UpdateFields["user_id"]["Value"] = $this->doctor_name->GetDBValue(true);
     $this->SQL = CCBuildUpdate("result", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["last_name"]["Value"] = $this->last_name->GetDBValue(true);
     $this->UpdateFields["middle_name"]["Value"] = $this->middle_name->GetDBValue(true);
     $this->UpdateFields["group_id"]["Value"] = $this->group_id->GetDBValue(true);
     $this->UpdateFields["department_id"]["Value"] = $this->department_id->GetDBValue(true);
     $this->UpdateFields["title_id"]["Value"] = $this->title_id->GetDBValue(true);
     $this->UpdateFields["first_name"]["Value"] = $this->first_name->GetDBValue(true);
     $this->UpdateFields["user_status_id"]["Value"] = $this->Hidden1->GetDBValue(true);
     $this->UpdateFields["user_id"]["Value"] = $this->user_id->GetDBValue(true);
     $this->SQL = CCBuildUpdate("users", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["holidays"]["Value"] = $this->holidays->GetDBValue(true);
     $this->UpdateFields["created_iduser"]["Value"] = $this->created_iduser->GetDBValue(true);
     $this->UpdateFields["modified_iduser"]["Value"] = $this->modified_iduser->GetDBValue(true);
     $this->UpdateFields["guid"]["Value"] = $this->hidguid->GetDBValue(true);
     $this->UpdateFields["message"]["Value"] = $this->message->GetDBValue(true);
     $this->UpdateFields["day_position"]["Value"] = $this->day_position->GetDBValue(true);
     $this->UpdateFields["day_month"]["Value"] = $this->hiddaymonth->GetDBValue(true);
     $this->SQL = CCBuildUpdate("alm_customers_contacts_holidays", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $this->cp["created_by"] = new clsSQLParameter("ctrlcreated_by", ccsText, "", "", $this->created_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_by"] = new clsSQLParameter("ctrlupdated_by", ccsText, "", "", $this->updated_by->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["creation_date"] = new clsSQLParameter("ctrlcreation_date", ccsText, "", "", $this->creation_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["updated_date"] = new clsSQLParameter("ctrlupdated_date", ccsText, "", "", $this->updated_date->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["latitude"] = new clsSQLParameter("ctrllatitude", ccsFloat, "", "", $this->latitude->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["longitude"] = new clsSQLParameter("ctrllongitude", ccsFloat, "", "", $this->longitude->GetValue(true), NULL, false, $this->ErrorBlock);
     $this->cp["file_name"] = new clsSQLParameter("ctrlfile_name", ccsText, "", "", $this->file_name->GetValue(true), NULL, false, $this->ErrorBlock);
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlpic_id", ccsFloat, "", "", $this->pic_id->GetValue(true), "", false);
     if (!$wp->AllParamsSet()) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     if (!is_null($this->cp["created_by"]->GetValue()) and !strlen($this->cp["created_by"]->GetText()) and !is_bool($this->cp["created_by"]->GetValue())) {
         $this->cp["created_by"]->SetValue($this->created_by->GetValue(true));
     }
     if (!is_null($this->cp["updated_by"]->GetValue()) and !strlen($this->cp["updated_by"]->GetText()) and !is_bool($this->cp["updated_by"]->GetValue())) {
         $this->cp["updated_by"]->SetValue($this->updated_by->GetValue(true));
     }
     if (!is_null($this->cp["creation_date"]->GetValue()) and !strlen($this->cp["creation_date"]->GetText()) and !is_bool($this->cp["creation_date"]->GetValue())) {
         $this->cp["creation_date"]->SetValue($this->creation_date->GetValue(true));
     }
     if (!is_null($this->cp["updated_date"]->GetValue()) and !strlen($this->cp["updated_date"]->GetText()) and !is_bool($this->cp["updated_date"]->GetValue())) {
         $this->cp["updated_date"]->SetValue($this->updated_date->GetValue(true));
     }
     if (!is_null($this->cp["latitude"]->GetValue()) and !strlen($this->cp["latitude"]->GetText()) and !is_bool($this->cp["latitude"]->GetValue())) {
         $this->cp["latitude"]->SetValue($this->latitude->GetValue(true));
     }
     if (!is_null($this->cp["longitude"]->GetValue()) and !strlen($this->cp["longitude"]->GetText()) and !is_bool($this->cp["longitude"]->GetValue())) {
         $this->cp["longitude"]->SetValue($this->longitude->GetValue(true));
     }
     if (!is_null($this->cp["file_name"]->GetValue()) and !strlen($this->cp["file_name"]->GetText()) and !is_bool($this->cp["file_name"]->GetValue())) {
         $this->cp["file_name"]->SetValue($this->file_name->GetValue(true));
     }
     $wp->Criterion[1] = $wp->Operation(opEqual, "pic_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $Where = $wp->Criterion[1];
     $this->UpdateFields["created_by"]["Value"] = $this->cp["created_by"]->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->cp["updated_by"]->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->cp["creation_date"]->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->cp["updated_date"]->GetDBValue(true);
     $this->UpdateFields["latitude"]["Value"] = $this->cp["latitude"]->GetDBValue(true);
     $this->UpdateFields["longitude"]["Value"] = $this->cp["longitude"]->GetDBValue(true);
     $this->UpdateFields["file_name"]["Value"] = $this->cp["file_name"]->GetDBValue(true);
     $this->SQL = CCBuildUpdate("tb_pic_gis", $this->UpdateFields, $this);
     $this->SQL .= strlen($Where) ? " WHERE " . $Where : $Where;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }

 function Update()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
     $this->UpdateFields["code"]["Value"] = $this->code->GetDBValue(true);
     $this->UpdateFields["client_name"]["Value"] = $this->client_name->GetDBValue(true);
     $this->UpdateFields["description"]["Value"] = $this->description->GetDBValue(true);
     $this->UpdateFields["creation_date"]["Value"] = $this->creation_date->GetDBValue(true);
     $this->UpdateFields["updated_date"]["Value"] = $this->updated_date->GetDBValue(true);
     $this->UpdateFields["updated_by"]["Value"] = $this->updated_by->GetDBValue(true);
     $this->UpdateFields["created_by"]["Value"] = $this->created_by->GetDBValue(true);
     $this->SQL = CCBuildUpdate("p_client", $this->UpdateFields, $this);
     $this->SQL .= strlen($this->Where) ? " WHERE " . $this->Where : $this->Where;
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
     }
 }