public PartialViewResult CommonCombo(string name, T_COMMON_COND Param, string selectedValue, string optionLabel, string htmlAttributes) { List <SelectListItem> combolist = new List <SelectListItem>(); Param.NAME = ""; IList <T_COMMON> list = new ALT.BizService.CommonService().GetCommon(Param); if (list == null) { list = new List <T_COMMON>(); } DROPDOWN_COND data = new DROPDOWN_COND { name = name , selectList = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.NAME, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }).ToList() , optionLabel = optionLabel , htmlAttributes = JsonConvert.DeserializeAnonymousType(htmlAttributes, new { @class = "", @style = "", @placeholder = "", @readonly = "" }) }; return(PartialCombo(data)); }
public PartialViewResult PV_CommonRegList(T_COMMON_COND Cond) { if (!(SessionHelper.LoginInfo.STORE_CODE == 1 && SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH == 1)) { Cond.MAIN_CODE = "-1"; } ViewBag.list = new ALT.BizService.CommonService().GetCommonPageList(Cond); return(PartialView2()); }
/// <summary> /// 공통코드 가져오기 /// </summary> /// <param name="Param"></param> /// <returns></returns> public List <T_COMMON> GetCommon(T_COMMON_COND Param) { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Base\\Common.xml", "GetCommon" , Param.MAIN_CODE.ToString("") , Param.SUB_CODE.ToString("") , Param.REF_DATA1.ToString("") , Param.REF_DATA2.ToString("") , Param.REF_DATA3.ToString("") , Param.REF_DATA4.ToString("") , Param.HIDE == null ? "" : (Param.HIDE == false ? "0" : "1") ); return(db.ExecuteQuery <T_COMMON>(sql).ToList()); }
/// <summary> /// 공통코드 /// </summary> /// <param name="helper"></param> /// <param name="id"></param> /// <param name="Param"></param> /// <param name="selectedValue"></param> /// <param name="optionLabel"></param> /// <param name="htmlAttributes"></param> /// <returns></returns> public static MvcHtmlString CommonCombo(this HtmlHelper helper, string id, T_COMMON_COND Param, string selectedValue = null, string optionLabel = "-선택-", object htmlAttributes = null) { Param.HIDE = (Param.HIDE == null) ? false : Param.HIDE; IList <T_COMMON> list = new BaseService().GetCommon(Param); var combo = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.NAME, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }); var arrHtmlAtribute = SemanticUIHelper.SetDefaultSemanticSize(htmlAttributes, semaintic_size); string shtml = helper.DropDownList(id, combo, optionLabel, arrHtmlAtribute).ToHtmlString(); //shtml += "<script >$('document').ready(function () { try{ $('#" + id + "').prev().html($('#" + id + " option:selected').text()); } catch(e){} }); </script>"; return(new MvcHtmlString(shtml)); }
/// <summary> /// 공통코드 /// </summary> /// <param name="helper"></param> /// <param name="id"></param> /// <param name="Param"></param> /// <param name="selectedValue"></param> /// <param name="optionLabel"></param> /// <param name="htmlAttributes"></param> /// <returns></returns> public static MvcHtmlString CommonCombo(this HtmlHelper helper, string id, T_COMMON_COND Param, string selectedValue = null, string optionLabel = "-선택-", object htmlAttributes = null, enComboDisType enComboDisType = enComboDisType.NAME) { /***ID가 STATUS인경우 selected에 문제가 발생함(PartialView을 Ajax호출할 경우 발생함) ****/ optionLabel = optionLabel ?? "-선택-"; if (optionLabel == "-1*") { optionLabel = null; } Param.HIDE = (Param.HIDE == null) ? false : Param.HIDE; IList <T_COMMON> list = new CommonService().GetCommon(Param); var arrHtmlAtribute = SemanticUIHelper.SetDefaultSemanticSize(htmlAttributes, semaintic_size); IEnumerable <SelectListItem> combo = new List <SelectListItem>(); switch (enComboDisType) { case enComboDisType.REF_DATA1: combo = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.REF_DATA1, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }).ToList(); break; case enComboDisType.REF_DATA2: combo = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.REF_DATA2, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }).ToList(); break; case enComboDisType.REF_DATA3: combo = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.REF_DATA3, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }).ToList(); break; default: combo = list.Select(s => new SelectListItem { Value = s.SUB_CODE.ToString(), Text = s.NAME, Selected = (selectedValue == s.SUB_CODE.ToString()) ? true : false }).ToList(); break; } string shtml = helper.DropDownList(id, combo, optionLabel, arrHtmlAtribute).ToHtmlString(); //shtml += "<script >$('document').ready(function () { try{ $('#" + id + "').prev().html($('#" + id + " option:selected').text()); } catch(e){} }); </script>"; return(new MvcHtmlString(shtml)); }
/// <summary> /// 공통코드 가져오기 /// </summary> /// <param name="Param"></param> /// <returns></returns> public List <T_COMMON> GetCommonPageList(T_COMMON_COND Param) { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\Common.xml", "GetCommonPageList" , Param.PAGE.ToString("1") , Param.PAGE_COUNT.ToString("10") , Param.SORT.ToString("A.MAIN_CODE") , Param.MAIN_CODE.ToString("") , Param.SUB_CODE.ToString("") , Param.NAME.ToString("") , Param.REF_DATA1.ToString("") , Param.REF_DATA2.ToString("") , Param.REF_DATA3.ToString("") , Param.REF_DATA4.ToString("") , Param.HIDE == null ? "" : (Param.HIDE == false ? "0" : "1") , Param.ADD_COND ); return(db.ExecuteQuery <T_COMMON>(sql).ToList()); }
public ActionResult CommonExcelReport(T_COMMON_COND Cond) { List <string> headers = new List <string>() { "그룹코드", "상세코드", "순번", "참조코드1", "참조코드2", "참조코드3", "참조코드4", "사용여부", "등록자", "등록시간", "수정자", "수정시간" }; return(new ALT.BizService.CommonService().GetCommon(Cond).Select(s => new { MAIN_CODE = s.MAIN_CODE , SUB_CODE = s.SUB_CODE , ORDER_SEQ = s.ORDER_SEQ , REF_DATA1 = s.REF_DATA1 , REF_DATA2 = s.REF_DATA2 , REF_DATA3 = s.REF_DATA3 , REF_DATA4 = s.REF_DATA4 , HIDE = (s.HIDE == null || s.HIDE == false) ? "미사용" : "사용" , INSERT_NAME = s.INSERT_NAME , UPDATE_NAME = s.UPDATE_NAME , UPDATE_DATE = s.UPDATE_DATE }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers)); }
public static MvcHtmlString Semantic_ButtonList(this HtmlHelper helper, string id, T_COMMON_COND Cond) { var list = new CommonService().GetCommon(Cond); StringBuilder sbHtml = new StringBuilder(); sbHtml.Append("\n").Append(" <div class='ui buttons ").Append(Cond.color.ToString("")).Append(" list' style='width:100%; cursor:pointer'> "); foreach (T_COMMON data in list) { sbHtml.Append("\n").Append(" <button class='ui button ").Append(id); if (data.SUB_CODE.ToString("") == Cond.selectedValue.ToString("")) { sbHtml.Append(" active"); Cond.selectedValue = data.SUB_CODE.ToString(""); } sbHtml.Append("' type='button' value='").Append(data.SUB_CODE).Append("'>").Append(data.NAME).Append("</button> "); } sbHtml.Append("<input type='hidden' id='").Append(id).Append("' value='").Append(Cond.selectedValue.ToString("")).Append("' />"); sbHtml.Append("\n").Append(" </div> "); sbHtml.Append("\n").Append(" <script type=\"text/javascript\"> "); sbHtml.Append("\n").Append(" $(\"document\").ready(function(){ "); sbHtml.Append("\n").Append(" $(\".").Append(id).Append("\").click(function(){ "); sbHtml.Append("\n").Append(" $(\".").Append(id).Append("\").removeClass(\"active\"); "); sbHtml.Append("\n").Append(" $(this).addClass(\"active\"); "); sbHtml.Append("\n").Append(" $(\"#").Append(id).Append("\").val( $(\".").Append(id).Append(".active\").attr(\"value\")); "); sbHtml.Append("\n").Append(" try{ ").Append(id).Append("_Callback( $(\".").Append(id).Append(".active\").attr(\"value\")); }catch(e){}"); sbHtml.Append("\n").Append(" }); "); sbHtml.Append("\n").Append(" }); "); sbHtml.Append("\n").Append(" </script> "); return(MvcHtmlString.Create(sbHtml.ToString().Trim())); }