using JLHHJSvr.BLL;
using JLHHJSvr.Com.Model;
using LJLib;
using LJLib.DAL.SQL;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web.Caching;

namespace JLHHJSvr.Helper
{
    internal sealed class CacheHelper : HelperBase
    {
        #region 弹簧资料
        private static LJCache<string, u_spring> _u_spring;
        public u_spring getspring(int springid)
        {
            string key = $"springid:{springid}";
            if (_u_spring == null) _u_spring = new LJCache<string, u_spring>() { DefaultAddMinutes = DefaultCacheMinutes };
            if (!_u_spring.TryGetValue(key, out u_spring value))
            {
                var result = new u_spring { springid = springid };
                DbSqlHelper.SelectOne(cmd, result, "line_diameter,gram_weight,height,center_diameter,caliber,cyclenum,roll_width,roll_length,arrangement_width,arrangement_height,springtypeid");
                _u_spring.Add(key, result);
                return result;
            }
            return value;
        }
        #endregion

        #region 弹簧类型
        #endregion

        #region 部门
        private static LJCache<string, u_dept> _u_dept;
        public u_dept getdept(int deptid)
        {
            string key = $"deptid:{deptid}";
            if(_u_dept == null) _u_dept = new LJCache<string, u_dept>() { DefaultAddMinutes = DefaultCacheMinutes };
            if (!_u_dept.TryGetValue(key, out u_dept value))
            {
                var result = new u_dept { deptid = deptid };
                DbSqlHelper.SelectOne(cmd, result, "pricelistid,profitrate,moneyrate,discount,taxes_rate,managerate,com_profitrate,dannum1_rate,dannum2_rate,dannum3_rate,dannum4_rate");
                _u_dept.Add(key, result);
                return result;
            }
            return value;
        }
        #endregion

        private const int DefaultCacheMinutes = 120;
    }
}