public static WeiboList getLatestWeibo(int num, bool is_raw, string type,string created_at)
{
string strSQL = "select * from ";
if (is_raw)
strSQL += " WEIBO_RAW ";
else
strSQL += " WEIBO ";
strSQL += " where 1=1 ";
if (!type.Trim().Equals(""))
strSQL += " and TYPE='" + type.Trim() + "' ";
if(!created_at.Trim().Equals(""))
strSQL += " and unix_timestamp(CREATED_AT)<unix_timestamp('" + created_at + "') ";
strSQL += " order by CREATED_AT desc limit " + num;
DataTable dt = sql.RunSQL(strSQL);
WeiboList list = new WeiboList();
for (int i = 0; i < dt.Rows.Count; i++)
{
WeiboDetail detail = new WeiboDetail();
DataRow tr = dt.Rows[i];
detail.weibo_id = int.Parse(tr["weibo_id"].ToString());
detail.user_id = int.Parse(tr["USER_ID"].ToString());
detail.content = tr["CONTENT"].ToString();
detail.pub_time = tr["CREATED_AT"].ToString();
detail.type = tr["type"].ToString();
detail.like_count = int.Parse(tr["like_count"].ToString());
detail.mid_pic = tr["BMIDDLE_PIC"].ToString();
detail.small_pic = tr["THUMBNAIL_PIC"].ToString();
detail.origin_pic = tr["ORIGINAL_PIC"].ToString();
UserDetail user = WeiboDB.getUser(detail.user_id);
detail.user_name = user.user_name;
detail.comment_count = WeiboDB.getCommentCount(detail.weibo_id);
detail.forward_count = WeiboDB.getForwardCount(detail.weibo_id);
list.weibo_list.Add(detail);
}
return list;
}
public static WeiboDetail getWeiboByID(int weibo_id)
{
string strSQL = "select * from WEIBO where WEIBO_ID=" + weibo_id;
DataTable dt=sql.RunSQL(strSQL);
DataRow tr = dt.Rows[0];
WeiboDetail detail = new WeiboDetail();
detail.weibo_id = int.Parse(tr["weibo_id"].ToString());
detail.user_id = int.Parse(tr["USER_ID"].ToString());
detail.content = tr["CONTENT"].ToString();
detail.pub_time = tr["CREATED_AT"].ToString();
detail.type = tr["type"].ToString();
detail.like_count = int.Parse(tr["like_count"].ToString());
detail.mid_pic = tr["BMIDDLE_PIC"].ToString();
detail.small_pic = tr["THUMBNAIL_PIC"].ToString();
detail.origin_pic = tr["ORIGINAL_PIC"].ToString();
UserDetail user = WeiboDB.getUser(detail.user_id);
detail.user_name = user.user_name;
detail.comment_count = WeiboDB.getCommentCount(detail.weibo_id);
detail.forward_count = WeiboDB.getForwardCount(detail.weibo_id);
return detail;
}
