ajax 获取 mysql 保存的图片显示

  1. 云栖社区>
  2. 博客>
  3. 正文

ajax 获取 mysql 保存的图片显示

awbeci 2014-03-12 14:54:00 浏览496
展开阅读全文
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;
        }

  

网友评论

登录后评论
0/500
评论
awbeci
+ 关注