public bool FinishIBSendDtl(long p_systemNo, P_TYPE p_processType, string strSystemProcessID, string strBroadcastYN, SEND_REQUEST_DTL_PSC p_sendRequestInfo, RESULT p_result = RESULT.SUCCESS)
{
string strProcedureName = "PKG_PRC_FOD.USP_FINISH_SEND_DTL";
lock (m_connection)
{
if (!ReOpen())
{
return(false);
}
try
{
using (OracleCommand command = new OracleCommand())
{
command.Connection = m_connection;
command.CommandText = strProcedureName;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("P_FAX_ID", p_sendRequestInfo.faxId);
command.Parameters.AddWithValue("P_FAX_DTL_ID", p_sendRequestInfo.faxDtlId);
command.Parameters.AddWithValue("P_PROCESS_TYPE", p_processType.ToString());
command.Parameters.AddWithValue("P_SYSTEM_ID", p_systemNo);
command.Parameters.AddWithValue("P_SYSTEM_PROCESS_ID", strSystemProcessID);
command.Parameters.AddWithValue("P_FOD_CHANNEL", 99999);
command.Parameters.AddWithValue("P_RESULT_CODE_3", string.Format("{0:D03}", (int)p_result));
command.Parameters.AddWithValue("P_BROADCAST_YN", strBroadcastYN);
command.Parameters.AddWithValue("P_LAST_PAGE_SENT", p_sendRequestInfo.strLastPagesSent);
int cnt = command.ExecuteNonQuery();
if (cnt < 1)
{
return(false);
}
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
return(false);
}
Close();
return(true);
}
}
public RESULT PSI_InsertProcessLog(P_TYPE p_processType, string p_strSystemProcessId, decimal p_FAX_ID, RESULT p_REASON, string p_INFO_EXTRA)
{
RESULT ret = RESULT.EMPTY;
string strProcedureName = "PKG_PRC_PSI.USP_INSERT_PROCESS_LOG";
lock (m_connection)
{
if (!ReOpen())
{
return(RESULT.F_DB_OPENERROR);
}
try
{
using (OracleCommand command = new OracleCommand())
{
command.Connection = m_connection;
command.CommandText = strProcedureName;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("P_FAX_ID", p_FAX_ID);
command.Parameters.AddWithValue("P_PROCESS_TYPE", p_processType.ToString());
command.Parameters.AddWithValue("P_FETCH_PROCESS", p_strSystemProcessId);
command.Parameters.AddWithValue("P_REASON", ((int)p_REASON).ToString().PadLeft(3, '0'));
command.Parameters.AddWithValue("P_INFO_EXTRA", p_INFO_EXTRA);
command.ExecuteNonQuery();
ret = RESULT.SUCCESS;
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
ret = RESULT.F_SYSTEM_ERROR;
}
}
return(ret);
}
public RESULT FetchSendListToMake(P_TYPE p_processType, string p_strSystemProcessId, int p_occupyCnt, ref List <DbModule.SEND_REQUEST_TMK> p_lstTmkSendReqInfos)
{
RESULT ret = RESULT.EMPTY;
string strProcedureName = "PKG_PRC_TMK.USP_OCCUPY_SEND_REQ";
lock (m_connection)
{
if (!ReOpen())
{
return(RESULT.F_DB_OPENERROR);
}
try
{
using (OracleCommand command = new OracleCommand())
{
command.Connection = m_connection;
command.CommandText = strProcedureName;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("P_PROCESS_TYPE", p_processType.ToString());
command.Parameters.AddWithValue("P_FETCH_PROCESS", p_strSystemProcessId);
command.Parameters.AddWithValue("P_OCCUPY_CNT", p_occupyCnt);
OracleParameter param = new OracleParameter("P_TABLE1", OracleType.Cursor);
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
param = new OracleParameter("P_TABLE2", OracleType.Cursor);
param.Direction = ParameterDirection.Output;
command.Parameters.Add(param);
command.ExecuteNonQuery();
DataTable dtMstr = new DataTable("MSTR");
OracleDataReader reader = (OracleDataReader)command.Parameters["P_TABLE1"].Value;
dtMstr.Load(reader);
reader.Close();
reader.Dispose();
DataTable dtDtl = new DataTable("DETAIL");
reader = (OracleDataReader)command.Parameters["P_TABLE2"].Value;
dtDtl.Load(reader);
reader.Close();
reader.Dispose();
if (dtMstr.Rows.Count <= 0 || dtDtl.Rows.Count <= 0)
{
if (dtMstr != null)
{
dtMstr.Dispose();
}
if (dtDtl != null)
{
dtDtl.Dispose();
}
return(RESULT.EMPTY);
}
//// BTF_FAX_SEND_MSTR ////
foreach (DataRow mstrRow in dtMstr.Rows)
{
SEND_REQUEST_TMK tmkReqInfo = new SEND_REQUEST_TMK();
tmkReqInfo.faxId = (decimal)mstrRow["FAX_ID"];
tmkReqInfo.strTrNo = mstrRow["TR_NO"].ToString();
tmkReqInfo.strState = mstrRow["STATE"].ToString();
tmkReqInfo.strReqType = mstrRow["REQ_TYPE"].ToString();
tmkReqInfo.previewYN = mstrRow["PREVIEW_REQ"].ToString();
tmkReqInfo.approvedReq = mstrRow["APPROVE_REQ"].ToString();
//// BTF_FAX_SEND_DTL ////
DataRow[] dtlRows = dtDtl.Select(String.Format("FAX_ID={0}", tmkReqInfo.faxId));
foreach (DataRow dtlRow in dtlRows)
{
SEND_REQUEST_DTL_TMK tmkDtlReqInfo = new SEND_REQUEST_DTL_TMK();
tmkDtlReqInfo.faxId = (decimal)dtlRow["FAX_ID"];
tmkDtlReqInfo.faxDtlId = (decimal)dtlRow["SEQ"];
tmkDtlReqInfo.strStateEach = dtlRow["STATE_EACH"].ToString();
tmkDtlReqInfo.strFaxNo = dtlRow["FAX_NO"].ToString();
tmkDtlReqInfo.strRecipientName = dtlRow["RECIPIENT_NAME"].ToString();
tmkDtlReqInfo.strTiffPath = dtlRow["TIF_FILE"].ToString();
tmkDtlReqInfo.strProcessFetchEach = dtlRow["PROCESS_FETCH_EACH"].ToString();
//dcvReq.m_lstSendRequestDetails.Add(dtlReq);
tmkReqInfo.m_lstTmkSendRequestDtlInfos.Add(tmkDtlReqInfo);
}
p_lstTmkSendReqInfos.Add(tmkReqInfo);
}
ret = RESULT.SUCCESS;
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
ret = RESULT.F_SYSTEM_ERROR;
}
Close();
return(ret);
}
}
public RESULT PSI_FetchPostProcessingRequest(P_TYPE p_processType, string p_strSystemProcessId, int p_occupyCnt, ref List <RECV_FAX_DATA_PSI> p_result)
{
RESULT ret = RESULT.EMPTY;
string strProcedureName = "PKG_PRC_PSI.USP_PROCESS_POST_INBOUND";
lock (m_connection)
{
if (!ReOpen())
{
return(RESULT.F_DB_OPENERROR);
}
try
{
using (OracleCommand command = new OracleCommand())
{
command.Connection = m_connection;
command.CommandText = strProcedureName;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("P_PROCESS_TYPE", p_processType.ToString());
command.Parameters.AddWithValue("P_FETCH_PROCESS", p_strSystemProcessId);
command.Parameters.AddWithValue("P_OCCUPY_CNT", p_occupyCnt);
OracleParameter param1 = new OracleParameter("P_TABLE1", OracleType.Cursor);
param1.Direction = ParameterDirection.Output;
command.Parameters.Add(param1);
OracleParameter param2 = new OracleParameter("P_TABLE2", OracleType.Cursor);
param2.Direction = ParameterDirection.Output;
command.Parameters.Add(param2);
using (OracleDataReader reader = command.ExecuteReader())
{
DataTable dt = new DataTable();
dt.Load(reader);
DataTable dt2 = new DataTable();
dt2.Load(reader);
/// dt, dt2 outer join 과 같은 결과를 내기 위한 loop
foreach (DataRow dr in dt.Rows)
{
RECV_FAX_DATA_PSI data = new RECV_FAX_DATA_PSI();
data.FAX_ID = decimal.Parse(dr["FAX_ID"].ToString());
//data.DEPT_CD = dr["OWNER_DEPT_CD"].ToString(); //WCD(2014-05-28) 부서정보 조회
//data.DEPT_NAME = dr["OWNER_DEPT_NAME"].ToString(); //WCD(2014-05-28) 부서정보 조회
// TEST - 추후 주석제거
//data.DEPT_CD = dr["UPPER_DEPT_CD"].ToString(); //WCD(2014-05-28)
//data.DEPT_NAME = dr["UPPER_DEPT_NAME"].ToString(); //WCD(2014-05-28)
//data.TASK_ID = dr["OWNER_TASK_ID"].ToString();
// TEST
//if(!decimal.TryParse(dr["OWNER_TASK_ID"].ToString(), out data.TASK_ID))
// data.TASK_ID = 0;
data.TASK_NAME = dr["OWNER_TASK_NAME"].ToString();
data.USER_ID = dr["OWNER_USER_ID"].ToString();
// TEST - 추후 주석제거
data.USER_NAME = dr["OWNER_USER_NAME"].ToString(); //WCD(2014-04-29)
data.SERVICE_FAXNO = dr["SERVICE_FAXNO"].ToString(); //WCD(2014-04-29)
data.DID = dr["DID"].ToString(); //WCD(2014-04-29)
//data.RECV_DATE = string.Format("{0:yyyyMMdd}", dr["RECV_DATE"]);//WCD(2014-04-29)
//data.RECV_TIME = string.Format("{0:HHmm}", dr["RECV_DATE"]); //WCD(2014-04-29)
//data.PAGE_CNT = dr["TIF_PAGE_CNT"].ToString(); //WCD(2014-04-29)
// TEST - 추후 주석제거
data.CID = dr["CID"].ToString();
data.CID_NAME = dr["CID_NAME"].ToString();
data.EMAIL_NOTIFY_YN = dr["EMAIL_NOTIFY_YN"].ToString();
data.EMAIL_NOTIFY = dr["EMAIL_NOTIFY"].ToString();
data.PROXY_USER_ID = dr["PROXY_USER_ID"].ToString();
data.PROXY_USER_ID = dr["PROXY_USER_NAME"].ToString();
data.PROXY_EMAIL_NOTIFY_YN = dr["PROXY_EMAIL_NOTIFY_YN"].ToString();
data.PROXY_EMAIL_NOTIFY = dr["PROXY_EMAIL_NOTIFY"].ToString();
data.SPAM_YN = dr["SPAM_YN"].ToString();
foreach (DataRow dr2 in dt2.Rows)
{
decimal fax_id = decimal.Parse(dr2["FAX_ID"].ToString());
if (data.FAX_ID == fax_id)
{
data.SUCC_YN = dr2["SUCC_YN"].ToString();
break;
}
}
p_result.Add(data);
}
}
if (p_result.Count > 0)
{
ret = RESULT.SUCCESS;
}
}
}
catch (Exception ex)
{
ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
ret = RESULT.F_SYSTEM_ERROR;
}
}
return(ret);
}
