| | |
| | | using System.Text; |
| | | using Model; |
| | | using Common; |
| | | using Oracle.DataAccess.Client; |
| | | using Oracle.ManagedDataAccess.Client; |
| | | using System.Data.Common; |
| | | |
| | | namespace Dao |
| | |
| | | builder.Append(" SELECT GEL.*, GWO.OP_NAME FROM GW_EVENT_LOG GEL "); |
| | | builder.Append(" LEFT JOIN GW_OP GWO ON GWO.OP_ID = GEL.OP_ID "); |
| | | builder.Append(" WHERE 1=1 "); |
| | | //builder.Append(" AND EVENT_TYPE = 'OPWARING' AND ASSIGNED_TO = 'WEB' "); |
| | | builder.Append(" AND EVENT_TYPE = 'OPWARING' AND ASSIGNED_TO = 'WEB' "); |
| | | builder.Append(permissionsSQL); |
| | | builder.Append(" ORDER BY HANDLE_FLAG, HANDLE_TIME DESC "); |
| | | |