/// <summary>
/// 查询log日志
/// </summary>
/// <param name="getLoginfoParams"></param>
/// <returns></returns>
public DataSet GetLoginfo(GetLoginfoParams getLoginfoParams)
{
try
{
Log.Info("DalOPERATIONLOG->GetList---START");
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM T_OPERATIONLOG where 1=1");
strSql.Append(" and (F_USER_ID = :F_USER_ID OR :F_USER_ID IS NULL)");
strSql.Append(" and (to_char(F_DATE,'yyyy-MM-dd')>= :F_DATEBEGIN OR :F_DATEBEGIN IS NULL)");
strSql.Append(" and (to_char(F_DATE,'yyyy-MM-dd')<= :F_DATEEND OR :F_DATEEND IS NULL)");
OracleParameter[] parameters =
{
new OracleParameter(":F_USER_ID", OracleType.VarChar),
new OracleParameter(":F_DATEBEGIN", OracleType.VarChar),
new OracleParameter(":F_DATEEND", OracleType.VarChar),
};
parameters[0].Value = getLoginfoParams.UserId;
parameters[1].Value = getLoginfoParams.BeginDateTime;
parameters[2].Value = getLoginfoParams.EndDateTime;
return(Query(strSql.ToString(), parameters));
}
catch (Exception ex)
{
Log.Error("DalOPERATIONLOG->GetList---FAILED", ex);
throw ex;
}
}
/// <summary>
/// 查询log日志
/// </summary>
/// <param name="getLoginfoParams"></param>
/// <returns></returns>
public DataSet GetLoginfo(GetLoginfoParams getLoginfoParams)
{
try
{
Log.Info("BllOPERATIONLOG->GetLoginfo---START");
ConnectionOpen();
dal.SetDBAccess(GetDBAccess());
return(dal.GetLoginfo(getLoginfoParams));
}
catch (Exception ex)
{
Log.Error("BllOPERATIONLOG->GetLoginfo---FAILED", ex);
throw ex;
}
finally
{
ConnectionClose();
Log.Info("BllOPERATIONLOG->GetLoginfo---finally");
}
}
