Пример #1
0
        public List<Character> mfnCharacterSelect(string p_Code)
        {
            using (var context = new PARKEntities())
            {
                var characterQuery = from character in context.Character
                                     where character.Code == p_Code
                                     select character;

                return characterQuery.ToList();
            }
        }
Пример #2
0
        public List<InterviewComents> mfnComentsSelect(string p_DetailID)
        {
            using (var context = new PARKEntities())
            {
                var comentQuery = from coment in context.InterviewComents
                                  where coment.DetailID == p_DetailID
                                  select coment;

                return comentQuery.ToList();
            }
        }
Пример #3
0
        public List<InterviewDetail> mfnDetailSelect(string p_MasterID)
        {
            using (var context = new PARKEntities())
            {
                var DetailQuery = from detail in context.InterviewDetail
                                  where detail.MasterID == p_MasterID
                                  orderby detail.FlowNum
                                  select detail;

                return DetailQuery.ToList();
            }
        }
Пример #4
0
        /*===========================================================================================================*/
        // 조회
        /*===========================================================================================================*/
        public List<InterviewList> mfnListSelect()
        {
            using(var context = new PARKEntities())
            {
                var listQuery = from list in context.InterviewList
                            orderby list.SearchNum
                            select list;

                return listQuery.ToList();
            }
        }
Пример #5
0
 /// <summary>
 /// 10000Line_News 스토어드 프로시저 동작(데이터 추가 및 제거)
 /// </summary>
 /// <param name="p_WorkingTag"></param>
 /// <param name="p_Character"></param>
 /// <param name="p_ComentID"></param>
 /// <param name="p_Content"></param>
 /// <param name="p_DetailID"></param>
 /// <param name="p_FlowNum"></param>
 /// <param name="p_ID"></param>
 /// <param name="p_MasterID"></param>
 /// <param name="p_Position"></param>
 /// <param name="p_Title"></param>
 private void mfnSp10000Line_News(string p_WorkingTag,
                                  string p_Character,
                                  string p_ComentID, 
                                  string p_Content, 
                                  string p_DetailID,
                                  int?   p_FlowNum,
                                  string p_ID,
                                  string p_MasterID,
                                  string p_Position,
                                  string p_Title)
 {
     using(var context = new PARKEntities())
     {
         context.f10000Line_News(iWorkingTag: p_WorkingTag,
                                  iCharacter:  p_Character,
                                  iComentID:   p_ComentID,
                                  iContent:    p_Content,
                                  iDetailID:   p_DetailID,
                                  iFlowNum:    p_FlowNum,
                                  iID:         p_ID,
                                  iMasterID:   p_MasterID,
                                  iPosition:   p_Position,
                                  iTitle:      p_Title);
     }
 }