public PartialViewResult KeywordSynonymCombo(string name, T_KEYWORD_COND Cond, string selectedValue, string optionLabel, string htmlAttributes)
{
List <SelectListItem> combolist = new List <SelectListItem>();
Cond.PAGE = 1;
Cond.PAGE_COUNT = 100;
Cond.IS_SYNONYM = true;
IList <T_KEYWORD> list = new KeywordService().GetKeywordPageList(Cond);
if (list == null)
{
list = new List <T_KEYWORD>();
}
DROPDOWN_COND data = new DROPDOWN_COND
{
name = name
,
selectList = list.Select(s => new SelectListItem {
Value = s.KEYWORD_CODE.ToString(), Text = s.KEYWORD_NAME, Selected = true
}).ToList()
,
optionLabel = optionLabel
,
htmlAttributes = JsonConvert.DeserializeAnonymousType(htmlAttributes, new { @class = "", @style = "", @placeholder = "", @readonly = "", @multiple = "" })
};
return(PartialCombo(data));
}
public List <T_KEYWORD> GetKeywordPageList(T_KEYWORD_COND Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml", "GetKeywordPageList"
, Cond.PAGE_COUNT.ToString("10")
, Cond.PAGE.ToString("1")
, Cond.CATEGORY_CODE.ToString()
, Cond.SORT.ToString("A.KEYWORD_NAME")
, Cond.KEYWORD_CODE.ToString("")
, Cond.KEYWORD_TYPE.ToString("")
, Cond.BASE_CODE.ToString("")
, Cond.IS_SYNONYM == false ? "0 ": "1"
, Cond.KEYWORD_NAME.ToString("")
, Cond.STATUS == null ? "" : Cond.STATUS.ToString()
, (Cond.HIDE == null || Cond.HIDE == false ? "" : "1")
);
return(db.ExecuteQuery <T_KEYWORD>(sql).ToList());
}
public PartialViewResult pv_CategoryRegList2(T_KEYWORD_COND Cond)
{
ViewBag.TABLE_NAME = Cond.TABLE_NAME;
ViewBag.list = new KeywordService().GetKeywordPageList(Cond);
return(PartialView2());
}