ｖ1.1.6.6

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

diff --git a/base/data/accessor/TaskDataAccessor.cs b/base/data/accessor/TaskDataAccessor.cs
index 3eef522..adf9359 100644 (file)
--- a/base/data/accessor/TaskDataAccessor.cs
+++ b/base/data/accessor/TaskDataAccessor.cs
@@ -120,7 +120,6 @@ namespace com.andoutomo.kybernetes.data.accessor
                     data.StartTime = new TimeComponent(reader["STARTTIME"].ToString());\r
                     data.EndTime = new TimeComponent(reader["ENDTIME"].ToString());\r
                     data.IsRepeat = Convert.ToInt32(reader["REPEATFLG"].ToString());\r
-                    data.HasComment = Convert.ToInt32(reader["HASCOMMENT"].ToString());\r
                     data.Project = reader["PROJECT"].ToString();\r
                     data.Tags = reader["TAGS"].ToString();\r
                     data.Comment = reader["COMMENT"].ToString();\r
@@ -236,6 +235,8 @@ namespace com.andoutomo.kybernetes.data.accessor
             parameters.Add(data.CategID);\r
             parameters.Add(data.Contents);\r
             parameters.Add(data.ForecastMin);\r
+            parameters.Add(data.Project);\r
+            parameters.Add(data.Tags);\r
 \r
             return TaskDBConnection.Connection.updateData(SqlDictionary.insertTask, parameters);\r
 \r
@@ -247,13 +248,14 @@ namespace com.andoutomo.kybernetes.data.accessor
         /// <returns></returns>\r
         public bool updateTask(TaskData data)\r
         {\r
-\r
             List<object> parameters = new List<object>();\r
             parameters.Add(data.DoDate.getDateString("yyyy-MM-dd"));\r
             parameters.Add(data.TimeArea.ToUpper());\r
             parameters.Add(data.CategID);\r
             parameters.Add(data.Contents);\r
             parameters.Add(data.ForecastMin);\r
+            parameters.Add(data.Project);\r
+            parameters.Add(data.Tags);\r
             parameters.Add(data.SortID);\r
 \r
             return TaskDBConnection.Connection.updateData(SqlDictionary.updateTask, parameters);\r
@@ -306,7 +308,7 @@ namespace com.andoutomo.kybernetes.data.accessor
                     {\r
                         reader.Read();\r
                         int dbVal = Convert.ToInt32(reader["REPEATFLG"].ToString());\r
-                        if (dbVal == 1)\r
+                        if (dbVal > 0)\r
                         {\r
                             retval = true;\r
 \r
@@ -325,7 +327,7 @@ namespace com.andoutomo.kybernetes.data.accessor
         /// <param name="id"></param>\r
         /// <param name="isRepeat"></param>\r
         /// <returns></returns>\r
-        public bool setRepeatTask(int id, bool isRepeat)\r
+        private bool setRepeatTask(int id, bool isRepeat)\r
         {\r
             List<object> parameters = new List<object>();\r
 \r
@@ -338,6 +340,24 @@ namespace com.andoutomo.kybernetes.data.accessor
 \r
         }\r
 \r
+        /// <summary>\r
+        /// 繰り返しの設定を行います(日付入り)\r
+        /// </summary>\r
+        /// <param name="id"></param>\r
+        /// <param name="dayAfter"></param>\r
+        /// <returns></returns>\r
+        public bool setRepeatTask(int id, int dayAfter)\r
+        {\r
+            List<object> parameters = new List<object>();\r
+\r
+            int settingData = dayAfter;\r
+\r
+            parameters.Add(settingData);\r
+            parameters.Add(id);\r
+\r
+            return TaskDBConnection.Connection.updateData(SqlDictionary.setRepeatTask, parameters);\r
+\r
+        }\r
 \r
         /// <summary>\r
         /// タスクを削除します。\r
@@ -611,5 +631,13 @@ namespace com.andoutomo.kybernetes.data.accessor
             List<object> paramList = new List<object>() { targetSortID };\r
             return TaskDBConnection.Connection.updateData(SqlDictionary.clearTags, paramList);\r
         }\r
+        /// <summary>\r
+        /// SQLiteの最適化コマンドを実行します。\r
+        /// </summary>\r
+        /// <returns></returns>\r
+        public bool rebuildDB()\r
+        {\r
+            return TaskDBConnection.Connection.maintainanceData();\r
+        }\r
     }\r
 }\r