base/data/accessor/LinkDataAccessor.cs

   1 using System.Collections.Generic;\r
   2 using com.andoutomo.kybernetes.data.connection;\r
   3 using System.Data.SQLite;\r
   4 using com.andoutomo.kybernetes.data.DAO;\r
   5 \r
   6 \r
   7 namespace com.andoutomo.kybernetes.data.accessor\r
   8 {\r
   9     public class LinkDataAccessor\r
  10     {\r
  11         #region singleton\r
  12         private static LinkDataAccessor _object;\r
  13         private LinkDataAccessor() { }\r
  14         public static LinkDataAccessor getObject\r
  15         {\r
  16             get\r
  17             {\r
  18                 if (_object == null)\r
  19                 {\r
  20                     _object = new LinkDataAccessor();\r
  21                 }\r
  22                 return _object;\r
  23             }\r
  24         }\r
  25         #endregion\r
  26 \r
  27         public bool addLink(string linkCmd, string BaseCmd)\r
  28         {\r
  29             List<object> paramList = new List<object>();\r
  30             paramList.Add(linkCmd);\r
  31             paramList.Add(BaseCmd);\r
  32 \r
  33             return SettingDBConnection.Connection.updateData(CommandSqlDictionary.insertLink, paramList);\r
  34         }\r
  35         public bool removeLink(string linkCmd)\r
  36         {\r
  37             List<object> paramList = new List<object>();\r
  38             paramList.Add(linkCmd);\r
  39 \r
  40             return SettingDBConnection.Connection.updateData(CommandSqlDictionary.removeLink, paramList);\r
  41             \r
  42         }\r
  43         public bool hasLink(string linkCmd)\r
  44         {\r
  45             List<object> paramList = new List<object>();\r
  46             paramList.Add(linkCmd);\r
  47             bool wkRetVal = false;\r
  48             SettingDBConnection.Connection.selectData(CommandSqlDictionary.hasLink, paramList, \r
  49                 (SQLiteDataReader reader) => \r
  50                 {\r
  51                     if (reader.HasRows)\r
  52                     {\r
  53                         wkRetVal = true;\r
  54                     }\r
  55                     else\r
  56                     {\r
  57                         wkRetVal = false;\r
  58                     }\r
  59                 });\r
  60             return wkRetVal;\r
  61         }\r
  62         /// <summary>\r
  63         /// リンク(アライアス)を全件取得します。\r
  64         /// </summary>\r
  65         /// <returns></returns>\r
  66         public List<SimpleDataBean> getAllLink()\r
  67         {\r
  68             List<SimpleDataBean> result = new List<SimpleDataBean>();\r
  69             SettingDBConnection.Connection.selectData(CommandSqlDictionary.getAllLink, \r
  70                 (SQLiteDataReader reader) =>\r
  71             {\r
  72                 while (reader.Read())\r
  73                 {\r
  74                     result.Add(new SimpleDataBean(reader["LINK_COMMAND"].ToString(), reader["BASE_COMMAND"].ToString()));\r
  75                 }\r
  76             });\r
  77             return result;\r
  78         }\r
  79 \r
  80     }\r
  81 }\r