/// <summary>
/// 更新设备响应内容
/// </summary>
/// <param name="arrContent"></param>
public void Update(string arrContent)
{
string sql = string.Format(@"
update DeviceCmds set
ResponseTime = @ResponseTime ,
ReturnValue = @ReturnValue
where ID=@ID
");
List <ManySql> manySql = new List <ManySql>();
string[] contentList = arrContent.Split('\n');
for (int i = 0, j = contentList.Length; i < j && contentList[i].Length > 0; i++)
{
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ResponseTime", Tools.GetDateTimeNowString()),
new SQLiteParameter("@ReturnValue", contentList[i]),
new SQLiteParameter("@ID", contentList[i].Split('&')[0].Split('=')[1])
};
manySql.Add(new ManySql(sql, parameters));
}
SqliteHelper.ExecuteManySql(manySql);
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="pins"></param>
/// <returns></returns>
public int Delete(List <string> pins)
{
string strPins = Tools.UnionString(pins);
List <string> listSql = new List <string>();
//删除一体化模板信息
listSql.Add(string.Format(@"
delete from TmpBioData
where PIN in ({0})
", strPins));
//删除指纹模板信息
listSql.Add(string.Format(@"
delete from TmpFP
where PIN in ({0})
", strPins));
//删除人脸模板信息
listSql.Add(string.Format(@"
delete from TmpFace
where PIN in ({0})
", strPins));
//删除指静脉模板信息
listSql.Add(string.Format(@"
delete from TmpFvein
where PIN in ({0})
", strPins));
//删除用户照片信息
listSql.Add(string.Format(@"
delete from TmpUserPic
where PIN in ({0})
", strPins));
//删除比对照片信息
listSql.Add(string.Format(@"
delete from TmpBioPhoto
where PIN in ({0})
", strPins));
//删除用户信息
listSql.Add(string.Format(@"
delete from UserInfo
where PIN in ({0})
", strPins));
try
{
SqliteHelper.ExecuteManySql(listSql);
}
catch
{
return(0);
}
return(1);
}
