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