private void BindData() { EapLog entity = new EapLog(); if (cboLogType.SelectedIndex != -1) { entity.LOG_TYPE = Convert.ToInt32(((EapItem)(cboLogType.SelectedItem)).ID); } else { entity.LOG_TYPE = -1; } entity.OPERATE_NOTE = txtOperateNote.Text.Trim(); entity.OPERATE_USER = txtOperateUser.Text.Trim(); entity.BEGIN_TIME = dtpBeginTime.Value; entity.END_TIME = dtpEndTime.Value; int icnt; List <EapLog> list = Bll.GetBll().QueryEapLog(entity, page.PageNo, page.PageSize, out icnt); page.RecordCount = icnt; dgv.DataSource = list; }
/// <summary> /// 查询日志数据 /// </summary> /// <param name="query_entity">查询条件实体</param> /// <param name="pageno">要查询的页</param> /// <param name="pagesize">页大小</param> /// <param name="icnt">结果记录条数</param> /// <returns>值列表数据清单</returns> internal List<EapLog> QueryEapLog(EapLog query_entity, int pno, int psize, out int icnt) { int para_count = 2; StringBuilder sql = new StringBuilder(); sql.Append("select t.LOG_ID,t.LOG_TYPE,t1.VLIST_DETAIL_NAME as LOG_TYPE_NAME,t.OPERATE_NOTE,t2.USER_NAME as OPERATE_USER,t.OPERATE_TIME from T_EAP_LOG t"); sql.Append(" left join T_EAP_VALUE_LIST_DETAIL t1 on t1.VLIST_DETAIL_VALUE=t.LOG_TYPE"); sql.Append(" left join T_EAP_USER t2 on t.OPERATE_USER=t2.USER_ID"); sql.Append(" where t1.VLIST_ID='log_type'"); sql.Append(" and to_char(t.OPERATE_TIME,'YYYYMMDD')>=to_char(:BEGIN_TIME,'YYYYMMDD')"); sql.Append(" and to_char(t.OPERATE_TIME,'YYYYMMDD')<=to_char(:END_TIME,'YYYYMMDD')"); if (query_entity.LOG_TYPE != -1) { sql.Append(" and t.LOG_TYPE=:LOG_TYPE"); para_count++; } if (query_entity.OPERATE_NOTE !=string.Empty) { sql.Append(" and t.OPERATE_NOTE like '%'||:OPERATE_NOTE||'%'"); para_count++; } if (query_entity.OPERATE_USER != string.Empty) { sql.Append(" and t.OPERATE_USER like '%'||:OPERATE_USER||'%'"); para_count++; } sql.Append(" order by t.LOG_ID desc"); OracleParameter[] para = new OracleParameter[para_count]; para[0] = new OracleParameter(":BEGIN_TIME", OracleType.DateTime); para[0].Value = query_entity.BEGIN_TIME; para[1] = new OracleParameter(":END_TIME", OracleType.DateTime); para[1].Value = query_entity.END_TIME; for (int i = 2; i < para_count; i++) { if (query_entity.LOG_TYPE != -1) { para[i] = new OracleParameter(":LOG_TYPE", OracleType.Number); para[i].Value = query_entity.LOG_TYPE; query_entity.LOG_TYPE = -1; continue; } if (query_entity.OPERATE_NOTE != string.Empty) { para[i] = new OracleParameter(":OPERATE_NOTE", OracleType.VarChar); para[i].Value = query_entity.OPERATE_NOTE; query_entity.OPERATE_NOTE = string.Empty; continue; } if (query_entity.OPERATE_USER != string.Empty) { para[i] = new OracleParameter(":OPERATE_USER", OracleType.VarChar); para[i].Value = query_entity.OPERATE_USER; query_entity.OPERATE_USER = string.Empty; continue; } } return Oracle.GetOracle().QueryToPage<EapLog>(sql, para, pno, psize, out icnt); }
/// <summary> /// 查询日志数据 /// </summary> /// <param name="query_entity">查询条件实体</param> /// <param name="pageno">要查询的页</param> /// <param name="pagesize">页大小</param> /// <param name="icnt">结果记录条数</param> /// <returns>值列表数据清单</returns> internal List <EapLog> QueryEapLog(EapLog query_entity, int pno, int psize, out int icnt) { if (Config.GetConfig().DB_TYPE == "1") { return(DalOracle.GetDalOracle().QueryEapLog(query_entity, pno, psize, out icnt)); } icnt = 0; return(null); }