mysql返回的图片如何显示出来_ajax 获取 mysql 保存的图片显示

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');

}

}

///

/// 获取图片

///

///

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;

}

}

///

/// 获取图片

///

///

///

///

public IList GetPictureData(string id, string type)

{

var sql = "";

var paramList = new List();

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(ds.Tables[0]);

return data;

}