RedisDbconn.cs 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Threading;
  4. using System.Threading.Tasks;
  5. using CSRedis;
  6. using Library;
  7. using System.Linq;
  8. namespace MySystem
  9. {
  10. public class RedisDbconn
  11. {
  12. public readonly static RedisDbconn Instance = new RedisDbconn();
  13. private RedisDbconn()
  14. {
  15. var csredis = new CSRedis.CSRedisClient(ConfigurationManager.AppSettings["RedisConnStr"].ToString());
  16. //初始化 RedisHelper
  17. RedisHelper.Initialization(csredis);
  18. }
  19. #region 设置单个字段
  20. public bool Set(string key, object value, int sec = -1)
  21. {
  22. return RedisHelper.Set(key, value, sec);
  23. // return false;
  24. }
  25. #endregion
  26. #region 整数累加
  27. public long AddInt(string key, long value = 1)
  28. {
  29. return RedisHelper.IncrBy(key, value);
  30. // return 0;
  31. }
  32. #endregion
  33. #region 数字累加
  34. public decimal AddNumber(string key, decimal value = 1)
  35. {
  36. return RedisHelper.IncrByFloat(key, value);
  37. // return 0;
  38. }
  39. #endregion
  40. #region 获取单个字段
  41. public T Get<T>(string key)
  42. {
  43. return RedisHelper.Get<T>(key);
  44. }
  45. #endregion
  46. #region 设置散列字段
  47. public bool HSet(string key, string field, object value)
  48. {
  49. return RedisHelper.HSet(key, field, value);
  50. // return false;
  51. }
  52. #endregion
  53. #region 散列整数累加
  54. public long HAddInt(string key, string field, long value = 1)
  55. {
  56. return RedisHelper.HIncrBy(key, field, value);
  57. // return 0;
  58. }
  59. #endregion
  60. #region 散列数字累加
  61. public decimal HAddNumber(string key, string field, decimal value = 1)
  62. {
  63. return RedisHelper.HIncrByFloat(key, field, value);
  64. // return 0;
  65. }
  66. #endregion
  67. #region 获取散列元素
  68. public T HGet<T>(string key, string field)
  69. {
  70. return RedisHelper.HGet<T>(key, field);
  71. }
  72. #endregion
  73. #region 获取散列所有元素
  74. public Dictionary<string, T> HGetAll<T>(string key)
  75. {
  76. return RedisHelper.HGetAll<T>(key);
  77. }
  78. #endregion
  79. #region 添加列表对象
  80. public long AddList(string key, object value)
  81. {
  82. return RedisHelper.LPush(key, value);
  83. // return 0;
  84. }
  85. public long AddList(string key, object[] value)
  86. {
  87. return RedisHelper.LPush(key, value);
  88. // return 0;
  89. }
  90. public long AddRightList(string key, object value)
  91. {
  92. return RedisHelper.RPush(key, value);
  93. // return 0;
  94. }
  95. public T RPop<T>(string key)
  96. {
  97. return RedisHelper.RPop<T>(key);
  98. }
  99. #endregion
  100. #region 添加集合对象
  101. public long SAdd(string key, object value)
  102. {
  103. return RedisHelper.SAdd(key, value);
  104. // return 0;
  105. }
  106. public long SAdd(string key, object[] value)
  107. {
  108. return RedisHelper.SAdd(key, value);
  109. // return 0;
  110. }
  111. #endregion
  112. #region 获取集合对象
  113. public T[] SGetList<T>(string key)
  114. {
  115. return RedisHelper.SMembers<T>(key);
  116. }
  117. #endregion
  118. #region 判断元素是否存在
  119. public bool SIsMember(string key, object value)
  120. {
  121. return RedisHelper.SIsMember(key, value);
  122. }
  123. #endregion
  124. #region 修改列表对象
  125. public bool SetList(string key, int index, object value)
  126. {
  127. long itemindex = RedisHelper.LLen(key) - index - 1;
  128. return RedisHelper.LSet(key, itemindex, value);
  129. // return false;
  130. }
  131. #endregion
  132. #region 获取列表
  133. public List<T> GetList<T>(string key, int pageNum = 1, int pageSize = 10)
  134. {
  135. int start = (pageNum - 1) * pageSize;
  136. int end = start + pageSize - 1;
  137. T[] list = RedisHelper.LRange<T>(key, start, end);
  138. return list.ToList();
  139. }
  140. #endregion
  141. #region 添加排序列表对象
  142. public long AddSort(string key, object value, decimal score)
  143. {
  144. return RedisHelper.ZAdd(key, (score, value));
  145. // return 0;
  146. }
  147. #endregion
  148. #region 获取排序列表
  149. public List<T> GetSort<T>(string key, int pageNum = 1, int pageSize = 10)
  150. {
  151. int start = (pageNum - 1) * pageSize;
  152. int end = start + pageSize;
  153. string[] list = RedisHelper.ZRangeByScore(key, start, end);
  154. List<T> lists = new List<T>();
  155. foreach (string record in list)
  156. {
  157. lists.Add(Newtonsoft.Json.JsonConvert.DeserializeObject<T>(record));
  158. }
  159. return lists;
  160. }
  161. public List<T> GetSortDesc<T>(string key, int pageNum = 1, int pageSize = 10)
  162. {
  163. int start = (pageNum - 1) * pageSize;
  164. int end = start + pageSize;
  165. string[] list = RedisHelper.ZRevRangeByScore(key, start, end);
  166. List<T> lists = new List<T>();
  167. foreach (string record in list)
  168. {
  169. lists.Add(Newtonsoft.Json.JsonConvert.DeserializeObject<T>(record));
  170. }
  171. return lists;
  172. }
  173. #endregion
  174. public bool Remove(string key, long start, long end)
  175. {
  176. return RedisHelper.LTrim(key, start, end);
  177. }
  178. public bool RemoveTop(string key, long count)
  179. {
  180. return RedisDbconn.Instance.Remove(key, count, RedisDbconn.Instance.Count(key) - 1); ;
  181. }
  182. public long Count(string key)
  183. {
  184. return RedisHelper.LLen(key);
  185. }
  186. public void Clear(string pattern)
  187. {
  188. string[] keys = RedisHelper.Keys(pattern);
  189. RedisHelper.Del(keys);
  190. }
  191. public string[] GetKeys(string pattern)
  192. {
  193. string[] keys = RedisHelper.Keys(pattern);
  194. return keys;
  195. }
  196. public bool Exists(string key)
  197. {
  198. return RedisHelper.Exists(key);
  199. }
  200. public bool HExists(string key, string field)
  201. {
  202. return RedisHelper.HExists(key, field);
  203. }
  204. public void SetExpire(string key, int expire)
  205. {
  206. RedisHelper.Expire(key, expire); //秒为单位
  207. }
  208. /// <summary>
  209. /// 锁key
  210. /// </summary>
  211. private readonly string lockKey = "RedisLock";
  212. /// <summary>
  213. /// 锁的过期秒数
  214. /// </summary>
  215. private readonly int lockTime = 20;
  216. /// <summary>
  217. /// 续命线程取消令牌
  218. /// </summary>
  219. private CancellationTokenSource tokenSource = new CancellationTokenSource();
  220. /// <summary>
  221. /// 获取锁
  222. /// </summary>
  223. /// <param name="requestId">请求id保证释放锁时的客户端和加锁的客户端一致</param>
  224. /// <returns></returns>
  225. public bool GetLock(string requestId)
  226. {
  227. //设置key 设置过期时间20s
  228. while (true)
  229. {
  230. //设置key Redis2.6.12以上版本,可以用set获取锁。set可以实现setnx和expire,这个是原子操作
  231. if (RedisHelper.Set(lockKey, requestId, lockTime, RedisExistence.Nx))
  232. {
  233. //设置成功后开启子线程为key续命
  234. CreateThredXm();
  235. return true;
  236. }
  237. }
  238. }
  239. /// <summary>
  240. /// 为锁续命(防止业务操作时间大于锁自动释放时间,锁被自动释放掉)
  241. /// </summary>
  242. void CreateThredXm()
  243. {
  244. Task.Run(() =>
  245. {
  246. while (true)
  247. {
  248. Thread.Sleep(10);
  249. //外部取消 退出子线程
  250. if (tokenSource.IsCancellationRequested)
  251. {
  252. return;
  253. }
  254. //查询key还有多少秒释放
  255. var Seconds = RedisHelper.PTtl(lockKey) / 1000;
  256. //key还剩1/3秒时重设过期时间
  257. if (Seconds < (lockTime / 3))
  258. {
  259. //小于5秒则自动 重设过期时间
  260. RedisHelper.Expire(lockKey, lockTime);
  261. }
  262. }
  263. }, tokenSource.Token);
  264. }
  265. /// <summary>
  266. /// 释放锁操作
  267. /// </summary>
  268. /// <param name="requestId">请求id保证释放锁时的客户端和加锁的客户端一致</param>
  269. public void ReleaseLock(string requestId)
  270. {
  271. //这里使用Lua脚本保证原子性操作
  272. string script = "if redis.call('get', KEYS[1]) == ARGV[1] then " +
  273. "return redis.call('del', KEYS[1]) " +
  274. "else return 0 end";
  275. RedisHelper.Eval(script, lockKey, requestId);
  276. //取消续命线程
  277. tokenSource.Cancel();
  278. }
  279. }
  280. }