public void Test() { const string csFuncName = "Test"; string strJson; PrintDebugMsg(csFuncName, "0 - Start"); try { SqlConnection conn = new SqlConnection(msDbConn); conn.Open(); conn.Close(); } catch (Exception e) { PrintDebugMsg(csFuncName, "1 - " + e.ToString()); return; } strJson = "{abc:12345,fgh:quit,k1k:7896}"; if (FKWebTools.GetFieldValueInJSONString(strJson, "fgh") != "quit") { PrintDebugMsg(csFuncName, "Error - Json parser"); return; } if (FKWebTools.GetFieldValueInJSONString(strJson, "k1k") != "7896") { PrintDebugMsg(csFuncName, "Error - Json parser"); return; } if (FKWebTools.ConvertFKTimeToNormalTimeString("20121213140123") != "2012-12-13 14:01:23") { PrintDebugMsg(csFuncName, "Error - FK time string convert"); return; } if (FKWebTools.GetFKTimeString14(Convert.ToDateTime("2013-2-3 19:7:29")) != "20130203190729") { PrintDebugMsg(csFuncName, "Error - time to FKTime14 convert"); return; } PrintDebugMsg(csFuncName, "OK - End"); }
// 기대의 접속상태표를 갱신한다. public void UpdateFKDeviceStatus( SqlConnection asqlConn, string asDevId, string asDevName, string asDevTime, string asDevInfo) { const string csFuncName = "UpdateFKDeviceStatus"; PrintDebugMsg(csFuncName, "0 - DevTime:" + asDevTime + ", DevId:" + asDevId + ", DevName:" + asDevName); if (asqlConn.State != ConnectionState.Open) { return; } try { PrintDebugMsg(csFuncName, "1"); SqlCommand sqlCmd = new SqlCommand("usp_update_device_conn_status", asqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@dev_id", SqlDbType.VarChar).Value = asDevId; sqlCmd.Parameters.Add("@dev_name", SqlDbType.VarChar).Value = asDevName; sqlCmd.Parameters.Add("@tm_last_update", SqlDbType.DateTime).Value = DateTime.Now; sqlCmd.Parameters.Add("@fktm_last_update", SqlDbType.DateTime).Value = FKWebTools.ConvertFKTimeToNormalTimeString(asDevTime); sqlCmd.Parameters.Add("@dev_info", SqlDbType.VarChar).Value = asDevInfo; sqlCmd.ExecuteNonQuery(); PrintDebugMsg(csFuncName, "2"); } catch (Exception e) { PrintDebugMsg(csFuncName, "Except - 1 - " + e.ToString()); } }
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}"); } }