public List <EMPLOYEE_P_DATA> GetEmployeePopupList(SEARCH_COND Param)
{
try
{
Param.SEARCH_DATA1 = Param.SEARCH_DATA1.ToString("");
if (!string.IsNullOrEmpty(Param.SEARCH_DATA1))
{
Param.SEARCH_DATA1 = " AND " + Param.SEARCH_DATA1 + " LIKE N'%" + Param.SEARCH_DATA.ToString("") + "%'";
}
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Member\\T_MEMBER_EMPLOYEE.xml", "GetEmployeePopupList"
, Param.PAGE_COUNT.ToString("10")
, Param.PAGE.ToString("1")
, Param.SORT.ToString("D.USER_NAME")
, Param.SEARCH_DATA.ToString("")
, Param.SEARCH_DATA1
, Param.SEARCH_DATA2.ToString("")
, Param.SEARCH_DATA3.ToString("")
);
return(db.ExecuteQuery <EMPLOYEE_P_DATA>(sql).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult getEmployeePList(SEARCH_COND Cond)
{
var rtn = new EmployeeService().GetEmployeePopupList(Cond);
return(new JsonResult {
Data = rtn
});
}
public PartialViewResult PV_EmployeePList(SEARCH_COND Cond)
{
if (SessionHelper.LoginInfo.STORE_CODE == 1)
{
}
else if (SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4)
{
Cond.SEARCH_DATA2 = SessionHelper.LoginInfo.STORE.COMPANY_CODE.ToString("");
}
else
{
Cond.SEARCH_DATA3 = SessionHelper.LoginInfo.STORE_CODE.ToString("");
}
ViewBag.list = new EmployeeService().GetEmployeePopupList(Cond);
return(PartialView2());
}
public PartialViewResult pv_AdOnDevicelist2(SEARCH_COND Cond)
{
#region >> 권한 주석처리
//if (SessionHelper.LoginInfo.STORE_CODE != 1 || !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
//{
// Cond.SEARCH_DATA3 = SessionHelper.LoginInfo.COMPANY_CODE.ToString("");
//}
//if (SessionHelper.LoginInfo.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
//{
// Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.STORE_CODE.ToString("");
//}
//if (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH != null)
//{
// switch (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH)
// {
// case 2: /*상위부서권한*/
// Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
// Cond.SEARCH_DATA5 = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH.ToString("");
// break;
// case 3:/*부서권한*/
// Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
// Cond.SEARCH_DATA6 = SessionHelper.LoginInfo.EMPLOYEE.DEPT_CODE.ToString("");
// break;
// case 8:/*상급자권한*/
// Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
// Cond.SEARCH_DATA7 = SessionHelper.LoginInfo.EMPLOYEE.MEMBER_CODE.ToString();
// break;
// case 9:/*본인권한*/
// Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
// Cond.SEARCH_DATA8 = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE.ToString();
// break;
// }
//}
#endregion
ViewBag.AD_FRAME_TYPE = Cond.SEARCH_DATA11;
ViewBag.list = new AdvertisingService().GetAdOnDeviceList2(Cond);
return(PartialView2());
}
public PartialViewResult pv_AdOnDevicelist2(SEARCH_COND Cond)
{
if (SessionHelper.LoginInfo.STORE_CODE != 1 || !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.SEARCH_DATA3 = SessionHelper.LoginInfo.COMPANY_CODE.ToString("");
}
if (SessionHelper.LoginInfo.STORE_CODE != 1 && !(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.STORE_CODE.ToString("");
}
if (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH != null)
{
switch (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH)
{
case 2: /*상위부서권한*/
Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
Cond.SEARCH_DATA5 = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH.ToString("");
break;
case 3: /*부서권한*/
Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
Cond.SEARCH_DATA6 = SessionHelper.LoginInfo.EMPLOYEE.DEPT_CODE.ToString("");
break;
case 8: /*상급자권한*/
Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
Cond.SEARCH_DATA7 = SessionHelper.LoginInfo.EMPLOYEE.MEMBER_CODE.ToString();
break;
case 9: /*본인권한*/
Cond.SEARCH_DATA4 = SessionHelper.LoginInfo.EMPLOYEE.STORE_CODE.ToString("");
Cond.SEARCH_DATA8 = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE.ToString();
break;
}
}
ViewBag.list = new AdvertisingService().GetAdOnDeviceList2(Cond);
return(PartialView2());
}
public static extern uint SIRIUS_SearchModelFaceByPic(uint UserID, string szPicPath, ref SEARCH_COND pSearchCond);
public static extern uint SIRIUS_FindMatchFace(uint UserID, ref SEARCH_COND pSearchCond, IntPtr pMatchFaceList, ref int pItemNum, ref int pTotalNum);
