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