public function indexAction() { $VTs = new clsSystem(); //先初始化 $VTs->initialization(); try { //-----------BI開始------------ //執行查詢 $strSQL = "select * from account"; $data = $VTs->QueryData($strSQL); //debug,印出資料用 $VTs->debug($data); //日期轉換 $date = date("Y-m-d"); $changeDate = $VTs->DateTime("ADyyyyMMdd_RCyyyMMdd", $date); $this->viewContnet['pageContent'] = $changeDate; //-----------BI結束------------ } catch (Exception $error) { //依據Controller, Action補上對應位置, $error->getMessage()為固定部份 $VTs->WriteLog("IndexController", "indexAction", $error->getMessage()); } //關閉資料庫連線 $VTs->DBClose(); //釋放 $VTs = null; return new ViewModel($this->viewContnet); }
public function indexAction() { $VTs = new clsSystem(); //先初始化 $VTs->initialization(); //-----------BI開始------------ //執行查詢 $strSQL = "select * from account"; $data = $VTs->QueryData($strSQL); //資料轉換 $data = $VTs->Data2Array($data); //debug,印出資料用 $VTs->debug($data); //日期轉換 $date = date("Y-m-d"); $changeDate = $VTs->DateTime("ADyyyyMMdd_RCyyyMMdd", $date); $this->viewContnet['pageContent'] = $changeDate; //-----------BI結束------------ //關閉資料庫連線 $VTs->DBClose(); //釋放 $VTs = null; return new ViewModel($this->viewContnet); }
public function DBinsertAction() { $VTs = new clsSystem(); //先初始化 $VTs->initialization(); //-----------BI開始------------ $type = $_POST["unit1"]; $type = "typeunit"; switch ($type) { case "typeunit": $strSQL = "INSERT INTO `el_type_unit` ( `unit1`, `unit2`, `typeid_a`) VALUES ('t1', 't2', '2');"; $VTs->ExecuteNonQuery($strSQL); //$strSQL = "SELECT @@IDENTITY;"; $data = $VTs->NewInsertID(); $VTs->debug($data); break; } //-----------BI結束------------ //關閉資料庫連線 $VTs->DBClose(); //釋放 $VTs = null; return new ViewModel($this->viewContnet); }