X-Git-Url: http://git.osdn.net/view?a=blobdiff_plain;f=KyberNetes%2Fdata%2Fconnection%2FSqlDictionary.Designer.cs;h=5b75b92653feee7f37722f79a5c95d594502671b;hb=c60f3c0c86f6bbd3aa22ae75582ad0b15fc2a413;hp=8565ff574f1ce359e828bd4fce541bbec8a68248;hpb=2a9f6fc9f53a42b2bf3be301ab0d22bd69f30a8b;p=kybernetes%2FKybernetes.git
diff --git a/KyberNetes/data/connection/SqlDictionary.Designer.cs b/KyberNetes/data/connection/SqlDictionary.Designer.cs
index 8565ff5..5b75b92 100644
--- a/KyberNetes/data/connection/SqlDictionary.Designer.cs
+++ b/KyberNetes/data/connection/SqlDictionary.Designer.cs
@@ -106,7 +106,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// delete from mst_category ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// delete from tbl_category ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string clearCategory {
get {
@@ -124,7 +124,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// delete from mst_timearea ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// delete from tbl_timearea ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string clearTimeArea {
get {
@@ -169,7 +169,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// SELECT CategID,Category,BGColor,FRColor FROM MST_CATEGORY ORDER BY CategID ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// SELECT CategID,Category,BGColor,FRColor FROM tbl_category ORDER BY CategID ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getALLCategory {
get {
@@ -191,7 +191,7 @@ namespace com.andoutomo.kybernetes.data.connection {
///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
- ///FROM TBL_TASKS T,TBL_SETTING S LEFT outer join MST_CATEGORY C on C.CATEGID=T.CATEGID
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT outer join tbl_category C on C.CATEGID=T.CATEGID
///ORDER BY DATESORT,E [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getAllList {
@@ -201,7 +201,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// SELECT TIMEAREA,START,END FROM MST_TIMEAREA ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// SELECT TIMEAREA,START,END FROM tbl_timearea ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getAllTimeArea {
get {
@@ -210,7 +210,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// SELECT CategID,Category,BGColor,FRColor FROM MST_CATEGORY WHERE CategID = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// SELECT CategID,Category,BGColor,FRColor FROM tbl_category WHERE CategID = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getCategoryFromCategId {
get {
@@ -219,7 +219,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// SELECT CategID,BGColor,FRColor FROM MST_CATEGORY WHERE Category = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// SELECT CategID,BGColor,FRColor FROM tbl_category WHERE Category = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getCategoryFromCategName {
get {
@@ -248,7 +248,7 @@ namespace com.andoutomo.kybernetes.data.connection {
///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
- ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getDailyList {
get {
@@ -311,7 +311,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,T.CATEGID,C.CATEGORY,T.CONTENTS,T.FORCASTMIN,T.STARTTIME,T.ENDTIME,T.REPEATFLG FROM TBL_TASKS T LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID where T.SORTID = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,T.CATEGID,C.CATEGORY,T.CONTENTS,T.FORCASTMIN,T.STARTTIME,T.ENDTIME,T.REPEATFLG FROM TBL_TASKS T LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID where T.SORTID = ? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getOneTask {
get {
@@ -324,7 +324,7 @@ namespace com.andoutomo.kybernetes.data.connection {
///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
- ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID
///WHERE DATE(T.DODATE [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getPwdList {
@@ -338,7 +338,7 @@ namespace com.andoutomo.kybernetes.data.connection {
///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
- ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE T.ENDTIME IS N [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE T.ENDTIME IS N [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getRemainList {
get {
@@ -360,7 +360,7 @@ namespace com.andoutomo.kybernetes.data.connection {
///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
- ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN MST_CATEGORY C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE DATE(T.DODATE) [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string getTodayList {
get {
@@ -387,7 +387,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// INSERT into MST_CATEGORY (CATEGID,CATEGORY,FRCOLOR,BGCOLOR) values(?,?,?,?) ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// INSERT into tbl_category (CATEGID,CATEGORY,FRCOLOR,BGCOLOR) values(?,?,?,?) ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string insertCategory {
get {
@@ -414,7 +414,7 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
- /// INSERT INTO MST_TIMEAREA (TIMEAREA,START,END) values(?,?,?) ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ /// INSERT INTO tbl_timearea (TIMEAREA,START,END) values(?,?,?) ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string insertTimeArea {
get {
@@ -441,6 +441,19 @@ namespace com.andoutomo.kybernetes.data.connection {
}
///
+ /// SELECT T.TASKID,T.SORTID,T.DODATE,T.TIMEAREA,C.CATEGORY,T.CONTENTS,
+ ///T.FORCASTMIN,T.STARTTIME,T.ENDTIME,C.BGCOLOR,C.FRCOLOR,T.REPEATFLG,
+ ///(CASE WHEN T.ENDTIME IS NULL THEN 1 ELSE 0 END) AS ENDTIMESORT,
+ ///(CASE WHEN T.DODATE =S.TODAY THEN 0 ELSE (CASE WHEN DODATE>S.TODAY THEN 2 ELSE 3 END) END) AS DATESORT,time(startTime) as STARTTIMESORT,(Case when STARTTIME IS NULL THEN 1 ELSE 0 END) AS STARTNullSort
+ ///FROM TBL_TASKS T,TBL_SETTING S LEFT OUTER JOIN tbl_category C ON C.CATEGID=T.CATEGID WHERE T.CONTENTS LIK [æ®ãã®æååã¯åãè©°ãããã¾ãã]"; ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
+ ///
+ internal static string searchTasks {
+ get {
+ return ResourceManager.GetString("searchTasks", resourceCulture);
+ }
+ }
+
+ ///
/// UPDATE TBL_TASKS SET REPEATFLG=? WHERE SORTID=? ã«é¡ä¼¼ãã¦ãããã¼ã«ã©ã¤ãºãããæååãæ¤ç´¢ãã¾ãã
///
internal static string setRepeatTask {