/// <summary> /// 获取数据 /// </summary> /// <param name="tabName"></param> /// <param name="uid"></param> /// <param name="key"></param> /// <returns></returns> public string Get(string tabName, string uid, string key) { string strKey = tabName + "_" + uid + "_" + key; if (RedisUtility.KeyExist(strKey)) { return(RedisUtility.StringGet(strKey)); } var sqlParams = new MySqlParameter[] { new MySqlParameter("@openid", MySqlDbType.VarChar) { Value = uid }, }; var strsql = "select " + key + " from " + tabName + " where uid=@uid limit 1"; var dataset = MysqlUtility.ExecuteQuery(strsql, sqlParams); var obj = dataset.Tables[0].Rows[0][key].ToString(); if (obj != null) { logger.Warn("strKey: " + strKey + " obj: " + obj); RedisUtility.StringSet(strKey, obj, expireTime); } return(obj); }
/// <summary> /// 设置数据 /// </summary> /// <param name="tabName"></param> /// <param name="uid"></param> /// <param name="key"></param> /// <param name="value"></param> public void Set(string tabName, string uid, string key, string value) { var strs = value.Split(':'); var dbType = GetDbType(strs[0]); var sqlParams = new MySqlParameter[] { new MySqlParameter("@value", dbType) { Value = strs[1] }, new MySqlParameter("@openid", MySqlDbType.VarChar) { Value = uid }, }; string strKey = tabName + "_" + uid + "_" + key; RedisUtility.StringSet(strKey, strs[1], expireTime); var strsql = "update " + tabName + " set " + key + "=@value where openid=@openid"; MysqlUtility.ExecuteSql(strsql, sqlParams); }