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