62,243
社区成员




public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string id = context.Request["id"].ToString();
ArticleDAO dao = new ArticleDAO(connString);
Article article = dao.GetArticle("id=" + id);
System.Collections.Generic.List<ArticleImage> list = new List<ArticleImage>();
string strWhere = "ArticleId =" + article.Id;
SqlClientHelper sch = new SqlClientHelper(connString);
StringBuilder sb = new StringBuilder();
sb.Append("select * from [ArticleImage]");
sb.Append(" where " + strWhere);
//就在这里出问题,注释掉这一句 就正常了,加上这一句就无法显示出内容
//在ajax回调里都可以取到数据,但就是不能显示在CKEditor里,也可以在页面的其他div里显示,唯独在CKEditor里显示不出来
// 这是从数据库取数据的,相关代码贴下面
DataTable dt = sch.GetData(sb.ToString());
IsoDateTimeConverter iso = new IsoDateTimeConverter();
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
String str = JsonConvert.SerializeObject(article, iso);
context.Response.Write(str);
}
}
/// <summary>
/// 获取查询结果集
/// </summary>
/// <param name="queryString">查询语句</param>
/// <returns>DataTable结果集</returns>
public DataTable GetData(string commandText)
{
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(commandText, conn);
try
{
conn.Open();
adapter.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
adapter.Dispose();
conn.Close();
}
return dt;
}
public class ArticleImage
{
//编号
private System.Int32 _id;
public System.Int32 Id
{
get { return _id; }
set { _id = value; }
}
//文章编号
private System.Int32 _articleid;
public System.Int32 ArticleId
{
get { return _articleid; }
set { _articleid = value; }
}
//图片数据
private System.Byte[] _data;
public System.Byte[] Data
{
get { return _data; }
set { _data = value; }
}
//创建时间
private System.DateTime _createdate;
public System.DateTime CreateDate
{
get { return _createdate; }
set { _createdate = value; }
}
//文件路径
private System.String _filepath;
public System.String FilePath
{
get { return _filepath; }
set { _filepath = value; }
}
//文件名
private System.String _filename;
public System.String FileName
{
get { return _filename; }
set { _filename = value; }
}
//图片类型
private System.String _imagetype;
public System.String ImageType
{
get { return _imagetype; }
set { _imagetype = value; }
}
//宽度
private System.Int32 _width;
public System.Int32 Width
{
get { return _width; }
set { _width = value; }
}
//高度
private System.Int32 _height;
public System.Int32 Height
{
get { return _height; }
set { _height = value; }
}
//点击量
private System.Int32 _clickcount;
public System.Int32 ClickCount
{
get { return _clickcount; }
set { _clickcount = value; }
}
//HTTP地址
private System.String _httpaddress;
public System.String HttpAddress
{
get { return _httpaddress; }
set { _httpaddress = value; }
}