[HttpGet]
public MemoResponse GetMemo(int memoId)
{
return factory.GetMemo(memoId);
}
public class MemoResponse
{
public string id { get; set; }
public string title { get; set; }
public string content { get; set; }
public string createTime { get; set; }
public string userName { get; set; }
public string userHead { get; set; }
}
public MemoResponse GetMemo(int memoId)
{
MemoResponse result = new MemoResponse();
string Mes = "";
StringBuilder sbSql = new StringBuilder();
sbSql.AppendFormat(@" SELECT [PK_ID],[FK_UserID],[Content],[CDate],dbo.GetUserHead(FK_UserID) as sHeadImg,
(SELECT sName FROM ibp_t_user AS b WHERE a.F