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