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