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);
}
