public List <T_LOG> GetLogList(T_LOG_COND Cond)
{
try
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "BizService\\Common\\T_LOG.xml", "GetLogList"
, Cond.PAGE.ToString("1")
, Cond.PAGE_COUNT.ToString("15")
, Cond.SORT_ORDER.ToString("A.IDX DESC")
, Cond.COMPANY_CODE.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.DEPT_SEARCH.ToString("")
, Cond.PARENT_MEMBER_CODE.ToString("")
, Cond.LOGIN_MEMBER_CODE.ToString("")
, Cond.FR_DATE.ToString("").ToFormatDate("yyyyMMdd")
, Cond.TO_DATE.ToString("").ToFormatDate("yyyyMMdd")
, Cond.LOG_TYPE.ToString("")
, Cond.LOG_DATA1.ToString("")
, Cond.LOG_DATA2.ToString("")
// , Cond.LOG_DESC.ToString("")
, Cond.INSERT_NAME.ToString("")
);
return(db.ExecuteQuery <T_LOG>(sql).ToList());
}
catch (Exception ex)
{
logger.Debug("CommonService >> GetLogList : " + ex.Message);
return(null);
}
}
public PartialViewResult PV_LogList(T_LOG_COND Cond)
{
if (SessionHelper.LoginInfo.COMPANY_CODE != 1)
{
Cond.COMPANY_CODE = SessionHelper.LoginInfo.COMPANY_CODE;
}
if (!(SessionHelper.LoginInfo.STORE.STORE_TYPE == 1 || SessionHelper.LoginInfo.STORE.STORE_TYPE == 4))
{
Cond.STORE_CODE = SessionHelper.LoginInfo.STORE_CODE;
}
switch (SessionHelper.LoginInfo.EMPLOYEE.EMP_AUTH)
{
case 2: /*상급부서*/
Cond.DEPT_SEARCH = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH + "%";
break;
case 3: /*상급부서*/
Cond.DEPT_SEARCH = SessionHelper.LoginInfo.EMPLOYEE.DEPT_SEARCH;
break;
case 8: /*상급자*/
Cond.PARENT_MEMBER_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE;
break;
case 9: /*본인*/
Cond.LOGIN_MEMBER_CODE = SessionHelper.LoginInfo.MEMBER.MEMBER_CODE;
break;
}
ViewBag.list = Service.commoneService.GetLogList(Cond);
return(PartialView2());
}
