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