コード例 #1
0
        public string TestConnect()
        {
            List <string> arrResult = new List <string>();

            // List<Dictionary<string, string>> arrResult2 = new List<Dictionary<string, string>>();

            using (imrEntities entities = new imrEntities())
            {
                var ptInfo = from b in entities.PatientInfo
                             orderby b.PT_NO
                             select b;

                foreach (var item in ptInfo)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new PT_INFO()
                    {
                        PT_NM = item.PT_NM,
                        PT_NO = int.Parse(item.PT_NO)
                    }
                                                                  ))
                                  );
                }
            }
            //arrResult.ToArray();
            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #2
0
        /// <summary>
        /// 사용자 로그인
        /// </summary>
        /// <param name="sUsrId"></param>
        /// <param name="sUsrPw"></param>
        /// <returns></returns>
        public string S_CO_USR_LGN_SIN(string USER_NO, string USER_PW)
        {
            List <string> arrResult = new List <string>();

            // List<Dictionary<string, string>> arrResult2 = new List<Dictionary<string, string>>();

            using (imrEntities entities = new imrEntities())
            {
                var userInfo = from b in entities.OTUSINFO
                               where b.USER_NO == USER_NO
                               where b.USER_PW == USER_PW
                               where b.USE_YN == "Y"
                               select b;

                foreach (var item in userInfo)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_CO_USR_LGN_SIN()
                    {
                        USER_NM           = item.USER_NM,
                        USER_NO           = item.USER_NO,
                        USER_NICK         = item.USER_NICK_NM,
                        USER_BIRTH        = item.USER_BIRTH.ToString(),
                        USER_GROUP        = item.USER_GROUP,
                        USER_MAIL_ADDRESS = item.USER_MAIL_ADDRESS,
                        USER_PHONE        = item.USER_PHONE,
                        SUCCESS_DOC       = "성공",
                        SUCCESS_YN        = "Y"
                    }
                                                                  ))
                                  );
                }

                if (arrResult.Count != 1)
                {
                    arrResult.Clear();
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_CO_USR_LGN_SIN()
                    {
                        USER_NM           = "",
                        USER_NO           = "",
                        USER_NICK         = "",
                        USER_BIRTH        = "",
                        USER_GROUP        = "",
                        USER_MAIL_ADDRESS = "",
                        USER_PHONE        = "",
                        SUCCESS_DOC       = "실패",
                        SUCCESS_YN        = "N"
                    }
                                                                  ))
                                  );
                }
            }
            //arrResult.ToArray();
            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #3
