Example #1
0
        ///----------------------------------------------------------------------------------
        /// <summary>
        /// 상품 조회, 2019-09-19
        /// </summary>
        /// <param name="intSeqNo"></param>
        /// <param name="strModuleName"></param>
        /// <param name="pl_objDT"></param>
        /// <param name="pl_strErrMsg"></param>
        /// <returns></returns>
        ///----------------------------------------------------------------------------------
        public static int GetProductList(string strStoreCode, string strCashAttrCode, int intProductTypeCode, out DataTable objDT, out string strErrMsg)
        {
            int  pl_intRetVal = 0;
            IDas pl_objDas    = null;

            strErrMsg = "OK";
            objDT     = null;

            try
            {
                pl_objDas = new IDas();
                pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
                pl_objDas.CommandType = CommandType.StoredProcedure;
                pl_objDas.CodePage    = 0;

                pl_objDas.AddParam("@pi_strStoreCode", DBType.adVarChar, strStoreCode, 50, ParameterDirection.Input);
                pl_objDas.AddParam("@pi_strCashAttrCode", DBType.adVarChar, strCashAttrCode, 15, ParameterDirection.Input);
                pl_objDas.AddParam("@pi_intProductTypeCode", DBType.adTinyInt, intProductTypeCode, 0, ParameterDirection.Input);
                pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
                pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);

                pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
                pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);

                pl_objDas.SetQuery("dbo.UP_POS_PRODUCT_UR_LST");

                if (!pl_objDas.LastErrorCode.Equals(0))
                {
                    pl_intRetVal = pl_objDas.LastErrorCode;
                    strErrMsg    = pl_objDas.LastErrorMessage;
                    return(pl_intRetVal);
                }

                objDT = new DataTable();
                objDT = pl_objDas.objDT;
            }
            catch (Exception pl_objEx)
            {
                pl_intRetVal = -15701;
                strErrMsg    = "상품 목록 조회 실패";
                UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
            }
            finally
            {
                if (pl_objDas != null)
                {
                    pl_objDas.Close();
                    pl_objDas = null;
                }
            }

            return(pl_intRetVal);
        }
Example #2
0
        //이벤트 입력
        private int InsFamilyEventJoin(int intUserNo, Int64 intFamilyEventNo, out string strErrMsg)
        {
            int  pl_intRetVal = 0;
            IDas pl_objDas    = null;

            strErrMsg = string.Empty;

            try
            {
                //사용자 정보 조회
                pl_objDas = new IDas();
                pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
                pl_objDas.CommandType = CommandType.StoredProcedure;
                pl_objDas.CodePage    = 0;

                pl_objDas.AddParam("@pi_intUserNo", DBType.adInteger, intUserNo, 0, ParameterDirection.Input);
                pl_objDas.AddParam("@pi_intFamilyEventNo", DBType.adBigInt, intFamilyEventNo, 0, ParameterDirection.Input);
                pl_objDas.AddParam("@pi_intUserRole", DBType.adTinyInt, 3, 0, ParameterDirection.Input);
                pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
                pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 4, ParameterDirection.Output);
                pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);

                pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 4, ParameterDirection.Output);

                pl_objDas.SetQuery("dbo.UP_FAMILY_EVENT_JOIN_TX_INS");

                pl_intRetVal = Convert.ToInt32(pl_objDas.GetParam("@po_intRetVal"));
                strErrMsg    = Convert.ToString(pl_objDas.GetParam("@po_strErrMsg"));
            }
            catch (Exception pl_objEx)
            {
                pl_intRetVal = -15213;
                strErrMsg    = pl_objEx.Message + pl_objEx.StackTrace;
                UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
            }
            finally
            {
                if (pl_objDas != null)
                {
                    pl_objDas.Close();
                    pl_objDas = null;
                }

                if (!pl_intRetVal.Equals(0))
                {
                    UtilLog.WriteLog("GetUserCurrentPwd", pl_intRetVal, strErrMsg);
                }
            }

            return(pl_intRetVal);
        }
