cs/access.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.Caching;
using System.Data.OleDb;
using System.Data;

    /// <summary>
    /// 带缓存的数据库链接方法 
    /// </summary>
    public class access
    {
        private HttpContext context = HttpContext.Current;

        public int ExecuteNonQuery(string sql) 
        {
            int fig = 0;

            fig = new AcsHelper().ExecuteNonQuery(sql);

            return fig;
        }
        public int ExecuteNonQuery(string sql, OleDbParameter[] parameters)
        {
            int fig = 0;

            fig = new AcsHelper().ExecuteNonQuery(sql, parameters);

            return fig;
        }

        public string ExecuteScalar(string sql) 
        {
            object fig = null;

            if (iftj() == 1)
            {
                if (context.Cache[sql] == null)
                {
                    string a = new AcsHelper().ExecuteScalar(sql);
                    if (a != "")
                    {
                        context.Cache.Insert(sql, a, null, times(), Cache.NoSlidingExpiration);
                    }
                    fig = a;
                }
                else
                {
                    fig = context.Cache[sql];
                }
            }
            else
            {
                fig = new AcsHelper().ExecuteScalar(sql);
            }

            return Convert.ToString(fig);
        }
        public string ExecuteScalar(string sql, OleDbParameter[] parameters)
        {