public PartialViewResult StoreDeptCombo(string name, T_STORE_DEPT Param, string selectedValue, string optionLabel, string htmlAttributes) { Param.STORE_CODE = Param.STORE_CODE == null ? -1 : Param.STORE_CODE; List <SelectListItem> combolist = new List <SelectListItem>(); IList <T_STORE_DEPT> list = new ALT.BizService.CommonService().GetDept(Param); if (list == null) { list = new List <T_STORE_DEPT>(); } DROPDOWN_COND data = new DROPDOWN_COND { name = name , selectList = list.Select(s => new SelectListItem { Value = s.DEPT_CODE.ToString(), Text = s.DEPT_NAME, Selected = (selectedValue == s.DEPT_CODE.ToString()) ? true : false }).ToList() , optionLabel = optionLabel , htmlAttributes = JsonConvert.DeserializeAnonymousType(htmlAttributes, new { @class = "", @style = "", @placeholder = "", @readonly = "" }) }; return(PartialCombo(data)); }
/// <summary> /// 부서조회 /// </summary> /// <param name="list"></param> /// <returns></returns> public List <T_STORE_DEPT> GetDept(T_STORE_DEPT Cond) { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Basic\\T_STORE_DEPT.xml", "GetDeptList" , Cond.STORE_CODE.ToString("0") , Cond.DEPT_CODE.ToString("") , Cond.DEPT_NAME.ToString("") , Cond.HIDE == null ? "" : (Cond.HIDE == false ? "0" : "1") ); return(db.ExecuteQuery <T_STORE_DEPT>(sql).ToList()); }
public IList <T_STORE_DEPT> GetStoreDept(T_STORE_DEPT param) { try { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Employee\\Employee.xml", "GetStoreDept" , param.PARENT_DEPT_CODE.ToString("") ); return(db.ExecuteQuery <T_STORE_DEPT>(sql.ToString()).ToList()); } catch (Exception ex) { logger.Debug("EmployeeService >> GetStoreDept : " + ex.Message); return(null); } }
public IList <T_STORE_DEPT> GetStoreDept(T_STORE_DEPT param) { try { string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER_EMPLOYEE.xml", "GetStoreDept" , param.STORE_CODE.ToString("") , param.PARENT_DEPT_CODE.ToString("") ); return(db.ExecuteQuery <T_STORE_DEPT>(sql).ToList()); } catch (Exception ex) { logger.Debug("EmployeeService >> GetStoreDept : " + ex.Message); return(new List <T_STORE_DEPT>()); } }
public ActionResult StoreDeptExcelReport(T_STORE_DEPT Cond) { List <string> headers = new List <string>() { "코드", "부서명", "상위부서", "미사용", "레벨", "수정자", "수정시간" }; return(new CommonService().GetDept(Cond).Select(s => new { DEPT_SEARCH = s.DEPT_SEARCH , DEPT_NAME = s.DEPT_NAME , PARENT_DEPT_NAME = s.PARENT_DEPT_NAME , HIDE = s.HIDE_NAME , LEVEL = s.LEVEL , UPDATE_NAME = s.UPDATE_NAME , UPDATE_DATE = s.UPDATE_DATE }).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers)); }
public PartialViewResult pv_StoreDeptRegList(T_STORE_DEPT Cond) { Cond.HIDE = null; ViewBag.list = new CommonService().GetDept(Cond); return(PartialView2()); }