Publics/ImageFromDB.ashx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web.SessionState;

namespace 客户订单管理2
{
    /// <summary>
    /// ImageFromDB 的摘要说明
    /// </summary>
    public class ImageFromDB : IHttpHandler, IRequiresSessionState
    {

        public void ProcessRequest(HttpContext context)
        {
            #region 权限检查
            if (context.Session["login"] == null || context.Session["login"].ToString() != "true")
            {
                context.Response.Write("<script>top.location.href='../Default.aspx';</script>");
                context.Response.End();
                return;
            }
            #endregion
            
            if (context.Request.QueryString["Table"] == null) return;
            context.Response.AppendHeader("Cache-Control", "no-cache"); 
            SqlConnection 数据连接;
            SqlCommand sqlCmd = new SqlCommand();
            string table = context.Request.QueryString["Table"];
            table = 系统.解密(table.Replace("_", "+"));
            string field = context.Request.QueryString["Field"];
            field = 系统.解密(field.Replace("_", "+"));
            string key = context.Request.QueryString["Key"];
            key = 系统.解密(key.Replace("_", "+"));
            string keyValue = context.Session["keyValue"].ToString();
            string sql = "select " + field + " from " + table + " where " + key + " = '" + keyValue + "'";
            数据连接 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["默认连接_3HK0R6GAS"].ConnectionString);
            try
            {
                数据连接.Open();
                sqlCmd.Connection = 数据连接;
                sqlCmd.CommandText = sql;
                object obj = sqlCmd.ExecuteScalar();
                数据连接.Close();
                MemoryStream ms = new MemoryStream((byte[])obj);
                BinaryReader br = new BinaryReader(ms);
                byte[] bw = new byte[(int)ms.Length];
                bw = br.ReadBytes((int)ms.Length);
                context.Response.Clear();
                context.Response.ContentType = "image/jpeg";
                context.Response.BinaryWrite(bw);
                context.Response.End();
            }
            catch
            {