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