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);
}
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筆記版本控制查詢));
}
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);
}
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);
}