/// <summary>
/// 광고또는 로컬박스별별 키워드 조회하기
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public IList <CODE_DATA> GetAdDeviceSearchKeyword(CATEGORY_KEYWORD_COND Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\SearchKeyword.xml", "GetAdDeviceSearchKeyword"
, Cond.AD_CODE.ToString("")
, Cond.DEVICE_CODE.ToString("")
, Cond.KEYWORD_TYPE.ToString("")
);
return(db.ExecuteQuery <CODE_DATA>(sql).ToList());
}
/// <summary>
/// 카테고리키워드 조회(CODE = KEYWORDWORD_CODE로 바인딩)
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public IList <CODE_DATA> GetCategoryKeywordList2(CATEGORY_KEYWORD_COND Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml", "GetCategoryKeywordList2"
, Cond.CATEGORY_CODE.ToString("")
, Cond.SEARCH_CATEGORY_CODE.ToString("")
, Cond.CATEGORY_TYPE.ToString("2")
, Cond.LEVEL_DEPTH.ToString("1")
, Cond.KEYWORD_TYPE.ToString("2")
);
return(db.ExecuteQuery <CODE_DATA>(sql).ToList());
}
public void SearchKeywordDelete(CATEGORY_KEYWORD_COND Cond, ref DataContext _db)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\SearchKeyword.xml", "SearchKeywordDelete"
, Cond.AD_CODE.ToString("")
, Cond.DEVICE_CODE.ToString("")
, Cond.CK_CODE.ToString("")
, Cond.KEYWORD_CODE.ToString("")
, Cond.KEYWORD_NAME.ToString("")
, Cond.KEYWORD_TYPE.ToString("")
);
if (_db != null)
{
_db.ExecuteCommand(sql);
}
else
{
db.ExecuteCommand(sql);
}
}
public PartialViewResult CategoryKeywordCombo(string name, CATEGORY_KEYWORD_COND Cond, string selectedValue, string optionLabel, string htmlAttributes)
{
List <SelectListItem> combolist = new List <SelectListItem>();
IList <CODE_DATA> list = new KeywordService().GetCategoryKeywordList2(Cond);
if (list == null)
{
list = new List <CODE_DATA>();
}
DROPDOWN_COND data = new DROPDOWN_COND
{
name = name
,
selectList = list.Select(s => new SelectListItem {
Value = s.CODE.ToString(), Text = s.NAME, Selected = true
}).ToList()
,
optionLabel = optionLabel
,
htmlAttributes = JsonConvert.DeserializeAnonymousType(htmlAttributes, new { @class = "", @style = "", @placeholder = "", @readonly = "", @multiple = "" })
};
return(PartialCombo(data));
}
public IList <CODE_DATA> GetCategoryKeywordList([FromBody] CATEGORY_KEYWORD_COND Cond)
{
return(new KeywordService().GetCategoryKeywordList(Cond));
}
