Пример #1
0
        public bool AOX_InsertFAXBOX(SendRequestMasterInfo p_mstr)
        {
            string strProcedureName = "PKG_PRC_COMMON.USP_FAXSEND_SET_FAXBOX";

            //decimal faxID = -1;

            try
            {
                using (OracleCommand command = new OracleCommand())
                {
                    command.Connection  = m_connection;
                    command.CommandText = strProcedureName;
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.AddWithValue("P_REQ_USER_ID     ".Trim(), p_mstr.REQ_USER_ID);
                    command.Parameters.AddWithValue("P_FAX_ID          ".Trim(), p_mstr.OUT_FAX_ID);

                    OracleParameter resultParam = new OracleParameter("P_RESULT", OracleType.VarChar, 1);
                    resultParam.Direction = ParameterDirection.Output;
                    command.Parameters.Add(resultParam);

                    int cnt = command.ExecuteNonQuery();
                    if (cnt > 0)
                    {
                        //faxID = Convert.ToDecimal(resultParam.Value);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
                //return -1;
                throw ex;
            }
            return(true);
        }
Пример #2
0
        /// <summary>
        /// Name       : AOX_InsertSendMaster
        /// Parameters :
        /// Content    : BTF_FAX_SEND_MSTR 테이블에 INSERT
        /// Return     : true / false
        /// Writer     : 장동훈
        /// Date       : 2012.09.06
        /// </summary>
        public decimal AOX_InsertSendMaster(SendRequestMasterInfo p_mstr)
        {
            string  strProcedureName = "PKG_PRC_AOX.USP_INSERT_SEND_MSTR";
            decimal faxID            = -1;

            try
            {
                using (OracleCommand command = new OracleCommand())
                {
                    command.Connection  = m_connection;
                    command.CommandText = strProcedureName;
                    command.CommandType = CommandType.StoredProcedure;

                    //AddInParam("P_INDEX_NO        ", OracleType.VarChar, p_mstr.INDEX_NO);
                    //command.Parameters.AddWithValue("P_INDEX_NO        ".Trim(), p_mstr.INDEX_NO);
                    command.Parameters.AddWithValue("P_TR_NO           ".Trim(), p_mstr.TR_NO);
                    command.Parameters.AddWithValue("P_STATE           ".Trim(), p_mstr.STATE);
                    command.Parameters.AddWithValue("P_PRIORITY        ".Trim(), p_mstr.PRIORITY);
                    command.Parameters.AddWithValue("P_TITLE           ".Trim(), p_mstr.TITLE);
                    command.Parameters.AddWithValue("P_MEMO            ".Trim(), p_mstr.MEMO);
                    command.Parameters.AddWithValue("P_PRE_PROCESS_REQ ".Trim(), p_mstr.PRE_PROCESS_REQ);
                    command.Parameters.AddWithValue("P_REQ_TYPE        ".Trim(), p_mstr.REQ_TYPE);
                    command.Parameters.AddWithValue("P_REQUESTER_TYPE  ".Trim(), p_mstr.REQUESTER_TYPE);
                    command.Parameters.AddWithValue("P_REQ_USER_ID     ".Trim(), p_mstr.REQ_USER_ID);
                    command.Parameters.AddWithValue("P_REQ_USER_NAME   ".Trim(), p_mstr.REQ_USER_NAME);
                    command.Parameters.AddWithValue("P_REQ_USER_TELNO  ".Trim(), p_mstr.REQ_USER_TELNO);
                    command.Parameters.AddWithValue("P_REQ_DATE        ".Trim(), p_mstr.REQ_DATE);
                    command.Parameters.AddWithValue("P_PREVIEW_REQ     ".Trim(), p_mstr.PREVIEW_REQ);
                    //command.Parameters.AddWithValue("P_PREVIEWED_ID    ".Trim(), p_mstr.PREVIEWED_ID);
                    //command.Parameters.AddWithValue("P_PREVIEWED_DATE  ".Trim(), p_mstr.PREVIEWED_DATE);
                    command.Parameters.AddWithValue("P_APPROVE_REQ     ".Trim(), p_mstr.APPROVE_REQ);
                    //command.Parameters.AddWithValue("P_APPROVED_YN     ".Trim(), p_mstr.APPROVED_YN);
                    //command.Parameters.AddWithValue("P_APPROVED_ID     ".Trim(), p_mstr.APPROVED_ID);
                    //command.Parameters.AddWithValue("P_APPROVED_DATE   ".Trim(), p_mstr.APPROVED_DATE);
                    //command.Parameters.AddWithValue("P_APPROVED_COMMENT".Trim(), p_mstr.APPROVED_COMMENT);
                    command.Parameters.AddWithValue("P_RESERVED_YN     ".Trim(), p_mstr.RESERVED_YN);
                    //command.Parameters.AddWithValue("P_RESERVED_DATE   ".Trim(), p_mstr.RESERVED_DATE);
                    //command.Parameters.AddWithValue("P_PROCESS_FETCH   ".Trim(), p_mstr.PROCESS_FETCH);
                    //command.Parameters.AddWithValue("P_SMS_CONTENTS    ".Trim(), p_mstr.SMS_CONTENTS);
                    command.Parameters.AddWithValue("P_SMS_SEND_YN     ".Trim(), p_mstr.SMS_SEND_YN);
                    //command.Parameters.AddWithValue("P_RESULT_FORWARD  ".Trim(), p_mstr.RESULT_FORWARD);
                    command.Parameters.AddWithValue("P_TEST_TYPE       ".Trim(), p_mstr.TEST_TYPE);
                    command.Parameters.AddWithValue("P_BROADCAST_YN    ".Trim(), p_mstr.BROADCAST_YN);
                    OracleParameter faxIdParam = new OracleParameter("P_OUT_FAX_ID", OracleType.Number);
                    faxIdParam.Direction = ParameterDirection.Output;
                    command.Parameters.Add(faxIdParam);

                    int cnt = command.ExecuteNonQuery();
                    if (cnt > 0)
                    {
                        faxID = Convert.ToDecimal(faxIdParam.Value);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionMsg(ex, "PROCEDURE : " + strProcedureName);
                //return -1;
                throw ex;
            }
            return(faxID);
        }