ｖ1.1.6.6

[kybernetes/Kybernetes.git] / base / data / connection / SqlDictionary.resx

diff --git a/base/data/connection/SqlDictionary.resx b/base/data/connection/SqlDictionary.resx
index ba513a0..6174491 100644 (file)
--- a/base/data/connection/SqlDictionary.resx
+++ b/base/data/connection/SqlDictionary.resx
@@ -118,7 +118,7 @@
     <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>\r
   </resheader>\r
   <data name="getAllList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  ,  PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>全タスクを表示します。</comment>\r
   </data>\r
   <data name="getCategoryFromCategName" xml:space="preserve">\r
@@ -126,7 +126,7 @@
     <comment>カテゴリ名からIDを逆引きします。</comment>\r
   </data>\r
   <data name="getDailyList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT , PROJECT ,TAGS ,COMMENT FROM VW_TASKS_SORT WHERE DATE (DODATE) = DATE (? ) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  ,  PROJECT ,TAGS ,COMMENT FROM VW_TASKS_SORT WHERE DATE (DODATE) = DATE (? ) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>指定された日付のタスクを取得します。</comment>\r
   </data>\r
   <data name="getMaxIDofTask" xml:space="preserve">\r
@@ -134,15 +134,15 @@
     <comment>タスクIDの最大値+1を求めます。</comment>\r
   </data>\r
   <data name="getRemainList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT, PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT WHERE ENDTIME IS NULL ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT WHERE ENDTIME IS NULL ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>残り全タスクを表示します。</comment>\r
   </data>\r
   <data name="getTodayList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT, PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  , TBL_SETTING S WHERE DATE (DODATE) = DATE (S.TODAY) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  , TBL_SETTING S WHERE DATE (DODATE) = DATE (S.TODAY) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>今日のタスクを取得します。</comment>\r
   </data>\r
   <data name="insertTask" xml:space="preserve">\r
-    <value>insert into tbl_tasks(TASKID,SORTID,DODATE,TIMEAREA,CATEGID,CONTENTS,FORCASTMIN,STARTTIME,ENDTIME) values(?,?,date(?),?,?,?,?,null,null)</value>\r
+    <value>insert into tbl_tasks(TASKID,SORTID,DODATE,TIMEAREA,CATEGID,CONTENTS,FORCASTMIN,STARTTIME,ENDTIME,PROJECT,TAGS) values(?,?,date(?),?,?,?,?,null,null,?,?)</value>\r
     <comment>タスクを追加します。</comment>\r
   </data>\r
   <data name="getToday" xml:space="preserve">\r
@@ -158,7 +158,7 @@
     <comment>IDを元にタスクを抽出します。</comment>\r
   </data>\r
   <data name="updateTask" xml:space="preserve">\r
-    <value>update tbl_tasks set DODATE=date(?),TIMEAREA=?,CATEGID=?,CONTENTS=?,FORCASTMIN=? WHERE SORTID=?</value>\r
+    <value>update tbl_tasks set DODATE=date(?),TIMEAREA=?,CATEGID=?,CONTENTS=?,FORCASTMIN=?,PROJECT=?,TAGS=? WHERE SORTID=?</value>\r
     <comment>タスク内容を変更します。</comment>\r
   </data>\r
   <data name="updateToday" xml:space="preserve">\r
@@ -214,7 +214,7 @@
     <comment>時間帯を追加します。</comment>\r
   </data>\r
   <data name="getPwdList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT, TBL_SETTING S  WHERE\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT, TBL_SETTING S  WHERE\r
   DATE (DODATE) = DATE (S.TODAY) \r
   AND ENDTIME IS NULL \r
   AND STARTTIME IS NOT NULL ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
@@ -265,7 +265,7 @@
     <comment>ソート番号全体を調整します。既に終了した過去分タスクはマイナス扱いとします。(こうすることで、新規発番されるタスクは過去分のソートIDの影響を受けなくなります。マイナス扱いなら最大値にはならないですからね。)</comment>\r
   </data>\r
   <data name="searchTasks" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  where CONTENTS LIKE ? OR Category LIKE ? OR PROJECT LIKE ? OR TAGS LIKE ? ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  ,  PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  where CONTENTS LIKE ? OR Category LIKE ? OR PROJECT LIKE ? OR TAGS LIKE ? ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>与えられたキーワードをコンテンツに持つタスクを検索します。</comment>\r
   </data>\r
   <data name="clearMetaComment" xml:space="preserve">\r
@@ -297,7 +297,7 @@
     <comment>その日全体についてコメントを追加します。</comment>\r
   </data>\r
   <data name="getGoingList" xml:space="preserve">\r
-    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , HASCOMMENT, PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  , TBL_SETTING S WHERE DATE (DODATE) &gt;= DATE (S.TODAY) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
+    <value>SELECT  TASKID  , SORTID  , DODATE  , TIMEAREA  , CATEGORY  , CONTENTS  , FORCASTMIN  , STARTTIME  , ENDTIME  , BGCOLOR  , FRCOLOR  , REPEATFLG  , PROJECT , TAGS ,COMMENT FROM VW_TASKS_SORT  , TBL_SETTING S WHERE DATE (DODATE) &gt;= DATE (S.TODAY) ORDER BY DATESORT,DODATE,STARTNULLSORT,STARTTIMESORT,ENDTIMESORT,TIMEAREA,SORTID</value>\r
     <comment>今後(本日以降)のタスクを表示します。</comment>\r
   </data>\r
   <data name="getDefaultTimeArea" xml:space="preserve">\r