신용카드 내역 조회 및 관리하기 예제 소스

728x90

신용카드 내역 조회 및 관리하기 예제 소스

 

CreditcardList, CreditcardInfo, InsertUpdateCreditCard 

 

public static List<CreditcardInfo> CreditcardList()
        {
            List<CreditcardInfo> results = new List<CreditcardInfo>();
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return results;

                string strProc = "SP_CreditCard_Select";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();

                DataTable tbl = sql.ExecuteProcedure(strProc, parameters);
                if (tbl == null) return results;

                foreach (DataRow row in tbl.Rows)
                {
                    results.Add(new CreditcardInfo()
                    {
                        Idx = Convert.ToInt32(row["Idx"]),
                        CardName = row["CardName"].ToString(),
                        CardRate = Convert.ToInt32(row["CardRate"]),
                        PayCycle = Convert.ToInt32(row["PayCycle"])
                    });
                }
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return results;
        }

        public static CreditcardInfo CreditcardInfo(int idx)
        {
            CreditcardInfo results = null;
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return results;

                string strProc = "SP_CreditCard_Select";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@Idx", idx));

                DataTable tbl = sql.ExecuteProcedure(strProc, parameters);
                if (tbl == null) return results;

                foreach (DataRow row in tbl.Rows)
                {
                    results = new CreditcardInfo()
                    {
                        Idx = Convert.ToInt32(row["Idx"]),
                        CardName = row["CardName"].ToString(),
                        CardRate = Convert.ToInt32(row["CardRate"]),
                        PayCycle = Convert.ToInt32(row["PayCycle"])
                    };
                    break;
                }
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return results;
        }

        public static int InsertUpdateCreditCard(int idx, string cardName, int cardRate, int payCyle)
        {
            int result = 0;
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_CreditCard_Insert_Update";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@Idx", idx));
                parameters.Add(new SqlParameter("@CardName", cardName));
                parameters.Add(new SqlParameter("@CardRate", cardRate));
                parameters.Add(new SqlParameter("@PayCycle", payCyle));

                result = Convert.ToInt32(sql.ExecuteScalraProcedure(strProc, parameters));
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }