構成変更のためファイルを置き直し。

[kybernetes/Kybernetes.git] / base / data / accessor / LinkDataAccessor.cs

diff --git a/base/data/accessor/LinkDataAccessor.cs b/base/data/accessor/LinkDataAccessor.cs
new file mode 100644 (file)
index 0000000..c657e38
--- /dev/null
+++ b/base/data/accessor/LinkDataAccessor.cs
@@ -0,0 +1,81 @@
+using System.Collections.Generic;\r
+using com.andoutomo.kybernetes.data.connection;\r
+using System.Data.SQLite;\r
+using com.andoutomo.kybernetes.data.DAO;\r
+\r
+\r
+namespace com.andoutomo.kybernetes.data.accessor\r
+{\r
+    public class LinkDataAccessor\r
+    {\r
+        #region singleton\r
+        private static LinkDataAccessor _object;\r
+        private LinkDataAccessor() { }\r
+        public static LinkDataAccessor getObject\r
+        {\r
+            get\r
+            {\r
+                if (_object == null)\r
+                {\r
+                    _object = new LinkDataAccessor();\r
+                }\r
+                return _object;\r
+            }\r
+        }\r
+        #endregion\r
+\r
+        public bool addLink(string linkCmd, string BaseCmd)\r
+        {\r
+            List<object> paramList = new List<object>();\r
+            paramList.Add(linkCmd);\r
+            paramList.Add(BaseCmd);\r
+\r
+            return SettingDBConnection.Connection.updateData(CommandSqlDictionary.insertLink, paramList);\r
+        }\r
+        public bool removeLink(string linkCmd)\r
+        {\r
+            List<object> paramList = new List<object>();\r
+            paramList.Add(linkCmd);\r
+\r
+            return SettingDBConnection.Connection.updateData(CommandSqlDictionary.removeLink, paramList);\r
+            \r
+        }\r
+        public bool hasLink(string linkCmd)\r
+        {\r
+            List<object> paramList = new List<object>();\r
+            paramList.Add(linkCmd);\r
+            bool wkRetVal = false;\r
+            SettingDBConnection.Connection.selectData(CommandSqlDictionary.hasLink, paramList, \r
+                (SQLiteDataReader reader) => \r
+                {\r
+                    if (reader.HasRows)\r
+                    {\r
+                        wkRetVal = true;\r
+                    }\r
+                    else\r
+                    {\r
+                        wkRetVal = false;\r
+                    }\r
+                });\r
+            return wkRetVal;\r
+        }\r
+        /// <summary>\r
+        /// リンク(アライアス)を全件取得します。\r
+        /// </summary>\r
+        /// <returns></returns>\r
+        public List<SimpleDataBean> getAllLink()\r
+        {\r
+            List<SimpleDataBean> result = new List<SimpleDataBean>();\r
+            SettingDBConnection.Connection.selectData(CommandSqlDictionary.getAllLink, \r
+                (SQLiteDataReader reader) =>\r
+            {\r
+                while (reader.Read())\r
+                {\r
+                    result.Add(new SimpleDataBean(reader["LINK_COMMAND"].ToString(), reader["BASE_COMMAND"].ToString()));\r
+                }\r
+            });\r
+            return result;\r
+        }\r
+\r
+    }\r
+}\r