|
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 保存的图片显示,布布扣,bubuko.com
原文：http://www.cnblogs.com/zhangwei595806165/p/3596337.html