From 4b78404c20490a615459267426ce9e6737bf4485 Mon Sep 17 00:00:00 2001 From: wei <> Date: Fri, 14 Jul 2006 09:20:45 +0000 Subject: Moving files. --- demos/sqlmap/protected/pages/Sample/Home.page | 5 ++ .../sqlmap/protected/pages/Sample/ProductList.page | 9 +++ .../sqlmap/protected/pages/Sample/ProductList.php | 18 +++++ demos/sqlmap/protected/pages/Sample/crud1.page | 19 ++++++ demos/sqlmap/protected/pages/Sample/crud1.php | 21 ++++++ demos/sqlmap/protected/pages/Sample/crud2.page | 36 ++++++++++ demos/sqlmap/protected/pages/Sample/crud2.php | 79 ++++++++++++++++++++++ 7 files changed, 187 insertions(+) create mode 100644 demos/sqlmap/protected/pages/Sample/Home.page create mode 100644 demos/sqlmap/protected/pages/Sample/ProductList.page create mode 100644 demos/sqlmap/protected/pages/Sample/ProductList.php create mode 100644 demos/sqlmap/protected/pages/Sample/crud1.page create mode 100644 demos/sqlmap/protected/pages/Sample/crud1.php create mode 100644 demos/sqlmap/protected/pages/Sample/crud2.page create mode 100644 demos/sqlmap/protected/pages/Sample/crud2.php (limited to 'demos/sqlmap/protected/pages/Sample') diff --git a/demos/sqlmap/protected/pages/Sample/Home.page b/demos/sqlmap/protected/pages/Sample/Home.page new file mode 100644 index 00000000..6d059c7e --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/Home.page @@ -0,0 +1,5 @@ + \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/ProductList.page b/demos/sqlmap/protected/pages/Sample/ProductList.page new file mode 100644 index 00000000..904d411d --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/ProductList.page @@ -0,0 +1,9 @@ +

Database Examples

+ + +
+ Code: <%# $this->DataItem['productid'] %> + Category: <%# $this->DataItem['category'] %> +
+ + \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/ProductList.php b/demos/sqlmap/protected/pages/Sample/ProductList.php new file mode 100644 index 00000000..a35c40ea --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/ProductList.php @@ -0,0 +1,18 @@ +IsPostBack) + { + $sqlmap = $this->Application->Modules['petshop-sqlmap']; + $products = $sqlmap->queryForList('SelectAllProducts'); + $this->productList->setDataSource($products); + $this->productList->dataBind(); + } + } +} + +?> \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/crud1.page b/demos/sqlmap/protected/pages/Sample/crud1.page new file mode 100644 index 00000000..ce467ffa --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/crud1.page @@ -0,0 +1,19 @@ + + + + + Person + + + + + +

Person List

+ + + + + + \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/crud1.php b/demos/sqlmap/protected/pages/Sample/crud1.php new file mode 100644 index 00000000..40733dc9 --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/crud1.php @@ -0,0 +1,21 @@ +Application->Modules['person-sample']; + $this->personList->DataSource = $sqlmap->queryForList('SelectAll'); + $this->personList->dataBind(); + } + + public function onLoad($param) + { + if(!$this->IsPostBack) + $this->loadData(); + } +} + +?> \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/crud2.page b/demos/sqlmap/protected/pages/Sample/crud2.page new file mode 100644 index 00000000..4d34e873 --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/crud2.page @@ -0,0 +1,36 @@ + + + + + Person + + + + + +

Person List

+ + + + + + + + + + + + + \ No newline at end of file diff --git a/demos/sqlmap/protected/pages/Sample/crud2.php b/demos/sqlmap/protected/pages/Sample/crud2.php new file mode 100644 index 00000000..46fe3893 --- /dev/null +++ b/demos/sqlmap/protected/pages/Sample/crud2.php @@ -0,0 +1,79 @@ +Application->Modules['person-sample']; + } + + private function loadData() + { + $this->personList->DataSource = + $this->sqlmap()->queryForList('SelectAll'); + $this->personList->dataBind(); + } + + public function onLoad($param) + { + if(!$this->IsPostBack) + $this->loadData(); + } + + protected function editPerson($sender,$param) + { + $this->personList->EditItemIndex=$param->Item->ItemIndex; + $this->loadData(); + } + + protected function deletePerson($sender, $param) + { + $id = $this->getKey($sender, $param); + + $this->sqlmap()->update("Delete", $id); + $this->loadData(); + } + + protected function updatePerson($sender, $param) + { + $person = new Person(); + $person->FirstName = $this->getText($param, 0); + $person->LastName = $this->getText($param, 1); + $person->HeightInMeters = $this->getText($param, 2); + $person->WeightInKilograms = $this->getText($param, 3); + $person->ID = $this->getKey($sender, $param); + + $this->sqlmap()->update("Update", $person); + $this->refreshList($sender, $param); + } + + protected function addNewPerson($sender, $param) + { + $person = new Person; + $person->FirstName = "-- New Person --"; + $this->sqlmap()->insert("Insert", $person); + + $this->loadData();; + } + + protected function refreshList($sender, $param) + { + $this->personList->EditItemIndex=-1; + $this->loadData(); + } + + private function getText($param, $index) + { + $item = $param->Item; + return $item->Cells[$index]->Controls[0]->Text; + } + + private function getKey($sender, $param) + { + return $sender->DataKeys[$param->Item->DataSourceIndex]; + } +} + +?> \ No newline at end of file -- cgit v1.2.3