一开始以为是数据库死锁造成的
后来设置了数据库锁超时时间为2000毫秒
但是还是会出现页面一直卡在那里，不知道为什么？

sql server 设置锁超时时间

 set lock_timeout 2000
select @@lock_timeout

难道代码逻辑有问题？
C# 代码如下：

[down.aspx]

 string idString = Request.QueryString["id"] ?? string.Empty;
int id = 0;
if(!int.TryParse(idString ,out id))
{
    return;
}   

var dbeh = Common.DB.Factory.CreateDBEntityHelper();
if (int.TryParse(idString, out id))
{
    var dlh = new DownLinkHelper();
    string downlink = dlh.GetDownlink(id);

    if(!string.IsNullOrEmpty(downlink))
    {
        Response.Redirect(Server.UrlPathEncode( Server.UrlDecode(downlink)));               
    }

}

[DownLinkHelper.cs]

 using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Caching;

/// <summary>
/// DownLink 的摘要说明
/// </summary>
public class DownLinkHelper
{
    Common.DB.IDBEntityHelper dbh = Common.DB.Factory.CreateDBEntityHelper();

    public string GetDownlink(int val)
    {
        var ent = dbh.GetEntity<Entities.SoftDownLink>("SoftID=" + val);
        if (ent != null)
        {               
            return ent.Address;          
        }

        return string.Empty;
    }
}











using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;

/// <summary>
///SQLServerHandler 的摘要说明
/// </summary>
public class DBHelper : IDBHelper
{
    string connectionString;
    public string ConnectionString
    {
        get { return connectionString; }
        set { connectionString = value; }
    }

    public DBHelper(string connectionString)
    {
        this.connectionString = connectionString;
    }

    public DbCommand CreateCommand()
    {
        return new SqlCommand();
    }

    public DbConnection CreateConnection()
    {

        return new SqlConnection(connectionString);
    }


    public DbParameter CreateParameter(string name, object value)
    {
        DbParameter parameter = CreateParameter();
        parameter.ParameterName = name;
        parameter.Value = value;
        return parameter;
    }

    public DbParameter CreateParameter(string name)
    {
        DbParameter parameter = CreateParameter();
        parameter.ParameterName = name;
        return parameter;
    }

    public DbParameter CreateParameter()
    {
        return new SqlParameter();
    }


    public T ExecuteScalar<T>(string sql, params DbParameter[] parameters)
    {

        using (DbConnection connection = CreateConnection())
        {
            DbCommand cmd = CreateCommand();
            cmd.Connection = connection;
            cmd.CommandText = sql;
            cmd.Parameters.AddRange(parameters);
            connection.Open();
            object o = cmd.ExecuteScalar();
            connection.Close();
            return (T)Convert.ChangeType(o, typeof(T));
        }
    }


    public DbDataReader ExecuteReader(string sql, params DbParameter[] parameters)
    {
        DbConnection connection = CreateConnection();

        DbCommand cmd = CreateCommand();
        cmd.Connection = connection;
        cmd.CommandText = sql;
        cmd.Parameters.AddRange(parameters);
        connection.Open();
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    }

    public int ExecuteNoneQuery(string sql, params DbParameter[] parameters)
    {
        using (DbConnection connection = CreateConnection())
        {

            DbCommand cmd = CreateCommand();
            cmd.Connection = connection;
            cmd.CommandText = sql;
            cmd.Parameters.AddRange(parameters);
            connection.Open();
            int num = cmd.ExecuteNonQuery();
            connection.Close();
            return num;
        }
    }

    public List<Hashtable> GetDataList(string sql, params DbParameter[] parameters)
    {

        List<Hashtable> list = new List<Hashtable>();
        using (DbDataReader reader = ExecuteReader(sql, parameters))
        {
            while (reader.Read())
            {
                Hashtable hs = new Hashtable();

                for (int i = 0; i < reader.FieldCount; i++)
                {
                    hs[reader.GetName(i)] = reader.GetValue(i);
                }

                list.Add(hs);
            }
            reader.Close();
            reader.Dispose();
        }

        return list;


    }

