ajax 获取 mysql 保存的图片显示

浏览数：27 / 时间：2015年06月12日

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