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; }