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();
}
}
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();
}
}
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();
}
}
/*===========================================================================================================*/
// 조회
/*===========================================================================================================*/
public List<InterviewList> mfnListSelect()
{
using(var context = new PARKEntities())
{
var listQuery = from list in context.InterviewList
orderby list.SearchNum
select list;
return listQuery.ToList();
}
}
/// <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);
}
}
