base/data/accessor/CategoryDataAccessor.cs

   1 using System;\r
   2 using System.Collections.Generic;\r
   3 using System.Data.SQLite;\r
   4 using com.andoutomo.kybernetes.data.DAO;\r
   5 using com.andoutomo.kybernetes.data.connection;\r
   6 \r
   7 \r
   8 namespace com.andoutomo.kybernetes.data.accessor\r
   9 {\r
  10     public class CategoryDataAccessor\r
  11     {\r
  12         public static CategoryDataAccessor getObject\r
  13         {\r
  14             get\r
  15             {\r
  16                 if (accessor == null)\r
  17                 {\r
  18                     accessor = new CategoryDataAccessor();\r
  19                 }\r
  20                 return accessor;\r
  21             }\r
  22         }\r
  23 \r
  24         private static CategoryDataAccessor accessor;\r
  25         private CategoryDataAccessor()\r
  26         {\r
  27             \r
  28         }\r
  29 \r
  30         /// <summary>\r
  31         /// DBテーブル"MST_CATEGORY"から、呼び出すクラス名を取得する\r
  32         /// </summary>\r
  33         /// <param name="commandStr">呼び出したコマンド(引数は別)</param>\r
  34         /// <returns>コマンドデータ</returns>\r
  35         public CategoryData getCategoryFromName(string categName)\r
  36         {\r
  37             CategoryData result = null;\r
  38             List<object> list = new List<object>();\r
  39             list.Add(categName);\r
  40             TaskDBConnection.Connection.selectData(SqlDictionary.getCategoryFromCategName, list,\r
  41             (SQLiteDataReader reader) =>\r
  42             {\r
  43                 if (reader.HasRows != false)\r
  44                 {\r
  45                     result = new CategoryData();\r
  46                     reader.Read();\r
  47                     result.CategId = Convert.ToInt32(reader["CategID"].ToString());\r
  48                     result.BGColor = Convert.ToInt32(reader["BGCOLOR"].ToString());\r
  49                     result.FRColor = Convert.ToInt32(reader["FRCOLOR"].ToString());\r
  50                 }\r
  51             });\r
  52             return result;\r
  53         }\r
  54 \r
  55         public CategoryData getCategoryFromID(int id)\r
  56         {\r
  57             CategoryData result = null;\r
  58             List<object> list = new List<object>();\r
  59             list.Add(id);\r
  60             TaskDBConnection.Connection.selectData(SqlDictionary.getCategoryFromCategId, list,\r
  61             (SQLiteDataReader reader) =>\r
  62             {\r
  63                 if (reader.HasRows != false)\r
  64                 {\r
  65                     result = new CategoryData();\r
  66                     reader.Read();\r
  67                     result.CategId = Convert.ToInt32(reader["CategID"].ToString());\r
  68                     result.Category = reader["Category"].ToString();\r
  69                     result.BGColor = Convert.ToInt32(reader["BGCOLOR"].ToString());\r
  70                     result.FRColor = Convert.ToInt32(reader["FRCOLOR"].ToString());\r
  71                 }\r
  72             });\r
  73             return result;\r
  74         }\r
  75 \r
  76         /// <summary>\r
  77         /// 全カテゴリを取得します。\r
  78         /// </summary>\r
  79         /// <returns></returns>\r
  80         public List<CategoryData> getAllCategory()\r
  81         {\r
  82             List<CategoryData> result = new List<CategoryData>();\r
  83             TaskDBConnection.Connection.selectData(SqlDictionary.getALLCategory, \r
  84                 (SQLiteDataReader reader) =>\r
  85                 {\r
  86                     while (reader.Read())\r
  87                     {\r
  88                         CategoryData wkResult = new CategoryData();\r
  89                         wkResult.CategId = Convert.ToInt32(reader["CategID"].ToString());\r
  90                         wkResult.Category = reader["Category"].ToString();\r
  91                         wkResult.BGColor = Convert.ToInt32(reader["BGCOLOR"].ToString());\r
  92                         wkResult.FRColor = Convert.ToInt32(reader["FRCOLOR"].ToString());\r
  93                         result.Add(wkResult);\r
  94                     }\r
  95                 });\r
  96             return result;\r
  97         }\r
  98     }\r
  99 }\r