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