示例#1
0
        public static void fn訂單私人筆記新增(CNote note)
        {
            string sql = $"EXEC 私人筆記新增 ";

            sql += $"@{CNoteKey.fNoteListName},";
            sql += $"@{CNoteKey.fCreateDateTime},";
            sql += $"@{CNoteKey.fEditDateTime},";
            sql += $"@{CNoteKey.fNoteListLevel},";
            sql += $"@{CNoteKey.fIsMyFavourite},";
            sql += $"@{CNoteKey.fIsTrash},";
            sql += $"@{CNoteKey.fHTMLContent},";
            sql += $"@{CNoteKey.fJsonContent},";
            sql += $"@{CNoteKey.fTheShareLink},";
            sql += $"@{CNoteKey.fTheContactPerson},";
            sql += $"@{CNoteKey.fFolderId}";

            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CNoteKey.fNoteListName, note.fNoteListName),
                new SqlParameter(CNoteKey.fCreateDateTime, note.fCreateDateTime),
                new SqlParameter(CNoteKey.fEditDateTime, note.fEditDateTime),
                new SqlParameter(CNoteKey.fNoteListLevel, note.fNoteListLevel),
                new SqlParameter(CNoteKey.fIsMyFavourite, note.fIsMyFavourite),
                new SqlParameter(CNoteKey.fIsTrash, note.fIsTrash),
                new SqlParameter(CNoteKey.fHTMLContent, note.fHTMLContent),
                new SqlParameter(CNoteKey.fJsonContent, note.fJsonContent),
                new SqlParameter(CNoteKey.fTheShareLink, (object)note.fTheShareLink ?? DBNull.Value),         //可NULL
                new SqlParameter(CNoteKey.fTheContactPerson, (object)note.fTheContactPerson ?? DBNull.Value), //可NULL
                new SqlParameter(CNoteKey.fFolderId, note.fFolderId)
            };

            CDbManager.executeSql(sql, paras);
        }
示例#2
0
        public static List <CVersion> fn筆記版本控制查詢(CNote note)
        {
            string sql = $"EXEC 筆記版本控制查詢 ";

            sql += $"@{CVersionKey.fNoteId}";
            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CVersionKey.fNoteId, note.fNoteId)
            };

            return((List <CVersion>)CDbManager.querySql(sql, paras, reader筆記版本控制查詢));
        }
示例#3
0
        public static void fn私人筆記刪除(CNote note)
        {
            string sql = $"EXEC 私人筆記刪除 ";

            sql += $"@{CNoteKey.fNoteId}";

            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CNoteKey.fNoteId, note.fNoteId)
            };

            CDbManager.executeSql(sql, paras);
        }
示例#4
0
        public static void fn筆記版本控制新增(CNote note)
        {
            string sql = $"EXEC 筆記版本控制新增 ";

            sql += $"@{CVersionKey.fEditDateTime},";
            sql += $"@{CVersionKey.fHTMLContent},";
            sql += $"@{CVersionKey.fJsonContent},";
            sql += $"@{CVersionKey.fNoteId}";

            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter(CVersionKey.fEditDateTime, note.fEditDateTime),
                new SqlParameter(CVersionKey.fHTMLContent, note.fHTMLContent),
                new SqlParameter(CVersionKey.fJsonContent, note.fJsonContent),
                new SqlParameter(CVersionKey.fNoteId, note.fNoteId)
            };

            CDbManager.executeSql(sql, paras);
        }