DB PhotoSelect 관련 예제 소스

728x90

DB PhotoSelect 관련 예제 소스

 

MemberPhotoSelect, UserPhotoSelect, InsertUpdateMemberUserPhoto

 

public static DataTable MemberPhotoSelect(int memberKey)
        {
            DataTable result = new DataTable();
            try
            {
                SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
                try
                {
                    if (!sql.Connect()) return result;

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

                    List<SqlParameter> parameters = new List<SqlParameter>();
                    parameters.Add(new SqlParameter("@MemberKey", memberKey));

                    result = sql.ExecuteProcedure(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();
                }
            }
            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));
            }

            return result;
        }

        public static DataTable UserPhotoSelect(int UserKey)
        {
            DataTable result = new DataTable();
            try
            {
                SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
                try
                {
                    if (!sql.Connect()) return result;

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

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

                    result = sql.ExecuteProcedure(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();
                }
            }
            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));
            }

            return result;
        }

        public static void InsertUpdateMemberUserPhoto(int memberKey, int userKey, byte[] buffer)
        {
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return;

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

                List<SqlParameter> parameters = new List<SqlParameter>();
                if (memberKey > 0)
                    parameters.Add(new SqlParameter("@MemberKey", memberKey));
                else
                    parameters.Add(new SqlParameter("@UserKey", userKey));
                parameters.Add(new SqlParameter("@PhotoImage", buffer));

                sql.ExecuteNonProcedure(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();
            }
        }

        public static void DeleteMemberUserPhoto(int memberKey, int userKey)
        {
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return;

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

                List<SqlParameter> parameters = new List<SqlParameter>();
                if (memberKey > 0)
                    parameters.Add(new SqlParameter("@MemberKey", memberKey));
                else
                    parameters.Add(new SqlParameter("@UserKey", userKey));

                sql.ExecuteNonProcedure(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();
            }
        }