/// <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)); }