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