ajax 获取 mysql 保存的图片显示

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
function ajax_GetFirstData(data) {
    var len = data.Data.length;
    if (len > 0) {
        $("#jquery_jplayer_1").jPlayer("play", 0);
        window.clearInterval(interval);
        $("#hidd_id").val(data.Data[0].Id);
        $("#txt_sfzh").val(data.Data[0].IdCard);
        $("#txt_name").val(data.Data[0].Name);
        $("#txt_sex").val(data.Data[0].Sex);
        $("#txt_sfztx").attr("src", "../webservice/DetectService.ashx?action=GetPicture&type=IdCardImg&id=" + data.Data[0].Id);
        $("#ps1").attr("src", "../webservice/DetectService.ashx?action=GetPicture&type=Camera1&id=" + data.Data[0].Id);
        $("#ps2").attr("src", "../webservice/DetectService.ashx?action=GetPicture&type=Camera2&id=" + data.Data[0].Id);
        $("#ps3").attr("src", "../webservice/DetectService.ashx?action=GetPicture&type=Camera3&id=" + data.Data[0].Id);
        $(‘#dlg-detect‘).dialog(‘open‘);
    }
}

  

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
/// <summary>
       /// 获取图片
       /// </summary>
       /// <param name="httpContext"></param>
       public void GetPicture(HttpContext httpContext)
       {
           var detectDal = new DetectDal();
           var id = httpContext.Request.Params["id"];
           var type = httpContext.Request.Params["type"];
           try
           {
               var data = detectDal.GetPictureData(id, type);
               switch (type)
               {
                   case "IdCardImg":
                       if (data[0].IdCardImg!=null)
                       {
                           httpContext.Response.BinaryWrite(data[0].IdCardImg);
                       }
                       
                       break;
                   case "Camera1":
                       if (data[0].Camera1!=null)
                       {
                           httpContext.Response.BinaryWrite(data[0].Camera1);
                       }
                        
                       break;
                   case "Camera2":
                       if (data[0].Camera2 != null)
                       {
                           httpContext.Response.BinaryWrite(data[0].Camera2);
                       }
                       break;
                   case "Camera3":
                       if (data[0].Camera3 != null)
                       {
                           httpContext.Response.BinaryWrite(data[0].Camera3);
                       }
                       break;
                   default:break;
               }
           }
           catch (Exception)
           {
               throw;
           }
       }

  

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
/// <summary>
       /// 获取图片
       /// </summary>
       /// <param name="id"></param>
       /// <param name="type"></param>
       /// <returns></returns>
       public IList<Detect> GetPictureData(string id, string type)
       {
           var sql = "";
           var paramList = new List<MySqlParameter>();
           switch (type)
           {
               case "IdCardImg":
                   sql = @" SELECT t.IdCardImg
                           FROM checkin.t_detect t
                           where t.id=?id";
                   break;
               case "Camera1":
                   sql = @" SELECT t.Camera1
                           FROM checkin.t_detect t
                           where t.id=?id";
                   break;
               case "Camera2":
                   sql = @" SELECT t.Camera2
                           FROM checkin.t_detect t
                           where t.id=?id";
                   break;
               case "Camera3":
                   sql = @" SELECT t.Camera3
                           FROM checkin.t_detect t
                           where t.id=?id";
                   break;
               default: break;
           }
           paramList.Add(new MySqlParameter("?id", id));
           DataSet ds;
           try
           {
               ds = MySQLOperater.ExecuteQuery(sql,paramList.ToArray());
           }
           catch (MySqlException e)
           {
               _log.Error("sql:" + sql + e.Message);
               throw new businessException("查询数据出错!");
           }
           var data = Helper.ToList<Detect>(ds.Tables[0]);
           return data;
       }

  ajax 获取 mysql 保存的图片显示

ajax 获取 mysql 保存的图片显示,布布扣,bubuko.com

ajax 获取 mysql 保存的图片显示

上一篇:SQL Server管理员专用连接的使用


下一篇:淘汰机制、缓存雪崩,看完直接跪服