    public Hashtable GetData(string sql, params DbParameter[] parameters)
    {
        Hashtable hs = null;
        using (DbDataReader reader = ExecuteReader(sql, parameters))
        {
            while (reader.Read())
            {
                hs = new Hashtable();
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    hs[reader.GetName(i)] = reader.GetValue(i);
                }
            }
            reader.Close();
            reader.Dispose();
        }

        return hs;
    }



}






/// <summary>
/// DbEntityHelper 的摘要说明
/// </summary>
public class DBEntityHelper : IDBEntityHelper
{
    IDBHelper db = null;

    public IDBHelper DBHelper
    {
        get { return db; }
        set { db = value; }
    }


    public DBEntityHelper()
    {

    }




    public T GetEntityBySql<T>(string sql, params DbParameter[] parameters)
    {
        List<T> list = GetDataList<T>(sql, parameters);

        if (list != null)
        {
            if (list.Count == 1)
            {
                return list[0];
            }
        }

        return default(T);
    }


    public T GetEntity<T>(int id)
    {
        return GetEntityById<T, int>(id);
    }

    public T GetEntity<T, IDT>(IDT id)
    {
        return GetEntityById<T, IDT>(id);
    }

    public T GetEntityById<T, IDT>(IDT id)
    {
        string idFieldName = FieldAttribute.GetIDFieldName(typeof(T));

        if (!string.IsNullOrEmpty(idFieldName))
        {
            return GetEntity<T>(idFieldName + "=@ID", db.CreateParameter("@ID", id));
        }

        return default(T);
    }

    public T GetEntity<T>(string where, params DbParameter[] parameters)
    {
        return GetEntityByWhere<T>(where, parameters);
    }

    public T GetEntity<T>(string where, string sort, params DbParameter[] parameters)
    {
        return GetEntityByWhere<T>(where, sort, parameters);
    }


    public T GetEntityByWhere<T>(string where, params DbParameter[] parameters)
    {
        return GetEntityByWhere<T>(where, null, parameters);
    }

    public T GetEntityByWhere<T>(string where, string sort, params DbParameter[] parameters)
    {
        List<T> list = GetDataList<T>(1, where, sort, parameters);
        if (list != null)
        {
            if (list.Count == 1)
            {
                return list[0];
            }
        }
        return default(T);
    }





    /// <summary>
    /// sql 获得列表
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="queryString"></param>
    /// <param name="parameters"></param>
    /// <returns></returns>
    public List<T> GetDataList<T>(string queryString, params DbParameter[] parameters)
    {
        queryString = queryString.Trim();
        PropertyInfo[] propertys = typeof(T).GetProperties();
        string sql = null;
        if (queryString.IndexOf("select", StringComparison.OrdinalIgnoreCase) == 0)
        {
            sql = queryString;
        }
        else
        {
            Type typ = typeof(T);

            string tableName = TableAttribute.GetTableName(typ);



            StringBuilder fields = new StringBuilder("0");
            foreach (PropertyInfo pi in propertys)
            {
                fields.Append(",");

                string fsql = FieldAttribute.GetFieldSQL(pi);
                if (!string.IsNullOrEmpty(fsql))
                {
                    fields.Append(fsql);
                }
                else
                {
                    fields.Append(FieldAttribute.GetFieldName(pi));
                }



            }

            if (queryString.IndexOf("where", StringComparison.OrdinalIgnoreCase) == 0)
            {
                sql = "select top 1000 " + fields.ToString() + " from " + tableName + " with(nolock) " + queryString;
            }
            else
            {
                sql = "select top 1000 " + fields.ToString() + " from " + tableName + " with(nolock) where " + queryString;
            }


        }

        List<T> list = new List<T>(30);



        using (DbDataReader reader = db.ExecuteReader(sql, parameters))
        {
            while (reader.Read())
            {
                T ins = Activator.CreateInstance<T>();

                foreach (PropertyInfo pi in propertys)
                {
                    int inx = reader.GetOrdinal(FieldAttribute.GetFieldName(pi).Replace("[", string.Empty).Replace("]", string.Empty));

                    object value = reader.GetValue(inx);

                    if (value == DBNull.Value)
                    {
                        pi.SetValue(ins, null, null);
                    }
                    else
                    {

                        pi.SetValue(ins, value, null);
                    }
                }

                list.Add(ins);
            }
            reader.Close();
            reader.Dispose();
        }





        return list;
    }