0
        /// <summary>
        /// 리뷰 데이터 삭제(업데이트)
        /// </summary>
        /// <param name="sContentID"></param>
        /// <param name="sReviewSeq"></param>
        /// <param name="sUserID"></param>
        /// <returns></returns>
        public string U_MA_USR_REV_SIN(string CONS_ID, string REV_SEQ, string USER_NO)
        {
            List <string> arrResult = new List <string>();

            using (imrEntities entities = new imrEntities())
            {
                try
                {
                    int reviewSeq  = int.Parse(REV_SEQ);
                    var UpdateData = entities.OTCSREVW.Where(a => a.CONS_ID == CONS_ID &&
                                                             a.REV_SEQ == reviewSeq &&
                                                             a.USER_NO == USER_NO).SingleOrDefault();

                    if (UpdateData != null)
                    {
                        UpdateData.USE_YN = "N";
                        entities.SaveChanges();
                        arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                      new ErrorReturn()
                        {
                            ERROR_YN = "N"
                            ,
                            ERROR_DOC = "성공"
                        }
                                                                      )));
                    }
                    else
                    {
                        arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                      new ErrorReturn()
                        {
                            ERROR_YN = "N"
                            ,
                            ERROR_DOC = "업데이트할 데이터가 없습니다."
                        }
                                                                      )));
                    }
                }
                catch (Exception ex)
                {
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN = "N"
                        ,
                        ERROR_DOC = "데이터 업데이트에 실패하였습니다. err message: " + ex.Message
                    }
                                                                  )));
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #4
0
        /// <summary>
        /// 찜 목록 데이터 삭제
        /// </summary>
        /// <param name="sContentID"></param>
        /// <param name="sUserID"></param>
        /// <returns></returns>
        public string D_MA_USR_FAV_SIN(string CONS_ID, string USER_NO)
        {
            List <string> arrResult = new List <string>();

            using (imrEntities entities = new imrEntities())
            {
                try
                {
                    var DeleteData = entities.OTUSMYLT.Where(a => a.CONS_ID == CONS_ID && a.USER_NO == USER_NO).SingleOrDefault();

                    if (DeleteData != null)
                    {
                        entities.OTUSMYLT.Remove(DeleteData);
                        entities.SaveChanges();
                        arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                      new ErrorReturn()
                        {
                            ERROR_YN = "N"
                            ,
                            ERROR_DOC = "성공"
                        }
                                                                      )));
                    }
                    else
                    {
                        arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                      new ErrorReturn()
                        {
                            ERROR_YN = "Y"
                            ,
                            ERROR_DOC = "삭제할 데이터가 없습니다."
                        }
                                                                      )));
                    }
                }
                catch (Exception ex)
                {
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN = "Y"
                        ,
                        ERROR_DOC = "데이터 삭제에 실패하였습니다. err message: " + ex.Message
                    }
                                                                  )));
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #5
0
        /// <summary>
        /// 리뷰 입력 작업중
        /// </summary>
        /// <param name="USER_NO"></param>
        /// <param name="CONS_ID"></param>
        /// <param name="REV_DOC"></param>
        /// <param name="CONS_ST"></param>
        /// <returns></returns>
        public string I_MA_USR_REV_SIN(string USER_NO, string CONS_ID, string REV_DOC, string CONS_ST)
        {
            List <string> arrResult = new List <string>();

            using (imrEntities entities = new imrEntities())
            {
                try
                {
                    OTCSREVW reviewData = new OTCSREVW
                    {
                        USER_NO  = USER_NO,
                        CONS_ID  = CONS_ID,
                        REV_DOC  = REV_DOC,
                        CONS_ST  = CONS_ST,
                        REV_DTM  = DateTime.Now,
                        CONS_SEQ = entities.OTCSINFO.Where(a => a.CONS_ID == CONS_ID && a.USE_YN == "Y").SingleOrDefault().CONS_SEQ,
                        REV_SEQ  = entities.OTCSREVW.Where(a => a.CONS_ID == CONS_ID && a.USE_YN == "Y").Count() + 1,
                        USE_YN   = "Y"
                    };

                    entities.OTCSREVW.Add(reviewData);
                    entities.SaveChanges();

                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN  = "N",
                        ERROR_DOC = "성공"
                    }
                                                                  )));
                }
                catch (Exception ex)
                {
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN  = "Y",
                        ERROR_DOC = "데이터 입력에 실패하였습니다. err message: " + ex.Message
                    }
                                                                  )));
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #6
0
        /// <summary>
        /// 구매내역 리스트 입력
        /// </summary>
        /// <param name="USER_NO"></param>
        /// <param name="CONS_ID"></param>
        /// <returns></returns>
        public string I_MA_USR_PRCH_SIN(string USER_NO, string CONS_ID)
        {
            List <string> arrResult = new List <string>();

            using (imrEntities entities = new imrEntities())
            {
                try
                {
                    OTUSCSLT purchaseData = new OTUSCSLT
                    {
                        USER_NO      = USER_NO,
                        CONS_ID      = CONS_ID,
                        CONS_BUY_DTM = DateTime.Now,
                        CONS_SEQ     = entities.OTUSCSLT.Count()
                    };

                    entities.OTUSCSLT.Add(purchaseData);
                    entities.SaveChanges();

                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN = "N"
                        ,
                        ERROR_DOC = "성공"
                    }
                                                                  )));
                }
                catch (Exception ex)
                {
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new ErrorReturn()
                    {
                        ERROR_YN = "Y"
                        ,
                        ERROR_DOC = "데이터 입력에 실패하였습니다. err message: " + ex.Message
                    }
                                                                  )));
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #7
0
        /// <summary>
        /// 리뷰 리스트 조회
        /// </summary>
        /// <param name="USER_NO"></param>
        /// <returns></returns>
        public string S_MA_USR_REV_LIST(string USER_NO)
        {
            List <string> arrResult = new List <string>();

            // List<Dictionary<string, string>> arrResult2 = new List<Dictionary<string, string>>();

            using (imrEntities entities = new imrEntities())
            {
                var revInfo = from b in entities.OTCSREVW
                              from c in entities.OTCSINFO

                              where b.USER_NO == USER_NO &&
                              b.CONS_ID == c.CONS_ID

                              select new
                {
                    CONS_ID         = b.CONS_ID,
                    CONS_NM         = c.CONS_NM,
                    CONS_THUMB_PATH = entities.OTCSSCRE.Where(a => a.CONS_ID == b.CONS_ID).FirstOrDefault().CONS_THUMB,
                    CONS_TP         = entities.MTCOTPCD.Where(a => a.CO_CD_DTL == c.CONS_TP_CD && a.USE_YN == "Y").FirstOrDefault().CO_CD_DOC,
                    REV_DTM         = b.REV_DTM
                };

                foreach (var item in revInfo)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_MA_USR_REV_LIST()
                    {
                        CONS_ID         = item.CONS_ID,
                        CONS_NM         = item.CONS_NM,
                        CONS_THUMB_PATH = Convert.ToBase64String(ImageToByteArray(item.CONS_THUMB_PATH)),
                        CONS_TP         = item.CONS_TP,
                        REV_DTM         = item.REV_DTM.Value.ToString("yyyyMMdd HH:mm:ss")
                    }
                                                                  ))
                                  );
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #8
0
        /// <summary>
        /// 컨텐츠 리뷰 리스트 조회
        /// </summary>
        /// <param name="CONS_ID"></param>
        /// <returns></returns>
        public string S_CV_CTS_REV_LIST(string CONS_ID)
        {
            List <string> arrResult = new List <string>();

            // List<Dictionary<string, string>> arrResult2 = new List<Dictionary<string, string>>();

            using (imrEntities entities = new imrEntities())
            {
                var revInfo = from b in entities.OTCSINFO
                              from c in entities.OTCSREVW

                              where b.CONS_ID == CONS_ID &&
                              b.CONS_ID == c.CONS_ID

                              select new
                {
                    USER_NO = c.USER_NO
                    ,
                    CONS_ID = b.CONS_ID
                    ,
                    REV_SEQ = c.REV_SEQ
                    ,
                    REV_DOC = c.REV_DOC
                    ,
                    REV_DTM = c.REV_DTM
                    ,
                    STAR_RATE = c.CONS_ST
                    ,
                    USER_NM = entities.OTUSINFO.Where(a => a.USER_NO == c.USER_NO && a.USE_YN == "Y").FirstOrDefault().USER_NM
                    ,
                    USER_NICK = entities.OTUSINFO.Where(a => a.USER_NO == c.USER_NO && a.USE_YN == "Y").FirstOrDefault().USER_NICK_NM
                };

                foreach (var item in revInfo)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_CV_CTS_REV_LIST()
                    {
                        USER_NO = item.USER_NO
                        ,
                        CONS_ID = item.CONS_ID
                        ,
                        REV_SEQ = item.REV_SEQ.ToString()
                        ,
                        REV_DOC = item.REV_DOC
                        ,
                        REV_DTM = item.REV_DTM.Value.ToString("yyyyMMdd HH:mm:ss")
                        ,
                        STAR_RATE = item.STAR_RATE
                        ,
                        USER_NM = item.USER_NM
                        ,
                        USER_NICK = item.USER_NICK
                    }
                                                                  ))
                                  );
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #9
0
        /// <summary>
        /// 컨텐츠 메인뷰 정보 조회
        /// </summary>
        /// <param name="CONS_ID"></param>
        /// <returns></returns>
        public string S_CV_CTS_INFO_SIN(string CONS_ID)
        {
            List <string> arrResult = new List <string>();

            // List<Dictionary<string, string>> arrResult2 = new List<Dictionary<string, string>>();

            using (imrEntities entities = new imrEntities())
            {
                var conInfo = from c in entities.OTCSINFO
                              from d in entities.OTADCOPY

                              where c.CONS_ID == CONS_ID &&
                              c.CONS_COPY_CD == d.CONS_COPY_CD

                              select new
                {
                    CONS_ID         = c.CONS_ID,
                    CONS_NM         = c.CONS_NM,
                    CONS_PREV_PATH  = entities.OTCSSCRE.Where(a => a.CONS_ID == c.CONS_ID).FirstOrDefault().CONS_PREV_PATH,
                    CONS_THUMB_PATH = entities.OTCSSCRE.Where(a => a.CONS_ID == c.CONS_ID).FirstOrDefault().CONS_THUMB,
                    STAR_RATE       = (from e in entities.OTCSREVW
                                       where e.CONS_ID == c.CONS_ID &&
                                       e.USE_YN == "Y"
                                       select e).Count().ToString(),
                    CONS_PRICE        = c.CON_PRICE,
                    COPY_DOC          = entities.MTCOTPCD.Where(a => a.CO_CD_DTL == c.CONS_COPY_CD && a.USE_YN == "Y").FirstOrDefault().CO_CD_DOC,
                    CONS_SIZE         = c.CONS_SIZE,
                    CONS_DOC          = c.CONS_DOC,
                    COPY_NM           = d.COPY_NM,
                    COPY_PHONE        = d.COPY_PHONE,
                    COPY_MAIL_ADDRESS = d.COPY_MAIL,
                    COPY_HOME_PAGE    = d.COPY_HOMEPAGE,
                    CONS_TP           = entities.MTCOTPCD.Where(a => a.CO_CD_DTL == c.CONS_TP_CD && a.USE_YN == "Y").FirstOrDefault().CO_CD_DOC,
                    CONS_CAT          = entities.MTCOTPCD.Where(a => a.CO_CD_DTL == c.CONS_CT_CD && a.USE_YN == "Y").FirstOrDefault().CO_CD_DOC,
                    CONS_PATH         = c.CONS_PATH
                };

                foreach (var item in conInfo)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_CV_CTS_INFO_SIN()
                    {
                        CONS_ID           = item.CONS_ID,
                        CONS_NM           = item.CONS_NM,
                        CONS_PREV_PATH    = Convert.ToBase64String(CompressFolder(item.CONS_PREV_PATH)),
                        CONS_THUMB_PATH   = Convert.ToBase64String(ImageToByteArray(item.CONS_THUMB_PATH)),
                        STAR_RATE         = item.STAR_RATE,
                        CONS_PRICE        = item.CONS_PRICE.ToString(),
                        COPY_DOC          = item.COPY_DOC,
                        CONS_SIZE         = item.CONS_SIZE.ToString(),
                        CONS_DOC          = item.CONS_DOC,
                        COPY_NM           = item.COPY_NM,
                        COPY_PHONE        = item.COPY_PHONE,
                        COPY_MAIL_ADDRESS = item.COPY_MAIL_ADDRESS,
                        COPY_HOME_PAGE    = item.COPY_HOME_PAGE,
                        CONS_TP           = item.CONS_TP,
                        CONS_CAT          = item.CONS_CAT,
                        CONS_PATH         = item.CONS_PATH
                    }
                                                                  ))
                                  );
                }
            }

            return(StaticUtils.ListToXml(arrResult));
        }
