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

/// <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;
}
}

/// <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;
}