// 添加微博
public bool save(WeiBo WeiBo)
{
string sql = "insert into t_weibo(authorId, authorName,isOriginal,zanNumber,transmitNumber,favsNumber,reviewNumber," +
"content,orAuthorId,orAuthorName,orContent,ortime,createTime) values(" +
WeiBo.authorId + ",'" +
WeiBo.authorName + "','" +
WeiBo.isOriginal+ "'," +
WeiBo.zanNumber+","+
WeiBo.transmitNumber+","+
WeiBo.favsNumber+","+
WeiBo.reviewNumber+",'"+
WeiBo.content + "'," +
WeiBo.orAuthorId+",'"+
WeiBo.orAuthorName+ "','" +
WeiBo.orContent+"','"+
WeiBo.orTime + "','" +
WeiBo.createTime + "')";
int flag = DBHelper.ExecuteSQL(sql);
if (flag == 1)
{
return true;
}
else
{
return false;
}
}
//根据weiboId更新微博(Zan)
public bool updateZanFavsReviewTrans(WeiBo wb)
{
return dll.updateZanFavsReviewTrans(wb);
}
public bool save(WeiBo WeiBo)
{
return dll.save(WeiBo);
}
//根据sql查询微博信息
IList<WeiBo> GetWeiBosBySql(string sql)
{
SqlDataReader reader = DBHelper.ExecuteReader(sql);
IList<WeiBo> WeiBos = new List<WeiBo>();
try
{
while (reader.Read())
{
WeiBo w = new WeiBo();
w.weiboId =(Int32) reader["weiboId"];
w.authorId = (Int32)reader["authorId"];
w.authorName = reader["authorName"].ToString();
w.content = reader["content"].ToString();
w.createTime = (DateTime)reader["createTime"];
w.favsNumber = (Int32)reader["favsNumber"];
w.reviewNumber = (Int32)reader["reviewNumber"];
w.transmitNumber = (Int32)reader["transmitNumber"];
w.zanNumber = (Int32)reader["zanNumber"];
w.isOriginal = reader["isOriginal"].ToString();
if (w.isOriginal.Trim()!="原创")
{
w.orAuthorId = (Int32)reader["orAuthorId"];
w.orAuthorName = reader["orAuthorName"].ToString();
w.orContent = reader["orContent"].ToString();
w.orTime = (DateTime)reader["orTime"];
}
WeiBos.Add(w);
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return WeiBos;
}
//根据weiboId更新微博(ZanFavsReviewTrans)
public bool updateZanFavsReviewTrans(WeiBo wb)
{
string sql = "update t_WeiBo " +
" set zanNumber=" + wb.zanNumber+ ","+
"favsNumber=" + wb.favsNumber + "," +
"reviewNumber=" + wb.reviewNumber + "," +
"transmitNumber=" + wb.transmitNumber +
" where weiboid=" + wb.weiboId;
int flag = DBHelper.ExecuteSQL(sql);
if (flag >= 1)
{
return true;
}
else
{
return false;
}
}