private SqlCeParameter[] GetParameters(Common.Search.DateRange range)
{
if (range == null)
{
return(null);
}
return(GetDateRangeParameters(range));
}
public List <LogEntryVO> Find(Common.Search.DateRange range, OperationVO operation, UserVO user)
{
SqlCeParameter[] parameters = GetParameters(range);
string condition = GetCondition(range, operation, user);
string statement = SqlStatememtGenerator.Select_ReadAllColumnsByCondition(tableName, condition);
SqlCeDataReader reader = executer.ExecuteSelectStatement(statement, parameters);
return(ReadAllRecords(reader));
}
private SqlCeParameter[] GetDateRangeParameters(Common.Search.DateRange range)
{
SqlCeParameter[] result =
{
MakeSqlParameter(startParam, range.Start, System.Data.SqlDbType.DateTime),
MakeSqlParameter(endParam, range.End, System.Data.SqlDbType.DateTime)
};
return(result);
}
public List <DocumentVO> FindByFileArchivingDate(Common.Search.DateRange range)
{
FileDAO dao = new FileDAO();
List <FileVO> files = dao.FindFilesByArchivingDate(range);
dao.CloseConnection();
NoRepeatList <DocumentVO> result = new NoRepeatList <DocumentVO>();
foreach (FileVO file in files)
{
result.AddDistinct(file.Document);
}
FullLoadList(result);
return(result);
}
private string GetCondition(Common.Search.DateRange range, OperationVO operation, UserVO user)
{
StringBuilder builder = new StringBuilder();
bool rangeB = false;
bool operationB = false;
if (range != null)
{
builder.Append(GetDateRangeCondition());
rangeB = true;
}
if (operation != null)
{
if (rangeB)
{
builder.Append(" AND ");
}
builder.Append(GetOperationCondition(operation));
operationB = true;
}
if (user != null)
{
if (rangeB || operationB)
{
builder.Append(" AND ");
}
builder.Append(GetUserCondition(user));
}
if (builder.Length == 0)
{
return("1 = 1");
}
return(builder.ToString());
}
public List <DocumentVO> FindByLastModificationDate(Common.Search.DateRange range)
{
return(FindByDateRangeColumn(range, documentLastEditDate));
}
public List <DocumentVO> FindByCreationDate(Common.Search.DateRange range)
{
return(FindByDateRangeColumn(range, documentCreationDate));
}
