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