CacheHelper.cs 2.1 KB

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