CacheHelper.cs 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  1. using JLHHJSvr.BLL;
  2. using JLHHJSvr.Com.Model;
  3. using LJLib;
  4. using LJLib.DAL.SQL;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Web.Caching;
  11. namespace JLHHJSvr.Helper
  12. {
  13. internal sealed class CacheHelper : HelperBase
  14. {
  15. #region 弹簧资料
  16. private static LJCache<string, u_spring> _u_spring;
  17. public u_spring getspring(int springid)
  18. {
  19. string key = $"springid:{springid}";
  20. if (_u_spring == null) _u_spring = new LJCache<string, u_spring>() { DefaultAddMinutes = DefaultCacheMinutes };
  21. if (!_u_spring.TryGetValue(key, out u_spring value))
  22. {
  23. var result = new u_spring { springid = springid };
  24. DbSqlHelper.SelectOne(cmd, result, "line_diameter,gram_weight,height,center_diameter,caliber,cyclenum,roll_width,roll_length,arrangement_width,arrangement_height,springtypeid");
  25. _u_spring.Add(key, result);
  26. return result;
  27. }
  28. return value;
  29. }
  30. #endregion
  31. #region 弹簧类型
  32. #endregion
  33. #region 部门
  34. private static LJCache<string, u_dept> _u_dept;
  35. public u_dept getdept(int deptid)
  36. {
  37. string key = $"deptid:{deptid}";
  38. if(_u_dept == null) _u_dept = new LJCache<string, u_dept>() { DefaultAddMinutes = DefaultCacheMinutes };
  39. if (!_u_dept.TryGetValue(key, out u_dept value))
  40. {
  41. var result = new u_dept { deptid = deptid };
  42. DbSqlHelper.SelectOne(cmd, result, "pricelistid,profitrate,moneyrate,discount,taxes_rate,managerate,com_profitrate,dannum1_rate,dannum2_rate,dannum3_rate,dannum4_rate");
  43. _u_dept.Add(key, result);
  44. return result;
  45. }
  46. return value;
  47. }
  48. #endregion
  49. private const int DefaultCacheMinutes = 120;
  50. }
  51. }