PWMIS.Core/SqlUtil/SqlCache.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using PWMIS.DataMap.Entity;

namespace PWMIS.Common
{
    /// <summary>
    /// (与具体数据库无关的)SQL查询命令信息
    /// </summary>
    public class SqlInfo
    {
        public string SQL { get; private set; }
        public Dictionary<string, TableNameField> Parameters { get; private set; }
        public System.Data.CommandType CommandType { get; set; }
        public string TableName { get; set; }

        public SqlInfo(string sql)
        {
            this.SQL = sql;
        }

        public SqlInfo(string sql, Dictionary<string, TableNameField> para)
        {
            this.SQL = sql;
            this.Parameters = para;
        }

        private static Dictionary<string, SqlInfo> _dictSqlCache;
        private static object sync_obj = new object();

        private static Dictionary<string, SqlInfo> DictSqlCache
        { 
            get{
                if (_dictSqlCache == null)
                {
                    lock (sync_obj)
                    {
                        if (_dictSqlCache == null)
                        {
                            var temp = new Dictionary<string, SqlInfo>();
                            _dictSqlCache = temp;
                        }
                    }
                }
                return _dictSqlCache;
            }
        }
        /// <summary>
        /// 从缓存中获取项
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public static SqlInfo GetFromCache(string key)
        {
            SqlInfo Value = null;
            DictSqlCache.TryGetValue(key, out Value);
            return Value;
        }
        /// <summary>