protected void Page_Load(object sender, EventArgs e)
{
//获取参数
string ls_aid = "", ls_cid = "", ls_page = "1", ls_pagesize = "10";
JpCommon JpCommon = new JpCommon();
if (this.Request.QueryString["cid"] != null)
ls_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
if (this.Request.QueryString["aid"] != null)
ls_aid = JpCommon.queryString2StrID(this.Request.QueryString["aid"].ToString(), 9);
if (this.Request.QueryString["page"] != null)
ls_page = JpCommon.queryString2StrID(this.Request.QueryString["page"].ToString(), 9);
if (this.Request.QueryString["pagesize"] != null)
ls_pagesize = JpCommon.queryString2StrID(this.Request.QueryString["pagesize"].ToString(), 9);
TPortalClass.JpComment JpComment = new TPortalClass.JpComment();
TPortalClass.JpUserVip JpUserVip = new TPortalClass.JpUserVip();
DataTable dt = JpComment.Getdocsbyaid_ysh_fy(ls_aid, ls_cid, Convert.ToInt32(ls_page), Convert.ToInt32(ls_pagesize));
DataTable tempTable = dt.Clone();
DataColumn col1 = new DataColumn("rytx", typeof(String));
DataColumn col2 = new DataColumn("showTime", typeof(String));
tempTable.Columns.Add(col1);
tempTable.Columns.Add(col2);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
string ls_user = dt.Rows[i]["usid"].ToString();
DataTable dtrytx = JpUserVip.GetJpUserPic(ls_user);
if (dtrytx.Rows.Count > 0)
{
dr["rytx"] = dtrytx.Rows[0]["hy_pic"].ToString();
}
else
{
dr["rytx"] = "images/1211p1.png";
}
dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["commenttime"].ToString()));
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
//转换成json格式
string strJson = JsonConvert.SerializeObject(tempTable);
//数据抛出
Response.Write(strJson);
}
private void DataPlay()
{
TPortalClass.JpComment JpComment = new TPortalClass.JpComment();
TPortalClass.JpUserVip JpUserVip = new TPortalClass.JpUserVip();
string strOrder = " order by commenttime desc ";
DataTable dt = JpComment.GetdocsbyaidAll(aid, cid, 1, 3, strOrder);
DataTable tempTable = dt.Clone();
DataColumn col1 = new DataColumn("rytx", typeof(String));
DataColumn col2 = new DataColumn("showTime", typeof(String));
tempTable.Columns.Add(col1);
tempTable.Columns.Add(col2);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
string ls_user = dt.Rows[i]["usid"].ToString();
DataTable dtrytx = JpUserVip.GetJpUserPic(ls_user);
if (dtrytx.Rows.Count > 0)
{
dr["rytx"] = dtrytx.Rows[0]["hy_pic"].ToString();
}
else
{
dr["rytx"] = "images/1211p1.png";
}
dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["commenttime"].ToString()));
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
rptListNew.DataSource = tempTable;
rptListNew.DataBind();
//获得最热的数据
dt.Clear();
strOrder = " order by praiseCount desc ";
dt = JpComment.GetdocsbyaidAll(aid, cid, 1, 3, strOrder);
tempTable.Clear();
tempTable = dt.Clone();
DataColumn col3 = new DataColumn("rytx", typeof(String));
DataColumn col4 = new DataColumn("showTime", typeof(String));
tempTable.Columns.Add(col3);
tempTable.Columns.Add(col4);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = tempTable.NewRow();
string ls_user = dt.Rows[i]["usid"].ToString();
DataTable dtrytx = JpUserVip.GetJpUserPic(ls_user);
if (dtrytx.Rows.Count > 0)
{
dr["rytx"] = dtrytx.Rows[0]["hy_pic"].ToString();
}
else
{
dr["rytx"] = "images/1211p1.png";
}
dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["commenttime"].ToString()));
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
rptList.DataSource = tempTable;
rptList.DataBind();
}