Example #3
0
        ///================================================================================
        /// Name           : PrintProductTypeDDLB
        /// Description    : <summary>일반 구매 시 사용되는 상품 타입 리스트 박스를 정의한다.</summary>
        /// Author         : [email protected], 2019-11-21
        /// Modify History : Just Created.
        ///================================================================================
        public static string PrintProductTypeDDLB(bool boolDefault, HtmlType objHtmlType = HtmlType.freeItemProductType)
        {
            IDas          pl_objDAS = null;
            StringBuilder pl_objSb  = null;

            try
            {
                pl_objSb = new StringBuilder();

                pl_objDAS = new IDas();
                pl_objDAS.Open(UserGlobal.BOQ_HOST_DAS);
                pl_objDAS.CommandType = CommandType.StoredProcedure;
                pl_objDAS.CodePage    = 0;

                pl_objDAS.AddParam("@pi_strDisplayFlag", DBType.adChar, 'Y', 1, ParameterDirection.Input);
                pl_objDAS.SetQuery("dbo.UP_PRODUCT_TYPE_UR_LST");

                if (boolDefault)
                {
                    pl_objSb.Append(MakeOption("0", "전체", objHtmlType));
                }

                while (pl_objDAS.Read())
                {
                    pl_objSb.Append(MakeOption(pl_objDAS.GetString("PRODUCTTYPECODE"), pl_objDAS.GetString("PRODUCTTYPEDESC"), objHtmlType));
                }
                pl_objDAS.CloseTable();
            }
            finally
            {
                if (pl_objDAS != null)
                {
                    pl_objDAS.Close();
                }
                pl_objDAS = null;
            }
            return(pl_objSb.ToString());
        }
Example #4
0
    public int InsPGPayLog(out string strErrMsg)
    {
        int    pl_intRetVal        = 0;
        string pl_strCashReceiptNo = string.Empty;
        IDas   pl_objDas           = null;

        strErrMsg = string.Empty;

        try
        {
            pl_objDas = new IDas();
            pl_objDas.Open(UserGlobal.BOQ_HOST_DAS);
            pl_objDas.CommandType = CommandType.StoredProcedure;
            pl_objDas.CodePage    = 0;

            pl_objDas.AddParam("@pi_intFamilyEventNo", DBType.adBigInt, pb_intEventNo, 0, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_intJoinMstCategory", DBType.adTinyInt, pb_intJoinMstCategory, 0, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_intJoinSubCategory", DBType.adTinyInt, pb_intJoinSubCategory, 0, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_intUserNo", DBType.adInteger, objSes.intUserNo, 0, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_intPayAmt", DBType.adDouble, pb_intPayAmt, 0, ParameterDirection.Input);

            pl_objDas.AddParam("@pi_strPGCode", DBType.adVarChar, pb_strPGCode, 50, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_intPayTool", DBType.adTinyInt, pb_intPaytool, 0, ParameterDirection.Input);
            pl_objDas.AddParam("@pi_strPayToolName", DBType.adVarChar, pb_strPaytoolName, 50, ParameterDirection.Input);
            pl_objDas.AddParam("@po_strErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
            pl_objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);

            pl_objDas.AddParam("@po_strDBErrMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
            pl_objDas.AddParam("@po_intDBRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
            pl_objDas.SetQuery("dbo.UP_PAYMENT_TX_INS");

            if (!pl_objDas.LastErrorCode.Equals(0))
            {
                pl_intRetVal = pl_objDas.LastErrorCode;
                strErrMsg    = pl_objDas.LastErrorMessage;
                return(pl_intRetVal);
            }

            strErrMsg    = pl_objDas.GetParam("@po_strErrMsg");
            pl_intRetVal = Convert.ToInt32(pl_objDas.GetParam("@po_intRetVal"));
            if (!pl_intRetVal.Equals(0))
            {
                return(pl_intRetVal);
            }
        }
        catch (Exception pl_objEx)
        {
            pl_intRetVal = -15705;
            strErrMsg    = pl_objEx.Message + pl_objEx.StackTrace;
            UtilLog.WriteExceptionLog(pl_objEx.Message, pl_objEx.StackTrace);
        }
        finally
        {
            if (pl_objDas != null)
            {
                pl_objDas.Close();
                pl_objDas = null;
            }
        }

        return(pl_intRetVal);
    }