//根据sql查询粉丝信息
IList <FansMarks> GetFansMarksBySql(string sql)
{
SqlDataReader reader = DBHelper.ExecuteReader(sql);
IList <FansMarks> FansMarks = new List <FansMarks>();
try
{
while (reader.Read())
{
FansMarks f = new FansMarks();
f.markId = Convert.ToInt32(reader["markId"]);
f.onselfId = Convert.ToInt32(reader["onselfId"]);
f.otherId = Convert.ToInt32(reader["otherId"]);
f.createTime = (DateTime)reader["createTime"];
FansMarks.Add(f);
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(FansMarks);
}
//插入 关注记录
public bool save(FansMarks f)
{
string sql = "insert into t_FansMarks(onselfId,otherId,createTime) values(" + f.onselfId + "," + f.otherId + ",'" + f.createTime + "')";
int flag = DBHelper.ExecuteSQL(sql);
if (flag == 1)
{
return(true);
}
else
{
return(false);
}
}