/// <summary>
/// 读取评论
/// </summary>
/// <param name="context"></param>
public void CommentsLoad(HttpContext context)
{
string eformsn = context.Request["eformsn"];
if (!Wis.Toolkit.Validator.IsInt(eformsn))
{
context.Response.Write(0);
return;
}
context.Response.ContentType = "text/xml";
context.Response.ContentEncoding = System.Text.Encoding.UTF8;
context.Response.Write("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider();
dataProvider.ConnectionString = Wis.Website.Setting.MeetingConnectionString;
dataProvider.Open();
string commandText = string.Format("select meetingGuid from wd_75 where eformsn ={0}", eformsn);
object o = dataProvider.ExecuteScalar(commandText);
dataProvider.Close();
if (o == null)
{
context.Response.Write(0);
return;
}
dataProvider.ConnectionString = Setting.ConnectionString;
dataProvider.Open();
using (StringWriter sw = new StringWriter())
{
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.Formatting = Formatting.Indented;
// xtw.WriteStartDocument();
xtw.WriteStartElement("L"); // League -> L
commandText = string.Format("select * from Comment where ObjectGuid ='{0}' order by CommentId", o);
System.Data.IDataReader dataReader = dataProvider.ExecuteReader(commandText);
while (dataReader.Read())
{
xtw.WriteStartElement("A");
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(dataReader["Title"].ToString());
sb.Append(","); //
sb.Append(dataReader["Commentator"].ToString());
sb.Append(","); //
sb.Append(dataReader["ContentHtml"].ToString());
sb.Append(","); //
sb.Append(dataReader["Original"].ToString());
sb.Append(","); //
sb.Append(System.Convert.ToDateTime(dataReader["DateCreated"]).ToString("yyyy-mm-dd HH:mm"));
sb.Append(","); //
xtw.WriteAttributeString("V", sb.ToString());
xtw.WriteEndElement();// ActiveMatch -> A
}
dataReader.Close();
dataProvider.Close();
xtw.WriteEndElement();// Live -> L
context.Response.Write(sw.ToString());
}
}