public int Update_Memo(Saus request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { RichTextBox rtb = new RichTextBox(); List <Saus1> ls = db.Select <Saus1>("Select IsNull(Memo,'') From Saus1 Where UserID='" + request.saus1.UserId + "'"); if (ls.Count > 0) { rtb.Text = request.saus1.Memo; } Result = db.Update <Saus1>( new { Memo = rtb.Rtf }, p => p.UserId == request.saus1.UserId ); } } catch { throw; } return(Result); }
public string GetMemo(Saus request) { string Result = null; try { using (var db = DbConnectionFactory.OpenDbConnection()) { RichTextBox rtb = new RichTextBox(); List <Saus1> ls = db.Select <Saus1>("Select Memo From Saus1 Where UserID='" + request.UserID + "'"); if (ls.Count > 0) { rtb.Rtf = ls[0].Memo; } Result = rtb.Text; } } catch { throw; } return(Result); }