public string InsertEnrollData(string astrDevId, string astrEnrollData) { string strEnrollId; string strBackupNumber; string strUserPrivilege; string strFpData; string strPassword; string strIdCard; int nBackupNumber; strEnrollId = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "enroll_id"); strBackupNumber = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "backup_number"); strUserPrivilege = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "user_privilege"); strFpData = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "fp_data"); strPassword = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "password"); strIdCard = FKWebTools.GetFieldValueInJSONString(astrEnrollData, "idcard"); try { if (!FKWebTools.IsValidEngDigitString(strEnrollId, 24)) { return("{result:ERROR_INVALID_PARAM_ENROLL_ID}"); } nBackupNumber = Convert.ToInt32(strBackupNumber); if (nBackupNumber < 0 || nBackupNumber > 12) { return("{result:ERROR_INVALID_PARAM_BACKUP_NUMBER}"); } } catch (Exception) { return("{result:ERROR_INVALID_PARAM}"); } try { string strSql; SqlConnection conn = new SqlConnection(msDbConn); conn.Open(); strSql = "INSERT INTO tbl_realtime_enroll_data"; strSql = strSql + "(update_time, device_id, enroll_id, backup_number, user_privilege, fp_data, password, idcard)"; strSql = strSql + "VALUES('" + FKWebTools.TimeToString(DateTime.Now) + "', "; strSql = strSql + "'" + astrDevId + "', "; strSql = strSql + "'" + strEnrollId + "', "; strSql = strSql + "'" + nBackupNumber + "', "; strSql = strSql + "'" + strUserPrivilege + "', "; strSql = strSql + "'" + strFpData + "', "; strSql = strSql + "'" + strPassword + "', "; strSql = strSql + "'" + strIdCard + "')"; SqlCommand cmd = new SqlCommand(strSql, conn); cmd.ExecuteNonQuery(); conn.Close(); return("{result:OK}"); } catch (Exception) { return("{result:ERROR_DB_ACCESS}"); } }
public string InsertGLog(string astrDevId, string astrGLog) { string strEnrollId; string strVerifyMode; string strIoMode; string strIoTime; strEnrollId = FKWebTools.GetFieldValueInJSONString(astrGLog, "enroll_id"); strVerifyMode = FKWebTools.GetFieldValueInJSONString(astrGLog, "verify_mode"); strIoMode = FKWebTools.GetFieldValueInJSONString(astrGLog, "io_mode"); strIoTime = FKWebTools.GetFieldValueInJSONString(astrGLog, "io_time"); strIoTime = FKWebTools.ConvertFKTimeToNormalTimeString(strIoTime); try { if (!FKWebTools.IsValidEngDigitString(strEnrollId, 24)) { return("{result:ERROR_INVALID_PARAM_ENROLL_ID}"); } if (String.IsNullOrEmpty(strVerifyMode) || strVerifyMode.Length > 8) { return("{result:ERROR_INVALID_PARAM_VERIFY_MODE}"); } if (String.IsNullOrEmpty(strIoMode) || strIoMode.Length > 8) { return("{result:ERROR_INVALID_PARAM_IO_MODE}"); } if (!FKWebTools.IsValidTimeString(strIoTime)) { return("{result:ERROR_INVALID_PARAM_IO_TIME}"); } } catch (Exception) { return("{result:ERROR_INVALID_PARAM}"); } try { string strSql; SqlConnection conn = new SqlConnection(msDbConn); conn.Open(); strSql = "INSERT INTO tbl_realtime_glog"; strSql = strSql + "(update_time, device_id, enroll_id, verify_mode, io_mode, io_time)"; strSql = strSql + "VALUES('" + FKWebTools.TimeToString(DateTime.Now) + "', "; strSql = strSql + "'" + astrDevId + "', "; strSql = strSql + "'" + strEnrollId + "', "; strSql = strSql + "'" + strVerifyMode + "', "; strSql = strSql + "'" + strIoMode + "', "; strSql = strSql + "'" + strIoTime + "')"; SqlCommand cmd = new SqlCommand(strSql, conn); cmd.ExecuteNonQuery(); conn.Close(); return("{result:OK}"); } catch (Exception) { return("{result:ERROR_DB_ACCESS}"); } }