/// <summary>
/// 최신버전 정보 확인 (FAU 사용)
/// </summary>
/// <param name="p_BUILD_VER">client 버전</param>
/// <param name="dtResult">최신 정보 버전</param>
/// <returns>RESULT</returns>
public RESULT FAS_CheckDeployInfo(string p_BUILD_VER, ref DataTable dtResult)
{
string strProcedureName = "PKG_PRC_FAS.USP_SELECT_DEPLOY_INFO";
lock (this)
{
try
{
if (!ReOpen())
{
return(RESULT.F_DB_OPENERROR);
}
using (OracleCommand command = this.MakeOracleCommand(strProcedureName))
{
OraParam param = new OraParam();
param.AddInParam("P_BUILD_VER ", OracleType.VarChar, p_BUILD_VER);
param.AddOutParam("P_TABLE1", OracleType.Cursor);
command.Parameters.AddRange(param.ParamsArray);
OracleDataReader reader = command.ExecuteReader();
dtResult = new DataTable();
dtResult.Load(reader);
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
return(RESULT.F_DB_ERROR);
}
}
return(RESULT.SUCCESS);
}
/// <summary>
/// 로그인 : ID 확인 -> 암호 확인 -> 로그인여부 기록 -> 성공
/// </summary>
/// <returns>
/// EMPTY = 000
/// SUCCESS = 001
/// F_DB_NOTEXIST_USER_ID = 115
/// F_DB_PASSWORD_MISMATCH = 116
/// F_DB_ERROR = 101
/// </returns>
public RESULT FAS_LoginAgentClient(string p_USER_ID, string p_USER_PW, string p_IP, ref string p_USER_NAME, ref string p_RECV_FAXBOX_ID, ref string p_SEND_FAXBOX_ID)
{
string strProcedureName = "PKG_PRC_FAS.USP_LOGIN_AGENT_CLIENT";
lock (this)
{
try
{
if (!ReOpen())
{
return(RESULT.F_DB_OPENERROR);
}
using (OracleCommand command = this.MakeOracleCommand(strProcedureName))
{
OraParam param = new OraParam();
param.AddInParam("P_USER_ID ", OracleType.VarChar, p_USER_ID);
param.AddInParam("P_USER_PW", OracleType.VarChar, p_USER_PW);
param.AddInParam("P_LOGIN_IP", OracleType.VarChar, p_IP);
param.AddOutParam("P_OUT_RESULT", OracleType.Number);
param.AddOutParam("P_OUT_USER_NAME", OracleType.VarChar, 30);
param.AddOutParam("P_OUT_RECV_FAXBOX_ID", OracleType.Number, 12);
param.AddOutParam("P_OUT_SEND_FAXBOX_ID", OracleType.Number, 12);
command.Parameters.AddRange(param.ParamsArray);
command.ExecuteNonQuery();
RESULT result = (RESULT)(decimal)command.Parameters["P_OUT_RESULT"].Value;
p_USER_NAME = command.Parameters["P_OUT_USER_NAME"].Value.ToString();
p_RECV_FAXBOX_ID = command.Parameters["P_OUT_RECV_FAXBOX_ID"].Value.ToString();
p_SEND_FAXBOX_ID = command.Parameters["P_OUT_SEND_FAXBOX_ID"].Value.ToString();
if (result != RESULT.SUCCESS)
{
return(result);
}
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
return(RESULT.F_DB_ERROR);
}
}
return(RESULT.SUCCESS);
}