function Update() { global $CCSLocales; global $DefaultDateFormat; $this->CmdExecution = true; $this->cp["user"] = new clsSQLParameter("expr959", ccsText, "", "", CCGEtUserLogin(), "", false, $this->ErrorBlock); $this->cp["penjelasan"] = new clsSQLParameter("ctrlpenjelasan", ccsText, "", "", $this->penjelasan->GetValue(true), "", false, $this->ErrorBlock); $this->cp["permasalahan"] = new clsSQLParameter("ctrlpermasalahan", ccsText, "", "", $this->permasalahan->GetValue(true), "", false, $this->ErrorBlock); $this->cp["kesimpulan"] = new clsSQLParameter("ctrlkesimpulan", ccsText, "", "", $this->kesimpulan->GetValue(true), "", false, $this->ErrorBlock); $this->cp["saran"] = new clsSQLParameter("ctrlsaran", ccsText, "", "", $this->saran->GetValue(true), "", false, $this->ErrorBlock); $this->cp["t_executive_summary_id"] = new clsSQLParameter("ctrlt_executive_summary_id", ccsInteger, "", "", $this->t_executive_summary_id->GetValue(true), 0, false, $this->ErrorBlock); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent); if (!is_null($this->cp["user"]->GetValue()) and !strlen($this->cp["user"]->GetText()) and !is_bool($this->cp["user"]->GetValue())) { $this->cp["user"]->SetValue(CCGEtUserLogin()); } if (!is_null($this->cp["penjelasan"]->GetValue()) and !strlen($this->cp["penjelasan"]->GetText()) and !is_bool($this->cp["penjelasan"]->GetValue())) { $this->cp["penjelasan"]->SetValue($this->penjelasan->GetValue(true)); } if (!is_null($this->cp["permasalahan"]->GetValue()) and !strlen($this->cp["permasalahan"]->GetText()) and !is_bool($this->cp["permasalahan"]->GetValue())) { $this->cp["permasalahan"]->SetValue($this->permasalahan->GetValue(true)); } if (!is_null($this->cp["kesimpulan"]->GetValue()) and !strlen($this->cp["kesimpulan"]->GetText()) and !is_bool($this->cp["kesimpulan"]->GetValue())) { $this->cp["kesimpulan"]->SetValue($this->kesimpulan->GetValue(true)); } if (!is_null($this->cp["saran"]->GetValue()) and !strlen($this->cp["saran"]->GetText()) and !is_bool($this->cp["saran"]->GetValue())) { $this->cp["saran"]->SetValue($this->saran->GetValue(true)); } if (!is_null($this->cp["t_executive_summary_id"]->GetValue()) and !strlen($this->cp["t_executive_summary_id"]->GetText()) and !is_bool($this->cp["t_executive_summary_id"]->GetValue())) { $this->cp["t_executive_summary_id"]->SetValue($this->t_executive_summary_id->GetValue(true)); } if (!strlen($this->cp["t_executive_summary_id"]->GetText()) and !is_bool($this->cp["t_executive_summary_id"]->GetValue(true))) { $this->cp["t_executive_summary_id"]->SetText(0); } $this->SQL = "UPDATE t_executive_summary SET \n" . "permasalahan='" . $this->SQLValue($this->cp["permasalahan"]->GetDBValue(), ccsText) . "', \n" . "penjelasan='" . $this->SQLValue($this->cp["penjelasan"]->GetDBValue(), ccsText) . "', \n" . "kesimpulan='" . $this->SQLValue($this->cp["kesimpulan"]->GetDBValue(), ccsText) . "', \n" . "saran='" . $this->SQLValue($this->cp["saran"]->GetDBValue(), ccsText) . "', \n" . "updated_date=sysdate,\n" . "updated_by='" . $this->SQLValue($this->cp["user"]->GetDBValue(), ccsText) . "' \n" . "WHERE \n" . "t_executive_summary_id = \n" . "" . $this->SQLValue($this->cp["t_executive_summary_id"]->GetDBValue(), ccsInteger) . ""; $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["doc_no"] = new clsSQLParameter("ctrldoc_no", ccsText, "", "", $this->doc_no->GetValue(true), "", false, $this->ErrorBlock); $this->cp["t_cust_acc_status_modif_id"] = new clsSQLParameter("ctrlt_cust_acc_status_modif_id", ccsInteger, "", "", $this->t_cust_acc_status_modif_id->GetValue(true), 0, false, $this->ErrorBlock); $this->cp["bap_employee_no_1"] = new clsSQLParameter("ctrlbap_employee_no_1", ccsText, "", "", $this->bap_employee_no_1->GetValue(true), "", false, $this->ErrorBlock); $this->cp["bap_employee_no_2"] = new clsSQLParameter("ctrlbap_employee_no_2", ccsText, "", "", $this->bap_employee_no_2->GetValue(true), "", false, $this->ErrorBlock); $this->cp["bap_employee_job_pos_1"] = new clsSQLParameter("ctrlbap_employee_job_pos_1", ccsText, "", "", $this->bap_employee_job_pos_1->GetValue(true), "", false, $this->ErrorBlock); $this->cp["bap_employee_job_pos_2"] = new clsSQLParameter("ctrlbap_employee_job_pos_2", ccsText, "", "", $this->bap_employee_job_pos_2->GetValue(true), "", false, $this->ErrorBlock); $this->cp["bap_employee_name_1"] = new clsSQLParameter("ctrlbap_employee_name_1", ccsText, "", "", $this->bap_employee_name_1->GetValue(true), "", false, $this->ErrorBlock); $this->cp["bap_employee_name_2"] = new clsSQLParameter("ctrlbap_employee_name_2", ccsText, "", "", $this->bap_employee_name_2->GetValue(true), "", false, $this->ErrorBlock); $this->cp["user"] = new clsSQLParameter("expr959", ccsText, "", "", CCGEtUserLogin(), "", false, $this->ErrorBlock); $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent); if (!is_null($this->cp["doc_no"]->GetValue()) and !strlen($this->cp["doc_no"]->GetText()) and !is_bool($this->cp["doc_no"]->GetValue())) { $this->cp["doc_no"]->SetValue($this->doc_no->GetValue(true)); } if (!is_null($this->cp["t_cust_acc_status_modif_id"]->GetValue()) and !strlen($this->cp["t_cust_acc_status_modif_id"]->GetText()) and !is_bool($this->cp["t_cust_acc_status_modif_id"]->GetValue())) { $this->cp["t_cust_acc_status_modif_id"]->SetValue($this->t_cust_acc_status_modif_id->GetValue(true)); } if (!strlen($this->cp["t_cust_acc_status_modif_id"]->GetText()) and !is_bool($this->cp["t_cust_acc_status_modif_id"]->GetValue(true))) { $this->cp["t_cust_acc_status_modif_id"]->SetText(0); } if (!is_null($this->cp["bap_employee_no_1"]->GetValue()) and !strlen($this->cp["bap_employee_no_1"]->GetText()) and !is_bool($this->cp["bap_employee_no_1"]->GetValue())) { $this->cp["bap_employee_no_1"]->SetValue($this->bap_employee_no_1->GetValue(true)); } if (!is_null($this->cp["bap_employee_no_2"]->GetValue()) and !strlen($this->cp["bap_employee_no_2"]->GetText()) and !is_bool($this->cp["bap_employee_no_2"]->GetValue())) { $this->cp["bap_employee_no_2"]->SetValue($this->bap_employee_no_2->GetValue(true)); } if (!is_null($this->cp["bap_employee_job_pos_1"]->GetValue()) and !strlen($this->cp["bap_employee_job_pos_1"]->GetText()) and !is_bool($this->cp["bap_employee_job_pos_1"]->GetValue())) { $this->cp["bap_employee_job_pos_1"]->SetValue($this->bap_employee_job_pos_1->GetValue(true)); } if (!is_null($this->cp["bap_employee_job_pos_2"]->GetValue()) and !strlen($this->cp["bap_employee_job_pos_2"]->GetText()) and !is_bool($this->cp["bap_employee_job_pos_2"]->GetValue())) { $this->cp["bap_employee_job_pos_2"]->SetValue($this->bap_employee_job_pos_2->GetValue(true)); } if (!is_null($this->cp["bap_employee_name_1"]->GetValue()) and !strlen($this->cp["bap_employee_name_1"]->GetText()) and !is_bool($this->cp["bap_employee_name_1"]->GetValue())) { $this->cp["bap_employee_name_1"]->SetValue($this->bap_employee_name_1->GetValue(true)); } if (!is_null($this->cp["bap_employee_name_2"]->GetValue()) and !strlen($this->cp["bap_employee_name_2"]->GetText()) and !is_bool($this->cp["bap_employee_name_2"]->GetValue())) { $this->cp["bap_employee_name_2"]->SetValue($this->bap_employee_name_2->GetValue(true)); } if (!is_null($this->cp["user"]->GetValue()) and !strlen($this->cp["user"]->GetText()) and !is_bool($this->cp["user"]->GetValue())) { $this->cp["user"]->SetValue(CCGEtUserLogin()); } $this->SQL = "UPDATE t_cust_acc_status_modif SET \n" . "doc_no='" . $this->SQLValue($this->cp["doc_no"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_no_1='" . $this->SQLValue($this->cp["bap_employee_no_1"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_no_2='" . $this->SQLValue($this->cp["bap_employee_no_2"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_job_pos_1='" . $this->SQLValue($this->cp["bap_employee_job_pos_1"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_job_pos_2='" . $this->SQLValue($this->cp["bap_employee_job_pos_2"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_name_1='" . $this->SQLValue($this->cp["bap_employee_name_1"]->GetDBValue(), ccsText) . "', \n" . "bap_employee_name_2='" . $this->SQLValue($this->cp["bap_employee_name_2"]->GetDBValue(), ccsText) . "', \n" . "updated_date=sysdate,\n" . "updated_by='" . $this->SQLValue($this->cp["user"]->GetDBValue(), ccsText) . "' \n" . "WHERE \n" . "t_cust_acc_status_modif_id = \n" . "" . $this->SQLValue($this->cp["t_cust_acc_status_modif_id"]->GetDBValue(), ccsInteger) . ""; $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); } }