private void WriteComment(CommentTarget target, string targetName, IDoc doc)
{
if (doc != null && doc.Text.Length > 0)
{
ICodeWriterPlSql sql = Model.Lamp.CodeWritersFactory.CreateCodeWriterPlSql();
sql.Write("COMMENT ON ");
switch (target)
{
case CommentTarget.Table:
sql.Write("TABLE ");
break;
default:
sql.Write("COLUMN ");
break;
}
sql.Write("{0} IS {1}", targetName, sql.ToConst(doc.Text));
genie.Config.NotifyAssistants("Doc", doc, sql.ToString(true));
WriteExecImmediat(sql);
creator.WriteFrom(sql);
creator.WriteSeparator();
}
}
public Comment(int targetId, CommentTarget target)
{
this.targetId = targetId;
this.target = target;
}
public static List<Comment> LoadById(int targetId, CommentTarget target)
{
List<Comment> comments = new List<Comment>();
IList<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@Target_ID", targetId));
parameters.Add(new SqlParameter("@Target", target.ToString()));
DataTable commentsTable = new DataTable();
DataAccessor.Instance.ExecSPDataTable("SP_LoadComments", parameters, commentsTable);
foreach (DataRow row in commentsTable.Rows)
{
Comment c = new Comment();
c.PosterName = DBUtil.DBToString(row["Poster_Name"]);
c.PosterIP = DBUtil.DBToString(row["Poster_IP"]);
c.Email = DBUtil.DBToString(row["Email"]);
c.Url = DBUtil.DBToString(row["URL"]);
c.Content = DBUtil.DBToString(row["Content"]);
c.PostDate = DBUtil.DBToDateTime(row["Post_Date"]);
c.Locale = DBUtil.DBToString(row["Locale"]);
comments.Add(c);
}
return comments;
}
