학원관리 DB Point 관리 예제 소스

728x90

학원관리 DB Point 관리 예제 소스

 

PointList, PointInfo, PointInfos, InsertUpdatePointProgramInfo

 

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

                string strProc = "SP_PointProgram_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 PointInfo()
                    {
                        PointIdx = Convert.ToInt32(row["PointIdx"]),
                        Amount = Convert.ToInt32(row["Amount"]),
                        PointProgram = row["PointProgram"].ToString(),
                        UseTF = Convert.ToBoolean(row["UseTF"])
                    });
                }
            }
            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 PointInfo PointInfo(int idx)
        {
            PointInfo results = null;
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return results;

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

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

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

                foreach (DataRow row in tbl.Rows)
                {
                    results = new PointInfo()
                    {
                        PointIdx = Convert.ToInt32(row["PointIdx"]),
                        Amount = Convert.ToInt32(row["Amount"]),
                        PointProgram = row["PointProgram"].ToString(),
                        UseTF = Convert.ToBoolean(row["UseTF"])
                    };
                    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 List<PointInfo> PointInfos()
        {
            List<PointInfo> results = new List<PointInfo>();
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return results;

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

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@UseTF", true));

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

                foreach (DataRow row in tbl.Rows)
                {
                    results.Add(new PointInfo()
                    {
                        PointIdx = Convert.ToInt32(row["PointIdx"]),
                        Amount = Convert.ToInt32(row["Amount"]),
                        PointProgram = row["PointProgram"].ToString(),
                        UseTF = Convert.ToBoolean(row["UseTF"])
                    });
                    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 InsertUpdatePointProgramInfo(int pointIdx, string pointProgram, int amount, bool useTF)
        {
            int result = 0;
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

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

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@PointIdx", pointIdx));
                parameters.Add(new SqlParameter("@PointProgram", pointProgram));
                parameters.Add(new SqlParameter("@Amount", amount));
                parameters.Add(new SqlParameter("@UseTF", useTF));

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