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; } |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 周边上新:园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源!
· .NET周刊【3月第1期 2025-03-02】
· 分享 3 个 .NET 开源的文件压缩处理库,助力快速实现文件压缩解压功能!
· [AI/GPT/综述] AI Agent的设计模式综述