+++ /dev/null
-<?xml version="1.0" encoding="utf-8"?>\r
-<root>\r
- <!-- \r
- Microsoft ResX Schema \r
- \r
- Version 2.0\r
- \r
- The primary goals of this format is to allow a simple XML format \r
- that is mostly human readable. The generation and parsing of the \r
- various data types are done through the TypeConverter classes \r
- associated with the data types.\r
- \r
- Example:\r
- \r
- ... ado.net/XML headers & schema ...\r
- <resheader name="resmimetype">text/microsoft-resx</resheader>\r
- <resheader name="version">2.0</resheader>\r
- <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>\r
- <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>\r
- <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>\r
- <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>\r
- <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">\r
- <value>[base64 mime encoded serialized .NET Framework object]</value>\r
- </data>\r
- <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">\r
- <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>\r
- <comment>This is a comment</comment>\r
- </data>\r
- \r
- There are any number of "resheader" rows that contain simple \r
- name/value pairs.\r
- \r
- Each data row contains a name, and value. The row also contains a \r
- type or mimetype. Type corresponds to a .NET class that support \r
- text/value conversion through the TypeConverter architecture. \r
- Classes that don't support this are serialized and stored with the \r
- mimetype set.\r
- \r
- The mimetype is used for serialized objects, and tells the \r
- ResXResourceReader how to depersist the object. This is currently not \r
- extensible. For a given mimetype the value must be set accordingly:\r
- \r
- Note - application/x-microsoft.net.object.binary.base64 is the format \r
- that the ResXResourceWriter will generate, however the reader can \r
- read any of the formats listed below.\r
- \r
- mimetype: application/x-microsoft.net.object.binary.base64\r
- value : The object must be serialized with \r
- : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter\r
- : and then encoded with base64 encoding.\r
- \r
- mimetype: application/x-microsoft.net.object.soap.base64\r
- value : The object must be serialized with \r
- : System.Runtime.Serialization.Formatters.Soap.SoapFormatter\r
- : and then encoded with base64 encoding.\r
-\r
- mimetype: application/x-microsoft.net.object.bytearray.base64\r
- value : The object must be serialized into a byte array \r
- : using a System.ComponentModel.TypeConverter\r
- : and then encoded with base64 encoding.\r
- -->\r
- <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">\r
- <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />\r
- <xsd:element name="root" msdata:IsDataSet="true">\r
- <xsd:complexType>\r
- <xsd:choice maxOccurs="unbounded">\r
- <xsd:element name="metadata">\r
- <xsd:complexType>\r
- <xsd:sequence>\r
- <xsd:element name="value" type="xsd:string" minOccurs="0" />\r
- </xsd:sequence>\r
- <xsd:attribute name="name" use="required" type="xsd:string" />\r
- <xsd:attribute name="type" type="xsd:string" />\r
- <xsd:attribute name="mimetype" type="xsd:string" />\r
- <xsd:attribute ref="xml:space" />\r
- </xsd:complexType>\r
- </xsd:element>\r
- <xsd:element name="assembly">\r
- <xsd:complexType>\r
- <xsd:attribute name="alias" type="xsd:string" />\r
- <xsd:attribute name="name" type="xsd:string" />\r
- </xsd:complexType>\r
- </xsd:element>\r
- <xsd:element name="data">\r
- <xsd:complexType>\r
- <xsd:sequence>\r
- <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />\r
- <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />\r
- </xsd:sequence>\r
- <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />\r
- <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />\r
- <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />\r
- <xsd:attribute ref="xml:space" />\r
- </xsd:complexType>\r
- </xsd:element>\r
- <xsd:element name="resheader">\r
- <xsd:complexType>\r
- <xsd:sequence>\r
- <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />\r
- </xsd:sequence>\r
- <xsd:attribute name="name" type="xsd:string" use="required" />\r
- </xsd:complexType>\r
- </xsd:element>\r
- </xsd:choice>\r
- </xsd:complexType>\r
- </xsd:element>\r
- </xsd:schema>\r
- <resheader name="resmimetype">\r
- <value>text/microsoft-resx</value>\r
- </resheader>\r
- <resheader name="version">\r
- <value>2.0</value>\r
- </resheader>\r
- <resheader name="reader">\r
- <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>\r
- </resheader>\r
- <resheader name="writer">\r
- <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 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
- <value>SELECT CategID,BGColor,FRColor FROM tbl_category WHERE Category = ?</value>\r
- <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 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
- <value>SELECT ((MAX(TASKID)) + 1) AS NEXTID FROM TBL_TASKS</value>\r
- <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 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 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
- <comment>タスクを追加します。</comment>\r
- </data>\r
- <data name="getToday" xml:space="preserve">\r
- <value>SELECT TODAY FROM TBL_SETTING</value>\r
- <comment>今日の日付を取ってきます</comment>\r
- </data>\r
- <data name="getALLCategory" xml:space="preserve">\r
- <value>SELECT CategID,Category,BGColor,FRColor FROM tbl_category ORDER BY CategID</value>\r
- <comment>全カテゴリを抽出します。</comment>\r
- </data>\r
- <data name="getOneTask" xml:space="preserve">\r
- <value>SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,T.CATEGID,C.CATEGORY,T.CONTENTS,T.FORCASTMIN,T.STARTTIME,T.ENDTIME,T.REPEATFLG, T.PROJECT , T.TAGS FROM TBL_TASKS T LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID where T.SORTID = ?</value>\r
- <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
- <comment>タスク内容を変更します。</comment>\r
- </data>\r
- <data name="updateToday" xml:space="preserve">\r
- <value>UPDATE TBL_SETTING SET TODAY = ? </value>\r
- <comment>日付を変更します。</comment>\r
- </data>\r
- <data name="getCategoryFromCategId" xml:space="preserve">\r
- <value>SELECT CategID,Category,BGColor,FRColor FROM tbl_category WHERE CategID = ?</value>\r
- <comment>カテゴリIDからカテゴリを検索します。</comment>\r
- </data>\r
- <data name="startTask" xml:space="preserve">\r
- <value>UPDATE TBL_TASKS SET STARTTIME=? WHERE SORTID=?</value>\r
- <comment>タスクの開始時間を更新します。</comment>\r
- </data>\r
- <data name="endTask" xml:space="preserve">\r
- <value>UPDATE TBL_TASKS SET ENDTIME=? WHERE SORTID=?</value>\r
- <comment>タスクの終了時間を更新します。</comment>\r
- </data>\r
- <data name="isRepeatTask" xml:space="preserve">\r
- <value>SELECT REPEATFLG FROM TBL_TASKS WHERE SORTID=?</value>\r
- <comment>そのタスクがリピート対象かを判別します。</comment>\r
- </data>\r
- <data name="setRepeatTask" xml:space="preserve">\r
- <value>UPDATE TBL_TASKS SET REPEATFLG=? WHERE SORTID=?</value>\r
- <comment>タスクのリピート設定を行います。</comment>\r
- </data>\r
- <data name="getNextStartTime" xml:space="preserve">\r
- <value>SELECT MAX(TIME(ENDTIME)) AS MAXENDTIME FROM TBL_TASKS WHERE DODATE=date(?);</value>\r
- <comment>次タスクの開始時間を求めるため、当日最後に終了したタスクの終了時間を抽出します。</comment>\r
- </data>\r
- <data name="clearCategory" xml:space="preserve">\r
- <value>delete from tbl_category</value>\r
- <comment>カテゴリをクリアします。</comment>\r
- </data>\r
- <data name="insertCategory" xml:space="preserve">\r
- <value>INSERT into tbl_category (CATEGID,CATEGORY,FRCOLOR,BGCOLOR) values(?,?,?,?)</value>\r
- <comment>カテゴリを追加します。</comment>\r
- </data>\r
- <data name="delayTask" xml:space="preserve">\r
- <value>update tbl_tasks set DoDate =date(?) where sortid=?</value>\r
- <comment>日付をまたいでタスクを延期します。</comment>\r
- </data>\r
- <data name="changeTaskNo" xml:space="preserve">\r
- <value>update tbl_tasks set sortid = ? where taskid=?</value>\r
- <comment>ソート番号を変更します。</comment>\r
- </data>\r
- <data name="clearTimeArea" xml:space="preserve">\r
- <value>delete from tbl_timearea</value>\r
- <comment>時間帯をクリアします。</comment>\r
- </data>\r
- <data name="insertTimeArea" xml:space="preserve">\r
- <value>INSERT INTO tbl_timearea (TIMEAREA,START,END) values(?,?,?)</value>\r
- <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 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
- <comment>実施中(StartしていてEndしていない)のタスクを抽出します。</comment>\r
- </data>\r
- <data name="changeAreaOfTask" xml:space="preserve">\r
- <value>update tbl_tasks set timearea=? where sortid=?</value>\r
- <comment>タイムエリアを変更します。</comment>\r
- </data>\r
- <data name="changeDebugMode" xml:space="preserve">\r
- <value>UPDATE TBL_SETTING SET LOGMODE='DEBUG'</value>\r
- <comment>デバッグモードに移行します。</comment>\r
- </data>\r
- <data name="changeErrorMode" xml:space="preserve">\r
- <value>UPDATE TBL_SETTING SET LOGMODE='ERROR'</value>\r
- <comment>通常モードに移行します。</comment>\r
- </data>\r
- <data name="changeTraceMode" xml:space="preserve">\r
- <value>UPDATE TBL_SETTING SET LOGMODE='TRACE'</value>\r
- <comment>トレースモードに移行します。</comment>\r
- </data>\r
- <data name="clearTime" xml:space="preserve">\r
- <value>update tbl_tasks set starttime=null,endtime=null where sortid=?</value>\r
- <comment>タスクのスタート/エンドをクリアし、初期状態に戻します。</comment>\r
- </data>\r
- <data name="countBeforeDelete" xml:space="preserve">\r
- <value>SELECT COUNT(taskID) as COUNT FROM tbl_tasks where sortid between ? and ?</value>\r
- <comment>タスク削除前に何件あるか確認します。</comment>\r
- </data>\r
- <data name="deleteTasks" xml:space="preserve">\r
- <value>DELETE FROM tbl_tasks where sortid between ? and ?</value>\r
- <comment>タスクを削除します。</comment>\r
- </data>\r
- <data name="getAllTimeArea" xml:space="preserve">\r
- <value>SELECT TIMEAREA,START,END FROM tbl_timearea</value>\r
- <comment>タイムエリアを取得します。</comment>\r
- </data>\r
- <data name="getLogMode" xml:space="preserve">\r
- <value>SELECT LOGMODE FROM TBL_SETTING</value>\r
- <comment>ログ出力状態を取得します。</comment>\r
- </data>\r
- <data name="getMaxSortID" xml:space="preserve">\r
- <value>SELECT MAX(SORTID) + 10 AS NEXTSORTID FROM TBL_TASKS</value>\r
- <comment>ソート番号の最大値を算出します。</comment>\r
- </data>\r
- <data name="suppressCompleteTask" xml:space="preserve">\r
- <value>UPDATE TBL_TASKS SET SORTID = SORTID * -1 WHERE DATE(DODATE) < (SELECT TODAY FROM TBL_SETTING) AND ENDTIME IS NOT NULL</value>\r
- <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 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
- <value>DELETE FROM TBL_COMMENT WHERE TASKID IS NULL AND DATE(CREATETIME) = DATE(?)</value>\r
- <comment>日付単位でメタコメントを削除します。</comment>\r
- </data>\r
- <data name="clearTaskComment" xml:space="preserve">\r
- <value>DELETE FROM TBL_COMMENT WHERE TASKID=?</value>\r
- <comment>タスク単位でコメントを削除します。</comment>\r
- </data>\r
- <data name="clearZombieComment" xml:space="preserve">\r
- <value>DELETE FROM TBL_COMMENT WHERE TASKID IS NOT NULL AND TASKID NOT IN(SELECT TASKID FROM TBL_TASKS)</value>\r
- <comment>タスク削除時に、タスクに紐付かないコメントをすべて削除します。</comment>\r
- </data>\r
- <data name="getComments" xml:space="preserve">\r
- <value>SELECT ID,TASKID,CREATETIME,COMMENT FROM TBL_COMMENT WHERE TASKID=? ORDER BY ID</value>\r
- <comment>当該タスクに関するコメントを照会します。</comment>\r
- </data>\r
- <data name="getMetaComment" xml:space="preserve">\r
- <value>SELECT C.ID,C.TASKID,C.CREATETIME,C.COMMENT FROM TBL_COMMENT C WHERE date(CREATETIME) = (SELECT TODAY FROM TBL_SETTING) or exists(SELECT TASKID FROM TBL_TASKS T WHERE T.TASKID = C.TASKID AND date(T.DODATE) =(SELECT TODAY FROM TBL_SETTING) ) ORDER BY ID</value>\r
- <comment>当日のメタコメントを参照します。</comment>\r
- </data>\r
- <data name="insertComment" xml:space="preserve">\r
- <value>INSERT INTO TBL_COMMENT (TASKID,CREATETIME,COMMENT) VALUES(?,datetime('now','localtime'),?)</value>\r
- <comment>タスクに対してコメントを追加します。</comment>\r
- </data>\r
- <data name="insertMetaComment" xml:space="preserve">\r
- <value>INSERT INTO TBL_COMMENT (TASKID,CREATETIME,COMMENT) VALUES(null,datetime('now','localtime'),?)</value>\r
- <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 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="getDefaultTimeArea" xml:space="preserve">\r
- <value>SELECT TIMEAREA FROM TBL_TIMEAREA WHERE TIME(START)<=TIME(?) AND TIME(?)<TIME(END)</value>\r
- <comment>現時刻からタイムエリアを算出します。</comment>\r
- </data>\r
- <data name="addTag" xml:space="preserve">\r
- <value>update tbl_tasks set tags=(case when tags is null then ? else (case when tags like ? then tags else tags||','||? end ) end) where sortid=?</value>\r
- <comment>タグを追加します。</comment>\r
- </data>\r
- <data name="clearTags" xml:space="preserve">\r
- <value>update tbl_tasks set tags=null where sortid=?</value>\r
- <comment>タグをクリアします。</comment>\r
- </data>\r
- <data name="findProject" xml:space="preserve">\r
- <value>SELECT DISTINCT PROJECT FROM TBL_TASKS</value>\r
- <comment>全プロジェクトを取得します。</comment>\r
- </data>\r
- <data name="findTags" xml:space="preserve">\r
- <value>SELECT DISTINCT TAGS FROM TBL_TASKS</value>\r
- <comment>全タグを取得します。</comment>\r
- </data>\r
- <data name="getSortIDFromTaskID" xml:space="preserve">\r
- <value>SELECT SORTID FROM TBL_TASKS WHERE TASKID = ?</value>\r
- <comment>タスクIDからソート番号を逆引きします。主にコメント用です。</comment>\r
- </data>\r
- <data name="updateProject" xml:space="preserve">\r
- <value>UPDATE TBL_TASKS SET PROJECT = ? WHERE SORTID= ?</value>\r
- <comment>プロジェクト名を設定します。</comment>\r
- </data>\r
-</root>
\ No newline at end of file
OSDN Git Service
