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