コード例 #10
0
        /// <summary>
        /// 컨텐츠 리스트 조회, 검색
        /// </summary>
        /// <param name="PAGE_NO">페이징 숫자</param>
        /// <param name="SEARCH_WORD">검색 할 컨텐츠 이름, 빈값 : 전체 조회</param>
        /// <param name="CATEGORY">검색 할 컨텐츠 카테고리, 빈값 : 전체 조회</param>
        /// <returns></returns>
        public string S_MA_CTS_SRCH_LIST(string PAGE_NO, string SEARCH_WORD, string CATEGORY)
        {
            int           nPageNo   = int.Parse(PAGE_NO);
            List <string> arrResult = new List <string>();

            // 페이징 최대 조회 갯수
            int nMaxPage = 30;


            using (imrEntities entities = new imrEntities())
            {
                var downloadRate = from download in entities.OTUSCSLT
                                   from b in entities.OTCSINFO
                                   where b.CONS_NM.Contains(SEARCH_WORD) &&
                                   download.CONS_ID == b.CONS_ID
                                   select download;



                var starRate = from star in entities.OTCSREVW
                               from b in entities.OTCSINFO
                               where b.CONS_NM.Contains(SEARCH_WORD) &&
                               star.CONS_ID == b.CONS_ID
                               select star;
                int starSum = 0;
                foreach (var starItem in starRate)
                {
                    if (null != starItem.CONS_ST)
                    {
                        starSum += int.Parse(starItem.CONS_ST);
                    }
                }

                int downCount = downloadRate.Count <OTUSCSLT>();
                int starAvg   = 0;
                if (starRate.Count <OTCSREVW>() > 0)
                {
                    starAvg = starSum / starRate.Count <OTCSREVW>();
                }
                else
                {
                    starAvg = 0;
                }

                var contentsInfo = from b in entities.OTCSINFO
                                   from c in entities.OTADCOPY
                                   from master in entities.MTCOTPCD
                                   from master2 in entities.MTCOTPCD
                                   from f in entities.OTCSSCRE
                                   where b.USE_YN == "Y" &&
                                   master.USE_YN == b.USE_YN &&
                                   master.CO_CD_DTL == b.CONS_TP_CD &&
                                   master2.USE_YN == b.USE_YN &&
                                   master2.CO_CD_DTL == b.CONS_CT_CD &&
                                   b.CONS_COPY_CD == c.CONS_COPY_CD &&
                                   b.CONS_ID == f.CONS_ID &&
                                   b.CONS_CT_CD.Contains(CATEGORY) &&
                                   b.CONS_NM.Contains(SEARCH_WORD)
                                   orderby b.CONS_SEQ descending
                                   select new
                {
                    CONS_ID         = b.CONS_ID,
                    CONS_TP         = master.CO_CD_DOC,
                    CONS_CT         = master2.CO_CD_DOC,
                    CONS_DOC        = b.CONS_DOC,
                    CONS_NM         = b.CONS_NM,
                    COPY_NM         = c.COPY_NM,
                    CONS_PRICE      = b.CON_PRICE,
                    STAR_RATE       = starAvg.ToString(),
                    DOWN_RATE       = downCount.ToString(),
                    CONS_THUMB_PATH = f.CONS_THUMB
                };


                var result = contentsInfo.Skip((nPageNo - 1) * nMaxPage).Take(nMaxPage);

                foreach (var item in result)
                {
                    //뭔가 정렬 굉장히 맘에 안드는데..
                    arrResult.Add(StaticUtils.DictionaryToXml(StaticUtils.GetDictionaryFieldValue(
                                                                  new S_MA_CTS_SRCH_LIST()
                    {
                        CONS_ID         = item.CONS_ID,
                        CONS_NM         = item.CONS_NM,
                        CONS_DOC        = item.CONS_DOC,
                        CONS_CT         = item.CONS_CT,
                        CONS_PRICE      = item.CONS_PRICE.ToString(),
                        CONS_THUMB_PATH = Convert.ToBase64String(ImageToByteArray(item.CONS_THUMB_PATH)),
                        CONS_TP         = item.CONS_TP,
                        COPY_NM         = item.COPY_NM,
                        DOWN_RATE       = item.DOWN_RATE,
                        STAR_RATE       = item.STAR_RATE
                    }
                                                                  ))
                                  );
                }
            }
            //arrResult.ToArray();
            return(StaticUtils.ListToXml(arrResult));
        }