    /// <summary>
    /// 获得列表
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="num">选择多少条，如果num <= 0 则选择全部</param>
    /// <param name="where"></param>
    /// <param name="sort"></param>
    /// <param name="parameters"></param>
    /// <returns></returns>
    public List<T> GetDataList<T>(int num, string where, string sort, params DbParameter[] parameters)
    {
        Type typ = typeof(T);

        string tableName = TableAttribute.GetTableName(typ);

        PropertyInfo[] propertys = typ.GetProperties();

        StringBuilder fields = new StringBuilder("0");
        foreach (PropertyInfo pi in propertys)
        {
            fields.Append(",");

            string fsql = FieldAttribute.GetFieldSQL(pi);
            if (!string.IsNullOrEmpty(fsql))
            {
                fields.Append(fsql);
            }
            else
            {
                fields.Append(FieldAttribute.GetFieldName(pi));
            }




        }

        where = where ?? string.Empty;
        if (!string.IsNullOrEmpty(where))
        {
            where = " where " + where;
        }

        sort = sort ?? string.Empty;
        if (!string.IsNullOrEmpty(sort))
        {
            sort = " order by " + sort;
        }

        string sql = null;
        if (num > 0)
        {
            sql = "select top " + num + " " + fields.ToString() + " from " + tableName + " with(nolock) " + where + " " + sort;
        }
        else
        {
            sql = "select " + fields.ToString() + " from " + tableName + "  with(nolock) " + where + " " + sort;

        }

        return GetDataList<T>(sql, parameters);
    }


    /// <summary>
    /// 选择全部数据列表
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <returns></returns>
    public List<T> GetDataList<T>()
    {

        return GetDataList<T>(100, null, null);
    }



    /// <summary>
    /// 获得一个分页数据列表
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="pageNumber"></param>
    /// <param name="pageSize"></param>
    /// <param name="where"></param>
    /// <param name="sort"></param>
    /// <param name="recordCount"></param>
    /// <param name="parameters"></param>
    /// <returns></returns>
    public List<T> GetPageDataList<T>(int pageNumber, int pageSize, string where, string sort, out int recordCount, params DbParameter[] parameters)
    {
        Type typ = typeof(T);

        string tableName = TableAttribute.GetTableName(typ);

        PropertyInfo[] propertys = typ.GetProperties();

        StringBuilder fields = new StringBuilder("0");
        string identity = string.Empty;
        foreach (PropertyInfo pi in propertys)
        {
            if (FieldAttribute.IsIdentity(pi)) identity = FieldAttribute.GetFieldName(pi);

            fields.Append(",");

            string fsql = FieldAttribute.GetFieldSQL(pi);
            if (!string.IsNullOrEmpty(fsql))
            {
                fields.Append(fsql);
            }
            else
            {
                fields.Append(FieldAttribute.GetFieldName(pi));
            }


            //fields.Append(FieldAttribute.GetFieldName(pi));

        }

        QueryStringHelper query = new QueryStringHelper();
        query.Fields = fields.ToString();
        query.Identity = identity;
        query.Table = tableName;
        query.PageSize = pageSize;
        query.AbsolutePage = pageNumber;
        query.Where = where;
        query.Sort = sort;


        DbParameter[] cps = new DbParameter[parameters.Length];
        for (int i = 0; i < parameters.Length; i++)
        {
            DbParameter para = parameters[i];

            cps[i] = db.CreateParameter(para.ParameterName, para.Value);
        }


        recordCount = db.ExecuteScalar<int>(query.GetCountQueryString(), cps);

        string selectString = query.GetQueryString();

        return GetDataList<T>(selectString, parameters);
    }

