Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php	(revision 20164)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php	(revision 20168)
@@ -68,5 +68,4 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
         $objDb = new SC_Helper_DB_Ex();
 
@@ -110,11 +109,11 @@
         // 編集前処理
         case 'pre_edit':
-            // 編集項目をDBより取得する。
-            $where = "holiday_id = ?";
-            $arrRet = $objQuery->select("title, month, day", "dtb_holiday", $where, array($_POST['holiday_id']));
+            // 編集項目を取得する。
+            $arrHolidayData = $this->lfGetHolidayDataByHolidayID($_POST['holiday_id']);
+
             // 入力項目にカテゴリ名を入力する。
-            $this->arrForm['title'] = $arrRet[0]['title'];
-            $this->arrForm['month'] = $arrRet[0]['month'];
-            $this->arrForm['day'] = $arrRet[0]['day'];
+            $this->arrForm['title'] = $arrHolidayData[0]['title'];
+            $this->arrForm['month'] = $arrHolidayData[0]['month'];
+            $this->arrForm['day'] = $arrHolidayData[0]['day'];
             // POSTデータを引き継ぐ
             $this->tpl_holiday_id = $_POST['holiday_id'];
@@ -134,17 +133,29 @@
         }
 
-        // 規格の読込
+        $this->arrHoliday = $this->lfGetHolidayList();
+    }
+
+    /**
+     * デストラクタ.
+     *
+     * @return void
+     */
+    function destroy() {
+        parent::destroy();
+    }
+
+    function lfGetHolidayDataByHolidayID($holiday_id) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $where = "holiday_id = ?";
+        return $objQuery->select("title, month, day", "dtb_holiday", $where, array($holiday_id));
+    }
+
+    function lfGetHolidayList() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
         $where = "del_flg <> 1";
         $objQuery->setOrder("rank DESC");
-        $this->arrHoliday = $objQuery->select("holiday_id, title, month, day", "dtb_holiday", $where);
-    }
-
-    /**
-     * デストラクタ.
-     *
-     * @return void
-     */
-    function destroy() {
-        parent::destroy();
+        return $objQuery->select("holiday_id, title, month, day", "dtb_holiday", $where);
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php	(revision 20166)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php	(revision 20168)
@@ -73,5 +73,4 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
 
         // 認証可否の判定
@@ -85,6 +84,5 @@
         $this->objFormParam->setParam($_POST);
 
-        $cnt = $objQuery->count("dtb_baseinfo");
-
+        $cnt = $this->lfGetBaseInfoCount();
         if ($cnt > 0) {
             $this->tpl_mode = "update";
@@ -116,6 +114,5 @@
             $arrCol = $this->objFormParam->getKeyList(); // キー名一覧を取得
             $col    = SC_Utils_Ex::sfGetCommaList($arrCol);
-            // DB値の取得
-            $arrRet = $objQuery->select($col, "dtb_baseinfo");
+            $arrRet = $this->lfGetBaseInfoData($col);
             $this->objFormParam->setParam($arrRet[0]);
         }
@@ -131,4 +128,26 @@
     function destroy() {
         parent::destroy();
+    }
+
+    /**
+     * 基本情報の登録数を取得する
+     *
+     * @return int
+     */
+    function lfGetBaseInfoCount() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->count("dtb_baseinfo");
+    }
+
+    /**
+     * 基本情報のデータを取得する
+     *
+     * @return array
+     */
+    function lfGetBaseInfoData($col) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->select($col, "dtb_baseinfo");
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php	(revision 20164)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php	(revision 20168)
@@ -90,5 +90,4 @@
      */
     function action() {
-        $objQuery =& SC_Query::getSingletonInstance();
 
         SC_Utils_Ex::sfIsSuccess(new SC_Session);
@@ -110,8 +109,5 @@
                 // 自動登録
                 case 'auto':
-                    $objQuery->begin();
-                    $objQuery->delete('mtb_zip');
-                    $this->insertMtbZip();
-                    $objQuery->commit();
+                    $this->lfAutoCommit();
                     break;
                 // 手動登録
@@ -126,5 +122,5 @@
             // 手動削除
             case 'delete':
-                $objQuery->delete('mtb_zip');
+                $this->lfDeleteZip();
 
                 // 進捗・完了画面を表示しない
@@ -145,4 +141,19 @@
     function destroy() {
         parent::destroy();
+    }
+
+    function lfAutoCommit() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $objQuery->begin();
+        $objQuery->delete('mtb_zip');
+        $this->insertMtbZip();
+        $objQuery->commit();
+    }
+
+    function lfDeleteZip() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $objQuery->delete('mtb_zip');
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php	(revision 20164)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php	(revision 20168)
@@ -68,5 +68,4 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
         $objDb = new SC_Helper_DB_Ex();
 
@@ -106,10 +105,10 @@
         // 編集前処理
         case 'pre_edit':
-            // 編集項目をDBより取得する。
-            $where = "kiyaku_id = ?";
-            $arrRet = $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($_POST['kiyaku_id']));
+            // 編集項目を取得する。
+            $arrKiyakuData = $this->lfGetKiyakuDataByKiyakuID($_POST['kiyaku_id']);
+
             // 入力項目にカテゴリ名を入力する。
-            $this->arrForm['kiyaku_title'] = $arrRet[0]['kiyaku_title'];
-            $this->arrForm['kiyaku_text'] = $arrRet[0]['kiyaku_text'];
+            $this->arrForm['kiyaku_title'] = $arrKiyakuData[0]['kiyaku_title'];
+            $this->arrForm['kiyaku_text'] = $arrKiyakuData[0]['kiyaku_text'];
             // POSTデータを引き継ぐ
             $this->tpl_kiyaku_id = $_POST['kiyaku_id'];
