public void RptBind()
{
string strWhere = "";
string strUid = "";
try
{
strUid = this.Session["hyuid"].ToString();
}
catch
{
}
if (strUid != "")
{
strWhere = " and hy_uid='" + strUid + "' ";
}
else
{
return;
}
JpFavorite jpFavorite = new JpFavorite();
DataTable dt = jpFavorite.GetData(strWhere);
StringBuilder stringBuilder = new StringBuilder();
int commentCount = 0;
JpComment jpComment = new JpComment();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtComment = jpComment.Getdocsbyaid_ysh(pis_cid, dt.Rows[i]["hy_aid"].ToString());
commentCount = dtComment.Rows.Count;
stringBuilder.Append("<li><a onclick=\"locationDetail('art_detail.aspx?aid=" + dt.Rows[i]["hy_aid"].ToString() + "&cid=" + dt.Rows[i]["hy_cid"].ToString() + "','" + locationType + "','1')\">" + dt.Rows[i]["hy_bt"].ToString() + "</a>");
stringBuilder.Append("<span>" + dt.Rows[i]["hy_addtime"].ToString() + "</span>");
stringBuilder.Append("</li>");
}
this.lb_show.Text = stringBuilder.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_cid = "", ls_page = "1", la_pagesize = "10";
TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
if (this.Request.QueryString["cid"] != null)
{
ls_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
}
if (this.Request.QueryString["page"] != null)
{
ls_page = JpCommon.Filter(this.Request.QueryString["page"].ToString());
}
if (this.Request.QueryString["pagesize"] != null)
{
la_pagesize = JpCommon.Filter(this.Request.QueryString["pagesize"].ToString());
}
//根据传入的文章栏目ID、页码、页数返回列表信息
TPortalClass.JpArticle JpArticle = new TPortalClass.JpArticle();
string ls_where = "", ls_order = "";
ls_where = " and cid like '" + ls_cid + "%' and sfzwd='否' ";
ls_order = " order by pubtime desc";
DataTable dt = JpArticle.SearchdocsByKey(ls_where, ls_order, int.Parse(ls_page), int.Parse(la_pagesize));
//复制一个DataTalbe
DataTable tempTable = dt.Clone();
//在现有的DatatTable增加一列
DataColumn col = new DataColumn("showTime", typeof(String));
//将列添加到DataTable中去
tempTable.Columns.Add(col);
//在现有的DatatTable增加一列
DataColumn col2 = new DataColumn("commentCount", typeof(String));
//将列添加到DataTable中去
tempTable.Columns.Add(col2);
int commentCount = 0;
JpComment jpComment = new JpComment();
//循环 对DataTable重新赋值
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[tempTable.Columns[j].ColumnName] = dt.Rows[i][j];
}
DataTable dtComment = jpComment.Getdocsbyaid_ysh(ls_cid, dt.Rows[i]["aid"].ToString());
commentCount = dtComment.Rows.Count;
//获得间隔的时间
dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["crtime"].ToString()));
dr["commentCount"] = commentCount;
tempTable.Rows.Add(dr);
}
//转换成json格式
string strJson = JsonConvert.SerializeObject(tempTable);
//数据抛出
Response.Write(strJson);
}