public void Getcount(int ID)
{
MemoryCache cache1 = MemoryCache.Default;
if (!cache1.Contains("tp" + ID.ToString()))
{
lock (ID.ToString())
{
if (!cache1.Contains("tp" + ID.ToString()))
{
string strtext = "select count(*) from tabvote where TabCanId=@ID";
MySqlParameter param = new MySqlParameter()
{
ParameterName = "ID", Value = ID, MySqlDbType = MySqlDbType.Int32
};
object count = MySQLCommon.ExecuteScalar(strtext, param);
string strtxt2 = "update tabcandidate set Votes=@Count where Id=@ID";
MySqlParameter[] param2 = new MySqlParameter[] {
new MySqlParameter()
{
ParameterName = "ID", Value = ID, MySqlDbType = MySqlDbType.Int32
},
new MySqlParameter()
{
ParameterName = "Count", Value = Convert.ToInt32(count), MySqlDbType = MySqlDbType.Int32
}
};
MySQLCommon.ExecuteNonQuery(strtxt2, param2);
cache1.Set("tp" + ID.ToString(), ID, DateTimeOffset.Now.AddMinutes(5));
}
}
}
}
/// <summary>
/// 添加投票信息
/// </summary>
/// <param name="vote"></param>
/// <returns></returns>
public int Addvote(TabVoteItems vote)
{
string strText = "insert into tabvote values(@Id,@Ip,@session,@user_agent,@Votetime,@TabCanId)";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter()
{
ParameterName = "Id", Value = vote.Id, MySqlDbType = MySqlDbType.Int32
},
new MySqlParameter()
{
ParameterName = "Ip", Value = vote.Ip, MySqlDbType = MySqlDbType.VarChar
},
new MySqlParameter()
{
ParameterName = "session", Value = vote.session, MySqlDbType = MySqlDbType.VarChar
},
new MySqlParameter()
{
ParameterName = "user_agent", Value = vote.user_agent, MySqlDbType = MySqlDbType.VarChar
},
new MySqlParameter()
{
ParameterName = "Votetime", Value = vote.Votetime, MySqlDbType = MySqlDbType.DateTime
},
new MySqlParameter()
{
ParameterName = "TabCanId", Value = vote.TabCanId, MySqlDbType = MySqlDbType.Int32
}
};
return(MySQLCommon.ExecuteNonQuery(strText, param));
}