    /// <summary>
    /// 修改数据
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="entity"></param>
    /// <returns></returns>
    public bool UpdateData<T>(T entity)
    {
        Type typ = typeof(T);
        PropertyInfo[] propertys = typeof(T).GetProperties();
        string tableName = TableAttribute.GetTableName(typ);

        List<DbParameter> list = new List<DbParameter>(propertys.Length);


        StringBuilder fps = new StringBuilder();

        bool first = true;

        string where = string.Empty;
        foreach (PropertyInfo pi in propertys)
        {
            if (FieldAttribute.IsAllowModifyUndefined(pi))
            {
                continue;
            }

            if (!FieldAttribute.IsIdentity(pi))
            {
                Type pp = pi.PropertyType;

                object value = pi.GetValue(entity, null);
                if (pp.IsValueType)
                {
                    if (value == null)
                    {
                        continue;
                    }
                }


                if (!first)
                {
                    fps.Append(",");
                }
                else
                {
                    first = false;
                }


                fps.Append(FieldAttribute.GetFieldName(pi));
                fps.Append("=@");
                fps.Append(pi.Name);


                list.Add(db.CreateParameter("@" + pi.Name, value));
            }
            else
            {
                where = FieldAttribute.GetFieldName(pi) + "=@" + pi.Name;
                list.Add(db.CreateParameter("@" + pi.Name, pi.GetValue(entity, null)));
            }
        }


        int num = db.ExecuteNoneQuery("update " + tableName + " set " + fps + " where " + where, list.ToArray());
        if (num == 1)
        {
            return true;
        }

        return false;
    }



    /// <summary>
    /// 插入数据
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="entity"></param>
    /// <returns></returns>
    public bool InsertData<T>(T entity)
    {

        Type typ = typeof(T);
        PropertyInfo[] propertys = typeof(T).GetProperties();
        string tableName = TableAttribute.GetTableName(typ);

        List<DbParameter> list = new List<DbParameter>(propertys.Length);


        StringBuilder fields = new StringBuilder();
        StringBuilder parames = new StringBuilder();

        bool first = true;

        foreach (PropertyInfo pi in propertys)
        {
            if (!FieldAttribute.IsIdentity(pi))
            {
                Type pp = pi.PropertyType;
                object value = pi.GetValue(entity, null);
                if (pp.IsValueType)
                {
                    if (value == null)
                    {
                        continue;
                    }
                }

                if (!first)
                {
                    fields.Append(",");
                    parames.Append(",");
                }
                else
                {
                    first = false;
                }


                fields.Append(FieldAttribute.GetFieldName(pi));


                parames.Append("@");
                parames.Append(pi.Name);

                list.Add(db.CreateParameter("@" + pi.Name, value));
            }
        }



        int num = db.ExecuteNoneQuery("insert into " + tableName + "(" + fields + ") values(" + parames + ")", list.ToArray());
        if (num == 1)
        {
            return true;
        }

        return false;
    }

    /// <summary>
    /// 插入数据，并返回最终插入的ID
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <typeparam name="RT"></typeparam>
    /// <param name="entity"></param>
    /// <returns></returns>
    public RT InsertDataAndGetID<T, RT>(T entity)
    {
        Type typ = typeof(T);
        PropertyInfo[] propertys = typeof(T).GetProperties();
        string tableName = TableAttribute.GetTableName(typ);

        List<DbParameter> list = new List<DbParameter>(propertys.Length);


        StringBuilder fields = new StringBuilder();
        StringBuilder parames = new StringBuilder();

        bool first = true;

        foreach (PropertyInfo pi in propertys)
        {
            if (!FieldAttribute.IsIdentity(pi))
            {
                Type pp = pi.PropertyType;
                object value = pi.GetValue(entity, null);
                if (pp.IsValueType)
                {
                    if (value == null)
                    {
                        continue;
                    }
                }

                if (!first)
                {
                    fields.Append(",");
                    parames.Append(",");
                }
                else
                {
                    first = false;
                }


                fields.Append(FieldAttribute.GetFieldName(pi));


                parames.Append("@");
                parames.Append(pi.Name);

                list.Add(db.CreateParameter("@" + pi.Name, value));
            }
        }


        string sql = "insert into " + tableName + "(" + fields + ") values(" + parames + ");select @@identity;";

        return db.ExecuteScalar<RT>(sql, list.ToArray());
    }


}