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);
}