@@ -129,8 +128,5 @@
         }
 
-        // 規格の読込
-        $where = "del_flg <> 1";
-        $objQuery->setOrder("rank DESC");
-        $this->arrKiyaku = $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where);
+        $this->arrKiyaku = $this->lfGetKiyakuList();
     }
 
@@ -158,4 +154,19 @@
         $ret = $objQuery->insert("dtb_kiyaku", $sqlval);
         return $ret;
+    }
+
+    function lfGetKiyakuDataByKiyakuID($kiyaku_id) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $where = "kiyaku_id = ?";
+        return $objQuery->select("kiyaku_text, kiyaku_title", "dtb_kiyaku", $where, array($kiyaku_id));
+    }
+
+    function lfGetKiyakuList() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $where = "del_flg <> 1";
+        $objQuery->setOrder("rank DESC");
+        return $objQuery->select("kiyaku_title, kiyaku_text, kiyaku_id", "dtb_kiyaku", $where);
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php	(revision 20166)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php	(revision 20168)
@@ -80,10 +80,9 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
 
         // 認証可否の判定
         SC_Utils_Ex::sfIsSuccess($objSess);
 
-        $cnt = $objQuery->count("dtb_baseinfo");
+        $cnt = $this->lfGetBaseInfoCount();
 
         if ($cnt > 0) {
@@ -123,6 +122,6 @@
         } else {
             $arrCol = $this->lfGetCol();
-            $col	= SC_Utils_Ex::sfGetCommaList($arrCol);
-            $arrRet = $objQuery->select($col, "dtb_baseinfo");
+            $col    = SC_Utils_Ex::sfGetCommaList($arrCol);
+            $arrRet = $this->lfGetBaseInfoData($col);
             $this->arrForm = $arrRet[0];
 
@@ -140,4 +139,26 @@
     function destroy() {
         parent::destroy();
+    }
+
+    /**
+     * 基本情報の登録数を取得する
+     *
+     * @return int
+     */
+    function lfGetBaseInfoCount() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->count("dtb_baseinfo");
+    }
+
+    /**
+     * 基本情報のデータを取得する
+     *
+     * @return array
+     */
+    function lfGetBaseInfoData($col) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->select($col, "dtb_baseinfo");
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php	(revision 20164)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php	(revision 20168)
@@ -67,5 +67,5 @@
      */
     function action() {
-        $objQuery =& SC_Query::getSingletonInstance();
+
         $objSess = new SC_Session();
         $masterData = new SC_DB_MasterData_Ex();
@@ -81,6 +81,5 @@
 
             if ( SC_Utils_Ex::sfCheckNumLength( $_POST['template_id']) ){
-                $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
-                $result = $objQuery->getAll($sql, array($_POST['template_id']) );
+                $result = $this->lfGetMailTemplateByTemplateID($_POST['template_id']);
                 if ( $result ){
                     $this->arrForm = $result[0];
@@ -103,5 +102,5 @@
                 } else {
                     // 正常
-                    $this->lfRegist($objQuery, $this->arrForm);
+                    $this->lfRegist($this->arrForm);
 
                     // 完了メッセージ
@@ -125,5 +124,13 @@
     }
 
-    function lfRegist(&$objQuery, $data ){
+    function lfGetMailTemplateByTemplateID($template_id) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
+        return $objQuery->getAll($sql, array($template_id) );
+    }
+
+    function lfRegist($data ){
+        $objQuery =& SC_Query::getSingletonInstance();
 
         $data['creator_id'] = $_SESSION['member_id'];
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php	(revision 20164)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php	(revision 20168)
@@ -71,5 +71,4 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
         $objDb = new SC_Helper_DB_Ex();
 
@@ -95,10 +94,21 @@
         }
 
-        // 配送業者一覧の取得
+        $this->arrDelivList = $this->lfGetDelivList();
+    }
+
+    /**
+     * 配送業者一覧の取得
+     *
+     * @return array
+     */
+    function lfGetDelivList() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
         $col = "deliv_id, name, service_name";
         $where = "del_flg = 0";
         $table = "dtb_deliv";
         $objQuery->setOrder("rank DESC");
-        $this->arrDelivList = $objQuery->select($col, $table, $where);
+
+        return $objQuery->select($col, $table, $where);
     }
 
Index: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php	(revision 20166)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php	(revision 20168)
@@ -76,5 +76,4 @@
     function action() {
         $objSess = new SC_Session();
-        $objQuery =& SC_Query::getSingletonInstance();
 
         // 認証可否の判定
@@ -88,5 +87,5 @@
         $this->objFormParam->setParam($_POST);
 
-        $cnt = $objQuery->count("dtb_baseinfo");
+        $cnt = $this->lfGetBaseInfoCount();
 
         if ($cnt > 0) {
@@ -119,6 +118,5 @@
             $arrCol = $this->objFormParam->getKeyList(); // キー名一覧を取得
             $col    = SC_Utils_Ex::sfGetCommaList($arrCol);
-            // DB値の取得
-            $arrRet = $objQuery->select($col, "dtb_baseinfo");
+            $arrRet = $this->lfGetBaseInfoData($col);
             $this->objFormParam->setParam($arrRet[0]);
         }
@@ -134,4 +132,26 @@
     function destroy() {
         parent::destroy();
+    }
+
+    /**
+     * 基本情報の登録数を取得する
+     *
+     * @return int
+     */
+    function lfGetBaseInfoCount() {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->count("dtb_baseinfo");
+    }
+
+    /**
+     * 基本情報のデータを取得する
+     *
+     * @return array
+     */
+    function lfGetBaseInfoData($col) {
+        $objQuery =& SC_Query::getSingletonInstance();
+
+        return $objQuery->select($col, "dtb_baseinfo");
     }
 
